Want a way to show growth on your students' SAGE test? Look no further! This Excel document is complete with all the formulas you need to calculate your students' growth. All you need to do is input their last year scores and current scores (or interim to summative scores). This is a fantastic way to see improvement in addition to the 1, 2, 3, or 4 grading. Within the Excel document there are two tabs-one for ELA and and one for Math. There are tables to calculate the effect size of each of the reporting categories within each test (Overall Score, Reading Literature, Reading Informational, Listening Comprehension, Writing, Language) (Overall Score, Operations and Algebraic Thinking, Number and Operations in Base 10, Number and Operations-Fractions, Measurement and Data & Geometry).
The formulas are based on John Hattie's research on Effect Size. The formula calculates the average standard deviation. His research states that 0.4 is one year's growth. Therefore anything less than 0.4 is less than a year's growth and anything greater than 0.4 is greater than a year's growth.
This product includes instructions on how to use the spreadsheet and find the information on the SAGE Portal. It also includes the spreadsheet for you to input your data. Because the formula deals with averages, the number of students you have is important. Included in the product are 11 separate spreadsheets already calculated for different class sizes. I included spreadsheets for class sizes of 20 students-30 students. Feel free to reach out to me if you need a spreadsheet with more than 30 students.
This is the best way I have found to document growth on the SAGE test. I also like to use this to show students how much they grew in each section. *Scores shown were made up and do not reflect real students scores.*
Thumbnail Background thanks to: Cutesy Clickables
Graphics thanks to Lisa Glanz