This course is not active. Please contact Department Chair for more information.
This course has been discontinued. Please contact Department Chair for more information.
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
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.
The learner has reliably demonstrated the ability to:
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.
Course Guidelines for previous years are viewable by selecting the version desired. If you took this course and do not see a listing for the starting semester / year of the course, consider the previous version as the applicable version.
|Institution||Transfer Details||Effective Dates|
|Langara College (LANG)||DOUG OADM 1222 (3) & DOUG OADM 1239 (3) = LANG FMGT 2308 (3); DOUG OADM 1222 (3) & DOUG OADM 1339 (3) = LANG FMGT 2308 (3)||2009/09/01 to 2017/12/31|