|
|
Computer Education Support
Course Descriptions
Computer Basics
1) The Essentials
Participants will learn the difference between hardware and software; discover the various types of computers and their roles; learn the most basic parts of a computer; understand what determines a computer’s performance; and get tips for what to look for when buying a computer.
2) Hardware and Software
Participants will learn what a CPU does and how memory is measured; learn about input devices: mouse, keyboard, and digital cameras; learn about output devices: monitor, graphics, and printers; learn about storage devices: hard drives, CD-ROMs, and DVDs; learn about operating systems, application software: word processors, spreadsheets, databases, and programming.
3) Introduction to Windows XP
Participants will log on to Windows; use the mouse to: point, click, double-click, right-click, click and drag; use the keyboard; start a program; learn the parts of a window; minimize, maximize, and restore a window;; move and close a window; change the size of a window; switch between several programs; tile and cascade windows; exit Windows and turn off the computer.
4) Programs, Files, and Folders
Participants will use menus and toolbars; fill out a dialog box; enter and edit text; save and open a file; select, replace, and delete text; use the undo function; print a file; cut, copy, and paste text; format fonts and paragraphs; get help; save and open files in different locations; learn about storage devices; use My Computer to navigate through folders and files; open, create, rename, copy, move, and delete files and folders; restore a deleted file; empty the Recycle Bin; change how information is displayed in a window; select multiple files and folders; find a file using the Search Companion; and use Windows Explorer.
5) Networks and the Internet
Participants will learn about networks, the difference between a LAN and WAN, the basics about the Internet, how Intranets and Extranets differ, and how telephone networks are used to connect to the Internet.
6) TabletPC and Windows Journal
Participants will review the basics of the HP TabletPC with a focus on using the stylus in Windows Journal.
7) Optimizing and Maintaining Your Computer
Participants will defrag and fix errors on the hard disk; back up and restore the hard disk; free up space on the hard disk; schedule tasks; install and remove software; add and remove Windows components; install a printer; install new hardware; use the Windows XP update feature; and use the Device Manager.
8) Customizing Windows XP
Participants will move, size, and hide the Taskbar; customize the Start Menu, work with the Quick Launch Bar; open recently used files; start a program with the Run command; add shortcuts to the Desktop; automatically start a program when Windows starts; change the date and time; add wallpaper; change the screen colors; change the screen resolution and color depth; use a screen saver and desktop theme; change system sounds; adjust the mouse; and customize how Windows looks and works.
9) Pictures and Multimedia
Participants will transfer digital photos to the computer; view and manage digital photos; print and email digital photos; play a CD; copy a CD to the hard drive; burn CDs and play a DVD.
|
|
|
Word Processing (Microsoft Word)
1) The Fundamentals
Participants will start Microsoft Word; give commands using the menu and toolbars; create a new document; insert and delete text; save and print a document; cut, copy, and paste text; find and replace text; use spell checking, the thesaurus, and word count; insert special characters; and use undo and redo.
2) Document Formatting
Participants will format characters; change a paragraph’s alignment and spacing; indent paragraphs; set, change, and remove tab stops; create bulleted and numbered lists; add borders and shading to paragraphs; understand text flow and spacing before and after a paragraph; change a document’s margins; create headers and footers; change page orientation; preview a document; control where the page breaks; add section breaks and apply multiple page formats; and print envelopes.
3) Graphics, WordArt and Charts
Participants will add lines, rectangles, circles, AutoShapes, text boxes, clip art, and pictures to a document using the Drawing toolbar; select, resize, format, and delete objects; specify how text wraps around pictures and text; align, group, flip, rotate, layer and apply shadows and 3-D effects to objects; insert, edit, and format a WordArt object; and create and modify a chart.
4) Tables and Spreadsheets
Participants will create a table; adjust row height and column width; insert and delete rows and columns; format a table with borders and shading; format characters and paragraphs in a table; split and merge cells; sort information in a table; perform calculations; work with tables that span multiple pages; insert an Excel worksheet into a Word document; modify an embedded Excel worksheet; insert a linked Excel chart in a Word document; and open and save files in different formats.
5) Mail Merge
Participant will create a mail merge main document; create a data source for the mail merge; enter records into the data source; insert merge fields into the main document; select specific records to merge; create labels; use an existing database as the data source; and create and work with envelopes.
6) Outlines and Long Documents
Participants will view an outline; expand and collapse headings; organize an outline; add cross-references, bookmarks, footnotes, table of contents, and index to a document; and create a master document.
7) Templates, Styles, and Document Collaboration
Participants will create and use templates; create and apply character and paragraph styles; modify an existing style; display styles in a document; attach a different template to a document; copy styles between documents and templates; add revisions to a document; accept and reject revisions; insert comments; save versions of a document; password-protect a document; compare documents; and collaborate with document workspace.
8) Fill-in Forms
Participants will create a new form; add text fields, check boxes, and drop-down field to a form; assign help to form fields; perform calculations in a form field; and save and fill out a form.
9) Advanced Topics
Participants will modify a Web page using Word; convert an existing Word document to a Web page; add hyperlinks to a Web page; view a Web page in a Web browser; apply a theme to Web page; work with frames; add, removing and create new toolbars; create and work with AutoText and AutoCorrect entries; record and play a macro; and edit a macro’s Visual Basic source code.
|
|
|
|
Spreadsheet (Microsoft Excel)
(1) The Fundamentals
Participants are introduced to the basic concepts and features of Microsoft Excel. Topics include: giving commands to Excel; entering labels and values into a workbook; navigating a workbook; naming and saving a workbook; previewing and printing; entering date values; editing, cleaning, and replacing cell contents; suing Cut, Copy, and Paste; moving and copying cells with drag and drop; working with Absolute and Relative cell references; inserting and deleting cells, rows and columns; using Undo and Redo; checking spelling; basic file management; and using cell comments.
(2) Worksheets and Workbooks
Pparticipants will format fonts and values in Excel using the Formatting toolbar and menus; adjust row height and column width; align cell contents; add borders, colors, and patterns to cells; use the Format Painter to copy formatting; create a custom number format; create, apply, and modify styles; use conditional formatting; merge cells; navigate between worksheets; insert, delete, rename, and move sheets; split and freeze a window; add headers, footers, and page numbers; insert page breaks; adjust margins, page,size orientation, and print scale; protect and hide a worksheet; create and use a template; and consolidate multiple worksheets.
(3) Charts and More
Participants will create a chart using Excel; move and resize a chart; format objects in a chart; change a chart's source data or type; add titles, gridlines, annotations, and a data table to a chart; work with a 3-D chart; create and work with a custom chart; insert an Excel worksheet into a Word document; modify an embedded worksheet; link and Excel chart into a Word document; insert a graphic into a worksheet; open and save files in different formats; and plot data on a map.
(4) Data Analysis and Pivot Tables
Pparticipants will create and sort a list; use the AutoFilter to filter a list; create and use an advanced filter; use data validation; create a PivotTable; create and work with subtotals; use Database functions (DSUM); use Lookup functions (VLOOKUP); and group and outline a worksheet.
(5) Formulas, Functions, and What-If Analysis
Participants will create a formula using the Insert Function feature; define and use range names; use the AutoCalculate feature; create a conditional formula with the IF function; use the PMT function; identify and fix formula errors; create a Scenario and Summary Report; create One and Two-Input Data Tables; use Goal Seek; and set up complex what-if analysis with Solver.
(6) Advanced Topics
Participants will add, remove, position, and create toolbars; create a custom AutoFill list; Password-protect a workbook; change Excel’s default options; find and change a file’s properties; share a workbook for group collaboration; add hyperlinks to a worksheet; save a workbook as an interactive and non-interactive Web Page; retrieve information from a Web Page; record and play a macro; assign a shortcut key and toolbar button to a macro; and edit a macro’s Visual Basic code.
|
|
|
|
Presentation (Microsoft PowerPoint)
(1) The Fundamentals
Participants will use menus, toolbars, dialog boxes; create, view, save, and print a presentation; use the help feature; reorganize a presentation in the Outline pane; copy, move, and delete slides in the Slide Sorter view; add notes to slides; recover a presentation; format a presentation; use the format painter to copy and apply formatting; apply a template to a presentation; use slide masters, color schemes; change the slide background; apply custom bullets; change paragraph formatting and line spacing; add headers and footers; and change the page setup for the presentation
(2) Graphics, Tables, and Charts
Participants will draw on slides; add, arrange, and format text boxes; select, resize, format, and delete objects; inserting clip art and pictures; align and group objects; draw AutoShapes; flip and rotate objects; layer objects; apply shadows and 3-D effects; create and work with a table; insert, edit, and format WordArt objects; create and modify various types of charts including an organization chart.
(3) Transitions, Animation, Multimedia, and More
Participants will deliver a presentation; use slide transitions; animate text and objects; rehearse slide show timings, create a presentation that runs itself; create a custom show; use the Package for CD feature; insert sound files, voice narration, and movie clips and automate the multimedia in the presentation.
(4) Advanced Topics
Participants will insert a presentation into a Microsoft Word document; embed a Microsoft Excel worksheet into a slide; modify an embedded object; import and export an outline; use hyperlinks and action buttons; save a presentation as a Web page; customize default options and toolbars; add comments to a slide; find and view file properties; and record and play a macro.
|
|
|
|
Database (Microsoft Access)
1) The Fundamentals
Participants will be introduced to tables, queries, forms, and reports; open and modify a database object; add, edit, and delete records in a table or form; preview and print; check spelling; find and replace information; sort and filter records; and format a datasheet.
2) Database Creation
Participants will create a new database; create a table from scratch and use the Table Wizard; create fields with different field types; create and modify queries that sort and filter data; create a form using the Form wizard; create reports and mailing labels using the Report Wizard; modify a table’s field properties; index a field; add a primary key to a table; specify data validation; and create a lookup field.
3) Relationships and Queries
Participants will create relationships between multiple tables; set referential integrity; create queries using multiple tables; create queries that calculate and summarize information; use the Expression Builder to create expressions; create parameter queries that prompt the user for information, create queries that find duplicates and unmatched records, and create action queries that delete, update, append, and export information.
4) Custom Forms and Reports
Participants will create, modify, and format forms and reports; work with properties and settings; create interactive forms and subforms; use reports to group and sort records; and insert objects such as charts, pictures and lines into a form or report.
(5) Advanced Topics
Participants will import and export data to and from an Access database; import objects from another Access database; import and export data to and from an Excel spreadsheet; link tables from an external data source (Teradata); mail merge records to Microsoft Word; create and work with hyperlinks and OLE object fields; and create and run macros.
|
|
|
|
