Course Information
Professor:
Email Address:
Office Location:
Strain 201
CS130
Introduction to Software Tools
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: a Statistics Software Package, Excel, Word, and PowerPoint. Class includes lab projects. Prerequisite: MATH 125 with a minimum grade of C. 2 credits.
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: a Statistics Software Package, Excel, Word, and PowerPoint. Class includes lab projects. Prerequisite: MATH 125 with a minimum grade of C. 2 credits.
Schedule:
|
|
|
|
|
Week 1 |
Aug 29 |
Syllabus Connect to Grace Course Intro Excel Intro - cells, formulas, binary operators, precedence, associativity, basic cell referencing, named cells, formatting cells, errors, functions, range of cell values, filling cells |
Syllabus Grace Intro Intro to Excel |
|
Aug 31 |
Excel functions, absolute & relative cell referencing, goal seek, importing web data, charting | Excel
Functions |
||
Sept 2 |
||||
Week 2 |
Sept 5 |
Labor Day - No Class |
||
Sept 7 |
Finish Last Lecture Go over Assign #1 |
Assign
#1 |
||
Sept 9 |
||||
Week 3 |
Sept 12 |
Intermediate
Excel | Functions | What if |
More
Functions |
|
Sept 14 | Finish Sept 12
Lecture Adv Excel | Conditional Calculations | Logical IF |
Assign #1
due |
Logical
IF |
|
Sept 16 | |
|
||
Week 4 |
Sept 19 |
|||
Sept 21 |
Go over assignment Review for exam |
Assign
#2 |
||
Sept 23 |
||||
Week 5 |
Sept 26 | Midterm |
Review |
|
Sept 28 | Excell
Regression |
Assign #2
due |
Regression |
|
Sept 30 |
||||
Week 6 |
Oct 3 |
Finish Regression Introduction to R |
R Intro |
|
Oct 5 |
Visualization with R |
R
Visualization |
||
Oct 7 |
Fall Break - No Class |
|||
Week 7 |
Oct 10 | Inferential
Statistics |
Assign
#3 |
R
Inferential |
Oct 12 | ||||
Oct 14 | ||||
Week 8 |
Oct 17 | |||
Oct 18 |
Final 6:00pm - 8:30pm |
Review |
||