Pretend Data Analysis in Google Sheets

Google Spreadsheet is never a quick and easy proposition for me to navigate. I managed to muddle through it again, but it took me over two hours to make my tables and graph look good. I followed instructions, copying and pasting and separating my sheets, and watched the tutorial so I could remember how to do simple things like finding the averages. I hid columns C-G since they were unnecessary in the original data sheet, but in the 'Below Average' data sheet, I deleted them entirely because the graph was doing strange things, and it seemed to be seeing them. Interestingly enough, embedding the sheets was the easiest part for me. Through much determination, and many views of Tony and Denise's examples, my final charts and graph are below:



I can see how these data sheets would be very useful for analyzing how well my class is doing later in the year. I can look at both the individual, as well as the overall growth trend. I can look at Walter, and notice that he improved the least, but he at least brought himself up from where he was with his last test score. I can look at Renee's progress, and see that, even though she started with one of the lowest scores, she improved with each test. I can also look at Katherine, and wonder what happened, and perhaps go back and review her tests to see why she did so well on Test 7, and then plummeted down again on Test 8, never fully recovering. The statistical anomalies are much more apparent when the scores are all graphed out. My originals can be seen here.