Many of us have used ABC (antecedent, behavior, and consequence) data sheets to collect data on students' problem behaviors in order to get more information about the function(s) of those behaviors in order to inform our interventions. However, there are rarely methods of analyzing this data as there are with more quantitative data collection methods... until now!
Page 1 of this excel document is an updated form of a general ABC data sheet. Print several copies of this page in order to take your pencil/paper data. Choose 1-3 problem behaviors to collect data and make sure to write very clear and objective definitions beforehand! Then use pages 2, 3, 5, and 7 to input your data from these sheets. Shaded cells will fill in automatically (reducing the amount of math calculations needed from you!), in order to output graphs that are helpful for identifying behavioral functions and present at FBA/BIP meetings.
This is a very helpful resource, especially if you have several general education teachers or para-educators who are collecting data for you, as ABC data is easy to explain and hard to do incorrectly. You then have plenty of reliable data that you can take from multiple sources, and analyze in a qualitative way.