I will demonstrate this, with an example for a fictitious course with three in-class sessions (with participation grading, 40% of grade), an individual written examination (30% of grade), and a group assignment (30%). I will show the various details of building the spreadsheet below – if you want to skip ahead and inspect the thing your self, I have made it available for downloading. I start with a spreadsheet of students and email addresses, provided to me by the administration or downloaded from our LMS. (In this example, the individual examination has six questions, of which the students should answer four.)įor the group project, I create a separate sheet (in the same workbook, called “Groups” Then I add columns for each of the assignments that I am going to grade: (If I have the time or can get the administration to create it from their databases, I ask to have first and last names in separate columns. The group sheet is exceptionally simple, just group number, points and comment. If you have several group assignments, this is where you will put them: Note that I also create a group numbered 0. With that done, I assign students to groups in the Students sheet… This is what I use for students who drop the course or don’t do the group assignment. …and then I am ready to start teaching my course.Īs the course rolls along, I enter points and comments for each student. As mentioned in the book, it is extremely important that you do the participation evaluation immediately after each class. I tend to give the students a score of 1-3, sometimes 1-6, with some definition. As I will show later, what scale you use does not really matter, as you can normalize them to whatever you want later in the process.Īnyway, assume the course is finished, and you have entered comments and points for everything – for the individual student, in the Student sheet….
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |