The following is a link to a spreadsheet created in education technology. It can be used to compare student's scores to the class average. This is a very useful tool. I created it in such a way that the first sheet is the raw data a teacher can change. When information is updated to the raw data, the second sheet automatically updates to the new raw data.
All of the below average students showed some improvement in their individual test scores. Some of the students showed much more improvement than others. A couple students hardly show any growth in their scores.
The names and scores in this spreadsheet were made up for viewing purposes of this spreadsheet only. They are not students and this particular spreadsheet does not contain any real information about students.
Here is the URL for the spreadsheet to view in a larger window:
http://spreadsheets.google.com/ccc?key=0AluIGppdYlabdGRjOGFvd0xWeEdjRmVlaXBOMDJJbHc&hl=en
Great start.
ReplyDeletePlease 'embed' the sheet (you're TAG).
Also, please take the time to actually analyze your results. Please read the directions carefully --- what are the Trends/Exceptions of the student growth of the students below the overall average.