vcc.ca
MGMT 1015: Applied Quantitative Skills
Effective date
May 2022
Department
Bus & Project Mgmt PD Diploma
School
Hospitality, Food Studies and Applied Business
Description
This course introduces students to the basics of arithmetic and financial mathematics. A basic understanding of statistics will also be developed during this course. Students learn how to use MS Excel to analyze, manage, and present data in different formats.
Credits
3.0
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:
- Perform basic arithmetic functions and solve basic algebraic equations
- Apply ratios, proportions, and percent
- Understand the concepts of central tendency and dispersion
- Apply financial mathematics (Time value of money)
- Recognize the concepts of data, information, and reports
- Practice break-even analysis both graphically and algebraically
- Utilize different data collection methods in quantitative and qualitative approaches
- Leverage MS Excel to create meaningful charts, graphs, and dashboards
- Utilize MS Excel capabilities as a tool in project management
Prior Learning Assessment & Recognition (PLAR)
None
Hours
Lecture, Online, Seminar, Tutorial: 45
Total Hours: 45
Total Hours: 45
Instructional Strategies
Lecture, teamwork, case studies, discussions, presentations, guest speakers, online activities
Grading System
Letter Grade (A-F)
Passing grade
D
Evaluation Plan
|
Type |
Percentage |
Assessment activity |
|
Midterm Exam |
20 |
|
|
Final Exam |
30 |
|
|
Project |
10 |
End of term project |
|
Assignments |
20 |
Team and individual assignments and projects defined by the instructor |
|
Quizzes/Tests |
20 |
Weekly planned or ad-hoc quizzes and tests |
Course topics
- Basic arithmetic and algebra skills
- Ratios, proportions, and percent
- Time value of money
- Concepts of central tendency and measures of dispersion
- Break-even analysis
- Data, information, reports
- Qualitative and quantitative approaches
- Using Excel to create tables, pivot tables, dashboards
- Conditional formatting and formulas in Excel
Learning resources
Learning Resources (textbooks, lab/shop manuals, equipment, etc.):
MS-Excel
MS-Excel
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.