For Any Grade Other (Specialty) Assessment

ACCESS test scores data tracker for Google Sheets

By TamiaDesigns

Easily monitor and analyze your students' WIDA ACCESS scores with this user-friendly Google Sheets template, designed to track both group and individual student progress. This powerful tool, created based on my years of experience working with ACCESS test scores, provides clear visualizations and detailed performance insights. Track scores for all students in one place, while also viewing detailed data for each individual student’s performance. Visualize student progress over time with automatically generated bar graphs, highlighting trends in language proficiency across the four domains (Listening, Speaking, Reading, and Writing). Dynamic checkboxes automatically update based on student progress towards specific goals such as a state-issued target score, a minimum required literacy score, or a minimum score to exit EL status. The percentage of students achieving these goals is also calculated automatically, with minimal effort on your part.

Also included is recording of the number of service minutes (push-in or pullout) that each student receives. I've used this in the past to justify the minutes of service (more or less) for students the following year, and even to advocate for the hiring of another EL teacher when I could clearly demonstrate that a reduction in minutes of support was leading to failure to make progress. There are also checkboxes to identify which students are on IEPs or 504 plans.

The file is currently set up with the required exit scores in Massachusetts, as that is where I work, but you can quickly and easily change those to your state's standards.

I have also included other Massachussetts-specific templates that have space to record MCAS scores. In Massachusetts we are also required to have student success plans for students who do not reach their state-assigned target on the ACCESS test. The state does not have a specific format that they require for the student success plans. The one I've included here is one that I have used and the state has been happy with it. Whether your state requires them or not, I think student success plans are a good idea for any student who is making slow or no progress on ACCESS.

This tracker is perfect for EL coordinators, teachers, and administrators focused on making data-driven decisions to improve student outcomes! All the sheets are printable. The individual student records are ideal for focusing conversations with students about their progress.

I cannot be your Google Sheets tech support person, but I have set the file up to be as automated as I can make it. For example, all the check boxes are triggered automatically. The file also comes with several pages of explanations.

Please note: 1) this file will NOT work in Excel and 2) I am not affiliated with WIDA in any way.

You will receive a PDF with a link to make your own copy of the file.

Terms of use:

Purchasing this product grants permission for use by ONE teacher or administrator. If you have colleagues who would like to use this file, please respect the huge amount of time I have put into making this for you and direct them to my store to buy their own copy! Thank you!

$10.00