The chart is a line graph of student progress. The growth of each student is demonstrated in the line graph. Each line represents a student's test score during the second half of the testing period (tests 6 - 10). In order to extract the below data, I deleted every student that scored higher than the average (192). The below graph represents the students that fell below the average, and had their own average slightly above 170. In order to make the graph clear, I inputted the test scores and tests so that the graph was visually appealing and understandable.
As a teacher, although the scores are still below the class average, I would take into account that improvement has been made by the majority of the students, especially towards the end of the testing period. In order to get test scores up and above the average, I would partner these students with a student that was above the average so they could learn from their peers and review the questions that were missed by several in order to clarify confusion. Examining frequently missed questions demonstrates gaps in knowledge.
Spreadsheet
looks great. is the embed Dynamic (eg., if you change the data in your sheet, will the graph in here change automatically)?
ReplyDelete