Office Classroom Excel Forms Grading

Question

I am wanting to use the Excel forms in my classroom but not finding an easy way to grade...is their an addin for excel?

Answer 1

Office 365 now has Microsoft Forms.  I work for a school district.   In forms I could create a Form for my student that would essential be a quiz.  So say 10 questions with choices that have a right answer.  Forms works great and then creates an excel output for you that is a csv file with the taker, question, answer etc.   Google has similar but goes a step further with an add in that actually grades this csv data for you.  http://www.flubaroo.com/flubaroo-user-guide

The grading part is what is missing...it shows you right or wrong but doesn't tally it up like this does.

Answer 2

I don't see where it grades....I am wanting to create a quiz using excel forms in office 365.  I want it to grade the quiz based on the excel file you can export from it.

Answer 3

How incredibly rude....

I am still not finding what I am looking for.

Sorry, but the question is: What are you looking for? :-)

There are thousands of templates out there... e.g. this one:

http://www.vertex42.com/ExcelTemplates/gradebook.html

Looks good, grading is included, very simple... IMHO has all you requested so far.

Andreas.

Answer 4

How incredibly rude....yes I have Googled it...please tell me which of those you would do because I am still not finding what I am looking for.

Answer 5

http://lmgtfy.com/?q=excel+grading+template