SCRIPTS |
|
LET'S INSTALL FORMMULE |
1. Please don't proceed until you've checked in. Once you have been given the green light, open the back end spreadsheet of your form. The file name ends with (Responses). That's how you know you are opening the back end and not the form itself.
2. From the back end, you will begin the installation of the FormMule script. Click Tools--> Script Gallery. 3. Type "formMule" into the box and click Search. 4. Click Install. 5. Click OK.
6. You will see a new item in your menu bar called formMule. Click formMule -> Run Initial Installation. 7. Click OK.
8. Scroll down until you see Accept. Click Accept. If prompted, reauthorize your account to run the script. You might have to repeat this process a few times if it doesn't take the first time.
9. You will now be brought to a sheet entitled, "FormMule Read Me." Ignore those instructions for now. Instead, look to the bottom left of the sheet and click on the "Form Responses" tab.
10. You should be on the Form Responses sheet and should see the data you entered previously from the sample rubric scores. Next, from the menu, click on formMule -> Step 1: Define merge source settings. 11. Do NOT change the Form Response option. Instead, check the Auto-Create a unique case number. Click Save settings. 12. Click OK when you see the Apps Script window. 13. You will see the cell headers double up on their own. This is normal. You will also see a yellow and an orange box. Also normal. These areas are where the script lives, so don't delete any columns. 14. From your menu above, click formMule--> Advanced options.
15. In the Advanced options window, select Copy down formulas on form submit. 16. You should see this window. Scroll horizontally to the far right of the window. 17. You should be looking at the far right of the window. Click the J box. Next, click the K box. You should see the gray formula text turn black. Do NOT check the boxes beneath the formulas. 18. You should see this sheet. Do NOT change anything. Do NOT click add. 19. Select the Form Responses tab. 20. You should now see the back end of your form.
GREAT SUCCESS! Now each time you enter a new student's rubric ratings into the front end of the form, the back end will copy down the grading formula and calculate the new student's numerical grade for you. FormMule can also be set up to email students automatically, but I think you will find the FormEmailer more reliable and easier to use for this.
|
|
|
What does this script do? FormEmailer will send an email to your students with their results. You can customize the email any way you like. 1. Go to Tools -> Script Gallery and search for FormEmailer. Authorize it to run by clicking OK.
2. You should now see this screen containing a green bar if the script installed properly. Click close.
3. On your menu, you will notice a new option next to any previous scripts you installed. Click FormEmailer -> Install. Click Install again on the subsequent screen. 4. You should now see a sheet that looks like this: 5. If you want to email students their feedback immediately after you fill out their rubric form, you'll have to set a trigger. To set a trigger, start by clicking Tools -> Script editor.. 6. In the menu, click on FormEmailer (NOT formMule). 7. From the Form Editor window that pops up, click Resources-> All your triggers.
8. Click on Add a new trigger.
9. Scroll down past the FormMule triggers until you see timeDriven. Configure your new trigger like this: Time-driven | Minutes timer | Every minute.
Now, click Save. 10. Close the Form Editor window and return to the FormEmailer sheet you were on previously.
11. On the FormEmailer sheet, you should now see Yes in green. If so, your script is now triggered to send an email automatically every time you fill out your rubric form.
12. Next, you'll want to set up the email template you'll use to send assessment results to students. From the menu, click FormEmailer -> Settings. Don't click on the wrong script! 13. You should see a screen that looks just like the one below. This is the template you will customize in a moment to send an email to your students.
14. Don't worry. It looks like a bunch of gobbledygook, but once you mess with the template a bit, you'll have things under control. Here's the lazy, easy way...
First, delete the gobbledygook from the body of the email template. Next, copy and paste the text below where the gobbledygook was.
15. You'll want to set up the email's TO, FROM, SUBJECT, etc. Next to TO, use the marker #EMAIL# with the word typed exactly as it appears in cell K1 of your spreadsheet (all uppercase? upper and lower?). Otherwise, the student's email address will not be filled in for you and the email will not be sent. Fill in the subject however you like. WANT AN EVEN MORE CUSTOMIZED MESSAGE? You can type anything you want in FormEmailer's email template. To insert any data from the spreadsheet into the email... |
|
|
What does this script do? If you have a separate spreadsheet containing your students' names and emails, FormRanger will automatically put them in the front side of your form so you can select the each student's name instead of typing it into the rubric each time. In the previous session, you set up a separate formula called VLOOKUP which will automatically fill in the student's email address for you.
|