Analyzing Student Data in a Spreadsheet

Original Data
Data Averages (Test 6-10)

Students with Above Average Test Scores

Students with Below Average Test Scores

After completing the data analysis on an excel worksheet, I quickly discovered that the excel format needs to be specifically formatted to each specific destination. While this is of course possible, it makes the task of embedding, while maintaining function and formatting time prohibitive. As a result, though this is a useful tool individually, I feel that spreadsheets need to be created in their final destination. While excel is a very useful program when installed on a computer, the many versions make it a compatibility nightmare. Looking back I wish that I would have used google spreadsheet for this particular assignment. Live and learn.

The results of the data collection were clear upon graphing the information. Students who scored below average on tests 6-10 showed the same upward trend in grade improvement when compare to the rest of the class. This shows that although they fall below the class average, they are improving at roughly the same rate as the rest of the class.

The student's cumulative average and the total class test average both equated to the same value. This of course makes sense because they are ultimately measuring the same value sets, averaged from different ends.

The hide function is especially useful in analyzing specific portions of the test year, while maintaining the ability to quickly access the cumulative data for each student. It is also important to note that averages can be calculated with specific data set to either zero or null. Since these will give you much different results, it is therefore important to mindfully enter data, so as to not over or underscore the student.