Here is the only data collecting tool you need! It's easy to use, yet provides a sophisticated analysis of student growth.
Welcome hard-working and over-stressed professional educator who rarely has (or is given) sufficient time to complete your teaching and testing responsibilities within designated time-frames! You are not alone. SLO’s and other growth data collecting tools are here to stay. This spreadsheet will make the process easier.
We’ve put in the time and effort so you won’t have to! All you have to do is enter student names, growth criteria, and scores for a pre-test and post-test. The Spreadsheet then performs all of the calculations quickly and effortlessly in the background. The Spreadsheet automatically calculates the number of students taking both tests, automatically sets the targeted growth percentage for each student depending on their initial scoring in the pre-test and the applicable growth criteria, automatically calculates percentage differences between the two tests, and automatically color-codes each student’s comparison results depending on whether they:
a).met or exceeded their targeted growth percentage from Eval #1 to Eval #2-
b).did not meet their targeted growth percentage on Eval #2 but at least scored as well as they did on Eval #1- Gray Shading or
c).scored lower on Eval #2 then they did on Eval #1- Red Shading
The Spreadsheet also summarizes for the teacher the total number of students scoring in each of the three above-listed categories as well as provides overall percentages for each category for all students taking both tests.
The Zip file includes:
Quick-Start Instructions- provided for those already familiar with Excel© (or even Google Sheets©).
Step-by-Step Instructions- provided for those just starting out with a spreadsheet program like Excel© or Google Sheets©. Reading these instructions may even help you learn some basics about these types of programs.
Excel Template- reusable and adjustable
At $2.99, we think you will find this spreadsheet an extremely helpful and time-saving bargain.