Graph Template Videos


Graph Template tour

Tabs (Excel Sheets)

  • Instructions
  • Templates (colored tabs)
  • Example data

Types

  • Behavior Tracker
  • Discrete Trial Training (DTT)
  • Language Tracker

How to copy your templates

Right-click desired tab // Move or Copy // check "Create a copy"

To do list:

  • Rename tab (sheet)
  • Label title of graph with your program
  • Add data
  • Don't forget your Target List is a TABLE

Selecting data series to format on your graph

Learn how to select a specific data series on your graph. This feature is helpful when it's tough to directly click a series on your graph.


Entering ongoing data

Learn how to extend data on your graph while also entering ongoing data.


conditional formatting

Learn how to change color of cells based on criteria (e.g. mastery criteria, red flags).


Phase change lines (using error bars)

Use Error Bars to create phase change lines. Check out McGinnis Dean Press for the original YouTube video!


how to print

There are 2 versions of the graph template:

  • Mac users MS Excel 2011
  • PC users MS Excel 2013

Each template is sized and optimized for printing. This video provides some workarounds to the common barriers of working with MS Excel, and shows you how to print your data.