|
|
|
|
Notes |
| Mon, Jan 9 |
Welcome Turing Software Tools Intro to Excel - cells, formulas, binary operators, precedence, associativity, named cells, errors. |
Questionnaire Connecting to Turing Software Tools Intro to Excel |
|
| Tue, Jan 10 | Excel functions, absolute & relative cell referencing, filling cells, importing web data. Combination cell references, trace precedents and dependents, range of values, PMT function, payment tables, what-if analysis, goal seeking. |
Assignment 1- Due Wednesday, Jan 11 @ 1pm |
Excel Functions Intermediary Excel |
| Wed, Jan 11 | Comparison operators, IF function, logical operators (AND, OR) |
Assignment 2 - Due Thursday, Jan 12 @ 1pm |
Excel Logic and IFs |
| Thu, Jan 12 | In class problems In class problems |
Problems 1 Problems 2 |
|
| Fri, Jan 13 | Review MIDTERM |
Review Sheet |
|
| Mon, Jan 16 | MLK DAY - NO CLASS |
MLK Day Events |
|
| Tue, Jan 17 | Excel Regression SPSS - setting up a dataset, descriptive statistics |
Excel Regression SPSS - Intro |
|
| Wed, Jan 18 | SPSS - Importing data from various sources SPSS - Regression SPSS - Importing Data |
Assignment 3 - Due Friday, Jan 20 @ 1pm |
SPSS - Graphing SPSS - Regression SPSS - Importing Data |
| Thu, Jan 19 | SPSS - Hypothesis testing SPSS - Hypothesis testing II |
Hypothesis Testing I Hypothesis Testing II Worksheet |
|
| Fri, Jan 20 | Mail Merge, Equation Editor PowerPoint, Review |
Word Review Sheet |
|
| Mon, Jan 23 | FINAL EXAM |
