CS 121E Course Description				Updated : June 14, 2010
(Not offered 2010-2011)
NAME OF COURSE:		Computer Applications for Educators 
	
Course Number:	CS 121
Credits:	3
Date:			June 29, 2006

Institution: 			Clackamas Community College

Outline Developed by: 	Len Eaton

Course Description:

Computer Applications for Educators as a course provides a hands-on approach to learning the concepts of word-processing, database management, and electronic spreadsheets. Word, Excel, and Access are used.  The main goal of the class is to provide the student a balance between learning specific skills in software, with the general concept of when and how to implement those skills. 

Since the student population will consist primarily of educators, the application of these programs in creating the assignments and projects will focus on ways they are typically used in the school environment by professional educators (PK-14).

The class is offered in a lab environment. The student will use each textbook, homework assignments, interaction with the instructor and fellow students to gain insight into each of the three applications covered, as well as the generalization of techniques to other software. In addition to class lab time, expect to spend 3-6 additional hours of computer time outside of class on homework projects.

Objectives:

•	To understand the principles of word processing, data base management, and electronic spreadsheets
•	To be able to use the above mentioned applications (using, for example, the Windows versions of Word, Excel, and Access.) to accomplish specific tasks
•	To develop a feeling for the strengths and uses of certain commercial software products.

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:

GenEd
Outcome	Student Outcome	
	Format Word documents, including character, paragraph, and page formatting, borders, and tables.	
	Insert and manipulate graphics images in a document	
	Use headers, footers, footnotes, endnotes	
	Use Word editing features, including search and replace, spell check, inserting symbols	
	Enter appropriate and correct text, values, formulas, and functions in Excel worksheets.	
	Copy and move spreadsheet data and formulas.	
	Manipulate columns and rows in Excel, including inserting and deleting columns and rows, changing column widths and row heights.	
	Format text and numbers in Excel, including character formatting, borders, color.	
	Use statistical functions, absolute cell references, and IF functions in a worksheet.	
	Create charts in Excel.	
	Design and create a table in Access..	
	Add, delete, and edit records in an Access table.	
	Create a form and a report in Access.	
	Perform simple and complex queries on Access tables and linked tables.	
	Perform statistical and field calculations in an Access query.	

Length of Course:

	One quarter with 3 class hours per week plus a two-hour comprehensive final for a total of 32 contact hours.

Grading Method:

	Grade/PN/Audit

Required Text(s):

•	Word 2003, Introductory Concepts and Techniques, by Shelley, Cashman, Course Technology
•	Excel 2003, Introductory concepts and Techniques, by Shelley, Cashman, Quasney, Course Technology
•	Access  2003,, Introductory concepts and Techniques, by Shelley, Cashman, Pratt, Course Technology

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 121 Course Outline
	Hours 

I.	Review of concepts in hardware, software, and Windows	1

II.	Word Processing	8
	A.	Text creation and editing
		1.	Deleting, inserting, scrolling, word wrap
		2.	Spell Checker
		3.	Block copy and Move
		4.	Search and Replace
	B.	Text formatting
		1.	Fonts
		2.	Margins, Justification
		3.	Alignment of text
		4.	Headers, Footers, and Page numbering
		5.	Tables
	C.	Saving, Opening, and Closing documents
	D.	Printing documents
	E.	Advanced features
		1.	Drawing lines
		2.	Using Graphics
		3.	Sorting
	
III.	 Electronic Spreadsheet	9
	A.	Entering and editing data and formulas
		1.	Entering and aligning labels
		2.	Entering values, formulas, and functions
		3.	Using absolute cell references
		4.	Changing column widths
		5.	Inserting and deleting rows and columns
		6.	Copying and moving cells and blocks of cells
	B.	Formatting a worksheet
		1.	Numeric format
		2.	Fonts
		3.	Lines and shading
	C.	Saving, Opening, and Closing worksheets
	D.	Printing worksheets
	E.	Creating bar, line, and pie graphs

IV.	Database Management	10
	A.	Creating and editing a table
		1.	Defining and revising the structure of a table
		2.	Defining Key fields
		3.	Entering and editing data in a table
		4.	Inserting and deleting records in a table
	B.	Querying a table
		1.	Using query by example
		2.	Using the operators or, not, like, and
		3.	Creating a query which links two tables
	C.	Creating reports by modifying a Quick report

V.	Exams and Review	4

Total	32