TEST TYPE: dashboard_functional

Title: TC_FUNC_01_Display_Overall_Stats
Scenario: Verify that the overall stats for the district are displayed correctly on the top of the page.
Steps to reproduce:
1. Log in as a district admin.
2. Navigate to the 'Reports' page.
3. Observe the overall stats section at the top of the page.
Expected Result: The overall stats section should display the total number of schools, users, students, logins, and activities for the district.
Actual Result: [To be filled during execution]
Priority: High

Title: TC_FUNC_02_Access_Schools_Comparison_Tab
Scenario: Verify that the 'Schools comparison' tab is accessible only to district admins.
Steps to reproduce:
1. Log in as a district admin.
2. Navigate to the 'Reports' page.
3. Locate the 'Schools comparison' tab.
4. Log out and log in as a teacher or school admin.
5. Navigate to the 'Reports' page.
Expected Result: The 'Schools comparison' tab should be visible only to district admins and not to teachers or school admins.
Actual Result: [To be filled during execution]
Priority: High

Title: TC_FUNC_03_Charts_Display_Correct_Data
Scenario: Verify that charts in the 'Schools comparison' tab display correct data based on selected filters.
Steps to reproduce:
1. Log in as a district admin.
2. Navigate to the 'Reports' page and select the 'Schools comparison' tab.
3. Apply a filter for a specific school year.
4. Observe the data in the charts.
Expected Result: The charts should display data corresponding to the selected school year filter.
Actual Result: [To be filled during execution]
Priority: High

Title: TC_FUNC_04_Drilldown_Functionality
Scenario: Verify the drilldown functionality from the 'Number of logins' chart to the 'Utilization' tab.
Steps to reproduce:
1. Log in as a district admin.
2. Navigate to the 'Reports' page and select the 'Schools comparison' tab.
3. Hover over a school in the 'Number of logins' chart.
4. Click on the 'View details' link in the popup.
Expected Result: The system should navigate to the 'Utilization' tab, focusing on the selected school's data.
Actual Result: [To be filled during execution]
Priority: High

Title: TC_FUNC_05_Export_Data_Functionality
Scenario: Verify the export data functionality for the 'Schools comparison' tab.
Steps to reproduce:
1. Log in as a district admin.
2. Navigate to the 'Reports' page and select the 'Schools comparison' tab.
3. Click on the 'Export data' option.
4. Confirm the export action.
Expected Result: The data should be exported to a CSV file with correct columns and totals, reflecting any applied filters.
Actual Result: [To be filled during execution]
Priority: Medium

Title: TC_FUNC_06_Filter_Application
Scenario: Verify that filters are applied to both charts and overview stats.
Steps to reproduce:
1. Log in as a district admin.
2. Navigate to the 'Reports' page.
3. Apply filters for a specific set of schools.
4. Observe the overview stats and charts.
Expected Result: Both the overview stats and charts should update to reflect the data for the selected schools.
Actual Result: [To be filled during execution]
Priority: High

Title: TC_FUNC_07_No_Data_Message_Display
Scenario: Verify that the 'No data available for the selected filters' message is displayed when applicable.
Steps to reproduce:
1. Log in as a district admin.
2. Navigate to the 'Reports' page.
3. Apply a date range filter that does not match any data.
Expected Result: A message stating 'No data available for the selected filters' should be displayed on the charts.
Actual Result: [To be filled during execution]
Priority: Medium

Title: TC_FUNC_08_Tab_Navigation
Scenario: Verify smooth navigation between different tabs in the dashboard.
Steps to reproduce:
1. Log in as a district admin.
2. Navigate to the 'Reports' page.
3. Click through each tab: 'Schools comparison', 'Utilization', 'Wellness check-ins', 'Student Assessments', 'Teacher Surveys'.
Expected Result: Navigation should be smooth, with each tab displaying the correct information without delays or errors.
Actual Result: [To be filled during execution]
Priority: Medium

Title: TC_FUNC_09_Translation_Verification
Scenario: Verify that the dashboard supports translations for available languages.
Steps to reproduce:
1. Log in as a district admin.
2. Change the language setting to French.
3. Navigate through the dashboard and verify text translations.
4. Repeat step 2 and 3 for Spanish.
Expected Result: All text in the dashboard should be translated correctly to the selected language.
Actual Result: [To be filled during execution]
Priority: Medium

Title: TC_FUNC_10_Hover_Interaction
Scenario: Verify that hovering over chart elements highlights data correctly.
Steps to reproduce:
1. Log in as a district admin.
2. Navigate to the 'Reports' page and select the 'Schools comparison' tab.
3. Hover over a bar in any chart to view the tooltip.
Expected Result: The school name and value should be highlighted, with other bars dimmed, and the 'View details' link should appear if applicable.
Actual Result: [To be filled during execution]
Priority: Low

Title: TC_FUNC_11_Custom_Date_Range_Filter
Scenario: Verify the functionality of the 'Custom date range' filter.
Steps to reproduce:
1. Log in as a district admin.
2. Navigate to the 'Reports' page and select the 'Schools comparison' tab.
3. Apply a 'Custom date range' filter.
4. Observe the data in the charts and overall stats.
Expected Result: The charts and overall stats should update to reflect the data for the selected custom date range.
Actual Result: [To be filled during execution]
Priority: Medium

Title: TC_FUNC_12_Default_School_Year_Selection
Scenario: Verify that the current school year is selected by default in the filter.
Steps to reproduce:
1. Log in as a district admin.
2. Navigate to the 'Reports' page and select the 'Schools comparison' tab.
3. Observe the default filter selection.
Expected Result: The current school year should be selected by default in the filter options.
Actual Result: [To be filled during execution]
Priority: Low

Title: TC_FUNC_13_Active_License_Schools_Display
Scenario: Verify that only schools with an active license are counted in the total number of schools.
Steps to reproduce:
1. Log in as a district admin.
2. Navigate to the 'Reports' page.
3. Apply filters to display schools.
4. Verify the total number of schools displayed.
Expected Result: The total number of schools should only include those with an active license for the selected filters.
Actual Result: [To be filled during execution]
Priority: High

Title: TC_FUNC_14_Mobile_Hover_Interaction
Scenario: Verify hover interaction equivalent on mobile devices.
Steps to reproduce:
1. Log in as a district admin on a mobile device.
2. Navigate to the 'Reports' page and select the 'Schools comparison' tab.
3. Tap on a data point in any chart.
Expected Result: Tapping a data point should highlight the school name and value, similar to hover interaction on desktop.
Actual Result: [To be filled during execution]
Priority: Low

Title: TC_FUNC_15_Overview_Cards_Filter_Application
Scenario: Verify that overview cards reflect the applied filters accurately.
Steps to reproduce:
1. Log in as a district admin.
2. Navigate to the 'Reports' page.
3. Apply various filters, including school and date range.
4. Observe the data in the overview cards.
Expected Result: Overview cards should update to show data relevant to the applied filters.
Actual Result: [To be filled during execution]
Priority: High

Title: TC_FUNC_16_Chart_Sorting_Order
Scenario: Verify that charts are sorted in descending order based on data values.
Steps to reproduce:
1. Log in as a district admin.
2. Navigate to the 'Reports' page and select the 'Schools comparison' tab.
3. Observe the order of bars in the charts.
Expected Result: All charts should display data in descending order based on the values.
Actual Result: [To be filled during execution]
Priority: Low

Title: TC_FUNC_17_Chart_List_View_Option
Scenario: Verify the list view option for charts when there are many schools.
Steps to reproduce:
1. Log in as a district admin.
2. Navigate to the 'Reports' page and select the 'Schools comparison' tab.
3. Ensure there are more schools than can fit on the screen.
4. Select the option to view charts in list view.
Expected Result: Charts should be displayed in a list view allowing for easy navigation through all schools.
Actual Result: [To be filled during execution]
Priority: Medium

Title: TC_FUNC_18_Data_Integrity_After_School_Change
Scenario: Verify data integrity when schools join or leave the district.
Steps to reproduce:
1. Log in as a district admin.
2. Navigate to the 'Reports' page.
3. Apply a date range filter that includes the period when a school joined or left.
4. Observe changes in charts and overall stats.
Expected Result: The data should accurately reflect the status of schools within the selected date range.
Actual Result: [To be filled during execution]
Priority: High

Title: TC_FUNC_19_UI_Scaling_For_Charts
Scenario: