Title: Installing and Using Firefox Extensions
Date: Friday, January 9, 2009
Presenter: Paul Doty, Electronic Services Librarian, St. Lawrence University
Time: Sign-in, 9:00-9:30 a.m.; Class, 9:30 a.m. - 12:30 p.m.
Location: Northern New York Library Network, Potsdam
Fee: $10.00 for library staff, $29.95 for all others, "Blue Line" Library
Staff: No Charge
Description: The purpose of this class is to provide participants with experience with Firefox,
and specifically with information oriented Extensions: what they do, where they are, and how to integrate
them into a Firefox Browser. Firefox is an open source World Wide Web Browser. Because open source code is
open to see, programmers and web-enthusiasts have developed utilities for Firefox that make it an
increasingly dynamic and flexible browser. These utilities are called Extensions, and are defined by
Firefox developers as "...small add-ons that add new functionality to Firefox, from a simple toolbar button to
a completely new feature. They allow you to customize Firefox..." These extensions or "add-ons" may include
All-in-One Sidebar, Mini Map Sidebar, Forecast Fox for feeds, news and blogging, dictionaries, language help
and much, much more. Extensions can be applied to just about any web-based function, and over time a number
of Extensions have been developed that speak directly to searching for and managing information.
Sign up for this class.
Title: Microsoft Excel, Beginning Level: Office 2007
Date: Thursday, January 15, 2009
Presenter: James Crowley, Crowley Computers
Time: Sign-in, 9:00-9:30 a.m.; Class, 9:30 a.m. - 3:30 p.m.
Location: Northern New York Library Network, Potsdam
Fee: $15.00 for library staff, $59.95 for all others (Includes lunch), "Blue Line"
Library Staff: No Charge
Description: Microsoft Excel is the most widely used spreadsheet program in use today. With the
introduction of Microsoft Office 2007 many of the familiar toolbars and screen designs changed dramatically,
along with the introduction of the "ribbon," Microsoft’s new navigational tool. This class will facilitate
using this new version of Excel.
For those using a previous version of Excel, the class can be very useful. The concepts remain the same,
but users of previous versions will see the screens will look different.
The class will cover:
a. What’s a spreadsheet? Excel versions and alternatives
b. Application pieces parts
c. Building a spreadsheet from scratch
i. Entry, editing and basic navigation
ii. Column and row sizing
iii. Autofill: laziness for speed and accuracy
d. Formulas for power
iv. Autosum and other autos...
v. Arithmetic
vi. Introduction to functions
e. Format for pretty
f. Print basics and the Page Layout ribbon
g. A picture is worth a thousand words, so Chart!
Sign up for this class.
Title: Microsoft Access, Beginning Level: Office 2007
Date: Friday, January 23, 2009
Presenter: James Crowley, Crowley Computers
Time: Sign-in, 9:00-9:30 a.m.; Class, 9:30 a.m. - 3:30 p.m.
Location: Northern New York Library Network, Potsdam
Fee: $15.00 for library staff, $59.95 for all others (Includes lunch),
"Blue Line" Library Staff: No Charge
Description: Microsoft Access is the most widely used database program in use today. With the
introduction of Microsoft Office 2007, however, many of the familiar toolbars and screen designs changed
dramatically, along with the introduction of the "ribbon," Microsoft’s new navigational tool. This class
will facilitate using this new version of Access.
For those using a previous version of Access, the class can be very useful. The concepts remain the same, but users of previous versions will see the screens will look different.
The class will cover:
a. Database basics: understanding the pieces, Access versions and alternatives
b. Databases from templates
c. Tables
i. Exploring with Northwind
ii. Creating tables with wizards
iii. Field names, types, basic options
iv. Necessity of primary keys
v. Design and datasheet view
vi. Add, edit and delete records
vii. Sorting, finding and viewing
d. Queries: sorting and filtering records
e. Forms: creation via wizards, basic design modifications
f. Reports: creation via wizards, getting totals, basic design modifications
Sign up for this class.
Title: Microsoft Excel, Level 2: Office 2007
Date: Tuesday , January 27, 2009
Presenter: James Crowley, Crowley Computers
Time: Sign-in, 9:00-9:30 a.m.; Class, 9:30 a.m. - 3:30 p.m.
Location: Northern New York Library Network, Potsdam
Fee: $15.00 for library staff, $59.95 for all others (Includes lunch),
"Blue Line" Library Staff: No Charge
Description: Students who have used this popular spreadsheet program in a limited way, or
students who participated in the Beginner’s Level class previously offered by the NNYLN, will find this
Level 2 class helpful in learning to fully utilize the powerful features of Microsoft Excel. Excel can be
much more than a basic spreadsheet program, and this class can help students realize that potential.
For those using a previous version of Excel, the class can be very useful. The concepts remain the same,
but users of previous versions will see the screens will look different.
The class will cover:
a. Structural overview
b. Navigate faster
c. Formulas for more power!
i. Basics review
ii. Finding functions and the formulas ribbon
iii. Relative and absolute references
d. More formatting for more readability
iv. Conditional formatting
e. Get three dimensional with sheets
v. Formulas across sheets
f. Copying and moving data
vi. Cut, copy, paste
vii. Dragging things around
g. Databases
viii. Sorting
ix. Autofilter
Printing review
Sign up for this class.
