This is a PowerBI assignment. You only have to do the dashboarding task (task 1) in "Assessment...

Question

This is a PowerBI assignment. You only have to do the dashboarding task (task 1) in "Assessment 3.pdf". It refers to a case study in "A1_Task_Description (See Case Study only).pdf", and the targeted user is the "Teacher" in "Assessment 1 Stakeholder Interview Data.pdf". The "Merged_Assessments.csv" file is the data you'll need for the PowerBI dashboard. So basically create a PowerBI dashboard with an appropriate number of pages that can be used by a teacher to evaluate a student.

Note that for the "connect back to the prototype you proposed" part, the referred prototype displays a student's academic history including all the A-E, NAPLAN and PAT assessments (the assessments' code, name, results, year/term when assessed).

a3-tasks-pi4gq03g.zip

Pashikanti Sneha · Accepted Answer

PowerBI Dashboard steps
To create a comprehensive Power BI dashboard for the teacher's use case, here's a complete
approach:
1. Objective of the Dashboard
The goal is to provide a streamlined dashboard that consolidates students' academic data,
including assessment results (A-E, PAT, and NAPLAN), attendance, and grade trends, to allow
teachers to monitor student progress efficiently. This directly addresses user needs from the
stakeholder interviews, where teachers expressed the need for a single access point for holistic
student information .
2. Dashboard Structure and Pages
Based on Task 1 requirements , the dashboard will have the following pages:
Page 1: Student Overview
● Objective: Offer a one-click view of each student’s academic performance across
various assessments.
● Components:
○ Student Info Card: Displays basic details like student ID, year, and current grade
level.
○ Assessment History Table: Lists assessments (A-E, PAT, NAPLAN), including
assessment codes, names, results, and the term/year assessed.
○ Trend Line Chart: Shows a student’s grade trends over time.
● Slicers: Enable filtering by student, assessment type, and academic year to support
personalized insights.
Page 2: Comparative Assessment Analysis
● Objective: Allow teachers to examine trends in assessments to support targeted
learning strategies.
● Components:
○ Bar Chart: Compares average scores by subject for each assessment type.
○ Heatmap: Visualizes performance distribution across terms and subjects,
highlighting high/low scores.
● Slicers: Filters for subject, grade level, assessment term, and year.
Page 3: Attendance & Participation
● Objective: Visualize attendance trends to identify patterns and their potential impact on
performance.
● Components:
○ Line Chart: Tracks attendance patterns for each academic term.
○ Scatter Plot: Shows attendance vs. average assessment scores, identifying
correlations.
● Slicers: Allow filtering by student, term, and grade level.
Page 4: Summary & At-Risk Insights
● Objective: Generate actionable insights, such as identifying at-risk students for targeted
support.
● Components:
○ KPI Cards: Indicators for students with low attendance or declining grades.
○ Table with Conditional Formatting: Highlights students scoring below a certain
threshold, or those with high absenteeism.
● Slicers: Filters for term, grade level, and focus areas like attendance and assessment
scores.
3.

This is a PowerBI assignment. You only have to do the dashboarding task (task 1) in "Assessment 3.pdf". It refers to a case study in "A1_Task_Description (See Case Study only).pdf", and the targeted...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment