Here you have a link to an excel spreadsheet with a grading system for a class. I have considered six items: creating a wiki, creating a story with Story Jumper, reading, listening, speaking and writing.
These are the scores of each item:
-Wiki: 13%
-Story Jumper: 13%
-Reading: 15%
-Listening: 20%
-Speaking: 25%
-Writing: 14%
I have chosen these scores because I speaking and listening are the most important skills due to the fact that these are the skills used in a conversation. The rest of the skills are less important but also have to be taken into account when grading your students.
Besides, I have also included two graphs, one indicates the percentage of every skill, and the other one the average of the students in each skill and the total average. I have done it in a way so that if I decide to change a percentage, this automatically changes in all the frames and graphs.
Although it is difficult for me to understand xcell spreadsheets, I have learnt many things by looking at tutorials on the Internet. That is why I encourage all the teachers to use this device and all its options.
No comments:
Post a Comment