Below is a link to an interactive worksheet designed to help convert pre- and post-test scores into an overall growth percentage.

SLO growth calculation worksheet

1. Rename the file once you make a copy

2. Complete the following columns on the spreadsheet:

• Last Name
• First name
• Pre-Test Score
• Goal
• Post-Test Score

- Goal Met, column "G" will automatically be filled in based on the date for each student.
- The 90% column will exclude students who do not meet that standard from the overall growth calculation.
- Use the tabs at the bottom of the spreadsheet to view graphs based on the data you submit.

View a sample completed spreadsheet

Thank you to Brenda Grahn and her husband for applying wizard-level Excel skills to the SLO Growth challenge.