MS Office Programming tricks Tricks Useful Visual Basic

How to Conduct Online Exam Using Google Docs

Now you don't need to search here and there for conducting online exam for your students. If your students are in Standard VII or below it then you can use this beautiful technique to conduct exam for them. For students above standard VII you can read my another post which is about 3 Best free websites to conduct online exam.

Why you will do this with Google docs

  • Google docs is a free service which will allow you to create web form using Text box, Dropdown, Radio button, Check box and many others.
  • You can create multiple choice questions with Google docs using Radio buttons.
  • Students below standard VII are small children and you might not want to create an exam which will take a lot of time to design. Google docs will take very less time to design.
  • When students will complete the exam all their answers will be populated in an excel sheet and you can easily evaluate their answers using Visual Basic program.

How to do this

  • Lets start doing this assuming that you know how to create web forms with Google docs.
  • If for the first time you are listening about Google docs or you are new to Google docs then also don't need to worry. Just sign in to your Google account and go to www.docs.google.com, you will automatically learn everything.
  • Create a form with Name(Text field), Roll number(Text field) and the questions(Radio buttons).
  • You can view a sample exam which I have created for you.

How to evaluate the answers

  • After the students appeared the exam, open Google docs and you can find their responses in a sheet.

  • Now a very important step is, after all students appear the exam, you have to also appear the exam with all correct answers so that your response will also be recorded in the same Google sheet. Make sure that your entry must be the last entry in the sheet. In the above picture you can see the last entry with my name. That means I deliberately appeared the exam giving all the correct answers so that my answers will be compared with others to evaluate their answers.
  • Then Go to File → Download as → Microsoft Excel. Now the answers will be downloaded as Excel.
  • In Excel you can see only one sheet. The name of the sheet must be Sheet1. If it is not so, then change it to Sheet1.
  • Now press alt+f11 to open VB editor. Then in the left side-bar double click on Sheet1 (Sheet1) to open the editor. Then copy and paste the following VB code.

  • Then close visual basic editor and press alt+f8 to run the VB code.
  • It will ask you "The questions are present from which column to which column ?"

  • Please provide the range carefully. If your questions are present from D to H then provide D-H.
  • Then it will ask you some more questions about. Read the questions carefully and provide only +ve integer values for all.

  • The result will be automatically calculated.

Leave a Reply

Your email address will not be published. Required fields are marked *