Department/Grade:   Business Education                                                    Course: Microsoft Excel                              

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

Prerequisite: Computer Applications

Course Description:

Students will learn to enter data, process information, and display results using Microsoft Excel software.  Students will format text; use functions and formulas; create charts, graphs and tables and learn to do “What If” statements.  In addition to business students, this is an EXCELlent course for college-bound students especially in the math and science fields.  Upon successful completion of this course, students will be prepared to take the MOUS (Microsoft Office User Specialist) certification test for Microsoft Excel.

COURSE OBJECTIVES	CONTENT/TIMELINE OUTLINE
Students will be able to use the basic features of the Excel worksheet.	Text and numbers AutoSum button Copy cells/ranges Font changes/fill colors 3-D clustered column chart Error correction AutoCalculate
Students will be able to use and apply basic formulas.	Point Mode entry Keyboard entry Smart Tags Range Finder Basic addition formulas Basic subtraction formulas Basic multiplication formulas Basic division formulas AutoSum shortcuts AVERAGE function MAX function MIN function
Students will be able to apply various features of the Drawing Toolbar and other toolbars to enhance the overall appearance of the Excel worksheet.	AutoShapes Draw objects Clipart Word Art Grouped objects Text boxes Callouts AutoFormat Organization charts Diagrams Conditional formatting
Students will apply more advanced formatting to the Excel worksheet.	Create series Format painter Insert/delete cells Freeze/unfreeze worksheet Format system date Docking toolbars Manipulate appearance of various charts Assign cell names Insert data tables Insert amortization tables Insert hyperlinks Set print areas/print options Protect cells
Students will apply more advanced formulas to the Excel worksheet.	Absolute cell references Mixed cell references IF function Goal seek What-if PMT function PV function FV function
Students will create and manipulate a list.	Validate data Insert computational fields VLOOKUP function Toggle button/function Add/delete records Sort records Query a list SUMIF function COUNTIF function
Students will create and use a template.	Manipulate given templates ROUND function Format codes Customize styles 3-D cell references Find and Replace function Research task pane Link workbooks
RESOURCE MATERIALS	ASSESSMENT
Microsoft Office Excel 2003 Shelly Cashman Series	Labs/Cases/Problems Projects Quizzes Objective Tests Problem Tests