Skip to contents

Import questions from Google Sheets.

Source: R/google2rmd.R
google2rmd.Rd

Download a Google Sheet of questions and convert it to Rmd files.

Usage

google2rmd(url, output_dir, sheet = 1, log_file = NA)

Arguments

url

URL to the Google Sheet.

output_dir

Directory to write Rmd files to.

sheet

Index or name of sheet that contains questions.

log_file

Directory to write log files to.

Details

The image is imported from the Sheet and saved in the 'img' directory with the same name as the question's generated ID.

Sheet format

The xlsx file should have the following columns:

  • Question: the question text

  • Image: the image file

  • Type: "schoice", "mchoice", or "string"

  • Ans1: the answer text for the first answer

  • Ans2: the answer text for the second answer

  • Ans3: the answer text for the third answer

  • Ans4: the answer text for the fourth answer

  • Ans5: the answer text for the fifth answer

  • Correct: the correct answer number (1-5)

  • Category: the category of the question

  • SubCat: the subcategory of the question

Credits

Brighton Pauli, 2022.

See also

xlsx2rmd