| |
![]() |
|
![]() |
|
||||||||||||||
Software Training Sessions
[Schedule of Sessions (By date)] [Schedule of Sessions (Alphabetical)]
Descriptions of Session TopicsCreating Brochures and FormsCreating Brochures Using Microsoft Publisher
Creating Printed and Web Forms Using Microsoft Publisher
Working With Access Databases
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.]
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 SchedulingMicrosoft 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
Creating Presentations for Classes or MeetingsPowerpoint 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] 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] 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
Creating SpreadsheetsSpreadsheets 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] 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.
Web Page DevelopmentMacromedia 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.] 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
Word ProcessingWe 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] 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 |
||||||||||||||||||