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.
Here is detail of what is covered:
Getting Around
· By Keyboard:
· By Mouse:
· Entering Data
· Entering Text
· Editing Within a Cell (F2)
Ranges
· Selecting
· Iterating (fill)
· Moving
· Non-contiguous Ranges
Formulas
PEMDAS
Nesting
Exponents
Function
· Sum Function/More Functions
· Fx
· Formulas on Ribbon
Using Multiple Worksheets
· Concepts of worksheets
· Cut and paste across sheets (paste special)
Basic Formatting
· Number, Currency, Accounting
· Font
· Border
· Patterns
· Widening columns and rows
· Centering across columns
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).
Here is detail of what is covered:
Review: Formulas & Functions
· Sum, SumIf
· Average
· Count, CountA, CountIf
· Standard Deviation (P and A)
· If
· Calculating Percentages
· Absolute Cell References
More Functions
· Date (today, now)
· Financial (ipmt, ppmt, db)
· Printing functions and equations
Charting
· Selecting data
· Moving to worksheet
· Formatting
· Taking to Word
Print Preview and Page Layout View
· Headers, footers, etc.
· Scaling
· Print row/column, grids
· Repeat rows and columns
· Print formulas
More Formatting
· Extended Cell Formats (Borders, Fills, etc.)
· Freeze Panes
· Merging Cells
· Conditional Formatting
Links across Spreadsheets
· Formulas vs. Paste Special
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.
Here is detail of what is covered:
Charting & Graphics (Review)
· Switching Chart Types
· Axis Options
· Trendlines
· Themes
· Inserting Objects (SmartArt)
Text Functions
· Text to columns
· Concatenate
· Proper
· Upper and Lower
· Left and Right
· Len
Database Features
· Sort
· Filter
· Consolidate
· Subtotal
· Validation
· Pivot Tables and Pivot Charts
· Vlookups and Hlookups
“What If” Analysis
· Scenarios
· Goal seek
Other Excel Options
· Protecting a Sheet (Review)
· Password Protecting a Workbook
· Templates
In this 3-hour course, you will learn how to create effective 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). Special graphic features such as “SmartArt” will be introduced. Course will also cover how to add animation effects and transitions to create a visually appealing PowerPoint presentation.
PowerPoint 2007: Level IIThis 3-hour course in PowerPoint 07 assumes basic familiarity with the program. It will emphasize efficient use of layouts, grids and guides, color schemes and themes, and graphic features such as charts and videos. For advanced users, this class in PowerPoint 07 will include the key concepts behind “master pages,” including 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 disk or for zipping and emailing.
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.
Using Microsoft Word 2007 Effectively: Tips and Shortcuts
This 3-hour intermediate-to-advanced class in Word 07 focuses on those aspects of Word that are often overlooked or not used well. The course begins with text shortcuts such as Autocorrect, adding characters to your keyboard, and Quick Parts. Then, there will be an overview of formatting concepts in Word, such as paragraph spacing, bullets and numbering, tab sets (left, right, center, decimal, bar, and leader tabs) and indents, and section breaks (used with columns, headers/footers, page numbers, paper orientation). Tables, graphics, and text boxes will also be covered. Then students will learn how to use “Styles” for formatting, and how important styles are for features such as Tables of Contents and Tables of Authorities. Finally, the class will work with “Themes” and Styles to design templates for re-use.
Microsoft Powerpoint 2007 Bells and Whistles
This course in PowerPoint 07 assumes basic familiarity with the program. It will emphasize efficient use of layouts, grids and guides, color schemes and themes, and graphic features such as charts and videos. This class will include key concepts behind “master pages,” including global design decisions such as colors and fonts for seamless presentations. SmartArt, photos, and videos will also be reviewed. Finally, the course will conclude with how to create self-running presentations with animation, then “package” the presentation for CD or flash disk or for zipping and emailing.
The course introduces basic concepts of Adobe Photoshop, such as modes (Gray, CMYK, RGB), and pixel vs. dot resolution when printing and for web design; and then 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 text. This 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, swatches, and history). Emphasis will be on learning how to “select” and “control” areas of your picture for detailed editing (such as redeye correction).