Archive for August, 2012

Attachment in Form

So far, I find 2 solutions:
1. Dropbox Form:
It’s limited for free account.
2. File upload class in Google Apps Script:

Categories: Ideas / Resources

Online Assignment System with Auto-Feedback & Grading Functions

This project is developed based on one of our undergraduate student class projects.

1. Available question types: Essay, Multiple choice, True / False, Yes / No, Checkbox, Pull down, Scale.
2. Flexible & easy design.
3. Centralized submitted answers.
4. Instant submission feedback: When a student submits an assignment / quiz, student will get an personalized email instantly with the submitted answers and pre-designed teacher’s feedback / message.
5. Embedded grading & reporting function: To grade all the submitted assignments / quizzes, the teacher just need several simple clicks; after the grading, the teacher can email students the grades individually by one click.
6. Share with other teachers / coworkers / teaching assistants.
7. Free.

 Step 1. Start your quiz / assignment design.
1. It will use google form to design an online quiz or assignment. Thus, you will need a google account first. Click google docs and login with your google account.
2. Click Sample Quiz, and make a copy of it as in the Figure 1, and click “ok”.

Figure 1: Make a copy of the Sample Quiz

3. Then, go back to your google docs, you will see a document called “Copy of SampleQuiz”. Click the document, and you will see the spreadsheet.
4. Click the menu “File”->”Rename”, then you can rename the assignment or quiz.
5. Click the menu “Form”->”Edit form”, then you can start to design your own assignment or quiz. You can modify the existing questions and add more questions. If you need any help, you can click HERE about how to edit a form.
6. Once you finish designing your assignment or quiz questions, save and close it. Your spreadsheet like document will be updated too.
    Note: Please do not change the first 3 items: “First Name”, “Last Name”, and “Email Address”, which are used to identify students. You feel free to add more such as “Student ID”, etc.

 Step 2. Configure the designed quiz / assignment.
 1. In the spreadsheet like document, click the menu “Tools”->”Script editor…”, and you will see the following as in Figure 2. Then click “Copy of HJ-SendConfirmEmail”.

Figure 2: Script Project Selection

2. Then, as in the following Figure 3, click “Resources”->”Current script’s triggers…”.

Figure 3: Set Up Trigger

3. Then a pop up window will show up. Click “No triggers set up. Click here to add one now.”, and set up the trigger as in Figure 4 (“sendEmails” – “From spreadsheet” – “On form submit”):

Figure 4: Set Up Trigger

4. Click “Save”.
5. An authorization information will show up as in Figure 5, and click “Authorize”.

Figure 5: Authorization

6. Then it will show you the authorization status. Click “Close”.
7. It will back to Figure 4. Click “Save”, and close the window as in Figure 3.
 Step 3. Customize the feedback message. 

1. Go back to the spreadsheet like document, click the second sheet named “Template” as in the Figure 6:

Figure 6: Select Template Sheet

2. The template sheet looks like Figure 7. You can modify cell A2, B2, B3, C2, D2 to customize your feedback email. Instruction is in the highlighted area. The modification will be automatically saved.

Figure 7: Customize Feedback Email

 Step 4. Set up answer key. (It’s optional if you do not want to use it for grading.)
 1. In the spreadsheet, click “Form” and “Go to live form”. The url of the opened form will be the link to be shared with the students.
2.  You can input “Answer”, “Key” and your own email address for the items: “First Name”, “Last Name”, and “Email Address”. And fill in the correct answers for all other questions.
3. Click “Submit”.
4. Check your email, you should get an email similar with the following Figure 8:

Figure 8: Instant Feedback Email

Step 5. Share the link of the quiz / assignment to your students.
    Go back to the spreadsheet, click “Form” and “Go to live form”. The opened form is what your students will see, and you can copy the url and share with your students. If your student submit his / her quiz or assignment, he / she will get an email similar with Figure 8 right away.
 Step 6. Grade the quiz / assignment and email grades. 
    This function uses Flubaroo ( We embed it to grade the quiz / assignment and email the grades. You can check the website for more details.
1. Go back to the spreadsheet, click the menu “Flubaroo” and “Grade Assignment”.

Figure 9: Flubaroo

2. Again, an authorization form similar with Figure 5 will show up and you will need to click “Ok” and “Close”.
3. Click the menu “Flubaroo” -> “Grade Assignment” again, and following the instruction to select related item.
4. Once you finish grading and click “View Grades”, you will see an added sheet named “Grades”.
5. To email students grades individually, click menu “Flubaroo” -> “Email Grades”, and follow the instruction. Each student will get an email with his / her grades, and you will get an email summary as well.
6. Drag the sheet “Template” and move it to left, and keep it as the second one.
Other tips:
1. If you want to regrade, you can click menu “Flubaroo” -> “Regrade Assignment”, the new grade sheet will replace the original one.
2. If you want to keep a copy of the students submission and grades, you can make a copy of the sheets  and rename them, such as “2012Spr-Submission” and “2012Spr-Grades”. After that, you can keep the answer key and delete the rows of the student records in the sheet “Student Submissions”, and reset the “row #” in “Template” to be 3. Remember to keep sheet “Student Submissions” the first place and “Template” the second place. Thus, you make it ready for new semester.