Access Introduction
Prerequisites: Windows Introduction and one Word or Excel class or equivalent experience.
This class is intended for individuals needing to learn about Access databases. Topics include: orientation to Access and database terminology; viewing, editing, and adding data; working with datasheets and design view; creating and using tables, queries, forms, and reports. The focus of the class is to understand how Access works and understanding tables.
Access Intermediate
Prerequisite: Access Introduction or equivalent experience.
This class is intended for individuals needing to create Access databases.
Topics include working with primary keys and understanding table field properties like text and number/date formats,
input masks, and lookups. The class will also focus on database design considerations and creating table relationships.
Access Forms
Prerequisite: Access Intermediate or equivalent experience.
This half-day class assumes participants understand how to create a basic form. Time will be spent modifying forms and form controls; working with form properties and settings; creating calculated controls; and creating and modifying subforms. We will also learn to apply formatting techniques to forms.
Access Queries
Prerequisite: Access Intermediate or equivalent experience.
This half-day class assumes participants understand basic query concepts. We will cover more advanced topics such as creating calculated fields, working with the expression builder, and summarizing groups of records. Additionally, we will examine various query types including parameter queries, crosstab queries, and action queries.
Access Reports
Prerequisite: Access Intermediate or equivalent experience.
This half-day class assumes participants understand how to create a basic report. Time will be spent using, creating, and modifying reports in design view. We will look at report sections, grouping, sorting, and inserting formulas. Additionally, we will learn to modify report and control properties and use report formatting techniques.
|
Adobe Acrobat 8 Introduction
Prerequisite: Windows Introduction or equivalent experience.
Adobe Acrobat 8 software lets you save documents in a compact Adobe Portable Document Format (PDF). These files will retain the exact look and feel of the original documents. You can email Adobe PDF files or post them to your web site, and feel confident that they can be viewed and printed by anyone, anywhere across a broad range of hardware and software. This class and/or slice will give you an introduction on using this versatile program to convert your documents into a secure PDF format.
|
Blogs
Prerequisite: Intermediate Internet experience
Delve into the latest technology on the web. Blogs are a type of
web journal which encourages others to participate in social computing.
In this workshop, we will look various blogs and investigate how blogs are
being successfully used in the world of education. You will also set up your first online
blog at one of the popular blog sites. This workshop is for those who have time to create,
develop, and maintain their own blogs. Access to a working email account during class is necessary.
Desktop Publishing with Word 2007
Prerequisite: Word 2007 Intro or equivalent experience.
Learn how to create flyers, newsletters, and dynamic looking documents with Word 2007's new graphic features and themes. Inserting pictures, clip art, shapes, and SmartArt Graphics will be covered in this slice.
|
Digital Photography Introduction
Prerequisite: Windows Introduction or equivalent experience
This workshop is an introduction to the world of digital photography. We have several cameras for use in the class and you may also bring your own.(However, there will be no instruction on the use of your personal camera.) We will be taking photos, editing them, and learning how to use them in different applications. You can bring a CD-R or flash stick for saving your work at the end of class. Dress is casual, as we will be going outside, weather permitting.
|
|
Dreamweaver Introduction
Prerequisites: Windows Introduction, knowledge of folders, and Internet Introduction or equivalent experience.
Dreamweaver has become the industry standard for web site design and development. This class introduces students to the Dreamweaver environment. At the end of this class, students will have a good understanding of the basics of Dreamweaver and be able to construct and edit small web sites. It is strongly recommended that students also take HTML Introduction.
Dreamweaver Intermediate
Prerequisites: Windows Introduction, knowledge of folders, and Dreamweaver Introduction.
This class builds on the Dreamweaver Introduction. Learn how to lay out your pages using tables and see how graphics set into cells can enhance your site. We will also use the HTML views in Dreamweaver. Add a Flash button or Flash text to your page, and discover how to use Behaviors to jazz up your site. Bring ideas (and a disk) to create your own simple web site, time permitting.
Dreamweaver & CSS
Prerequisite: Intermediate and strong knowledge of HTML
This advanced course is designed for a student who wants to learn how to use Cascading Style Sheets to develop and design Websites. Using CSS-1 specifications, students will learn the differences between, when to use, and how to create imbedded, inline, and linked style sheets. Working with basic styles and HTML, students will use Dreamweaver to customize various styles, control background appearance, text, and colors. Basics will be discussed and then Dreamweaver will be used to create styles and sheets. |
Excel Introduction
Prerequisite: Windows Introduction or equivalent experience.
Microsoft Excel makes using a spreadsheet easy. This class will cover basic spreadsheet skills including: creating, saving, and printing workbooks; basic skills used in building and editing worksheets; techniques used in selecting, copying, moving, and replacing cell contents; basic formatting features such as alignment, fonts, and column widths; using basic formulas and functions, including relative and absolute cell referencing.
Excel Intermediate
Prerequisite: Excel Introduction or equivalent experience.
If you have mastered the basics of Excel, you are ready to move on to this class. Topics will include: working with and managing larger worksheets and workbooks, creating lists and data forms, using filters and functions with lists to analyze data, and more work with functions and formulas.
Excel Advanced
Prerequisite: Excel Intermediate or equivalent experience.
If you are comfortable with using Excel and would like to know a little more, this class covers the following topics: creating, applying, and managing Conditional Formatting Rules; creating Range Names and using them in functions and data validation lists; the basics of creating and working with Pivot Tables and Pivot Charts; and the basics of creating and working with Macros.
Excel 2003 Charts
Prerequisite: Excel Introduction or equivalent experience and knowledge of spreadsheets.
Illustrate your data with great looking charts! During this slice you will learn to create, edit, and format charts, and work with different types.
Excel Functions & Formulas
Prerequisite: Excel Introduction or equivalent experience.
Do you need to know more of the basics on how to work with functions and formulas in Excel? We will use some of Excel's built-in functions like: If, Proper, VLookup, Max, Min, PMT, Average, DCount, count, countA…as well as build some of our own specialized formulas like weighted averages. This class will include a review of Order of Operations and Relative and Absolute Cell Referencing.
Excel Shortcuts, Tips, and Tricks
Prerequisite: Excel Introduction or equivalent experience.
This class/slice is designed for people who currently use Microsoft Excel. Microsoft Office has many hidden options, unknown features, and shortcuts. We will show you formatting tips, keyboard shortcuts, and other tricks to customize Excel to work the way you want. You will be able to apply many of the same techniques in Word, PowerPoint, Publisher, and Access. Take this class to learn how to make Microsoft Office more powerful, more productive, and even easier for you to use. |
File Management
Prerequisite: Windows Introduction or equivalent experience.
This class/slice covers the basics of file management. Learn how files and folders are organized within your computer. Find out where your files go when you save them and how to put them in specific folders. Topics covered will be terminology, file management concepts, creating and renaming files and folders, moving and copying files, and folders.
|
GroupWise Introduction
Prerequisite: Windows Introduction or equivalent experience
This class will cover sending and receiving email, calendaring and scheduling, archiving, reviewing set-up options, creating and managing folders, and the address books.
GroupWise Intermediate
Prerequisite: GroupWise Introduction or equivalent experience.
This class will cover a review of archiving, using busy search, marking appointments as private, phone messages, reminder notes, tasks, categories, changing item type, using the checklist, filtering vs. the find feature, setting up notify, rules, and junk mail handling.
GroupWise 7 Tips & Tricks
Have fun customizing GroupWise based on your personal preferences and take advantage of features such as Categories, HTML-formatted mail, and Rules.
|
HTML Writing Introduction
Prerequisite: Internet Introduction or equivalent experience.
Learn the basics of writing a web page. Making a web page is not really very difficult. Basic HTML is surprisingly easy to learn and this class will explain what HTML is, and how HTML "markup tags" are used to format a web page. Using a free, popular editor, you will learn how to create web pages, import graphics, and text. It is highly recommended that you learn HTML before using other web editing programs. You can bring a CD-R or flash stick for saving your work at the end of class.
iLife '09 Overview
iLife is a suite of tightly integrated applications that comes installed free on every Mac. It includes iTunes, iPhoto, iMovie, GarageBand, and iDVD. Take a quick tour of each of these digital applications which contains everything you need to create and share compelling, media-rich projects for your Mac.
|
iTunes: It's Not Just About Music
iTunes is not just for the Mac! This is designed to give you an overview of Apple's iTunes software. See how to import music, make playlists, share your music on your network, visit the Apple Store, get content from iTunes U (K-12, college, and university courses), find podcasts, and more.
|
Minimizing the Impact of Spyware
Learn how to minimize the impact SpyWare can have on your computer's performance and steps you can take to protect your data and personal information.
|
Movie Maker
Prerequisite: Windows XP Introduction or equivalent experience and an understanding of digital photography basics.
Movie Maker for Windows XP is a basic yet powerful digital video editing tool. This workshop will teach you how to create a movie using Windows Movie Maker. Participants will use their own digital photos to create a finished movie, complete with music and special effects. This movie will be saved to a CD-ROM (not supplied). Please bring your digital photos (maximum 10-15) on CD or thumb drive and two blank CD-R's to record your finished movie to take home. We will not be transferring photos from your camera.
|
netTrekker d.i.
netTrekker is the award-winning search engine for schools that helps teachers match resources to each child's individual learning needs. It contains over 180,000 educator-selected online resources that are organized around the K-12 curricula and by grade level so searching is logical and easy. Students receive ONLY safe, relevant results and school-friendly images every time they use the Internet. netTrekker supports differentiated instruction with standards-based online resources, organized by readability level to help every child achieve. This workshop will introduce you to this web-based search engine, searching, creating saved searches, assistive searches, teacher tools, and NYS Standards searching.
During this workshop,you will also receive a complimentary free trial account which will provide complete access to netTrekkerfor 30 days.
|
Personal Computer Pit Stop
Prerequisite: Windows Introduction or equivalent experience.
Can't get your computer out of first gear? Wondering why it takes so long to boot up and what's taking up all of that space on your hard drive? Spend some time with us and learn some useful tips on how to maximize your computer's performance before you spend more money on hardware. Topics will include how to use the performance tools which are part of the Windows XP operating system, file management techniques, keeping your Desktop clean, uninstalling unwanted programs the correct way, keeping your virus scanning software up-to-date, how to counter the impact of Spyware on your computer's performance, and much more. This class and/or slice is geared for the novice computer user who has experience with Windows XP.
|
PowerPoint Introduction
Prerequisite: Windows Introduction or equivalent experience.
Learn the basics of creating powerful presentations for colleagues and others. This class will cover creating slides, customizing slides, inserting graphics, creating notes and handouts, giving on-screen presentations, and printing options. Use of the templates and wizards will be discussed. Bring ideas to create your own presentation. Also, bring a disk so you can save your creation to take home with you.
PowerPoint Enhancements
Prerequisite: PowerPoint Introduction or equivalent experience.
If you currently know how to create a basic PowerPoint presentation and would like to jazz it up, this is the class for you. Designed to take you to the next plateau, the focus of this class is the effective use of animations and transitions, as well as sound and video, to make an impressive and productive presentation. Learn the ins and outs of making slides and objects jump, twirl, change color, disappear, and more.
|
Publisher Introduction
Prerequisite: Word Introduction or equivalent experience.
Create great looking flyers, business cards, newsletters and much more using Publications for Print. We will also cover different aspects of working with text and graphics during this slice.
|
Specialty Projects Workshop
Is there something you need help with? This workshop is what you’ve been asking for. We can help with any software product listed on our classes’ page. Bring your special project, problem, or anything that you need help with and we will help you to work it out. We will have two-hour blocks throughout the day for individualized help. When you sign up for this workshop, you will be asked to tell us what you need help with and also sign up for a specific time slot.
Switching from a PC to a Mac
So you’re considering switching to a Mac, but where do you start, and what do you do? Is owning a Mac something that has crossed your mind? Would you like to learn about Macs and the Mac OS X operating system? This presentation (not hands-on) or slice will guide you through the basics of the Mac, increase your knowledge of this exciting platform, and help you with your decision. If you have a new Mac and want to learn more about it, this workshop/slice may answer some of your questions.
Upgrading to Office 2007 - either Word, Excel, Access, or PowerPoint 2007
Prerequisite: You must have experience using the specific application in a previous version of Microsoft Office to take this class or slice .
Bridge the gap between earlier versions of MS Office and 2007's new approach. Learn how the new MS Office 2007 user interface can help you create documents faster, more easily, and more intutively. Reduce the time and frustration of learning new software with commands and present the right tools when you need them. Learn the use of improved picture, charting, and graphics tools to help you produce better-looking documents, spreadsheets, and presentations more quickly. Learn how live preview shows your changes quickly.
|
Using the Lesson Activity Toolkit in SMART Notebook 10
Prerequisite: Previous experience using the SMART Notebook.
You will learn how to use the Lesson Activity Toolkit which is a Gallery collection of customizable tools and templates, including activities, games and graphics that you can use to create professional-looking, interactive, and engaging lessons.
Using the Smart Board
Prerequisite: Knowledge of Microsoft Word, Excel, and/or PowerPoint is helpful.
In this class, we will cover the basics of using the SMART Board as well as the SMART Notebook. Topics will include: reviewing SMART Board components such as the styluses, keyboard, and orientation feature; working with Microsoft Word, Excel and PowerPoint on the SMART Board; using the SMART Notebook to manipulate objects, covert handwriting to text, insert and capture images, and add attachments; and exploring SMART Board tools like the SMART Recorder, Shade, Spotlight, and Magnifier. |
Windows XP Introduction
Learn the basics of Windows XP including terminology and moving and resizing windows,customizing Windows, the taskbar, and the start menu, creating Shortcuts, and learning other Windows tips and tricks. You will also learn about general computer maintenance, become familiar with word processing, and copying and pasting between programs. By the end of class you will feel much more comfortable with your computer!
|
Word Introduction
Prerequisite: Windows Introduction or equivalent experience.
Microsoft Word makes word processing easy. This class will cover basic word processing skills including: creating, saving, and printing documents; editing techniques for selecting, copying, moving, and replacing text; basic character and paragraph formatting techniques; such as line spacing, indenting, and tabs. Using bullets and numbering lists will also be covered.
|
Word Intermediate
Prerequisite: Word Introduction or equivalent experience.
If you have mastered the basic word processing techniques of Word, you are ready to move on to some of the more advanced features of this program. Topics will include: working with tables; basic page formatting features such as margins, headers, and footers; and mail merge.
|
Word Shortcuts, Tips, and Tricks
Prerequisite: Word Introduction or equivalent experience.
This class/slice is designed for people who currently use Microsoft Word. Microsoft Office has many hidden options, unknown features, and shortcuts. We will show you formatting tips, keyboard shortcuts and other tricks to customize Word to work the way you want. You will be able to apply many of the same techniques in Excel, PowerPoint, Publisher, and Access. Take this class to learn how to make Microsoft Office more powerful, more productive, and even easier for you to use
|
Word Tables
Prerequisite: Word Introduction or equivalent experience.
Are you confident with word processing but get confused when you have to create or work with tables? If so, then this slice is for you. Topics will include creating tables; adjusting table size; adding, deleting, and moving rows and columns; merging and splitting cells; working with borders and shading; sorting; and more. With this new knowledge, you will be able to create schedules, calendars, resumes, and lists with ease.
Working with Objects in SMART Notebook 10 "Slice"
In this slice, you will learn how to create an object using each of the drawing tools found on the SMART Notebook software toolbar, use the Properties tab to modify the color, line style, and text style of the objects; bring in objects from the Gallery; and work with the options found in the object drop-down menu. |
|
