|
|
|
|
|
Week 1 |
Aug
27 |
Welcome Turing Software Tools Intro to Excel - cells, formulas, binary operators, precedence, associativity, named cells, errors |
Connecting to Turing Software Tools Intro to Excel |
Assignment 0 - DUE Friday, Aug 31 @ 3pm |
Aug 29 |
Excel functions, absolute & relative cell referencing, filling cells, importing web data |
Excel Functions |
||
Week 2 |
Sept 3 |
Labor Day - NO
CLASS |
||
Sept 5 |
Excel
functions, importing web data, combination cell references, trace
precedents and dependents, range of values, PMT function, payment
tables, what-if analysis, and goal seeking. |
Intermediary Excel |
Assignment 1 |
|
Week 3 |
Sept 10 | Comparison operators, IF function, logical operators (AND, OR), nested IFs |
Advanced Excel |
|
Sept 12 | Continue previous notes. Excel Regression, conditional formatting |
Regression in Excel |
DUE - Assignment 1 Assignment 2 |
|
Week
4 |
Sept 17 |
Continue previous notes: polynomial, exponential, power, and logarithmic regression Review for the midterm. |
Review |
|
Sept 19 |
Midterm |
DUE - Assignment 2 |
||
Week 5 |
Sept 24 | SPSS - setting up a dataset, descriptive statistics, and charting |
SPSS - Intro |
|
Sept 26 | SPSS - importing data from Excel, regression in Excel |
SPSS - Regression |
||
Week
6 |
Oct 1 |
Hypothesis Testing |
Hypothesis testing I Hypothesis testing 2 |
Assignment 3 |
Oct 3 |
Word:
|
Word - Mail Merge and Equation Editor |
||
Week 7 |
Oct 8 | Review | ||
Oct 10 | Final Exam - 4:45-7:45pm | DUE - Assignment 3 |