Challenges discovered
Numerous people were given access to the
instruction statistics sheet so that they could
see the up-to-date instruction statistics. To
reduce confusion, we chose to “hide” the
spreadsheets (inside of the master instruction
statistics sheet) that held the importing-data.
We found that we couldn’t use the “download
as” feature to save the Instruction Statistics
report, as it saves a PDF with dozens of blank
pages at the end. Instead, to download a PDF
or to print the instruction statistics, we have to
go through these steps:
1. Open the Google Spreadsheet “Instruction
Statistics.”
2. Click on the “print” button (upper-left
hand corner).
3. In the first print dialog, set appearance
preferences. We recommend “No gridlines,”
“Actual size,” and “Portrait.”
4. In the second print dialog, choose to
print only pages 1-2. Print or choose “Save as
PDF” as the printer.
Finally, we realized that the instruction statistics
must be reset once a year by clearing out
the data from the previous year. We must clear
all the old responses to the forms (otherwise
they will show up in the stats for the next year)
by going into each Google Form, viewing the
responses, and clearing the old responses. We
highly recommend that the old responses be
saved rather than deleted.