BIM 190B: Spreadsheets I

Credits 2 Lab Hours 44

This course is an in-depth introduction to Microsoft Excel. The focus is to learn functions of Excel, to apply this knowledge to business situations, and to begin preparing students for the MOS (Microsoft Office Specialist) Expert certification exam. This class teaches to and requires the most current version of Microsoft Office for Windows.

Prerequisites

Successful completion of MATH 094 or MAP 117 or BBCC Placement Exam into MATH 098 or higher and successful completion of BIM 190A or corequisite of BIM 190A

Quarters Offered
Spring
Course Outcomes

Upon successful completion of the course, students should be able to demonstrate the following knowledge or skills:

  1. Automating worksheet tasks
  2. Advanced worksheet management
  3. Advanced formulas and functions
  4. Performing What-If Analysis
Course Content Outline
  1. Automating Worksheet Tasks
  2. Advanced Worksheet Management
  3. Advanced Formulas and Functions
  4. Performing What-If Analysis
Department Guidelines

PO5        Students will develop proficient Microsoft Office techniques by creating professional business documents while meeting an 85% competency level

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.