CS 135S Course Description
Course Title: Advanced Excel 					Revised: June 8, 2010
Course Number: CS 135S
Credit: 3
Institution: Clackamas Community College
Outline Developed by: Doug Cross
Outline Revised by: Len Eaton
Course Description:
This course is a continuation of CS-121 with a focus on design, construction, and documentation of advanced spreadsheets using MS Excel. Templates, multiple worksheets, complex formulas, advanced chart features, Visual Basic macros, sorting, database capabilities. This class is also offered as an online course. 
Expected Student Outcomes: 
The defined outcomes listed in this guide are stated in terms of what the student will be able to do after completing this course. This section is a statement of final learning outcomes and does not attempt to state how, or in what order, the defined outcomes will be presented. 
After completing this course, the successful student will be expected to:
Gen  Ed	Student Outcome	
	Work with lists 	
	Enter and find data 	
	Work with ranges 	
	Analyze lists 	
	Create subtotals 	
	Work with multiple Worksheets and Workbooks 	
3A	Work with functions 	
	Use lookup table 	
	Use one and two variable data tables  	
	Create Charts 	
6C, 8B	Perform what-if Analysis 	
	Use goal seek and solver 	
	Use custom formats 	
	Create macros  	
	Use Visual Basic for Application 	
	Validate data 	
	Work with controls 	
	Integrate with other applications and the Internet 	
	Export and Import data 	
Length of Course: 
One quarter with 3 lecture hours per week. Also taught as a hybrid and fully on-line.
Prerequisite: 
CS 121
Grading Method: 
Letter grades are assigned on the standard 10% increment scale. The course may also be taken as a Pass/No-Pass.
Required Text: 
Thomson-Course Technology,  New Perspectives on Microsoft Office Excel 2007, Comprehensive, Parsons, Oja, Ageloff, and Carey, ISBN: 13-978-1-4239-0585-1
Assessment Process: 
Ten (10) continuing projects
One (1) Final capstone project
Regular tutorial quizzes, midterms and final exam
Capstone Project
The capstone project will be a comprehensive spreadsheet developed by the student for a demonstration of knowledge of the processed covered in the class. Ideally this project will be one that the student will apply to his/her own personal use. The student will have the option of using a generic scenario if they do not have a specific personal basis for the project.  

CS 135S Course Outline
 I. Introduction    
II. Using Worksheets to Make Business Decisions  
III. Creating a Worksheet 
IV. Developing a Professional-Looking Worksheet 
V. Creating Charts 
VI. Working with Excel Lists 
VII. Integrating Excel with Other Windows Programs and the World Wide Web 
VIII. Developing an Excel Application 
IX. Working with Multiple Worksheets and Workbooks 
X. Data Tables and Scenario Management 
XI. Using Solver for Complex Problems 
XII. Importing Data into Excel 
XIII. Enhancing Excel with Visual Basic 
Total 33 hours