| Week |
Date |
Class Discussion Topic |
Lab - What's due or what you should be doing |
| 1 |
9/25 |
Attendance |
CAS 170 - Begin Chapter 1 |
| |
|
Introduction to Course and Lab |
CAS 171 - Begin Project 4 |
| |
|
File Management |
|
| |
|
Email and Attachments |
|
| |
|
Get Your Book |
|
| |
|
CAS 171 - Review Absolute Refs, IF |
|
| |
|
|
|
| |
9/27 |
Getting to Know You (without singing) |
|
| |
|
CAS 170 - Intro to Excel |
|
| |
|
The Look of Excel, Order in Excel |
|
| |
|
Data Entry |
|
| |
|
Formula Entry |
|
| |
|
Three things you can do with a mouse |
|
| |
|
|
|
| Week |
|
|
|
| 2 |
10/2 |
CAS 170 - AutoSum |
|
| |
|
Formatting |
|
| |
|
CAS 171 - PMT and other financial formulas |
|
| |
|
|
|
| |
10/4 |
CAS 170 |
|
| |
|
Chapter 1, In the Lab #2 examined |
|
| |
|
Accounting Format |
|
| |
|
|
|
| Week |
|
|
|
| 3 |
10/9 |
CAS 170 - Charts |
CAS 170 - Chapter 1 Due |
| |
|
Review for Test 1 |
Begin Chapter 2 |
| |
|
|
CAS 171 - Project 4 Due |
| |
|
|
Begin Project 7 |
| |
|
|
|
| |
10/11 |
Test 1 - CAS 170 (through Chapter 1) |
|
| |
|
|
|
| Week |
|
|
|
| 4 |
10/16 |
Test 1 - CAS 171 (through Project 4) |
|
| |
|
CAS 170 |
|
| |
|
Math and Order of Operations |
|
| |
|
Formulas and Functions |
|
| |
|
Conditional Formatting |
|
| |
|
|
|
| |
10/18 |
CAS 171 - VBA, Macros |
|
| |
|
|
|
| Week |
|
|
|
| 5 |
10/23 |
no class - Faculty In-Service |
CAS 170 - Chapter 2 Due |
| |
|
(Classes starting before 4pm are cancelled) |
Begin Chapter 3 |
| |
|
|
|
| |
10/25 |
CAS 170 - Absolute vs. Relative References |
|
| |
|
|
|
| Week |
|
|
|
| 6 |
10/30 |
CAS 170 |
|
| |
|
IF function |
|
| |
|
Goal Seek |
|
| |
|
Formatting Charts |
|
| |
|
Rotating Text |
|
| |
|
|
|
| |
11/1 |
CAS 171 |
CAS 171 - Project 7 Due |
| |
|
Project 7, Cases and Places #1 examined |
Begin Project 8 |
| |
|
|
|
| Week |
|
|
|
| 7 |
11/6 |
CAS 170 - Review for Test 2 |
CAS 170 - Chapter 3 Due |
| |
|
|
Begin Chapter 5 |
| |
|
|
|
| |
11/8 |
Test 2 - CAS 170 (through Chapter 3) |
|
| |
|
|
|
| Week |
|
|
|
| 8 |
11/13 |
CAS 170 - Sorting, VLookup function |
|
| |
|
|
|
| |
11/15 |
CAS 171 |
CAS 171 - Project 8 Due |
| |
|
Project 8, In the Lab #3 examined |
Begin Project 9 |
| |
|
|
|
| Week |
|
|
|
| 9 |
11/20 |
CAS 170 |
CAS 170 - Chapter 5 Due |
| |
|
Chapter 5, In the Lab #3 examined |
Begin Chapter 6 |
| |
|
|
|
| |
11/22 |
no class - Thanksgiving Holiday |
|
| |
|
|
|
| Week |
|
|
|
| 10 |
11/27 |
CAS 170 - Templates |
|
| |
|
CAS 171 |
|
| |
|
Project 9, In the Lab #1 examined |
|
| |
|
|
|
| |
11/29 |
CAS 170 - Review for Test 3 |
|
| |
|
|
|
| Week |
|
|
|
| 11 |
12/4 |
Test 3 - CAS 170 (through Chapter 6) |
|
| |
|
|
|
| |
12/6 |
Test 2 - CAS 171 (through Project 9) |
CAS 170 - Chapter 6 Due |
| |
|
|
|
| Week |
|
|
|
| 12 |
12/11 |
no class |
CAS 171 - Project 9 Due |
| |
|
|
|
| |
12/13 |
no class |
All Late or Revised Assignments Due |
| |
|
|
|
