Williamsfield Curriculum Mapping Computer Applications

Williamsfield School District #210

Curriculum Map 2007-2008

Naslund, Ruby / Computer Applications / High School / Grades 10-12

Month

Content

August	Review Word Basics Identifying Part of the Opening Screen Understanding Document Views Text Entry and Word Wrap Navigating Through a Document Saving a Document Opening an Existing Document Previewing Your Document Selecting a Page Orientation Printing Your Document Review Basic Editing Selecting Text Viewing Hidden Characters Using the Backspace and Delete Keys Using Overtype Using Undo and Redo Moving and Copying Text Using Find and Replace Using the Word Count Command
September	Helpful Word Features Automatic Features AutoCorrect AutoFormat As You Type Auto Text Auto Complete Automatic Spell Checking Automatic Grammar Checking Using the Spelling and Grammar Checker Inserting the Date and Time Using the Thesaurus Inserting Symbols Formatting Text Changing the Font, Style, Size, and Color Changing Underline Style and Color Changing Font Effects Highlighting Copying Format and Style Applying Styles Character Spacing Formatting Paragraphs and Documents Setting Margins Aligning Text Changing Indents Adjusting Line and Paragraph Spacing Changing Vertical Alignment Setting Tab Stops Bulleted and Number Lists Outline Numbered List Organizing a Document in Outline View Working with Graphics Creating Columns Adding Borders and Shading Paragraphs Inserting Clip Art Adding Borders to Pages Drawing Graphics Creating Diagrams and Charts
October	Working with Documents Inserting Page Breaks Inserting Headers and Footers Showing and Hiding White Space in a Document Splitting Windows Creating Section Formatting Using the Research Tool Using AutoSummarize Inserting and Formatting Tables Formatting and Revising a Table Modifying Table Structure Borders and Shading Converting Text into Tables Table AutoFormat Sorting Text in a Document Increasing Efficiency Using Word Using Templates Using Wizards Using Mail Merge Creating and Printing Envelopes Creating and Printing Labels Sending a Document by E-mail Workgroup Collaboration Compare and Merge Documents Inserting Hyperlinks in Documents Creating a Web Page Inserting Hyperlinks in Web Pages Excel Basics Starting Excel Opening and Existing Workbook Moving the Highlight in a Worksheet Selecting a Group of Cells Entering Data in a Cell Changing Data in a Cell Searching for Data Using Zoom View Saving a Workbook Printing a Worksheet Changing the Appearance of a Worksheet Changing the Size of a Cell Positioning Text Within a Cell Changing Cell Appearance Cell Formats Organizing the Worksheet Copying Data Moving Data Inserting and Deleting Rows and Columns Freezing Titles Splitting Workbook Screens Printing Options Checking Spelling on a Worksheet
November	Worksheet Formulas Structure of a Formula Editing Formulas Relative, Absolute, and Mixed Cell References Creating Formulas Quickly Previewing a Calculation Formula Helpers Function Formulas Parts of Function Formulas Types of Functions Making the Worksheet Useful Sorting Data AutoFilter Hiding Columns and Rows Using the Drawing Tools Adding a Picture to a Worksheet Using Templates Inserting Hyperlinks Saving Workbooks in a Different Format Viewing and Editing Comments Using the Research Tool Working with Multiple Worksheets Worksheets in a Workbook Identifying Worksheets Positioning Worksheets in a Workbook Consolidating Workbook Data Printing a Workbook Working with Multiple Workbooks
December	Worksheet Charts Types of Worksheet Charts Creating a Chart from Worksheet Data Creating an Embedded Chart Creating Other Types of Charts Excel Unit Review and Simulation
January	Access Basics Database Basics Opening a Database Creating a Database Manipulating Data Editing Records Changing Datasheet Layout Changing Field Properties Creating and Modifying Forms Creating Forms Modifying Forms Working with Calculated Controls Working with Hyperlinks Compacting and Repairing a Database Finding and Ordering Data Using Find Using Queries Sorting Indexing Setting a Primary Key Relationships Creating a Multiple Query Reports and Macros Reports Macros
February	Integrating Access Importing and Exporting Data Form Letters Data Access Pages PowerPoint Basics Introduction to PowerPoint Starting PowerPoint Opening and Viewing an Existing Presentation Saving a Presentation Changing Views Using Menus and Toolbars Deleting Slides Printing a Presentation Closing a Presentation and Exiting PowerPoint Creating and Enhancing PowerPoint Presentations Creating a Presentation Applying a Design Template Formatting a Single Slide Using a Slide Master Editing a Picture in PowerPoint Working with Text Check Spelling, Style, and Usage Adding Slides Deleting Placeholders and Text from Slides Formatting Slides Working with Clip Art Custom Animation Adding Sound Insert a Hyperlink Use Slide Transitions Saving a Presentation as Rich Text Format
March	Working with Visual Elements Working with Organization Charts Working with Tables Creating Shapes and Objects Manipulating Objects Creating a Text Box Ordering Visual Elements Working with Multiple Presentations Inserting Objects on a Slide Adding a Header or Footer Expanding on PowerPoint Basics Integrating PowerPoint with Other Office Programs Working with Multiple Masters Formatting Text and Objects Aligning Text and Pictures Delivering a Presentation Publishing Presentations to the Web Sending a Presentation via E-mail Publisher Basics Introduction to Publisher Starting Publisher Starting a Project Using Task Panes Personal Information Sets Saving a Publication Adding a Logo Printing a Publication Closing a Publication Design Sets Other Types of Publications
April	Enhancing Publisher Documents Enhancing Your Publisher Documents Beginning a Brochure Entering Text Adding Design Gallery Objects and Adding Color Inserting Pictures Creating a Newsletter Inserting Text from a Word Document Publisher Unit Review and Simulation Learn to use Photo Story Program Photoshop Elements Introduction to the Work Area Auto Levels—Histogram Quick Fix Feature Grayscale Borders Pixels and Size Borders Learn to Use Selection Tools Shapes and Layers Creating Shadows
May	Continue with Photoshop Elements Animations Restoration of Photos Swirl Introduction to Sqirlz Water Reflections, Gimp, and Picasa2 Programs Basic Introduction to Dreamweaver Program