Student Assessment Data Reporting Tool for Teachers

Posted by Tom Mellish, Executive Director, IRTA on Nov 3, 2016 12:31:57 PM


We recently had conversations with two local elementary teachers and asked them: "What resources would be valuable to YOU in your classroom?" 

Their answer was surprising, at first.

"A way to report on student assessment data."

Upon reflection, their answer makes perfect sense. One of the most tedious and time consuming aspects of teaching is capturing, organizing and presenting student assessment data. 

Teachers are tasked with administering multiple assessments throughout the year. In Indiana, we use NWEA, ISTEP, I-READ, and other standardized tests. While standardized testing is surrounded by controversy, especially the status of the ISTEP test in Indiana, we realize that testing can be a valuable tool. Regardless, assessments are a part of our school system today.

How can we as teachers organize and present this data to our administration, parents and students in a way that is streamlined, efficient, and makes sense to everyone who needs to read the data?

We began with our teacher friends' basic spreadsheet that they currently use and added functionality that helps automate the process, and reduces extraneous manual entry and duplication of effort.

It is a basic spreadsheet, available here in Google Sheets (or download the Excel file). All data is entered on one tab, and the system generates a 1-page report for each student that displays the data in an easy-to-read report. 

Download the Free Student Assessment Data Reporting Tool Here

The spreadsheet can be customized with your own particular assessments, but it contains the basic tests that Indiana teachers use: NWEA, I-READ, ISTEP, among others.

Customize the student's names and enter scores on the DATA tab.

The names and data will appear on separate tabs as a report that can be downloaded or printed off as PDFs.

Here is an example of what the final report will look like for each student:

Student Assessments 2016-2017.xlsx - Student 1-426188-edited.jpg

Step 1: Read the instruction tab. It provides step-by-step instructions for using the spreadsheet and customizing or adding rows/tabs for more students.


Step 2: Customize the spreadsheet to include assessments particular to your class or school.


Step 3: Enter your students names, evaluations, test scores, and comments.


Step 4: Print sheets or save to PDF for printing later.

Test just sheet at first  before printing them all to make sure formatting is just right. Select as your layout: "Fit to Width" and "Portrait".


Please give us feedback on this tool, and we can continue to improve it for teachers in Indiana. Send us suggestions or let us know what's working or not working.

Download the Free Student Assessment Data Reporting Tool Here


Topics: Educator Resources

Subscribe to Email Updates