Software Training Sessions

General Topics (Descriptions)

Creating Brochures and Forms Creating Spreadsheets
Working with Databases Administering Synapse
Email and Personal Scheduling Web Page Development
Finetuning and Protecting your Computer Windows XP
Creating Presentations for Classes or Meetings Word Processing

Using Public Folders for Centralized Communication

[Evaluate a Session]

[Schedule of Sessions (By date)]

[Schedule of Sessions (Alphabetical)]

 

 

 

Descriptions of Session Topics

Creating Brochures and Forms

          Creating Brochures Using Microsoft Publisher

Microsoft Publisher is a free program that comes with Microsoft Office.  It allows you to create brochures easily using predesigned templates and user-friendly toolbars.  In this session, we will discuss how to determine page layout, how to use the drawing toolbar, to apply borders and edges, how to work with WordArt, and how to insert pictures and graphics in a brochure. [Requires introductory knowledge of Word or Wordperfect.]

          Creating Printed and Web Forms Using Microsoft Publisher

Microsoft Publisher is a free program that comes with Microsoft Office. It allows you to create forms that can be printed out and filled in or that can be filled in on a web page. In this session, we will discuss how to determine page layout, how to insert form fields (check boxes, text boxes, drop-down lists, for example),  how to modify form field options, and how to protect your form from being changed by others. [Requires introductory knowledge of Word or Wordperfect.]

Working With Access Databases

Microsoft Access (Introduction)

Microsoft Access is a full-featured database program that allows you to store, manipulate, and report data.  In this session, we will learn how to create a simple database using both the Design View and the Table Wizard.  We will learn to enter data into a database using tables. Then, we will create reports based on those tables. You will develop a database that may be used in your work situation.  [Knowledge of Microsoft Windows (95 or later version) or Mac OS required.]

Microsoft Access (Intermediate)

 

Building on the previous session, we will learn how to create forms for entering and viewing data.  We will also generate queries (structured statements) to sort and report data. [Requires introductory knowledge of Microsoft Access.]

 

Microsoft Access (Advanced)

 

Building on the previous session, we will consider the issue of good database design.  We will also learn about determining what tables and fields to create and how to build "relationships" between tables. [Requires intermediate knowledge of Microsoft Access.]

Email and Personal Scheduling

Microsoft Outlook (Introduction)

Although Outlook is a full-scale productivity software, this session will concentrate on the email component: retrieving and opening messages, using Quickview, viewing attachments, deleting messages and emptying trash. Also, we will learn how to create and send messages, use the Address Books, and create a signature that you can insert at the end of a message. Finally, we will learn how to access Outlook through the Houghton College web site. [Knowledge of Microsoft Windows (95 or later version) or Mac OS required.]

Microsoft Outlook (Intermediate)

We will look at some of the more advanced features of Outlook that make your life more efficient. We will create subfolders and generate rules so that mail, tasks, appointments, and notes will be delivered to a particular subfolder.  We will use the calendar to schedule appointments. We will learn how to schedule tasks for yourself and assign tasks to others.  We will learn how to set up proxy access so that others may look at your email or calendar. We will discuss helpful 'options'. In this day of 'Spam', we will find out how to deal with Junk email that arrives in your Outlook mailbox. If time permits, we will consider how to download email messages and appointments to your hard drive so you can read and reply to them offline.  [Requires introductory knowledge of Microsoft Outlook.]

Finetuning and Protecting Your Computer

There are a number of operations that you can perform to make certain that your PC runs smoothly and efficiently.  We will learn how to "defragment" your hard drive so it doesn't overwork to find files and folders. We will learn how to scan your hard drive for viruses and to update your antivirus software. To save space on your hard drive, we will learn how to clean unnecessary files off of it, including clearing the cache on your web browser. We will also take a peek inside the computer box to see what the mystery is all about. [Requires knowledge of Microsoft Windows (95 or later version) or Mac OS.]

Creating Presentations for Classes or Meetings

PowerPoint (Introduction)

Powerpoint is the premiere presentation software.  We will select a slide layout and a template design., input text into a slide, edit and change the format of that text, then insert a new slide. We will move and change the size of text boxes. Then, we will save your slide show for viewing.  We will show you how to print hard copies of a slide for distribution to others. [Requires knowledge of Microsoft Windows (95 or later version) or Mac OS]

PowerPoint (Intermediate I)

Building on the previous session, we will learn to select the "view" that you wish to work with. We will make the presentation more interesting to viewers by including animation effects in a slide and by inserting clip art.  We will organize information better by inserting tables, spreadsheets, or graphs into a slide.   If time permits, we will try creating our own graphics for insertion into a presentation. [Requires introductory knowledge of Powerpoint]

PowerPoint (Intermediate II)

The addition of audio and video clips in a presentation creates an exciting multimedia experience for viewers.  We will learn best practices for inserting clips into a slide.  We will also learn how to using timing sequences to run your presentation, including making your presentation run continuously. [Requires introductory knowledge of Powerpoint]

Using Microsoft Outlook Public Folders for Centralized Communication

The use of Microsoft Outlook public folders is one method for distributing documents and creating public discourse.  We will discuss the rationale behind public folders.  We will construct a public folder and give permission to others to become a part of the folder. We will post messages or files to the public folder and reply to one of those messages.  Finally, we will use the "Favorites" link to make finding a public folder easier. [Requires introductory knowledge of Microsoft Outlook.]

Creating Spreadsheets

Excel (Introduction)

Spreadsheets provide a good way to organize and manipulate data, especially numerical data.  We will learn how to input text and numbers into cells, format the contents of cells, and move and copy the contents of cells. We will use the Autosum function to perform quick and easy additions of numbers in columns or rows. But, we will also create formulas to perform more sophisticated calculations. We will also learn how to print out a spreadsheet.  [Requires knowledge of Microsoft Windows (95 or later version) or Mac OS]

Excel (Intermediate)

This session will delve into the complexity of linking multiple worksheets within one spreadsheet. We will also create a chart for visual representation of selected data.  And we will learn how to use the Drawing Toolbar to add interesting elements to the spreadsheet. [Requires Introductory knowledge of Excel.]

Synapse, the course management system.

Synapse is the college's course administration software.  It provides a centralized platform for many of the technological functions normally carried on in a course.  This introduction for faculty covers: how to upload content for distribution to class members, how to create assignments and news items, input grades, and create groups, how to start a discussion forum, and  how to develop online tests.  A number of new features have been added in this version (Version 3). [Requires knowledge of Microsoft Windows (95 or later version) or Mac OS]

Web Page Development

Dreamweaver (Introduction)

Macromedia Dreamweaver is an alternative web page editor to Microsoft Frontpage.**  In this session, we will briefly discuss the language (HTML) that is the basis for most web page editing.  We will then begin creating a rudimentary web page with headings, text, and ordered/unordered lists. We will learn how to format the text.  We will learn how to create internal links on your pages so that a user can move easily around a page or to one of your other pages.  We will also discuss techniques for acquiring external web page addresses (URLs) that can be used to link your web site to external sites. If time permits, we will learn how to test a link.  [Requires knowledge of Microsoft Windows (95 or later version) or Mac OS and introductory knowledge of Netscape or Internet Explorer.]

Dreamweaver (Intermediate)

To make your pages available to others over the World Wide Web, you need to "publish" those pages.  In this session, we will learn how to integrate your web pages so that they may be published en masse.  We will also make your pages more interesting by incorporating graphics into them.  Finally, to organize the information on your pages and to make the process of web page development easier, we will learn how to create tables and use templates.    [Requires introductory knowledge of web page development]

Microsoft Front Page (Introduction)

In this session, we will briefly discuss the language (HTML) that is the basis for most web page editing.  We will then begin creating a rudimentary web page with headings, text, and ordered/unordered lists. We will learn how to format the text.  We will learn how to create internal links on your pages so that a user can move easily around a page or to one of your other pages.  We will also discuss techniques for acquiring external web page addresses (URLs) that can be used to link your web site to external sites. If time permits, we will learn how to test a link.  [Requires knowledge of Microsoft Windows (95 or later version) or Mac OS and introductory knowledge of Netscape or Internet Explorer.]

Microsoft Frontpage (Intermediate)

To make your pages available to others over the World Wide Web, you need to "publish" those pages.  In this session, we will construct a "personal web" to integrate your web pages so that they may be published en masse.  We will also make your pages more interesting by incorporating graphics into them.  Finally, to organize the information on your pages and to make the process of web page development easier, we will learn how to create tables and use templates.    [Requires introductory knowledge of web page development]

Microsoft Frontpage (Advanced)

This session will concentrate on the creation of 'frames', which is another way to organize your pages.  This enables you to create menus that are visible even when the contents of the pages changes. (Example: http://campus.houghton.edu/webs/employees/gavery/glenspg.htm) We will also show how to use predesigned hover buttons and how to create "hotspot" links.  We will discuss some issues about good web page design.  [Requires intermediate knowledge of web page development]

WindowsXP

This session reveals the differences between XP and previous version of Windows, including the XP User Account. We will work with "windows" and show how to modify your Start Menu and TaskBar. We will use Windows Explorer to search for and organize files and folders.  We will also use the Control Panel to change Windows settings and to administer your computer. Come find out what is new about XP.  [No prerequisite]

Word Processing

Word (Introduction)

We will learn how to create a new document and edit, save, and print that document.   We will discuss page layout and how to preview your document, as well as how to modify it by ‘undo’ing mistakes, finding and replacing text, changing the formatting of text, and checking spelling. Finally, we will learn to insert pictures and objects into a document.  [Knowledge of Microsoft Windows (95 or later version) or Mac OS required]

Word (Intermediate)

Building on the previous session, we will learn how to make our documents more powerful.  We will create tables and use columns to organize information. We will insert footnotes or endnotes into a document, add page numbers, and make borders. To make editing processes more efficient, we will create macros (keyboard shortcuts). If time permits, we will learn how to merge several documents (chapters?) into a master document and learn to create labels.  [Requires knowledge of introductory Word concepts]

 

**Houghton College provides Microsoft Frontpage (under a campus-wide licensing agreement) to every student, faculty and staff member as part of Microsoft Office.  The College, however, does not have a campus-wide licensing agreement for Dreamweaver and only has a limited number of copies of the software available for use by faculty and staff.  If you wish to have Dreamweaver installed on your office PC or laptop, please contact the HelpDesk at x6180 to see if copies are available.

 

 

Updated May 10, 2004

Comments to Glen Avery