CS 130 Schedule

Date
Topic
Notes
Assignments
Jan 9 Monday
Grace |
Software Tools

Introduction to Excel
cells, formulas
binary operators, precedence
associativity, named cells, errors
Grace

Introduction

Excel

Jan 10 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 11 Wednesday
SNOW DAY

Jan 12 Thursday
SNOW DAY

Jan 13 Friday
SNOW DAY



Jan 16 Monday NO CLASS MLK Jr Day

Jan 17 Tuesday
SNOW DAY





Jan 18 Wednesday
Finish PMT

Comparison operators, IF function, logical operators (AND, OR)
Conditionals

New Plan!
Midterm Review
Jan 19 Thursday
Regression

In Class Problems / Review


Regression Assignment 2
Jan 20 Friday MIDTERM

Introduction to R





Packet of R Notes

Jan 23 Monday
Visualization with R
Hypothesis Testing with R



Jan 24 Tuesday

1-3:30

Continue R

In Class Assignment

In Class Assignment
(R:T Tests, Visualization)