The Bush School Library Instructional Technology Department's

FACULTY AND STAFF COURSE OFFERINGS

Simply email Barbara Frandeen to enroll. We also create custom classes for specific departmental or divisional needs.

Word Fundamentals -- Barbara Frandeen

  1. Create and save documents for easy retrieva
  2. Insert and delete text to edit a document
  3. Move, copy, and replace text
  4. Modify text for emphasis (bold, italics, etc.)
  5. Set and remove tab stops to enhance document appearance
  6. Create, modify, and format tables to organize text
  7. Use margins, indents, bullets, and numbering to change text layout
  8. Use proofreading tools (Spell check, AutoText, AutoCorrect, Thesaurus) to enhance productivity

Word Intermediate -- Barbara Frandeen

  1. Use mail merge to create form letters, mailing lists, labels, etc.
  2. Sort various data formats alphabetically or numerically
  3. Use templates and styles to create documents
  4. Format text in multiple columns
  5. Create and insert graphics
  6. Use Headers and Footers to display text and page numbers

Excel Fundamentals -- Barbara Frandeen

  1. Navigate through an Excel spreadsheet
  2. Organize columns and rows; edit content of cells
  3. Calculate values by entering formulas into cells; creating absolute cell references
  4. Use functions to create complex formulas
  5. Sort information; use filters to display specific information
  6. Format cells and worksheet elements
  7. Create charts
  8. Change the page setup and preview the workbook

Excel Intermediate -- Barbara Frandeen

  1. Create range names to simplify writing formulas
  2. Work with functions to create complex formulas
  3. Annotate and format worksheets
  4. Use and create templates to make quick, customized forms
  5. Create charts to analyze data
  6. Modify charts to improve presentation
  7. Review your work to check for errors

Excel Advanced - Barbara Frandeen

  1. Create and edit macros to automate repetitive or complex tasks
  2. Link multiple workbooks to update information and recalculate related tables
  3. Sort and filter more complex data
  4. Use data tables to extrapolate current trends and project future trends
  5. Use PivotTables to reorganize summary data
  6. Consolidate data from several worksheets onto one worksheet for a customized view of information

PowerPoint Fundamentals -- Barbara Frandeen

  1. Identify PowerPoint screen elements and terms
  2. Use outlines to organize the text of your presentation
  3. Use the PowerPoint design templates and formatting tools
  4. Modify your presentation
  5. Add objects and insert pictures
  6. Create charts to illustrate numeric information
  7. Display a consistent look throughout presentations by using color schemes and the Slide Master
  8. Produce an on-screen slide show

PowerPoint Intermediate/Advanced -- Barbara Frandeen

  1. Import data from another program to create a presentation quickly
  2. Share information between programs to save time
  3. Move and copy slides and objects to display data effectively
  4. Use charts and tables to present data graphically
  5. Use graphics to enhance a presentation
  6. Use animation to increase the impact of text and graphics
  7. Rehearse a slide show and prepare it for presentation

Front Page Fundamentals -- Barbara Frandeen

  1. Explore the FrontPage 2000 environment
  2. Create Web-based HTML documents to develop a Web site
  3. Format a page
  4. Create hyperlinks to link to other files on the Internet or on a network
  5. Place pictures in a page
  6. Use tables to arrange text and objects on a page
  7. Add multimedia to your pages by inserting movies, sounds and animations

Outlook Fundamentals -- Barbara Frandeen

  1. Set up your Inbox
  2. Communicate with e-mail
  3. Manage contact information
  4. Address, distribute, file, sort, and find messages
  5. Record, prioritize, and track tasks
  6. Schedule and manage appointments
  7. Coordinate and schedule meetings with others
  8. Print Outlook items

Outlook Intermediate/Advanced -- Barbara Frandeen

  1. Organize incoming e-mail messages (color-coding, auto-filing, managing junk mail)
  2. Control Messages (delaying, recalling, and automatically replying)
  3. Use Stationery for Messages
  4. Set up your own email groups
  5. Use Contact Records
  6. Schedule events and assign tasks
  7. Use the Journal feature
  8. Share Outlook folders with others

Access Fundamentals -- Barbara Frandeen

  1. Identify basic database concepts and Access terminology
  2. Move through tables in Datasheet view and Form view
  3. Edit, add, and delete records in Datasheet view and Form view
  4. Create databases, add and modify table structures, and enhance table views
  5. Create a query to display specific records
  6. Query multiple tables to analyze additional information

Access Intermediate -- Barbara Frandeen

  1. Share and manage data (importing, linking, assigning a primary key, etc.)
  2. Define data entry rules to ensure accurate data input
  3. Use advanced queries to answer a specific question about data in one or more tables
  4. Create summary queries to perform calculations and make comparisons
  5. Create and modify a customized form with the Form Wizard
  6. Build a customized report with the Report Wizard

Visio -- Barbara Frandeen

  1. Introduction to tools and terminology
  2. How to choose a drawing template and set up your drawing page
  3. Creating and manipulating basic shapes, using shape operations, etc.
  4. Creating a floor plan
  5. Creating an organization chart
  6. Creating a flow chart, or a map, etc.

Dreamweaver -- Barbara Frandeen

  1. Creating a web site in Dreamweaver
  2. Creaing an HTML page in Dreamweaver
  3. Formatting headings, text styles, paragraphs
  4. Adding horizontal rules and backgrounds
  5. Creating hyperlinks
  6. Adding and modifying images on a web site
  7. Creating hyperlinked images and image maps
  8. Creating and modifying tables on a web page

Digital Camera Basics -- Rebecca Wynkoop

  1. Setting camera default setting
  2. Taking pictures & making mini movies
  3. Downloading images and mini movies
  4. Crop, re-size and color
  5. Saving images & mini movies
  6. Using/printing your images
  7. Camera maintenance

Effective Information Seeking Strategies -- Lisa Keller

Much of our students’research, as well as our own, is conducted electronically. Even print materials are found by using electronic catalogs. We happily and successfully ‘Google’complicated reference questions. But we tend to merely poke around the surface of this powerful medium. In this workshop, we will look at the spectrum of electronic information tools, from the free Web to subscription periodical databases, and learn how each is most effectively used