End of Term Tip: Use a Google Spreadsheet for Student Evaluation

The end of the term brings the all-important task of student evaluation. Ideally, all the teachers on a team should participate in evaluating each student and deciding whether the student should advance. But with people’s busy schedules, it’s often hard to get teams together to do this. Fortunately, there’s another way!

This term, the co-leaders of my 3A team, Kiyana Allen and Clare Bresnahan, set up a Google spreadsheet and gave all of us access. We typed our assessment of each student right into the spreadsheet in the comfort of our homes. With everybody’s input, Kiyana and Clare will average the ratings and transfer the final assessments to the student checklists. What a great idea!

Below Kiyana shares step-by-step instructions for creating a Google spreadsheet for your class.

1. Go to http://docs.google.com. This will prompt you to sign in. If you have a Gmail account, you can use it. If not, follow the instructions to create a Google account.

2. On the left-hand side, go to “Create New” and click on “Spreadsheet.” This opens a blank spreadsheet.

3. Save the document by clicking Save Now in the top-right corner. You need to choose a title, such as Spring_2011_Eval.

4. In column A on the far left, list each of the students in your class. Under each name, create a row for each day or night of the week that your class meets. This enables each set of teachers to enter their ratings for each student. In the case of our PM class, which meets four times a week, there are separate rows for Monday, Tuesday, Wednesday, and Thursday. Classes that meet two days a week (morning and weekend classes) would have just two rows, labeled with those days.

5. Across the top, create seven column headers: attendance, participation, reading, writing, speaking, listening, and comments. Teachers will enter ratings of “excellent,” “good,” “fair,” or “needs improvement” in each student’s row under each of the skills, with comments in the last column.

6. To share the document, click on Share in the top-right corner. Then enter each teacher’s e-mail address. Next to the e-mail will be a drop-down box that controls the level of access. Make sure to set this to “can edit” so everyone can enter their info.

7. Once the teachers for each day have entered their assessments, the team leader can use the ratings to fill out the classroom checklists for students. The final assessment for each student should reflect the average of each night’s ratings.

A sample evaluation spreadsheet. The screenshot came out kind of meh (sorry), but you can click on it for a larger view. The student names are, obviously, fictional.

This entry was posted in Teaching Tips & Resources. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s