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. A workbook is included in the fee.

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. A workbook is included in the fee.

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            Mar. 2                   8:30 a.m. – 4:30 p.m.

CRN 10903          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            Mar. 9                  8:30 a.m. – 4:30 p.m.

CRN 10904           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            Mar. 16                8:30 a.m. – 4:30 p.m.

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

 

Access (Parts 1-3)                                      

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                                                             

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                                                               

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                                                             

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            Mar. 30                8:30 a.m. – 3:00 p.m.

CRN 10909          BHC ALC – Rm. 111          Fee $85

 

iPad: Getting Started                       

Instructor: M. DeGrauwe

Level 0 – Do you have an iPad and don’t know where to start? We will explore the Home Screen, the parts of your device and the main apps: settings, calendar, contacts, and mail. We will learn how to connect to Wi-Fi, get to the Internet using Safari, add contacts, set up your email account, and schedule dates in your calendar. Bring your iPad to class. You should have your iPad charged and activated. You should also have created your Apple ID.

4 Mondays          Mar. 8 – Mar. 29              5:30 – 7:00 p.m.

CRN 10914          Outreach – Rm. 402         Fee $55

 

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

 

3D Printing I            

Instructor: R. Vedvik, Electrical Engineer/Acoustics Engineer    

Level 1 – This class will provide the home hobbyist, or those looking to start or expand a business, with the knowledge and hands-on experience needed to get started with, or improve on, 3D printing. Topics include how 3D printers work, printer selection, setup and maintenance, printing material selection and chemistry, design strategies, troubleshooting, and software applications. Live demonstrations of 3D software and slicing software will help students modify or create 3D computer models. A 3D printer will operate during the class to demonstrate how computer models are installed and printed, and to serve as an example for discussion.

(The first two classes will meet virtually.)

6 Wednesdays   Feb. 17 – Mar. 24             6:00 – 8:00 p.m.

Outreach – Rm. 407         Fee $79

In Person CRN 10917      Virtual Classroom CRN 10918

 

3D Printing II   

Instructor: R. Vedvik, Electrical Engineer/Acoustics Engineer

Prerequisite: 3D Printing I or permission from instructor.

Level 1 – A continuation of 3D Printing I.

(The first two classes will meet virtually.)

4 Wednesdays    Mar. 31 – Apr. 21           6:00 – 8:30 p.m.

Outreach – Rm. 407         Fee $65

In Person CRN 10919    Virtual Classroom CRN 10922

 

In-person vs. virtual classroom vs. online?

  • An in-person class provides the traditional on-site instruction.
  • A virtual classroom provides real-time, online instruction. A student is responsible for the technology needed to attend the class.
  • An online class provides online instruction but not in real-time. A student is responsible for the technology needed to complete the class.