CS 121 Course Description (Not offered 2010-2011)

Course Title:		Computer Applications 	Updated: June 14, 2010
Course Number:	CS 121
Credits:		3

Institution: 			Clackamas Community College
Outline Developed by:	Brenda Herman

Course Description:

	A hands-on approach to learning the concepts of word processing, database management and electronic spreadsheets.

Objectives:

•	To understand the principles of word processing, electronic spreadsheets, and database management
•	To be able to use the above mentioned applications (using the Windows 2007 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:

•	Format Word documents, including character, paragraph, and page formatting, borders, and tables.
•	Insert and manipulate graphics images in a document.
•	Use headers, footers, footnotes, and endnotes
•	Use Word editing features, including search and replace, spell check, and 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, and 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.

Prerequisite:

	CS 120 and Math 60

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:

	Word 2007, Introductory Concepts and Techniques, by Shelley, Cashman, Vermaat, Course Technology
	Excel 2007, Introductory concepts and Techniques, by Shelley, Cashman, Quasney, Course Technology
	Word 2007, 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 charts

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