Computer Classes

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

Winter Spring 2015 Computer Classes

 

WHERE DO I START WITH MY COMPUTER?

Register Online 

Instructor: Terri Nee-Holtz

In this class, beginning computer users will learn the basics needed to get the best use of the Computer Windows screen. Participants will also cover setting mouse and screen preferences plus operating various windows. Learn to open and close window options, scroll through windows, switch between multiple windows, review items on the taskbar, set time/date and discuss proper shutdown procedures.

Wednesday, January 21 • 9:00 am-12:00 pm

Computer Lab, Aural Umhoefer Classroom Building

Fee: $39

 

The following classes are hands on courses using Microsoft 2013. Feel free to bring your own data to practice with. All classes take place in a computer lab with a computer station available for each student. You may also bring in your own laptop.

 

Save Time and Create Efficiency with Object Linking and Embedding, Macros, and Mail Merge

Register Online 

Instructor: Terri Nee-Holtz

* Linking permits the two-way passing of instructions and data between applications allowing users to integrate data from different applications. Object linking allows users to share a single source of data for a particular object. When the source is updated, all the documents using the data are updated as well.

* Learn to create macros to help you automate a task by storing the series of commands and functions needed to perform the task. You then run the macro to repeat, or "play back," the commands.

* Use mail merge to create and print letters and other documents that are sent to many recipients. Each document has the same kind of information, yet some of the content is unique.

 Friday, February 27th • 9:00 am - 12:00 pm

Campus Library Computer Lab

Fee: $39

 

Excel: Performing What-If Analysis

Register Online 

Instructor: Terri Nee-Holtz

For more advanced projects, you may want to consider the types of what-if analysis: scenarios and data tables. Rather than starting from the desired result and working backward, these options allow you to test multiple values and see how the results change. Scenarios let you substitute values for multiple cells at the same time. You can create as many scenarios as you want and then compare them without changing the values manually. When each scenario is selected, it will replace the values in the spreadsheet with its own values, and the result will be recalculated. Data tables allow you to take one or two variables in a formula and replace them with as many different values as you want, then view the results in a table. This option is especially powerful because it shows multiple results at the same time.

Friday, March 6th • 9:00 am-12:00 pm

Campus Library Computer Lab

Fee: $39

 

Excel: Working with Pivot Tables & Charts for Data Analysis & Reporting

Register Online 

Instructor: Terri Nee-Holtz

Do you struggle with the type of Excel charts to use in your analytics reports? Does the charted data display the data in the best possible manner? Why is it important to create the right chart? Charts show trends or relationships in data that are more difficult to see by simply looking at numbers. We use charts to tell stories, evaluate alternatives, understand trends or find-out if everything is normal. Learn the charts that are available, how to create them and personalize them by formatting with colors, comments, photos, etc. Learn how to create compact graphing; insert charts within worksheet cells, and much more. Pivot Tables and PivotChart A PivotTable report is useful to summarize, analyze, explore, and present summary data. A PivotChart report can help you visualize PivotTable report summary data so that you can easily see comparisons, patterns, and trends. Both enable you to make informed decisions about critical data in your enterprise. These items are great to use when you have a large amount of data to analyze for they allow you to quickly select only the necessary data and arrange it on the worksheet in the format that works best for you.

Friday, April 10th • 9:00 am-12:00 pm

Campus Library Computer Lab

Fee: $39

 

Creating Better Documents with Microsoft Office Word 2013

Register Online 

Instructor: Terri Nee-Holtz

Creating and formatting a Word document that stands out from all the others involves more effort in formatting your document. This class will help you master Word's advanced formatting options. Some of the topics covered will be: customizing your document with a cover page; adding a table of contents; inserting drop caps in your word document; adding a chart to your document; formatting your document with columns, tabs and tables; cite sources by using words citation feature that tracks and compiles; create footnotes and endnotes.

Friday, April 24 • 9:00 am - 12:00 pm

Campus Library Computer Lab

Fee: $39

 

BadgerLink: Wisconsin’s Online Library

Register Online 

Instructor: Cate Booth, Academic Librarian, UW-Baraboo/Sauk County

BadgerLink is a suite of online resources available to all Wisconsin residents. From historical research to medical information to business and consumer information, BadgerLink provides access to reliable, high-quality, advertisement-free content. In addition, BadgerLink resources provide access to newspapers, magazines, and even literature. This workshop will provide an introduction to BadgerLink resources, tips for searching, and allow participants to gain hands-on experience using the tool.

Tuesday, April 14th • 5:30-7:00 pm

Campus Library Computer Lab

Fee: $19