Highlights
SCENARIO
You are Aya Baxter and you are working as a data analyst in a tertiary institution. Your manager has been asked by a Senior staff member responsible for student engagement to analyse a data set of an ‘at risk’ first year university class (often with a high failure rate) to understand the demographics and the potential for all students to successfully complete the unit. The institution is looking to implement some student support strategies but first need to understand the student cohort in some detail.
To: Aya Baxter
From: Monica Dave
Subject: Student Engagement project
Dear Aya,
The Pro Vice Chancellor (PVC) Student Engagement is gathering data regarding some of theproblematic subjects we teach in first year across the institution. She is particularly interested in a data set from a first year Statistics unit which has had some very high fail rates in the past. Could you please review the data sets extracted from the student system and the Learning Management system and provide some advice including a brief report to help with planning intervention strategies to ensure that students can be successful. You will need to include a range of descriptive statistics and data visualisations (in the form of a data dashboard) so that the PVC and colleagues will be able to quickly understand the situation when in their next meeting which is scheduled for Week 8 of this semester. It would be great if you could get this work to me no later than Friday, Week7 I look forward to your response
Monica Dave
PREPARATION
In order to prepare a reply to the email, you will need to examine and analyse the datasets thoroughly. There are two separate excel files that will need to be reviewed.
Remember the process to use and the importance of the first step: Identifying the problem. The data will be messy, you need to clean the data and decide what will be
best for your analysis. After cleaning the data, you will need to do some explorations about what its telling you. Consider the variables against which data is being recorded and the various relationships between variables that may be of help. A consideration of the ethical aspects of this request should also be included. Demonstrate your use of a pivot table to manipulate the data as part of your analysis. Use the pivot table to create an Interactive data dashboard that includes at least 3
charts from which decision making is possible.
This STA101: Statistics Assignment has been solved by our Statistics experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.
© Copyright 2026 My Uni Papers – Student Hustle Made Hassle Free. All rights reserved.