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.

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

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)

END OF MINITERM

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

Lesson 7.1 Questions 9-13; 15-22

Lesson 9.5 Questions 7-8; 11-18