Data Visualation for Acadience Scores

Data Visualization for Acadience Scores

Before using this data visualization dashboard, be aware that your spreadsheet will need significant modification. I have included a CSV file for reference. It will most likely be faster to use conditional formatting rather than this data visualization dashboard. 

Reference File

The data visualization dashboard anticipates the spreadsheet with this row and column layout. The colors are based on conditional formatting rules and are not necessary for the AI tool to do its job. 

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 three header rows will be important to know the question number, the assessment standard, the students' names, points earned and points possible. 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 question and standard including students whose scores are 1 out of 1 or 2 out of 2 shown in blue, students who scored 1 out of 2 shown in yellow, and students who scored 0 out of 1 or 0 out of 2 shown in red grouped by score. Blue is Tier 1; Yellow is Tier 2; Red is Tier 3; class average for any standard; individual student bar graphs across all standards with standards labeled on the x axis and scores shown graphed against the Y axis; bar graph of class performance on any question standard with student names listed next to the bar associated with their score. Allow a user selection to also compare students by question number with the same parameters described for the standards. Make the theme navy blue, white, black, and gray.

Iteration

Remove any graphs for the points possible columns, but use the data to know the possible for the scores. Ensure that all students are graphed using the 0 is red, 1 out of 2 is yellow, and 1 out of 1 and 1 out of 2 are blue.

Iteration 2

Remove the Class Average by Standard graphing option. It's not useful. The Tier 1, Tier 2, and Tier 3 groups are not being populated by any student names. The teacher will not know which students fall into each category. Fix this.

Iteration 3

I have removed the points possible columns. Use only the columns remaining. The possible points are now included in header column. Adjust the graphs accordingly.

Iteration 4

Students who received a score of 0 on any given standard or question are not highlighted in the graph since their score doesn't show a bar. Devise a way to highlight them in red even though their score does not have a red bar graph bar.

Iteration 5

Remove Student Name from the group. It is a column header, not an actual participant in the assessments.