Spreadsheet+Agendas+2012



=DAY 1: Spreadsheet Overview=

M&Ms and Dipnetting

 * ** Content (What do we want participants to know and be able to do?) ** || ** Processes **
 * (How will we get there?) ** || ** Time ** || ** Who ** || ** Materials ** ||
 * ** Opening (Launch) **

Review of essential questions, targets, success criteria and agenda Review expectations of participation. Discuss norms for participation during the session. 8:00-8:30 || Jessica || Agenda
 * Review of essential questions, targets, success criteria, agenda for the day. ** || Opening
 * Discuss with participants the **//Procedure Summary://** //design of case study, data collection procedures and importance of the data.//
 * Obtain consent (orally) from participants. || 30 minutes

Procedure summary

Informed Consent (Appendix E)  || 8:30-8:40 || Consenting volunteers || Digital Spreadsheet Pre-Assessment (Google Form: Appendix A) https://docs.google.com/spreadsheet/embeddedform?formkey=dFRkRld6TEpxejVHd0htT252dUpOMXc6MQ || 8:40-9:30 ||  || Small group interview questions for volunteers (Appendix C part I and Part II). || 9:30-9:45 ||  ||   ||
 * ** Voluntary Survey ** || Allow consenting volunteers time to complete the voluntary survey. || 10 minutes
 * ** Small Group Interview ** || Pre-PD interview with consenting volunteers || 50 minutes
 * ** Break ** || ** 15 minute break ** || 15 minutes
 * ** (Explore) **


 * Immersion in spreadsheet creation and manipulation **

// Teachers will be primary planners during afternoon session. //
 * M&M activities ** || Use a gradual release model to immerse teachers in using the lesson planning template while “trying out activities” as students.
 * 1) 1. Teachers as students: Engage 1
 * 2) 2. Teachers as co-planners: Engage 2, Explore 1,2

9:45-11:45 || Jessica and group || M&M activities
 * What did you learn from our work and discussion and what are the emerging implications for your practice? ** || 2 hours

Lesson Planning Template--see links on M&M activity page.

Computers with digital spreadsheet software || 11:45-12:45 || All ||  ||
 * ** Lunch ** || ** 45 minute lunch ** || 60 Minutes
 * ** Immersion in spreadsheet creation and manipulation **

Throughout the work the teachers will use the lesson-planning template to identify the big idea, learning targets and success criteria.
 * Dipnetting activities ** || Teachers will work in partners through the dipnetting lesson series.

While engaging in the content, teachers will anticipate student strategies and conceptions.

Based on their immersion work, how would they plan this lesson? Using the lesson plan template teachers will organize the launch, explore and summary strategies they would use to scaffold learning for students. || 2 hours 12:45-2:45 || Jessica and group || Dipnetting activities

Lesson Planning Template

Computers with digital spreadsheet software ||
 * ** Reflection and Close **
 * (Summarize) ** || Teachers will share their findings and implications for their work.

Explain next steps: bring materials to next meeting to create participants own lesson plans. (April 23: 3:30pm-5:30pm) || 15 minutes 2:45-3:00 || Jessica and group ||  ||



=DAY 2: Study Group Lesson Design=
 * ** Content (What do we want participants to know and be able to do?) ** || ** Processes **
 * (How will we get there?) ** || ** Time ** || ** Who ** || ** Materials ** ||
 * ** Opening (Launch) **

Review of essential questions, targets, success criteria and agenda Review the work from the April 11th kickoff.
 * Review of essential questions, targets, success criteria, agenda for the session. ** || Opening

Expectation of the day: work in study groups to design a lesson or lesson series that integrates math, science and spreadsheets to be used in their classroom. || 15 minutes 3:30-3:45 || Jessica || Agenda || 3:45-5:15 || Study groups || Lesson planning template
 * ** Translating new knowledge into practice (Explore) ** || Teachers will work in study groups (2-4 people) to design standards-based interdisciplinary spreadsheet lessons. || 90 minutes

Computers with digital spreadsheet software ||
 * ** Reflection and Close **
 * (Summarize) ** || Teachers will share their findings and implications for their work.

Explain next steps: bring materials to next meeting to create participants own lesson plans. (April 23: 3:30pm-5:30pm) || 15 minutes 5:15-5:30 || Jessica and group ||  ||


 * ** Content (What do we want participants to know and be able to do?) ** || ** Processes **
 * (How will we get there?) ** || ** Time ** || ** Who ** || ** Materials ** ||
 * ** Opening (Launch) **

Review of essential questions, targets, success criteria and agenda Review the work from the April 23rd work session.
 * Review of essential questions, targets, success criteria, agenda for the session. ** || Opening

Expectation of the day: work in study groups to complete design a lesson or lesson series that integrates math, science and spreadsheets to be used in their classroom. || 10 minutes 3:30-3:40 || Jessica || Agenda || 3:45-5:15 || Study groups || Lesson planning template
 * ** Translating new knowledge into practice (Explore) ** || Teachers will work in study groups (2-4 people) to design standards-based interdisciplinary spreadsheet lessons. || 90 minutes

Computers with digital spreadsheet software || 5:15-5:30 || Jessica and group ||  ||
 * ** Reflection and Close **
 * (Summarize) ** || Teachers will share their findings and implications for their work. || 15 minutes