Course

Spreadsheets and Business Calculations

Important Notice

This course is not active. Please contact Department Chair for more information.

Faculty
Commerce & Business Administration
Department
Office Administration
Course Code
OADM 1222
Credits
3.00
Semester Length
15 Weeks x 4 Hours per Week = 60 Hours
Max Class Size
30
Method(s) Of Instruction
Lecture
Seminar
Typically Offered
Fall

Overview

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, 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

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.

Means of Assessment
Assignments 20%
Test #1 25%
Test #2 25%
Test #3 30%
Total 100%
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.
Textbook Materials

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.

Requisites

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

Equivalencies

No equivalent courses.

Course Guidelines

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.

(Current)

Course Transfers

These are for current course guidelines only. For a full list of archived courses please see https://www.bctransferguide.ca

Institution Transfer Details for OADM 1222
There are no applicable transfer credits for this course.

Course Offerings

Summer 2024