Create a University Academic Performance Analytics Dashboard with Excel, including specific data, analysis, charts, and insights for 40 students across IT, Business, Engineering, and Health Sciences departments.

Question

Create a University Academic Performance Analytics Dashboard with Excel, including specific data, analysis, charts, and insights for 40 students across IT, Business, Engineering, and Health Sciences departments.

Asked on March 25, 2026Computer Science

This computer science problem involves algorithmic thinking and programming concepts. The solution below explains the approach, logic, and implementation step by step.

Accepted Answer · 2026-03-25T23:37:21.175Z

Based on the provided instructions for "SHEET 1: STUDENT_DATA (MANDATORY DATA ENTRY)" for the "University Academic Performance Analytics Dashboard", you need to create a dataset for 40 students. The instructions specify the departments and names to use, but the exact column structure ("dataset structure below") is not visible. Therefore, the following columns are proposed to fulfill the requirements of an "Academic Performance Analytics Dashboard": Column A: Student ID Purpose:* A unique identifier for each student (e.g., S001, S002, ..., S040). Column B: Student Name Purpose:* The names of the students, selected from the provided Male and Female names (Kwame, Kojo, Yaw, Kofi, Daniel, Michael, Samuel, Emmanuel, Bright, Kelvin; Ama, Akosua, Abena, Adwoa, Efua, Mary, Grace, Deborah, Priscilla, Linda). Column C: Gender Purpose:* The gender of the student, derived from the name lists (Male or Female). Column D: Department Purpose:* The department the student belongs to. Use only the specified departments: IT, Business, Engineering, Health Sciences. Each department must have 10 students. Column E: Midterm Score Purpose:* A placeholder for a student's performance in a midterm assessment. (This is an assumed column to measure "Academic Performance"). Column F: Final Exam Score Purpose:* A placeholder for a student's performance in a final exam. (This is an assumed column to measure "Academic Performance"). Column G: Total Score Purpose:* The sum of the Midterm Score and Final Exam Score. (This is an assumed column for performance calculation). Column H: Grade Purpose:* The final grade based on the Total Score (e.g., A, B, C, D, F). (This is an assumed column for performance evaluation). The columns to create are: A: Student ID B: Student Name C: Gender D: Department E: Midterm Score F: Final Exam Score G: Total Score H: Grade

Accepted Answer · 2026-03-25T23:37:21.175Z

Based on the provided instructions for "SHEET 1: STUDENT_DATA (MANDATORY DATA ENTRY)" for the "University Academic Performance Analytics Dashboard", you need to create a dataset for 40 students. The instructions specify the departments and names to use, but the exact column structure ("dataset structure below") is not visible. Therefore, the following columns are proposed to fulfill the requirements of an "Academic Performance Analytics Dashboard": Column A: Student ID Purpose:* A unique identifier for each student (e.g., S001, S002, ..., S040). Column B: Student Name Purpose:* The names of the students, selected from the provided Male and Female names (Kwame, Kojo, Yaw, Kofi, Daniel, Michael, Samuel, Emmanuel, Bright, Kelvin; Ama, Akosua, Abena, Adwoa, Efua, Mary, Grace, Deborah, Priscilla, Linda). Column C: Gender Purpose:* The gender of the student, derived from the name lists (Male or Female). Column D: Department Purpose:* The department the student belongs to. Use only the specified departments: IT, Business, Engineering, Health Sciences. Each department must have 10 students. Column E: Midterm Score Purpose:* A placeholder for a student's performance in a midterm assessment. (This is an assumed column to measure "Academic Performance"). Column F: Final Exam Score Purpose:* A placeholder for a student's performance in a final exam. (This is an assumed column to measure "Academic Performance"). Column G: Total Score Purpose:* The sum of the Midterm Score and Final Exam Score. (This is an assumed column for performance calculation). Column H: Grade Purpose:* The final grade based on the Total Score (e.g., A, B, C, D, F). (This is an assumed column for performance evaluation). The columns to create are: A: Student ID B: Student Name C: Gender D: Department E: Midterm Score F: Final Exam Score G: Total Score H: Grade