Class Data Visualization

Elementary Data Visualization (Scores using 4 – 1 Scale)

Dashboard Instructions

Prior to using this data dashboard, you will need to export your Canvas grade book as a CSV (comma-separated value) file, or create a PowerTeacher Pro report in Excel format. The PowerTeacher Pro report will need to be converted to a CSV file using Google Sheets or a site like CloudConvert's Excel to CSV. This file will be uploaded as the CSV data source.

This data visualization is for teachers using the 4, 3, 2, 1 standards-based grading scale.

Prompt

Code a data visualization dashboard in html, css, and javascript and make it self-contained, complete, and embeddable. Use the csv file previously 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. 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. 4 is Tier 1, 3 is Tier 2, 2 is Tier 3, and 1 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.

Iteration

Can you adjust the colors on the individual graphs to reflect the color scheme with blue for 4, green for 3, yellow for 2 and red for 1?

Secondary Data Visualization (Scores as Percents)

This data visualization is for teachers using the percents-based grading scale.

Prompt

Create a new version of the data dashboard with the following parameters for grading: Tier 1 = scores of 90 to 100, Tier 2 = scores of 80 to 89.99, Tier 3 = scores of 60 to 79.99, and Tier 4 = scores of 0 to 59.99.