COURSE SCHEDULE

(Last Revised: April 20, 2017)

Disclaimer: The instructor reserves the right to make changes in the course schedule.

Date
Lesson / Step-By-Step Exercises
End-Of Lesson/Unit Projects
Jan 12

Overview, Expectations, Assessment/Participation

 

 

 

Chapter 1 - Basic Math Functions

 Complete before leaving class

Complete by Tuesday, January 17

  • Task #5 (Check your MyGCC email after 5:00 pm today)
Jan 17 Chapter 1 - Basic Math Functions

Homework Assignment:

  1. Page 12 Chapter 1 - ch01ex01.xlsx
  2. Page 12 Chapter 1 - ch01ex02.xlsx
  3. Page 22 Chapter 1 - ch01ex03.xlsx
  4. Page 32 Chapter 1 - ch01ex05.xlsx
  5. Page 41 Chapter 1 - ch01ex07.xlsx
  6. Page 57 Chapter 1 - ch01ex17.xlsx

Instructions:

  1. UPLOAD ALL - (Follow green handout for UPLOADING)
Jan 19

SLO: Chapter 2 - Fractions

PRACTICE:

  1. ch02pr01.xlsx
  2. ch02pr02.xlsx
  3. ch02pr03.xlsx
  4. ch02pr04.xlsx

 

 Assignment:
  1. Page 110 ~ 111 - Chapter 2 ( ODD Only)

Homework Assignment:

  1. Page 111 Chapter 2 - ch02qz01.xlsx
  2. Page 111 Chapter 2 - ch02qz02.xlsx

Instructions:

UPLOAD the 2 EXCEL Files - (Follow green handout for UPLOADING)
Jan 24

Chapter 1 Basic Math Functions / Chapter 2 - Fractions

In-Class Chapter 01 / 02 Assessment (QUIZ):

  1. Page 57 - Chapter 01 #74, 75, 76
  2. Page 61 - Chapter 01 #47, 48, 49
  3. Page 107- Chapter 02 #72 - 82 (EVEN Only)
Jan 26

SLO: Chapter 3.1, 3.2- Percents

PRACTICE:

  1. Page 119 - In-class Practice Exercises
  2. Page 128 ~ 129 In-class Practice Exercises
  3. ch03pr01.xlsx
  4. ch03pr02.xlsx
 Assignment:
  1. Page 119 Chapter 3.1 (EVEN Only)
  2. Page 128 ~ 129 - Chapter 3.2 (EVEN Only)

Homework Assignment:

  1. Page 119 Chapter 3.1 - ch03ex01.xlsx
  2. Page 119 Chapter 3.1 - ch03ex02.xlsx
  3. Page 130 Chapter 3.2 - ch03ex03.xlsx
  4. Page 130 Chapter 3.2 - ch03ex04.xlsx

UPLOAD the 2 EXCEL Files - (Follow green handout for UPLOADING)
Jan 31

SLO: Chapter 3.3 - Percents

PRACTICE:

 

  1. Page 138~139 - In-class Practice Exercises
  2. ch03pr03.xlsx
  3. ch03pr04.xlsx

Assignment:

  1. Page 138~139 Chapter 3.3 (EVEN Only)

Homework Assignment:

  1. Page 139 Chapter 3.3 - ch03ex05.xlsx
  2. Page 139 Chapter 3.3 - ch03ex06.xlsx

UPLOAD the 2 EXCEL Files - (Follow green handout for UPLOADING)
Feb 2 Chapter 3 - Percents

In-Class Chapter 03 Assessment (QUIZ):

Page 148- Chapter 03

  1. Page 148 ~ 149, (#1, 5, 9, 13, 17, 21, 23, 26, 31, 35)
  2. Page 149 ch03qz01.xlsx
  3. Page 149 ch03qz02.xlsx
Feb 7

SLO: Chapter 4.1 - Bank Services

PRACTICE:

 

  1. Page 160~161 - In-class Practice Exercises
  2. ch04pr01.xlsx
  3. ch04pr02.xlsx

In-Class :

  1. Page 164 Chapter 4.1- ch04ex01.xlsx
  2. Page 164 Chapter 4.1- ch04ex02.xlsx
Feb 9

SLO: Chapter 4.2 - Bank Statement Reconciliation

PRACTICE:

  1. Page 170 - In-class Practice Exercises
  2. ch04pr03.xlsx

In-Class :

  1. Page 173 Chapter 4.2- ch04ex03.xlsx
  2. Page 173 Chapter 4.2- ch04ex04.xlsx
Feb 14 Chapter 4 - Bank Services

In-Class Chapter 04 Assessment (QUIZ):

  1. Page 177 ch04ex05.xlsx
  2. Page 181 ch04qz01.xlsx
  3. Page 181 ch04qz02.xlsx
Feb 16

SLO: Chapter 5.1, 5.2 - Payroll

PRACTICE:

  1. Page 188 ~ 189 In-class Practice Exercises
    • Page 188 Chapter 5.1: #1, 2, 3, 4
    • Page 189 Chapter 5.1: #30, 31, 32
    • Page 194 Chapter 5.2: #16, 17, 18, 19
  2. ch05pr01.xlsx
  3. ch05pr02.xlsx

In-Class :

  1. Page 189 Chapter 5.1- ch05ex01.xlsx
  2. Page 173 Chapter 5.2 - ch05ex03.xlsx

 
Feb 21

SLO: Chapter 5.3, 5.4 - Payroll

PRACTICE:

  1. Page 204 ~ 205 In-class Practice Exercises
  2. ch05pr03.xlsx
  3. ch05pr04.xlsx

In-Class :

  1. Page 205 Chapter 5.3- ch05ex06.xlsx
  2. Page 211 Chapter 5.4 - ch05ex08.xlsx
Feb 23 Chapter 5 - Payroll

In-Class Chapter 05 Assessment (QUIZ):

  1. Page 189 ch05ex02.xlsx
  2. Page 194 ch05ex04.xlsx
  3. Page 221 ch05qz01.xlsx
  4. Page 221 ch05qz02.xlsx
Feb 28  
Mar 2

SLO: Chapter 6 - Taxes (Property, State, and Federal Unemployment)

PRACTICE:

  1. Page 229, 234 In-class Practice Exercises
  2. ch06pr01.xlsx
  3. ch06pr02.xlsx
  4. ch06pr03.xlsx
  5. ch06pr04.xlsx

In-Class :

  1. Page 230 Chapter 6.1- ch06ex01.xlsx
  2. Page 230 Chapter 6.1 - ch06ex02.xlsx
  3. Page 234 Chapter 6.2 - ch06ex03.xlsx
Mar 7 SLO: Chapter 6 - Taxes (Federal Income Tax)

PRACTICE:

  1. Page 240 Diagram 1040 EZ In-class Practice Exercises
  2. Page 249 #15 1040EZ In-class Practice Exercises
  3. Page 248 ch06pr05.xlsx

In-Class :

  1. Page 251 Chapter 6.3- ch06ex05.xlsx
Mar 9 Chapter 6 - Taxes

In-Class Chapter 06 Assessment (QUIZ):

  1. Page 259 ch06qz01.xlsx
  2. Page 259 ch06qz02.xlsx
  3. Page 259 ch06qz03.xlsx

 
Mar 14

SLO: Chapter 7 - Insurance (Health & Life Insurance)

PRACTICE:

  1. Page 269 ~ 270 Exercises: #15, 16, 17, 25
  2. Page 267 ch07pr01.xlsx
  3. Page 268 ch07pr02.xlsx

In-Class :

  1. Page 270 Chapter 7.1- ch07ex01.xlsx
  2. Page 270 Chapter 7.1 - ch07ex02.xlsx
Mar 16

SLO: Chapter 7 - Insurance (Motor Vehicle and Property Insurance)

PRACTICE:

  1. Page 278 ~ 279 Exercises: #1, 2, 3, 4, 22, 23
  2. Page 274 ch07pr03.xlsx
  3. Page 277 ch07pr04.xlsx

 

In-Class :

  1. Page 279 Chapter 7.2- ch07ex03.xlsx
  2. Page 279 Chapter 7.2 - ch07ex04.xlsx
Mar 21 Chapter 7 - Insurance

In-Class Chapter 07 Assessment (QUIZ):

  1. Page 287 ch07qz01.xlsx
  2. Page 283 ch07ex07.xlsx
  3. Page 287 ch07qz02.xlsx
Mar 23

SLO: Chapter 8.1, 8.2, 8.3 - Cash Discount & Trade Discounts

PRACTICE:

  1. Page 303 Exercises: #1, 2, 7, 8
  2. Page 308 Exercises: #1, 2, 9 - 15, 16
  3. Page 302 ch08pr02.xlsx
  4. Page 302 ch08pr03.xlsx

In-Class :

  1. Page 303 Chapter 8.2- ch08ex01.xlsx
  2. Page 303 Chapter 8.2- ch08ex02.xlsx
  3. Page 308 Chapter 8.3- ch08ex03.xlsx
  4. Page 308 Chapter 8.3- ch08ex04.xlsx
Mar 28

SLO: Chapter 8.4, 8.5 - Series Discounts & Sales Tax

PRACTICE:

  1. Page 313 Exercises: #1, 2, 5, 6
  2. Page 318 Exercises: #3, 4
  3. Page 311 ch08pr04.xlsx
  4. Page 317 ch08pr05.xlsx

In-Class :

  1. Page 303 Chapter 8.2- ch08ex05.xlsx
  2. Page 303 Chapter 8.2- ch08ex06.xlsx
  3. Page 308 Chapter 8.3- ch08ex07.xlsx
  4. Page 308 Chapter 8.3- ch08ex08.xlsx
Mar 30 Chapter 8 - Invoices and Discounts

In-Class Chapter 08 Assessment (QUIZ):

  1. Page 329 ch08qz01.xlsx
  2. Page 325 ch08ex10.xlsx
  3. Page 329 ch08qz02.xlsx

 
Apr 4

SLO: Chapter 9 - Markup and Markdown

PRACTICE:

  1. Page 334 Exercises: #9 - 15
  2. Page 338 ch09pr01.xlsx

In-Class :

  1. Page 339 Chapter 9.2- ch09ex01.xlsx
  2. Page 339 Chapter 9.2- ch09ex02.xlsx
Apr 6 External Activity Math@Work
Apr 10-14
*SPRING BREAK*
Apr 18

Chapter 9 - Markup and Markdown

PRACTICE:

  1. Page 344 ch09pr02.xlsx
  2. Page 348 ch09pr03.xlsx

In-Class :

  1. Page 345 Chapter 9.3- ch09ex03.xlsx
  2. Page 345 Chapter 9.3- ch09ex04.xlsx
  3. Page 349 Chapter 9.4- ch09ex05.xlsx
  4. Page 349 Chapter 9.4- ch09ex06.xlsx
Apr 20

In-Class Chapter 09 Assessment (QUIZ):

  1. Page 353 ch09ex09.xlsx
  2. Page 357 ch09qz01.xlsx
  3. Page 357 ch09qz02.xlsx

 

© 2017 Yvonne C. Flores, Guam Community College