Making Courses

Are all the control numbers clearly visible?
Check the size of lines and circles; adjust wtih Event > Customize Appearance. Control numbers in bold. White outline around numbers (eg 0.1). If needed, change away from IOF standard sizes.
Are all the courses in the correct order? The New Animals course order is in the "Pivot Courses" tab of this spreadsheet, and also shown below.
Is the name of the course on each map?
Which courses should not be used because the legs cross each other too much?
Did you create updated PDFs?
Is the course in an appropriately named folder in the correct location? Is it using the correct (usually latest) map?

Neighborhood-O Maps

The overall process

Make the map and courses in Purple Pen.
Record the controls (course, control number, question, right and wrong answers) in the master spreadsheet. Make sure you are entering data in the Controls tab!
Run the software to generate the answer sheets (doc, pdf and form): Go to Extensions > Macros > CreateMultipleChoiceQuizForms
1. You can find the results in the ALL ANSWER PDFs folder (in MapsArchive), and the docs in the ALL ANSWER DOCs folder. The form will be in ALL FORMS folder. Check that they are there and look OK.
2. Sheet ControlCourses is created if it does not exist, and overwritten each time. So copy the line(s) from ControlCourses and paste into CuratedCourses after running the macro. This gives you the links to the form and documents that are generated.
3. You may want to edit the doc or form, because sometimes the formatting is not perfect. If you edit the doc, download as PDF and replace the original PDF. (You may then want to update the URL in CuratedCourses tab.)
4. You can create a QR code (eg with QRCode Monkey) that points to the online form, and put that QR code in the google doc & pdf. Here is an example.
For "permanent" courses on our website:
1. Add links to the map, PDF answer sheet and Form answer sheet on the website (wix.com table)
2. Edit the form so that the results are sent to a tab in the master spreadsheet.
3. Run software periodically to summarize all results.

Current questions and things to do 7/21/2020

Check that all website published courses are the ones in the CuratedCourses tab.
Previously, all the responses were MANUALLY added to the Neighborhood O Responses spreadsheet, which is for some weird reason in the 2020 03 27 Fences folder.
Look to see whether we have any "old" course form files and rescue any "old" results.
- There are forms in the Courses folder eg here. Some have answers.
  - 2020 03 27 Aggasiz - Hydrants I ID is 1i1PTGnQW4JP9Q2pG4HpqXYkV6NIORUr4B7UdYl-XqYI
  - Agassiz H1 ID is 1CUmztXwxcaRfz_0yDv5LJyN_17GXWF9zhHrxnXNBjhA
  - Manually transferred the old results over and deleted 2020 -3 27 Aggasiz. Ah but that did not get the responses into the form. Might need to write code to make that happen, or else manually submit.
Make sure that accidentally rerunning the make courses macro will not over-write existing functioning courses
Check the process for adding a new course and document it fully.
Check that the website has the up to date courses... It appears that the website has a link to different form
Changes to script
- Put new things into the right folder.

Important files and folders

Ethan's instructions for making a map. (need to add branding instructions)

Folder where all neighborhood O maps end up. This folder has three subfolders:

Branding and Image Elements: logo and website address that should be added to each map, using Purple Pen.
Maps and Purple Pen Files. This folder is organized by neighborhood. Within each neighborhood folder, there are two folders, Map Files and Courses. Within each "Courses" folder there can be multiple folders, one for each purple pen file (which may itself have multiple courses). This final folder includes the purple pen file, the pdfs of the maps, and the quizzes (google forms).
Control Data and Program Output
- Spreadsheet Neighborhood-O Controls and Courses - this is the master spreadsheet that contains the data and software for automatically generating the quizzes in both Google Form and PDF formats. It also contains participant's results (the answers they submitted to the forms). See below for more information about this spreadsheet.
- ALL ANSWER DOCS: this contains Google Docs which are a printable version of the question sheet with multiple choices for answers. People may prefer to print and use an actual paper copy when they are out on the course. They can submit their answers after they do the course, when they're back home.
- ALL ANSWER PDFS: Same as ALL ANSWER DOCS, but these are PDFs instead of Google Docs. These are the ones we link to on the website
- ALL FORMS: Same question sheet but as a google form. The software creates these, including what the correct answers are.

Neighborhood-O Controls and Courses tabs

[to be documented - list all the tabs and what they are for]

How to run the software

The software is written in Google Apps Scripts and is run from the master google spreadsheet. You can run a macro by going to Tools > Macros and then choosing the macro you want to run.

Please be careful with this, because by running a macro you may replace a previous form and lose the previous results and the connection to it from the website! Each of these functions is documented in more detail below.

calculateResults
createMultipleChoiceQuizAnswerDocs - this does not exist
createMultipleChoiceQuizForms

To see and edit the code, click on Tools > Script Editor.

Visibility/availability of macros can be managed with Tools > Manage Macros or Tools > Import.

calculateResults

This reads from sheet (tab) CuratedCourses and writes to sheet Results.

If there is no sheet named Results, it creates it.

It uses the google form identifier from CuratedCourses to open the form, get the responses, determine the total points, get the actual responses' scores, and store that information in an array. Then it writes that array to the Results sheet. I tried running this script on 7/21, and ... it works! This is a nice way to get all the answers in one place.

createMultipleChoiceQuizAnswerDocs

Does not exist in the code any longer - should probably remove it.

createMultipleChoiceQuizForms

Input: tab "Controls"

Output: tab "ControlCourses"

This writes output to the ControlCourses sheet. It completely overwrites anything that was there before. Note that the manually curated CuratedCourses tab is where we should keep the courses that are final.

The code walks through all the controls in Controls tab, creating an array of quizzes. Each quiz is a list of controls with all the information about that control.

Next, the code creates a Google form and a Google doc starting from templates. The templates are here: form, doc.

For each quiz, the code creates a copy of the two templates, and sets up some initial text in the files. Then it goes through the questions, adding the question to both the form and the doc. Note that the controls for a given course must be in order in the Controls tab, because the code does not (currently) sort the controls within a course. Finally, a PDF file is created that is a copy of the Google doc, and is named as the course.

Finally, all information about each course, including the Form ID, URL, response URL, and answer sheet ID, URL (both gdoc and pdf) are stored into the output tab "ControlCourses".

Now the important questions: where do these files go; do we over-write existing files?

As an example, from CuratedCourses, Agassiz H1 form is here. 1CUmztXwxcaRfz_0yDv5LJyN_17GXWF9zhHrxnXNBjhA

In ControlCourses, Agassiz H1 is 1CUmztXwxcaRfz_0yDv5LJyN_17GXWF9zhHrxnXNBjhA, so it is the same. If we run the code again, though, it would recreate this.

However, in website, the quiz link is different! There is one response from me on April 13. https://forms.gle/Ek3b9YHReH9tMoKSA Oh no it's fine it is the short link.

Report abuse