Application Training |
| References | Request For Information |
Introduction to Word (Level 1)
Students will learn to create a document from the ground up. Topics covered include paragraph indentation, alignment and spacing; changing font type, color and size; using borders and background colors; setting tabs, headers and footers. Also covered are numbered and bulleted lists, saving and naming files, changing page margins, pages numbers, running spelling & grammar checkers as well as using the thesaurus.
Word Level 2
This course picks up where Word Level 1 left off. Topics covered in-depth include adding graphics and clipart to your documents, formatting text around, through and next to the pictures. You will learn the aspects of creating tables and columns and how to use Mail Merge.
Prerequisite: Introduction to Word
Word Level 3
This course picks up where Word Level 1 & 2 left off. You will learn how to create Macros and a table of contents, that updates itself as you edit your documents. You will learn to create and use Word templates, customize toolbars and use Word Wizards. There will be more in-depth coverage on the Drawing, Alignment and Rotation tools, as well as Charts. You will also learn to manage files by protecting documents with passwords and making them read-only so documents can be read but not changed.
Prerequisite: Introduction to Word, and Word Level 2
Introduction to Excel (Level 1)
Students will learn to create a spreadsheet from the ground up. Topics covered include entering text and numbers in cells making up the columns and rows of your spreadsheet. Learn to add columns of numbers automatically, average numbers, and how to find the largest and smallest number is a range. Learn shortcuts to quickly entering large ranges of numbers. Also covered are features to format your spreadsheet with different font styles, sizes, colors; cell and table borders and background colors. Prerequisite: Excel 1
Excel Level 2
This course picks up where Excel Level 1 left off. Topics covered in more depth include Database functions of Excel (sorting, subtotaling, etc) and working with Charts. Several additional functions are also covered such as the Sub-Totals, PAYMENT, VLOOKUP, and IF. You will also learn to re-order, rename and copy entire worksheets, as well as how to link cells from one spreadsheet to another.
Prerequisite: Introduction to Excel
Excel Level 3
This course picks up where Excel Level 1 & 2 left off. New topics include Macros and Pivot Tables. You will create and use Excel templates, customize toolbars and use Excel Wizards. We will cover more advanced aspects of database sorting, filters and queries. Importing and exporting data from other applications will be covered in detail. You will also learn to manage files by protecting documents with passwords and making them read-only so documents can be read but not changed.
Prerequisite: Introduction to Excel and Excel Level 2
Outlook – Email & Contacts
This section of Outlook is designed for the person with little or no Outlook experience. Students will learn the fundamentals of sending and receiving email, replying and forwarding email. Students will learn to find, move, delete, and copy email messages. Students will also see how to add names and address to the address book and contact list. Time will be spent on the basic setup of Outlook.
PREREQUISITE: Students should be familiar with Microsoft Windows and the mouse.
Outlook – Calendaring & To Do List
This section of Outlook is designed for the person who is already familiar with the emailing functions of Outlook, and is now ready to manage calendars and a list of things to do electronically. Students will add meetings, invite others, monitor responses, send meetings and appointments. Students will practice adding recurring appointments, anniversaries, meetings, and more to an electronic calendars. Various printing formats will also be explored. In addition to a calendar of events, students will also learn how to construct and manage a To Do list.
PREREQUISITE: Outlook-Email & Contacts. Students should be familiar with Microsoft Windows and the mouse.
Introduction to PowerPoint (Level 1)
This course covers the fundamentals of Microsoft PowerPoint, the world’s leading presentation software. You will learn to create and edit slide presentations both from scratch and using the PowerPoint wizard. You will learn to create and edit slides, slide layouts and designs. You will learn to edit the Master slide, for objects included on every slide, apply page numbers and add your company logo once for inclusion on all slides.
PowerPoint Level 2
This course picks up where PowerPoint Level 1 left off. Topics covered in more depth include finding, placing and editing graphics files, advanced slide layout and animating text and other objects. Also covered are the Pack-n-Go feature, which allows you to compress your presentation to fit on a floppy disk or include PowerPoint Viewer with a presentation to send to someone without PowerPoint. You will also learn to create Custom Slide Shows and to use the Timings and Rehearsal features to prepare your presentation.
Prerequisite: Introduction to PowerPoint, Level 1
Beginning Access One – Tables & Queries
This course is for the person new to Access. We will discuss terminology and the steps necessary to start your database on the right foot. You will be creating a database from the ground zero, starting with Tables and Queries. You will learn how to structure your tables correctly setting properties, default values, input masks, etc. From tables, we will move to queries, table relationships and assuring data integrity.
Prerequisite: Introduction to Excel and Relational Database Management Systems are HIGHLY recommended
Beginning Access Two – Forms & Reports
Now that you learned to structure good tables and queries in Beginning Access One – Tables & Queries, this course will concentrate on the fundamentals of the Forms and Reports objects in your Access database. You will learn to create forms and sub-forms (forms within forms). Finally, we will create and refine reports and learn how to structure and print data in a meaningful format.
Prerequisite: Beginning Access one - Tables & Queries, Relational Database Management Systems and Excel recommended
Access Level 3
This course picks up where Access 1 & 2 leaves off. You will learn to utilize web capability by creating hyperlinks and build order forms for Internet use. You will learn more in-depth tricks and tips to maintaining data integrity. You will integrate information from other applications by linking and importing Excel spreadsheets as new tables, and adding to existing tables. You will also learn how to create cross-tab queries.
Prerequisite: Introduction to Access and Access Level 2, Relational Database Management Systems and Excel Level 1
Access Part 4
In this course, students will be introduced to security issues and learn how to set up a Switchboard in Microsoft Access. Advanced Query Wizards, Action Queries and Briefcase replication will also be covered. Students will design advanced forms, where one field of information is entered, and an entire record is returned, as well as additional form and report concepts. Students will learn the next steps in automating tasks with Macros.
Prerequisite: Access Parts 1-3, Relational Database Management Systems and Excel Level 1
Relational Database Management Concepts
This session will cover the concepts and principles between Relational Database Concepts. What is a Relational Database? Why do you set up multiple tables and relationships between them? This course is a prerequisite to the Microsoft Access series and will answer these questions and more, preparing the student to learn conceptually what a relational database is and why it is critical to the success of any database application you will be working with (e.g., Microsoft Access, Oracle, dBase, etc.).
Prerequisite: Introduction to Excel is HIGHLY recommended
Digital Camera Basics
Got a digital camera you aren’t sure what to do with it? Learn the basics of operating your camera, what is the difference between digital and optical zoom, how to connect it to your computer and how to get pictures from your camera into your computer. Students will also learn the basics of storing, organizing and printing digital pictures.
Digital Photo Editing
Once you know the basics of using your Digital Camera, this class will show students how to edit pictures, lighten and darken images, remove red eyes or unwanted objects and more. In addition to learning the basics of photo editing, students will also learn how to create a photo slide show, add music and other bells and whistles!
Prerequisite: Digital Camera Basics or equivalent knowledge of camera operation
This course is an introduction to the functions of the primary Lotus Notes databases: Email, Personal Address Book, Calendar and To Do lists. Basic skills of Email are covered, addressing mail, sending and receiving messages, formatting text with different fonts and colors. You will learn how to use the various address books and how to build your own Personal Address Book and Personal Mailing Lists. Calendaring functions include how to schedule meetings with multiple participants, appointments and anniversaries, reserving meeting rooms and how to follow-up on who is confirmed, declined, etc. The last part of the last session concentrates on Group Calendaring functions. There will be a break before the Group Calendaring section, providing an opportunity for those who do not need these skills to leave.
Learn hands-on the basics of the Internet, what it is and how to use it without so much frustration. What are Browsers and Search Engines? What is an ISP? How do I find addresses, phone numbers and maps? How do I get connected and how much should it cost? How to I use email? The answers to these questions and more will be covered in this 3-week class.
Intro to PCs and Windows
This course is for the person with little or no computer experience. Aspects of hardware, software and peripherals (printers, scanners, etc.) are explained. Learn the difference between megabytes and kilobytes, harddrive space and memory. Learn what processor speed means and how to make a good computer buy (when to upgrade or buy new). The third session concentrates on the basics of the Windows operating system, using the mouse, changing backgrounds and screen savers, what files and folders are, how to copy from the harddrive to a floppy disk and more.