We need to show the number of targets, objectives, and goals mastered for each of the sel lesson areas.
User Story:
As an admin, I want to see the quiz average for each lesson area, so I can ensure our students understand the SEL topics
🚩 Acceptance Criteria:
DESIGN: https://www.figma.com/file/gdwMnbpudJxuzVrORrOGvd/Ed-Member-Site-UX?node-id=3839%3A402
General Concept
Design
When the user is on the Progress tab and selects Social Emotional Learning in the drop down, they will see a table detailing quiz averages for SEL.
We will also show a filter for Grade. The grades available are:
All Grades
EI
Pre-K
Kindergarten
Grade 1
Grade 2
Grade 3
Grade 4
Grade 5
Grade 6
Grade 7
Grade 8
Grade 9
Grade 10
Grade 11
Grade 12
NA
We will show a tab for each region/building/role/team member selected
The table will show a row for each of the 5 lesson domains:
All Domains
Awareness of Self & Others
Self-Management
Social Skills
Social Awareness
Self-Care
And a column for
Quiz Average
For each domain, we will show a button to expand. Clicking this button will reveal a row for each lesson area within the domain. Clicking this button again will collapse this view
The user needs to be able to sort the list by any column
If the user clicks on the numbers within a column, they will see a pop-up listing the names of the students in the selected grade who completed a SEL quiz for that domain/area, as well as each students' average quiz score for that domain/area
Business Rules
This report will be available if any of the selected filter options have access to SEL lessons
By default, we will sort alphabetically by domain. However, users should be able to sort by any column
All Domains row will show the number of unique students who completed a quiz from any domain and the average quiz score across all domains, based on filter selections
The columns and sub-columns (i.e. Students | Average) need to remain static as a user scrolls down the page
Any cell with 0 or NA will not be clickable.
Grade
We will default the grade filter to All Grades.
This filter is a single select filter.
Selecting a grade will filter to show quiz average based on the grade of the students
By default, we will sort alphabetically by domain. However, users should be able to sort by any column
The columns and sub-columns (i.e. Students | Targets) need to remain static as a user scrolls down the page
Quiz Average
We will show the average score for quizzes completed within the domain/area within the specified date range
All domains will show the average quiz score for all domains, based on filter settings
If a user clicks on the number in this column, we will see a list of all students in the selected grade who completed a quiz for that domain/area within the date range and the average score the student received for all tests completed for that domain/area
This column will not be clickable at the district, region, or student level
Export/Print
Main Report
Export
When the user clicks the export button, we will export the data for all tabs (using tabs in Excel)
Print
When the user clicks the print button, we will print based on the currently viewed tab
We will print the table as shown on the screen based on selections
We will not print the filters, side panel, pill tabs, or drop-down menu
We will show a title on the report of Social Emotional Learning Quiz Average for INSERT GRADE by Domain from INSERT FILTER START DATE to INSERT FILTER END DATE
We will show a sub-title detailing the filter selections
Pop-Up Modal
We will export the full list of students who completed at least 1 quiz, based on filter selections
For each student, we will show their average score per domain/lesson area
We will print the report as it shows in the modal
🚩 District
Design
When filtered by district, we will show all results on one screen. There will be no tabs
Clicking on Export will export the data to Excel or CSV
Clicking on Print will print the report
Cells will not be clickable & Pop-Up Modal will not exist
Business Rules
This report will be available if the district or any of it’s child accounts the user has access to have been allocated SEL SEL student licenses.
We will calculate progress for all students active within the date range
Targets Mastered
This column will only show if any of theQuiz Average
We will show the average score for quizzes completed by students in all buildings in the district the user has access to ALSO have access to Skills
Students will show the number of unique students in the selected grade in all buildings in the district the user has access to who mastered a target for a lesson in the domain within the specified date range
Targets will show the number of targets mastered for lessons within the domain by all students in the selected grade in all buildings in the district the user has access to within the specified date range.
If a user clicks on the numbers in this column, we will see a list of all students in the selected grade in all buildings in the district the user has access to who mastered a target for this domain within the date range.
Objectives Mastered
This column will only show if any of the buildings in the district the user has access to ALSO have access to Skills
Students will show the number of unique students in the selected grade in all buildings in the district the user has access to who mastered an objective for a lesson in the domain within the specified date range
Objectives will show the number of objectives mastered for lessons within the domain by all students in the selected grade in all buildings in the district the user has access to within the specified date range.
If a user clicks on the numbers in this column, we will see a list of all students in the selected grade in all buildings in the district the user has access to who mastered an objective for this domain within the date range.
Goals Mastered
This column will only show if any of the buildings in the district the user has access to ALSO have access to Skills
Students will show the number of unique students in the selected grade in all buildings in the district the user has access to who mastered a goal for a lesson in the domain within the specified date range
Goals will show the number of goals mastered for lessons within the domain by all studentsin the selected grade in all buildings in the district the user has access to within the specified date range.
If a user clicks on the numbers in this column, we will see a list of all students in the selected grade in all buildings in the district the user has access to who mastered a goal for this domain within the date range.
Quiz Average
We will show the % of correct answers for quizzes within the domain within the specified date range for all students in the selected grade in all buildings the user has access to
We will calculate % of correct answers as questions correct/questions attempted x 100
This calculation is based on domain and grade of the student
This column will within the domain/area/grade within the specified date range
This column will not be clickable
Export/Print
Export
We will export the data as it is displayed on the screen.
Print
We will not print the filter, side panel, or pill tabs
Print in landscape
Show logo at top of page
Table should fill the page
Same as above
We will show a title of Social Emotional Learning Progress for INSERT GRADE by Domain for INSERT FILTER START DATE to INSERT FILTER END DATEWe will show a subtitle listing the name of the district
🚩 Region
Design
When filtered by region, we will show a tab for each selected region
When the user clicks on a tab for a particular region, they will view the report for that region only
Clicking on Export will export the data to Excel or CSV
Clicking on Print will print the report
Business Rules
This report will be available if any of the selected regions or any of their child accounts the user has access to have been allocated SEL SEL student licenses.
We will calculate progress for all students active at the selected region within the date range
If Student A belongs to Region A in September and mastered 3 targets and moves to Region B in October and masters 0 targets, we will count the 3 targets under Region A and the 0 targets under Region B.
Targets Mastered
This column will only show if any of the buildings in the region the user has access to ALSO have access to Skills
Students will show the number of unique students in the selected grade in all buildings in the region the user has access to who mastered a target for a lesson in the domain within the specified date range
Targets will show the number of targets mastered for lessons within the domain by all students in the selected grade in all buildings in the region the user has access to within the specified date range.
If a user clicks on the numbers in this column, we will see a list of all students in the selected grade in all buildings in the region the user has access to who mastered a target for this domain within the date range.
Objectives Mastered
This column will only show if any of the buildings in the region the user has access to ALSO have access to Skills
Students will show the number of unique students in the selected grade in all buildings in the region the user has access to who mastered an objective for a lesson in the domain within the specified date range
Objectives will show the number of objectives mastered for lessons within the domain by all students in the selected grade in all buildings in the region the user has access to within the specified date range.
If a user clicks on the numbers in this column, we will see a list of all students in the selected grade in all buildings in the region the user has access to who mastered an objective for this domain within the date range.
Goals Mastered
This column will only show if any of the buildings in the region the user has access to ALSO have access to Skills
Students will show the number of unique students in the selected grade in all buildings in the region the user has access to who mastered a goal for a lesson in the domain within the specified date range
Goals will show the number of goals mastered for lessons within the domain by all students in the selected grade in all buildings in the region the user has access to within the specified date range.
If a user clicks on the numbers in this column, we will see a list of all students in all buildings in the region the user has access to who mastered a goal for this domain/grade within the date range.
Quiz Average
We will show the % of correct answers for quizzes within the domain within the specified date range for all students in the selected grade in all of the region’s buildings the user has access to
We will calculate % of correct answers as questions correct/questions attempted x 100
This calculation is based on domain and grade of the student
This column will not be clickable
Export/Print
We will export the data as it is displayed on the screen.
Print
We will not print the filter, side panel, or pill tabs
Print in landscape
Show logo at top of page
Table should fill the page
We will show a title of Social Emotional Learning Progress for INSERT GRADE by Domain for INSERT FILTER START DATE to INSERT FILTER END DATE
We will show a subtitle listing the name of the region
Building
Design
When filtered by building, we will show a tab for each selected building
When the user clicks on a tab for a particular building, they will view the report for that building only
Clicking on Export will export the data to Excel or CSV
Clicking on Print will print the report
When the user clicks on the quiz column, the modal will show the names of the students who completed the quiz and each student’s quiz average for that domain
Business Rules
This report will be available if any of the selected buildings have been allocated SEL SEL student licenses.
We will calculate progress for all students active at the selected building within the date range
If Student A belongs to Building A in September and mastered 3 targets and moves to Building B in October and masters 0 targets, we will count the 3 targets under Building A and the 0 targets under Building B.
Targets Mastered
This column will only show if the selected building ALSO has access to Skills
Students will show the number of unique students in the selected grade in the selected building who mastered a target for a lesson in the domain within the specified date range
Targets will show the number of targets mastered for lessons within the domain by all students in the selected grade in the selected building within the specified date range.
If a user clicks on the numbers in this column, we will see a list of all students in the selected grade in the selected building who mastered a target for this domain within the date range.
Objectives Mastered
This column will only show if the selected building ALSO has access to Skills
Students will show the number of unique students in the selected grade in the selected building who mastered an objective for a lesson in the domain within the specified date range
Objectives will show the number of objectives mastered for lessons within the domain by all students in the selected grade in the selected building within the specified date range.
If a user clicks on the numbers in this column, we will see a list of all students in the selected grade in the selected building who mastered an objective for this domain within the date range.
Goals Mastered
This column will only show if the selected building ALSO has access to Skills
Students will show the number of unique students in the selected grade in the selected building to who mastered a goal for a lesson in the domain within the specified date range
Goals will show the number of goals mastered for lessons within the domain by all students in the selected grade in the selected building within the specified date range.
If a user clicks on the numbers in this column, we will see a list of all students in the selected grade in the selected building who mastered a goal for this domain within the date range
Quiz Average
We will show the % of correct answers for quizzes within the domain within the specified date range for all students in the selected grade in the selected building
We will calculate % of correct answers as questions correct/questions attempted x 100
This calculation is based on domain and grade of the student
If a user clicks on the number in this column, we will see a list of all students in the building in the selected grade who completed a quiz for that domain within the date range and the average score the student received. We will calculate % of correct answers as questions correct for all quizzes taken by the student for the domain within the date range/questions attempted for all quizzes taken by the student for the domain within the date range x 100
Export/Print
We will export the data as it is displayed on the screen.
Print
We will not print the filter, side panel, or pill tabs
Print in landscape
Show logo at top of page
Table should fill the page
We will show a title of Social Emotional Learning Progress for INSERT GRADE by Domain for INSERT FILTER START DATE to INSERT FILTER END DATE
We will show a subtitle listing the name of the building
Role
Design
When filtered by role, we will show a tab for each selected role
When the user clicks on a tab for a particular role, they will view the report for that role only
Clicking on Export will export the data to Excel or CSV
Clicking on Print will print the report
Business Rules
This report will be available if any users with the selected roles belong to a building that has been allocated SEL SEL student licenses.
We will calculate progress for all students active who are assigned to users with the selected role within the date range
If Student A is assigned to a team member with Role A in September and mastered 3 targets and is reassigned to a team member with Role B in October and masters 0 targets, we will count the 3 targets under Role A and the 0 targets under Role B.
Targets Mastered
This column will only show if any users with the selected role ALSO have access to Skills
Students will show the number of unique students in the selected grade assigned to team members with the selected role in all buildings the user has access to who mastered a target for a lesson in the domain within the specified date range
Targets will show the number of targets mastered for lessons within the domain by all students in the selected grade assigned to team members with the selected role in all buildings the user has access to within the specified date range.
If a user clicks on the numbers in this column, we will see a list of all students in the selected grade assigned to team members with the selected role in all buildings the user has access to who mastered a target for this domain within the date range.
Objectives Mastered
This column will only show if any users with the selected role ALSO have access to Skills
Students will show the number of unique students in the selected grade assigned to team members with the selected role in all buildings the user has access to who mastered an objective for a lesson in the domain within the specified date range
Objectives will show the number of objectives mastered for lessons within the domain by all students in the selected grade assigned to team members with the selected role in all buildings the user has access to within the specified date range.
If a user clicks on the numbers in this column, we will see a list of all students in the selected grade assigned to team members with the selected role in all buildings the user has access to who mastered an objective for this domain within the date range.
Goals Mastered
This column will only show if any users with the selected role ALSO have access to Skills
Students will show the number of unique students in the selected grade assigned to team members with the selected role in all buildings the user has access to to who mastered a goal for a lesson in the domain within the specified date range
Goals will show the number of goals mastered for lessons within the domain by all students in the selected grade assigned to team members with the selected role in all buildings the user has access to within the specified date range.
If a user clicks on the numbers in this column, we will see a list of all students in the selected grade assigned to team members with the selected role in all buildings the user has access to who mastered a goal for this domain within the date range.
Quiz Average
We will show the % of correct answers for quizzes within the domain within the specified date range for all students in the selected grade assigned to team members with the selected role in all buildings the user has access to
We will calculate % of correct answers as questions correct/questions attempted x 100
This calculation is based on domain and grade of the student
This column will not be clickable
Export/Print
We will export the data as it is displayed on the screen.
Print
We will not print the filter, side panel, or pill tabs
Print in landscape
Show logo at top of page
Table should fill the page
We will show a title of Social Emotional Learning Progress for INSERT GRADE by Domain for INSERT FILTER START DATE to INSERT FILTER END DATE
We will show a subtitle listing the name of the role
Team Member
Design
When filtered by team member, we will show a tab for each selected team member
When the user clicks on a tab for a particular team member, they will view the report for that team member only
Clicking on Export will export the data to Excel or CSV
Clicking on Print will print the report
When the user clicks on the quiz column, the modal will show the names of the students who completed the quiz and each student’s quiz average for that domain
Business Rules
This report will be available if any of the selected team members belong to a building that has been allocated SEL SEL student licenses.
We will calculate progress for all students active who are assigned to the selected team member within the date range
If Student A is assigned to a team member A in September and mastered 3 targets and is reassigned to a team member B in October and masters 0 targets, we will count the 3 targets under Team Member A and the 0 targets under Team Member B.
Targets Mastered
This column will only show if the selected team member ALSO has access to Skills
Students will show the number of unique students assigned to the selected team member in all buildings the user has access to who mastered a target for a lesson in the domain within the specified date range
Targets will show the number of targets mastered for lessons within the domain by all students assigned to the selected team member in all buildings the user has access to within the specified date range.
If a user clicks on the numbers in this column, we will see a list of all students assigned to the selected team member in all buildings the user has access to who mastered a target for this domain within the date range.
Objectives Mastered
This column will only show if the selected team member ALSO has access to Skills
Students will show the number of unique students assigned to the selected team member in all buildings the user has access to who mastered an objective for a lesson in the domain within the specified date range
Objectives will show the number of objectives mastered for lessons within the domain by all students assigned to the selected team member in all buildings the user has access to within the specified date range.
If a user clicks on the numbers in this column, we will see a list of all students assigned to the selected team member in all buildings the user has access to who mastered an objective for this domain within the date range.
Goals Mastered
This column will only show if the selected team member ALSO has access to Skills
Students will show the number of unique students assigned to the selected team member in all buildings the user has access to to who mastered a goal for a lesson in the domain within the specified date range
Goals will show the number of goals mastered for lessons within the domain by all students assigned to the selected team member in all buildings the user has access to within the specified date range.
If a user clicks on the numbers in this column, we will see a list of all students assigned to the selected team member in all buildings the user has access to who mastered a goal for this domain within the date range.
Quiz Average
We will show the % of correct answers for quizzes within the domain within the specified date range for all students assigned to the selected team member in all buildings the user has access to
We will calculate % of correct answers as questions correct/questions attempted x 100
This calculation is based on domain
If a user clicks on the number in this column, we will see a list of all students assigned to the selected team member in all buildings the user has access to who completed a quiz for that domain within the date range and the average score the student received. We will calculate % of correct answers as questions correct for all quizzes taken by the student for the domain within the date range/questions attempted for all quizzes taken by the student for the domain within the date range x 100
Export/Print
We will export the data as it is displayed on the screen.
Print
We will not print the filter, side panel, or pill tabs
Print in landscape
Show logo at top of page
Table should fill the page
We will show a title of Social Emotional Learning Progress by Domain for INSERT FILTER START DATE to INSERT FILTER END DATE
We will show a subtitle listing the name of the team member
Student
Design
When filtered by student, we will show a tab for each selected student
When the user clicks on a tab for a particular student, they will view the report for that student only
The student columns on the report will not be clickable
Clicking on Export will export the data to Excel or CSV
Clicking on Print will print the report
Business Rules
This report will be available if any of the selected students belong to a building that has been allocated SEL SEL student licenses.
We will calculate progress for all of the selected students active within the date range
Grade filter will reset to All Grades and cannot be changed
Targets Mastered
This column will only show if the selected student belongs to a building that ALSO has access to Skills
Students will show 1 if the student has mastered any targets for the selected domain within the date range. If not, we will show 0.
Targets will show the number of targets mastered for lessons within the domain by the selected student within the specified date range.
This is not clickable
Objectives Mastered
This column will only show if the selected student belongs to a building that ALSO has access to Skills
Students will show 1 if the student has mastered any objectives for the selected domain within the date range. If not, we will show 0.
Objectives will show the number of objectives mastered for lessons within the domain by the selected student within the specified date range.
This is not clickable
Goals Mastered
This column will only show if the selected student belongs to a building that ALSO has access to Skills
Students will show 1 if the student has mastered any goals for the selected domain within the date range. If not, we will show 0.
Goals will show the number of goals mastered for lessons within the domain by the selected student within the specified date range.
This is not clickable
Quiz Average
We will show the % of correct answers for quizzes within the domain within the specified date range for the selected student
We will calculate % of correct answers as questions correct/questions attempted x 100
This calculation is based on domain
This is not clickable
Export/Print
We will export the data as it is displayed on the screen.
Print
We will not print the filter, side panel, or pill tabs
Print in landscape
Show logo at top of page
Table should fill the page
We will show a title of Social Emotional Learning Progress by Domain for INSERT FILTER START DATE to INSERT FILTER END DATE
We will show a subtitle listing the name of the student
