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.
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.