Data Workshop

Description:

This training is designed to specifically address an OPI change of what was the "COMMENTS" section of the IEP progress report to now say "DATA" . The expectation is that there will be specific data collected to support statements on student progress reports. This training session will help special educators (and others) meet the criteria for collecting and using academic and behavioral data to monitor & guide instructional progress as well as address progress reporting requirements. Bring your laptop (tablets won’t work) and your ideas for the data you need to collect. You will receive guidance and support on how to make your data collection ideas work!

WiFi :

connect to Hilton Honors

Next Open Browser,

Should auto load Hotel Guest login page.

Scroll down and select "I have a Promo Code"

code is: comp

Access this Digital Handout site here:


http://bit.ly/WMCSPD-DATA


Agenda Session 1

Agenda - 9 am to 4 pm

1. Intro & the WHY for Data Collection

2. Tools to do the job.

3. Examples of Data Collection tools (yours & ours)

4. Explore Form Data & Speadsheets

LUNCH on your own

5. Collaboration

6. Workshop time

7. Share out & Travel Safe


Specifics to agenda:

Why for Data collection (new OPI requirement)

Show form examples

Review building form questions

    • what to collect - types of questions

Explore form data

    • Responses vs Linked spreadsheet

Show examples of spreadsheets

    • formulas
    • Add-ons

Data Analysis

    • Form Responses
    • Custom Charts
    • Formulas to Filter, Sort, Lookup
      • Building custom views of data using formulas

Workshop time

Closing - Group share of team ideas, works in progress, etc. "Show us what your team got done today"


Topics to cover if time and interest:

  • muli-user windows vs one window logins
  • access form from mobile devices (phones, tables)


Agenda Session 2

Lunch will be on your own - apx. noon

We will cover the topics below allowing ample time for questions and workshop time to create and collaborate.

A Quick Review

  • What we covered last time

Share you Data Collection Tools and Experience

  • Types of data collected - i.e. behavior, progress monitor, etc
  • Challenges
  • Successes

Topics to be explored Today

  • Multiple browser windows and Chrome sync
  • Submitting forms from mobile devices
  • Automating forms with Add-on tools
    • Large drop-down list lookup and synchronization
    • Automated email notification & document creation using 'key-field' form data
  • Sharing data & analysis
    • Collaborative docs
    • Web Portals (how to protect data with share settings)
  • DBR - Direct Behavior Rating - explore the concept and available tools
  • Summarizing Data
    • DBR - Direct Behavior Rating
    • Creating Charts - Selecting the right chart to display your data
    • Navigating customization settings within charts

Agenda Session 3

Lunch will be on your own - apx. noon

With a mixture of folks having attended previous introductory data sessions and some this being their first workshop. The pacing of this day will be a mixture of direct instruction, sharing of examples and independent work. We will attempt to cover the topics below allowing ample time for questions and workshop time to create and collaborate.

A Quick Review

  • What resources are available on this site. Please share your questions and desired learning outcomes in the Comments & Question Parking lot form.

Share you Data Collection Tools and Experience - Especially the 'Veteran' data attendees

  • Types of data collected - i.e. behavior, progress monitor, etc
  • Challenges
  • Successes

Topics to be explored Today

  • Multiple browser windows and Chrome sync
  • Review of the process for creating forms to collect data (for newer attendees)
  • Submitting forms from mobile devices
  • Automating forms with Add-on tools
    • Large drop-down list lookup and synchronization for larger, non-static lists
    • Automated email notification & document creation using 'key-field' form data and Add-ons
  • Importing and Exporting data (CSV)
  • Sharing data & analysis
    • Collaborative docs (understanding levels of sharing)
      • Using filter views to create quick sorting of data for those with only View share settings
    • Web Portals (how to protect data with share settings)
    • Using the New Google sites (again, review levels of share access)
  • Summarizing Data
    • Conditional formatting and other spreadsheet tools to help make data more readable
    • Explore tool & Pivot tables - quick ways to analyze data
    • Creating Charts - Selecting the right chart to display your data
    • Navigating customization settings within charts
    • Creating progress monitoring charts (like those illustrated during Wayne's Data session)
      • Charts with Aim lines or Benchmark goals