Nicole Cook	CS 61.11A	Section # 2945
Fall 2014	Course Syllabus	Office Maggini #2941
email: Ncook@santarosa.edu	Tuesday 9:00 am - 12:20 pm	Phone: 527-4999 x5221
	Maggini 2803

This class is designed to teach someone with no spreadsheet experience the basics of how to use a spreadsheet. This class will give students the introductory experience needed for more advanced spreadsheet classes.

Week	Topic	Reading Assignment	Online Quiz Each quiz will be available for 1 week only and then unavailable after that time !!	Lab Assignment
Week 1	Windows 7, Microsoft Office, Basic Excel Navigation, File Management, The Ribbon	Win 7 & Office 2010 Chapter	Quiz 1	Lab 1
Week 2	Basic Spreadsheet Data Entry, Fill Command, Formatting, Using Charts	Chapter 1	Quiz 2	Lab 2
Week 3	Formulas, Functions and Formatting	Chapter 2	Quiz 3	Lab 3
Week 4	Embedded Functions and the IF Statement	Chapter 3	Quiz 4	Lab 4
Week 5	Financial Functions, Data Tables, and Amortization Schedules	Chapter 4	Quiz 5	Lab 5
Week 6	VLOOKUP, Sort, Query	Chapter 5	Quiz 6	Lab 6
Week 7	Multiple Worksheets and Workbooks	Chapter 6	Quiz 7	Lab 7
Week 8	All You Have Learned	None	None	Final Project

Required Materials

The Book - Microsoft Excel 2010 Comprehensive. Shelly Cashman Series Course Technology - CENGAGE Learning

Grading Policy:

1. The computer lab assignments make up 60.0% of the course grade.

2. The quizzes make up 20.0% of the course grade.

2. The Final Project makes up 20.0% of the course grade.

3. All labs are due 1 week after they are assigned.

4. Reading assignments should be completed before the class they are listed on.

Return to CS 61.11A Class Links