G'day all,
I have PDFs that contain questions for practice exams. I have attached one for reference.
Each exam contains questions and when I copy them into excel it essentially looks like this.
Row 1: Question
Row 2: A) Answer
Row 3: B) Answer
Row 4: C) Answer
Row 5: D) Answer
Row 6: Question
Row 7: A) Answer
Row 8: B) Answer
Row 9: C) Answer
Row 10: D) Answer
And it goes on for 40-odd questions per exam.
At the end of the exam are answers which essentially have what unit the question is related to right next to it.
We are trying to integrate them to a platform that will allow us to do it in bulk if we can somehow get the data into the following format.
question type marks answer1 answer2 answer3 correctanswer threshold subject trainingBlock externalReference performanceCriteria questionExplanation.
Please see attached spreadsheet.
Does anyone know how I can transpose this data? We have about 40 questions per exam, 10 exams per subject and 7 subjects. Making a grand total of 2800 questions. The idea of manually doing this seems impossible.
Regards,
Joey
Bookmarks