vcc.ca
OADM 1106: Excel
Effective date
May 2020
Department
Admin Professional 1 & 2
School
Hospitality, Food Studies and Applied Business
Description
This course provides an introduction to spreadsheets and their use. Spreadsheets are used to develop accounting concepts and to show graphical changes due to financial management. This course also covers database management using Excel tables, along with sorting and filtering of record data.
Credits
2.5
Year of study
1st Year Post-secondary
Prerequisites
None
Corequisites
None
Course Learning Outcomes
Upon successful completion of this course, students will be able to:
- Create and manage multiple worksheets and workbooks
- Build, copy, and manage a variety of simple and complex formulas using appropriate arithmetic operators and built-in functions
- Identify and use cell referencing including ranges and relative and absolute references
- Apply professional formatting to increase worksheet legibility and enhance worksheet interpretation with conditional formatting
- Print value worksheets, formula worksheets, and charts in a variety of layouts
- Create and enhance a variety of charts based on worksheet data
- Perform simple and complex sorts on worksheets and tables, and use the IF function to logically calculate conditional outcomes
Prior Learning Assessment & Recognition (PLAR)
None
Hours
Lecture, Online, Seminar, Tutorial: 20
Clinical, Lab, Rehearsal, Shop, Kitchen, Simulation, Studio: 28
Total Hours: 48
Clinical, Lab, Rehearsal, Shop, Kitchen, Simulation, Studio: 28
Total Hours: 48
Instructional Strategies
This course uses lectures and demonstrations to help students achieve the learning outcomes in an interactive manner. In addition, the instructor will use assignments and exams to help students apply the course material and identify strengths and weaknesses of their knowledge gained in the course.
Grading System
Letter Grade (A-F)
Passing grade
D
Evaluation Plan
|
Type |
Percentage |
Assessment activity |
|
Assignments |
30% |
Formulas and formatting (10%), Charts (5%), IF functions (5%), Sorting & filtering (5%), 3-D formulas (5%) |
|
Participation |
10% |
|
|
Midterm Exam |
30% |
|
|
Final Exam |
30% |
|
Course topics
- Working with formulas and functions
- Formatting a worksheet
- Creating charts and graphics
- Sorting and filtering data
- Working with multiple workbooks and worksheets
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.