Microsoft Word
1.
Using Microsoft Word I can perform the following basic operations to create Word documents: start/quit, open/close, display formatting marks, edit/select/move text, undo/redo, print preview/print, and save documents.
2.
I can create a document and format/modify text with the following: font type, font size, bold, italics, underline, superscript, and subscript.
3.
I can use the following Word features: spelling and grammar check, help, thesaurus, AutoCorrect, Office Clipboard, find/replace, word count, AutoText
4.
I can insert and format the following: headers/footers, page numbers, manual page breaks, indented paragraphs (first-line and hanging indents), hyperlinks, and tab stops.
5.
I can create, edit, and format a table.
6.
I understand the default line spacing in Word and can modify the line spacing before and after paragraphs.
7.
I can identify and utilize the various components of the Word window: Ribbon, Quick Access toolbar, shortcut menus, and Quick Access Toolbar.
8.
I can insert a hyperlink and convert to regular text.
9.
I can insert, format, reposition, change layout options and resize pictures, clip art, and symbols.
10.
I can prepare a research paper and follow proper guidelines using the Modern Language Association of America (MLA) documentation style.
11.
I can create a business letter with a letterhead.
12.
I can apply predefined styles that appear in the Styles gallery on the Ribbon.
13.
I can customize and reset Word options and change document properties.
Microsoft Excel
14.
Using Microsoft Excel I can perform the following basic operations: enter, edit, and format text and numbers by changing the font type, font size, font color, fill color, and use the format painter to copy formatting from one location to another.
15.
I can enhance the visual display of a worksheet by adding styles, themes, borders, rotate text, center cell entries across columns by merging cells, and add conditional formatting to a range of cells.
16.
I can create and enter formulas using the keyboard and point mode, use AutoSum, use the range finder to verify a formula, and display the formulas version of the worksheet.
17.
I can use built-in functions to perform common calculations on data and use the Auto Calculate area to display statistics.
18.
I understand the difference between absolute and relative cell references.
19.
I can use What-If Analysis and Goal Seek to analyze worksheet data.
20.
I can use the fill handle to create a series, and copy a formula to adjacent cells.
21.
I can insert and format charts such as pie/column/Sparkline charts.
22.
I can adjust row heights and column widths, insert and delete rows and columns, and freeze column and row titles.
23.
I can change a worksheet name and add color to the worksheet tab.
24.
I can set margins, add headers and footers, change the worksheet orientation, save a workbook, print preview a worksheet, print a worksheet or a section of a worksheet, and change document properties.
Microsoft Access
25.
Using Microsoft Access I can design and create a new database.
26.
I can create a table in datasheet or design view, identify the primary key, define the fields in a table, add/delete records, import records to a table, save, print preview, and print the contents of a table.
27.
I can create a query using the simple query wizard or create a query in design view and add criteria to a query including text data, numbers, comparison operators, a wild card, and compound criteria to search for information in a database.
28.
I can sort data in a query, join tables, use calculated fields, and print query results.
29.
I can create and save a form, enter records using the form, and print the form.
30.
I can create custom reports, modify column headings, resize columns in print layout view, add totals to a report, and print the report.
31.
I can customize the navigation pane, change database properties, and compact and repair a database.
32.
I can maintain a database by adding, changing, deleting, and filtering records.
33.
I can change the structure of a database by adding a new field, deleting a field, resizing columns, and changing field size.
34.
I can create validation rules such as specifying a required field, specifying a range, specifying a default value, and specifying a collection of legal values.
35.
I can use single-valued and multi-valued lookup fields.
36.
I can update forms and reports to reflect changes to the table structure.
Microsoft PowerPoint
37.
Using Microsoft PowerPoint I can create a new slide show presentation.
38.
I can choose a document theme to provide consistency in design and color throughout the presentation by setting the color scheme, font set, and layout of a presentation.
39.
I can create slides, including a title slide and a text slide with a multi-level bulleted list, add new slides, and change slide layouts.
40.
I can insert Clip Art and photographs into slides.
41.
I can add a picture style, add a border, add and resize shapes, apply a shape style, and use WordArt.
42.
I can format a slide background, using a solid color, gradient color, or a picture or texture.
43.
I can add a shadow to text to help letters display prominently.
44.
I can add animation effects, special visual and sound effects, and apply to text or content.
45.
I can add a slide transition, a special animation effect, used to progress from one slide to the next.
46.
I can format pictures by re-coloring and adding artistic effects.
47.
I can change from normal view to slide sorter view to check slides for balance and consistency.
48.
I can add media to slides by inserting a video file and an audio file, and run a slide show with media.
49.
I can change document properties.
50.
I can add notes to a slide in the notes pane, preview and print a handout, save, and close the presentation.