Behavior Data Tracking Spreadsheet That Calculates Biweekly Totals and Averages

Behavior Data Tracking Spreadsheet That Calculates Biweekly Totals and Averages
Behavior Data Tracking Spreadsheet That Calculates Biweekly Totals and Averages
Behavior Data Tracking Spreadsheet That Calculates Biweekly Totals and Averages
Behavior Data Tracking Spreadsheet That Calculates Biweekly Totals and Averages
Behavior Data Tracking Spreadsheet That Calculates Biweekly Totals and Averages
Behavior Data Tracking Spreadsheet That Calculates Biweekly Totals and Averages
Behavior Data Tracking Spreadsheet That Calculates Biweekly Totals and Averages
Behavior Data Tracking Spreadsheet That Calculates Biweekly Totals and Averages
Resource Type
Product Rating
File Type

Spreadsheet (Excel) File

Be sure that you have an application to open this file type before downloading and/or purchasing.

274 KB|12 pages
Share
Product Description
This Behavior Tracking Excel Spreadsheet is great for tracking behavior goals. The spreadsheet automatically tallies frequency totals and calculates a two-week average-- which is perfect for IEP behavior goal progress monitoring scores!

1. Track behavior frequency data throughout the day on an interval tracking sheet (see mine, available for download at http://www.teacherspayteachers.com/Product/Frequency-and-Interval-Data-Collection-Sheet-815806) under the DAY 1 tab.

2. Plug frequency data and interval data into the student's colored box on the Excel Spreadsheet. (I print my interval forms on colored sheets so I can quickly tell whose data I am entering).

3. The next day, repeat steps 1 and 2 under the DAY 2 tab. The next day, plug in data under DAY 3 tab, and so on.

4. After entering data on Day 10, click the TOTALS tab to see a total frequency count and percentage of time (interval) average, for the ten days. (You can also view the TOTALS data at any time before the ten day period has ended.)

EASILY CUSTOMIZABLE:

I made "Student1" the name in the orange box on every sheet, so you can do a find/replace (control + F) and change Student1 to your student's name across the workbook, and so on.

At the end of the 10-day period, select File - "Save As." Save a new spreadsheet for the next 10-day period.

This spreadsheet has 42 intervals (42 10-minute periods in a day). To reduce the number of intervals, change the math in the totals/percentages columns from /42 to /___. I'd be happy you assist you with this! If you have less than 42 intervals, it's important to change this so your students' behaviors do not appear to happen less frequently than they actually do.

Please don't redistribute. If you use any part of this product commercially, please link to my TPT Store-- http://www.teacherspayteachers.com/Store/Brandi-Felkowski

Thanks for visiting! Remember-- leaving feedback earns credits!
Total Pages
12 pages
Answer Key
Does not apply
Teaching Duration
1 Year
Report this Resource
Loading...
$5.00
Digital Download
More products from A Peach for the Teach
Product Thumbnail
$0.00
Product Thumbnail
$0.00
Product Thumbnail
$0.00
Product Thumbnail
$0.00
Product Thumbnail
$0.00
$5.00
Digital Download
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign up