This course is a continuation from BIM180 and introduces the advanced features and integration capabilities of Microsoft Office 2021. This course consists of five modules—Word, Excel, PowerPoint, Access, and Integration.
Prerequisites
BIM180 and BUS102
Quarters Offered
Fall,
Winter,
Spring,
Summer
Course Outcomes
Upon successful completion of the course, students should be able to demonstrate the following knowledge or skills:
- Design, create, format, and edit complex Word documents
- Design, create, format, and edit complex Excel spreadsheets and charts
- Design, create, format, and edit complex PowerPoint presentations
- Design, create, format, and edit complex Access databases
- Design, create, format, and edit an integrated project encompassing advanced MS Office features.
Institutional Outcomes
IO2 Quantitative Reasoning: Students will be able to reason mathematically using methods appropriate to the profession
Course Content Outline
- Word – a variety of complex documents, mailings, and advanced formatting features
- Excel – advanced spreadsheet functions, table management, formulas, and data analysis/validation
- PowerPoint – advanced tools, master slides, links, graphics, objects, media, and customization features
- Access – data analysis using complex relational databases, queries, calculations, forms, and reports
- Integration – assimilation of advanced presentations using linked and embedded Office applications
Department Guidelines
The syllabus must contain evaluation/grading guidelines, class environment/expectations/rules, course learning outcomes, and a disability services statement. A schedule must be provided to students that contains content covered (text chapters, topics, etc.), tentative test dates (to include final date/time). If an LMS or similar site is used for the course, it must be created following the Quality Matters (QM) principals outlined in the QM workbook questions. These documents should be reviewed with the BIM instructor at least two weeks prior to class start.