Amherst County Public Schools



(6617) Computer Applications and Internet—Pacing GuideWeek 1-Introduction to class and how to access documents and assignmentsCertification Prep—Microsoft PowerPoint 2010-Lessons 1-3Lesson 1 -Overview- Students will be able to:Describe interface of MS PowerPoint 2010; identify command buttonsRibbon-Tabs-commands and functionsOn Demand TabsRibbon Drop-Down MenusMini toolbarQuick Access ToolbarIntuitive AssistanceHelpKey Tip badgesRibbon Location Scavenger HuntIcon Name and FunctionCertification Prep, MS PowerPoint 2010, Pages 5-15Lesson 2-Start a new PowerPoint Presentation- Students will be able to:Modify text within a text box; add clip art to a slide; explain hard and soft returns; apply basic animations to objects and text; add slides to presentation; insert images; create slides from existing outline; set up slide mastersBegin a PresentationModify Text in a text boxAdd Clip artWork with Line BreaksBasic AnimationAdd SlidesInsert ImagesCreating slides from outlineUse Slide MastersCertification Prep, MS PowerPoint 2010, Pages 15-26Lesson 3-Enhancing a Basic Presentation- Students will be able to:Apply animations to objects; format clip art images; add drawing shapes and arrange shapes on slide; format WordArt; use clip art sounds; output slide show to screen and paperApply animationsFormat imagesAdd Drawing ShapesArrange shapesInsert and format WordArtAdd clip art soundsOutput slide showCertification Prep, MS PowerPoint 2010, Pages 27-34Week 2-Microsoft PowerPoint 2010 Lessons 4-6Lesson 4-Tables and Bullets- Students will be able to:Insert table on slide; set text in columns, format bullets; vertically align text on slideInsert a TableSet text in ColumnsBullet FormattingVertical Text AlignmentCertification Prep, MS PowerPoint 2010, Pages 35-37Lesson 5-Chart Templates- Students will be able to:Insert chart onto slide; format text box; modify slide background; customize chart; apply preset chart styleInsert a ChartFormat text boxModify Slide BackgroundCustomize a ChartChart StylesCertification Prep, MS PowerPoint 2010, Pages 38-42Lesson 6-Creating organizational chart using SmartArt- Students will be able to:Create organizational chart; create SmartArt from hierarchical list; modify organizational chart created from SmartArtCreate an Organizational ChartCreate SmartArtModify SmartArt Organizational ChartCertification Prep, MS PowerPoint 2010, Pages 43-46Week 3-Microsoft PowerPoint 2010-Lessons 7-10Lesson 7-Hyperlinks and Buttons- Students will be able to:Create action buttons, insert hyperlinks, and modify appearance of hyperlinksCreate action buttonsInsert hyperlinksModify appearance of hyperlinksCertification Prep, MS PowerPoint 2010, pages 47-49Lesson 8—Proofing and Publishing—Students will be able to:Add comments to slide; add annotation marks to slide; inspect document for metadata; set properties for a presentation; set PowerPoint options; publish presentation for placement on CD; print handouts from presentationAdd commentsAdd Annotation marksInspect a documentSet presentation properties and securitySet PowerPoint optionsSet publishing optionsPrint handoutsCertification Prep, MS PowerPoint 2010, pages 49-55Lesson 9-Transitions and Animations- Students will be able to:Add transitions between slides; rehearse timing; set slide show options; organize slides into sections; create custom slide showAdd slide transitionsRehearse timing of slide showSet slide show optionsCreate sectionsCreate custom slide showCertification Prep, MS PowerPoint 2010, pages 56-59Lesson 10-Graphics and Photo Albums-- Students will be able to:Add content to photo album; edit photo album; adjust images by adding effects and correctionsAdd album contentEdit photo albumAdd effects and correctionsCertification Prep, MS PowerPoint 2010, pages 60-62Week 4-GMetrix Practice for CertificationStudents log on to GMetrix—take practice test on PowerPoint 2010Week 5—MOS PowerPoint 2010 Certification ExamsWeek 6—Begin lessons on Microsoft Word 2010-Lessons 1-3Lesson 1-Basic Overview-Students will be able to:Describe the interface of Microsoft Word 2010; access help system; identify command buttonsRibbon-Tabs-commands and functionsOn Demand TabsRibbon Drop-Down MenusMini toolbarQuick Access ToolbarIntuitive AssistanceHelpKey Tip badgesRibbon Location Scavenger HuntIcon Name and FunctionCertification Prep-MS Word 2010, pages 5-15Lesson 2-Quick Tour and Features- Students will be able to:Format document page; use spell-check; copy, cut, paste text; adjust paragraph indentations; modify paragraph formatting; modify text formatting and create style; find and replace text; adjust paragraph line spacingPage formattingSpell-Checker FeaturesCopy, cut, pasteIndentations and special formattingParagraph formattingText formatting and stylesFind and replace textParagraph line spacingCertification Prep- MS Word 2010, pages 15-23Lesson 3-Images and WordArt-Students will be able to:Insert clip art; resize images; apply compression to images; insert and format WordArt Insert clip artWork with imagesUse WordArtCertification Prep, MS Word 2010, pages 24-27Week 7—Begin Lessons on Microsoft Word 2010, Lessons 4-6Lesson 4-Table Basics-Students will be able to:Insert table into Word document; format text within a table; add rows and columns; use formulas; convert table to textFormat text and cellsAdd rows and columnsUse formulasConvert table to textCertification Prep, MS Word 2010, pages 28-33Lesson 5-Lists, Colors, and Shapes—Students will be able to:Format numbered and bulleted lists; apply formatting to paragraphs and pages; create subscript text; modify colors of an image; create and manipulate drawing shapesNumbered and bulleted listsPage FormattingSubscriptsImage ColorsWork with drawing shapesText EffectsCertification Prep, MS Word 2010, pages 28-38Lesson 6-Hyperlinks, Bookmarks, and Section Breaks-Students will be able to:Insert hyperlinks into document; insert bookmarks; create section breaksHyperlinksBookmarksSection BreaksCertification Prep, MS Word 2010, pages 39-42Week 8—Begin Lessons on MS Word 2010, Lessons 7-9Lesson 7-References-Students will be able to:Add citations to document; create bibliography using automated features; create table of contents using automated featuresCitationsBibliographyTable of ContentsCertification Prep, MS Word 2010, pages 42-44Lesson 8-Page Views-Students will be able to:Display two documents simultaneously, display a document in different views; modify headers and footersView multiple documentsDocument page viewsResize headers and footersCertification Prep, MS Word, pages 45-48Lesson 9—Reviewing a Document-Students will be able to:Track changes; accept or reject tracked changes; use commentsTrack changesAccept and reject changesComment in a documentCertification Prep, MS Word, pages 49-53Week 9- Begin Lessons on MS Word 2010-Lessons 10-12Lesson 10-Backstage Tasks-Students will be able to:Set spelling and grammar options; inspect documents for metadata; specify autosave intervals; apply protection; compare two documentsSpelling and grammar optionsInspect a documentAuto RecoverProtect document and mark as finalCompare documentsCertification Prep, MS Word, pages 53-57Lesson 11-Mailings-Students will be able to:Explain a mail merge; select recipients; compose letter for mail merge; create mail mergeMail mergeSelect recipientsCompose letterComplete mergeCertification Prep, MS Word 2010, pages 57-61Lesson 12-Document Features-Students will be able to:Use sample template to create newsletter; add watermark; create blog postSample TemplatesCreate WatermarkBlog PostCertification Prep, MS Word 2010, pages 61-62Week 10-Practice Tests on GMetrixWeek 11-MOS Word Certification TestWeek 12-Begin Lessons on MS Excel 2010—Lessons 1-3Lesson 1-Basic Overview-Students will be able to:Describe the interface of Microsoft Excel 2010; access help; identify command buttonsRibbon-Tabs-commands and functionsOn Demand TabsRibbon Drop-Down MenusMini toolbarQuick Access ToolbarIntuitive AssistanceHelpKey Tip badgesRibbon Location Scavenger HuntIcon Name and FunctionCertification Prep, MS Excel 2010, pages 5-15Lesson 2-Program Layout-Students will be able to:Set vertical and horizontal alignment for cells; enter data; add headers and footers to worksheetSet cell alignmentEnter dataChange viewsAdd headers and footersCertification Prep, MS Excel 2010, pages 16-18Lesson 3—Getting Acquainted-Students will be able to:Enter data; use Auto Fill; set data type; set column width; add borders to cells; enter formulas; sort data; work with different views; print a workbookEnter dataUse Auto FillSet data typeSet column widthAdd bordersMerge cellsEnter formulasSort dataWork with various viewsPrint a workbookCertification Prep, MS Excel 2010, pages 19-25Week 13-Begin Lessons on MS Excel—Lessons 4-5Lesson 4-Data Tables-Students will be able to:Create table in Excel; add data validation; add formulas; sort data; apply combination filtering; add records to existing table; apply conditional formatting to cells; create a sparkline; sort data by hierarchical criteria; set print options across pagesCreate a tableFormat cellsData validationAdd formulasSort dataCombination FilteringAdd recordsConditional formattingAdd sparklineHierarchical sorting Print options across pagesCertification Prep-MS Excel 2010, pages 26-35Lesson 5-Using Formulas and Functions-Students will be able to:Describe how to reference other worksheets; modify existing formulas; create formula to find average of selected range; construct if..then..else logic; create advanced conditional formatting rules; explain how to hide/show columns and rows; add comments to worksheet; use find function to locate specific cells; construct formulas containing cross worksheet references; explain order of evaluationReference other worksheetsModify formulasFind averageUse IF…THEN…ELSE functionAdvanced conditional formatting rulesHide and reveal columns and rowsInsert commentsFind informationCross-worksheet formulasOrder of Evaluation Certification Prep, MS Excel 2010, pages 36-45Week 14-Begin Lessons on MS Excel 2010-Lessons 6-7Lesson 6-Using Templates, Themes, and Images-Students will be able to:Move worksheets between workbooks; organize worksheet tabs; add headers and footers to spreadsheet; customize template-based worksheets; modify images, apply themes; enter data; create CSV file, create PDF file; make page settings; create hyperlinks to websites and filesAdd worksheets from other workbooksColor-code and organize workbook tabsAdd header and footerCustomize Template-Based WorksheetsModify imagesApply themesEnter dataCSV filePDF filePage settingsCreate hyperlinksCertification Prep, MS Excel 2010, pages 46-54Lesson 7-Pivot Tables, SmartArt Graphics, and Charts—Students will be able to:Create pivot table; define a named range; use named range in formula; create chart; manipulate views in a worksheet; inspect document for hidden dataPivot table labelsDefine rangeUse named cell range in formulaSmartArt GraphicsCreate chartWork with viewsInspect documentCertification Prep, MS Excel 2010, pages 55-61Week 15-Log on to GMetrix and practice for Excel 2010 testWeek 16-MOS Certification Excel 2010Week 17-18-Projects for PowerPoint, Word, and Excel 2010Week 18-other 6617 competencies not covered to date ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download