To use this data visualization, you will need a downloaded CSV file. You can get this by exporting your Canvas grade book. You can also create a report in PowerTeacher Pro, saving it as an Excel file, and importing to Google Slides and downloading the CSV or by using Cloud Convert to generate the CSV file.
This data visualization is for teachers using raw scores with varying point values.
Prompt
Code a data visualization dashboard in html, css, and javascript and make it self-contained, complete, and embeddable. Use the csv file uploaded as the source for the data. This dashboard is for a teacher to be able to dive deeply into the data contained in the spreadsheet and to be able to form individual, small group, and whole group instruction, response to intervention groups, and enrichment groups for advanced students. It should also show any data trends and be able to show students who are struggling. The header row will be important to know the possible points for every score. You will divide the each student's score by the points possible and convert the resulting decimal into a percent prior to manipulating the data in the respective graphs. The data visualization dashboard should be able to accurately graph student performance in vertical or horizontal bar graph form. Create user selectable fields for the following data visualizations: RTI Groups for any user selectable assignment including students whose score is 4 shown in blue, students whose score is 3 shown in green, students whose score is 2 shown in yellow, and students whose score is 1 shown in red grouped by score. 90 to 100 is Tier 1, 80 to 89.99 is Tier 2, 60 to 79.99 is Tier 3, and 0 to 59.99 is Tier 4; class average for any assignment; individual student bar graphs across all assignments with assignments labeled on the x axis and scores shown graphed against the Y axis; bar graph of class performance on any given assignment with student names listed next to the bar associated with their score; line graph of user selection of any student's scores across all assignments. Make the theme navy blue, white, black, and gray.