Data Workshop

Description:

One of the tenets of RTI is making decisions based on actual analysis of real data, not just acting on a ‘hunch.’ That’s not to say your hunch is not often true, but it’s much more reassuring and convincing when it’s backed by real data. When it comes to deciding on the best intervention strategies, making data-based decisions is key.

In this session, we will explore examples of data collection tools currently in use by schools. You will get an introduction to helpful technology tools for the collection, easy analysis and collaborative communication of your data. There will be both discussion of concept development as well as hands-on practice with the tools we explore.

Come with your plans and ideas, a computer (tablets are not recommended) and walk away ready to implement your own customized data systems.


WiFi :

KTN Polson Meeting Room

Password: michel

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