AM Foundations Workshop - 8am to 11am
Microsoft Excel & Google Tools

Excel
-Basic Terminology: columns, rows, cells
-Types of Data: labels, constants, formulas
-Symbols for math functions
-Functions: SUM, AVERAGE, MAX, MIN, COUNT, IF
-Fill Down
-Formatting Cells
-Column Widths
-Charts & Graphing Data
Hands-on: Making a Gradebook in Excel

Google Tools
-Advantages of collaborative tools/web-based applications for the classroom
-Demonstration: Google Docs (Documents/Presentations/Spreadsheets)
-Demonstration: Google Notebook
-Demonstration: Google Calendar
-Demonstration: Google Pages
Hands-on: Create a classroom resource using a Google Tool

Wrap-Up
Brainstorming: How can we use these tools in our curriculum?
Next visit: lesson planning time



PM Foundations Workshop - 12noon to 3pm
Blogging & Podcasting

Blogging
-Introduction to blogging/web publishing
-Platforms for blogging
-Integrating blogs across the curriculum
-Reading & evaluating blogs
-Introduction to RSS
Activity: register & start a classroom or teacher blog

Podcasting
-Introduction to Podcasting
-Podcasting as a classroom tool
-Listening to & evaluating classroom podcasts
-Demonstration: methods of podcasting/tools needed
-Demonstration: creating a podcast on the fly
Activity: In groups, brainstorm/plan/script/record a podcast

Wrap-Up
Brainstorming: How can we integrate blogging & podcasting across the curriculum?
Next visit: lesson planning time