Shelly Cashman Series Summer Institute Course Descriptions
MONDAY, JULY 14TH
Excel 2007 - The Next Step ~ Jeff Quasney
This intermediate level course covers financial functions, working with data tables, sorting and
querying data tables, creating templates, and working with multiple workbooks. We will cover
more advanced formatting and delve into new charting features in Excel 2007, as well as the new
Word 2007 - The Next Step ~ Misty Vermaat
In this intermediate course, topics include creating a document with a title page, table, chart, and
watermark; generating form letters, mailing labels, envelopes, and directories; creating a
professional newsletter that contains WordArt, a pull-quote, and graphics; and linking an Excel
worksheet and chart to a Word document. Chapters 4, 5, 6, and Feature 2 from the book will be
Teaching Information Technology Concepts Through the Lens of Web 2.0 ~ Mark
Recent years have seen a shift in how people have used the World Wide Web as it evolved from
a tool for disseminating information and conducting business to a platform facilitating new ways of
information sharing, collaboration, and communication in a digital age. A new vocabulary has
emerged, as mashups, flickr, YouTube, del.icio.us, twitter, and WikiPedia have come to
characterize the genre of interactive applications collectively known as Web 2.0. This hands-on
session will introduce these and other Web 2.0 technologies and suggest ways to incorporate
them into the information technology classroom.
Adobe Photoshop CS3 – An Introduction ~ Joy Starks
This is an introductory course. Topics include the Photoshop workspace, basic editing, menus,
tools, and palettes. You will learn about the following tools: marquee, move, lasso, magic wand,
eraser, and clone as you create layers, masks borders, and guides. Chapters 1, 2, and 3 from the
book will be covered.
Dreamweaver CS3 – An Introduction ~ Steve Freund
This is an introductory course. Topics include navigating the Dreamweaver CS3 workspace,
creating a basic Web page and Web site using Dreamweaver CS3, and adding and formatting
text, images, and other Web page elements. Tables and page layout techniques are discussed.
Chapters 1, 2, and 3 from the book will be covered.
TUESDAY, JULY 15 TH
Excel 2007 – Advanced ~ Jeff Quasney
This advanced Excel course covers macros, VBA, complex problem solving with the Excel Solver
add-in, and importing data into a workbook. New features in Excel 2007 that are covered include
information rights management, converting text to columns, transposing data during a paste
operation, checking a workbooks compatibility with previous version of Excel, and removing
private and personal information from a workbook.
Word 2007 – Advanced ~ Misty Vermaat
This is an advanced course. Topics include working with document sharing tools such as tracked
changes and comments, a master document, a table of contents, and an index; creating an online
form that contains content controls; enhancing an online form and working with macros,
document security, and XML; and creating and publishing a blog post. Chapters 7, 8, 9, and
Feature 3 from the book will be covered.
Access 2007 – An Introduction ~ Philip Pratt and Mary Last
For this introductory course, topics include creating and using databases and tables; previewing
and printing the contents of a table; creating simple reports using the Report Wizard; creating and
using a split form; creating queries; using character data, wildcards, numeric data, comparison
operators, compound criteria, and/or calculated fields in queries; creating parameter queries;
sorting query results; creating a top-values query; joining tables; changing join properties;
statistics in queries; changing formats and captions; creating crosstab queries; adding, changing,
deleting, locating, and filtering records; changing the structure of a table; changing the
appearance of a datasheet; validation rules; Lookup fields; referential integrity; subdatasheets,
importing data; linking data; exporting data; and using XML data.
Adobe Photoshop CS3 – The Next Step ~ Joy Starks
In this intermediate course, topics include drawing and painting with color, enhancing and
repairing photos, and creating color channels and actions. You will learn about the following
tools: color picker, brush, shape, swatches, paint bucket, ellipse, pen, path, line, gradient, spot
healing brush, patch, red eye, dodge, burn, sponge, and warp. Chapters 4, 5, and 6 from the
book will be covered.
Adding Interactivity to and Formatting your Dreamweaver CS3 Web Sites (Intermediate)
In this intermediate course, topics include advanced Dreamweaver 8 features, including creating
forms, adding form objects, templates, HTML styles and cascading style sheets, applying styles
to templates, layers, image maps, behaviors, and navigation bars. Chapters 4, 5, and 6 from the
book will be covered.
WEDNESDAY, JULY 16th
RSVB to Visual Basic 2008 – An Introduction ~ Corinne Hoisington
This course is designed for an instructor who is a beginner in the Visual Basic environment or
interested in a new way to teach programming. Topics include an introduction to Visual Basic
programming; structured programming; object-oriented programming and design; event-driven
programming; methodology for building Visual Basic applications; the Visual Studio 2008
development environment; adding and removing objects; setting properties; accessing Visual
Basic help; writing code in the Visual Studio IDE; data types; use of variables and constants,
arithmetic operations, and logical operations. Windows applications and Smart Device
application will be introduced. Projects 1, 2, 3, 4 and 5 from the book will be covered.
Windows Vista – An Introduction ~ Ray Enger
In this introductory course, topics include navigating the Windows Vista desktop and Start menu,
working with gadgets on the Windows Sidebar, and Windows Vista Help and Support. WordPad,
the components of a folder window, file and folder management, and backing up your files also
are discussed. Chapters 1, 2, and 3 from the book will be covered.
Access 2007 – The Next Step ~ Philip Pratt and Mary Last
In this intermediate course, topics include the Report Wizard; modifying report designs in Layout
view; sorting and grouping in a report; adding totals and subtotals to reports; using multiple tables
in a report; conditionally formatting controls; the Form Wizard; modifying form designs in Layout
view; multi-table forms; Yes/No, date, memo, OLE, hyperlink, and attachment fields; input mask
wizard; updating forms in Design view; including combo boxes; including subforms; creating,
editing, and using macros; switchboard systems; PivotTables and PivotCharts; creating SQL
queries; using criteria; sorting; using functions; grouping; joining tables; and a comparison with
Adobe Photoshop CS3 – Advanced ~ Joy Starks
This is an advanced course. Topics include applying filters and patterns, using lighting effects,
text overlays, shadows and reflections, notes and audio annotations, creating original vector
graphics, Web photo galleries, slices, tweening, and animation. Chapters 7, 8, and 9 from the
book will be covered.
Making Your Dreamweaver CS3 Web Site Look Its Best – Advanced ~ Steve Freund
This is an advanced course. Topics include advanced Dreamweaver 8 features, including page
layout with frames, animation and behaviors, media objects, and the Dreamweaver Web Photo
Album. Dreamweaver help, accessibility, and publishing to a Web server are discussed. Chapters
7, 8, 9, and the Special Feature from the book will be covered.
THURSDAY, JULY 17th
PowerPoint 2007 – An Introduction ~ Susan Sebok
In this introductory course, topics include selecting appropriate document themes, creating title
and text slides with bulleted lists, changing the size, color, and style of text using the Format
Painter, and viewing and printing presentations, outlines, and handouts. Other topics include
inserting and formatting shapes, photographs, and clips, applying Quick Styles to placeholders
and shapes, and selecting slide transitions. Additional topics include creating presentations from
outlines, designing custom backgrounds, creating a SmartArt graphic and then applying a
SmartArt style, formatting WordArt, and creating Web pages. Chapters 1, 2, 3, and Feature 1
from the book will be covered.
RSVB to Visual Basic 2008 – Intermediate ~ Corinne Hoisington
This intermediate course is designed for an instructor who teaches topics which include using
looping structures, adding code snippets, user validation, using the MenuStrip control, and
publishing applications using the Click Once Application technology. Web site applications will
also be built using the powerful new ASP 3.5. A Visual Basic 2008 Web application can now be
opened in Expression Web and the Expression engine is now within VB 2008. Projects 6, 7, 8,
and 9 from the book will be covered.
Communication and Personalizing Windows Vista – Intermediate ~
Steve Freund and Ray Enger
In this intermediate course, topics include using Windows Vista for personal information
management, and communicating on the Internet using Windows Mail, Internet Explorer, and
Windows Live Messenger. Personalizing components of the desktop including the taskbar,
notification area, and Start menu, accessibility, and using the Control Panel also are discussed.
Chapters 4, 5, and 6 from the book will be covered.
Access 2007 – Advanced ~ Philip Pratt and Mary Last
In this advanced course, topics include creating a report in Design view; subreports; adding dates
and page numbers to reports; grouping and ungrouping controls; updating multiple controls;
creating mailing labels; creating a form in Design view; adding command buttons to forms; adding
combo boxes; modifying buttons and combo boxes; adding an option group and creating a macro
for the option group; using tab controls; inserting, modifying, and formatting charts; converting
databases; the Table Analyzer, Performance Analyzer, and Documenter tools; automatic error
checking; custom input masks; indexes; selecting a startup form; encrypting a database and
setting a password; digital certificates; the Trust Center; locking a database; splitting a database;
creating a SharePoint list from an Access table; importing or linking a SharePoint Services list to
an Access table; and moving a database to SharePoint.
Publisher 2007 – An Introduction ~ Joy Starks
This is an introductory course. Topics include creating and editing publications from scratch and
from templates. As you create flyers, brochures, newsletters, and e-mail, you will learn about
editing, positioning, and resizing text, graphics, repeating elements, and design gallery objects,
as well as converting print publications to Web publications. Chapters 1, 2, 3, and Feature 1 from
the book will be covered.
FRIDAY, JULY 18th
Bringing Web 2.0 to Your Classroom ~ Farhad Javidi
Web 2.0 technologies are empowering us in ways we could only have imagined a few years ago.
We're able to build more, connect more, teach better, have more fun and share more than ever
before. In this exciting full-day training, participants will learn some of the Web 2.0 tools that can
help to improve student achievement, provide a more meaningful learning experience, and
increase conversation and collaboration.
RSVB to Visual Basic 2008 – Advanced ~ Corinne Hoisington
Don't let the word advanced scare you off! Actually this is the Friday fun day! An investigation of
the new Visual Studio Office Tools will be made which allows developers to program in Microsoft
Office 2007 applications. Databases, the new LINQ database connection, cell phone applications,
web services, and the new Microsoft Reports will also be discussed. Projects 10, 11, 12 and the
Enrichment Chapter from the book will be covered.
PowerPoint 2007 – The Next Step ~ Susan Sebok
This is an intermediate course. Topics include working with information graphics, including
creating charts and tables, changing the entire presentation theme colors and fonts, formatting
pictures and clips by adding styles, effects, and borders, inserting hyperlinks and action buttons,
changing bullet characters, and using the thesaurus. Running shows with pens and highlighters,
packaging presentations for a CD, collaborating by using comments, and compressing files are
discussed along with adding multimedia files and setting slide show timings. Other topics include
creating a self-running presentation containing animated shapes, formatting slide masters,
locating templates from the Microsoft Office Online Web site, and changing presentation
orientation and resolution. Chapters 4, 5, 6, and Features 2 and 3 from the book will be covered.
Publisher 2007 – The Next Step ~ Joy Starks
In this intermediate course, topics include using business information sets, merging publications
and data, and creating an interactive Web site. You will learn to create letterhead, business
cards, catalogs, calendars, and labels. You also will edit graphics, autoshapes, tables, the
content library, bookmarks, form controls, hot spots, and HTML code fragments. Chapter 4, 5,
and 6 from the book will be covered.
Windows Vista – Advanced ~ Ray Enger
In this advanced course, topics include advanced file searching techniques, indexing, the Search
folder window, saved searches, and searching from the Start menu. Working with digital pictures,
music, and videos using programs such as Windows Media Player, Windows Photo Gallery, and
Windows DVD Maker also are discussed. Chapters 7, 8, and 9 from the book will be covered.