TEST TYPE: dashboard_functional

Here are the functional test cases for the dashboard utilization tab based on the provided requirements:

---

**Title:** TC_FUNC_001_Validate_Utilization_Tab_Visibility  
**Scenario:** Verify that the utilization tab is visible to users with appropriate permissions.  
**Preconditions:** User is logged in with either admin or teacher role.  
**Steps to Reproduce:**  
1. Log in as a school admin.  
2. Navigate to the dashboard.  
3. Locate the utilization tab.  
4. Log out and log in as a teacher.  
5. Navigate to the dashboard again.  
**Expected Result:** The utilization tab is visible for admin users and hidden for teacher users.  
**Actual Result:** To be filled during execution  
**Priority:** High  
**Test Data:** User credentials for admin and teacher roles.  

---

**Title:** TC_FUNC_002_Validate_Utilization_Chart_Data  
**Scenario:** Ensure that the utilization charts display correct activity counts by activity type and user type.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Log in as a school admin.  
2. Navigate to the utilization tab.  
3. Select a specific month from the period filter.  
4. Observe the activity counts displayed in the charts.  
**Expected Result:** The charts should accurately reflect the activity counts for the selected month, categorized by activity type and user type.  
**Actual Result:** To be filled during execution  
**Priority:** High  
**Test Data:** Activity data for the selected month.  

---

**Title:** TC_FUNC_003_Validate_Stacked_Bar_Chart_Representation  
**Scenario:** Verify that the month-on-month activity counts are represented as a stacked bar graph.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Log in as a school admin.  
2. Navigate to the utilization tab.  
3. Select the month-on-month activity chart.  
**Expected Result:** The chart should display a stacked bar graph with each activity type represented in different colors.  
**Actual Result:** To be filled during execution  
**Priority:** High  
**Test Data:** Activity data for multiple months.  

---

**Title:** TC_FUNC_004_Validate_Activity_Type_Selection  
**Scenario:** Ensure that selecting an activity type filters the right chart data accordingly.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Log in as a school admin.  
2. Navigate to the utilization tab.  
3. Select a specific activity type from the left panel.  
4. Observe the right chart.  
**Expected Result:** The right chart should only display bars corresponding to the selected activity type.  
**Actual Result:** To be filled during execution  
**Priority:** High  
**Test Data:** Activity type data for filtering.  

---

**Title:** TC_FUNC_005_Validate_Month_on_Month_Logins_Chart  
**Scenario:** Verify that the month-on-month logins are displayed correctly in a line graph.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Log in as a school admin.  
2. Navigate to the utilization tab.  
3. Locate the month-on-month logins chart.  
**Expected Result:** The chart should accurately reflect the number of logins for each month on the x-axis and y-axis.  
**Actual Result:** To be filled during execution  
**Priority:** High  
**Test Data:** Login data for multiple months.  

---

**Title:** TC_FUNC_006_Validate_Leaderboard_Table_Visibility  
**Scenario:** Ensure that the leaderboard table is visible only to admin users.  
**Preconditions:** User is logged in as an admin or teacher.  
**Steps to Reproduce:**  
1. Log in as a school admin.  
2. Navigate to the utilization tab.  
3. Observe the leaderboard table.  
4. Log out and log in as a teacher.  
5. Navigate to the utilization tab again.  
**Expected Result:** The leaderboard table should be visible for admin users and hidden for teacher users.  
**Actual Result:** To be filled during execution  
**Priority:** High  
**Test Data:** User credentials for admin and teacher roles.  

---

**Title:** TC_FUNC_007_Validate_Leaderboard_Data  
**Scenario:** Verify that the leaderboard table displays correct user data.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Log in as a school admin.  
2. Navigate to the utilization tab.  
3. Observe the leaderboard table.  
**Expected Result:** The leaderboard should display the top 10 users with correct data in each field (Name, Number of students, Number of logins, Number of activities completed, Last login date).  
**Actual Result:** To be filled during execution  
**Priority:** High  
**Test Data:** User activity data.  

---

**Title:** TC_FUNC_008_Validate_Overview_Cards_Visibility_Admin  
**Scenario:** Ensure that overview cards are displayed correctly for admin users.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Log in as a school admin.  
2. Navigate to the utilization tab.  
3. Observe the overview cards displayed.  
**Expected Result:** All overview cards should be visible for admin users.  
**Actual Result:** To be filled during execution  
**Priority:** High  
**Test Data:** User credentials for admin role.  

---

**Title:** TC_FUNC_009_Validate_Overview_Cards_Visibility_Teacher  
**Scenario:** Ensure that overview cards are displayed correctly for teacher users.  
**Preconditions:** User is logged in as a teacher.  
**Steps to Reproduce:**  
1. Log in as a teacher.  
2. Navigate to the utilization tab.  
3. Observe the overview cards displayed.  
**Expected Result:** The 'Number of Schools' and 'Number of teachers/admins' cards should be hidden for teacher users.  
**Actual Result:** To be filled during execution  
**Priority:** High  
**Test Data:** User credentials for teacher role.  

---

**Title:** TC_FUNC_010_Validate_Filter_Functionality  
**Scenario:** Verify that the filters apply correctly to the overview cards and charts.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Log in as a school admin.  
2. Navigate to the utilization tab.  
3. Apply filters for School and Period.  
4. Observe the changes in overview cards and charts.  
**Expected Result:** The overview cards and charts should update to reflect the selected filters.  
**Actual Result:** To be filled during execution  
**Priority:** High  
**Test Data:** Filter selections for School and Period.  

---

**Title:** TC_FUNC_011_Validate_Export_Functionality_Activity_Completion  
**Scenario:** Ensure that the export functionality for activity completion works correctly.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Log in as a school admin.  
2. Navigate to the utilization tab.  
3. Click on the export button for activity completion.  
4. Save the .csv file.  
**Expected Result:** The .csv file should download successfully and contain the correct data for activity completion.  
**Actual Result:** To be filled during execution  
**Priority:** Medium  
**Test Data:** N/A  

---

**Title:** TC_FUNC_012_Validate_Export_Functionality_Number_of_Logins  
**Scenario:** Ensure that the export functionality for number of logins works correctly.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Log in as a school admin.  
2. Navigate to the utilization tab.  
3. Click on the export button for number of logins.  
4. Save the .csv file.  
**Expected Result:** The .csv file should download successfully and contain the correct data for number of logins.  
**Actual Result:** To be filled during execution  
**Priority:** Medium  
**Test Data:** N/A  

---

**Title:** TC_FUNC_013_Validate_Export_Functionality_Leaderboard  
**Scenario:** Ensure that the export functionality for the leaderboard works correctly.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Log in as a school admin.  
2. Navigate to the utilization tab.  
3. Click on the export button for the leaderboard.  
4. Save the .csv file.  
**Expected Result:** The .csv file should download successfully and contain the correct data for the leaderboard.  
**Actual Result:** To be filled during execution  
**Priority:** Medium  
**Test Data:** N/A  

---

**Title:** TC_FUNC_014_Validate_Overall_Tab_Export_Functionality  
**Scenario:** Verify that the overall tab export functionality works correctly.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Log in as a school admin.  
2. Navigate to the overall tab.  
3. Click on the export button for the overall data.  
4. Save the PDF file.  
**Expected Result:** The PDF file should download successfully and reflect the dashboard layout with applied filters.  
**Actual Result:** To be filled during execution  
**Priority:** Medium  
**Test Data:** N/A  

---

**Title:** TC_FUNC_015_Validate_Translation_Functionality  
**Scenario:** Ensure that the translation functionality works for all supported languages.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Log in as a school admin.  
2. Change the language setting to French.  
3. Navigate to the utilization tab and observe all labels.  
4. Change the language setting to Spanish.  
5. Navigate to the utilization tab and observe all labels.  
**Expected Result:** All labels should be correctly translated in French and Spanish.  
**Actual Result:** To be filled during execution  
**Priority:** Medium  
**Test Data:** N/A  

---

**Title:** TC_FUNC_016_Validate_School_Filter_Visibility  
**Scenario:** Verify that the school filter is only visible to appropriate user roles.  
**Preconditions:** User is logged in as an admin or teacher.  
**Steps to Reproduce:**  
1. Log in as a school admin.  
2. Navigate to the utilization tab and check for the school filter.  
3. Log out and log in as a teacher.  
4. Navigate to the utilization tab and check for the school filter.  
**Expected Result:** The school filter should be visible for admin users and hidden for teacher users.  
**Actual Result:** To be filled during execution  
**Priority:** High  
**Test Data:** User credentials for admin and teacher roles.  

---

**Title:** TC_FUNC_017_Validate_Period_Filter_Options  
**Scenario:** Ensure that the period filter displays the correct options.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Log in as a school admin.  
2. Navigate to the utilization tab.  
3. Click on the period filter dropdown.  
**Expected Result:** The dropdown should display school years and a custom date range selector.  
**Actual Result:** To be filled during execution  
**Priority:** Medium  
**Test Data:** N/A  

---

**Title:** TC_FUNC_018_Validate_Grade_Filter_Options  
**Scenario:** Verify that the grade filter displays the correct options based on user role.  
**Preconditions:** User is logged in as an admin or teacher.  
**Steps to Reproduce:**  
1. Log in as a school admin.  
2. Navigate to the utilization tab.  
3. Click on the grade filter dropdown.  
4. Log out and log in as a teacher.  
5. Navigate to the utilization tab and check the grade filter options.  
**Expected Result:** The grade filter should display appropriate options based on the user role.  
**Actual Result:** To be filled during execution  
**Priority:** Medium  
**Test Data:** User credentials for admin and teacher roles.  

---

**Title:** TC_FUNC_019_Validate_Student_Filter_Options  
**Scenario:** Ensure that the student filter displays the correct options based on user role.  
**Preconditions:** User is logged in as an admin or teacher.  
**Steps to Reproduce:**  
1. Log in as a school admin.  
2. Navigate to the utilization tab.  
3. Click on the student filter dropdown.  
4. Log out and log in as a teacher.  
5. Navigate to the utilization tab and check the student filter options.  
**Expected Result:** The student filter should display appropriate options based on the user role.  
**Actual Result:** To be filled during execution  
**Priority:** Medium  
**Test Data:** User credentials for admin and teacher roles.  

---

**Title:** TC_FUNC_020_Validate_Group_Filter_Options  
**Scenario:** Verify that the group filter displays the correct options based on user role.  
**Preconditions:** User is logged in as an admin or teacher.  
**Steps to Reproduce:**  
1. Log in as a school admin.  
2. Navigate to the utilization tab.  
3. Click on the group filter dropdown.  
4. Log out and log in as a teacher.  
5. Navigate to the utilization tab and check the group filter options.  
**Expected Result:** The group filter should display appropriate options based on the user role.  
**Actual Result:** To be filled during execution  
**Priority:** Medium  
**Test Data:** User credentials for admin and teacher roles.  

--- 

These test cases cover a variety of functional scenarios for the utilization tab, ensuring comprehensive testing of the dashboard's features and user interactions.



TEST TYPE: dashboard_negative

### Test Cases for Dashboard Negative Scenarios

---

**Title:** TC_NEG_001_Invalid_School_Filter  
**Scenario:** Verify that the dashboard does not display data when an invalid school filter is applied.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Navigate to the utilization tab.  
2. Select an invalid school from the 'School' filter dropdown.  
3. Click on the 'Apply' button.  
**Expected Result:** The dashboard should display a message indicating "No data available for the selected filters."  
**Actual Result:** To be filled during execution.  
**Priority:** High  
**Test Data:** Invalid school name (e.g., "NonExistentSchool")

---

**Title:** TC_NEG_002_No_Activity_Selection  
**Scenario:** Verify that the chart does not display any data when no activity type is selected.  
**Preconditions:** User is logged in as a teacher.  
**Steps to Reproduce:**  
1. Navigate to the utilization tab.  
2. Leave the activity type selection blank.  
3. Click on the 'Apply' button.  
**Expected Result:** The chart should show "Please select an activity type to view data."  
**Actual Result:** To be filled during execution.  
**Priority:** Medium  
**Test Data:** N/A

---

**Title:** TC_NEG_003_Invalid_Period_Filter  
**Scenario:** Verify that the dashboard does not display data when an invalid period filter is applied.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Navigate to the utilization tab.  
2. Select an invalid period from the 'Period' filter dropdown.  
3. Click on the 'Apply' button.  
**Expected Result:** The dashboard should display a message indicating "No data available for the selected filters."  
**Actual Result:** To be filled during execution.  
**Priority:** High  
**Test Data:** Invalid period (e.g., "2025-2026")

---

**Title:** TC_NEG_004_Empty_Leaderboard  
**Scenario:** Verify that the leaderboard table displays a message when there are no users to show.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Navigate to the utilization tab.  
2. Ensure there are no users with activity completion.  
3. Click on the 'Leaderboard' section.  
**Expected Result:** The leaderboard should display "No users available for leaderboard."  
**Actual Result:** To be filled during execution.  
**Priority:** Medium  
**Test Data:** N/A

---

**Title:** TC_NEG_005_Export_No_Data  
**Scenario:** Verify that the export functionality does not allow export when there is no data available.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Navigate to the utilization tab.  
2. Ensure no data is displayed in the charts or tables.  
3. Click on the 'Export' button for the leaderboard.  
**Expected Result:** The system should display a message "No data available for export."  
**Actual Result:** To be filled during execution.  
**Priority:** High  
**Test Data:** N/A

---

**Title:** TC_NEG_006_Restricted_Access_Leaderboard  
**Scenario:** Verify that a teacher cannot access the leaderboard section.  
**Preconditions:** User is logged in as a teacher.  
**Steps to Reproduce:**  
1. Navigate to the utilization tab.  
2. Attempt to access the 'Leaderboard' section.  
**Expected Result:** The system should display a message "Access denied. This section is only available for admins."  
**Actual Result:** To be filled during execution.  
**Priority:** High  
**Test Data:** N/A

---

**Title:** TC_NEG_007_Stacked_Bar_Chart_No_Activity  
**Scenario:** Verify that the stacked bar chart does not display data when no activity type is selected.  
**Preconditions:** User is logged in as a teacher.  
**Steps to Reproduce:**  
1. Navigate to the utilization tab.  
2. Do not select any activity type.  
3. Click on the 'View Chart' button.  
**Expected Result:** The chart should show "Please select an activity type to view data."  
**Actual Result:** To be filled during execution.  
**Priority:** Medium  
**Test Data:** N/A

---

**Title:** TC_NEG_008_Invalid_User_Filter  
**Scenario:** Verify that the dashboard does not display data when an invalid user filter is applied.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Navigate to the utilization tab.  
2. Select an invalid user from the 'User' filter dropdown.  
3. Click on the 'Apply' button.  
**Expected Result:** The dashboard should display a message indicating "No data available for the selected filters."  
**Actual Result:** To be filled during execution.  
**Priority:** High  
**Test Data:** Invalid user name (e.g., "NonExistentUser")

---

**Title:** TC_NEG_009_Empty_Overview_Cards  
**Scenario:** Verify that the overview cards display a message when there is no data available.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Navigate to the utilization tab.  
2. Ensure no data is available for schools, teachers, students, activities, and logins.  
**Expected Result:** Each card should display "No data available."  
**Actual Result:** To be filled during execution.  
**Priority:** Medium  
**Test Data:** N/A

---

**Title:** TC_NEG_010_Export_Invalid_Format  
**Scenario:** Verify that the export functionality does not allow export in an invalid format.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Navigate to the utilization tab.  
2. Click on the 'Export' button.  
3. Select an invalid format (e.g., .txt).  
**Expected Result:** The system should display a message "Invalid export format selected."  
**Actual Result:** To be filled during execution.  
**Priority:** Medium  
**Test Data:** N/A

---

**Title:** TC_NEG_011_Chart_Data_After_Filter_Clear  
**Scenario:** Verify that the chart does not retain data after filters are cleared.  
**Preconditions:** User is logged in as a teacher.  
**Steps to Reproduce:**  
1. Navigate to the utilization tab.  
2. Apply any filters.  
3. Clear all filters.  
**Expected Result:** The chart should reset and show "Please select filters to view data."  
**Actual Result:** To be filled during execution.  
**Priority:** Medium  
**Test Data:** N/A

---

**Title:** TC_NEG_012_Export_Without_Selection  
**Scenario:** Verify that the export functionality does not allow export without any selection.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Navigate to the utilization tab.  
2. Do not select any data for export.  
3. Click on the 'Export' button.  
**Expected Result:** The system should display a message "Please select data to export."  
**Actual Result:** To be filled during execution.  
**Priority:** High  
**Test Data:** N/A

---

**Title:** TC_NEG_013_Chart_Selection_Without_Data  
**Scenario:** Verify that the chart does not display data when selecting an activity type that has no data.  
**Preconditions:** User is logged in as a teacher.  
**Steps to Reproduce:**  
1. Navigate to the utilization tab.  
2. Select an activity type that has no data.  
3. Click on the 'View Chart' button.  
**Expected Result:** The chart should show "No data available for the selected activity type."  
**Actual Result:** To be filled during execution.  
**Priority:** Medium  
**Test Data:** N/A

---

**Title:** TC_NEG_014_Empty_School_Filter  
**Scenario:** Verify that the dashboard does not display data when the school filter is left empty.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Navigate to the utilization tab.  
2. Leave the 'School' filter empty.  
3. Click on the 'Apply' button.  
**Expected Result:** The dashboard should display a message indicating "Please select a school to view data."  
**Actual Result:** To be filled during execution.  
**Priority:** High  
**Test Data:** N/A

---

**Title:** TC_NEG_015_Chart_Access_Without_Selection  
**Scenario:** Verify that the chart does not display data when the user tries to access it without selecting any filters.  
**Preconditions:** User is logged in as a teacher.  
**Steps to Reproduce:**  
1. Navigate to the utilization tab.  
2. Do not select any filters.  
3. Click on the chart to view data.  
**Expected Result:** The chart should show "Please select filters to view data."  
**Actual Result:** To be filled during execution.  
**Priority:** Medium  
**Test Data:** N/A

---

**Title:** TC_NEG_016_Export_Without_Activity_Completion  
**Scenario:** Verify that the export functionality does not allow export when there are no activities completed.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Navigate to the utilization tab.  
2. Ensure there are no completed activities.  
3. Click on the 'Export' button for activity completion.  
**Expected Result:** The system should display a message "No data available for export."  
**Actual Result:** To be filled during execution.  
**Priority:** High  
**Test Data:** N/A

---

**Title:** TC_NEG_017_Chart_Access_Without_Proper_Role  
**Scenario:** Verify that a student cannot access the utilization tab.  
**Preconditions:** User is logged in as a student.  
**Steps to Reproduce:**  
1. Attempt to navigate to the utilization tab.  
**Expected Result:** The system should display a message "Access denied. You do not have permission to view this section."  
**Actual Result:** To be filled during execution.  
**Priority:** High  
**Test Data:** N/A

---

**Title:** TC_NEG_018_Empty_Grade_Filter  
**Scenario:** Verify that the dashboard does not display data when the grade filter is left empty.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Navigate to the utilization tab.  
2. Leave the 'Grade' filter empty.  
3. Click on the 'Apply' button.  
**Expected Result:** The dashboard should display a message indicating "Please select a grade to view data."  
**Actual Result:** To be filled during execution.  
**Priority:** High  
**Test Data:** N/A

---

**Title:** TC_NEG_019_Export_Without_Selection_Of_Users  
**Scenario:** Verify that the export functionality does not allow export when no users are selected in the leaderboard.  
**Preconditions:** User is logged in as an admin.  
**Steps to Reproduce:**  
1. Navigate to the utilization tab.  
2. Ensure no users are selected in the leaderboard.  
3. Click on the 'Export' button.  
**Expected Result:** The system should display a message "Please select users to export."  
**Actual Result:** To be filled during execution.  
**Priority:** High  
**Test Data:** N/A

---

**Title:** TC_NEG_020_Chart_Access_Without_Activity_Data  
**Scenario:** Verify that the chart does not display data when there are no activities recorded.  
**Preconditions:** User is logged in as a teacher.  
**Steps to Reproduce:**  
1. Navigate to the utilization tab.  
2. Ensure there are no activities recorded for the selected filters.  
3. Click on the chart to view data.  
**Expected Result:** The chart should show "No data available for the selected filters."  
**Actual Result:** To be filled during execution.  
**Priority:** Medium  
**Test Data:** N/A

--- 

These test cases focus on various negative scenarios that could occur within the utilization tab of the dashboard, ensuring comprehensive coverage of potential failure points and user experience issues.



TEST TYPE: dashboard_ui

### Test Cases for Dashboard UI - Utilization Tab

---

**Title:** TC_UI_001_Utilization_Tab_Visibility  
**Scenario:** Verify that the Utilization tab is visible to users with appropriate permissions.  
**Preconditions:** User is logged in with either Admin, Teacher, or Student role.  
**Steps to Reproduce:**  
1. Log in to the application with an Admin account.  
2. Navigate to the Dashboard.  
3. Check for the presence of the Utilization tab.  
4. Log out and log in with a Teacher account.  
5. Repeat step 3.  
6. Log out and log in with a Student account.  
7. Repeat step 3.  
**Expected Result:** The Utilization tab should be visible to Admins and hidden for Teachers and Students.  
**Actual Result:** To be filled during execution.  
**Priority:** High  
**Test Data:** Admin, Teacher, and Student credentials.

---

**Title:** TC_UI_002_Utilization_Charts_Data_Integrity  
**Scenario:** Ensure that the utilization charts display correct activity counts by activity type and user type.  
**Preconditions:** User is logged in with Admin role and data is pre-populated in the database.  
**Steps to Reproduce:**  
1. Log in to the application as an Admin.  
2. Navigate to the Utilization tab.  
3. Observe the activity counts displayed in the charts.  
4. Compare the displayed counts with the expected counts from the database.  
**Expected Result:** The counts in the charts should match the expected values from the database.  
**Actual Result:** To be filled during execution.  
**Priority:** High  
**Test Data:** Pre-populated activity data in the database.

---

**Title:** TC_UI_003_Month_on_Month_Chart_Y_Axis_Labels  
**Scenario:** Verify that the month on month chart displays appropriate y-axis labels.  
**Preconditions:** User is logged in with Admin role and data is pre-populated.  
**Steps to Reproduce:**  
1. Log in to the application as an Admin.  
2. Navigate to the Utilization tab.  
3. Observe the month on month chart.  
4. Check the y-axis labels for clarity and accuracy.  
**Expected Result:** The y-axis should display a range of values that are evenly distributed and clearly labeled.  
**Actual Result:** To be filled during execution.  
**Priority:** Medium  
**Test Data:** Pre-populated month on month activity data.

---

**Title:** TC_UI_004_Stacked_Bar_Chart_Activity_Selection  
**Scenario:** Validate that selecting an activity type filters the stacked bar chart correctly.  
**Preconditions:** User is logged in with Admin role and data is pre-populated.  
**Steps to Reproduce:**  
1. Log in to the application as an Admin.  
2. Navigate to the Utilization tab.  
3. Select a specific activity type from the left panel.  
4. Observe the stacked bar chart on the right.  
**Expected Result:** The stacked bar chart should only display bars corresponding to the selected activity type.  
**Actual Result:** To be filled during execution.  
**Priority:** High  
**Test Data:** Pre-populated activity types.

---

**Title:** TC_UI_005_Leaderboard_Table_Visibility  
**Scenario:** Ensure that the Leaderboard table is visible only to Admin users.  
**Preconditions:** User is logged in with Admin, Teacher, and Student roles.  
**Steps to Reproduce:**  
1. Log in to the application as an Admin.  
2. Navigate to the Utilization tab.  
3. Check for the presence of the Leaderboard table.  
4. Log out and log in as a Teacher.  
5. Repeat step 3.  
6. Log out and log in as a Student.  
7. Repeat step 3.  
**Expected Result:** The Leaderboard table should be visible to Admins and hidden for Teachers and Students.  
**Actual Result:** To be filled during execution.  
**Priority:** High  
**Test Data:** Admin, Teacher, and Student credentials.

---

**Title:** TC_UI_006_Overview_Cards_Visibility  
**Scenario:** Verify that overview cards display correctly based on user roles.  
**Preconditions:** User is logged in with Admin, Teacher, and Student roles.  
**Steps to Reproduce:**  
1. Log in to the application as an Admin.  
2. Navigate to the Utilization tab and observe the overview cards.  
3. Log out and log in as a Teacher.  
4. Repeat step 2.  
5. Log out and log in as a Student.  
6. Repeat step 2.  
**Expected Result:** Admin should see all cards, Teacher should see only 3 cards, and Student should see only 3 cards.  
**Actual Result:** To be filled during execution.  
**Priority:** Medium  
**Test Data:** Admin, Teacher, and Student credentials.

---

**Title:** TC_UI_007_Filter_Functionality  
**Scenario:** Validate the functionality of filters applied to the overview cards and charts.  
**Preconditions:** User is logged in with Admin role and data is pre-populated.  
**Steps to Reproduce:**  
1. Log in to the application as an Admin.  
2. Navigate to the Utilization tab.  
3. Apply various filters (School, Period, User, Group, Grade, Student).  
4. Observe the changes in the overview cards and charts.  
**Expected Result:** The overview cards and charts should update dynamically based on the selected filters.  
**Actual Result:** To be filled during execution.  
**Priority:** High  
**Test Data:** Various filter values.

---

**Title:** TC_UI_008_Export_Functionality  
**Scenario:** Ensure that the export functionality works for activity completion, logins, and leaderboard.  
**Preconditions:** User is logged in with Admin role and data is pre-populated.  
**Steps to Reproduce:**  
1. Log in to the application as an Admin.  
2. Navigate to the Utilization tab.  
3. Click on the Export button for Activity Completion.  
4. Repeat step 3 for Number of Logins and Leaderboard.  
5. Check the downloaded files.  
**Expected Result:** The exported files should be in .csv format and contain the correct data.  
**Actual Result:** To be filled during execution.  
**Priority:** Medium  
**Test Data:** Pre-populated data for export.

---

**Title:** TC_UI_009_PDF_Export_Overall_Tab  
**Scenario:** Verify the PDF export functionality for the overall tab.  
**Preconditions:** User is logged in with Admin role and data is pre-populated.  
**Steps to Reproduce:**  
1. Log in to the application as an Admin.  
2. Navigate to the overall tab.  
3. Click on the Export to PDF button.  
4. Open the downloaded PDF file.  
**Expected Result:** The PDF should reflect the current dashboard view with applied filters.  
**Actual Result:** To be filled during execution.  
**Priority:** Medium  
**Test Data:** Pre-populated data for export.

---

**Title:** TC_UI_010_Translation_Functionality  
**Scenario:** Validate that the UI elements are correctly translated based on the selected language.  
**Preconditions:** User is logged in and can switch languages.  
**Steps to Reproduce:**  
1. Log in to the application.  
2. Change the language to French.  
3. Navigate to the Utilization tab.  
4. Check the translation of all UI elements.  
5. Repeat steps 2-4 for Spanish.  
**Expected Result:** All UI elements should be accurately translated according to the selected language.  
**Actual Result:** To be filled during execution.  
**Priority:** Medium  
**Test Data:** Language selection options.

---

**Title:** TC_UI_011_Responsive_Design  
**Scenario:** Ensure that the dashboard UI is responsive across different screen sizes.  
**Preconditions:** User is logged in with Admin role.  
**Steps to Reproduce:**  
1. Log in to the application as an Admin.  
2. Resize the browser window to various dimensions (desktop, tablet, mobile).  
3. Observe the layout of the Utilization tab.  
**Expected Result:** The dashboard should maintain usability and readability across all screen sizes.  
**Actual Result:** To be filled during execution.  
**Priority:** Medium  
**Test Data:** N/A

---

**Title:** TC_UI_012_Activity_Type_Color_Coding  
**Scenario:** Verify that each activity type in the stacked bar chart is color-coded correctly.  
**Preconditions:** User is logged in with Admin role and data is pre-populated.  
**Steps to Reproduce:**  
1. Log in to the application as an Admin.  
2. Navigate to the Utilization tab.  
3. Observe the stacked bar chart.  
4. Check the color coding for each activity type against the legend.  
**Expected Result:** Each activity type should have a unique color that matches the legend.  
**Actual Result:** To be filled during execution.  
**Priority:** Medium  
**Test Data:** Pre-populated activity types with color codes.

---

**Title:** TC_UI_013_Empty_Data_Handling  
**Scenario:** Ensure the UI handles empty data scenarios gracefully in charts and tables.  
**Preconditions:** User is logged in with Admin role and data is cleared from the database.  
**Steps to Reproduce:**  
1. Log in to the application as an Admin.  
2. Navigate to the Utilization tab.  
3. Observe the charts and tables.  
**Expected Result:** The UI should display a message indicating no data available instead of showing blank charts/tables.  
**Actual Result:** To be filled during execution.  
**Priority:** Medium  
**Test Data:** Empty database state.

---

**Title:** TC_UI_014_Chart_Tooltips  
**Scenario:** Verify that tooltips on charts display accurate information on hover.  
**Preconditions:** User is logged in with Admin role and data is pre-populated.  
**Steps to Reproduce:**  
1. Log in to the application as an Admin.  
2. Navigate to the Utilization tab.  
3. Hover over different sections of the charts.  
**Expected Result:** Tooltips should display accurate and relevant data for each section hovered over.  
**Actual Result:** To be filled during execution.  
**Priority:** Medium  
**Test Data:** Pre-populated data for charts.

---

**Title:** TC_UI_015_Chart_Legend_Visibility  
**Scenario:** Ensure that the legend for the stacked bar chart is visible and correctly describes the data.  
**Preconditions:** User is logged in with Admin role and data is pre-populated.  
**Steps to Reproduce:**  
1. Log in to the application as an Admin.  
2. Navigate to the Utilization tab.  
3. Observe the stacked bar chart and its legend.  
**Expected Result:** The legend should be clearly visible and accurately describe each activity type represented in the chart.  
**Actual Result:** To be filled during execution.  
**Priority:** Medium  
**Test Data:** Pre-populated activity types.

--- 

These test cases cover a range of scenarios for the dashboard UI, focusing on visual elements, layout, and functionality specific to the Utilization tab.