CS 130 Schedule
|
Date
|
Topic
|
Notes
|
Assignments
|
| Jan 7 Monday |
Questionnaire |
Turing | Software Tools Introduction to Excel cells, formuals binary operators, precedence associativity, named cells, errors |
Turing Introduction Excel |
Survey |
| Jan 8 Tuesday |
Excel functions,
absolute & relative cell references filling cells Charts importing web data Combination cell references, trace precedents and dependents, range of values, PMT function, payment tables, what-if analysis, goal seeking. |
Functions Functions & Tables |
Assignment 1 Sample SpreadSheet |
| Jan 9 Wednesday |
Comparison operators, IF function, logical
operators (AND, OR)
|
Conditionals |
Assignment 2 |
| Jan 10 Thursday |
In class problems
In class problems |
Problems |
|
| Jan 11 Friday |
Review | Midterm
|
Midterm Review | |
| Jan 14 Monday |
Excel Regression
SPSS - setting up a dataset, descriptive statistics |
Regression SPSS |
|
| Jan 15 Tuesday |
SPSS - Importing data from various sources
Graphing SPSS - Regression SPSS - Importing Data |
Graphing Regression Importing |
Assignment 3 California |
| Jan 16 Wednesday |
SPSS - Hypothesis testing
SPSS - Hypothesis testing II |
HypoTest I HypoTest II HypoTest Worksheet |
|
| Jan 17 Thursday |
Mail Merge, Equation Editor, PowerPoint
Review |
Word PPT Review |
|
| Jan 18 Friday |
No class unless we have a snow day!
|
||
| Jan 21 Monday |
Martin Luther King, Jr Day NO CLASS |
||
| Jan 22 Tuesday |
Final Exam 1:00 - 3:30pm
|