Library Workshops - Fall 2008

MICROSOFT APPLICATIONS

MS Access 2003: Tables

Date/Time: Thursday, October 9, 2008, 2-4 pm

Description: 
Learn everything about the basics of tables: entering and editing data, sorting fields, filtering, and other basic functions. Learn about creating a new database and importing data from other programs.
Target Audience: 
Anyone wanting to use Access.
Expertise Level: 
Understanding of Windows basics.
Learning Objectives:
Create your own database.
Use a wizard to create table and learn to edit and manipulate the data.
Learn about creating a table in design view.

MS Access 2003: Queries

Date/Time: Thursday, October 16, 2008, 2-4 pm

Description: 
This second workshop on Access continues with creating Access queries. Learn and practice everything about all the query types, and then go on to using Design View for queries.
Target Audience: 
Anyone wanting to learn more about Access.
Expertise Level: 
Anyone knowing Access basics or who has attended Access Beginning I.
Learning Objectives:
Create a query.
Learn to manipulate and filter data permanently with a Query.
Learn to create and edit different query types in design view.
Learn how to create expressions for filtering criteria in a query.

MS Access 2003: Reports and Forms

Date/Time: Thursday, October 23, 2008, 2-4 pm

Description: 
The third Access workshop starts out with learning about the different types of reports and the easiest way to get the finished report you want. The workshop will continue with in depth hands on work in the design view for reports. The workshop finishes with translating our new knowledge of building reports into creating the Access forms.
Target Audience: 
Anyone wanting to learn more about Access reports and forms.
Expertise Level: 
Anyone knowing Access basics or who has attended Access Beginning I or II.
Learning Objectives:
Create an autoreport or use the wizard.
Learn to manipulate and edit a report using design view.
Create a data form from a wizard, autoform or design view.

---

MS Excel 2003: Spreadsheets

Date/Time: Tuesday, September 30, 2008, 9-11 am

Description:
A workshop covering the basic spreadsheet features of Excel 2003. Participants will build a simple spreadsheet.
Target Audience:
Anyone new to Excel
Expertise Level: 
Understanding of Windows basics
Learning Objectives:
Build a simple spreadsheet
Entering and editing data and navigating in a worksheet
Moving and copying data
Formatting a worksheet
Printing a worksheet

MS Excel 2003: Charts

Date/Time: Tuesday, October 7, 2008, 9-11 am

Description:
A hands-on workshop in Excel 2003 discussing charting spreadsheet data. Participants will create charts from pre-made spreadsheets
Target Audience:
Individuals with some Excel experience.
Expertise level:
Understanding of Excel basics
Learning Objectives:
Creating, modifying and formatting charts

MS Excel 2003: Formulas

Date/Time: Tuesday, October 14, 2008, 9-11 am

Description:
A workshop in Excel 2003 discussing formulas for special worksheet layouts, and advanced formulas.  Participants will both create spreadsheets and work with pre-made spreadsheets.
Target Audience:
Individuals with Excel experience.
Expertise Level:
Understanding of Excel basics
Learning Objectives:
Working formulas
Creating special spreadsheets
Using advanced formulas and functions
 

---

MS PowerPoint 2003: Intro

Date/Time:  Monday, September 29, 2008, 2-4 pm

Description: 
Microsoft PowerPoint 2003 is an increasingly popular software program used to create computer-based presentations. PowerPoint enables you to create electronic presentations that include text, graphics, pictures, sound, and video. This workshop will introduce participants to PowerPoint and how it can be used to deliver class lectures and conference presentations. Topics covered include the AutoContent Wizard, design templates, the PowerPoint interface. Learn how to insert, format, and move text, layouts, and graphics. Bring a flash drive to save your work.
Target Audience:
Anyone wanting to create a PowerPoint presentation.
Expertise Level: 
Beginning
Learning Objectives:
How to get started with a presentation.
How to add and edit text.
Add and edit graphics.
Change layouts and add more slides.
View all the pieces of your presentation.

MS PowerPoint 2003: Intermediate

Date/Time: Monday, October 6, 2008, 2-4 pm

Description:
This PowerPoint 2003 workshop will show participants how to create your own unique design template and save it.  Work with adding animation, transitions, draw tools, sound, and video to your presentation.  Learn how to save and publish your presentation to the web. 
Bring a flash drive to save your work.
Target Audience:
Anyone knowing PowerPoint basics.
Expertise Level: 
Intermediate
Learning Objectives:
Edit a design template.
Create your own template with pictures or the draw program.
Saving templates.
Adding animation and transitions to the presentation.
Getting sound and video into your presentation.
Posting your presentation to the Web.

MS PowerPoint 2003: Advanced

Date/Time: Monday, October 13, 2008, 2-4 pm

Description:
The advanced session of PowerPoint 2003 will cover grouping graphics, creating master slides, adding interactive components, printing options, considerations when using different versions, and packing a presentation.  Bring a flash drive to save the presentation you create during this session.
Target Audience:
Anyone knowing PowerPoint basics.
Expertise Level: 
Intermediate to Advanced
 

---

MS Word 2003: Basics

Date/Time: Wednesday, September 24, 2008, 9-11 am

Description: 
Word Basics 2003 explores finding and opening multiple documents, how to use templates, applying formats and styles, using the spell check and grammar check features, editing your document with cut and paste, and creating headers and footers.
Target Audience: 
Anyone new to Microsoft Word.
Expertise Level: 
Beginning
Learning Objectives:
To give you the confidence and experience in using the basic features of Word.

MS Word 2003: Customizing

Date/Time: Wednesday, October 1, 2008, 9-11 am

Description: 
Word Customizing 2003 discusses customizing templates, toolbars, and options, using auto correct, find and replace, footnotes, columns, and numbered or bulleted lists.
Target Audience: 
Anyone wanting to learn more features of Word 2003.
Expertise Level: 
Basic understanding of Word.
Learning Objectives:
Get hands-on practice using columns.
Setting up Word Options, customizing templates and toolbars.
Controlling number and bullet options.

MS Word 2003: Graphics

Date/Time: Wednesday, October 8, 2008, 9-11 am

Description: 
Graphics!  Borders!  Flyers!  Draw!  WordArt!  Have fun learning how to use all the coordinating graphical pieces of Microsoft Word 2003.
Target Audience: 
Anyone wanting to learn graphics in Word.
Expertise Level:
  Understanding of Word basics.
Learning Objectives:
Hands-on learning of graphics, borders, draw, and WordArt.

---

MS Access 2007: Tables

Date/Time: Friday, October 31, 2008, 9-11 am

Description: 
Microsoft Access 2007, a part of the Microsoft Office Suite, is a relational database program that allows users to manage large amounts of information. Explore the new interface for Access 2007. Learn the basics of creating tables: entering and editing data, sorting fields, filtering, and other functions. Learn about creating a new database and importing data from other programs.
Target Audience: 
Anyone wanting to use Access 2007.
Expertise Level: 
Basic understanding of Windows and Office programs.
Learning Objectives:
Use a wizard to create a table.
Learn the shortcuts to edit and manipulate data in tables.
Learn what table properties are, and how to use them in creating a table in design view.
Find information on how to define and set up a new database.

MS Access 2007: Queries

Date/Time:  Friday, November 7, 2008, 9-11 am

Description: 
This second workshop on Access 2007 continues with creating Access queries from wizards and from design view. Discuss the query types, and create one of each type. Learn how to edit basic queries to manipulate and filter data. Learn to use Design View for creating or manipulating your queries.
Target Audience: 
Anyone wanting to learn more about Access.
Expertise Level: 
Anyone knowing Access basics or who has attended the Access Tables workshop.
Learning Objectives:
Create a query.
Learn to manipulate and filter data permanently with a Query.
Learn to create and edit different query types in design view.
Learn how to create expressions for filtering criteria in a query.

MS Access 2007: Reports and Forms

Date/Time:  Friday, November 14, 2008, 9-11 am

Description: 
The third Access 2007 workshop starts out with learning about the different types of reports and the easiest way to get the finished report you want. The workshop will continue with in depth test of the new report tool compared to the old design view for reports. Finish the session with translating your new knowledge of building reports into creating Access forms.
Target Audience: 
Anyone wanting to learn more about Access reports and forms.
Expertise Level: 
Anyone knowing Access basics or who has knowledge of database programs.
Learning Objectives:
Create an autoreport or use the wizard to create a basic report.
Learn to manipulate and edit a report using design view.
Create a data form from a wizard, autoform or design view.

---

MS Excel 2007: Spreadsheets

Date/Time: Wednesday, November 5, 2008, 9-11 am

Description:
Microsoft Excel 2007 is a spreadsheet program that is a powerful tool that can be used for accounting or databases. In this session you learn to navigate the program and create a spreadsheet.
Target Audience:
Anyone new to Excel
Expertise Level: 
Understanding of Windows basics.
Learning Objectives:
Learn the menus.
Build a simple spreadsheet.
Entering and editing data and navigating in a worksheet.
Moving and copying data.
Formatting and customizing a worksheet.

MS Excel 2007: Charts

Date/Time: Wednesday, November 12, 2008, 9-11 am

Description:
A hands-on workshop in Excel 2007 that shows you how to chart spreadsheet data. Participants will create several types of charts from pre-made spreadsheets.
Target Audience:
Individuals with some Excel experience.
Expertise level:
Understanding of Excel basics.
Learning Objectives:
Creating, modifying and formatting charts.
Learn how choosing the right data affects your chart.
Learn how to put charts into other Office programs and being able to link and update the information from the spreadsheet.

MS Excel 2007: Formulas

Date/Time: Wednesday, November 19, 2008, 9-11 am

Description:
A workshop in Excel 2007 discussing built in functions, building formulas and advanced formulas.
Target Audience: 
Individuals with some Excel experience or attendance at previous workshops.
Expertise Level:
Understanding of Excel basics.
Learning Objectives:
Working with formulas and functions

---

MS PowerPoint 2007: The Basics

Date/Time:  Tuesday, October 28, 2008, 9-11 am

Description: 
Part of the New Microsoft Office 2007 suite, PowerPoint is used to create computer-based electronic presentations that include text, graphics, pictures, sound, and video. This workshop will introduce participants to PowerPoint 2007 and how it can be used to deliver class lectures and conference presentations. Topics covered in this session include the basic navigation of PowerPoint, design templates, the new ribbon toolbars, and general tips on the “do’s and don’ts” when creating presentations. Learn how to insert, format, and move text, layouts, and graphics. Attendees are encouraged to bring a flash drive if desired.
Target Audience:
Users new to PowerPoint 2007.
Expertise Level: 
Introductory
Learning Objectives:
Learn the all new 2007 interface.
How to get started with a presentation.
How to add and edit text.
Add and edit graphics.
Change layouts and add more slides.
View all the pieces of your presentation.

MS PowerPoint 2007: Design Tools

Date/Time: Tuesday, November 4, 2008, 9-11 am

Description:
This PowerPoint 2007 workshop will show participants how to create unique design templates and save for later use. Attendees will work with adding animation, transitions, draw tools, sound, and video to presentations. In-depth discussion will include tips on saving presentations in different formats for optimal results when delivering the project on different computers or situations such as a kiosk or for the Web. Bring a flash drive to save your work.
Bring a flash drive to save your work.
Target Audience:
Anyone knowing PowerPoint basics.
Expertise Level: 
Intermediate
Learning Objectives:
Edit a design template.
Design your own template with pictures or the draw program.
Saving templates.
Adding animation and transitions to the presentation.
Using sound and video in your presentation.
Saving your project for the Web, a kiosk, or as a presentation.

MS PowerPoint 2007: Advanced Techniques

Date/Time: Tuesday, November 11, 2008, 9-11 am

Description:
The advanced session for PowerPoint 2007 will cover grouping graphics, creating master slides, adding interactive components for audience interaction, printing options, considerations when using different versions, and packing a presentation for use on another computer. Attendees are encouraged to ask questions and will be given time in class to create their own presentation using the skills learned from all three workshops. Bring a flash drive to save the presentation you create during this session.
Target Audience:
Anyone desiring knowledge of advanced methods of content creation.
Expertise Level: 
Intermediate to Advanced
Learning Objectives:
Customizing the PowerPoint Interface.
Advanced Animation techniques.
Advanced Transitions.
Integrating audience feedback into your presentation.
Review of presentation techniques and goals.
Ample time for attendees to ask questions and experiment with features.

---

MS Word 2007: Interface

Date/Time: Tuesday, November 4, 2008 1-3 pm

Description: 
Interface explores the program concentrating on the new 2007 Word ribbon interface and office menu button. Learn what's new and what's still in 2007. Find out about document compatability and whether or not to convert your documents.
Target Audience:
Anyone new to Microsoft Word
Expertise Level: 
Beginning
Learning Objectives:
Learn the Windows interface features.
Explore the toolbars and menus in Word.
Create and save a new document.
Practice using dialog boxes.

MS Word 2007: Basics

Date/Time: Tuesday, November 11, 2008 1-3 pm

Description: 
Basics does an in depth exploration of the most needed functions on the Home, Insert, Page Layout, and View ribbons. Find and opening multiple documents, learn how to use templates, apply new formats and styles, edit your document with cut and paste, and creating headers and footers.
Target Audience: 
Anyone new to Microsoft Word.
Expertise Level: 
Beginning
Learning Objectives:
To give you the confidence and experience in using the basic features of Word.

MS Word 2007: Customizing

Date/Time: Tuesday, November 18, 2008 1-3 pm

Description: 
Customizing discusses customizing templates, toolbars, and options, using auto correct, find and replace, footnotes, columns, and numbered or bulleted lists.
Target Audience: 
Anyone wanting to learn more features of Word.
Expertise Level: 
Basic understanding of Word.
Learning Objectives:
Get hands-on practice using columns.
Setting up Word Options, customizing templates and toolbars.
Controlling number and bullet options.

---

MS Outlook 2007: Intro

Date/Time: Monday, November 3, 2008, 2-4 pm

Description: 
This introductory course will help attendees become comfortable and familiar with Outlook 2007. The new User Interface will be examined in depth as well as the basic functionality of Email, Calendar and Contacts. These features will be explained so that course participants will be able to take this knowledge back to their own computer and begin actively using the various components of Outlook 2007.
Target Audience: 
This class is for new users to Outlook 2007.
Expertise Level: 
Familiarity with basic email concepts.
Learning Objectives:
Examine the diverse features in Outlook 2007.
Explore the new User Interface.
Explore through various options that can be customized in Outlook 2007.
Effectively create and use signatures.
Basic use of the Calendar and Contacts functions of Outlook 2007.
Basic knowledge of security involving email.

MS Outlook 2007: Intermediate

Date/Time: Monday, November 10, 2008, 2-4 pm

Description: 
The exploration of Outlook 2007 continues with discussion and demonstration of the more intermediate and advanced features available in the program. Email, Calendar, Tasks and other functions will be demonstrated at a higher level to help attendees increase productivity and organization. Course participants will also be shown how to configure Outlook 2007 on their home computer to access various email services and how to utilize more than one email account. Basic functionality of options for Exchange Server users will be explained.
Target Audience: 
Email users who desire more extensive knowledge of Outlook 2007.
Expertise Level: 
Basic understanding of Outlook 2007.
Learning Objectives:
More advanced options for Email, Calendar, Tasks and Contacts. Configuring the Out of Office Assistant, and customizing the User Interface. More complex understanding of how email services work. Basic understanding of Exchange Server options. Intermediate knowledge of email security. How to configure and setup new email accounts.

---