Following a lecture format, part of the course content will be presented by way of explanation, demonstration and guided practice. Following a seminar format, some content will be presented as situational problems that require individual and group consideration, discussion and resolution.
Module 1 – Review of Basic Arithmetic and Introduction to a 10-key Calculator
1.1 Review addition and subtraction
1.2 Estimate answers in addition/subtraction
1.3 Perform addition and subtraction using a 10-key calculator
Module 2 – Multiplication and Division
2.1 Solve multiplication and division problems without a calculator
2.2 Solve multiplication and division problems with a 10-key calculator
2.3 Estimate answers in multiplication and division
Module 3 – Special Functions – 10 key Calculator
3.1 Solve problems involving accumulative multiplication and division
3.2 Convert fractions to decimals
3.3 Convert percents to decimals and fractions
3.4 Calculate the percentage, rate and base
3.5 Solve problems involving percent of increase or decrease
3.6 Solve problems involving constants
Module 4 – Essential Business Applications
4.1 Calculate commissions
4.2 Calculate simple interest
4.3 Calculate cash and trade discounts
4.4 Calculate markon and markdown
4.5 Prorate expenses
4.6 Calculate ratios and proportions
Module 5 – Spreadsheets
5.1 Solve problems involving the PMT, FV, AVERAGE, MAX, MIN, IF, AND, OR, VLOOKUP, HLOOKUP, IFERROR, COUNTIF, SUMIF and AVERAGEIF functions
5.2 Work with large spreadsheets--freeze panes, hide rows/columns
5.3 Use relative, absolute and mixed references
5.4 Create, format and filter a spreadsheet table
5.5 Create, filter and sort a PivotTable and related PivotChart
5.6 Link cells in multiple worksheets
5.7 Link workbooks
5.8 Use conditional formatting
5.9 Create amortization schedules
5.10 Use defined names in formulas
5.11 Create validation rules for data entry
5.12 Protect contents of worksheets and workbooks and create an application
5.13 Create and run a macro
The learner has reliably demonstrated the ability to:
- perform arithmetic calculations manually;
- solve a variety of business problems using a 10-key calculator;
- solve a variety of business problems using spreadsheet software;
- exhibit a high standard of behaviour with respect to attendance, punctuality, positive attitude and respect for others.
| Assignments | 20% |
| Test #1 | 25% |
| Test #2 | 25% |
| Test #3 | 30% |
| Total | 100% |
Textbooks and materials to be purchased by students
Merchant, Ronald. Basic Business Math and Electronic Calculators. Latest Edition. Star Publishing Inc.
Parsons, June Jamrich, Oja, Dan, Ageloff, Roy and Patrick Carey. New Perspectives on Microsoft Excel, Introductory. Latest Edition. Nelson Education: Course Technology Cengage Learning.
Skills Assessment Manager (SAM), Latest Ed., Nelson Education: Course Technology Cengage Learning.
Or other textbooks and online assessment tools as approved by the department.
(Any Math 11 with a minimum grade “C” standing OR DVST 0210 OR 7 on AS4 OR placement at DVST 0310)