To the many inspiring, dedicated educators who join the #aussieED chats from the US (at the craziest hours), I wanted to throw something your way. I hope it can be of some use to you and your colleagues.

The Interactive Assessment Grid is now available for all of the US Common Core State Standards.

This is an interactive assessment grid in the form of an Excel spreadsheet with all Common Core State Standards for English Language Arts & Literacy in History/Social Studies, Science, and Technical Subjects as well as Mathematics! You can use it to mark your students and investigate the entire Common Core State Standards.

The assessment grid has been made to be easy to use and navigate. Using the filters in different combinations will help you to develop a deeper understanding of the Common Core. It can also give you a better overview of your students’ strengths and needs.

Click below to be taken to the download page.

Download Common Core Interactive Assessment Grid

Features

Add up to 35 students for assessment purposes.

ss1

Double click cells to mark students

ss2

Mark multiple students and outcomes with a simple select and click interface

ss3

Available marks: “little understanding”, “some understanding”, “full understanding” and “no data”.

Capture

ss4

Display controls include full width, 100% zoom, distraction-free full screen interface, regular Excel view mode and a scroll bar for zooming.

ss5

Filter by years (K-12), domains, clusters, standard points, standards and more.

ss6

Extra Information + Disclaimer

When you first open the file, security warning may show. Click Enable Editing and Enable Content buttons to begin. If you don’t do this, the macros cannot run. This will mean that the marking interface and buttons will not work. Other functions such as filtering and colours will still work. There are no malicious scripts in the macros. I coded them myself.

11

1

The spreadsheet has been tested with Windows 7 and Windows 10 running Microsoft Excel 2010 and 2013. It should work with Mac OS X running Excel for Mac but I haven’t been able to test it yet.

As always, backup often. If you choose to use this to hold your students’ assessment data, backup in multiple places to a physical storage device and to the cloud or server in a different physical location. Also, I’m a teacher, not a programmer. I make no guarantees for anything!

Use your professional judgment as to how or whether to use this assessment tool. You are given the option of selecting from three levels of understanding for each elaboration. You know that’s only part of the assessment story.

Lastly, feedback is very welcome. I hope you get plenty of benefit from it!

Download Common Core Interactive Assessment Grid

Assessment grid design and assessment entry system © 2016 Rob McTaggart
The data here is ported from the following page of Common Core standards:
https://www.learnboost.com/common-core
Copyright (c) 2010 LearnBoost <dev@learnboost.com>
THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
THE SOFTWARE.
For more information or to download PDF versions of the Common Core State Standards, please visit: www.corestandards.org 
© Copyright 2010. National Governors Association Center for Best Practices and Council of Chief State School Officers. All rights reserved.
You can find the latest version of this spreadsheet on the following website:
Common Core Interactive Assessment Grid


            
								

About The Author

Primary Technologies Teacher
Google+

Rob McTaggart teaches Technologies from K-6 in Newcastle, Australia. He is co-founder of the Digital Sparks regional student technology design challenge & expo.
Rob is a Google for Education Certified Innovator who loves to help students to engage and create with the world using technology. He developed the RAPID Design framework to support students and teachers in these aims.
Rob is a moderator for #aussieED and plays a logistics role for the team, managing the website and various channels. He is an ambassador and teacher trainer for Code Club Australia and runs a local Code Club for his students.
His main gig is teaching 550 amazing kids every week which makes him a very lucky teacher!

Related Posts

Leave a Reply

Your email address will not be published.