Google Sheet Data to Make Quiz Automatically only One Click

 

नमस्‍कार दोस्‍तो,

इस ब्‍लॉग में हम आपको बहुत ही सरल भाषा में बतायेगें की किस प्रकार गुगल शीट के डेटा से ब्‍लॅक में गुगल फॉर्म Quiz बनाया जाता है ा 

निचे दि गई स्‍टेप को फोलो कर  गुगल शीट के डेटा से ब्‍लॅक में गुगल फॉर्म Quiz बनाना सिखे ा

How to Google Sheet Data to Make Quiz only One Click Automatically

In this blog we will tell you  How to Google Sheet Data to Make Quiz only One Click Automatically so read the complete blog carefully and learn How to Google Sheet Data to Make Quiz only One Click Automatically according to given guidelines.

Click to Google Sheet Copy With Source Code

 

Step 1 :- In Google Sheet Quesion Write in Column A

Step 2 :- Correct Answer Write in Column B

Step 3 :- Columns C, D, E, Incorrect Choice Write

Step 4 :- Click to >> Extensions >> App Script >>

Step 5 :- Click to Copy Below Code and Paste to Code.gs File

function popForm() { var ss = SpreadsheetApp.getActive(); // var sheet = ss.getActiveSheet(); var sheet = ss.getSheetByName('Sheet1'); var numberRows = sheet.getDataRange().getNumRows(); // Read the sheet data into 3 arrays. Would be better practice (faster performance) to read all into 1 array and divide as needed). var myQuestions = sheet.getRange(1,1,numberRows,1).getValues(); var myAnswers = sheet.getRange(1,2,numberRows,1).getValues(); var myGuesses = sheet.getRange(1,2,numberRows,4).getValues(); // Shuffle the 4 choices horizontally. This script only works with Questions in col A, correct Answer in col B, and false choices in col C thru E. var myShuffled = myGuesses.map(shuffleEachRow); Logger.log(myShuffled); Logger.log(myAnswers); // Create the form as a quiz. The resulting form's "Quiz options" are different from a manually created quiz. Be aware (and change manually if needed! var form = FormApp.create('Question Paper'); form.setIsQuiz(true); // Write out each multiple choice question to the form. for(var i=0;i<numberRows;i++){ if (myShuffled[i][0] == myAnswers[i][0]) { var addItem = form.addMultipleChoiceItem(); addItem.setTitle(myQuestions[i][0]) .setPoints(1) .setChoices([ addItem.createChoice(myShuffled[i][0],true), addItem.createChoice(myShuffled[i][1]), addItem.createChoice(myShuffled[i][2]), addItem.createChoice(myShuffled[i][3]), ]); } else if (myShuffled[i][1] == myAnswers[i][0]) { var addItem = form.addMultipleChoiceItem(); addItem.setTitle(myQuestions[i][0]) .setPoints(1) .setChoices([ addItem.createChoice(myShuffled[i][0]), addItem.createChoice(myShuffled[i][1],true), addItem.createChoice(myShuffled[i][2]), addItem.createChoice(myShuffled[i][3]), ]); } else if (myShuffled[i][2] == myAnswers[i][0]) { var addItem = form.addMultipleChoiceItem(); addItem.setTitle(myQuestions[i][0]) .setPoints(1) .setChoices([ addItem.createChoice(myShuffled[i][0]), addItem.createChoice(myShuffled[i][1]), addItem.createChoice(myShuffled[i][2],true), addItem.createChoice(myShuffled[i][3]), ]); } else if (myShuffled[i][3] == myAnswers[i][0]) { var addItem = form.addMultipleChoiceItem(); addItem.setTitle(myQuestions[i][0]) .setPoints(1) .setChoices([ addItem.createChoice(myShuffled[i][0]), addItem.createChoice(myShuffled[i][1]), addItem.createChoice(myShuffled[i][2]), addItem.createChoice(myShuffled[i][3],true), ]); } else { var addItem = form.addMultipleChoiceItem(); addItem.setTitle(myQuestions[i][0]) .setPoints(1) .setChoices([ addItem.createChoice(myShuffled[i][0]), addItem.createChoice(myShuffled[i][1]), addItem.createChoice(myShuffled[i][2]), addItem.createChoice(myShuffled[i][3]), ]); } } } // This function, called by popForm, shuffles the 5 choices. function shuffleEachRow(array) { var i, j, temp; for (i = array.length - 1; i > 0; i--) { j = Math.floor(Math.random() * (i + 1)); temp = array[i]; array[i] = array[j]; array[j] = temp; } return array; }

Step 6 :- Click to Save Project

Step 7 :- Click to Run >> Permission Ok >>

Step 8 :- Open Your Google Drive Google Drive Open

 Your Quiz Succefully Generated 

More Detail See Video :-