Local knowledge
Sign up for this class.
Title: Microsoft Word: Office 2007
Date: Tuesday, September 16, 2008
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 Word is the most widely used word processing program in the United
States 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
design. This class will facilitate using this new version of Word. For those using a previous version of
Word, the class can also be very useful. The concepts remain the same, but users of previous version
should realize the screens will look different.
The class will cover:
a. Structural overview
b. Formatting and styles
c. Getting around better and using Views
d. Page layout
e. Tables
f. Pictures, clipart and other objects
Sign up for this class.
Title: Introduction to Grant Writing
This class will be offered in two locations:
Date: Thursday, September 18, 2008
Location: North Country Library System, Watertown
Date: Friday, September 19, 2008
Location: Clinton Essex Franklin Library System, Plattsburgh
Presenter: Barbara Berger Eden, Cornell University
Time: Sign-in, 9:00-9:30 a.m.; Class, 9:30 a.m. - 12:30 p.m.
Fee: $10.00 for library staff, $29.95 for all others. "Blue Line" Library Staff:
No Charge
Description: In these days of stagnant or shrinking budgets, librarians need to identify
alternative sources of funding. One solution to this problem is to develop a successful grants program.
Learn how to master writing a grant proposal by attending this class. Barbara Berger Eden, Director,
Department of Preservation and Collection Maintenance, Cornell University Library, has been writing
proposals for the past 20 years that have covered a wide-spectrum of library projects. She has been the
coordinator of many projects that have ranged from digitization of special collections to education and
training of library staff. This class is intended for librarians, administrators, and support staff from
all types of libraries responsible for financial development.
Sign up for this class.
Title: Microsoft Excel, Beginning Level: Office 2007
Date: Tuesday September 23, 2008
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 also be very useful. The concepts remain
the same, but users of previous versions should realize that 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 & accuracy
d. Formulas for power
i. Autosum and other autos...
ii. Arithmetic
iii. Introduction to functions
e. Format for pretty
f. Print basics & the page layout ribbon
g. A picture is worth a thousand words, so chart!
Sign up for this class.
Title:
Lessons for Scanning, Part 1:
Planning Your Digitization Project and Introduction to Scanning
Date: Wednesday, September 24, 2008
Location: Northern New York Library Network, Potsdam
Presenter: Peter Verheyen, Syracuse University
Time: Sign-in, 9:00-9:30 a.m.; Class, 9:30 a.m. - 3:30 p.m.
Fee: $15.00 library, museum, and historical society staff; $59.95 all others (Lunch included.)
Description: Libraries are looking more and more for digital solutions for preserving fragile
material, making resources available to remote users, and improving access to special collections.
"Lessons for Scanning" is a two-part course that will enable participants to determine how this technology
fits into their library environment. In "Lessons for Scanning," Part 1, participants will be taught how to
begin incorporating digitization into their library’s technology plan for preservation and access. The
morning session will concentrate on planning a digitization project. The course of a digitization project
will be explained and budgeting, staffing and critical technical issues addressed. Following lunch, the
afternoon session will provide an introduction to the technical process of scanning library materials.
Both sessions will be conducted by Peter D. Verheyen, Preservation & Digital Access Librarian, Special
Collections Research Center, Syracuse University Library.
Part two of the series will be presented on October 8, 2008.
Sign up for this class.
Title: Microsoft Access, Beginning Level: Office 2007
Date: Tuesday, September 30, 2008
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 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 will be very useful. The concepts remain
the same, but users of previous versions should realize 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.