Cut Your Grading Time in Half with Automated Rubrics

[@zairaashraf2372]

This is fantastic. Please keep the content coming. I am a trainee teacher so this is really useful.

[@edtechii]

Hello Zaira Ashraf, thank you for your positive comment. I am glad you find the content useful. I try to publish on a weekly basis. Is there anything in particular you would like to learn?

[@witkamashele3538]

I would like to convert the total 16 to 30, how do insert the formula?

[@ColetteWaddell]

This was amazing. I am already implementing this into so many aspects of my professional and personal life

[@edtechii]

Excellent - happy to help!

[@liamboshoff1232]

Thank you for this! It has changed my life!

[@edtechii]

Glad I could help!

[@prshntkumar0000]

Thanks, your video helped me to understand it clearly.

[@edtechii]

You are welcome!

[@augustinesayi9506]

This content will make me a greater teacher

[@edtechii]

Thanks for the comment! Sure it will :)

[@mss81]

Superb! This is what I am looking for.

[@edtechii]

Glad it was helpful!

[@kristiburtner75]

This was great - thank you so much! I would love to know if you have a video that shows how to summarize multiple rubrics or put them into a summary? Thank you

[@edtechii]

Sure, if you browse the templates in the folder, you will probaby find what you need.

[@witkamashele3538]

Fantastic, my essay grading will be much easier and quicker to complete loads of learners papers. thank you.

[@edtechii]

Hello Witka, thanks for your taking your time to leave a comment - happy to see the tutorial was helpful. Have a wonderful day.

[@witkamashele3538]

How do i convert 16 to 30 instead of 100%

[@edtechii]

@@witkamashele3538 Hey, can you send me a link to your rubric you are working on?

[@ramondevera7977]

thank you, this is really helpful! saves me a lot of time

[@edtechii]

Wonderfull, enjoy it :)

[@elizabethwebb673]

Very helpful! Thank you so much for sharing!

[@edtechii]

No worries!

[@victorias.j.6219]

Thank you so much for this video! It helped me a lot😄

[@edtechii]

You're so welcome!

[@FH-on6em]

Super helpful 🎉🎉

[@edtechii]

Thanks!

[@ruthmae-yz5ul]

Excellent tutorial. I clicked on the link to get the template but it only has a slide presentation and a video presentation. No template.???

[@edtechii]

There is a folder with templates. Got it?

[@lasinverguenza2762]

Great!! Thank you so much!

[@edtechii]

Welcome! Thanks for subscribing.

[@bobbonus4390]

Bring on AI, to actually read the submissions and do the clicking for you. You can feed AI the rubric and it will go from there, results can be tabulated and you can simply copy paste to reports. Why you may ask is this a step up? The AI is much more accurate as it does not mark relatively to other work and marks each submission independently according to the rubric, whereas teachers will tend to base their grades relative to previously marked work and overall this results in under marking. As long as the prompt is written expertly, it should feature your own rules of thumb when the mark criteria is subjective and even draw on the expected learning outcome of the question. I know that some of the best PD s to be an examiner and marker, but you can still do this and in designing the prompt you will gain a full understanding of the examination standards.

[@edtechii]

Good points. How does your school feel about sharing students work with the AI?

[@omamiwininikwe9414]

Hello Thanks for the great tutorial. I did create a rubric for this but cannot seem o get the final percentage aspect to work correctly in the formula. Everything is great for the five criteria on the rubric and the points for each 4-1 on the rubric. The formula works for each column to add the correct amount until I add the total percentage at the end. After that it is no longer correct and seems to make it out of 100 even though the total is only 20. I did input * 100/20 but it is not working correctly.

[@edtechii]

Could you make a copy of your sheet and share it with me, so I can check it out? My email is in the about section of the channel.

[@bodylanguage70]

this is AMAZING.

[@edtechii]

Thanks.

[@hamfizahhakim2156]

Thank you very much for this really brilliant tutorial. I am interested to try but the link for the template is not working. May I ask you a favor to share the working link. Many thanks in advance.

[@edtechii]

Could you try this link, please: bit.ly/Automated_Rubrics_Templates

[@hamfizahhakim2156]

@@edtechii , Thank you very much. Really appreciate it. Regards from Malaysia

[@ferlyndafj559]

Thank you for the wonderful share! Is it possible to protect the same range, in a different tabs in one sheet ? I'm trying to use this rubric for a deliberation process for 300 projects. For each sheet, we will have 30 tabs. I have applied protect range in the first tab and duplicate it, but the protect feature is disabled in the new tab.

[@edtechii]

Hello Ferlynda, thanks for your question. I've not worked with protect range feature before. What does it do? And what are you trying to accomplish with it?

[@ferlyndafj559]

@@edtechii it protects certain cells from being edited. Since multiple people are working with multiple tabs, we want to make sure they don't overwrite the content (student name, project etc) and only have access to the checkbox cell. That's what I'm trying to accomplish. Hopefully I get to find the solution to it, or else, I guess I just need to apply the protect range feature for each tab after duplicating it.

[@ferlyndafj559]

May I also ask, if there is a way to collect all the marks calculated in different tabs, in one place ?

[@edtechii]

@@ferlyndafj559 Yes, you can collect gather data from various tabs in one cell. That's what I've done in student list (1st tab): it collects scores from other tabs. 1. Choose a cell where you want the aggravated score to appear. 2. Start a formula with "=" 3. Then go through the tabs and click on the cells that you want to add. Separate each cell with "+" sign 4. Click "Enter" Let me know if this worked for you.

[@edtechii]

@@ferlyndafj559 Got it. I've not worked with this feature yet.

[@georgeotoole2768]

In terms of sharing with students, could you not create your assignment in GC and attach whatever files for the students and also this Sheets Rubric and select "make a copy for each student", then when you are ready to grade each student by assignment they have their own copy of the rubric which you can score and return? I guess also if this was more generic and a running total (say for learning skills), you could duplicate each tab and add the student name(s) and publish each sheet individually to the web and share the link with the student and they can track their progress (and no others) in real time at any point over the course of the semester or year.

[@edtechii]

Hello George, thanks for your questions and suggestions. With regard to sharing a rubric with the students by making a separate copy for each student - the problem with this method is that when you make a copy for each student in Google Classroom Assignment, students are given editing permission and then can therefore change the score. When it comes to creating a separate sheet for each student, yes this works. The initial set up is a bit time-consuming i.e. creating a comprehensive rubric as a template because you don't wanna make major changes to it once it's been duplicated 20+ times, then creating a copy of this template for each student and sharing it with them one by one with "view only" permission. However, once you past this, the grading and communication process is rather straight-forward. To sum up, your first idea is not workable, the second idea is feasible given you put in some time upfront. Thanks!

[@georgeotoole2768]

@@edtechii Yeah I guess but if you have recorded the mark before you return the assignment then the first method would still be easier. After all, the teacher can use Version History to see any changes the student has made. If the student says the mark isn't the same they would be asked to resubmit the assignment. I don't know many students who would be that brazen --maybe I have been lucky!

[@edtechii]

This adds complexity and potential squabble with students over who is right. If you don't see as issue in your learning context then go ahead.

[@jorgemedina463]

I really appreciate all of this. Just one quick question, when I download the template for excel, it turns the check boxes into True/False statements. How can I convert them back to check boxes while not messing up the formula?

[@edtechii]

Hello Jorge and thank you for your question. I am afraid I do not work with excel. Try experimenting with checkboxes in excel and see what syntax you need to use to tell excel to count cells only if the box is checked. Does it make sense?

[@jorgemedina463]

@@edtechii Yes, I gave it a try and I have to manually add each check box and give it a cell target, then it works. Thank you again for all the useful info and the templates!

[@edtechii]

@@jorgemedina463 Fantastic, I am happy you've found a solution. Have fun!

[@raistarfanclub4497]

Excellent

[@edtechii]

Thanks!

[@georgeotoole2768]

This is an excellent video! I just found you and am loving what you are doing. Two questions: Can I link your material to my website? And do you see GC's Rubric Builder making this process redundant or do you see a need for both methods? Thanks again!

[@edtechii]

Hello George, Question 1: Sure, you can link the videos on your website. Question 2: It's funny you should ask that, because Google Rubrics Beta was announced just as I was putting finishing touches to my automated rubrics. For me it was like, "Ok, it seems as if Google and I are thinking about the same thing." ;) I don't think two rubrics mutually exclude each other. There are times and places where using Google Classroom rubric is more efficient and effective e.g. if you are assigning students an essay through Google Assignment, then I would advise using Google Rubrics by all means. Google Rubrics, like most of the Google products and services, are easy to use and use-friendly. May be even to the point of being "too" simple and user friendly. This simplicity comes at a cost - Google Rubrics are not customizable enough for some educators. Creating a weighted rubric, for example, is not possible incurrent version of Google Rubric. Also, what if your school doesn't use Google Classroom as their Learning Management System? Or, you are grading a student's art project, or theatrical performance, or STEAM project? The two examples below are not reproducible in Google Rubrics: Weighted Automated Rubric: drive.google.com/open?id=1Y6WL2aqNNhnzWrFN9DDvHRrGiE6CqdgoCC68K77aEbU Semester-long STEAM project: drive.google.com/open?id=1f0eRxd-H-pOSpPNBYDZHQCcsWdOnLD-s6D5GyY7jC6o I hope this answers your question.

[@georgeotoole2768]

@@edtechii Yes it's a very good answer. Thanks again and I look forward to viewing more of your content!

[@edtechii]

On the way ;)

[@edtechii]

Hello George, thanks for your comment and for being attentive to the intellectual property of others. Yes, you can post the original link to the video on your website: kzbin.info/www/bejne/e6q8nKd6hpx1hKc This tutorial came out a couple of weeks before GC rolled out its rubric feature. If you are using GC as both your Learning Management System (assigning work, sharing materials) and your Student Information System (recording students grades), then yes-using GC native rubric makes sense as it eliminates double entry i.e. you mark students work once, and the scores are recorded in the GC grade book. If, on the contrary, you have another Student Information System such as Power School, Moodle, Rediker, etc. and GC is only use for material distribution, then I would probably use an automated rubric for its ease of use and increased versatility.

[@supreemmdb2]

Wonderful. I will certainly be using this idea. At which point does backing up data come into play? lol... Off topic, but something interesting I noticed, was that you mentioned privacy from other students. Here in Japan, they share other students grades with the class. Their intent is for students to feel pressure from other students to do better... Obvious that can lead to bullying/depression (JP issues), but its intent is to create more empathy for others and help those in need, which is vital to their education here (moral education, as a subject, is required in JP from grades K-9). I suppose balance is key.

[@edtechii]

Hello Techmite, thanks for taking your time to leave a comment and share your teaching experience. It's interesting how each culture puts a certain spin on every tenet of our life. There is no way a grade is revealed to other parties in the context where I work.

[@norsalwatimohdrazalli2891]

How to calculate the total rubric for different sheet? For example I have 3 parts..Part A: Employer Marks, Part B: Lecturer Marks and Part C: Officer Marks. The three parts is given by different people. So how to create the formula for total 3 parts?

[@edtechii]

Hello Norsalwati, thanks for your question. When you said you have 3 parts, do you mean you have three separate rubrics (files) or three rubrics within one file?

[@norsalwatimohdrazalli2891]

@@edtechii I means three seperate rubrics = three sheets not 1 sheet for all..how to create the formula?

[@edtechii]

@@norsalwatimohdrazalli2891 Are all three sheets in one file i.e. as different tabs?

[@norsalwatimohdrazalli2891]

@@edtechii ya in one file but different tabs

[@edtechii]

​@@norsalwatimohdrazalli2891 Ok, thanks for clarifying. I'll try to explain: 1) Choose the cell where you want an average of all three scores. 2) press "=" sign 3) open your formula with "AVERAGE" . Do not type the quotation marks 5) Open a bracket "(" . You should now have "=AVERAGE(" 6) Select the the cell that has the total score of the first rubric 7) Put comma ",". You should know have something like this "=AVERAGE(H11," 8) Select the the cell that has the total score of the second rubric 9) Put comma "," 10) Select the the cell that has the total score of the third rubric 11) Close the bracket with ")". You should now have something like this: =AVERAGE(H7,Sheet2!C3,Sheet3!C3) 12) Press "Enter" If you've followed the steps correctly, the cell that you chose should do the average of all three scores. Let me know if it worked for you. Thanks!

[@profe_alfie]

Evgenii, thank you for the video, it's very helpful. Question is there a way to only allow one cell out of a roll or column to be checked? This is to prevent mistakes on the rubric.

[@edtechii]

Hello Sinuhe, and thank you for your question. Yes, it is possible to allow only one cell to be checked. I won't be able to explain this via a comment, but you can easily teach yourself how to do this. Let me know how it went.

[@augustaferretti1982]

@@edtechii Thanks for the video, it was really helpful. I have the same question as Sinuhe, can you direct me where to look for this information?

[@edtechii]

@@augustaferretti1982 Here you go: www.benlcollins.com/apps-script/radio-buttons-in-google-sheets/

[@michielpaesen4682]

Hi, i am just popping into this video and it helped a lot. We used an app for rubrics, but the app stoped existing. We were looking for an alternative and your video is the solution for us. I only have one question. Is it possible to give the rows a different grade (example row 1 counts for 40%, row 2 counts for 40% and row 3 counts for 20% of the total points?) I don't find a way to do this, maybe you have a solution?

[@edtechii]

Glad to hear the video is helpful. Yes, there is a way to give each a row a different weight. If you go to the folder that is linked in the video description, you will find a folder titled "Templates". In this folder, open "Automated Rubric - Weighted". In that spreadsheet, click on zeroes under "Criteria score" and look at the formula. Does what I did there make sense?

[@jinalchande7744]

Hello from India Sir, Thank you for the video, Completely informative and gave me different ideas for my work which is data oriented. I have one query, which is... In the video you mentioned that we can link the automated rubric with Forms (assuming Google Forms) Request you to share how that can be done

[@edtechii]

Hello Jinal, thank for your question. Can you point me to the timestamp in the video where I talk about it.

[@solanodasilva2077]

Thank you for sharing this excellent tutorial. I was wondering if that was a way to create a rubric with point ranges that could be integrated with Google Classroom's rubrics? For example, if one has three criteria to grade on - (1) Content, (2) Interpretation and (3) Structure - and within each of the three one has five ranges: 0-2: needs much improvement; 3-4: emerging; 5-6: meets expectations; 7-8: excellent, and 8-10: exceptional. This would provide the possibility of entering any value from 0-10 for each of the three criteria and in doing so generate much more variation in the scores for each criteria and also in the aggregate scores. Thank you again

[@edtechii]

Hello Solano, Thanks for your comment. I don't think you can integrate anything with Google Classroom rubric. I'm not sure what you are trying to accomplish with your idea, but I'm pretty sure it can be done in Google Sheets / Excel. if you can draw your idea on paper and send it to me, I might be able to automate it in Google Sheets / Excel.

[@solanodasilva2077]

@@edtechii Thank you for your prompt reply. I have sketched out the rubric. It is accessible from: tinyurl.com/y5ek423x

[@edtechii]

@@solanodasilva2077 Alright, I can see that you are trying to assign different weight to each criterion. You also have a selection of points for each performance level?

[@solanodasilva2077]

@@edtechii Yes Evgenii you are correct. In excel I use the formula =SUM(0.3*Content, 0.4*Interpretation,0.3*Structure) which gives me the total/10. But if I then want to extrapolate to a different total (say out of 30) then I would use =SUM((VALUE of total out of 10)*30)/10). To see an image which may express this better see: tinyurl.com/y2x2876f But am wondering if there is a better way. It would have been nice if the feature of having running points rubrics were available in Google Classroom.

[@edtechii]

@@solanodasilva2077 Thanks for providing a link - it seems like a working rubric. Here's my example of a weighted rubric: docs.google.com/spreadsheets/d/1Y6WL2aqNNhnzWrFN9DDvHRrGiE6CqdgoCC68K77aEbU/edit?usp=sharing (Make a copy to be able to edit). I thought you could you the formulas I used to improve your rubric.

[@dinamayer6412]

What if I want students to self-assess?

[@edtechii]

Hello Dina, and thank you for your question. You will need to give students editing rights for them to be able to edit it. This article explains more: help.tillerhq.com/en/articles/432685-sharing-and-permissions-in-google-sheets

[@dr.r.kannigadevicse-staff4649]

Just for information: Doing the same with Google classroom (setting rubric for assignement, for example) is better than this idea???? as it simplifies the creation of rubric and assigning to all students at one shot and grading questions by just clicking and generates marks

[@edtechii]

Correct. The method described in the video is an alternative to the Google Classroom rubric. This method can also be used when a built-in rubric is not available.

[@FH-on6em]

❤❤❤❤

[@denisecooper9678]

🏆🏆🏆🏆🏆