Course Information

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.

Schedule:

	Date	Topics	Homework & Assignments	Notes
Week 1	Aug 28	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 30	Excel functions, absolute & relative cell referencing, goal seek, importing web data, charting		Excel Functions
	Sept 1
Week 2	Sept 4	Labor Day - No Class
	Sept 6	Finish Last Lecture Go over Assign #1	Assign #1
	Sept 8
Week 3	Sept 11	Intermediate Excel | Functions | What if		More Functions
	Sept 13	Finish Sept 12 Lecture Adv Excel | Conditional Calculations | Logical IF	Assign #1 due	Logical IF I
	Sept 15
Week 4	Sept 18	Regression Intro		Logical IF II Lindear Regression
	Sept 20	Go over assignment Review for exam	Assign #2
	Sept 22
Week 5	Sept 25	Midterm		Review
	Sept 27	Excell Regression Intro to R		Nonlinear Regression R Intro Part A
	Sept 29
Week 6	Oct 2		Assign #2 due	R Intro Part B
	Oct 4	Visualization with R		R Visualization
	Oct 6	Fall Break - No Class
Week 7	Oct 9	Inferential Statistics	Assign #3	R Inferential
	Oct 11	Finish Inferential Lecture
	Oct 13
Week 8	Oct 16	Mail Merge / Review		Mail Merge
	Oct 17	Final 6:00pm - 8:30pm		Review