DRIVER'S.ED FOR THE INFORMATION SUPERHIGHWAY • SPRING 99
PAGE 1.1
non-University. www.cc.ukans.edu/acs/docs/wkshop/excel5.0-interm.pdf February 11, 1-4 p.m., CC PC Lab March 9, 1-4 p.m., CC PC Lab
Excel: Functions and Data Analysis Tools
Learn about the various types of functions in Excel and how to use the Function Wizard. We'll create a VLOOKUP function to merge two sets of data, provide arguments for the IF function to do a conditional count, and manipulate strings of characters with the CONCATENATE function. We also access the Data Analysis ToolPak (an Excel add-in) to create a histogram and chart to show frequency of values. Prerequisite:Excel:Intermediate. Requires registration for all and a $75 fee for non-University. www.cc.ukans.edu/acs/docs/wkshop/excel5.0-advanced.pdf
February 23,1-4 p.m., Budig PC Lab
April 6,1-4 p.m., CC PC Lab
Making the Most of Microsoft Office Help NEW!
The Microsoft Office suite of programs, Word, Excel, PowerPoint, and Access, don't have manuals because the documentation is available in the programs. Under the Help menu are thousands of pages of step-by-step how-to's, instructions, and definitions to help you do everything you need or want to do. In this demonstration, you learn the basic structure of the Help files, and some strategies for finding the topic you're looking for, plus you will see how to find information on merging an Excel file and a Word file. The last half of the class will be open to questions.
February 18,1-2:30 p.m.,CC Auditorium March 16,4-5:30 p.m.,CC Auditorium
PowerPoint: Introduction
Learn to make and modify a simple presentation, add and format text, use basic drawing tools, and change color schemes. Explore PowerPoint's built-in templates and wizards, learn to prepare speaker's notes, and create handouts for your audience. Package your presentation as a slide show, learn to use the Pack and Go feature (that allows you to give your presentation from a computer without the PowerPoint software) and run the completed slide show. Prerequisites: Word processing skills and experience in a Mac OS or Windows environment. Requires registration for all and a $75 fee for non-University. www.cc.ukans.edu/acs/docs/wkshop/powerp-intro-handout.pdf
January 20,1:30-4:30 p.m.,CC PC Lab February 23,6-9 p.m.,CC PC Lab March 10,1:30-4:30 p.m.,CC PC Lab
PowerPoint: Intermediate
Explore some advanced features of PowerPoint, including inserting charts and graphics, using the drawing tools to enhance your message, and adding transitions and action buttons to your slide show. Learn to modify PowerPoint template graphics to meet your presentation needs. And finally, convert your completed presentation to an HTML document for use on the World Wide Web. Prerequisite:PowerPoint: Introduction or equivalent skills. Requires registration for all and a $75 fee for non-University. www.cc.ukans.edu/acs/docs/wkshop/powerp-interm-handout.pdf
February 9,1-4 p.m., CC PC Lab
April 7,1-4 p.m.,CC PC Lab
SPSS: Introduction
With SPSS for Windows or Mac OS you don't need to know the command language to perform statistical analyses. Learn to enter, save, and retrieve data, request analyses, and create graphs. Prerequisite:Experience in a Windows or MacOS environment. Requires registration for all and a $75 fee for non-University.
SPSS: Intermediate
January 22,1-4 p.m.,CC PC Lab
Do you need to learn advanced data and file manipulation techniques? In this course, participants learn to merge data files, recode variables, combine several variables into one, and much more. Prerequisite:SPSS:Introduction (or equivalent skills). Requires registration for all and a $75 fee for non-University.
February 5,1-4 p.m., CC PC Lab
Microsoft Office
Microsoft Office is a suite of integrated software for word processing (Word), spreadsheet (Excel), presentation (PowerPoint), and database (Access).
PowerPoint
PowerPoint, available with Microsoft Office, is presentation software that creates and displays professional slide shows.
SPSS
SPSS is a statistical program used for advanced data analysis.