COMP 0832: Introduction to Spreadsheets
Effective date
January 2017
Department
College & Career Access
Description
This course covers the basic skills needed to produce reports that involve numbers and calculations. Students learn how to enter and edit text and numeric data; enter calculating formulas and statistical functions; format numbers and text to produce clear, accurate and attractive printouts, and create simple charts to show relationships between numeric data.
Year of study
Grade 11 Equivalency
Prerequisites
Introduction to Windows (COMP 0735) or equivalent; Grade 9 English or equivalent (English 041, CLB 6, or ESL Upper Advanced).
Course Learning Outcomes
Upon successful completion of this course, students will be able to:
- Describe the purpose and layout of a spreadsheet application.
- Select cells.
- Enter and edit data.
- Perform calculations.
- Format cells.
- Copy and move cell contents.
- Use functions in formulas.
- Print a worksheet.
- Create simple charts.
Prior Learning Assessment & Recognition (PLAR)
None
Hours
Clinical, Lab, Rehearsal, Shop, Kitchen, Simulation, Studio: 96
Practicum, Self-Paced, Individual Learning: 96
Total Hours: 96
Instructional Strategies
Self-paced.
Classroom instruction.
Moodle.
Grading System
Satisfactory/Unsatisfactory
Evaluation Plan
Type
|
Percentage
|
Assessment activity
|
Assignments
|
30
|
|
Project
|
35
|
|
Final Exam
|
35
|
|
Course topics
- Purpose and layout of spreadsheet application
- Select cells
- Enter and edit data
- Perform calculations
- Format cells
- Copy and move cell contents
- Use functions in formulas
- Print a worksheet
- Create simple charts
Notes:
- Course contents and descriptions, offerings and schedules are subject to change without notice.
- Students are required to follow all College policies including ones that govern their educational experience at VCC. Policies are available on the VCC website at:
https://www.vcc.ca/about/governance--policies/policies/.
- To find out if there are existing transfer agreements for this course, visit the BC Transfer Guide at https://www.bctransferguide.ca.