Introduction to Personal Computing
Students will learn about the basic hardware components, additional hardware components, and computer software. Students will learn about hard disks, floppy disks, compact disks and additional storage media. Learn the basics about Microsoft windows: creating a new folder, copy and delete a file, and mouse techniques. Learn the basics for Microsoft Word, enter and save text in a document, open an existing document, revise and print a document. Learn the basics for Microsoft Excel such as: entering labels and values into a worksheet, enter a formula into a worksheet and copy a formula. Students will learn the basics about PowerPoint, which will include: creating a title slide, bulleted list slide and adding autoshapes. Students will also learn about Microsoft Access and Internet Explorer and much more.

Microsoft Access 2000, Introduction
Students will learn how to open the different database objects. Design a new database, Design and create data tables, Modify existing data tables and manipulate existing data for editing purposes by using example data. Select specific records and fields from tables by using Access queries. Create a Simple and Grouped Tabular Report. Create calculated fields and view data from more than one table. Create data forms for viewing and inputting data. Present data from your tables by creating reports that summarize and grouping information the way you need to. Students will learn lots of shortcuts. Student manual provided.

Microsoft Access 2000, Intermediate
Students will learn to define a default field value in a table, set a primary key, add a memo field to a table, design a custom form, add a header and footer to a form, and a calculated control. Students will learn how to make and use multitable queries, create equi-joins and outer joins, use action queries, and use referential integrity. How to link and unlink a table, modify table properties, create combo boxes and lookup tables, and insert graphics in fields. Students will learn how to use a Database wizard, using the office clipboard, and backup and restore a database. Student manual provided. Prerequisites: Access 2000, Introduction or equivalent experience.

Microsoft Access 2000, Advanced
Students will learn how to use object linking and embedding. Students will also learn how to create a lookup field, multiple-table forms by creating a master-detail form and a form based on a multiple-table query, create and modify a chart, create a parameter query and an action query. Students will learn to create and run a command button macro, set database startup options, create a many-to-many relationship and a one-to-one relationship between tables, and how to create a switchboard. Student manual provided. Prerequisites: Access 2000, Intermediate or equivalent experience.

Microsoft Excel 2000, Introduction
Learn the basics of using Excel's integrated spreadsheet, chart, and database program. Learn how to create, edit, format and print charts and reports. In the process, learn how to use Excel's numerous timesaving features including AutoSelect, AutoCorrect, AutoFill, AutoComplete, AutoSum, Animated Insertion and Deletion, Drag-and-drop, ScreenTips, Office Assistant, Shortcut menus, and Excel's customizable toolbars. Learn how to enter formulas, modify formulas, and timesaving techniques on entering formulas, and multiple cells at the same time. Learn how to use Excel functions for Sum, Average, Max and Min. using the paste function button.

Microsoft Excel 2000, Intermediate
Learn how to use Excel’s intermediate spreadsheet features effectively. Find a specific entry in a worksheet. Create and apply a new style to a worksheet. Use a workbook template to create a new workbook. Use alignment options in the Format Cells dialog box. Enter an absolute column and absolute row cell reference into a formula. Use the PMT and FV function and set up a financial analysis table (using the PMT and FV functions). Use the IF and Nest IF functions; Date and Now functions. Modify and enhance a basic chart. Learn how to copy data from one worksheet to another worksheet in the same workbook and into a different workbook. Freeze and hide rows and columns. Learn all this and more. Prerequisites: Excel 2000, Introduction or equivalent experience.

Microsoft Excel 2000, Advanced
Learn how to use Excel’s advanced spreadsheet features effectively. Learn data entry and formatting techniques, which include: restricting cell entries to specific numbers, dates or times. Learn how to define a range name, and use range names in formulas. Learn to use the lookup functions using the Vlookup and the Hlookup functions. Students will learn to how to link multiple workbooks. Learn about working with a database. Students will learn about analyzing data using pivot table reports, solver, and outlining a worksheet. Learn how to import and export from other applications into Excel. Learn all the features and much more. Prerequisites: Excel 2000, Intermediate or equivalent experience.

Microsoft Excel 2000, Macros
Learn to record and run a personal macro, display macro instructions, edit a macro, and how to use absolute and relative cell references in a macro. Learn to record and run a workbook macro and how to add a macro button to a worksheet. Learn to display a data prompt during macro execution, how to use a conditional statement in a macro and to use a control loop in a macro. Learn to use a combo box and a check box on a worksheet and how to link a control to worksheet data. Prerequisites: Excel 2000, Advanced or equivalent experience.

Microsoft FrontPage 2000, Introduction
Students will have an introduction on understanding the Internet, the World Wide Web and Intranets. Students will learn what FrontPage is and learn to use the application window, menus, displaying help information, and how to enter and exit FrontPage. Students will also learn about building a web site; how to work with tables (creating, inserting and deleting rows/columns, resizing table rows/columns, merging cells, and resetting table and cell properties); how to work with pictures and hyperlinks, and dynamic html effects and FrontPage components. Students will also learn how to manage a FrontPage Web, work in tasks view, and additional features of FrontPage, which include templates, wizards, navigation view, and more.

Microsoft FrontPage 2000, Intermediate
Students will learn how to import existing web pages into FrontPage, use a table in FrontPage, apply a custom background and theme, and work with shared borders. Students will also learn how to add a Page Banner to a page, add a navigation bar to a page, and add Frames to a page. Additional topics covered: Banner Ads, Search Forms, Custom Forms, Publishing a FrontPage Web and Importing an Access Database into FrontPage and more. Prerequisites: FrontPage 2000, Introduction or equivalent experience.

Microsoft Outlook 2000, Introduction
Learn how to send and receive messages; how to display and respond to a mail message, print a mail message, attach an external file to a mail message, display the contents of a file attachment and how to forward a mail message. Learn about setting up scheduled events on your calendar and how to setup recurring events. Students will learn to about navigating through the calendar, scheduling, and printing the calendar. Learn about creating, adding, and changing a contacts list. Learn to create a tasks list, maintain a journal, and how to use the notes folder.

Microsoft Outlook 2000, Intermediate
Students will learn how to create and insert a signature into a mail message and use Outlook stationery to create a mail message. Students will learn how to search for a specific message, filter and group the Inbox. Students will also learn how to recall a message. Students will learn how to write a letter to a contact, send a meeting request to a contact, and assign Outlook items to categories. Additional topics covered: Creating and sending a task request, responding to a task request, saving a calendar as a web page, creating and using a message template and much more. Prerequisites: Outlook 2000, Introduction or equivalent experience.

Microsoft PowerPoint 2000, Introduction
Lean how to create professionally designed overhead transparencies, 35mm slides, and computer-based presentations quickly and easily. Students will learn how to create a title slide, bulleted list slide, and how to edit text, switch between outline view, slide view and slide sorter view. Learn how to import graphics; use the drawing tools; create, edit, and format bulleted text slides; and apply and modify various templates. Then learn how to check the spelling; print Speaker’s Notes and Audience Handouts; add transition and animation effects; and give a Slide Show. Learn how to use design template, use the clip gallery, and many more features.

Microsoft PowerPoint 2000, Intermediate
Students will learn how to share data with Microsoft Excel with object linking and embedding, embedding Microsoft Excel worksheet entries in a PowerPoint Presentation. Enhance Microsoft Excel worksheet entries on a PowerPoint slide. Learn to share data with Microsoft Word, add special effects to text by creating an artistic text block or using the formatting toolbar to enhance text Then learn how to integrate data from other programs, including WordArt, Microsoft Organization Chart, Microsoft Graph, Microsoft Excel, and Microsoft Word. Also learn how to modify the color scheme and use various Slide Show techniques including transitions, builds, animation, drill downs, and hidden slides. Prerequisites: PowerPoint 2000, Introduction or equivalent experience.

Microsoft PowerPoint 2000, Advanced
Students will learn how to use the advanced formatting techniques such as copying a design template from one presentation to another, reset paragraph indentation on a slide, set and clear tab stops on a slide, adjust an autoshape to fit text/adjust text to fit within an autoshape. Use data from other applications, create and setup an organizational chart. Learn how to include sounds and video in a presentation by inserting a sound clip or video clip into a slide. Learn to play a sound or video clip in slide show. Students will learn advanced slide show techniques like how to exclude a slide from a slide show, crate a hyperlink branch to a specific slide or another presentation, and use automatic slide timings. Students will learn additional advanced PowerPoint features that include creating a summary slide, custom slide how, save a presentation for use on another computer, and more timesaving techniques. Prerequisites: PowerPoint 2000, Intermediate or equivalent experience.

Publisher 2000, Introduction
Students will learn about creating a letterhead in publisher, how to examine options in the Publisher catalog, user the letterhead wizard, and save the application. Learn how to create a flyer using the quick publication wizard, insert a personal information component into a publication, add a border to a frame, and insert a text frame. Learn to create a newsletter, examine options in the Publisher design gallery, insert a masthead, setup columns, create a drop cap, and work with shapes. Learn about setting up a table and use WordArt. Learn to create and format a table and insert and delete rows and columns in a table. Learn addition publisher features such as creating and applying a new style to text.

Microsoft Word 2000, Beginning
Learn how to start word, use the menu system, and toolbars. Students will learn how to display help information, exit from word, reset the working folder, and enter text into the Document window. Learn how to Save, Print, Close, and reopen a document. Learn how to move the insertion point within a document, insert and delete text, and reverse an edit operation. Learn how to move, copy, and delete a block of text. Learn how to work with paragraphs by indenting the right and/or left side of the paragraph, change margins for the document; reset the spacing in a document or paragraph. Students will learn this along with many shortcuts and other features.

Microsoft Word 2000, Intermediate
Learn intermediate editing and formatting techniques such as: finding specific text in a document, find and replace text in a document, apply underline and effect options to text, adjust character spacing, and insert symbols. Learn how to set up a table: create a table, insert and delete rows and columns, use formulas in a table, and merge cells in a table. Set up multiple-column documents: create parallel columns in a document, create newspaper columns in a document, use styles, produce a report, add header/footers to a document, and page numbers. Students will learn these features and much more. Prerequisites: Word 2000, Introduction or equivalent experience.

Microsoft Word 2000, Advanced
Learn advanced editing and formatting techniques such as: finding formatting and special characters, controlling page breaks, sorting paragraphs in a list, balancing the length in a newspaper column, creating and applying a new style to text. Learn advanced table techniques: create a table by linking or embedding a Microsoft Excel worksheet. Learn advanced report techniques: adding borders and shading to a document, creating a table of contents, creating an index, and creating footnotes and endnotes. Learn about working with charts and pictures by inserting and modifying a chart in Microsoft Word. Learn how to perform mail merge features and Word forms. Students will learn these features and much more. Prerequisites: Word 2000, Intermediate or equivalent experience.

Microsoft Word 2000, Macros
Students will learn to record and run a text macro, as well as a command macro. Students will learn to record a macro to set up a custom document layout, and a macro to set up a word table. Students will learn to display macro instructions, and how to edit macro instructions. Students will learn to write a simple macro and how to insert a new procedure in a macro. Students will learn how to display a data prompt during macro execution, using a conditional statement in a macro, and using a control loop in a macro. Students will also learn to create custom template macros and how to create and run an autonew macro. Prerequisites: Word 2000, Advanced or equivalent experience.

Project 2000
Learn all of the amazing features of Microsoft Project 2000! Learn to create a project schedule, enter a milestone, insert and delete tasks and reorder a project. Learn to link tasks, change the timescale of a Gantt chart, add lag and lead time between tasks and use work breakdown structure codes. Learn to use the resource sheet, allocate resources, contour a resource assignment and create and apply a task calendar. Learn to identify the critical path of a project, identify the slack time of a project, assign a constraint and deadline to a task and define a fixed duration task. Additional topics covered: Sharing data between Project and Word, Project and Excel, and sharing between Excel and Project.

Windows 2000
Learn all of the amazing features of Windows 2000! Learn about moving, resizing and hiding the Taskbar and how to view and change Taskbar properties as well as adding items to the Taskbar. Learn how to use Windows Explorer to do things such as view files and folders, creating and renaming folders, copying and moving files and deleting files. Learn to use the Search feature to find files and folders. Learn to schedule tasks, modify scheduled tasks, and delete tasks. Learn how to share data between programs. Learn different print operations and so much more!

Click here to go back to Computer Class Schedules.