Course Descriptions & Prerequisites

Introductory Computer Courses

PC Literacy I

Learn computer terminology and components, how to turn the computer on and off, and an introduction to/practice with the mouse and keyboard. Learn how to navigate the desktop and open programs as well as basics of computer storage and hardware.
There Are No Prerequisites

PC Literacy II

Learn common window elements, how to multitask by switching between multiple open programs, and how to work with files and folders to create a file management system. Learn how to execute commands using toolbars, menus, ribbons, and shortcuts as well as how to copy and paste.
Prerequisite: PC Literacy I class or the ability to use a mouse and basic keyboarding skills.

Email Basics Part I

Learn how to register for an email account, receive/read messages, compose/send messages, and delete/restore messages. Learn how to sign out of your account and learn some basic email etiquette guidelines.
Prerequisite: PC Literacy I class or basic Internet and word processing experience.

Email Basics Part II

Learn how to use email to categorize your messages using tabs and labels, search through your messages, and add contacts/recipients. Learn how to send and receive attachments, links, and photos as well as some email safety tips.
Prerequisite: Email Basics I or basic email experience and a Gmail account.

Tips, Tricks, and Shortcuts

Learn to become more efficient by using shortcut keys/combinations (such as Function, Shift, Alt, Ctrl, Windows, and Tab keys) to perform commands in Windows, Office, and web browsers as well as some useful tricks in the Microsoft Office programs.
Prerequisite: PC Literacy I and II or familiarity with the mouse, keyboard, and basic Microsoft Office tools.

Microsoft Office Courses

Intro to Office 

Learn the layout of some of the most popular Microsoft Office Suite programs such as Word, Excel, and PowerPoint. Learn about the major changes to the latest version of office and the newest features in each of the programs.
Prerequisite: PC Literacy I and II or familiarity with the mouse and the keyboard.

Microsoft Word 2016

image

Introduction to Word

Learn how to navigate the word processing program and use Word to create, open, save, format, print, and close a document. Learn to use the clipboard as well as keyboard shortcuts.
Prerequisite: PC Literacy I and II; Intro to Office 2016 or familiarity with the mouse and the keyboard.

image

Word II

Learn how to set margins and tabs, format paragraphs, use bullets and numbering. Also learn how to use find and replace, insert headers and footers, and create autocorrect entries. Learn how to insert symbols and apply font effects, as well as insert WordArt.
Prerequisite: Intro to Word or equivalent computer experience (see above).

image

Word III

Learn how to work with tables and columns. Learn how to insert and format pictures and shapes. Learn how to insert footnote and endnote references as well as perform a mail merge using the Mail Merge Wizard.
Prerequisite: MS Word II or equivalent computer experience (see above).

image

Word IV

Learn how to work with themes and styles, insert a Table of Contents, and use templates. Learn how to collaborate on documents (using comments and track changes) as well as how to apply password protection.
Prerequisite: MS Word III or equivalent computer experience (see above).

Microsoft Excel 2016

image

Introduction to Excel

Learn how to navigate the spreadsheet program and use Excel to create, format, save, and print a worksheet. Also learn how to insert and resize rows/columns and use merge & center, AutoSum and AutoFill. Learn to how to create a formula using cell referencing and create a chart, as well as copy, paste, and sort data.
Prerequisite: MS Word and PowerPoint series or equivalent computer experience (see course descriptions).

image

Excel II

Learn more on AutoSum as well as how to use other functions and equations (including using cell referencing in your formulas). Learn how to copy formatting, formulas, and data using Format Painter, AutoFill, and AutoComplete. Learn more on sorting and filtering data as well as how to freeze panes and hide rows/columns. Also learn how to manage worksheets and add headers, footers, and comments.
Prerequisite: Intro to Excel or equivalent computer experience (see above).

image

Excel III

Learn how to import data from an external source and learn more on formulas such as subtotal, average, and logical (if, then) functions. Learn how to use macros to record the commands of repetitive tasks for reuse. Learn more about templates, as well as how to format spreadsheets using page layout options. Also learn how to analyze/visualize data using conditional formatting and Sparklines.
Prerequisite: Excel II or equivalent computer experience (see above).

image

Excel IV

Learn how to create and customize PivotTables, as well as use the VLOOKUP function to find information in a data range. Learn how to protect cells/worksheets and how to create and use data forms and drop-down lists. Also learn how to define your data as a table and use the Payment (PMT) function to calculate loan amounts.
Prerequisite: Excel III or equivalent computer experience (see above).

Microsoft PowerPoint 2016

image

Introduction to PowerPoint

Learn how to navigate the presentation program and use PowerPoint to create, save, run, view, and print presentations. Learn how to insert and format objects such as text boxes, shapes, and images as well as how to apply themes and variants using the Design tab.
Prerequisite: MS Word Series or equivalent computer experience (see course descriptions).

image

PowerPoint II

PowerPoint II
Learn how to make changes to multiple slides using Slide Master view, as well as how to find and create templates.  Learn how to enhance presentations by inserting and formatting graphics and by adding transitions and animations. Learn how to insert multiple pictures at a time using Photo Album and how to display data using Charts.
Prerequisite:  Intro to PowerPoint or equivalent computer experience (see above).

image

PowerPoint III

Learn how to enhance presentations with SmartArt graphics, media (such as audio and video), and hyperlinks. Learn how to create a custom theme and add speaker notes to presentations. Also learn how to set up a slide show to be presented using timings, hidden slides, and more.
Prerequisite:  PowerPoint II or equivalent computer experience (see above).

Google Courses

Introduction to Google Apps

Learn how to optimize web browsing using Google Chrome and how signing in to your Google account on Chrome gives you automatic access to other Google services. Learn how to use Google’s cloud storage service Google Drive to store, manage, and access files. Also learn how to use Google Docs to create word processing documents as well as share and collaborate with other users.
Prerequisite: Must have a Google account and basic computer skills as well as experience using the Internet and productivity applications.

Google Apps II: Visual Content

Learn how to create visually appealing digital slideshows using Google Slides, Google’s online presentation program. Learn how to design simple graphics and diagrams using Google Drawings. Also learn how to optimize searches for online pictures using Google Image Search, as well as how to store those pictures (and your own) using Google Photos.
Prerequisite:  Must have a Google account and Introduction to Google Apps or equivalent experience (see above).

Google Apps III: Data

Learn how to use Google Sheets, Google’s online spreadsheet program to create and format spreadsheets as well as how to use Google Forms to collect data through online surveys. Also learn how to use these two programs in conjunction utilizing Google Sheets to organize and analyze the data collected from Google Forms.
Prerequisite:  Must have a Google account and Google Apps II or equivalent experience (see above).

Google Apps IV: Communication

Learn how to use Gmail, Google’s email service, beyond sending and receiving emails to optimize workflow. Learn how to organize emails and use Google Contacts and Google Tasks in conjunction with Gmail to “work faster and collaborate better”. Also learn how to use Google Hangouts for video calls and group conversations as well as Google Calendar for scheduling.
Prerequisite:  Must have a Google account and Google Apps III or equivalent experience (see above).

To Register

To check the schedule of computer training classes or register for any of the above courses, please visit the Library Calendar page.

Disclaimer: By signing up for any of the above courses, you are certifying that you have the basic skills required to complete this class (as listed in the prerequisites). If you feel you do not meet the requirements, please refer to tutorial recommendations below or Contact the Trainers for a recommended training path. 

Back to the Computer Training Classes Page