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.
Add up to 35 students for assessment purposes.
Double click cells to mark students
Mark multiple students and outcomes with a simple select and click interface
Available marks: “little understanding”, “some understanding”, “full understanding” and “no data”.
Display controls include full width, 100% zoom, distraction-free full screen interface, regular Excel view mode and a scroll bar for zooming.
Filter by years (K-12), domains, clusters, standard points, standards and more.
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.
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!
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 <firstname.lastname@example.org>
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: