Tracking Reading Growth with Line Graphs

In our PYP program, we use DIBELS to track student reading fluency. The first step is to create a table that includes the assessment dates and fluency scores, with a separate column for benchmark scores.

I conducted this experiment to see if I could create a graph that displays both fluency test results and benchmark scores on a single chart. By doing this, I aimed to visualize student progress more clearly.

In the table below, column A contains student names, and column B contains the assessment dates. I set it up this way so that I could easily use the FILTER function to sort or focus on specific students. The fluency scores and benchmark data are placed in separate columns.

To create a graph with two line charts, I ensured that the fluency and benchmark scores were in different columns. To make the lines continuous in the graph, I checked the "Plot null values" option. This step is crucial, as without it, the benchmark scores would only appear as isolated dots rather than a connected line.

AI used for editing.