Quiz with Google Docs - Score Working

Okay dear readers, as promised I am here to give details of how to get score of your quiz...  You can say that its a continuation part of last blog post Making Quiz with Google Docs...

Now when you are done with your Form creation and spreadsheet addition for responses to be recorded, next step is to calculate the score which is yet very easy to do with following simple steps...

Step 1: Login to your Google account and go to docs, where you will see your files like the following image...

Step 2: Now open the 'Test Quiz (Responses)' file to make some changes to the file...

If you notice there is only one sheet with the name 'Form Responses'.

Step 3: Click on Add Sheet to create new sheet under the same file as shown in below image...

You will see a blank new sheet with the name 'Sheet2' which will now be used to calculate the results of the quiz for each individual entry...

Step 4: Now leave 02 columns for 'Time of Entry' and 'Name' and in 3rd column write the correct answer for your first question which in my case is '2007' and then second question's correct answer in the next column which in my case is 'COM'... Now pointing to column address 'A2' press '=' sign on your keyboard and click on the sheet 'Form Responses' and moving by keyboard arrow keys select the column where date and time is there and press enter... Move to the next cell 'B2' and press '=' and then click on 'Form Responses' sheet and select the where name is written in this sheet with keyboard arrow keys and press enter...

You will see the same data is showing on your 'Sheet2'...

If you can see the image above, the time,date and name records carried forward from the previous sheet and your correct answers are also there to compare the results...

Step 5: Now being on the same column which is shown in above image press '=' sign and then right 'if(' so it will become like '=if(' and then move up arrow key to select the top column which is '2007' and press '=' sign again, similar to below image...

Step 6: Now being in the same position, click on 'Form Responses' sheet and then select answer field of first question which is 'D2' in the sheet and then write ,1,0 to give score of 1 if correct and 0 if the answer is  incorrect... Now simply copy the formula from column 'C2' to 'D2' by simply pressing 'Ctrl+C' on your keyboard and 'Ctrl+V' after moving to next column...See below image...

As you can see that both the questions answered correctly so that the score is 1 and 1...

Step 7: Before going further click on first '1' and press 'F2' function key that will appear the formula to edit which you need to make some changes to make the correct answers columns 'constraint' which means every time when you drag the formula down to see next record result, the answer column address should not change and only the entry which is compared should change... To make this happen add $ sign with 'C' and '1' which will freeze this column every time you drag it down for more results...

To make it further clear lets see how it will work, I hope after practicing and going through the procedure further you will understand how this thing works, perfectly...

Now I will try another entry will incorrect answer lets see what happens...

As you can see there is another entry...

Step 8: Now click on 'Sheet2' and select second and third row and press 'Ctrl+d' to copy the formula in next row, which will show the results like below image...

If you notice and first question, answer was incorrect that is why the score is 0...

Finally the last step is to make final Total score which is very easy to make...

Simply write Total Score in the next column and under that write '=sum(' and select the score to sum...

You are done enjoy creating interesting quiz for your facebook, students, and so on...

Thank you  for your patience and support.  Please feel free to ask questions and write comments...

Making Quiz with Google Docs

Many of my fellows are into training and testing programs and many times ask for help in creating online quiz to distribute into their students or co-workers and others...

I thought better I share this experience and tutorial with entire blog readers and whoever can find it on the web to make an effort making their life easier...

Okay first of all u should have Google account, you can register yourself for one with going to www.gmail.com and then by clicking on 'Create An Account' button...

Once you are done with account creation, I suggest you simply open Google.com, while you are already singed in which you can see in upper right side corner which will show you the user details, which is signed in...

Simply follow the steps please...

Step 1: Open Google.com and click on Docs and it might ask you to sign in again or register for the service which you can with the same Google ID, you just have created...

Step 2: Click on 'CREATE' button and select Form like below image...

Step 3: Now select the theme and title of the quiz or form, as shown in below image...

Once you select the theme and title for your page, you will move to the following image/page...

Step 4: Here you need to select the question type, whether it will be text only, multiple choice etc. Just see below image and you will understand what I mean...

As you can see that 'Question Title' I have given as Name, cause I want name and email details of the person attempting the quiz, remember that you can make it compulsory or just leave it up to the user...  Question Type must be text only, as the user will enter his/her name...

Step 5: Now click on 'Add Item' button to add more items, yes the one you need for 'Email' same as, the one created for 'Name', follow the below image...

Here if you see, you already have the choice to select whatever type of item you want to add to your form next...  I suggest that you try all of them one by one to get to know what things you can actually add to your quiz form...

Step 6: Now add your question title and answer as well if it is a multiple choice question as shown in below image...

If you notice, there is a check box for 'Required question' which can be checked if the question or field is compulsory...

Step 7: Once you are done with adding questions, I have added only 02 questions cause its a tutorial... Now look at the bottom options to select from...

The option 'Show link to submit another response' is pre-selected which enables user to submit multiple entries for the same quiz even after submission...
The next one is 'Publish and show a link to the results of this form of all respondents', this option will enable the user to see previous responses which their result...
The last one is 'Allow responders to edit responses after submitting', which will off course give user choice to reconsider their answers/ entries...

Step 8: After completion of the form, click on 'Choose response destination' to select where the results will be saved for your further working, as shown in below image...

Select 'New spreadsheet' to record the responses of the form... It will create a spreadsheet as an additional document under your Google Docs account to record the response which we will use to calculate the score later on...

Step 9: Now click on 'Send Form' button to publish it on the web, so that you can simply send the link of the form and users can open it from their and attempt the quiz, see below image...

As you can see its suggesting to copy the link, or you can also email it to Admin of your institute, school, college, university, organization to spread it through email...  Copy and send the link highlighted to the users or send them email directly which will send an email including the form link and instructions...

Step 10: Finally try this link to open the form and it will show you something like below image...

Try it once by yourself... 

After submission you will see the below image like submission page...

Once you submit, you can see the results in the spreadsheet, which was created by Google Docs to show you the results, see the below image...

As you can see that the spreadsheet shows time stamp as well which was not added by us, but it shows automatically as to show which time and date the quiz was attempted by the particular user...

Other questions are shown as headings and answers as records... They will keep adding as more and more users will attempt the quiz...

Okay guys tomorrow in next post we will discuss about calculating the score by knowing the correct answers, so be patient and keep looking forward for the post tomorrow Insha-Allah...