Tool to plot google form data as a radar graph. Data collected with a google form, manipulated with Sheetsee.js, and visualized by D3.js.
- Create a google form input type "Grid" to collect information from students. See above for an example.
- The form must have "allow users to edit their responses" enabled.
- Collect Data
- In the form output, create a sheet named
Summaryand have it transfer summary information you'd like to plot. This will be made public, so it shouldn't have identifiable information (other than an obscured unique identifier). See above for an example.
- Share publically the one sheet of the google spreadsheet you don't mind being public. instructions
- Set up your index.html file from this repository. This file has instructions at the top to configure the file.
Example of Use
- Example google form that students fill out
- Example form output as a google spreadsheet
- Images above show the ouput
Publishing the File
I recommend publishing this on google drive, since that's a very quick and easy way to host/share a file this lightweight. see Google's instructions. Any other server would be good too, of course.
Sending the form to students
Here's an example email with instructions
Please do the following: 1. Take this skills evaluation <link> 2. Save the “Edit your responses” link that appears after you submit (in your bookmarks or email). This is how you will keep track of what you know/don’t know. Don’t lose it!
Distributing the Visualization Links
There are at least two ways
- Use mail merge to send links to the students
- Tell the students their usernumbers and let them construct the links themselves.
I'm happy to accept pull requests of course :)
The hard part is that local html files can't easily use local js files like it needs to? (was this my problem?) But if you host it to google drive it syncs in seconds and then can import the relevant js files.
- Data is collected with a google form
- Data is stored in a google spreadsheet
- Data is coerced and averaged in a google spreadsheet
- Data is imported to an HTML file via Sheetsee.js
- Data is visualized in the HTML file using D3.js
- Links to the many visualizations are shared manually.
- The google spreadsheet output could auto-calculate the groups somehow. Headers from "grid" type google input get headers like
UnixSection[mv, cp, pwd]. There is probably a clever google sheets equation that could automatically do this.
- Automatically email the result link after submission (maybe via a google script)
- The D3.js part could probably pretty easily be made to be fork-n-go or a module to be used with google spreadsheets data more generally.
D3.js Radar Chart example taken from here