All grade levels have been update with the most recent cut points based on September 2016 revisions. The Error column in the previous version has changed to ACC (accuracy). A column for composite score has been added. This spreadsheet does NOT calculate composite score. It only color codes the composite score column based on cut points. Please reference:
for how to manually calculate composite scores.
This is an excel spreadsheet for DIBELS Next for K-5. There are three premade tabs for each grade level. The spreadsheet is set so you can enter student names and scores. Each cell color codes the score you input for that subtest(red, yellow, green). The dates can be changed to fit current year. It includes sections for beginning, middle, and end of year benchmarks and progress monitoring. The cells for progress monitoring are specific subtests that my school uses throughout the year. If you choose to use different subtests for progress monitoring different from the ones on the spreadsheet you would have to change the "what if" formulas for that subtest/column under conditional formatting - manage rules.
Note: The slash marks must stay in place for cells that do not have a score. If you leave the cell blank the formula reads a blank cell as a score of 0. If you feel uncomfortable with excel and formulas I would recommend downloading my other version of this spread sheet that does not have formulas. That way you can just input numbers and change columns without worry of messing up a formula. A final note, if you choose to add a column and the column to the left of where you are adding has a formula that columns formula will be in the new column. You can delete the formula out of a column by highlighting the cells you do not want to have the formula, going to conditional formatting, choosing clear rules, and clear rules from selected cells.