Course Information
Professor:
Email Address:
Office Location:
Strain 203C
Office Hours:
Mon, Tues 10:30 - 11:30am
Thu 1:30-2:30pm
Thu 1:30-2:30pm
Many disciplines are finding the need to gather, manipulate, analyze, and graph data. This course will introduce students to software toolsthat aid in this process. Software that is widely used at Pacific includes: Excel, SPSS, Word, and PowerPoint. Class includes labprojects. Prerequisite: MATH 125 with a minimum grade of C. 2 credits.
Schedule:
|
|
|
|
|
| Week
1 |
Aug 25 | Welcome Turing Software Tools Intro to Excel - cells, formulas, binary operators, precedence, associativity, named cells, errors |
Connecting
to grace Software Tools Intro to Excel |
Assignment
0: Questionnaire DUE Wednesday, August 20 at 2:15pm |
| Aug
27 |
Excel
functions, absolute & relative cell referencing,
filling cells, importing web data |
Excel functions |
||
| Week
2 |
Sept
1 |
Labor
Day - NO CLASS |
||
| Sept 3 |
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. |
Advanced Excel functions |
Assignment 1 DUE Wednesday, September 10 at 2:15pm |
|
| Week
3 |
Sept 8 | Comparison
operators, IF function, logical operators (AND, OR),
nested IFs |
Logical Operators and IF |
|
| Sept 10 | Continue
previous notes. |
Assignment 1 is
DUE Assignment 2 |
||
| Week
4 |
Sept 15 |
Excel Regression, conditional formatting | Regression |
|
| Sept 17 |
Continue
previous notes: polynomial, exponential, power, and logarithmic regression Review for the midterm. |
In-Class Problems Midterm Review |
Assignment 2 is DUE |
|
| Week
5 |
Sept 22 | Midterm | ||
| Sept 24 | SPSS - setting up a dataset, descriptive statistics | Intro to SPSS |
||
| Week
6 |
Sept 29 |
SPSS
- charting, importing data from Excel, regression |
Charting
in SPSS Regression Importing Data |
|
| Oct 1 |
Hypothesis Testing |
Hypothesis
Testing Worksheet |
Assignment 3 |
|
| Week
7 |
Oct 6 | Word:
|
Mail Merge & Equation Editor PowerPoint |
|
| Oct 8 | Review |
Final
Review |
DUE: Assignment 3 |
|
| Week 8 | Oct 13 | Final Exam - 6-8:30pm |