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 workshop, you will learn the basics of Microsoft PowerPoint and learn how to create a presentation. You will learn how to add and format text and graphics (including how to edit clipart), use built-in designs, work with slides and their various views (such as Outline view and Notes view), and learn various ways to print the presentation (such as Handouts). Class concludes with the construction of a simple slide show.
Class starts with a brief review of formatting (including Format Painter). Participants will learn how to work with backgrounds and color schemes, animations and transitions, timing, and other special effects. Much of the session will be spent on charting, including graphs (pie chart, bar chart, multiple charts), organization charts, and flow charts. You should know the basics of PowerPoint: how to create a slide show.
In this workshop, you will learn how to insert multimedia and HTML links into your presentations, and how to design "custom" slide shows (combining multiple PowerPoint files). Participants will work with the slide master and handouts master, and also how to create and customize templates. Specialized presentation features such as "Package," "Action Buttons," and "Photo Album" will be covered as well.
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 adjustmenst and finer detail retouching. Participants will learn how to manipulate and improve their images, whether from a digital camera, scanner, slides, or the Web.
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.