Computer Classes

UW-BSC Continuing Education offers a variety of non-credit computer courses for students and community members.

Fall 2014 Computer Classes

 

WINDOWS  7

Go to Registration Page

Instructor: Terri Nee-Holtz
If you feel uncomfortable when you sit down at your computer or feel there are more ways to use your computer, this course is for you. Windows is the operating system (OS) that allows your computer to run all other applications. In this course, you will get hands-on experience with all the things Windows can do.
Work with documents (create, save, open) and create a filing system to organize your documents. Learn shortcuts to copy, move and delete current files. Learn to search for documents and photos by using tags, dates, name of author, etc.
Learn how to customize your computer so that it works best for you by changing Windows settings, running computer maintenance, and creating shortcuts to your most used applications and files.
Tuesday, October 7 • 6-9 pm
Computer Lab, Aural Umhoefer Classroom Building
Fee: $39

ORGANIZE YOUR COMPUTER WORKSPACE

Go to Registration Page

Instructor: Terri Nee-Holtz
Do you find yourself saying “where did the computer store that file?” This course will solve that mystery. Learn to manage your documents, favorite websites, and photos. Organize your email and keep it organized by creating folders and have incoming messages sent to the folders upon receipt. Block senders and manage multiple emails in one click. Store and organize your favorite websites so they are at your fingertips.

Tuesday, October 21 • 6-9 pm
Computer Lab, Aural Umhoefer Classroom Building
Fee: $39

MICROSOFT WORD

Class Canceled due to Low Enrollment

Instructor: Terri Nee-Holtz
You can do more with Word than typing text. Learn how to use templates, and how to create and save documents in different versions of Word. Create a collaborative document, leave comments for your co-authors, track changes made by each co-author, and accept or reject those changes. Create a report with a Table of Contents and Bibliography. Quickly create a document by storing repetitive strokes in a macro, learn keyboard shortcuts of most-used commands, and use the Find and Replace feature to change a word, text, or phrase that is used multiple times within the document with one click.

BEGINNING WEB DESIGN USING WORDPRESS

Go to Registration Page

Instructor: Marc Boucher
UW-Baraboo/Sauk County Library Director
You can use WordPress for any kind of Website you want to create! This hands-on class will give you the tools to create your own web page with this easy-to-use software.

Thursday, October 9 • 5-7 pm
Campus Library Computer Lab
Fee $29

GOOGLE DOCS

Go to Registration Page

Instructor: Terri Nee-Holtz
Google Docs is a free office suite that allows you to create your work online and access your documents from anywhere. Create and manage documents, spreadsheets, presentations, and more, all in one. You can also collaborate with other users in real time. Documents can be shared, opened, and edited by multiple users simultaneously. Users can be notified when a comment or discussion is made or replied to, facilitating collaboration.
NOTE: Students must have a gmail account before class begins. If you do not have
a gmail account, contact the Continuing Education office prior to class, and an account will be created for you. If you have an existing gmail account, you must know your username and password to access the account during class.

Friday, October 10 • 12:30-3:30 pm
Campus Library Computer Lab
Fee: $39

USING EXCEL TO TAKE FORMULAS TO A NEW LEVEL

Go to Registration Page

Instructor: Terri Nee-Holtz
Have you ever struggled just to get the work done any way you can? Why not do it the easy, fast, and skillful way? Break free of old habits and increase your productivity with Excel power tools. Master formulas and functions that put spreadsheet power at your fingertips! Learn to use Name Manager, which allows you to use text to write formulas in place of cell references.
Create a 3-D (Consolidated Worksheet) and create formulas using cells from other worksheets. Learn techniques to make editing easier. Once the values are entered, you can design and organize worksheets, and give them visual punch with exciting charts and SmartArt. Learn to change the print layout with page breaks, margins, repeating column and row headings to multiple pages. Most importantly, set up protection of your worksheets so co-workers can only edit what you give permission.

Fridays, October 17 and October 24 • 12:30-3:30 pm
Campus Library Computer Lab
Fee: $78 for 2 Fridays

USING EXCEL AS A DATABASE

Go to Registration Page

Instructor: Terri Nee-Holtz
Excel has many great features that allow users to create and maintain a large database. Once data is entered, you can update, sort, search, filter/retrieve subsets of data, summarize data by inserting subtotals, and create reports. Make important data stand out by setting up conditional formatting. This feature will change the formatting of all cells that meet the condition. Learn to import and export Excel data with other Microsoft applications. Exported data may be linked so the original and the exported file are updated together.

Friday, November 7 • 12:30-3:30 pm
Campus Library, Computer Lab
Fee: $39

USE EXCEL TO ANALYZE AND PREDICT

Go to Registration Page

Instructor: Terri Nee-Holtz
Once your worksheet is created, it can be difficult to find a formula error. Use the feature Trace An Error to identify the formulas and cells that are causing the error. Here are some of the features this class will cover:
a) What-If Analysis with Goal Seek: Allows you to explore the impact of changing different values in a worksheet.
b) Create and chart a One-Variable and Two-Variable Data Table: Useful to determine the impact of different values. IE Impact different interest rates and the length of mortgage on the calculated monthly payment.
c) Scenario Manager: Each scenario includes a scenario name, input or changing cells, and values of each input cell. The number of scenarios you can create is unlimited.
d) Pivot Tables and Charts: An interactive table used to group and summarize a range of data or an Excel table into a concise, tabular format for easier report and analysis.

Friday, November 21 • 12:30-3:30 pm
Campus Library Computer Lab
Fee: $39

FINDING WHAT YOU NEED IN THE INFORMATION AGE

Go to Registration Page

Instructors: UW-Baraboo/Sauk County Academic Librarians
In these days of information overload, learn from academic librarians how to sort through the mass of information available. This class will help you discover resources you didn’t know you had access to, and also help you become more efficient and confident when searching for information on the Web.

Tuesday, October 28 • 5:00-6:30 pm
Campus Library Computer Lab
Fee $19