Counseling Lesson Data Collection Spreadsheet for School Counselors

Use this Google Sheet to collect data on any lesson or lesson unit! All you have to do is put in your lesson’s raw data and the form will automatically calculate averages, percent change, and generate graphs in a striking data report. With minimal time you can create professional reports for your stakeholders to advocate for your school counseling program. You don’t need to know how to do anything fancy in spreadsheets - I’ve already done all the coding for you!

Download includes:

• Spreadsheet to collect participation, mindset & behavior, and outcome data.
• Spreadsheet generates a professional data report
• Instructional guide with video demonstrations
• Sample spreadsheet completely filled in for you to view
• Troubleshooting form to contact me with any issues or questions you may have*

Limitations of this spreadsheet:

• The spreadsheet collects data for one lesson or unit of lessons. To use it for another lesson or unit, simply click the download button again to get a fresh copy.
• This is a single use license for use by one counselor or individual to collect data on lessons that they taught or co-taught. If other counselors or individuals at your school or district plan to use it, please purchase additional licenses at a discount.
• Designed to collect data on lessons with an unlimited number of students.
• Pre and post assessments may have up to 10 questions using a likert scale with up to 6 response options and/or questions that have a right or wrong answer.
• Collects and reports data for up to 3 types of outcome data.

Other Data Tools from Gatewood School Counseling:

• Group Counseling Data Collection
• Individual Counseling Data Collection
• SMART Program Goals Data Collection

*Troubleshooting form is for questions or problems regarding the spreadsheet as it was made and intended for use. It does not allow you to make special requests or customizations to the original download.