Course Descriptions & Prerequisites

Jump to:

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 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 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.

Windows 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 such as taking a screenshot or screen clipping, screen annotations in PowerPoint, and using the translation feature in Word.
Prerequisite: PC Literacy I and II or familiarity with the mouse, keyboard, and basic Microsoft Office tools.

Microsoft Office Courses

Switching to Office 2016 

Learn the layout of the newest version of the Microsoft Office Suite. With the newest office features you can: use the Tell Me box to search Office programs, insert online pictures without leaving Office programs, work together with other collaborators in real time in Office, open a PDF to edit it in Word, use a touch device to write equations by hand in Excel, or record steps on your screen and insert them as a video in PowerPoint.
Prerequisite: Word, PowerPoint or Excel I or equivalent experience with the Office Suite.

Microsoft Word 2016


Word I

Learn how to navigate the word processing program and use Word to create, open, save, format, print, and close documents such as a letter or a handout. Learn to use the clipboard to copy and paste as well as use keyboard shortcuts.
Prerequisite: PC Literacy I and II or familiarity with the mouse and the keyboard.


Word II

Learn page and paragraph formatting as well as how to organize lists of information in documents using tabs, bullets, and numbering. Learn to use find and replace to make a change several times throughout a document or create your own autocorrect entry to fix common typing errors. Learn how to insert a header or footer to repeat on each page, or insert decorative text called WordArt.
Prerequisite: Word I or equivalent computer experience (see above).


Word III

Learn how to organize information using multiple columns or in a grid using a table. Learn how to enhance and illustrate your documents by inserting and formatting pictures and shapes. Learn how to use footnotes and endnotes to provide references to text in a document. Learn how to create letters, address labels, envelopes, or more for mass mailings.
Prerequisite: Word II or equivalent computer experience (see above).

Word IV

Learn how to use styles to create outlines or a Table of Contents and how to change the overall look of a document using pre-designed themes. Learn how to use pre-formatted sample documents called templates to create reports, resumes, and more. Learn how to collaborate with other users (in real time or using comments/track changes) and to apply password protection to a document with secure information.
Prerequisite: Word III or equivalent computer experience (see above).

Microsoft Excel 2016

Excel I

Learn how to navigate the spreadsheet program and use Excel to create, open, save, format, print, and close workbooks such as a budget. Learn how to insert and resize rows/columns as well as copy, paste, and sort data. Learn how to create a chart to visualize data and use formulas/functions to perform calculations within a worksheet.
Prerequisite: Word and PowerPoint series or equivalent computer experience (see course descriptions).


Excel II

Learn how to use cell referencing to update formulas automatically and Autofill/Autocomplete to copy formulas and data to other cells easily. Also learn how to use Autosum to total figures such as on a sales report. Learn how to join text from two columns using the concatenation function, such as combining cells with first and last name listed in separate columns on a payroll worksheet. Other topics include sort & filter, freeze panes, hiding rows/columns, managing worksheets, and inserting headers, footers, and comments.
Prerequisite: Excel I or equivalent computer experience (see above).


Excel III

Learn how to import data from an external source such as a CSV file, as well as more formulas including subtotal, average, and logical (if, then) functions. Learn how to use macros to record the commands of repetitive tasks for reuse such as subtotaling payroll data. Also learn page layout options to prepare your spreadsheet for printing and how to search for pre-designed templates such as a billing statement. Learn how to analyze/visualize data such as sales figures using conditional formatting or sparklines.
Prerequisite: Excel II or equivalent computer experience (see above).


Excel IV

Learn how to create and customize PivotTables which can be used to summarize, analyze, explore, and compare data such as sales figures. Learn how to use the Vlookup function to find information in a data range such as looking up a price by part number. Also learn how to use the payment (PMT) function to calculate loan amounts such as on an amortization schedule. Other topics include protecting cells/worksheets that contain secure data, defining data as a table, and entering data using forms and drop-down lists. Also includes a bonus exercise: creating floorplans.
Prerequisite: Excel III or equivalent computer experience (see above).

Microsoft PowerPoint 2016


PowerPoint I

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 to add visual aids to your slideshow. Learn how to take an outline created in Word and import it onto your slides. Also learn how to use the Design tab to apply themes and variants to coordinate a presentation with colors, graphics, and fonts that have a cohesive look.
Prerequisite: Word Series or equivalent computer experience (see course descriptions).


PowerPoint II

PowerPoint II
Learn how to make changes to multiple slides at once using Slide Master view as well as how to enhance presentations by inserting and formatting graphics and by adding transitions and animations. Learn how to find templates such as a business plan or create a customized slide design template for your company. Learn how to insert multiple pictures at a time to create a Photo Album such as a vacation slideshow and how to display data such as survey results using Charts.
Prerequisite:  PowerPoint I or equivalent computer experience (see above).

PowerPoint III

Learn how to enhance presentations with SmartArt graphics (such as an organizational chart), media (such as audio and video), and hyperlinks (such as linking to the web or another slide in the presentation). Learn how to create a custom theme including background graphics and color, font, and effect variants. Learn how to prepare for presenting by adding speaker notes, using slide timings, hiding slides, and pausing presentations. Also includes a bonus exercise: creating a collage.
Prerequisite:  PowerPoint II or equivalent computer experience (see above).

Microsoft Publisher 2016

Publisher I

Learn how to navigate the publication program and use Publisher to create, save, design, and print a publication. Learn how to use built-in templates (predesigned publications such as a letterhead, business cards, and more) as well as how to save your business information to be input into other publications. Learn how to create email publications such as an email newsletter. Learn how to export publications for printing options such as a desktop, copy shop, and commercial printing.
Prerequisite: Word series or equivalent computer experience (see course descriptions).
 

Publisher II

Learn how to link text boxes so that text flows from one box to another in a brochure or other publication.  Learn how to use a blank template to create a publication such as an invitation from scratch by inserting and formatting elements such as text, pictures, and shapes. Also learn how to perform a mail merge to populate an award certificate or other publication with the list of recipient names. Learn how to design a banner using Borders & Accents, WordArt, and other formatting options.
Prerequisite: Publisher I or equivalent computer experience (see above).
 

Publisher III

Learn how to format lists and line spacing to create an advertisement to be used in a printed publication or posted online. Learn how to use with rulers, position, and page setup to create and print gift certificates. Also learn how to work with predesigned page parts and advanced font formatting to create a menu and use Master Page to repeat design and layout elements on multiple pages in a calendar or other publication.
Prerequisite: Publisher II or equivalent computer experience (see above).
 

Google Courses

Google Apps I: Cloud Computing

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: Online Visuals

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 Google Apps I or equivalent experience (see above), including experience using the Internet and productivity applications.

Google Apps III: Online Surveys

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), including experience using the Internet and productivity applications.

Google Apps IV: Online 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), including experience using the Internet and productivity applications.

QuickBooks Courses

QuickBooks Online I

Learn how to access your QuickBooks Online subscription and eBook, how to navigate the user interface and some basic accounting concepts. Also learn how to set up a company file including a chart of accounts and products/services. Learn how to add and manage users and enter opening balances and/or historical transactions.
Prerequisite: MS Excel Series or equivalent computer experience (see course descriptions) as well as experience using the Internet and an understanding of basic accounting concepts.

QuickBooks Online II

Learn how to use the QuickBooks Online Customers Center to add, import, edit, merge, and delete customers. Learn how to record sales transactions by creating and customizing sales receipts and invoices. Also learn how to receive customer payments, record a bank deposit, and create customer/sales reports.
Prerequisite: QuickBooks Online I. The QuickBooks courses must be taken as a series, this course cannot be taken separately.

QuickBooks Online III

Learn how to use the QuickBooks Online Vendors Center to add, import, edit, merge, and delete vendors. Learn how to create vendor transactions such as purchases and expenses, customize expense forms, and create check, expense, and bill records. Also learn how to manage accounts payable by creating accounts payable (and other vendor) reports, as well as pay bills.
Prerequisite: QuickBooks Online II. The QuickBooks courses must be taken as a series, this course cannot be taken separately.

QuickBooks Online IV

Learn how to manage the QuickBooks Online Banking Center, set up and use bank feeds, and manage bank rules. Learn to enter transfers, deposits, and debit/credit card transactions. Also learn how to reconcile accounts and prepare end-of-period financial statements such as a balance sheet and profit-loss statement.
Prerequisite: QuickBooks Online III. The QuickBooks courses must be taken as a series, this course cannot be taken separately.

EB Create Courses

Adobe Photoshop

Photoshop I

Learn the basics of the image editing software Photoshop including how to navigate the interface, work with tools and other panels, and customize the Photoshop environment. Also learn introductory tasks such as cropping, resizing, and rotating images. Learn the various saving and file format options as well as Photoshop purchasing options and alternatives.
Prerequisite: Must have basic computer skills as well as experience using the Internet and productivity applications.  

Photoshop II

Learn intermediate Photoshop tasks such as understanding how to use the two main types of layers (content layers and adjustment layers). Also learn how to improve the look of your images using corrections including levels, curves, colors, sharpening, and noise reduction.
Prerequisite: Photoshop I or equivalent experience (see above).

Photoshop III

Learn how to do more with layers, including opacity, blending modes, masks, and groups. Also learn how to work with brushes to paint on any layer as well as add and customize text in a project.  Learn how to read a histogram which can tell you different things about the shadows, midtones, and highlights of an image.
Prerequisite: Photoshop II or equivalent experience (see course description).

iPad

iPad I: Introduction

Learn iPad basics such as an overview of buttons, controls, gestures, and screens as well as how to set up your device. Learn how to search, arrange, and organize your apps and how to manage sharing, privacy, and security. Also learn how to type and edit text and use apps such as Safari (web browsing), Mail, Contacts, FaceTime, and more.
Prerequisite: There are no prerequisites for this course.

iPad II: Digital Media

Learn how to use the iPad’s camera app to take photos, and the photo app to view, organize, and edit the photos you take. Learn how to use iTunes to find and purchase music, movies, TV shows, and more. Learn how to use iMovie to create a movie using photos, video clips, text, and audio.
Prerequisite: iPad I or equivalent experience (see above).

iPad III: iWork

Learn how to use the iPad’s suite of productivity tools, known as iWork, which consists of the Pages (Apple’s word processing program), Keynote (Apple’s presentation program), and Numbers (Apple’s spreadsheet program) apps. Learn how to use Pages to create word processing or page layout documents, Keynote to create dynamic presentations, and Numbers to create data-rich spreadsheets.
Prerequisite: iPad II or equivalent experience (see above).

iPad IV: eBooks

Learn how to use the iPad’s iBooks app to get books and PDF files, read them and interact with multimedia, listen to audiobooks, and organize your eBook collection. Learn how to install and explore the Kindle app for iPad. Also learn how to use the OverDrive and Hoopla apps which give you access to eBooks & audiobooks with your East Brunswick library card.
Prerequisite: iPad III or equivalent experience (see above).

To check the schedule of computer training classes or register for any of the above courses, please visit the Library Calendar page. You can register from the event page or by calling customer service at 732-390-6767.

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 Technology Training Page