|
|
|
|
Workshop List
Microsoft Office 2007
|
Workshop
Title |
Workshop
Description |
Workshop
Documents |
| Introduction to Office 2007 |
This workshop provides an overview of the new Interface in Microsoft Office 2007. The workshop covers some of the major changes that have been made in Office 2007. Some of topics that will be covered are:
* The Ribbon
* Office Button
* New file format in Office 2007
This workshop qualifies to you have Microsoft Office 2007 on your work PC.
Prerequisites:
* Knowledge of previous versions of Microsoft Office Product. |
Course Handout |
| Microsoft Access 2007 - I (Introduction) |
This workshop provides an Introduction to Microsoft Access 2007. Some of the topics that will be covered in this workshop are:
* Access Interface
* Database Concepts
* Relational Database
* Tables |
Syllabus & Pre-requisites
Course Handout 1
Course Handout 2
Course Handout 3 |
| Microsoft Access 2007 - II (Intermediate) |
This workshop covers queries in Microsoft Access 2007. Some of the topics that will be covered in this workshop are:
* Query
* Query Operators
* Query Types
|
Syllabus & Pre-requisites
Course Handout |
| Microsoft Access 2007 - III (Advanced) |
The workshop provides an overview of Forms and Reports in Access 2007. The following topics will be covered:
* Reports
* Forms
|
Syllabus & Pre-requisites
Course Handout 1
Course Handout 2 |
| Microsoft Excel 2007 - I (Introduction) |
This workshop provides an introduction to Excel 2007. Some of the topics that will be covered in this workshop are:
* Office Button
* Ribbon
* Worksheet basics
* Formatting Cells
* Cell References
* Page Layout
* Basics Formulas and Function such as Sum(), and Average()
|
Syllabus & Pre-requisities
Course Handout |
| Microsoft Excell 2007 - II (Intermediate) |
The workshop covers some intermediate topics in Excel. Some of the topics that will be covered in this workshop are:
* Charts
* Tables
* Pivot Tables
|
Syllabus & Pre-requisities
Course Handout |
| Microsoft Excel 2007 - III (Advanced) |
This workshop covers the following topics
* Name Manager
* Data Validation Rules
* What-if Analysis
* Grouping & Data Consolidation
|
Syllabus & Pre-requisities
Course Handout 1
Course Handout 2 |
| Microsoft Outlook Web Access 2007 |
This workshop provides an overview of Microsoft Outlook Web Access (OWA) 2007. It covers some of the new and existing features available in OWA 2007.
|
Course Handout |
| Micorsoft PowerPoint 2007 - I (Introduction) |
This workshop provides an overview of Microsoft PowerPoint 2007. The workshop covers some of the major changes that have been made in PowerPoint. This workshop is intended for users who have not used PowerPoint or who would like to brush up their basic PowerPoint skills. The following topics will be covered in the workshop:
* The Ribbon
* Office Button
* The Home Tab (Font Formatting, Adding Slides)
* Insert Tab (Adding Images, SmartArt, Header & Footers)
* Applying themes to the presentation.
* Adding slide transition
Prerequisites:
* Knowledge of any Microsoft Office 2007 or 2003 Product.
* Introduction of Office 2007 Workshop (or consent of instructor) |
Syllabus & Pre-requisites
Course Handout |
| Microsoft PowerPoint 2007 - II |
This workshop covers the following PowerPoint topics:
* Adding and editing Chart.
* Slide Animations.
* Adding multimedia elements (Audio/Video).
* Packaging the presentation
|
Syllabus & Pre-requisites
Course Handout 1
Course Handout 2 |
| Microsoft Publisher 2007 - I (Introduction) |
This workshop provides an introduction to Microsoft Publisher 2007. Some of the topics that will be covered in this workshop are:
* Creating a new publication.
* Adding various objects to the publications such as text boxes, images, etc.
* Formatting various options in the publication.
|
Syllabus & Pre-requisites
Course Handout |
| Microsoft Word 2007 - I (Introduction) |
This workshop provides an introduction to Word 2007. Some of the topics that will be covered in this workshop are:
* Ribbon
* Document Basics
* Basic styles
* Font Formatting
* Page Setup
* Paragraph Formatting
* Document Views
|
Syllabus & Pre-requisites
Course Handout |
| Microsoft Word 2007 - II |
This workshop covers the following topics:
* Updating page margins.
* Using built-in heading styles.
* Updating heading styles.
* Using heading styles to create an automatic table of content.
|
Syllabus & Pre-requisites
Course Handout 1
Course Handout 2
Course Handout 3 |
| Microsoft Word 2007: Mail Merge |
This workshop provides an overview of Mail Merge in Word 2007 to create labels, emails and letters. The workshop will cover examples of mail merge to
* Create Labels
* Letters
Prerequisites:
* Knowledge of previous version of Microsoft Word
* Introduction to Microsoft Word 2007 (or consent of instructor) |
Course Handout
Practice 1
RecipientList |
Acrobat
|
Workshop
Title |
Workshop
Description |
Workshop
Documents |
| Acrobat Introduction |
This workshop is intended for those faculty and staff members who use Acrobat to create PDF documents for web posting and other uses. Covers basic navigation and editing, the use of links and bookmarks, and more.
Prerequisite: Windows Introduction or previous experience. |
Syllabus Course Handout |
Basic Computer Operation
|
Workshop
Title |
Workshop
Description |
Workshop
Documents |
| Computer Introduction |
Not just for beginners, this workshop covers the basics of using a computer. This workshop is best suited for faculty and staff who are challeneged getting past "turning the computer on."
The information is presented in an easy-to-understand style. Topics included mouse and keyboard operations, along with some basic computer skills. Lots of hands-on and loads of fun! Prerequisite: No experience required. |
Syllabus
Course Handout Computing Basics Questionaire |
| Computer Problem-Solving |
Give the Help Desk a break! This workshop is designed to provide users with simple problem-solving tips pertaining to very basic comuter issues that might come up during a task.
This may include printer issues, navigating NEIU network, desktop management (shortcuts, folders, etc.), and more. Prerequisite: Computer Introduction or equivalent. |
|
| File Storage & Backup |
Learn about the various options for storing and backing up your precious files. Includes CD burning, network drive usage, and the newer mini portable drives (flash drives, thumb drives, etc.).
Prerequisite: Windows Intro or previous experience. |
Objectives |
| Keyboarding |
Feeling challenged with using the keyboard? This workshop covers basic keyboard functions, and is NOT a typing workshop. Keys covered include backspace, delete, enter, escape, space bar, tab, and more. No typing experience required. |
Syllabus
Course Handout 1
Course Handout 2
Miscellaneous Keyboarding Tricks Word Keyboard Shortcuts |
| Protecting Your Computer |
Having problems with spam, viruses, spyware or pop-ups? Come learn more about these pests and the steps you can take to protect your computer from them. Includes an introduction to Windows Update. |
Syllabus Course Handout |
| Troubleshooting Basics |
This workshop is intended for faculty and staff at an intermediate level. We will discuss good computing habits and learn about ways to respond to computing problems. Participants will come away with ideas for preventing common problems and strategies for dealing with error messages and other surprises. |
Objectives |
Microsoft Office 2003
|
Workshop
Title |
Workshop
Description |
Workshop
Documents |
| Access 2003 Introduction |
Access can be a powerful database tool, but intimidating to users without fundamental training.
This workshop is designed for users who have never used Access, or have used it lightly. The workshop is delivered to new users in simple, easy-to-understand language, including database terms and concepts, navigation, and more. If you are currently entering data into an existing database, or plan to, this workshop is a great place to start. Prerequisite: Excel Introduction |
Course Handout
Data Entry Project
Tables & Relationships Project Preparation for Access Intermediate |
| Access 2003 Intermediate |
If you're comfortable with navigating your way around Access, and are ready for the next step, this workshop is intended for you. Although this workshop is broad, topics include building basic tables, modifying field properties, selecting data type, creating dropdown lists (look-up fields) for easier data entry, and creating forms, reports and simple queries using wizards. |
Syllabus
Course Handout Field Properties Project |
| Access 2003 for Queries |
Queries are an effective tool used to collect data for analysis, reports, or forms. This workshop is designed for users who are comfortable with Access and are navigating within the program (Tables, Forms, Reports, queries). Focus is on creating queries, using multiple sources and criteria. Prerequisite: Access Intro and Access Intermediate, or equivalent |
Syllabus Course Handout |
| Excel 2003 Introduction |
Excel is a great tool for faculty and a must for staff. This workshop introduces some of the basic functions of Excel, including creating and modifying worksheets, simple formatting, including numbers and text, creating simple formulas and calculations
Prerequisite: Excel Introduction or previous experience. |
Syllabus Course Handout |
| Excel 2003 Intermediate |
This workshop includes working with multiple worksheets, using formulas and formatting features, and protecting workbooks for sharing purposes. Prerequisite: Excel Introduction or previous experience. |
Syllabus Course Handout |
| Excel 2003 for Charts & Reports |
Learn to create charts, step-by-step, format and prepare worksheets for printing,distribution, and presentation. Prerequisite: Excel Intro or previous experience, Excel Intermediate recommended |
Syllabus Course Handout |
| Excel 2003 for Grade Sheets |
This workshop is designed as a starting point for faculty members who are interested in tracking grades using an Excel worksheet. With guidance, participants will create a simple grade sheet that they can use as a template to use with future courses. If your course assignments and final grades are point-based, Excel is a great alternative to track, calculate, and expedite final grades. Prerequisite: Excel Intro or equivalent. |
|
| Outlook 2003 Introduction |
Outlook integrates e-mail with a calendar, task list, & contact list. Learn the e-mail basics – including folders and message management – plus maintaining and managing calendars, contacts, and more. Intended for all new Outlook users. |
Syllabus
Objectives
Course Handout 1 Course Handout 2 |
| Outlook 2003 Intermediate |
Interested in learning more Outlook features? Topics include message signature, archiving and mailbox cleanup choices, rules, and more. Intended for those who have been using Outlook for a while.
Prerequisite: Outlook Intro or previous experience. |
Syllabus Course Handout |
| PowerPoint 2003 Introduction |
Learn the basics of creating effective presentations. Includes the use of drawing tools and design templates; inserting ClipArt, photos, and graphs; and printing notes and handouts. |
Syllabus Course Handout |
| PowerPoint 2003 Intermediate |
Learn advanced techniques for creating presentations using the slide master view, action buttons & hidden slides, media files, and more.
Prerequisite: PowerPoint Introduction or previous experience. |
Syllabus Course Handout |
| Publisher Introduction |
Use this user-friendly program to design brochures, newsletters, certificates, and more. Familiarity with Word or another word processing program is recommended. |
Syllabus Course Handout |
| Publisher for Multi-Page Documents |
Learn to work with multiple page documents such as brochures and newsletters. Insert and format long text sections; manage styles and background objects.
Prerequisite: Publisher Introduction or previous experience. |
Syllabus Course Handout |
| Word 2003 Introduction |
Learn to create and work with basic word processing documents; cut, copy, and paste text; use text and page formatting tools; work with outlines; and manage application tools. |
Syllabus
Course Handout Word Keyboard Shortcuts |
| Word 2003 Intermediate |
Create tables, add headers and footers, use templates, merge documents, and more. |
Syllabus Course Handout |
Internet
|
Workshop
Title |
Workshop
Description |
Workshop
Documents |
| FrontPage Introduction |
Learn to design and publish basic web pages. Participants should bring their individual or departmental gamut login and password. |
Syllabus
Course Handout NEIU FTP |
| HTML Basics |
Whatever program you use to design or update web pages, it’s helpful to understand a little Hypertext Markup Language (HTML). Come learn the basics, including paragraph and font formatting, making links, and inserting images. |
Syllabus Course Handout |
| Internet Explorer |
Learn basic web usage and terminology with Internet Explorer. Navigate the Internet, use a search engine, save web addresses and print web pages. Includes an introduction to Acrobat Reader. |
Syllabus Course Handout |
| Outlook Web Access |
This workshop is intended for those employees – faculty and staff – who have been set up on the Exchange version of Outlook 2003. Participants will learn the additional features of Outlook with the Exchange setup, especially accessing Outlook on the web. We will also cover the various methods of calendar sharing, as well as the tools and processes for setting up and using these methods. |
Objectives
Course Handout 1 Course Handout 2 |
Windows XP
| Windows Introduction |
File management & multitasking are essential Windows skills. Learn to organize and back up your files, and move easily from one task to another. Will cover the Taskbar and Start Menu, Windows Explorer, and more. |
Syllabus Course Handout |
| Windows Intermediate |
Get familiar with the tools and processes for managing and maintaining the Windows operating system. Clean up unneeded files, scan for and repair problems, and organize the hard drive.
Prerequisite: Windows Intro or previous experience. |
Syllabus Course Handout |
Miscellaneous
| Listservs |
Create, configure, and manage a ListProc listserv. |
Syllabus Course Handout |
| Online Tutorials Introduction |
For those who want to get started on the online tutorial program in a guided setting. Get registered, learn the site, and get tips to make the most of this program. |
Syllabus Course Handout |
| Photo Editing |
Learn about different types of digital images and how to work with them using simple programs included with the Microsoft Office suite. Prepare images for the web or for use in other documents. |
Syllabus Course Handout |
|
|
|
