DWQA Ask QuestionCategory: QuestionsAssignment: Create MCQ via Google Form Using Selenium and Add Questions & Options from Excel
admin Staff asked 5 years ago

(To Post Answer let me know at : akashdktyagi@gmail.com . I will create your ID; login using the ID and post your answers.)

Requirement: Create a Google Form that has  questions  using ‘Automation Tools’.
Tools: Selenium, Maven and anything you want to include.
Programming Language: Java/.
Browsers: Chrome/Firefox
Details:
1. Create an Excel sheet and have five columns in it.
2. First column should have a question and rest of the four columns should have options.
(Basically an MCQ).
3. Save and close the file.
4. Make use of an IDE (based on the language you use) and create a project to automate a test
case.
5. Write an automation script to,
 Read the data from the excel sheet that you have created before.
 Login to your Google Account and Select Google Forms.
 Select a ‘Blank Form’.
 Name the form as ‘My Assessment’.
 Read the data from the Excel sheet that you have created.
 The data should not be limited to one or two questions. It should be GENERIC i.e.., the data
should be dynamic. If you add/remove the data from the excel sheet, in the next execution
the updated data from the sheet should be read and exact number of questions should be
created on the form.
 Dump the first columns data from the excel to the question field of the Google
Form and dump the data from rest of the columns to option fields of the Google
Form.

Similarly add all the Questions mentioned in the Excel File.
 Click on Settings
 Click on ‘Quizzes’ tab
 Enable ‘Make this a Quiz’
 Close the page.
 Close the browser