Data Project Checkpoint
Data Project Checkpoint

Data Project Checkpoint

Virginia’s Reading Report Card, 4th Grade

This is a line chart showing that the Virginia reading scores of 4th graders increased from 1992-2019, then decreased from 2019-2003
Chart showing Trend in Virginia Reading Scores. Data from The Nation’s Report Card

Trend

Overall, although the rate of 4th-grade children reading at the basic level was increasing from 1998 to 2019, it has declined from 2019 to 2022. The rate of 4th-grade children reading at the proficient level, which is 238, is significantly lower in 2022 than five years ago.

Process to Identify the Trend

I exported reading score data from The Nation’s Report Card into Excel. The data was collected at four different points in time between 1992 and 2002. It reports on the average score and the reading score percentiles of 4th graders from all 50 states, per collection year. I created a Pivot Table to show the average score per year for only Virginia. For 1992, some states did not collect data so I had to clean up this data before creating the Pivot Table. This is the data that I used to create my chart.

Data Link

The Nation’s Report Card

Spreadsheet and Table Link

The nations report card.xlsx

Leave a Reply

Your email address will not be published. Required fields are marked *