BUS 0250. Microsoft Applications for Business
Units: 3
Formerly known as IT 10
Hours: 72 (54 lecture, 18 laboratory)
An overview of business and academic use of software for word processing, spreadsheets, charting data, databases, and presentations. Using Microsoft software, managing files, using online tools, transmitting files via the Internet. Common computer hardware and software system concepts; impact of computers on society, networks and security. Course will use Microsoft Office 365 (2019 or higher) applications of Word, Excel, and PowerPoint. (CSU)
BUS 0250 - Computer Applications for Business
http://catalog.sierracollege.edu/course-outlines/bus-0250/
Catalog Description Formerly known as IT 10 Hours: 72 (54 lecture, 18 laboratory) Description: An overview of business and academic use of software for word processing, spreadsheets, charting data, databases, and presentations. Using Microsoft software, managing files, using online tools, transmitting files via the Internet. Common computer hardware and software system concepts; impact of computers on society, networks and security. Course will use Microsoft Office 365 (2019 or higher) applications of Word, Excel, and PowerPoint. (CSU) Course Student Learning Outcomes CSLO #1: Research, analyze and evaluate information to solve business problems using office computer application programs. CSLO #2: Design and produce office computer application program solutions incorporating current trends, security, and best practices. CSLO #3: Employ office computer application programs concepts and terminology in professional communication. CSLO #4: Demonstrate marketable office computer application program career skills. Effective Term Fall 2025 Course Type Credit - Degree-applicable Contact Hours 72 Outside of Class Hours 90 Total Student Learning Hours 162 Course Objectives Lecture Objectives: 1. Design/plan, critique, and identify improvements to text documents such as flyers, reports, resumes, and letters, including positioning graphics, setting tab stops, creating columns, mail merge and constructing/formatting tables using word processing software; 2. Design/plan, critique, and identify improvements to spreadsheets with formulas, relative cell addressing, functions and charts using spreadsheet software; 3. Explore database concepts and objects including tables, forms, reports and queries; 4. Differentiate and apply common computer user hardware and software system concepts, including networking and security; 5. Assess the impact of computers on society, such as: e-commerce and ethical issues; 6. Critique, and identify techniques to use the operating system, and managing files and folders; 7. Design/plan, critique, and identify improvements to presentations including graphics and animation using presentation software; and 8. Design/plan, critique, and identify improvements to integrated projects including copying, inserting, merging, and importing data and objects from one application into another; and Laboratory Objectives: 1. Design/build, construct, and modify documents such as flyers, reports and letters, including positioning graphics and setting tab stops, using word processing software; 2. Design/build, construct, and modify spreadsheets with formulas, relative cell addressing, functions, and charts using spreadsheet software; 3. Use web browser to upload and download files, study computer-based training, utilize course management system; 4. Design/build, construct, and edit presentations including graphics using presentation software; and 5. Design/build, construct, edit application integration projects by copying, inserting, merging, and importing data and objects from one application into another. General Education Information Approved College Associate Degree GE Applicability CSU GE Applicability (Recommended-requires CSU approval) Cal-GETC Applicability (Recommended - Requires External Approval) IGETC Applicability (Recommended-requires CSU/UC approval) Articulation Information CSU Transferable Methods of Evaluation Classroom Discussions Example: Example question for Lecture objective 2, students design/plan, critique, and identify improvements to spreadsheets with formulas, relative cell addressing, functions and charts using spreadsheet software. Describe at least 4 key characteristics of an effective chart. Instructors score based on accuracy and completeness Objective Examinations Example: Example questions for Lecture objective 2, students design/plan, critique, and identify improvements to spreadsheets with formulas, relative cell addressing, functions and charts using spreadsheet software. An Excel workbook sheet that contains only a chart is referred to as: ____________. The chart type that displays the relationship of parts to a whole is a _______________ chart. Problem Solving Examinations Example: A comprehensive final exam may be offered through the learning system from a textbook publisher. The students are presented with simulated computer screens and asked to perform skills such as: 1. Enter a formula to solve a particular computation in a spreadsheet cell. 2. Move a folder to a specific location. Projects Example: Project for Lab objective 2, students design/build, construct, and modify spreadsheets with formulas, relative cell addressing, functions and charts using spreadsheet software by completing assignments which include computer projects for each of several chapters. For example: Provided with a start file, students are asked to enter in formulas and create effective charts. Scored based on accuracy and completeness using rubric. Skill Demonstrations Example: Skill Demonstration for Lab objective 6, students design, construct, and edit presentations including graphics and animation using presentation software. For Example PowerPoint presentation: students apply the skills learned in the textbook and course lecture to create a new presentation following the instructions/requirements page provided. Instructors score based on accuracy and completeness using rubric. Repeatable No Methods of Instruction Laboratory Lecture/Discussion Distance Learning Lab: Instructor has students do selected projects: discussing and collaborating in class and completing for homework. For example, part of the Excel Charting project requires students to critique provided charts and make improvements. The projects require students to read directions, discuss and think about how to apply the software features to satisfy the requirements of the project, execute the project, proofread, determine how to correct errors and revise their work to turn in. Lecture: Instructor lectures, demonstrates and leads students in guided practice and experimentation with the software. For example: the students follow along as instructor demonstrates steps to create and modify charts and explains appropriate use of various features. The instructor pauses frequently to allow for students to explore and experiment with features such as chart layouts, chart types, switching rows/columns, changing colors, adding titles. Instructor highlights reasons to use or not use various software features. For example: it is important to use titles to thoroughly define the data charted. It is undesirable to use 3D graphical rendering because even though it may appear "cool", it distorts the precision of chart. The instructor may ask students to respond to questions on a graded or ungraded discussion board, on a quiz. Example questions: An Excel workbook sheet that contains only a chart is referred to as: ____________. The chart type that displays the relationship of parts to a whole is a _______________ chart. Distance Learning The instructor will conduct and online lecture on computers in society followed by students using discussion board to outline the impact of computers on society, such as: e-commerce and ethical issues. Students are to post their outlines and comment on a minimum of five other student posts'. Obj. Typical Out of Class Assignments Reading Assignments Students are assigned to read/study textbook chapters. Students complete computer projects; instructions are provided to students in writing and require careful reading. Example: 1. Read and study first MS Word Chapter in the textbook. Study the end of chapter questions. Complete related simulated tasks to reinforce skills. 2. Read project requirements and complete the "Impact of Computers on Society" Newsletter project; making sure to include each item listed in the directions. Writing, Problem Solving or Performance Students complete computer projects. Example: 1. Following the written directions provided, use Word to create a properly formatted business letter. 2. Following the written directions provided, create a file/folder organization for this course. 3. Following the written directions provided, use Excel to create a worksheet for computing your grade in BUS 0250. Construct it so that you will be able to add future assignments, keep track of your grade and predict your final course grade. Other (Term projects, research papers, portfolios, etc.) 1.. Create your own presentation -Choose an appropriate topic that interests you to present to the class -Create a NEW presentation; do not recycle from a previous class -Create a presentation with 8-12 slides -Create a Title slide -Use at least 3 different standard slide layouts – ok to modify slightly -Font size: large enough to be read from back of classroom -Use at least 2 different bullet styles -Insert a photo from the Web related to your topic with the source credited (Google is not a source) -Create a summary slide -Spell check and proofread: accuracy, consistent formatting, capitalization and punctuation Required Materials Microsoft Office 365: A Skills Approach Author: Manning Publisher: McGraw Hill Publication Date: 2023 Text Edition: 2021 Edition, 1st Edition Classic Textbook?: No OER Link: OER: Other materials and-or supplies required of students that contribute to the cost of the course. Microsoft Office 365 (2019 version or higher) - Word, Excel, and PowerPoint. Computer based training access code bundled with textbook or etext.
Information Technology
http://catalog.sierracollege.edu/departments/infotech/
...Required Courses: Course List Code Title Units BUS 0250 Microsoft Applications for Business 3 IT...
