CS 91 Course Description

Course Title:	Computers for New Users II 	
Course Number:	CS 091 				Revised:  June 8, 2010
Credits:		2					

Institution: 			Clackamas Community College
Outline Developed by: 	Originally developed by Linda C. Anderson
				Subsequent revisions by Len Eaton

Course Description:

This is a follow-up of CS090. More work with applications, including word processing, spreadsheet, and file management.  Takes place in the computer lab, one student to a computer.  This course meets the computer literacy requirement.

Prerequisite: 	Pass CS090 or equivalent experience.

Expected Student Outcomes: 
The defined outcomes listed in this guide are stated in terms of what the student should expect to be able to do after completing this course successfully. 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 should expect to be able to:

I.	Create and edit documents with Microsoft Word (8C)
	A.	Open, close, and save documents
	B.	Navigate through documents
	C.	Edit and select text
	D.	Find and replace text
	E.	Move and copy text
	F.	Use Spelling and Grammar Checker
	G.	Format text with fonts, bold, italicize, underline
	H.	Format paragraphs with alignment, indenting, spacing
	I.	Create bulleted and numbered lists
	
II.	Work with spreadsheets using Microsoft Excel (8C)
	A.	Navigate through worksheets and workbooks
	B.	Open, close, and save workbooks and worksheets 
	C.	Enter data, formulas, and functions
	D.	Use AutoCalculate, AutoSum, and AutoFill
	E.	Insert and delete cells, columns, rows
	F.	Copy and move data
	G.	Format worksheets with font and numeric formats
	H.	Set column width and row heights
	I.	Set print options, including headers and footers, page and margin settings

II.	Windows Explorer
	A.	Navigate through drives and folders to find files 
	B.	Create folders and copying files to the folders
	C.	Start Applications
	D.	Copy, move, rename, and delete folders and files

Length of Course:

	Five weeks, with 4 in class hours a week, 4 hours in lab, or 10 weeks, with 2 in class hours a week

Grading Method:

	The course is taken with a grade of Pass/No Pass.  Students may do a project to get a letter grade for the class.

Required Text:

CS 91 - Computers for New Users II Student Workbook, December 2009

Library and Information Resources

Use of library and information resources is integrated into Computer Science Certificate and degree programs in general education requirements and in Computer Science classes as relevant to the curriculum.  Use of library and information resources is encouraged, and students can access a variety of program-approved materials via the library’s web-based electronic databases and print materials.  Instruction in use of the library and information resources is available to all students.

	CS 91 Course Outline
	Hours

I.	Word Processing with Microsoft Word 	7
	A.	Opening, closing, and saving documents
	B.	Navigating through documents
	C.	Editing and selecting text
	D.	Finding and replacing text
	E.	Moving and copying text
	F.	Using Spelling and Grammar Checker
	G.	Formatting text with fonts, bold, italicize, underline
	H.	Formatting paragraphs with alignment, indenting, spacing
	I.	Creating bulleted and numbered lists
	J.	Applying borders and shading

II.	Working with Spreadsheets Using Microsoft Excel	7
	A.	Navigating through worksheets and workbooks
	B.	Opening, closing, and saving workbooks and worksheets 
	C.	Entering data, formulas, and functions
	D.	Using AutoCalculate, AutoSum, and AutoFill
	E.	Inserting and deleting cells, columns, rows
	F.	Copying and moving data
	G.	Formatting worksheets with font and numeric formats
	H.	Setting column width and row heights
	I.	Simple formulas, AutoSum, Sum function
	J.	Setting print options, including headers and footers, page and margin settings

II.	Windows Explorer	3
	A.	Navigating through drives and folders to find files 
	B.	Creating folders and copying files to the folders
	C.	Starting Applications
	D.	Copying, moving, renaming, and deleting files

IV.	Review 	1
	
V.	Written and hands-on exam	2

Total 	20