10 Sep DATA ANALYTICS REPORT
Overview
This assignment will enable you to practice your data analytics skills learned to date. You need to implement the Data Science Road Map and respond to the scenario on page 2.
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 the problematic 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.
Presentation
The structure for the report is as follows:
1. Title page
2. Problem: outline the problem you are trying to solve based on the scenario outlined below and the data sets you receive.
3. Data Wrangling: outline the steps you took to clean the data initially and the processes you used to understand what was in the data set you received. Include screen captures etc to show the process used.
4. Features extracted: based on your problem, what features did you choose to work with and why?
5. Ethical considerations: use the factors from the Business Ethics Canvas to write about the ethical aspects you considered
6. Modelling & Analysis: what visualisation and statistical processes did you employ to find answers to the problem you identified. Why did you choose these?
7. Present Results: this should include a data dashboard created in EXCEL and contain both visual, numerical and textual data. Data in your report should refer to data in the spreadsheet
8. References (where appropriate)
Criteria
1. Data Analysis Skills (Use of the Data Science Road Map process to structure the analysis; discuss the ethics
2. Demonstration of Statistical Thinking skills (ability to use the language, concepts and processes of statistics to address the problem presented)
3. Demonstration of EXCEL SKILLS (pivot tables, data dashboards, functions)
4. Communication skills – ability to write a coherent report
Innovation/Originality – for going above and beyond!
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.