| Date |
Topic |
Reading |
Due |
| Sep |
6 |
Wed |
Introduction to the course and Excel |
Gauaer and Barber, Chapter 1 |
|
|
|
11 |
Mon |
Introduction to Excel |
Gauaer and Barber, Chapter 1 |
|
| ProblemSolving.ppt
13 |
Wed |
Calculations in Excel, Simple and compound interest |
Look up definitions of simple and component interest. |
|
|
|
18 |
Mon |
Relative and absolute addressing, spreadsheet design, academic integrity |
Gauaer and Barber, Chapter 2
http://www.cs.plu.edu/courses/csce115/fall06/csce115syl.html
http://www.plu.edu/print/handbook/code-of-conduct/academic-integrity.html |
Lab 1 |
|
20 |
Wed |
Topics from Chapter 2 |
Gauaer and Barber, Chapter 2 |
|
|
|
25 |
Mon |
Functions including Average, Min, Max, Count, If, charts
|
Gauaer and Barber, Chapter 4, pages 184 - 188, Chapter 3 |
Lab 2 |
|
27 |
Wed |
Graphs and Charts |
Gauaer and Barber, Chapter 3 |
|
|
| Oct |
2 |
Mon |
Loan analysis, amortization schedules
The PMT, FV, PV and other functions |
Gauaer and Barber, Chapter 4 |
Lab 3 |
|
4 |
Wed |
More on Financial Functions and other functions, protection, borders |
Gauaer and Barber, Chapter 4 |
Group project proposals |
|
|
9 |
Mon |
VLookup and HLookup, Sorting |
Gauaer and Barber, Chapter 4 |
Lab 4 |
|
11 |
Wed |
VLookup and HLookup, Sorting |
Gauaer and Barber, Chapter 4 |
|
|
|
16 |
Mon |
Gauaer and Barber, Chapter 4, Review |
Review materials |
Lab 5 |
|
18 |
Wed |
Exam one |
Covers Excel, loans and savings |
|
|
|
23 |
Mon |
Basic XHTML 1.0 and web pages |
Web Wizzrd's Guide to XHTML, Chapters 1 and 2
or http://www.goer.org/HTML/
(Introduction and Basic (though Colors) sections) |
Lab 6 |
|
25 |
Wed |
Intermediate XHTML 1.0 |
Web Wizzrd's Guide to XHTML, Chapter 3 |
|
|
|
30 |
Mon |
Advanced XHTML 1.0
Group project presentations |
Web Wizzrd's Guide to XHTML, Chapters 3 and 4
|
Lab 7 |
| Nov |
1 |
Wed |
XHTML wrapup
Group project presentations |
|
|
|
|
6 |
Mon |
Problem solving
Statistics |
ProblemSolving.ppt
stat1.ppt |
Lab 8 |
|
8 |
Wed |
Statistics
|
stat1.ppt |
Individual project proposals |
|
|
13 |
Mon |
Normal Curve |
stat2.ppt
Normal Curve Links |
|
|
15 |
Wed |
Normal Curve
Review of Statistics |
stat2.ppt |
Lab 9
(Due Thursday) |
|
|
20 |
Mon |
Exam two |
Covers XHTML, Statistics |
|
|
22 |
Wed |
Thanksgiving vacation |
No class |
|
|
|
27 |
Mon |
Normal curve |
stat2.ppt |
Lab 10 |
|
29 |
Wed |
Individual project presentations |
|
|
|
| Dec |
4 |
Mon |
Individual project presentations |
|
|
|
6 |
Wed |
Review |
|
Lab 11 |
|
|
|
| Dec |
13 |
Wed |
Final Exam: comprehensive |
Home
