MEYERSDALE AREA SCHOOL DISTRICT
A PLANNED COURSE STATEMENT
FOR
Business Math I
Adopted: June 2006
Revised: June 2012
Developed by: Christine Custer
Business Math Planned Course Statement Page 8
A. COURSE DESCRIPTION
· This course is designed to give the student an insight into the functions of mathematics used in the business and every day environment. Business Math I integrates everyday business math with the use of Microsoft Excel spreadsheets. This course covers fractions, percents, bank services, payroll, taxes, insurance, purchasing merchandise, markup, markdown and interest. Through internet activities, reinforcement activities, quizzes and spreadsheets, students apply concepts in a meaningful way. This course provides students with the knowledge to perform math calculations with a technological manner. This course uses the traditional method of calculating integrated with Excel. This course is recommended for all college-bound students and to career-minded students for entry level positions upon graduating high school.
Length of Course: 18 Weeks
Periods per Week: Five
Curriculum: Business Education
Unit: 1 Credit
Grading: Percentage
Prerequisite(s): None
Materials:
· Business Math Using Excel, Copyright 2005, South-Western.
· Microsoft Excel software
UNIT: Microsoft Excel
I. Learning Objective:
A. Students will understand the terminology and concepts of the basics of Microsoft Excel and apply these to create mathematical worksheets.
II. Getting started with Excel:
A. Define spreadsheet software.
B. Open and save a workbook.
C. Enter labels and values.
D. Preview and print a worksheet.
E. Plan and design a worksheet.
F. Edit Cell entries and work with ranges.
G. Enter formulas.
H. Introduce Excel functions.
I. Copy and move cell entries.
J. Understand relative and absolute cell references.
K. Copy formulas with relative cell references.
L. Copy formulas with absolute cell references.
III. Formatting a worksheet
A. Format values
B. Use fonts and font sizes
C. Change attributes and alignment of labels
D. Adjust column widths
E. Insert and delete rows and columns
F. Apply colors, patterns, and borders
G. Use conditional formatting
IV. Working with charts
A. Plan and design a chart
B. Create a chart
C. Move and resize a chart
D. Edit a chart
E. Format a chart
F. Enhance a chart
G. Annotate and draw on a chart
UNIT: Basic Math Functions
I. Learning Objective: Students will understand and demonstrate the basic math functions including decimals, adding, division and integrate these on to excel spreadsheets.
II. Basic math funcitons:
A. Numbers
1. Identify each position of the decimal number system
2. Write numbers or amounts in word forms.
3. Round numbers
4. Use Excel to round numbers
B. Addition
1.Identify terms used with addition
2.Align decimal points in addition
3.Add mentally
4.Add by tens mentally
5.Add horizontally
6.Use Excel to solve problems involving addition
C. Subtraction
1.Identify terms used with subtraction
2.Subtract vertically
3. Check subtraction by addition
4. Regroup in subtraction
5. Solve problems with zzeros in regrouping in subtraction
6. Express negative numbers
7. Use Excel to solve problems involving subtraction
D. Multiplication
1. Identify terms used with multiplication
2. Multiply correctly
3. Multiply with decimals
4. Solve problems with zeros in multiplication
5. Check multiplication
6. Accumulate products
7. Use Excel to solve problems involving multiplication
E. Division
1. Identify terms used with division
2. Divide whole numbers
3. Divide numbers that have remainders
4. Divide numbers with decimals
5. Check division by multiplying
6. Use Excel to solve problems involving division
F. Basic math operations and Excel
1. Combine basic math operation in Excel
II. Fractions:
A. Fractions and mixed numbers
1. Identify terms used with fractions
2. Distinguish between fractions and mixed numbers
3. Convert improper fractions to whole numbers
4. Convert improper fractions to mixed numbers
5. Convert mixed numbers to improper fractions
6. Reduce fractions to lowest terms
7. Raise fractions to higher terms
8. Convert fractions to decimals
9. Convert decimals to fractions
10. Use Excel to enter fractions and mixed number
B. Add and subtract fractions and mixed numbers
1. Identify terms used with adding and subtracting fractions
2. Add and subtract like fractions
3. Find the least common denominator
4. Add and subtract unlike fraction
5. Add fractions and mixed numbers
6. Subtract fractions and mixed number
7. Use Excel to add and subtract fractions and mixed numbers
C. Multiply and divide fractions and mixed numbers
1. Multiply common fractions
2. Use cancellation
3. Multiply whole numbers, fractions and mixed numbers
4. Divide fractions
5. Divide whole numbers, fractions, and mixed number
6. Use Excel to multiply and divide numbers and fractions
III. Percent
A. Introduction to percents
1. Identify terms used with percents
2. Write a percent as a decimal
3. Write a decimal as a percent
4. Write a percent as a fraction
5. Write a common fraction as a percent
6. Use Excel to format a percent, decimal or fraction
B. Part, rate and base
1. Identify the terms part, rate and base
2. Find the part
3. Find the rate
4. Find the base
5. Identify the elements of percent problems
6. Use Excel to find the part, rate and base
C. Percent of increase and decrease
1. Identify terms used with percent of increase and percent of decrease
2. Find the percent of increase and the total when the percent is given
3. Find the percent of decrease and the total when the percent is given
4. Determine percentage distribution
5. Use Excel to calculate increase and decrease and percentage distribution
IV. Bank Service
A. The Checking Account
1. Identify terms used with checking accounts
2. Identify checking account services
3. Distinguish among the types of checking accounts
4. Maintain a checkbook and a check register
5. Use Excel to complete a deposit slip and a check register
B. Bank Statement Reconciliation
1. Understand why a checking account must be reconciled
2. Interpret a bank statement
3. Reconcile a bank statement with a check register
4. Use Excel to reconcile a bank statement
V. Payroll
A. Gross Earnings
1. Identify terms used for computing gross earnings
2. Calculate gross pay for common pay periods
3. Calculate gross earnings for straight time, overtime, and double time
4. Use Excel to calculate straight time, overtime, and double time
B. Gross Pay for Various Compensation Methods
1. Identify terms used for various compensation methods
2. Calculate compensation by salary
3. Calculate compensation by salary plus commission
4. Calculate compensation by piecework
5. Use Excel to calculate various methods of compensation
C. Payroll Deductions
1. Identify terms used for payroll deductions
2. Calculate social security and Medicare
3. Find the federal income tax using the wage bracket method
4. Find the federal income tax using the percentage method
5. Find the state income tax using the state income tax rate
6. Find the amount paid to IRS each payroll tax period
7. Use Excel to calculate social security, Medicare, federal income tax, and state income tax
D. Employee’s earnings Record and Payroll Register
1. Create an employee’s earning record
2. Create a payroll register
3. Use Excel to create a payroll register
VI. Taxes and Insurance
A. Identify terms used with property tax and property tax rates
1. Calculate the tax levied on property based on the assessed value
2. Calculate the tax rate levied on property based on the assessed value
3. Use Excel to calculate property taxes
B. State Unemployment Tax, Federal Unemployment Tax and Federal Income Tax
1. Identify terms used with state unemployment tax, federal unemployment tax and federal income tax
2. Calculate state unemployment tax
3. Calculate federal unemployment tax
4. Calculate federal income tax
5. Use Excel to calculate SUTE, FUTA and federal income tax
C. Health, Auto, Life, and Property Insurance
1. Identify terms used with insurance
2. Determine the premiums for health insurance
3. Determine the premiums for automobile insurance
4. Determine the premiums for life insurance
5. Determine the premiums for property insurance
6. Calculate the payment when a property insurance policy contains an 80% coinsurance clause
7. Use Excel to calculate insurance premiums
VII. Purchasing Merchandise
A. The Purchasing Cycle
1. Describe the purchasing cycle
2. Identify terms used with purchasing
B. Cash Discounts
1. Identify terms used with cash discounts
2. Calculate cash discounts
3. Use the complement method
4. Find the net amount after merchandise has been returned
5. Find the net amount due after shipping and insurance charges
6. Calculate amount of credit for partial payments
7. Use Excel to calculate the net amount due
C. Trade Discounts
1. Find the net amount due after a single trade discount
2. Calculate the net amount due after trade and chas discounts and shipping charges
3. Use Excel to calculate the net amount due
D. Series Discounts
1. Find the net price after a series discount
2. Find the single discount equivalent rate
3. Use Excel to calculate the series discount
E. Sales Tax
1. Calculate sales tax
2. Use Excel to calculate sales tax
VIII. Markup and Markdown
A. Concepts Used in Pricing Merchandise
1. Identify terms used with pricing merchandise
2. Distinguish among basic pricing variables
3. Apply base, rate and part formulas to pricing
B. Selling Price
1. Calculate markup based on cost to compute selling price
2. Calculate selling price when cost and markup rate based on selling price are known
3. Use Excel to calculate markup and selling price
C. Markup Rate
1. Calculate markup rate based on cost
2. Calculate markup rate based on selling price
3. Use Excel to calculate markup rate
D. Markdown
1. Determine markdown sale price
2. Calculate markdown rate
3. Use Excel to calculate markdown rate
Business Math Planned Course Statement Page 8
UNIT: / All Units in Business Math 1INSTRUCTIONAL STRATEGIES / RESOURCES & MATERIALS / ASSESSMENT PROCEDURES (cont'd)
X / Lecture / X / Computer / Classroom Portfolio
X / Demonstration / X / Overhead Projector / Other
X / Discussion / X / Chalkboard
X / Exploratory/Discovery Activity / Models/Maps / METHODS OF ASSISTANCE
Laboratory / X / Textbooks / AND ENRICHMENT
X / Cooperative Learning / X / Resource Books / Peer Tutor
X / Independent Learning / Literature / X / Adaptive Materials
X / Integrated Learning / Laboratory Equip./Materials / X / Test Remake/Retry
X / Presentation/Dramatization / Manipulatives / X / Cooperative Learning
Community Based Instruction / X / Worksheets/Workbooks / Teacher Tutor
Assembly / Demonstration Board / Self-Check Charts
X / Peer Teaching / Slides/Filmstrips/Movies / X / Modified Curriculum
Enrichment/Learning Centers / X / Charts / X / Instructional Support
X / Computations / X / Calculator / Parental Conferences
X / Project / Other / Aide Assistance
X / Note Taking / Color Code Clues
X / Silent Reading / ASSESSMENT PROCEDURES / X / Alternate Instructional Approaches
Drawing / Class Participation / X / Provide Extra Time
Field Trips / Research Papers / X / Tests
Competitions / Essay Tests / Task Analysis
Guest Speakers / X / Objective Tests / Organizational Framework
Model Building / X / Rubrics / X / Verbal Response (Tests)
Other / X / Homework / Ad Hoc Grouping
Individual Project / X / Computer Utilization
INSTRUCTIONAL ARRANGEMENTS / X / Class Work / X / Independent Testing
X / Whole Class / X / Application / X / Audio/Videotape Lessons
X / Small Group / Multi-media Production / Resource Teacher
Pairs / Quality Elements Checklist / Extended Readings
X / Individual / Teacher Observations / X / Guidesheets
Focus Groups / Self-Assessment / Learning Style Adaptations
Ability Groups / Workshops / Increase Guided Practice
X / Heterogeneous Group / X / Tests / Read
Inclusionary/Blended / Journals / Work Experience
Teaching Team / X / Lab Work / Other
Skills Checklist
MATERIALS/TECHNOLOGIES: / Peer Work
Audiocassette/Projector / Group Work
X / Videocassette/VCR/TV / Group Project
X / Software/Computer / Posters
CD ROM/Computer / Observations
X / Internet / Oral Presentations
Videoconference / Community Service
TV/Satellite / Booklets
Other / Leadership