vcc.ca
COMP 0984: Spreadsheet Management 12
Effective date
January 2017
Department
College & Career Access
School
Arts and Sciences
Description
This course provides students with the knowledge and skills needed to use advanced spreadsheet data entry and formatting techniques. Students apply statistical, financial and decision-making functions, cell protection and data validation. Students create macros to automate worksheet management.
Completion of 2 of the following courses is required for completion of ABE Provincial Level Computer Studies: COMP 0982, COMP 0984, COMP 0985.
COMP 0982, 0984 and 0985 may be taken in any order.
Credits
4.0
Year of study
Grade 12 Equivalency
Prerequisites
Grade 10 English or equivalent.
Corequisites
None
Course Learning Outcomes
Upon successful completion of this course, students will be able to:
- Students will meet the learning outcomes for ABE Provincial Level Computer Studies (Spreadsheet Management) as stated in the most recent ABE Articulation Handbook.
Prior Learning Assessment & Recognition (PLAR)
None
Hours
Clinical, Lab, Rehearsal, Shop, Kitchen, Simulation, Studio: 96
Practicum, Self-Paced, Individual Learning: 96
Total Hours: 96
Practicum, Self-Paced, Individual Learning: 96
Total Hours: 96
Instructional Strategies
Self-paced - one-to-one individualized instruction
Grading System
Letter Grade (A-F)
Passing grade
D
Evaluation Plan
|
Type |
Percentage |
Assessment activity |
|
Project |
10 |
Formulas, functions, charts |
|
Project |
10 |
Manage and analyze data |
|
Exam |
20 |
Functions, formatting, charts |
|
Exam |
20 |
Styles, If, vlookup |
|
Exam |
20 |
Solver, validation, protection |
|
Exam |
20 |
Database functions, data & Pivot tables, macros |
Course topics
- Advanced data entry techniques. Worksheet functions and formulas. Advanced charts .
- Reports.
- Data analysis.
- Macros.
- Customized spreadsheets.
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.