1. Microsoft Office 2007/2010 Overview
Presenter: Connie Hyslop

What’s New! Have you recently upgraded to Office 2010? Thinking about whether you should make the change? During this session, the instructor will provide an overview of what’s changed in Word, Excel, Access, PowerPoint, Publisher and Outlook will be discussed.

2. Cloud Computing – Productivity 2.0 – Taming Technology to Manage Your Life
Presenter: David Trask, Oakland SD

This session will be lead by David Trask. In the session we’ll explore the use of online collaboration tools such as the Goggle suite of applications (Google Apps)…Google Docs, spreadsheets, presentation, and forms…Zoho Office, Evernote, Dropbox, as well as a range of others. Participants will be given the opportunity to use these tools during class as well as learn how to set up “Google Apps for your domain”. In today’s digital society, portability and collaboration are easier than ever before. Work with groups of people from around the state/nation/world in a collaborative fashion without every leaving your office. Make phone calls, send text messages, broadcast messages to your team using Google Voice. Share documents with others at the click of a button. Give presentations online! Come and learn how to make yourself and your team more productive with “cloud computing!”

3. “Energy Markets, Procurement, Green and Sustainability Strategic Planning”
Presenter: Jon Sorenson

The deregulated energy markets are more complex than ever with the addition of new tariffs and the added focus on renewable and/or green/clean technology. Jon Sorenson, Competitive Energy Services managing partner, will provide a detailed energy market overview, explore energy product procurement, review regulatory developments, provide an overview of green and renewable initiatives and discuss strategy development and implementation. His program targets businesses, institutions and large endusers, and is appropriate for mid to high levels.

1. Creating Charts and Working with Macros
Presenter: Connie Hyslop

During this workshop participants will learn to create different types of charts including column, stacked, line and pie charts. Attendees will learn to work with embedded charts and chart sheets, understand chart components, move or resize an embedded chart, add new information to a chart, customize the chart axes, legend, title, data markers, gridlines, plot area and add notes or arrows to a chart.

2. IPads/Apps: All you wanted to know and more!
Presenters: Peter Robinson, Auburn School District

The Auburn School Department began an initiative this school year to provide iPads to all its kindergarten students. Come to this session to hear about this innovative initiative and how it’s doing in the first year of implementation. We’ll also take a look at the latest and greatest in iPad/iPhone/iPod Touch apps for productivity, learning, and just plain fun!

3. Is It Audit Time ALREADY???
Presenters: Steve Plodzik and Sheryl Pratt

Back to basics – In this session we’ll cover a number of topics including what you need to do to prepare for the annual audit and what is different about a “single” audit of Federal Funds. We’ll also cover things like what constitutes an encumbrance, what are allowable reserves and what are common “audit findings.”

1. Using Microsoft Excel Lists & Database
Presenter: Connie Hyslop

This workshop is designed for people who manage lists in Excel. Participants will learn how to use Excel database features including sorting information; use a list as a database; filter data to show specific record and calculate automatic database subtotals and totals. The presenter will show how pivot tables are used to summarize and analyze database information. In addition, conditional IF statements and Vlookup formulas will be covered.

2. Bargaining During Troubled Times and Its Impact on Settlements
Presenters: Roger P. Kelly & Matthew H. Upton, DW-Maine/NH

Two experienced public sector negotiators will discuss effective collective bargaining strategies and options and how negotiated settlements are occurring during these trouble times. ASBO members will be encouraged to raise issues and participate in these discussions.

3. They want to do WHAT with student activities???
Presenter: Steve Plodzik & Sheryl Pratt

Two experienced public sector negotiators will discuss effective collective bargaining strategies and options and how negotiated settlements are occurring during these trouble times. ASBO members will be encouraged to raise issues and participate in these discussions.