spread sheet assignment.

The first sheet you see is just my practice sheet where I worked with numbers and formulas to get myself familiar with Google sheets.  The second is the chart that I used to graph all of those numbers.  Again, it was just to get myself familiar with the program and everything that I would need to use for the assignment.

The chart with all of the students should be the next sheet.  This has all of the students listed by their averaged scored of Tests 6-10.  The students with the lowest scores are at the top, and then it goes in chronological order to the bottom.  The row below all of the students is the average score for each test.  A few rows below the last chart is the average score for every score on tests 6-10.

The next sheet is a table of all the students whose average is below the average of all the scores for the tests.  In other words, every students who has an average below 191.92 is listed on this sheet.  This spread sheet is helpful when looking at the growth of students over the last 5 tests.  When analyzing the students that have not achieved the class average, it is important to look at their scores and see if they have gotten better scores on each test they take.  If their scores have been raised every time, then you know that they are making progress and that your teaching methods are making sense to them.  If they are not raising their score every time, then you know that you have to adjust your methods with them.

The last sheet is just a bar graph of all of the students who fall below the class average.  It is charting their score on each test.  This is a good way to visually see the trends of each student.

click to go to my actual spread sheet!