CS 130 Schedule
Date
|
Topic
|
Notes
|
Assignments
|
Jan 7 Monday |
Questionnaire |
Software Tools Introduction to Excel cells, formulas binary operators, precedence associativity, named cells, errors |
Introduction Excel |
|
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 Sample Spreadsheet |
Jan 10 Thursday |
In class problems
In class problems |
Problems |
|
Jan 11 Friday |
Review
Midterm |
Midterm Review | |
Jan 14 Monday |
Regression R! Swirl! (how to install R) |
||
Jan 15 Tuesday |
Continue with R
Visualization with R |
Visualization mtcars mtcars - data Data Manipulation |
|
Jan 16 Wednesday |
Hypothesis Testing with R
|
Hypothesis Testing | Assignment 3 |
Jan 17 Thursday |
Equation Editor
Review |
Word Review |
|
Jan 18 Friday | Office Hours/Snow Day Makeup | ||
Jan 21 Monday |
Martin Luther King Day (no courses held)
|
||
Jan 22 Tuesday |
Final Exam 1:00 - 3:30pm |