Whoops! Something went wrong.

Click here to refresh the page
529 Downloads

7th Grade ELA Common Core Benchmark Grader/Analyzer

7th Grade ELA Common Core Benchmark Grader/Analyzer
7th Grade ELA Common Core Benchmark Grader/Analyzer
7th Grade ELA Common Core Benchmark Grader/Analyzer
7th Grade ELA Common Core Benchmark Grader/Analyzer
7th Grade ELA Common Core Benchmark Grader/Analyzer
7th Grade ELA Common Core Benchmark Grader/Analyzer
Grade Levels
Product Rating
3.9
3 ratings
File Type

Spreadsheet (Excel) File

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

454 KB|5 pages in excel
Share
Product Description
Use this Excel spreadsheet to grade and analyze four quarterly benchmarks and receive immediate feedback on student performance on individual standards, strands, and areas, not only for for that assessment, but also for the entire year to date.

Enter your key down the "answers" column (up to 54 questions per benchmark) and then code them under the appropriate benchmarks by typing "=Benchmark(1-4).(question number)" (So the third question on benchmark 1 would be =Benchmark1.3, while the fifteenth question on benchmark 4 would be =Benchmark4.15) Save, and then you're ready to enter student responses. (*see below for a more detailed explanation) The spreadsheet will automatically check for correct responses and distribute points (one per question) for you. If you want to hand grade selected questions or assign more than one point to a question, you can simply manually type in those points as students earn them into the appropriate columns. Make one copy of this spreadsheet for each student, and track progress all year long.

The ELA common core standards are color coded by area with pop-out descriptors for those that don't know what the codes stand for. If you need help using this product feel free to email me; I will be uploading a step-by-step how-to with screen caps later.

This spreadsheet was written for Office 2010 and was saved for earlier versions. If there are issues with how this works on your computer, please feel free to contact me. I will also be uploading an 8th grade version.

*Each row is one question. Scroll to the objective(s) that question addresses, and in that row and under that column, type the equal sign, the word benchmark, the number of the benchmark you're on (1-4), a period, and then the question number, all without spaces, and then hit enter. Question 5 for Benchmark 2 would be typed as =benchmark2.5 in the columns that match the standard it addresses. If you're not sure, hover over the codes, and a text box will tell you what that standard's text on the common core is.
Total Pages
5 pages in excel
Answer Key
N/A
Teaching Duration
N/A
Report this Resource
Loading...
FREE
Digital Download
More products from Caroline Askew
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
FREE
Digital Download
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