Fillable PDF for quizzes
Hey everyone! I am using Smartsheet in the classroom to digitize student tests. I want students to fill out a form, have their results come in, then feed the results into a fillable pdf so they know what they got wrong. I also want to have the PDFs for record keeping. Right now the quiz is set up as a dropdown list where students select the answer they want and it grades them. How do I put this into a PDF? My PDF looks something like this..
Question
A. …
B. …
C. …
D. …
I want there to be a check mark next to the option they selected. If anyone knows how to do this, I would really appreciate the help! Thank you
Answers
-
If you have a fixed set of questions for the quiz, first create a Smartsheet form with all the questions. Your students will fill up this form to take the quiz. Now your goal is to
1. Get a mark or correct/incorrect for each question
2. Map out where to put the check mark among the options based on the answer submitted by the student.
See the screenshot below. The first part (sky blued) is the submission from the student where we will not make any modification. I have shown here only for 2 questions. Each question has its own colored section. In each section there are two parts, one is for mapping out the check mark, another is for grading. You can use the following formulas:
For column Q1 A: =IF([Question 1]@row = "A", 1, 0)
For column Q1 Answer: =IF(Name@row <> "", IF([Question 1]@row = "D", "Correct", "Incorrect"), "")
Note, here I just assumed D to be correct answer for Question 1.
For final grade, use formula: =COUNTIF([Q1 A]@row:[Q2 Answer]@row, "Correct") / 2
Now create a template fillable pdf just like your questionnaire doc. You can use Libre Office or free online tools to create fillable pdf. Make sure to put check box field beside all the options of all the questions.
Now go to document builder in Smartsheet by selecting Generate Documents from the row menu. Follow the instruction to map out your document. Here make sure you are mapping the check boxes accordingly. For question 1 in your template, there should be 4 check box fields for 4 options and you should map Q1 A, Q1 B, Q1 C, Q1 D accordingly. Thus it will show check mark to the answer that the student has selected. You can have a field in your template for grade where you can map the Final Grade field.
You can setup two workflows now.
1. When new rows are added > generate document
2. When a row is changed and an Attachment is Added > Send Alert to student
It will take some time to setup the whole process. But once done, it should serve your purpose.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives