Workshop Descriptions
Microsoft Access: Introduction
Microsoft Access is the relationship database system widely used by professionals. In this workshop, you will learn how to create a database, design tables and relationships from which query searches and selection, simple forms and reports can be created. This workshop will focus on building reports and developing queries. You will also learn some useful tips and strategies for customizing it to your specific department.
The Microsoft Access sessions will be held on 2 separate days to best accommodate faculty and staff’s work schedules. You MUST be able to attend both sessions.
In this workshop, you will learn how to use an Excel spreadsheet for data calculations and reports. You will learn how to create formulas, edit and format cells, manage workbooks, format worksheets, and create and modify charts. You will also learn how to customize the layout of the Excel window and how to print the contents of a worksheet. Other topics include learning how to use borders, shades, headers and footers and chart wizard.
In this workshop, you'll BUILD on your existing Excel skills - make sure you are comfortable with the basic skills listed in the Excel: Introduction workshop before signing up. Topics include: advanced math ("if" statements, counts, date/time, calculating interests, standard deviations), inserting graphics, links to other programs, multiple tables. Database functions such as multiple sort, forms, and subtotals will be utilized.
This workshop will introduce MORE Excel functions and operations such as Goal Seeker and VLookup. Class will include a review of charting, including custom chart types. Then learn how to build pivot tables and pivot charts from databases. Students will also work with templates, styles, and macros.
In this getting-started 3-hour course, you will learn how to use the new user interface of PowerPoint 07 to create slides in a variety of layouts. Learn tricks and tips for formatting, inserting photographs and clipart, and adding special effects (like 3-D, bevels, and mirrors). This basic-level course is geared toward introducing you to the broad, fundamental concepts that will allow you to continue learning PowerPoint at an accelerated pace.
This 3-hour course in PowerPoint 07 assumes some basic familiarity with the program. It emphasizes efficient use of layouts, grids and guides, color schemes and themes, and special graphic features such as “SmartArt,” charting and diagrams, and videos. This course will also cover how to add animation effects and transitions to create a visually appealing PowerPoint presentation.
For advanced users, this class in PowerPoint 07 will begin with the new concepts behind “master pages.” It will cover creating global designs and templates, which can then be edited and modified for seamless presentations. SmartArt and inserting photos and videos will also be reviewed. Finally, the course will conclude with how to create self-running, timed “kiosk” shows, then “package” the presentation for CD or flash memory.
Participants will learn how to define and develop the work breakdown structure, use MS Project to create and track project schedules, update the schedule with actual data, publish project status to persuasively communicate with senior management.
This hands-on workshop offers a general tour of Photoshop's features, and some specific techniques for making adjustments and finer detail retouching. Participants will learn how to manipulate and improve their images, whether from a digital camera, scanner, slides, or the Web.
This intermediate workshop is designed to familiarize students with some of the advanced functions of Photoshop CS3. Concepts to be covered include using the selection tools, working with Masks, and advanced Layer techniques. This is an intermediate workshop, and Photoshop Intro is required before attending this workshop. The instructor will not be covering any of the basics of Photoshop and will expect the students will have understanding and experience using Photoshop to create graphic files and adjust images
Preparing Multimedia for the Classroom
The use of multimedia can provide an engaging means to present information to students; however, it can be a challenge to find and prepare multiple media formats for classroom lecture. In this hands-on workshop, we will cover techniques for finding images, audio, and video on the Web, and how to incorporate multimedia effectively into PowerPoint.
Prerequisites: Basic knowledge of Internet searching, basic knowledge of PowerPoint.
Preparing Multimedia for Blackboard
This workshop will be an opportunity for hands-on experience of preparing multimedia for online presentation. File formats and compression for images, audio, and video will be discussed, and participants will learn techniques for incorporating multimedia effectively into Blackboard.
Prerequisites: Basic knowledge of Blackboard.
Participants will learn the basic layout and navigation system in Blackboard, how to customize the course menu, and how to add and organize content in their own courses. Participants will be working in their own Blackboard courses and should bring any course materials they wish to use to the workshop on a USB drive or disk. Please log into your course before the workshop; if you have trouble with this, e-mail Blackboard@luc.edu.
Using Your Blackboard Gradebook Effectively
This class will cover the basics of the Blackboard Gradebook. It is a hands-on workshop in which you will learn how to:
- Set-up your gradebook in Blackboard and how to avoid some common mistakes in Gradebook use.
- The difference between manually and automatically created items in the Blackboard Gradebook.
- Manipulate your Gradebook, e.g., sorting items by category, date created, etc.
- Weigh items in the Gradebook.
- View and download assignment, test, and survey results.
- Enter grades and change grades.
- Download and upload your Gradebook.
If you’re just beginning to learn how to analyze data or you feel you need a refresher on the basics of data analysis this class is for you.
During the class you will learn how to:
- Create a dataset in SPSS by creating and defining variables.
- Enter data in SPSS and import data from other formats into SPSS.
- Manipulate the structure of SPSS data files with some of the most commonly used procedures – Select Cases, Sort Cases, and Split File.
- Use univariate statistical procedures such as Descriptives and Frequencies and produce simple charts.
- Manipulate variables through data transformation commands such as Recode, Compute, and Count.
- Create Crosstabular tables and interpret their output.
- Use simple bivariate statistical procedures such as t-tests and correlations.
- Manipulate SPSS output for reporting purposes
NVivo7
NVivo7 is a software application designed to help you manage your qualitative research data. Field notes, interview transcripts and survey responses are just some examples of data that you can incorporate into your NVivo project to begin your data management and analysis.
This class is an introduction to NVivo7. It is designed for researchers who have collected some research data (need not be much) and are ready to begin the coding process. In this class you will learn how to create your NVivo project, how to bring data into the project, how to code data, how to produce coding reports, and how to conduct data searches and queries.
No experience with the software is required, but a basic understanding of qualitative research methods is assumed