Whoops! Something went wrong.

Click here to refresh the page

Quarterly Assessment Data Collection Tool

Grade Levels
Product Rating
2 ratings
File Type

Spreadsheet (Excel) File

Be sure that you have an application to open this file type before downloading and/or purchasing.

202 KB|7 pages
Product Description
Quickly and easily create quarterly reporting sheets for up to 50 students and 41 questions. Question’s answers can range from A-E and 1-6 points, include 1 of 14 Common Core Aligned categories and a difficulty level of 1-3. Worksheets are dynamic based on question answers and types. Reporting tool creates a printer friendly reports for individual students and allows for easy comparison to entire class performance.

How to use:
So the workbook can be used more than once, save an original copy and save the copy you will be working with under a different name.

On the first sheet (Tests), enter your last name, make any adjustments to the categories you would like (category name and abbreviations) but do not change the answer key. Select an answer, category and type for each question. You can also make adjustments to the Detailed Template sheet but any data added to the yellow or blue cells will be lost when the quarterly sheets are created. Click the Create Quarters button on the Tests sheet. The Tests and Detailed Template sheets will be hidden and a Reporting sheet as well as 4 custom quarterly sheets will be build based on the data you entered on the Tests sheet and modifications to the Detailed Template sheet.

Select the sheet for the quarter being completed. Enter all student names (required) and Student IDs (optional) starting in cell A7. Select the student answer for each question or points earned. Answer dropdown lists are dynamic based on question. Quarterly sheets provide basic reporting by student and question.

After at least one students information has been entered, click on the Reporting tab (if no student data has been entered an error will be displayed). Select a student name from the dropdown list in cell D2. This is dynamic and is based on the student names across all quarterly sheets. Students name will only appear once. Click the Run Report button. Student and class data will be generated. To generate a report for another student, choose that students name and click the Run Report button. Report has been sized to print to one landscape page
Total Pages
Answer Key
Teaching Duration
Report Copyright Infringement
  • Comments & Ratings
  • Product Q & A
Digital Download
Download Now



Digital Download
Download Now
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign up