CS 130 Spring 2015
Professor:
Email Address:
Office Location:
Strain 203C
Office Hours:
Mon 1:00 - 2:00pm
Wed 1:00 - 2:00pm
Fri 10:30 - 11:30am
Wed 1:00 - 2:00pm
Fri 10:30 - 11:30am
Many disciplines are finding the need to gather, manipulate, analyze, and graph data. This course will introduce students to software tools that aid in this process. Software that is widely used at Pacific includes: Excel, SPSS, Word, and PowerPoint. Class includes lab projects. Prerequisite: MATH 125 with a minimum grade of C. 2 credits.
Schedule:
| Weeks |
Date
|
Topics |
|
| Week
1 |
Jan
26 |
Syllabus Grace - connecting to grace Intro to Excel - cells, formulas, binary operators, precedence, associativity, named cells, errors |
Survey |
| Jan 28 |
Excel
functions, absolute & relative cell
referencing, filling cells, importing web data
- Class Notes |
DUE:
survey |
|
| Week
2 |
Feb
2 |
Excel
functions, importing web data, combination cell
references, trace precedents and dependents, range
of values, PMT function, payment tables, what-if
analysis, and goal seeking.
- Class Notes |
Assignment
1 |
| Feb 4 | Continue previous notes | ||
| Week
3 |
Feb
9 |
Comparison operators, IF function, logical operators (AND, OR), nested IFs - Class Notes | DUE:
Assignment 1 Assignment 2 |
| Feb 11 |
Continue
previous notes |
||
| Week
4 |
Feb
16 |
In-class
problems. Review for the midterm. |
DUE:
Assignment 2 |
| Feb 18 | Exam
during normal class time in Marsh LL12 |
||
| Week
5 |
Feb
23 |
Excel
Regression, conditional formatting - Class
Notes |
|
| Feb 25 | SPSS - setting up a dataset, descriptive statistics - Class Notes | ||
| Week
6 |
Mar
2 |
SPSS
- charting,
importing
data from Excel,
regression |
Assignment
3 |
| Mar 4 | No
Class - Professor at a conference |
||
| Week
7 |
Mar
9 |
Hypothesis Testing | |
| Mar 11 | Practice
Problems Review Problems |
DUE: Assignment 3 | |
| Mar 13 | Final Exam 6-8:30pm in Marsh LL 12 |