Department/Grade:   Business Education                                        Course: Computer Applications                               

Revision Date:  April, 2008               Required/Elective:     Required         Course Length: One Year

Prerequisite: None

Course Description:

During the first semester, students will strengthen their keyboarding skills for personal and business use; review and reinforce the alphabet, number keys, symbols and their applications; increase their speed and accuracy using proper techniques; and develop skills to include arranging, placing, and spacing copy in the formatting of personal business and business letters, memos, reports, and tables.  Report formatting will be taught including one-page, two-page, as well as multi-page documents with thesis statements, outlines, citations, and reference pages in the MLA style as required by all classes.

During the second semester, students will receive an overview of Microsoft Excel, Access, and PowerPoint. Students interested in these areas are then encouraged to take the full-year course.

COURSE OBJECTIVES	CONTENT/TIMELINE OUTLINE
Students will demonstrate proficiency on alphabetic keys.	Alphabetic skill building lessons Block paragraphs Touch keyboarding Speed drills Timed writings
Students will demonstrate proficiency on numerical keys.	Numerical skill building lessons Block paragraphs Touch keyboarding Speed drills
Students will demonstrate proficiency on symbols keys.	Symbols skill building lessons Block paragraphs Touch keyboarding Speed drills
Students will learn to find and correct errors.	Proofreading exercises Proofreading paragraphs Proofreading handouts Analyze documents for mailability/accuracy
Students will be able to format memorandums in correct format.	Simplified memos Standard memos
Students will be able to format letters in correct format.	Personal business letters Regular business letters Letterhead Block style letters Rough-draft letter copy Form letters
Students will be able to format and arrange simple tables in correct format.	Two-column tables Three-column tables

Students will be able to format reports using MLA style.	Arranged MLA style reports Semi-arranged MLA style reports Rough-draft MLA style reports Compose MLA style reports Research reports
Students will be able to demonstrate knowledge and use the basic introductory features of Microsoft Access.	Create and use a database Create and use a database table Create various fields Create various records Create and use a simple query Create and use a simple form Develop ability to add/delete records Merge tables with letters in Microsoft Word
Students will be able to demonstrate knowledge and use the basic introductory features of Microsoft Excel.	Format a worksheet Differentiate between text and values Create a 3-D clustered chart Use a variety of methods to correct errors Copy ranges of cells Use basic formulas Use AutoSum Apply various functions Display formulas version of worksheet Display values version of worksheet
Students will be able to demonstrate knowledge and use the basic introductory features of Microsoft PowerPoint.	Customize PowerPoint slide shows Use single-bulleted lists Use multi-level bulleted lists Add animation schemes to PowerPoint slide shows Add clip art to PowerPoint slide shows
RESOURCE MATERIALS	ASSESSMENT
Century 21 Keyboarding & Information Processing South Western Publishing Co. Microsoft Office Access 2002 and/or 2003 Shelly Cashman Series Microsoft Office Excel 2002 and/or 2003 Shelly Cashman Series Microsoft Office PowerPoint 2002 and/or 2003 Shelly Cashman Series	Quizzes Tests Memo hard copies Letter hard copies Table hard copies Report hard copies Database hard copies Spreadsheet hard copies PowerPoint slide shows