|
|
|
|
|
Tuesday January 7 |
1-2:30pm |
Welcome Turing Software Tools |
Turing Software Tools |
Assignment 0: Questionnaire - DUE Thursday, January 9 at 3:15pm |
3:15-4:45pm |
Intro to Excel - cells, formulas, binary operators, precedence, associativity, named cells, errors | Intro to Excel |
||
Wednesday January 8 |
1-2:30pm | Excel functions, absolute & relative cell references filling cells Charts |
Excel Functions |
|
3:15-4:45pm | importing web data Combination cell references, trace precedents and dependents, range of values, PMT function. |
Excel PMT Function |
Assignment 1 Worksheet 1 Spreadsheet DUE at 1pm on Friday, January 10 |
|
Thursday January 9 |
1-2:30pm | Payment tables, what-if analysis, goal seeking. Comparison operators, IF function. |
Excel IF Function |
|
3:15-4:45pm | Logical operators (AND, OR), pie charts, conditional formatting, nested Ifs. | |||
Friday January 10 |
1-2:30pm | In class problems |
Excel Problems |
Assignment 2 DUE at 1pm on Tuesday, January 14 |
3:15-4:45pm | In class problems |
|||
Monday January 13 |
1-2:30pm | Excel Regression |
Excel Regression |
|
3:15-4:45pm | Review | Review Problems |
||
Tuesday January 14 |
1-2pm | Review |
||
3:00-4:45pm | Midterm Exam | |||
Wednesday January 15 |
1-2:30pm | SPSS - setting up a dataset, descriptive statistics |
SPSS - Intro |
|
3:15-4:45pm | SPSS - Importing data from various sources Graphing |
SPSS - Charts |
||
Thursday January 16 |
1-2:30pm | SPSS - Regression SPSS - Importing Data |
SPSS - Regression SPSS - Importing |
Assignment 3 - DUE at 1pm on Tuesday, January 21 |
3:15-4:45pm | SPSS - Hypothesis testing | SPSS - Hypothesis Testing |
||
Friday January 17 |
1-2:30pm | Hypothesis Testing Worksheet, Mail Merge, Equation Editor | Hypothesis Testing Worksheet Equation Editor |
|
3:15-4:45pm | PowerPoint | PowerPoint |
||
Monday January 20 |
1-2:30pm | MLK DAY - NO CLASS |
||
Tuesday January 21 |
1-2:30pm | Review |
Review Worksheet |
|
3:15-4:45pm | Review |
|||
Wednesday January 22 |
1-3:30pm | Final Exam |