- Customize correct and incorrect responses from a Google Form in Sheets: Format>Conditional Formating- Green and Red
- Add a Sparkline in one cell for a line graph of change over time.
- Motion Chart- animated for large data sets with many students.
- There are many advanced tools for data:Pivot table- under data
- =filter(D:F,C:C="studentname") when responses "StudentNames” are listed in column C on the Form Responses sheet. Columns D, E, and F have feedback.
Thursday, July 28, 2016
Advanced Training: Unit 4: Analyze and Interpret Student Data
Important take aways from this unit:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment