Workshop Descriptions
Microsoft Access 2007: Introduction
Microsoft Access is the relational database system widely used by professionals. In this workshop, you will learn how to create 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 may 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 basic formulas (PEMDAS), use simple functions (Sum, Average, Count, Today), edit and format cells, and format and link workbook sheets. 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 other fundamental formats.
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: more math functions ("if" statements, sumif, count/countif/counta, standard deviations, calculating interests, standard deviations), creating and formatting charts, links tables and charts to other programs (such as Word), and conditional formatting (writing and clearing rules).
This workshop will introduce MORE Excel functions such as VLookup. Class will include a review of charting and graphics. Then students will learn how to build pivot tables and pivot charts from databases, as well as use the consolidate and subtotal features to get grouped summary information. Students will also work with Goal Seek, scenarios, and other “what-if analyses” such as validate.
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.
PowerPoint 2007: IntermediateThis 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.
PowerPoint 2007: AdvancedFor advanced users, this class in PowerPoint 07 will begin with the concepts behind having multiple “master pages” (including creating your own layout masters) It will include 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 (including how to insert YouTube videos into your presentation). Finally, the course will conclude with how to create self-running, timed “kiosk” shows, then “package” the presentation for email, CD, or flash memory sticks.
Project: IntroductionParticipants 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.
The introductory course starts with an overview of basic Photoshop concepts such as modes (gray, CMYK, RGB), pixel vs. dot resolution when printing and using for web design, and then it works with basic photo editing (brighten, contrast, lighten, darken, sharpen, crop, straighten). Students will use basic tools in the complex Photoshop toolbox, such as paint, dodge/burn, smudge/sharpen/blur, zoom/pan, and type. The course will teach you how to coordinate your tools from the toolbox with the toolbar and the multiple palettes provided in Photoshop (including navigation/view, color/swatches, and history). Emphasis will be on learning how to “select” and “control” areas of your picture for detailed editing (such as redeye correction).
Adobe Photoshop CS3: Level 2Photoshop Level 2 will continue working with the more specialized tools in the toolbox, such as magic eraser, magic wand, and magic lasso. This course will emphasize how to use “layers” to edit photos and combine images into photo montages. Students will learn concepts such as adjustment layers for color and contrast, text layers (and text effects), and copy layers, with layer “styles.” Then, they will learn how to use “quick masks” to edit layers, text masks for creating content-filled text, and ruby-lith masks for selecting and editing. Finally, students will work with a variety of filters to create borders, special effects, and dynamic pictures.
The Blackboard Quickstart is designed for those who are new to 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.