|
Customized Office Skills Training (C.O.S.T) Curriculum
MS Word – Introduction · Word Basics o Introduction to word processing o Identifying parts of the opening screen o Understanding document views o Text entry and word wrap o Navigating through a document o Saving a document o Locating and opening an existing document o Zoom view o Full screen view o Previewing a document o Selecting a page orientation o Printing a document o Basic Editing o Selecting text o Viewing hidden characters o Using the backspace and delete keys o Using overtype o Using undo and redo o Moving and copying text o Using find and replace o Using the word count command o Helpful Word Features o Automatic features o AutoCorrect o AutoFormat as you type o AutoText o AutoComplete o Automatic spell checking o Automatic grammar checking o Using the spelling and grammar checker o Inserting the date and time o Using the thesaurus o Inserting symbols
· Formatting Text o Changing the font, style, size, and color o Changing underline style and color o Changing font effects o Highlighting o Copying format and style o Applying styles o Character spacing o Formatting Paragraphs and Documents o Set the margins of a document o Align text o Adjust indents and line spacing o Change vertical alignment o Set and modify tabs o Apply bullet and numbering formats o Create and outline numbered list o Organize a document in outline view o Working with Graphics o Format text into columns o Add borders and shading o Insert and scale clip art o Wrap text around graphics o Draw Object o Select, resize, cut, copy, and paste objects o Change the appearance of objects o Add text to drawings o Create and modify diagrams o Working with Documents o Insert page breaks o Insert headers and footers o Show and hide white space o Split windows o Create a section with formatting that differs from other sections o Use the research tool o Use AutoSummarize o Insert and format tables o Convert text into tables o Sort text
· Increasing Efficiency Using Word o Create and use templates o Use wizards o Use mail merge o Create and print envelopes and labels o Send documents by e-mail o Insert, view, and edit comments o Track changes o Compare and merge documents o Save a document as a Web page and apply a theme Insert hyperlinks in documents and Web pages
MS Excel – Introduction · Excel Basics o What is Excel o Starting Excel o Opening and existing workbook o Moving the highlight in a worksheet o Selecting a group of cells o Entering data in a cell o Changing data in a cell o Searching for data o Using zoom view o Saving a workbook o Printing a worksheet
· Changing the Appearance of a Worksheet o Changing the size of a cell o Positioning text within a cell o Changing cell appearance o Cell formats o Organizing the Worksheet o Copying data o Moving data o Inserting and deleting rows and columns o Freezing titles o Splitting workbook screens o Printing options o Checking spelling on a worksheet o Worksheet Formulas o What are formulas o Structure of a formula o Editing formulas o Relative, absolute, and mixed cell references o Creating formulas quickly o Previewing a calculation o Formula helpers o Function Formulas o Parts of function formulas o Types of functions o Making the Worksheet Useful o Sorting data o AutoFilter o Hiding columns and rows o Using the drawing tools o Adding a picture to a worksheet o Using templates o Inserting hyperlinks o Saving workbooks in a different format o Viewing and editing comments o Using the research tool o Working with Multiple Worksheets o Worksheets in a workbook o Identifying worksheets o Positioning worksheets in a workbook o Consolidating workbook data o Printing a workbook o Working with multiple workbooks
· Worksheet Charts o What is a worksheet chart o Types of worksheet charts o Creating a chart from worksheet data o Creating an embedded chart Creating other types of charts
· Getting Started with PowerPoint o Defining presentation software o Starting PowerPoint o Viewing the PowerPoint window o Using the AutoContent wizard o Viewing a presentation o Saving a presentation o Getting help and researching information o Printing and closing the file and exiting PowerPoint o Creating a Presentation o Planning an effective presentation o Entering slide text o Creating a new slide o Entering text in the outline tab o Adding slide headers and footers o Choosing a look for a presentation o Checking spelling in a presentation o Evaluating a presentation o Modifying a Presentation o Opening an existing presentation o Drawing and modifying an object o Editing drawn objects o Aligning and grouping objects o Adding and arranging text o Formatting text o Importing text from MS Word o Customizing the color scheme and background o Enhancing a Presentation o Inserting clip art o Inserting, cropping, and scaling a picture o Embedding a chart o Entering and editing data in the datasheet o Formatting a chart o Creating tables in PowerPoint o Using slide show commands o Setting slide show timings and transitions o Setting slide animation effects
· Customizing a Presentation o Understanding PowerPoint masters o Formatting master text o Changing master text indents o Adjusting text objects o Using advanced drawing tools o Using advanced formatting tools o Insert and format WordArt o Creating a template o Enhancing Charts o Inserting data from a file into a datasheet o Formatting a datasheet o Changing the chart type o Changing chart options o Working with chart elements o Animating charts and adding sounds o Embedding an organization chart o Modifying an organization chart o Working with Embedded and Linked Objects and Hyperlinks o Embedding a picture o Embedding an Excel chart o Linking an Excel worksheet o Updating a linked Excel worksheet o Inserting an animated GIF file o Inserting a sound o Inserting a hyperlink o Creating a photo album o Using Advanced Features o Sending a presentation for review o Combining reviewed presentations o Setting up a slide show o Creating a custom show o Rehearsing slide timings o Publishing a presentation for the web o Packaging a presentation o Broadcasting a presentation
MS Access · Introduction to Access o Introduction to database concepts o Opening an existing database o Opening an Access table o Printing a table o Exiting Access o Creating and printing a query o Creating and printing a form o Getting help o Creating, previewing and printing a report o Compacting a database o Maintaining a Database o Guidelines for designing databases o Guidelines for designing Access tables o Creating a tableAdding records to a table o Saving a database o Modifying the structure of an Access table o Copying records from another Access database o Updating a database o Querying a Database o Introduction to queries o Query window o Creating and running a query o Defining table relationships o Sorting data in a query o Filtering data o Defining record selection criteria for queries o Defining multiple selection criteria for queries o Creating Forms and Reports o Creating a form using the form wizard o Changing a form’s auto format o Navigating a form o Finding data using a form o Previewing and printing selected form records o Maintaining table data using a form o Creating a form with a main form and a sub form o Creating a report using the report wizard o Inserting a picture in a report o Converting an Access 2000 database to a previous version
· Creating More Advanced Queries and Custom Forms o Creating a lookup wizard field o Displaying related records in a subdatasheet o Using the input mask wizard o Using a pattern match in a query o Using a list-of-values match in a query o Creating a custom form o Selecting and moving controls o Changing a label’s caption o Resizing controls o Using form headers and form footers o Changing the background color of a form object o Creating a multi-page form using tab controls o Using a filter with a form o Customizing Reports and Integrating Access with Other Programs o Creating a custom report o Report window in design view o Adding fields to a report o Working with controls o Adding the date to a report o Adding page numbers to a report o Adding a title to a report o Adding lines to a report o Defining conditional formatting rules o Sorting and grouping data in a report o Calculating group totals and overall totals o Hiding duplicate values in a report o Integrating Access with other programs o Embedding a chart in a report o Linking a word document in a report o Exporting an access query as an Excel worksheet o Working with HTML Documents, Data Access Pages, and Hyperlink Fields o Using the Web o Creating a data access page for an Access table o Sorting and filtering data access page records o Creating hyperlinks to World Wide Web pages
MS Publisher · Creating and Editing a Publication o What is MS Publisher o Starting and customizing Publisher o Creating a publication o The publisher window o Speech recognition o Entering text o Saving a new publication o Using graphics o Moving and resizing objects o Saving an existing publication with the same file name o Printing a publication o Quitting Publisher o Opening a publication o Modifying a publication o Creating a Web Page from a publication o Publisher help system o Designing a Newsletter o Designing a newsletter o Editing the newsletter template o Editing the masthead o Importing files o Saving an intermediate copy of the newsletter o Working with personal information sets o Editing sories in MS Word o Editing the design set o WordArt o Using graphics in a newsletter o Adding page numbers to the master page o Checking a newsletter for errors o Checking the newsletter for design errors
· Publishing a Tri-Fold Brochure o Creating a tri-fold brochure o Custom color schemes o Replacing text o Font scheme styles o Formatting fonts and paragraphs o Using photographs and images in a brochure o Creating a logo from scratch o Outside printing o Packaging the publication for the printing service o Personalizing and Customizing Publications with Information Sets o Creating letterhead from scratch o Using layout and ruler guides o Personal information sets o Searching for and editing photographs o Using the measurement toolbar o Creating the lower portion of the letterhead o Using an automatic date o Business cards o Envelopes o Using the mail merge feature o Web sites o Creating Business Forms and Tables o Creating invoices o Creating styles o Using a drop cap o Working with tabs and markers o Coupons o BorderArt o Custom-size publications o Using tables o Calendar Web pages o Creating a Web Site o Creating a Web page from scratch o Form controls o HTML code fragments |
