Technology - Black Hawk College

Technology

Program Description

Level 0   Introductory class for the novice and those who need to understand basics.

Level 1   For those who understand basic computer concepts and terminology.

Level 2   For more experienced students who want to expand their knowledge and computer skills.

Classes that meet from 8:30 a.m. – 3:00 p.m. or 8:30 a.m. – 4:30 p.m. will break for a 30-minute lunch (on your own.)

Unless noted, technology classes are held in-person.

 

Word Level 1                                       

Instructor: N. VanSpeybroeck

Prerequisite: Basic Windows and keyboarding skills.

Level 1 – Create basic documents using the following skills:  cutting, copying, pasting, and formatting text, aligning and indenting paragraphs, adding numbered and bulleted lists, inserting dates and symbols, changing margins, switching document views, running the spelling and grammar checker, and printing a document.

1 Tuesday             Apr. 13                 8:30 a.m. – 3:00 p.m.

CRN 10900           BHC ALC – Rm. 111             Fee $85

 

Word Level 2                                      

Instructor: N. VanSpeybroeck

Prerequisite: Word Level 1 or equivalent skills.

Level 2 – Take your Word skills to the next level by creating professional documents using: styles and themes, tabs, headers and footers, tables, graphics including pictures, clipart and SmartArt, newspaper-style columns, watermarks and more.

1 Tuesday             Apr. 20                 8:30 a.m. – 3:00 p.m.

CRN 10901           BHC ALC – Rm. 111             Fee $85

 

Word Level 3                                        

Instructor: N. VanSpeybroeck

Prerequisite: Word Level 2 or equivalent skills.

Level 2 – Do you already use Microsoft Word extensively but aren’t aware of the many time saving steps and features? Increase your productivity by learning shortcuts that transform your files into impressive, professional-looking documents. Learn more about styles, tabs and templates. Discover mail merge, Quick Parts and how to sort tables. Explore ways to save time and ensure that repetitious tasks are performed consistently and accurately by creating macros to perform a series of actions.

1 Tuesday             Apr. 27                 8:30 a.m. – 3:00 p.m.

CRN 10902           BHC ALC – Rm. 111             Fee $85

 

Excel Level 1                                           

Instructor: N. VanSpeybroeck

Prerequisite: Basic Windows skills.

Level 1 – Microsoft Excel is an important spreadsheet application that is essential for use at home and at work. Some of the topics that are covered include: creating and saving a new workbook, working with ranges, creating simple formulas, copying and moving data, formatting numbers and text, formatting cells, working with columns and rows, using page setup, printing, and using templates.  A workbook is included in the fee.

1 Tuesday             June 8                   8:30 a.m. – 4:30 p.m.

CRN  50194          BHC ALC – Rm. 111             Tuition Fee $97

 

Excel Level 2                                           

Instructor: N. VanSpeybroeck

Prerequisite: Excel Level 1 or equivalent skills.

Level 2 – Enhance and develop your spreadsheet skills. Customize the Ribbon, use advanced formulas, create 3-D formulas across multiple worksheets, move, copy and color code worksheet tabs, sort and filter data, name ranges, create charts, insert graphics and more. A workbook is included in the fee.

1 Tuesday             June 15                8:30 a.m. – 4:30 p.m.

CRN 50195           BHC ALC – Rm. 111             Tuition Fee $97

 

Excel Level 3                                             

Instructor: N. VanSpeybroeck

Prerequisite: Excel Level 2 or equivalent skills.

Level 2 – Further develop your Excel expertise by learning how to: create and revise Pivot Tables, record macros and create shortcut buttons, use advanced chart features, export and import data, outline and subtotal data, work with tables, make and track comments, create conditional formatting, use advanced functions including LOOKUP and nested IF formulas, password protect worksheets or cells and more! A workbook is included in the fee.

1 Tuesday             June 22                 8:30 a.m. – 4:30 p.m.

CRN 50196             BHC ALC – Rm. 111           Tuition Fee $97

 

Access (Parts 1-3)  CANCELLED                           

Instructor:  E. Duffy
Level 2 – This series will teach what you need to know to work with an existing database or create one of your own. By the end of the series, you will know how to create and work with tables, queries, forms and reports. A workbook is included in the fee for each class.

 

Part 1  CANCELLED                                                                              

Prerequisite: Basic Windows, MS Word and Excel, and an understanding of a database.

Learn to create and work with tables, the foundation of your database. Specific skills to be covered include creating tables, editing and modifying tables, setting field properties, finding and filtering data, creating relationships, using simple queries, and printing data.

1 Wednesday       May 5                   8:30 a.m. – 3:00 p.m.

CRN 10906           BHC ALC – Rm. 111             Fee $89

 

Part 2    CANCELLED                                                                                      

Prerequisite: Access Part 1 or equivalent skills.

Learn to make your data work for you. Take this class to learn to make more sophisticated queries, forms and reports. Specific skills to be covered are creating action queries; manipulating controls; using design view, editing tools and sub-forms; and creating a PivotTable.

1 Wednesday       May 12                 8:30 a.m. – 3:00 p.m.

CRN 10907           BHC ALC – Rm. 111             Fee $89

 

Part 3      CANCELLED                           

Prerequisite: Access Part 2 or equivalent 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 Part 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 19                 8:30 a.m. – 3:00 p.m.

CRN 10908           BHC ALC – Rm. 111             Fee $89

 

PowerPoint                                                     

Instructor: N. VanSpeybroeck

Prerequisite: Word skills.

Level 1 – Explore how to create attention-getting presentations with MS PowerPoint. Learn how to use the templates; format and edit text; prepare and print outlines, handouts, and speaker notes; add special effects like sound and animation; insert graphics and tables; use transitions and timing; and run the slide show. Bring a USB flash drive or information you want to include in your own presentation. A reference guide is included in the fee.

1 Tuesday             July 13                  8:30 a.m. – 3:00 p.m.

CRN  50197          BHC ALC – Rm. 111             Fee $85

 

Publisher                             

Instructor: N. VanSpeybroeck

Prerequisite: Word skills.

Level 1 – Use Publisher’s templates and design elements to create professional looking marketing materials such as fliers, newsletters, brochures, business cards, letterhead and more! A reference guide is included in the fee.

1 Tuesday          July 20                       8:30 a.m. – 3:00 p.m.

CRN 50198           BHC ALC – Rm. 111             Fee $85

 

iPad: Beginner                                              

Instructor: M. DeGrauwe

Level 1 – Are you unsure how to use your iPad? Learn the basics of using your device from settings to apps.  Understand your Home Screen. Learn how to use the Internet, how to add contacts, how to set up an e-mail account and how to navigate the app store and iTunes. Bring your iPad to class. You should have your iPad charged and activated. You should also have created your Apple ID.

1 Monday             Apr. 12                                5:30 – 7:30 p.m.

CRN 10915           Outreach – Rm. 402            Fee $25

 

iPad: Intermediate                                      

Instructor: M. DeGrauwe

Level 2 – Increase your iPad skills and knowledge through tips and tricks for using this device. Explore some of the more interesting and unique applications available for iPad users. Discover FaceTime and how to make video calls with family and friends. Bring your iPad to class.

1 Monday             Apr. 26                                5:30 – 7:30 p.m.

CRN 10916           Outreach – Rm. 402            Fee $25