Learning Sheets Functions for Oral Assessment Grades (or, why my PLN rocks!)

Learning Sheets Functions for Oral Assessment Grades (or, why my PLN rocks!)

I recently put a plea out to my PLN to help me figure out how to collect grades from a form for oral assessment.

Click here for the original form. Click here for the study sheet for my students.

My idea is, from the 27 questions, I will randomly ask 10 questions to one student at a time. I will check off my assessment of their success on each answer (on my iPad).

Thanks to Kim Pollishuke, Pascal Morissette, Scott Monahan, Diana Mancuso and Jenny Gray for helping me find a solution.

Here are the steps:

  1. I used a grid question with questions in the row and to numbers 1, 2, 3, 4 in the columns. I then inserted as an image (just above) Faible, Acceptable, Bien, Excellent.

Screen Shot 2015-05-24 at 10.18.23 PM.png

2. I went to the live form and filled it out once as a test student.  

3. In the associated sheet I added two columns: Average and Grade (insert, column right).

4. In the Average column, I clicked on the first cell (Row 2), then clicked on the functions button, then clicked on “Average”:
Screen Shot 2015-05-24 at 10.24.35 PM.png
5. I highlighted all the cells to the l of this column, stopping at the cell after the student’s name then clicked “Enter”. This gave me an average out of 4.
Screen Shot 2015-05-24 at 10.27.26 PM.png

6. I then copied this “If” function formula that the brilliant Diana Mancuso made for me:


(Based on the following grades out of 4):
A+ = 3.8 - 4
A   = 3.4 - 3.7
A-  = 3.2 - 3.3
B+ = 3.1
B  = 3
B- = 2.8 - 2.9
C+ = 2.5 - 2.7
C  = 2 - 2.4
C- = 1.8 - 1.9
D+ = 1.5 - 1.7

D  = 1 - 1.4

and pasted it in the first cell under the “Grades” column. Just click out of the cell after. This gave me a letter grade for the first student.

(NOTE: The “AD” in the formula refers to the letters of the “Average” column that I added. You will need to change this to the letter of the column that your average column falls under.)

7. For subsequent students, it’s just a matter of dragging down the little blue square in the bottom right hand corner to cover the new cells (in “Average” and then “Grades” columns) and you will see the magic happen.

Screen Shot 2015-05-24 at 10.36.51 PM.png

PS. In grade 5, students have to ask the question as well as answer it. Click here for the study sheet, click here for the form. When assessing, I will simply give them the Key Word (Mot Clé) and they will have to give me the question and the answer.


  1. Rock on, my friend! This is such a great idea and I can't wait to adapt it in my own teaching practice.

  2. Couldn't have done it without you, thanks so much, my geeky friend!

  3. great article, thank you for sharing, I think I need it
    i like play game clickjogos online free and apply baixar facebook online free and apply baixar mobogenie online free

  4. Great post,Thanks for providing us this great knowledge,Keep it up.
    A good blog.
    five nights at freddy's download | fnaf | five nights at freddy's

  5. Great post. i like it. feeling great when reading your post .
    descargar mobogenie gratis and apply baixar facebook gratis | descargar mobogenie

  6. wow, great news. Thank you so much for your information.
    mobogenie and apply baixar facebook movel | descargar mobogenie gratis


  7. Latest Govt Bank Jobs Recruitment Notification 2016

    Awesome share.Thanks to author for useful post, keep it up....................

  8. So there are more of the benefits put thrown by this learning sheets and towards understanding of such facts will make our work more easy and evident.

  9. What a great article I have found finally, dear author, thank you very much for it! And I would like to add that not so long ago I was looking for some professional budget rewriting, but unfortunately I have not found it in the internet at all. And that is why I am really very happy that now I have seen your very helpful and well structured article. And please do not stop to write them, because I am completely sure that they can help to many of other people who are looking for some help as well as me!


  10. الرائد تقدم خدمات تطهير و تعقيم خزانات المياه فى جدة و مكة لاننا :
    افضل شركة غسيل خزانات بجدة
    و افضل شركة غسيل خزانات بمكة
    للمزيد قم بزيارة
    افضل شركة تنظيف منازل

  11. Packers And Movers Bangalore Local Household Shifting Service, Get Free Best Price Quotes Local Packers and Movers in Bangalore List, Compare Charges, Save Money And Time at
    Local Packers And Movers Bangalore

  12. We have to know the methods you can easy way to Activate YouTube doing YouTube.com/activate. If you are facing issues with YouTube, like how to connect YouTube on your TV, mobile or other devices contact us. Google has provided us the enjoyment, and by YouTube activate, you watch here latest videos, songs, or web series, etc.

  13. Packers And Movers Bangalore Local Household Shifting Service, Get Free Best Price Quotes Local Packers and Movers in Bangalore List, Compare Charges, Save Money And Time at
    Local Packers And Movers Bangalore

  14. Get Packers and Movers Jaipur List of Top Reliable, 100% Affordable, Verified and Secured Service Provider. Get Free ###Packers and Movers Jaipur Price Quotation instantly and Save Cost and Time. Packers and Movers Jaipur ✔ ✔ ✔ Reviews and Compare Charges for household Shifting, Home/Office Relocation, ***Car Transportation, Pet Relocation, Bike SHifting @ Packers And Movers Jaipur

  15. Packers and Movers Chennai Give Safe and Reliable ***Household Shifting Services in Chennai with Reasonable ###Packers and Movers Price Quotation. We Provide Household Shifting, Office Relocation, ✔ ✔ ✔ Local and Domestic Transportation Services, Affordable and Reliable Shifting Service Charges @ Packers And Movers Chennai

  16. Packers and Movers Hyderabad Give Certified and Verified Service Providers, Cheap and Best ###Office Relocation Charges, ***Home Shifting, ✔✔✔Goods Insurance worth Rs. 10,000, Assurance for Local and Domestic House Shifting. Safe and Reliable Household Shifting Services in Hyderabad with Reasonable Packers and Movers Price Quotation @ Packers And Movers Hyderabad

    I want to let the world know about Doctor JUMBA the Great spell caster that brought back my husband to me when I thought all hope was lost. Doctor JUMBA used his powerful spell to put a smile on my face by bringing back my man with his spell, at first i thought i was dreaming when my husband came back to me on his knees begging me to forgive him and accept him back and even since then he loves me more than i ever expected so i made a vow to my self the i will let the World know about Doctor JUMBA because he is a God on earth. Do you have problems in your relationship ? Has your partner broke up with you and you still love and want him back ? Do you have problems with your lover ? or do you need help of any kind then contact Doctor JUMBA today for i give you 100% guarantee that he will help you just as he helped me. Doctor Jumba email is: wiccalovespelltools@gmail.com or
    Website ::  https://drjumbaspellhome.wordpress.com  

  18. Packers and Movers Ahmedabad - We Provide ***Best Service Providers, Safe, Reliable, Affordable, Trusted ###Movers and Packers in Ahmedabad List, Household Shifting, Office Relocation: Choose Top Verified Packers and Movers Ahmedabad Compare ✔✔✔Shifting Service Chrages, Price Quotation, Rate List Charts and Save Money and Time @ Packers and Movers Ahmedabad