You can enter your team number to send your score to mentors (see below).
This is a 19 question multiple [STRIKE]guess[/STRIKE] choice quiz.
You can take it an unlimited amount of times. Question order is randomized.
You are told what you get wrong but not the right answers.
You can instruct your students to take the quiz and enter their name and number on the first screen (this is optional)
You can then request a key for your team which will be emailed to you with instructions
Once you get a key, you can lookup data from your team. Instructions can be found here and will be included in the email with your key.
A favor to ask
The key system is not perfect. This is the honor system. Please be respectful and only request the key if you are the mentor for a team. Please do not redistribute the answers. If more than one key is requested for a team, both keys will be invalidated and you will need to contact me to reactivate them. If you really want security for your team, let me know and we can make you a private sheet.
Let me know. I know there are many other quizzes out there and some of them are great. This was already in the works so it will just be yet another option. Enjoy!
Love this scoring calculator!! Definitely super useful in quick changes during team discussions because how crazy different the game is this year in terms of the time variable. Another amazing resource 1836!
The scoring calculator I made a copy of appears to have an error I did not find in the live version. The “How many robots climbed” cell does not appear to be working correctly. Not a huge deal as the live one works.
I hate to be a pain in the butt, but, it only gives the option of 0 robots climbing. I’m sure I could mess around with the cell and fix it, but it’s such a great resource that I feel you want it perfect!
I’ve been playing with data validation a lot this year. Last year, an error message was spit out in an adjacent cell but now it doesn’t allow impossible situations (for the most part). Thanks for reporting.
Im starting to have issues with the spreadsheet updating. At least 2 students have come up to me this week saying they completed the test to our goal, even showing me their completed test with their name/team specified, but my spreadsheet hasnt updated in over 5 days. when i open the spreadsheet it shows its trying to update it (has a grey bar on the side thats loading) but it never changes. I went ahead and did one myself under the name “Testing the update of Google Sheets” and that one is also not appearing on the sheet.
Edit: Fixed by Jared in less than 30 minutes. Didn’t expect it to be that quick!