This series of courses is intended to prepare students to use mathematical principles to make decisions with regards to Personal Finance, Credit and Insurance decisions or in Business decisions.  There is a strong focus on practical mathematical skills and the application of these skills in building spread sheets.  

Below are I will be posting a series of videos with instructions for the basic functions we will be using in Google Sheets for our projects due at the end of each unit.

Google Sheets Basics #1



Math For Business Applications

Assignment List

Each Lesson 

I. Complete the Content Vocabulary

II. Summarize the reading section before Example 1

III. Complete the assigned problems

One Question in each section must be done BY HAND. The rest you can use either a calculator or Excel to determine your answer.  

Long Division: You can do the question using a calculator first and then use your answer to demonstrate how to do long division.

ALL Spreadsheet Projects are DUE the Workday the week after they are assigned​


Lesson 13.1 Questions 8 & 9; 12-20

Lesson 13.2 Questions 10 & 11; 14-23

Lesson 13.3 Questions 7; 11-20

Lesson 13.4 Questions 5-7; 9-16

Lesson 13.5 Questions 6-9; 10-18

Lesson 13.6 Questions 10; 13 - 24

Lesson13.7 Questions 10 – 13; 17 - 27

Excel Project Part 1: Complete Question 15-19 on pg. 507 using an Excel Spread Sheet to do the calculations

Excel Project Part 2: Complete Question 22-25 on pg. 507 using an Excel Spread Sheet to do the calculations
Lesson 14.1 (Trade Discounts) Questions 9-11; 23-32

Lesson 14.2 (Trade Discounts Complement Method) Questions 9-12; 16-25

Lesson 14.3 (Chain Discounts) Questions 9-10; 17-19; 22-33

Lesson 14.4 (Cash Discounts – Ordinary Dating) Questions 11-12; 15 - 24

Lesson 14.5 (Cash Discounts – OEM Dating) Questions 14-15; 18-25

Lesson 14.6 (Inventory) Questions 9-10; 13 - 23

Lesson 14.7 (Valuing Inventory) 6-8; 11-20

Lesson 14.8 (Carrying Inventory) 12-15; 19-28

Excel Project Part 1: Complete Question 10-12 on pg. 545 using an Excel Spread Sheet to do the calculations

Excel Project Part 2: Complete Question 13-15 on pg. 545 using an Excel Spread Sheet to do the calculations

Excel Project Part 3: Complete Question 17-23 on pg. 546 using an Excel Spread Sheet to do the calculations

Excel Project Part 4: Complete Question 24 on pg. 546 using an Excel Spread Sheet to do the calculations

Lesson 15.1 (Markup) Questions 15-17; 19-28

Lesson 15.2 (Markup Rate) Questions 9-13; 16-25

Lesson 15.3 (Net Profit) Questions 10-13; 18-26

Lesson 15.4 (Net-Profit Rate) Questions 11-17; 20-29

Lesson 15.5 (Markup Based on Selling Price) Questions 7-10; 14-20

Lesson 15.6 (Markup Rate) Questions 12-13; 17-26

Lesson 15.7 (Markup Based on Cost) Questions 17-21; 27-36

Lesson 15.8 (Markdown) Questions 11-16; 20-29

Excel Project Part 1: Complete Question 12-17 on pg. 581 using an Excel Spread Sheet to do the calculations

Excel Project Part 2: Complete Question 19-23 on pg. 581 using an Excel Spread Sheet to do the calculations

Excel Project Part 3: Complete Question 26-30 on pg. 582 using an Excel Spread Sheet to do the calculations

Excel Project Part 4: Complete Question 33-40 on pg. 583 using an Excel Spread Sheet to do the calculations

Excel Project Part 5: Complete Question 44-49 on pg. 584 using an Excel Spread Sheet to do the calculations

Excel Project Part 6: Complete Question 52-59 on pg. 585 using an Excel Spread Sheet to do the calculations

Excel Project Part 7: Complete Question 65-71 on pg. 586 using an Excel Spread Sheet to do the calculations

Excel Project Part 8: Complete Question 74-79 on pg. 586 using an Excel Spread Sheet to do the calculations

Lesson 16.1 (Opinion Surveys) Questions 8-9, 16-26

Lesson 16.2 (Sales Potential) Questions 5-7; 9-15

Lesson 16.3 (Market Share) Questions 7-9; 13-19

 Lesson 16.4 (Sales Projections) Questions 7-8; 13-22

Lesson 16.5 (Newspaper Advertising Costs) Questions 6; 9-16

 Lesson 16.6 (Television Advertising Costs) 9-10; 15-24

 Lesson 16.7 (Pricing) 9-10; 13-22

 Excel Project Part 1: Complete Question 19-24 on pg. 615 using an Excel Spread Sheet to do the calculations

Excel Project Part 2: Complete Question 26-33 on pg. 616 using an Excel Spread Sheet to do the calculations

Excel Project Part 3: Complete Question 35-40 on pg. 616 using an Excel Spread Sheet to do the calculations

Excel Project Part 4: Complete Question 44-49 on pg. 618 using an Excel Spread Sheet to do the calculations

Excel Project Part 5: Complete Question 52-57 on pg. 619 using an Excel Spread Sheet to do the calculations

Excel Project Part 6: Complete Question 59-62 on pg. 620 using an Excel Spread Sheet to do the calculations

Lesson 17.1 (Building Rental) Questions 9; 1 - 20

Lesson 17.2 (Maintenance and Improvement) Questions 5-8; 11-20

Lesson 17.3 (Equipment Rental) Questions 6; 9-14

Lesson 17.4 (Utilities Cost – Telephone) Questions 11; 15, 23

Lesson 17.5 (Utilities Cost – Electricity) Questions 8-10; 14-24

Lesson 17.6 (Professional Services) Questions 8-13; 16-22

Excel Project Part 1: Complete Question 9-14 on pg. 648 using an Excel Spread Sheet to do the calculations

Excel Project Part 2: Complete Question 17-22 on pg. 649 using an Excel Spread Sheet to do the calculations

Excel Project Part 3: Complete Question 24-29 on pg. 650 using an Excel Spread Sheet to do the calculations

Excel Project Part 4: Complete Question 33-38 on pg. 651 using an Excel Spread Sheet to do the calculations

Excel Project Part 5: Complete Question 41-44 on pg. 652 using an Excel Spread Sheet to do the calculations

Excel Project Part 6: Complete Question 46-50 on pg. 652 using an Excel Spread Sheet to do the calculations

Math for Personal Finance

Assignment List

Each Lesson 

I. Complete the Content Vocabulary

II. Summarize the reading section before Example 1

III. Complete the assigned problems

One Question in each section must be done BY HAND. The rest you can use either a calculator or Excel to determine your answer.  

Long Division: You can do the question using a calculator first and then use your answer to demonstrate how to do long division.

ALL Spreadsheet Projects are DUE the Workday the week after they are assigned

Intro & Workshop 1 & 2

Workshop 6 

Lesson 1.1 Questions 15-21; 26-39 (Straight Time Pay)

Lesson 1.2 Questions 11-15; 18-29 (Overtime Pay)

Lesson 1.3 Questions 9-13; 15-23 (Weekly Time Card)

Lesson 1.4 Questions 11-19; 22-33 (Piecework)

Lesson 1.5 Questions 7-9; 11-20 (Salary)

Lesson 1.6 Questions 12-18; 22-36 (Commission)

Lesson 1.7 Questions 11-13; 18-32 (Graduated Commission)

Chapter 1 Spreadsheet Project: Questions 25-30 on pg. 120
PLUS figure out gross pay at $17.27 using the spreadsheet

Lesson 2.1 Questions 13-14; 16-26 (Federal Income Tax)

Lesson 2.2 Questions 11-14; 21-31 (State Income Tax)

Lesson 2.3 Questions 5-6; 8-18 (Graduated State Income Tax)

Lesson 2.4 Questions 7-8; 12-22 (Social Security and Medicare Taxes)

Chapter 2 Spreadsheet Project: Calculating Net Pay
Using MicroSoft Excel complete Questions 22-24 on pg. 149; & Question28 on pg. 150; 

Lesson 2.5 Questions 5-10; 14-24 (Group Health Insurance)

Lesson 2.6 Questions 4-6; 12-22 (Statement of Earnings)

Lesson 3.1 Questions 5-8; 13-14; 17-25 (Average Monthly Expenditures)

Lesson 3.2 Questions 3-9; 12-23 (Preparing a Budget Sheet)

Chapter 3: Spreadsheet Project: Household Budget
Use Microsoft Excel to compare the actual budget to the amount budgeted on pg. 171

Lesson 3.3 Questions 11; 14-25 (Using a Budget)

Lesson 4.1 Questions 15-18; 24-33 (Deposits)

Lesson 4.2 Questions 7-18; 23-31 (The Check Writing Process)

END OF MINITERM 

Lesson 4.3 Questions 6-7; 12-21 (Check Registers)

Lesson 4.4 Questions 4-11; 16-26 (Bank Statements)

Lesson 4.5 Questions -5; 7-16 (Banking Statement Reconciliation)

Lesson 4.6 Questions 4-6; 8-19 (Online Banking)

Chapter 4: Spread Sheet Activity: Check Register and Reconciliation
Use MicroSoft Excel to complete the following questions:
4.3 Check Registers on pg. 204
4.4 Bank Statements on pg. 205
Questions 23-25

Lesson 5.1 Questions 6-9; 14-23 (Deposits)

Lesson 5.2 Questions 11-15, 17-27 (Withdrawals)

Lesson 5.3 Questions 8-10; 13-24 (Account Statements)

Lesson 5.4 Questions 10-11; 16-27 (Simple Interest)


Lesson 5.5 Questions 9-15; 18-30 (Compound Interest)

Lesson 5.6 Questions 11; 17-27 (Compound Interest Tables)

Lesson 5.7 Questions 7-10; 15-24 (Daily Compounding)

Lesson 5.8 Questions 9-12; 15-22 (Annuities)

Chapter 5: Spreadsheet Project: Simple and Compound Interest
Part 1: Use MicroSoft Excel to complete questions 12-13 on pg. 240
Part 2: Use MicroSoft Excel to complete questions 29-30 on pg. 242
Part 3: Use MicroSoft Excel to complete questions 32-34 on pg. 243
Part 4: Use MicroSoft Excel to complete questions 37-39 on pg. 243
Part 5: Use MicroSoft Excel to complete questions 41-42 on pg. 244

Lesson 6.1 Questions 9-10; 13-21 (Sales Tax)

Lesson 6.2 Questions 11-13; 16-25 (Total Purchase Price)

Lesson 6.3 Questions 9-14; 16-22 (Unit Pricing)

Chapter 6: Spreadsheet Project: Sales Price Calculation
Part 1: Use MicroSoft Excel to complete questions 11-14 on pg. 274
Part 2: Use MicroSoft Excel to complete questions 16-20 on pg. 274-5
Part 3: Use MicroSoft Excel to complete questions 23-26 on pg. 275
Part 4: Use MicroSoft Excel to complete questions 27-31 on pg. 276
Part 5: Use MicroSoft Excel to complete questions 33-36 on pg. 277
Part 6: Use MicroSoft Excel to complete questions 39-43 on pg. 277
Part 7: Use MicroSoft Excel to complete questions 46-49 on pg. 278

Lesson 6.4 Questions 6-10; 13-22 (Comparison Shopping)

Lesson 6.5 Questions 8-13; 15-21 (Coupons and Rebates)

Lesson 6.6 Questions 10-14; 22-32 (Mark Down)

Lesson 6.7 Questions 4-12; 17-27 (Sale Price)


END OF MINITERM  / TRIMESTER 1













​Math for Credit and Investments

Assignment List

Each Lesson

I. Complete the Content Vocabulary

II. Summarize the reading section before Example 1

III. Complete the assigned problems

One Question in each section must be done BY HAND. The rest you can use either a calculator or Excel to determine your answer.  

Long Division: You can do the question using a calculator first and then use your answer to demonstrate how to do long division.

ALL Spreadsheet Projects are DUE the Workday the week after they are assigned​

Lesson 7.1 Questions 9-13; 15-22 

Lesson 7.2 Questions 8-11; 14-19 

Lesson 7.3 Questions 17-18; 22-30 

Spreadsheet Project: Compare Credit Card Offers

Part 1: Using MicroSoft Excel complete questions 9-12 on pg. 296
Part 2: Using MicroSoft Excel complete questions 13-14 on pg. 296
Part 3: Using MicroSoft Excel complete questions 16-17 on pg. 298

Lesson 8.1 Questions 8-10; 1-24 

Lesson 8.2 Questions 11-19; 23-33 

Lesson 8.3 Questions 7-16; 25-34 

Lesson 8.4 Questions 5-7; 16-24 

Lesson 8.5 Questions 8-10; 17-22 

Lesson 8.6 Questions 7-10; 1-21 

Chapter 8: Spreadsheet Project: Comparing Loan Offers

Part 1: Using MicroSoft Excel complete questions 1-15 on pg. 326
Part 2: Using MicroSoft Excel complete questions 19-20 on pg. 326
Part 3: Using MicroSoft Excel complete questions 23-26 on pg. 328
Part 4: Using MicroSoft Excel complete questions 31-38 on pg. 329
Part 5: Using MicroSoft Excel complete questions 42-45 on pg. 330

Lesson 9.1 Questions 8; 12-18 

Lesson 9.2 Questions 6-9; 15-22 

Lesson 9.3 Questions 7-8; 11-21 

Lesson 9.5 Questions 7-8; 11-18 

Lesson 9.6 Questions 8-9; 14-22 

Lesson 9.7 Questions 9-10; 13-19 

Chapter 9: Spreadsheet Project: Leasing vs Purchase of a Vehicle

Part 1: Using MicroSoft Excel complete questions 12-15 on pg. 364
Part 2: Using MicroSoft Excel complete questions 18-21 on pg. 365
Part 3: Using MicroSoft Excel complete questions 27-28 on pg. 366
Part 4: Using MicroSoft Excel complete questions 31-33 on pg. 367
Part 5: Using MicroSoft Excel complete questions 36-39 on pg. 368
Part 6: Using MicroSoft Excel complete questions 41-42 on pg. 368

Lesson 10.1 Questions 7-10; 13-22 

Lesson 10.2 Questions 7-11; 16-25 

Lesson 10.3 Questions 6-8; 11-21 

Lesson 10.4 Questions 11-14; 18-28 

Lesson 10.5 Questions 8-10; 15-24 

Lesson 10.6 Questions 4-8; 10-16 

Lesson 10.7 Questions 4; 6-12 

Lesson 10.8 Questions 3-5; 9-17 

Lesson 10.9 Questions 10-12; 17-27 

1/25/2018Chapter 10: Spreadsheet Project: Housing Costs
Part 1: Using MicroSoft Excel complete questions 12-15 on pg. 404
Part 2: Using MicroSoft Excel complete questions 17-20 on pg. 405
Part 3: Using MicroSoft Excel complete questions 26-29 on pg. 406
Part 4: Using MicroSoft Excel complete questions 30-33 on pg. 407
Part 5: Using MicroSoft Excel complete questions 35-38 on pg. 407
Part 6: Using MicroSoft Excel complete questions 39-44 on pg. 408
Part 7: Using MicroSoft Excel complete questions 55 on pg. 410


Lesson 11.1 Questions 12-14; 16-26 

Lesson 11.2 Questions 11-14; 16-25 

Lesson 11.3 Questions 9-12; 15-25 

Lesson 11.4 Questions 9-12; 13-20 

2/5/2018Chapter 11: Spreadsheet Project: Insurance

Part 1: Using MicroSoft Excel complete questions 10-15 on pg. 431 
Part 2: Using MicroSoft Excel complete questions 18-23 on pg. 432
Part 3: Using MicroSoft Excel complete questions 26-31 on pg. 433
Part 4: Using MicroSoft Excel complete questions 36-39 on pg. 434

Lesson 12.1 Questions 8-14; 18-27 

Lesson 12.2 Questions 9-12; 16-25 

Lesson 12.3 Questions 9-10; 15-24 

Lesson 12.4 Questions 9-11, 20-29 

Lesson 12.5 Questions 7-8; 12-23 

2/16/2018Chapter 12: Spreadsheet Project: Investments

Part 1: Using MicroSoft Excel complete questions 12-16 on pg. 469 
Part 2: Using MicroSoft Excel complete questions 18-23 on pg. 470
Part 3: Using MicroSoft Excel complete questions 25-30 on pg. 470
Part 4: Using MicroSoft Excel complete questions 32-37 on pg. 471
Part 5: Using MicroSoft Excel complete questions 39-41 on pg. 472 
Part 6: Using MicroSoft Excel complete questions 44-47 on pg. 472
Part 7: Using MicroSoft Excel complete questions 50-53 on pg. 473
Part 8: Using MicroSoft Excel complete questions 55-57 on pg. 474
Part 9: Using MicroSoft Excel complete questions 59-61 on pg. 474 


Lesson 12.6 Questions 10-13; 16-25 

Lesson 12.7 Questions 7-11; 14-23 

12.8 Questions 9-10; 1-23 

Lesson 12.9 Questions 3-8; 14-24