We need to provide a report detailing the number of users accessing teaching resources and the number of teaching resources accessed for all of the SEL Lesson Areas.
General Concept
Design
When the user is on the Lessons tab and selects Social Emotional Learning in the drop down, they will see a table detailing usage 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
Lesson Videos (Educators)
Lesson Plans
Lesson Materials
Lesson Videos (Students)
Activities
Quizzes
Each column will be split into Users | Activities or Students | Activities
If the user clicks on the numbers within a column, they will see a pop-up listing the names of the users/students who accessed the activities for that domain.
The user needs to be able to sort the list by any column
Business Rules
This report will be available if any of the selected filter options have access to SEL lessons
Grade
We will default the grade filter to All Grades.
This filter is a single select filter.
Selecting a grade will filter to show usage based on the grade associated with the lesson (for educator columns) or grade of the student (for student columns)
Tier 3 lessons will be counted under each grade encompassed in the grade band. For example, a PK-2 lesson will be counted when filter is set to Pre-K, Kindergarten, Grade 1, or Grade 2.
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. Users | Activities) need to remain static as a user scrolls down the page
Lesson Videos (Educators)
We will show Users | Videos
Users will show the number of users who accessed a lesson video for the specified domain/grade
Videos will show the total number of videos accessed for that domain/grade
We will count videos watched from the libraries or from the learning plan (any tab)
If a user clicks on the numbers in this column, we will see a list of all users who accessed the lesson videos for this domain/grade within the date range.
Users should be listed alphabetically by last name but names should be written First Name Last Name
Lesson Plans
We will show Users | Plans
Users will show the number of unique users who accessed a lesson plan for the specified domain/grade
Plans will show the total number of lesson plans accessed for that domain/grade
We will count lesson plans viewed from the libraries or from the learning plan (any tab)
If a user clicks on the numbers in this column, we will see a list of all users who accessed the lesson plans for this domain/grade within the date range.
Users should be listed alphabetically by last name but names should be written First Name Last Name
Lesson Materials
We will show Users | Materials
Users will show the number of unique users who accessed a lesson materials for the specified domain/grade
Materials will show the total number of lesson materials accessed for that domain/grade
We will count materials viewed from the libraries, my resources, or the learning plan (any tab).
If a user clicks on the numbers in this column, we will see a list of all users who accessed the lesson materials for this domain/grade within the date range.
Users should be listed alphabetically by last name but names should be written First Name Last Name
Lesson Videos (Students)
We will show Students | Videos
Students will show the number of unique students who viewed a video for the specified domain/grade
Videos will show the total number of videos viewed for that domain
If a user clicks on the numbers in this column, we will see a list of all students who viewed the lesson videos for this domain/grade within the date range.
Students should be listed alphabetically by last name but names should be written First Name Last Name
Activities
We will show Students | Activities
Students will show the number of unique students who completed an activity for the specified domain/grade
Activities will show the total number of activities completed for that domain/grade
If a user clicks on the numbers in this column, we will see a list of all students who viewed the lesson activities for this domain/grade within the date range.
Students should be listed alphabetically by last name but names should be written First Name Last Name
Quizzes
We will show Students | Quizzes
Students will show the number of unique students who completed a quiz for the specified domain/grade
Quizzes will show the total number of quizzes completed for that domain/grade
If a user clicks on the numbers in this column, we will see a list of all students who completes a quiz for this domain/grade within the date range.
Students should be listed alphabetically by last name but names should be written First Name Last Name
Export/Print
When the user clicks the export button, we will export the data for the currently viewed tab
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 Lesson Domains Accessed 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 team members/students who accessed the given activity for the given domain/grade.
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
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 team member or student licenses.
We will calculate usage for all team members/students active within the date range
Lesson Videos
Users will show the number of users at the district or any of the child accounts the user has access to who accessed a lesson video for the specified domain/lesson grade within the date range
Videos will show the total number of videos accessed at the district or any of the district’s child accounts the user has access to for that domain/lesson grade within the date range
If a user clicks on the numbers in this column, we will see a list of all team members at the district or any of the district’s child accounts the user has access to who viewed the lesson videos for this domain/lesson grade within the date range.
Users should be listed alphabetically by last name but names should be written First Name Last Name
Lesson Plans
Users will show the number of unique users at the district or any of the district’s child accounts the user has access to who viewed a lesson plan for the specified domain/lesson grade within the date range
Plans will show the total number of lesson plans accessed for that domain/lesson grade by users at the district or any of the district’s child accounts the user has access to within the date range
If a user clicks on the numbers in this column, we will see a list of all users at the district or any of the district’s child accounts the user has access to who accessed the lesson plans for this domain/lesson grade within the date range.
Lesson Materials
Users will show the number of unique team members at the district or any of the district’s child accounts the user has access to who accessed a lesson material for the specified domain/lesson grade within the date range
Materials will show the total number of lesson materials accessed for that domain/lesson grade within the date range by users at the district or any of the district’s child accounts the user has access to
If a user clicks on the numbers in this column, we will see a list of all users at the district or any of the district’s child accounts who accessed the lesson materials for this domain/lesson grade within the date range.
Lesson Videos (Students)
Students will show the number of unique students in the selected grade at any of the buildings the user has access to who viewed a video for the specified domain within the date range
Videos will show the total number of videos viewed by students in the selected grade for that domain at any of the buildings the user has access to within the date range
If a user clicks on the numbers in this column, we will see a list of all students in the selected grade who viewed a video for this domain at any of the buildings the user has access to within the date range.
Activities
Students will show the number of unique students in the selected grade at any of the buildings the user has access to who completed an activity for the specified domain within the date range
Activities will show the total number of activities completed by students in the selected grade for that domain at any of the buildings the user has access to within the date range
If a user clicks on the numbers in this column, we will see a list of all students in the selected grade who completed an activity for this domain at any of the buildings the user has access to within the date range.
Quizzes
Students will show the number of unique students in the selected grade at any of the buildings the user has access to who completed a quiz for the specified domain within the date range
Quizzes will show the total number of quizzes completed by students in the selected grade for that domain at any of the buildings the user has access to within the date range
If a user clicks on the numbers in this column, we will see a list of all students in the selected grade who completed a quiz for this domain at any of the buildings the user has access to within the date range.
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 Lessons for INSERT GRADE by Topic for INSERT FILTER START DATE to INSERT FILTER END DATE
We 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 team member or student licenses.
We will calculate usage for all team members/students active at the selected region within the date range
Multi-account team members will be counted under each region in which they belonged within the date range.
If Team Member A belongs to Region A in September and views 3 videos and moves to Region B in October and views 0 videos, we will count the 3 videos under Region A and the 0 videos under Region B. This is also true for Students.
If Student A is in Grade 3 in August and viewed 3 videos and then moved to Grade 4 in September and viewed 4 videos, we will count the 3 videos under Grade 3 and the 4 videos under Grade 4.
Lesson Videos
Users will show the number of users at the region or any of the region’s child accounts the user has access to who viewed a lesson video for the specified domain/lesson grade within the date range
Videos will show the total number of videos accessed at the region or any of the region’s child accounts the user has access to for that domain/lesson grade within the date range
If a user clicks on the numbers in this column, we will see a list of all team members at the region or any of the region’s child accounts the user has access to who viewed the lesson videos for this domain/lesson grade within the date range.
Lesson Plans
Users will show the number of unique users at the region or any of the region’s child accounts the user has access to who viewed a lesson plan for the specified domain/lesson grade
Plans will show the total number of lesson plans accessed for that domain/lesson grade by users at the region or any of the region’s child accounts the user has access to
If a user clicks on the numbers in this column, we will see a list of all users at the region or any of the region’s child accounts the user has access to who viewed a lesson plan for this domain/lesson grade within the date range.
Lesson Materials
Users will show the number of unique team members at the region or any of the region’s child accounts the user has access to who accessed a lesson material for the specified domain/lesson grade within the date range
Materials will show the total number of lesson materials accessed for that domain/lesson grade within the date range by users at the region or any of the region’s child accounts the user has access to
If a user clicks on the numbers in this column, we will see a list of all users at the region or any of the region’s child accounts who accessed the lesson materials for this domain/lesson grade within the date range.
Lesson Videos (Students)
Students will show the number of unique students in the selected grade at any of the region’s child accounts the user has access to who viewed a lesson video for the specified domain within the date range
Videos will show the total number of videos viewed by students in the selected grade for that domain at any of the region’s child accounts the user has access to within the date range
If a user clicks on the numbers in this column, we will see a list of all students in the selected grade who viewed a video for this domain at any of the region’s child accounts the user has access to within the date range
Activities
Students will show the number of unique students in the selected grade at any of the region’s child accounts the user has access to who completed an activity for the specified domain within the date range
Activities will show the total number of activities completed by students in the selected grade for that domain at any of the region’s child accounts the user has access to within the date range
If a user clicks on the numbers in this column, we will see a list of all students in the selected grade who completed an activity for this domain at any of the region’s child accounts the user has access to within the date range
Quizzes
Students will show the number of unique students in the selected grade at any of the region’s child accounts the user has access to who completed a quiz for the specified domain within the date range
Activities will show the total number of quizzes completed by students in the selected grade for that domain at any of the region’s child accounts the user has access to within the date range
If a user clicks on the numbers in this column, we will see a list of all students in the selected grade who completed a quiz for this domain at any of the region’s child accounts the user has access to within the date range
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 Lessons for INSERT GRADE by Topic 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
Business Rules
This report will be available if any of the selected buildings have been allocated SEL SEL team member or student licenses.
We will calculate usage for all team members/students active at the selected building within the date range
Multi-account team members will be counted under each building in which they belonged within the date range.
If Team Member A belongs to Building A in September and views 3 videos and moves to Building B in October and views 0 videos, we will count the 3 videos under Building A and the 0 videos under Building B. This is also true for Students.
Lesson Videos
Users will show the number of users at the building who viewed a lesson video for the specified domain/lesson grade within the date range
Videos will show the total number of videos accessed by users at the building for that domain/lesson grade within the date range
If a user clicks on the numbers in this column, we will see a list of all team members at the building who viewed the lesson videos for this domain/lesson grade within the date range.
Lesson Plans
Users will show the number of unique users at the building who viewed a lesson plan for the specified domain/lesson grade
Plans will show the total number of lesson plans accessed for that domain/lesson grade by users at the building within the date range
If a user clicks on the numbers in this column, we will see a list of all users at the building who viewed a lesson plan for this domain/lesson grade within the date range.
Lesson Materials
Users will show the number of unique team members at the building who accessed a lesson material for the specified domain/lesson grade within the date range
Materials will show the total number of lesson materials accessed for that domain/lesson grade within the date range by users at the building
If a user clicks on the numbers in this column, we will see a list of all users at the building who accessed the lesson materials for this domain/lesson grade within the date range.
Lesson Videos (Students)
Students will show the number of unique students in the selected grade at the building who viewed a video for the specified domain within the date range
Videos will show the total number of videos viewed by students in the selected grade for that domain at the building within the date range
If a user clicks on the numbers in this column, we will see a list of all students in the selected grade who viewed a video for this domain at the building within the date range.
Activities
Students will show the number of unique students in the selected grade at the building who completed an activity for the specified domain within the date range
Activities will show the total number of activities completed by students in the selected grade for that domain at the building within the date range
If a user clicks on the numbers in this column, we will see a list of all students in the selected grade who completed an activity for this domain at the building within the date range.
Quizzes
Students will show the number of unique students in the selected grade at the building who completed a quiz for the specified domain within the date range
Activities will show the total number of quizzes completed by students in the selected grade for that domain at the building within the date range
If a user clicks on the numbers in this column, we will see a list of all students in the selected grade who completed a quiz for this domain at the building within the date range.
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 Lessons for INSERT GRADE by Topic 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 of the accounts the user has access to contain team members with the selected role have been allocated SEL SEL team member or student licenses.
We will calculate usage for all team members/students active at the within the date range
If Team Member A is assigned to Role A in September and views 3 videos and is reassigned to Role B in October and views 0 videos, we will count the 3 videos under Role A and the 0 videos under Role B.
Students will be counted under all roles in which they are assigned to team members with the selected role
Lesson Videos
Users will show the number of users assigned to the selected role at all accounts the user has access to who viewed a lesson video for the specified domain/lesson grade within the date range
Videos will show the total number of videos accessed by users assigned to the selected role at all accounts the user has access to for that domain/lesson grade within the date range
If a user clicks on the numbers in this column, we will see a list of all team members assigned to the selected role in all accounts the user has access to who viewed the lesson videos for this domain/lesson grade within the date range.
Lesson Plans
Users will show the number of unique users assigned to the selected role at all accounts the user has access to who viewed a lesson plan for the specified domain/lesson grade within the date range
Plans will show the total number of lesson plans accessed for that domain/lesson grade within the date range by all users with the selected role at all accounts the user has access to
If a user clicks on the numbers in this column, we will see a list of all users assigned to the selected role at all accounts the user has access to who viewed a lesson plan for this domain/lesson grade within the date range.
Lesson Materials
Users will show the number of unique team members assigned to the selected role at all accounts the user has access to who accessed a lesson material for the specified domain/lesson grade within the date range
Materials will show the total number of lesson materials accessed for that domain/lesson grade within the date range by users assigned to the selected role at all accounts the user has access to
If a user clicks on the numbers in this column, we will see a list of all users assigned to the selected role at all accounts the user has access to who viewed the lesson materials for this domain/lesson grade within the date range.
Lesson Videos (Students)
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 viewed a video for the specified domain within the date range
Activities will show the total number of videos viewed by students in the selected grade assigned to team members with the selected role at all buildings the user has access to for that domain within the 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 at all buildings the user has access to who viewed a video for this domain within the date range.
Activities
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 completed an activity for the specified domain within the date range
Activities will show the total number of activities completed by students in the selected grade assigned to team members with the selected role at all buildings the user has access to for that domain within the 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 at all buildings the user has access to who completed an activity for this domain within the date range.
Quizzes
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 completed a quiz for the specified domain within the date range
Activities will show the total number of quizzes completed by students in the selected grade assigned to team members with the selected role at all buildings the user has access to for that domain within the 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 at all buildings the user has access to who completed a quiz for this domain within the date range.
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 Lessons for INSERT GRADE by Topic 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
The grade filter will show, but the user will not be able to change the grade from All Grades
The team member columns on the report (i.e. Lesson Plans, Lesson Videos, and Lesson Materials) 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 accounts the user has access to contain the selected team members have been allocated SEL SEL team member or student licenses.
Grade filter will reset to All Grades and cannot be changed
We will calculate usage for all team members/students active at the within the date range
If Student A is assigned to Team Member A in September and views 3 videos and is reassigned to Team Member B in October and views 0 videos, we will count the 3 videos under Team Member A and the 0 videos under Team Member B.
Students will be counted under all team members to whom they are assigned within the date range
Lesson Videos
Users will show 1 if the selected team member viewed a lesson video for the selected domain within the date range. If not, we will show 0.
Videos will show the total number of videos accessed by the selected team member for that domain within the date range
Not clickable
Lesson Plans
Users will show 1 if the selected team member viewed a lesson plan for the selected domain within the date range. If not, we will show 0.
Plans will show the total number of lesson plans accessed for that domain within the date range by the selected team member
Not clickable
Lesson Materials
Users will show 1 if the selected team member viewed a lesson material for the selected domain within the date range. If not, we will show 0.
Materials will show the total number of lesson materials accessed for that domain within the date range by the selected team member
Not clickable
Lesson Videos (Students)
Students will show the number of unique students assigned to the selected team member in all buildings the user has access to who viewed a video for the specified domain within the date range
Videos will show the total number of videos viewed by students assigned to the selected team member at all buildings the user has access to for that domain within the 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 at all buildings the user has access to who viewed a video for this domain within the date range.
Activities
Students will show the number of unique students assigned to the selected team member in all buildings the user has access to who completed an activity for the specified domain within the date range
Activities will show the total number of activities completed by students assigned to the selected team member at all buildings the user has access to for that domain within the 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 at all buildings the user has access to who completed an activity for this domain within the date range.
Quizzes
Students will show the number of unique students assigned to the selected team member in all buildings the user has access to who completed a quiz for the specified domain within the date range
Quizzes will show the total number of quizzes completed by students assigned to the selected team member at all buildings the user has access to for that domain within the 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 at all buildings the user has access to who completed a quiz for this domain within the date range.
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 Lessons by Topic 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 grade filter will show, but the user will not be able to change the grade from All Grades
The team member columns will show NA
The student column on the report (i.e. Activities) 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 buildings that have been allocated SEL SEL student licenses.
We will calculate usage for all students active within the date range
Lesson Videos
Will show NA
Lesson Plans
Will show NA
Lesson Materials
Will show NA
Lesson Videos (Students)
Students will show 1 if the selected student viewed a video for the selected domain within the date range. If not, we will show 0.
Videos will show the total number of videos viewed by the selected student for that domain within the date range
Not clickable
Activities
Students will show 1 if the selected student completed an activity for the selected domain within the date range. If not, we will show 0.
Activities will show the total number of activities completed by the selected student for that domain within the date range
Not clickable
Quizzes
Students will show 1 if the selected student completed a quiz for the selected domain within the date range. If not, we will show 0.
Quizzes will show the total number of quizzes completed by the selected student for that domain within the date range
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 Lessons by Topic for INSERT FILTER START DATE to INSERT FILTER END DATE
We will show a subtitle listing the name of the student
