Suitable for: Teachers and High School students
01.
Obtain video transcript:
Find a relevant video
Option > Show transcript
02.
Copy transcript:
Click on 'show transcript' in video description
Option > 'Toggle timestamps'
Highlight and copy the transcript text
04.
Add text similar to this above the transcript text:
Make a multiple choice quiz for my Year 8 Design and Technology students based on the Design and Technology in this transcript from a video:
05.
Add text similar to this below the transcript text:
Then put these in a spreadsheet format, like this: Question - max 120 characters Answer 1 - max 50 characters Answer 2 - max 50 characters Answer 3 - max 50 characters Answer 4 - max 50 characters Time limit (sec) – 5, 10, 20, 30, 60, 90, 120, or 240 secs Correct answer(s) - choose at least one Which spreadsheet tools can read this sheet and export to xlsx format? Excel Google Docs Numbers LibreOffice 60 1,2,3,4
06.
Select all text and copy:
CTRL + A
CTRL + C
07.
Paste text into Chat GPT:
Paste text into the message box
Note: you may need to create an account or login to ChatGPT.
08.
Scroll down and copy the table:
Click the top-left cell, hold shift, scroll down and click the bottom-right cell to select the whole table.
CTRL + C to copy table.
Note: The first attempt included code only, so I pressed 'regenerate' and the second attempt included the table.
09.
Paste table into a sheet:
Go to sheet.new
Click in the top-left cell
CTRL + V to paste
10.
Export sheet as .xlsx:
Go to file > download
Choose .xlsx file
11.
Move to Kahoot:
Go to staff apps portal and login to Kahoot.
Select 'Create'
Select 'Kahoot'
Select 'Blank canvas'
Select 'Select file'
Upload your .xslx file
12.
Add and review questions:
Select 'Add questions'
Review questions and save