Course Objectives
and
Exam Reviews
This page was last updated: 08/24/05
In addition to the objectives listed below for Windows, Word, Excel, PowerPoint, and Access, you should be able to:
 |
Navigate to the course Web site/access course information | ||||||
|
With regard to e-mail:
| ||||||
|
With regard to WebCT:
| ||||||
|
Use the search tools/procedures provided in Galileo/Gill |
General Goals
|
Learn about the operating system Microsoft Windows and user interfaces such as Windows Explorer for file/folder management |
|
Generate/edit documents using word processing software (Word) |
|
Utilize a spreadsheet program (Excel) to organize data, create charts/reports, perform calculations, access real-time Web data, make decisions, and publish to the Web |
|
Produce professional presentations using presentation graphics software, PowerPoint |
|
Create databases and process data using a database management system (DBMS) called Access, for tasks such as queries and forms |
Mid-term Exam Review for Windows, Word, and Excel
On the mid-term exam, with regard to Windows, you should be able to:
|
| make a window active or inactive |
|
| maximize/minimize/move/resize/close a window |
|
| start Windows Explorer and be able to: |
| create new folders |
| display folder contents |
| rename file |
| display contents of folders |
| format disk |
| expand/collapse branch to display directory tree such as the C drive |
On the mid-term exam, with regard to Word 2003, you should be able to:
| format text such bolding (and color) |
| copy/paste text |
| apply bullets/numbers |
| select all of the text using the Edit/Select all feature |
| set margins/orientation |
| open/save/print/close documents |
| open/close Word |
| display document in print preview |
| set tabs |
| apply undo/redo |
| apply Format Font “effects” such as strikethrough, etc. |
| insert clipart/page break/a table |
| set line spacing/first line and hanging indent |
| find/replace text |
| utilize Thesaurus/spell check/word count |
| view contents of clipboard |
| be familiar with various document Views such as Normal and Print Layout |
| utilize the Index feature of Word Help |
On the mid-term exam, with regard to Excel 2003, you should be able to:
| start new workbook |
| name, save, open, close a workbook |
| rename workbook/worksheet |
| enter/edit text in cells, align cell contents |
| display one or more worksheets in print preview |
| set print/page orientation, margins, center on page vertically or horizontally |
| add header/footer |
| print gridlines, set/clear print area, use various print preview options such as zoom and viewing page breaks |
| apply undo and redo |
| delete cell contents/column/row/formatting |
| clear cell contents; copy to clipboard and paste from clipboard |
| delete information without saving to clipboard |
| move/copy sheet |
| apply find/replace/go to features |
| add/remove Excel toolbars |
| insert cell/row/column/worksheet/chart |
| work with Paste Function to insert date, perform calculations (such as sum and average) and other statistical information such as finding maximum and minimum |
| format cell with regard to number, alignment, font, border, pattern |
| format row/column/sheet with regard to width/height/hide/unhide |
| perform spell check |
| apply AutoCorrect, AutoComplete, AutoFormat, AutoSum |
| use AutoFill to create a series |
| utilize the AutoFit feature to automatically set column width |
| select the entire worksheet with a single action |
| navigate between worksheets; change color/font/pitch of text and objects |
| apply/remove split screen and freeze pane features |
| apply merge and center |
Final exam review for PowerPoint, Access and FrontPage:
On the final exam, with regard to PowerPoint 2003,you should be able to:
|
create/open/modify a graphic presentation |
|
print presentation in various ways, i.e., handouts |
|
navigate between various views |
|
create a new presentation in outline view |
|
add a new slide and change the layout of a slide |
|
select or change the presentation template |
|
add transitions and animation to each slide |
|
insert a graphic and animate graphic |
|
promote and demote text |
|
save/save as new document |
|
apply different views such as slide sort or slide show |
|
AutoCorrect/AutoText |
With regard to Access 2003, you should be able to:
|
create new databases, tables, forms, reports, and queries |
|
set data types |
|
open/edit/modify databases including tables, forms, reports, and queries |
|
set or edit field properties in a table |
|
enter or edit data in datasheet view |
|
navigate between and print in different views such as design or datasheet |
|
use a calculated field in a query |
|
establish “and/or” criteria in a query |
|
establish validation rule and text |
|
set the date using the Now function |
|
establish a relationship between two tables and establish referential integrity |
|
use the Wizard to create a form |
|
sort a table on one or more fields |
|
apply the find/replace command |
|
define and set the primary key |
|
set features such as orientation and margins |
|
display document in print preview |
With regard to FrontPage 2003, you should be able to:
|
create a Web site/open an existing Web site and edit |
|
save Web site to your hard drive or the campus network (H drive) |
|
create a one page Web from a template |
|
apply a theme to a Web site or Web page |
|
inset a file, insert a graphic, import pages |
|
create tasks |
|
enter text, apply paragraph styling, format text |
|
spell check the Web site page by page |
|
preview in browser and print |
|
view page Normal, HTML, and Preview modes |
|
navigate with Views Buttons: page, folder, reports, navigation, hyperlinks, and tasks |
|
create a hyperlink using text or graphic |
|
create a table, enter text, insert a graphic, edit table by merging/splitting cells, apply formatting, etc. |
