BMD120 – Spreadsheets
Course Description
This course introduces students to spreadsheets and to Microsoft Excel. Spreadsheets teaches students how to work with different types of documents using a variety of core and intermediate features to create and edit professional-looking spreadsheets for a variety of purposes and situations. It helps to develop skills in creating and manipulating highly functional spreadsheets. This course has no other course prerequisites.
Instructional Methods
Instructor facilitated student-paced instruction, offered full-time on-campus or online with the identical curriculum, completion requirements and credentials received for both delivery methods.
Learning Objectives
Upon completion of this course, the successful student will have demonstrated or be able to:
- Identify the difference between workbooks and worksheets
- Create and edit formulas
- Learn about cell references as well as mathematical operators
- Review charts and chart elements
- Demonstrate filtering and sorting functions
- Learn conditional formatting and other workbook functions
Assessment Methods
Student progress is monitored weekly through attendance and assessments. A final exam is conducted at the end of the course for each program. Marks are allocated for class examinations only. Minimum pass mark is 60%. Grades will be assigned as follows:
| 95-100 | A+ |
| 89-94 | A |
| 80-88 | B+ |
| 70-79 | B |
| 60-69 | C |
| 00-59 | F |
| Incomplete | Student is in a course that has not yet ended. |
| Withdrawn | Student withdrew or was dismissed from the course. |
Assessments and Weighting
| Assignments | 90% |
| Attendance | 10% |
| Total | 100% |