Analyzing Student Data in a Spreadsheet

Typically, I'm comfortable using Excel style spreadsheets. Going into the assignment I felt fairly comfortable, until it came to creating the charts. I had difficulty creating charts and customizing them to fit my needs. Overall, these charts are fairly simple to understand. I tried to create three charts that were easy to look at and get the big picture of where the growth of the students was at. My charts were made to be clearly presented by using bright, contrasting colors in order to be reader friendly. Here is my completed Student Data Spreadsheet

Analysis: Based off the information in the link and charts above, the student growth was substantial. The greatest amount of growth shown was in the pre-test vs post-test. This would be positive for a teacher to observe, however, it should be noted that over the three formative assessments, the students who performed well on assessment one, typically performed well on assessments two and three. There were a couple of cases that students regressed and received lower scores on assessments two and three. Overall, the percent of growth was substantial. Only one student did not see growth from the pre-test to the post-test.