Welcome to Modern Educator

Here on this blog I hope to get a conversation going amongst students, teachers, administrators, and parents about who, what, when, why, and where we should teach technology skills for the 21st century. I am technology teacher at Truckee High School in Truckee, CA and currently teach classes like digital media, e-learning, applications, and keyboarding -- yes...still important! :) Please Join the Conversation!

Tuesday, October 15, 2013

Google Spreadsheet Assessment

Today I'm giving my first Google Spreadsheet assessment.  Students received a Google Document with directions and questions to complete.  There is also a set of data that they have to produce a data table with on a new Google Spreadsheet and perform various calculations.  They will also produce two charts to display their results.

Unfortunately, I do not think this assessment will save me any grading time versus my previous assessment using MS Excel when students sent me an email with two attached files since I will still have to open up two Google shared files to grade each students work.  I think next time I need to explore putting the questions into a Google Form.  However, that eliminates other skill assessments from the test like opening shared files, making editable copies, and sharing documents.  Let me know if you have any ideas on how to best assess this type of student learning with Google so that it provides a valuable learning experience and is efficient as possible for the instructor providing student feedback.

No comments:

Post a Comment

Thanks for joining in on our conversation!