BIM 190A: Spreadsheets I

Credits 3 Lab Hours 66

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.

Quarters Offered
Winter,
Spring
Course Outcomes

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

  1. Developing and formatting of worksheets
  2. Analyzing data using formulas
  3. Working with Charts and tables
  4. Managing Workbook data
  5. working with images and integrating other programs
  6. Analyzing data and PivotTables 
Course Content Outline
  1. Getting Started with Excel
  2. Formatting a Worksheet
  3. Analyzing Data Using Formulas
  4. Working with Charts
  5. Working with Tables
  6. Managing Workbook Data
  7. Working with Images and Integrating with Other Programs
  8. Analyzing Data with PivotTables
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.