You are here

Coherence Gap Spreadsheet

Coherence Gap Spreadsheet

New! Coherence Gap Workshops

The school year is wrapping up and while you worked hard and covered a lot of content, you didn't get to all the topics you wanted to. What's that going to mean for next year?

The Coherence Gap Spreadsheet is designed to help you answer that question. To help you get started, please register for and join one of the upcoming workshops:

The Coherence Map from Student Achievement Partners is one of the most powerful tools a math teacher can use to better understand their academic standards and how they form coherent progressions of learning over time. But one thing the coherence map doesn't do is give the user any indication of how many lessons or how many hours it takes for students to learn the content described by each standard.

In a perfect world, teachers and students would have all the time necessary to reach all the goals described by the standards. In reality, this rarely happens—students have absences, explanations get rushed, homework goes unfinished, and severe weather and pandemics can close school buildings entirely. This is when having instructional time estimates for each standard can be useful, both for future curriculum planning or understanding the potential consequences of instruction already lost.

The Coherence Gap Spreadsheet was developed in 2020 to help teachers and schools make more informed curricular decisions. This tool doesn't make decisions for an educator but rather relies on the educator's understanding of the standards and horizon content knowledge to use feedback from the spreadsheet to make better decisions. Before using the spreadsheet, users should watch this tutorial video as well as read the "README" sheet, which is the first sheet in the Excel workbook. If you have questions about using the spreadsheet or interpreting your results, please contact Raymond Johnson.

For further assistance, please contact:

Raymond Johnson, Ph.D.
Mathematics Content Specialist
P 303.866.6582