Working in Google spreadsheet with this data set was really quite easy. Copying and pasting the raw data into a new document, using the provided formulas to create the averages for each student and test as well as the overall average of test scores was the brunt of the work required for this assignment. The one place that i did get caught was trying to get both the graph and the data sheet to embed into my blog so that they were both completely viewable all in one screen, i definitely need to work on fixing dimensions when embedding.
The data set and graph that you see above is the progression of student scores for tests 6-10 for the students who scored below the overall class average score of tests 6-10, which was 191.9. Just by viewing the graph you can see a steady incline in these scores from test 6 to test 10. With the exception of Hepburn's test 7 score, just about everyone increased their scores steadily with each exam.
Job well done! Glad the project went smooth for you.
ReplyDelete