2006-2007
Syllabai:
- Course Intro and Self Posters with digital photo(s)
Introduce chapter terms and concepts. Help students complete assignments. Teach students to use the Help function and encourage them to use it before getting instructor assistance. Provide feedback on graded assignments. Review and test using SAM when unit is complete.
- Unit 1: Creating and Editing a Word Document
Students will be able to
o Start and quit Word
o Describe the Word window
o Change the font size and type
o Enter text in a document
o Checking spelling
o Save a document
o Format text and paragraphs
o Use bold, italics, underline
o Undo and redo commands or actions
o Insert clip art
o Print
o Open a document
o Correct errors
o Use Microsoft Word Help
o Create a folder
- Unit 2: Creating a Research Paper
Students will be able to
o Change margins and line spacing
o Use a header to number pages
o Apply formatting using shortcut keys
o Indent paragraphs
o Add a footnote
o Count the words in a document
o Insert a manual page break
o Create a hyperlink
o Sort paragraphs
o Proof and revise a document
o Display Web page using a hyperlink
o Use Research task pane to locate information
o Use Help
- Unit 3: Creating a Resume Using a Wizard and a Cover Letter with a Table
Students will be able to
o Use Resume Wizard to create a resume
o Fill in a document template
o Use print preview to view and print a document
o Set and use tab stops
o Collect and paste using the Clipboard task pane
o Format paragraphs and characters
o Remove formatting from text
o Identify components of a business letter
o Insert the current date
o Create and insert an AutoText entry
o Insert a Word table, enter data in table, and format table
o Address and print an envelope
o Work with smart tags
o Modify file properties
o Use Help
- Carry out a Word review.
- Complete Word Final.
Introduce chapter terms and concepts. Help students complete assignments. Teach students to use the Help function and encourage them to use it before getting instructor assistance. Provide feedback on graded assignments. Review and test using SAM when unit is complete.
- Unit 1: Creating a Worksheet and an Embedded Chart
o Start and Quit Excel
o Describe the Excel worksheet
o Enter text and numbers
o Use AutoSum
o Copy a cell to a range of cells using fill handle
o Format a worksheet
o Create a Column chart using the Chart Wizard
o Save and print
o Open a workbook
o Use AutoCalculate area to determine statistics
o Correct errors
o Use help to answer questions
- Unit 2: Formulas, Functions, Formatting, and Web Queries
o Enter formulas using the keyboard and Point mode
o Recognize smart tags and option buttons
o Apply the AVERAGE, MAX, and MIN functions
o Verify a formula using Range Finder
o Format a worksheet using buttons and commands
o Add conditional formatting to a range of cells
o Change column width and row height
o Check spelling
o Use print preview
o Print partial or complete worksheet
o Display and print formulas version of a worksheet
o Use a Web query to get real-time data from a Web site
o Rename sheets
o Use Help
- Unit 3: What-If Analysis, Charting, and Working with Large Worksheets
Students will be able to
o Rotate text in a cell
o Create a series of month names
o Use the Format Painter button to format cells
o Copy, paste, insert and delete cells
o Format numbers using format symbols
o Freeze and unfreeze titles
o Show and format the system date
o Use absolute cell references
o Use the IF function
o Show and dock toolbars
o Create a 3-D pie chart on a separate sheet
o Color and rearrange worksheet tabs
o Change the worksheet view
o Use Goal seek
o Use Help
- Carry out an Excel review.
-
- Complete Excel Final.
Introduce chapter terms and concepts. Assist students as they complete assignments. Encourage students to use the Help function before getting instructor assistance. Provide feedback on graded assignments. Review and test using SAM when unit is complete.
- Unit 1: Using a Design Template and Text Slide Layout to Create a Presentation
o Start and customize PowerPoint
o Describe the PowerPoint window
o Select a design template
o Create a title slide & text slides with bulleted lists
o Change font size and style
o Save a presentation
o End a slide show with a black slide
o View a presentation in slide show view
o Quit and Open a presentation
o Display and print a presentation in black and white
o Use Help
- Unit 2: Using Outline Tab and Clip Art to Create a Slide Show
o Start and customize a presentation from an outline
o Add a slide and create a closing slide on the Outline tab
o Create text slides with multi-level bulleted lists on Outline tab
o Create a closing slide in outline view
o Save and review a presentation
o Insert and move clipart and change its size
o Add a header & footer to outline pages
o Animate clip art
o Add an animation scheme and run an animated slide show
o Print a presentation outline
o Use Help
- Carry out a PowerPoint review.
- Complete PowerPoint Final.
Introduce chapter terms and concepts. Assist students as they complete assignments. Encourage students to use the Help function before getting instructor assistance. Provide feedback on graded assignments. Review and test using SAM when unit is complete.
- Unit 1: Creating and Editing a Publication
o Start and quit Publisher
o Describe the Publisher window
o Edit text and graphics
o Use Best Fit feature
o Edit a synchronized object
o Replace a picture
o Resize and delete objects
o Correct spelling errors
o Save and print
o Open a publication
o Use Help
- Unit 2: Designing a Newsletter
o Edit a newsletter template
o Insert, delete, and navigate pages in a newsletter
o Edit a masthead
o Import text files and graphics
o Edit personal info components, design sets, attention getters, styles & sidebars
o Insert a WordArt object and pull quote
o Add page numbers to the master page
o Identify foreground and background elements
o Check for spelling and design errors
o Print a two-sided page
o Use Help
- Carry out a Publisher review.
- Complete Publisher Final.
Complete an integrated final project using Word, Excel, PowerPoint, and Publisher
Microsoft Access 2000 |
|
- Access Pretest
- Unit 1: Creating a Database Using Design and Datasheet Views Students will be able too Describe databases and database management systems o Start Access o Describe features of Access screen o Create a database o Create a table o Define the fields in a table o Open a table o Close a database and quit Access o Open a database o Add records to a nonempty table o Print contents of a table o Use a form to view data o Create a custom report o Use Help o Design a database to eliminate redundancy - Introduce chapter terms and concepts. Assist students as they complete assignments. Encourage students to use the Help function before getting instructor assistance. Provide feedback on graded assignments. Review and test using SAM when unit is complete.
- Carry out an Access review. - Complete Access post-test.
- Carry out a course review project/final.
- Ask students to complete a course evaluation.
|