This is a simple line graph to show student progress. The students growth is demonstrated as the tests progress. The chart is depicting the second half of the testing period tests (6-10). Students that had an average higher than 192 are not represented, as I wanted to show the average that was just below 170 collectively. As you can see most students had an overall improvement trend, but there were those with peaks and valleys.
What I see in this graph is a lack of consistency. I want to reverse this as quick as possible. I would like to see test scores that are a bit more steady rather than big peaks and valleys. This may be because of the material presented during the unit that this graph represents, and I recommend some more individual attention from the teacher to spot weaknesses or gaps in the students comprehension.
Using this kind of data in a classroom setting can be very important in terms of the ease at which it can be created and its visual appeal. It clearly depicts the activity of the scores in a way that students can grasp. I think in order to arrive at a more uniform upward trend in scores I would recommend smaller group work or group work, say five students to one teacher, really digging into the subject matter to create better comprehension. Being able to see the data so clearly represented can do wonders for motivation.
My experience with Google Sheets was fantastic. It was easy to navigate through and the embedding of the sheet in this blog was very clear. I was thinking about how to use this in a musical application and feel that when I touch on the more academic side of music learning this kind of graph and spreadsheet could be very useful. For example, test scores for some of the music theory that we will cover; the analyzing of Bach Chorales or mad minute key signatures. The students could log on and see their over all trend during the semester or quarter, and it would give them a great barometer of where they were and what they needed to do!
Here is a link to the raw data
This comment has been removed by the author.
ReplyDeleteYou're 90% of the way there. Appreciated the potential apps in the classroom.
ReplyDeleteSuggestions to strengthen this presentation:
1- please re-read the latter part of the instructions that request you put on your 'teach hat' and ANALYZE the data and chart.
2- consider changing the VERTICAL dimensions of the embed so one doesn't have to vertical scroll as much (and can see more data/chart)
3- The X-asix (Horizontal) needs to be more specific. "tests" is general, but one needs to see Test 6, Test 7, etc.
I'd like to share this in class.