Spreadsheets and Business Calculations

Curriculum guideline

Effective Date:
Return to Course
Print Guideline
Course
OADM 1222
Discontinued
No
Course code
OADM 1222
Descriptive
Spreadsheets and Business Calculations
Department
Office Administration
Faculty
Commerce & Business Administration
Credits
3.00
Start date
End term
201430
PLAR
Yes
Semester length
15 Weeks x 4 Hours per Week = 60 Hours
Max class size
30
Contact hours
Lecture: 3 Hours Seminar: 1 Hour Total: 4 Hours
Method(s) of instruction
Lecture
Seminar
Learning activities

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.

Course description
This course will introduce students to a variety of business problems requiring mathematical solutions. The solutions to these problems will be accomplished by using a calculator and/or a spreadsheet program. These business problems will involve basic arithmetic, fractions, percents, discounts, simple interest, prorating and markup/markdown. The student will also create spreadsheets using financial functions and work with multiple worksheets and workbooks.
Course content

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 VLOOPUP functions
5.2          Work with large spreadsheets--freeze panes, hide rows/columns
5.3          Use the AutoFilter command
5.4          Link cells in multiple worksheets
5.5          Link workbooks
5.6          Use conditional formatting
5.7          Create amortization schedules

Learning outcomes

The learner has reliably demonstrated the ability to:

  1. perform arithmetic calculations manually;
  2. solve a variety of business problems using a 10-key calculator;
  3. solve a variety of business problems using spreadsheet software;
  4. exhibit a high standard of behaviour with respect to attendance, punctuality, positive attitude and respect for others.
Means of assessment
Assignments  15%
Employability skills      10%
Test - 1  20%
Test - 2  25%
Test -3  30%
Total 100%
Textbook materials

Textbooks and Materials to be Purchased by Students

 

Merchant, Ronald. Basic Business Math and Electronic Calculators. Latest Edition. Star Publishing Inc.

 

Grauer, Robert and Maryann Barber.  Excel, Latest Edition. Pearson Education.

Prerequisites

(Any Math 11 with a minimum grade “C” standing OR DVST 0210 OR 7 on AS4 OR placement at DVST 0310)

Corequisites

OADM 1256

Which prerequisite

OADM 1347 and OADM 1401