It is important for the student to determine which level of training they need. Specific skills are covered in each level. Word, Excel, PowerPoint and Access feature three levels: Beginning, Intermediate and Advanced. Outlook is offered as one course.
Choose from the course descriptions below.
Access Beginning Objectives
Upon the completion of the Beginning Access class participants, will be able to:
- Start Microsoft Access and create a new blank database or open previously prepared database.
- Identify the menu, task panes, toolbars and objects of the MS Access window.
- Create a Table using both the wizard and the design view.
- Given a Table be able to add and change the primary key.
- Add a field to a Table and change the properties of a previously created field.
- Modify the column widths and row heights of a given Table.
- Add new records and modify old records in a given Table.
- Add an input mask to a field.
- Insert an OLE object into a table.
- Given a prepared Table sort the data.
- Use a wizard to create a form to enter data in a given Table.
- Filter data by Selection and Form in a given Table.
- Filter data by Form with more than one variable in a given Table.
- Create a Query using a wizard for a given Table.
- Create a Query in the design view for a given Table.
- Add a calculation field to a Query in the design view.
- Given a prepared database establish a relationship between two Tables.
- Given a prepared database create a Query between multiple Tables for a Report.
- Given a prepared database create a report using the wizard from both a Query and a Table.
- Create a form with a Combo Box.
- Format a form in the design view by adding a title and moving various controls.
- Modify labels in a form using the properties window.
Access Intermediate Objectives
Upon the completion of the Intermediate Access class participants will be able to:
- Create and Run a Macro to that will run a report.
- Create a Macro with a filter.
- Create and apply an input mask to a field in a given table.
- Add a switchboard, to a given database, with buttons to various switchboard pages.
- Given a database with more than two tables create a form with a sub-form using the wizard.
- Given a database create a pivot table for a table.
- Given a database create a pivot chart for a table.
- Prepare data in an Excel worksheet to be imported into an Access database.
- Export contacts from MS Outlook into an access database file.
- Import from a MS Access table to MS Outlook contacts.
- Create an Access Page from a given table.
Access Advanced Objectives
Upon the completion of the Advanced Access class participants will be able to:
- Define the components of a MS Access expression.
- Use the Expression Builder to create an expression.
- Build an expression in a table of a given Access database.
- Build an expression in a control box of a Report of a given Access database.
- Build and use an expression in the criteria box of a Query.
- Add an expression to a field portion of a Query.
- Use an expression in the validation rule of a Table in a given Access database.
- Use an expression in the validation rule in the property of a control of a Form of a given Access database.
- Define bound, unbound and calculated controls in Forms and Reports of a given Access database.
- Given a scenario and some data in an excel workbook design a simple Access database that will solve the problems put forth in the scenario.
Excel Beginning Objectives
Upon the completion of the Beginning Excel class participants will be able to:
- Demonstrate how to open a workbook and know difference between workbook and worksheet.
- Identify the parts of a worksheet window.
- Open a given workbook and be able to change views.
- Create a blank workbook then name and save it to a specific location.
- Recall algebraic rules that govern order of operation.
- Format cells using text, number, percentages and currency.
- Rotate text in a cell.
- Enter and edit data, modify column and rows with respect to height and width, and sort data.
- Add a worksheet to a given workbook and modify the color, name and location of its tab.
- Use simple formulas and functions (such as min, max, count, sum, and average),
- Use a spreadsheet to compute “loan payments” by using financial functions.
- Understand and use absolute and relative cell references in formulas.
- Copy values and formulas down and over in a worksheet.
- Use the AutoSum tool on rows and columns in a worksheet.
- Enter data into a cell and use the “merge and center" tool to combine a number of cells into one cell.
- Set print areas, change print options and print documents.
- Use the “Date” and “Now” functions in a worksheet.
- Calculate the difference between two given dates in a worksheet.
- Use various means for sorting data in a worksheet.
- View and print the formulas version of a worksheet.
Excel Intermediate Objectives
Upon the completion of the Intermediate Excel class participants will be able to:
- Demonstrate how to add a header and footer, change margins and insert a page break.
- Add comments to a cell on a given worksheet.
- Create a variety of charts from data in a given worksheet.
- Use the Format Painter button to copy the formatting from one group of cells to another.
- Enter data and then use border thickness and color to highlight and enhance.
- Use conditional formatting for a specific set of data in a given worksheet to highlight specific data.
- Name Cells in a given worksheet and use those names in a formula.
- Use the COUNTIF, IF and VLOOKUP functions in a given worksheet.
- Explore advanced format painting, styles, and additional formulas and functions.
- Assign a name to a cell and refer to the cell in a formula by using the assigned name.
- Demonstrate how to create and use a template.
- Given a worksheet be able to display subtotals.
- Add a hyperlink to a worksheet element.
- Show how to use the find and replace command in a given worksheet.
- Protect and unprotect cells in a worksheet.
- Split worksheet windows.
- Freeze rows and columns in a given worksheet.
Excel Advanced Objectives
Upon the completion of the Advanced Excel class participants will be able to:
- Create a List from a set of data entered in a spreadsheet.
- Add records to a List.
- Do a simple sort of a List.
- Add computational fields to a List.
- Sort a List by one or multiple fields.
- Compose and use a query for a List.
- Use the Totals button to open and close the Totals row and use various options in the Total row.
- Use the Criteria create a query from a list and print results.
- Apply database functions, the SUMIF function and the COUNTIF function to generate information from a list
- Create a Pivot Table from a given set of data on a worksheet.
- Create a Pivot Chart from a given set of data on a worksheet.
- Create an amortization schedule on a blank spreadsheet.
- Use the Excel Speaks function to listen as you enter and review data on worksheet.
- Use the Concatenate function in a worksheet.
- Create a document in Excel.
Outlook Basic Objectives
Upon the completion of the Outlook class participants will be able to:
- Navigate and modify the various views of MS Outlook.
- Open and read emails and any attachments.
- Turn the Desktop Alert off and on as desired.
- Send a new email to a contact or someone listed in an address book.
- Add an attachment, with varying options, to an email.
- Send an email of high importance.
- Sort emails by varying options.
- Create a new folder and save specific messages in that folder.
- Set up Rules to manage incoming or outgoing messages.
- Set up a list of Safe Senders for filtering emails.
- Set up a list of Blocked Senders for filtering emails.
- Set up Signatures for your emails.
- Select a Signature for a specific email.
- Change from one view to another in the MS Outlook Calendar.
- Set up a one time appointment in the Calendar.
- Set up a recurring appointment in the Calendar.
- Use the Calendar option to set up a meeting and invite specified attendees.
- Set up a recurring meeting using the Calendar option of MS Outlook.
- Create a new Contact.
- Using the various Tabs modify information about a current Contact.
- Create an email Distribution List.
- Set up a “to do” list using the Tasks option in Outlook.
- Assign a Task to another person and track the progress.
- Understand the function of Notes, Folder List, Journal and Shortcuts in Outlook.
PowerPoint Level 1 Objectives
Upon the completion of the Level 1 PowerPoint class participants will be able to:
- Start Microsoft PowerPoint and open a new blank presentation or a previously prepared presentation.
- Identify and name the various components of the PowerPoint window.
- Understand and change between various views.
- Create a new presentation from a template.
- Add a new slide to a presentation and change its layout.
- Resize, change the position and shape of a text box in a slide.
- Add a new slide into which the participant will add both text and clip art.
- Use the drawing toolbar to add some basic shapes and lines to a slide.
- Open a previously prepared presentation and apply a new design template.
- Add a slide transition to a specific slide and then to all slides of a presentation.
- Apply an animation scheme to the text of a slide.
- Apply custom animation to selected text and graphics of a slide.
- Insert a sound clip into a slide.
- Use the Outline Pane to change text on slides and to promote and demote text in bulleted lists.
- Identify the various print options for a presentation.
- Create a presentation starting with a prepared Word document.
PowerPoint Level 2 Objectives
Upon the completion of the Level 2 PowerPoint class participants will be able to:
- Insert and manipulate an AutoShape into a presentation.
- Insert and format text inside an AutoShape.
- Rotate, resize and move an AutoShape in a slide.
- Add a floating toolbar to a workspace.
- Use the drawing toolbar to add shapes and lines to a slide.
- Add and format WordArt on a slide.
- Use the flowchart option on the AutoShape menu to create a flowchart.
- Add an Organizational chart to a slide using the Diagram or Organization Chart tool on the drawing toolbar.
- Create and format a Table on a blank slide.
- Create a chart on a blank slide from given data.
- Download design templates from an online source.
- Change the color scheme of a selected design template for a presentation.
- Edit individual colors in a color scheme.
- Format text to given specifications.
- Import an outline from Word into a presentation.
- Modify the text and background on the Slide Master for a given presentation.
- Change the design template and modify the Title Master and Slide Master of a given presentation.
- Add date, name and slide number to the Header and Footer of a given presentation.
- Create a photo album presentation given a group of digital images.
- Print a given presentation as a Word document.
- Remove hidden data from a presentation and then save it.
- Save presentation as a web page.
- Use the Package for CD option for a given presentation.
PowerPoint Level 3 Objectives
Upon the completion of the Level 3 PowerPoint class participants will be able to:
- Use custom animation to create animation of text, clip art and pictures on a given slide.
- Apply various animation effects to a given slide.
- Add an action button the will play an audio sound clip to a given slide.
- Using an audio CD, have a track play on a specific slide on a given presentation.
- Rehearse timings for a presentation.
- Record narration for a presentation.
- Use the on-screen ink feature to highlight and emphasis points on a slide.
- Set up a show for various situations.
- Build a custom show using selected slides.
- Address security issues.
- Change the linked sound size limit.
- Communicate effectively as described by Dale Carnegie.
Word Beginning Objectives
Upon the completion of the Beginning Word class participants will be able to:
- Start Microsoft Word and open a new blank document or a previously prepared document.
- Identify the menu, task panes, toolbars and various views of the MS Word window.
- Use the commands “save” and “save as” to name and save their document to specific locations on the computer.
- Enter text and to use spell check, the thesaurus and dictionary.
- Use the File | Page Setup menu to set the margins and page orientation
- Format text to given specifications and to use the “Cut”, “Copy”, “Paste” and “Move” functions on text within a given document or between documents.
- Use the “Back Up” and “Redo” functions from the standard toolbar and menu.
- Open the Office Clipboard and use the “insert”, “clear all” and “paste all” functions.
- Use the “format painter” to transfer formatting from one portion of a document to another.
- Apply indentation, shading and borders to a paragraph.
- Set tabs from the Format | Tabs menu or insert and modify tabs manually on the ruler.
- Change the Style of a selected portion of a document.
- Investigate the various settings in the Tools | Option menu that can be modified for personnel preferences of the user.
Word Intermediate Objectives
Upon the completion of the Intermediate Word class participants will be able to:
- Use the “Insert Table” option under the Table menu to create a table in a MS Word document.
- Use the “Tables and Borders” toolbar to format a table with borders and shading to given specifications.
- Recreate a table from a given image using “Tables and Borders” toolbar options.
- Use the “Find”, ”Replace” and “Go To” functions under the Edit toolbar to find and/or replace given text in a document.
- Use various wildcard options in their Find/Replace search for text within a document.
- Set the options in the “Autocorrect” feature for MS Word.
- Set the “Options” for MS Word to control whether a “Drawing Canvas” will be created when an “AutoShape” is inserted into a document.
- Be able to insert an “AutoShape” into a blank document and add text and formatting.
- Use the “Header and Footer” toolbar to enter prearranged or custom information into the header and footer of a document.
- Use the “Page Set-up” window to change the header and footer options.
- Insert the current date within the document and have it set to update automatically.
- Use the “Word Count” feature located in the Tools menu to find the number of words in the document.
- Perform various sorting activities.
- Insert a “Hyperlink” into document and understand the various targets that may be linked to.
- Use the “Drop Caps” formatting option within a document.
- Use the “Section Break” and Format | Columns options to change the number of columns at a specific location within a document.
- (As an exercise) Create a newsletter from given specific information utilizing the lessons in this class.
Word Advanced Objectives
Upon the completion of the Advanced Word class participants will be able to:
- Create a new “Mail Merge” document using a template from the participant’s computer
- Merge data from a new list that the participant will create.
- Modify the fields on a “Data List” of information to be used in the “Mail Merge” document.
- Enter information into the “Data List” that has been created.
- Enter static information into the “Mail Merge” document and format the letter to given specifications.
- Enter specific “Blocks” and “Fields” into predetermined locations in the “Mail Merge” document.
- Sort data on the Data List, view specific data as it will appear in the document and then merge the data into a new document.
- Use the Mail Merge to create Labels, E-mails, Directories, and Envelopes.
- Use Access to update the List that was created by the participant.
- Create a form in Access that can be used to update a list used by the Mail Merge function.
- Given a MS Word document create macros to carry out specific formatting functions.
- Use the Paste Special command to copy from a web page to a MS Word document.
- Use the Track Changes function to make and review changes to a document.
- Add document protection at various levels limiting access to a document.