Link - https://docs.google.com/spreadsheets/d/1tm29YjgE7euKYMYR7dTBxp8fKegpk-HtHz_pA3NTXa8/edit?usp=sharing
I had a VERY difficult time working on this section of Google Apps and have worked with it for many hours. I was not able to fully complete these two parts because I honestly just didn't understand it or how to do it. I got assistance from my husband, who has experience in business with Exel, but he was unable to help me get the formulas to work. When we tried to get a percentage, we got true/false instead. I found this to be exceptionally hard for someone who had no experience at all with anything like this. I can see how this would be beneficial to use in the classroom if you could get it to work. I am sure many others can, but without no formal training and only a few videos that move quickly. I couldn't. I had no problems setting up the quiz and linking it to a spreadsheet. It just wouldn't work for getting the grades in the second sheet.
This would align with common core in several ways. First, the teacher can use the quizzes to assess for understanding of what is being taught. It would work for pretty much all standards and content areas. All content needs some form of assessment and this would be a wonderful way to assess and students would find it easy and they would not be as fearful as facing a formal test. I would like to explore to see if their was a function that would allow for limiting time on the quizzes as it would be easy for student to use open books.
No comments:
Post a Comment