Day Computer Classes

Last updated 4/25/2014

Business Group Discounts
The following discounts are based on the number of employees enrolled in 1 class:
10% off total fee (6-7 people)
12% off total fee (8-9 people)
15% off total fee (10-11 people)
20% off total fee (12-13 people)
Lab Rental
Interested in renting a computer lab for your company? Labs are available with Microsoft Office 2010, Windows 7, Windows 8 and Internet. Call 309-796-8244 for more details.

Classes that meet 8:30 a.m. to 3 p.m. break for half hour lunch (on your own.)

Online Surveys
Instructor: N. VanSpeybroeck
Create free online surveys to poll, collect data or feedback from your customers, employees, or members of school, club, non-profit, or other groups. Customize survey questions, analyze, and share the results. Promote the survey with a link on your Facebook page or website. Simply design surveys in minutes to collect valuable information!

1 Thursday      May 8                        8:30-11 a.m.
CRN 11736      Outreach-Rm. 402      Fee $25

Excel Level 3
Instructor: N. VanSpeybroeck
Prerequisite: Excel Level 2 skills.
Take your Excel skills to the next level.

  • Use advanced chart features
  • Outline and subtotal data
  • Export and import data
  • Work with tables
  • Use advanced data filtering
  • Work with comments
  • Use conditional formatting and more

1 Tuesday       May 6                        8:30 a.m. to 3 p.m.
CRN 11751      BHC ALC-Rm. 112      Fee $90

Excel Level 4
Instructor: N. VanSpeybroeck
Prerequisite: Excel Level 3 skills.
Our final session concludes the Excel learning series by learning how to:

  • Create and revise Pivot Tables
  • Record macros and create shortcut buttons
  • Use advanced functions including LOOKUP and nested IF formulas
  • Password protect worksheets or cells
  • Work with Outlines

1 Tuesday       May 13                      8:30 a.m. to 3 p.m.
CRN 11754      BHC ALC-Rm. 112      Fee $90

Access 2010 Level 1
Instructor: E. Duffy
Prerequisite: Basic Windows and data entry skills and an understanding of what a database is (queries/forms/reports).
From the beginning you will learn to create tables, the foundation of your database. By the end of this one-day class, you will be able to create simple queries to analyze the data from your tables, make forms for data entry and create reports. If you have used an Access database created by someone else, but now you need to make changes to the existing database, or create your own database, this is the course for you. Specific skills to be covered include: creating tables, editing and modifying tables, setting field properties, finding and filtering data, creating relationships, using simple queries, creating basic forms and reports and printing data.

1 Wednesday      May 7                       8:30 a.m. to 3 p.m.
CRN 11756         Outreach-Rm. 402      Fee $90

Access 2010 Level 2
Instructor: E. Duffy
Prerequisite: Access Level 1 skills.
In just one day, learn to make your data work for you. Take this class to learn to make more sophisticated queries, forms and reports. Whether modifying an existing database or creating your own, this is the class for learning how to customize it to get exactly what you want. Specific skills to be covered include: creating action queries, manipulating controls, using design view, using editing tools, sub forms and creating a PivotTable.

1 Wednesday      May 14                     8:30 a.m. to 3 p.m.
CRN 11758         Outreach-Rm. 402      Fee $90

Access 2010 Level 3
Instructor: E. Duffy
Prerequisite: Access Level 2 skills.
Don’t miss this class that pulls everything together. You have made the tables, queries, forms and reports, now automate them and learn tricks to make them work better. This class shows all the things Access has to offer to someone who has Level 1 and 2 skills. It also includes time for questions about your own database. Specific topics to be covered include: analyzing tables, exporting data to Excel and Word, using advanced query wizards, using charts, working with ActiveX controls and indexes, replicating databases, using Access and the Internet, creating and using macros and switchboards.

1 Wednesday      May 21                           8:30 a.m. to 3 p.m.
CRN 50382        Outreach-Rm. 402      Fee $90


Attention Teachers! Earn CPDU Credits

iPad for Teachers
Instructor: TBA
Are you fully utilizing your iPad in your classroom? Do you know how to find apps to help teach in class? With an iPad, you can teach the same lesson to all of your students but in different ways. Create materials that are tailored to your lessons and your class. Discover how to make learning fun.

1 Thursday       July 17                           8:30 a.m.-Noon
CRN 50421      Outreach-Rm. 406      Fee $35

Google Docs for Teachers
Instructor: TBA
This class introduces teachers to the world of Google Docs, an online word processor, spreadsheet and presentation editor that allows you and your students to create, store, share, and collaborate on documents. You can use Google Docs to provide feedback to your students, follow their work on assignments, collaborate with your colleagues on shared materials, and publish handouts and presentations online for your students and their parents. Google Docs will help you and your students stay organized!

1 Thursday       July 31                            8:30 a.m.-Noon
CRN 50422      Outreach-Rm. 402      Fee $35

BHC Hawk’s Hub (bookstore) information

For a list of PaCE books, visit the Quad-Cities Hawk’s Hub page. Click on “Buy Books – QC Campus” then click the box marked Adult Ed. Books may be purchased at the bookstore or online.