Assessment: assignment 1- data analytics report 1


Assessment: Assignment 1- Data Analytics Report 1


Assessment @ a glance 



Use the Data Science Road Map, your Excel &   Descriptive Statistics skills to analyse two data sets to solve a problem 


Learning outcomes

Present and describe information effectively

Suggest ways to improve decision   making processes






Learnline Submit   Here

Week 7 (see Learnline   for details)


Volume & Documentation

Two documents are required:

– An Excel workbook showing data analysis and a data dashboard

– A 2- 4-page report in Word summarising outcomes and   decisions (see required template in   task details) 


Group or Individual




See separate document


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.



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


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. 


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) 


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

5. Innovation/Originality – for going above and beyond!

Get 20% Discount on This Paper
Pages (550 words)
Approximate price: -

Try it now!

Get 20% Discount on This Paper

We'll send you the first draft for approval by at
Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Paper Helper has assembled a team of highly skilled writers with diverse experience in the online writing circles. Our aim is to become a one stop shop for all your Academic/ online writing. Check out below our amazing service!


Essay Writing Services

At Paper Helper, we prioritize on all aspects that creates a good grade such as impeccable grammar, proper structure, zero-plagiarism, and conformance to guidelines. The principal purpose of essay writing is to present the author's evaluation concerning a singular subject about which they have made. Since Professionalism is the mother of every success, try our team of experienced writers in helping you complete your essays and other assignments.


Admission Papers

You have been trying to join that prestigious institution you long yearned for, but the hurdle of an admission essay has become a stumbling block. We have your back, with our proven team that has gained invaluable experience over time, your chance of joining that institution is now! Just let us work on that essay.How do you write an admission essay? How do you begin the essay? For answers, try Quality Custom Writers Now!


Editing and Proofreading

Regardless of whether you're pleased with your composing abilities, it's never an impractical notion to have a second eye go through your work. The best editing services leaves no mistake untouched. We recognize the stuff needed to polish up a writing; as a component of our editing and proofreading, we'll change and refine your write up to guarantee it's amazing, and blunder free. Our group of expert editors will examine your work, giving an impeccable touch of English while ensuring your punctuation and sentence structures are top-notch.


Technical papers

We pride ourselves in having a team of clinical writers. The stringent and rigorous vetting process ensures that only the best persons for job. We hire qualified PhD and MA writers only. We equally offer our team of writers bonuses and incentives to motivate their working spirit in terms of delivering original, unique, and informative content. They are our resources drawn from diverse fields. Therefore your technical paper is in the right hands. Every paper is assessed and only the writers with the technical know-how in that field get to work on it.


College Essay Writing

If all along you have been looking for a trustworthy college essay service provider that provides superb academic papers at reasonable prices, then be glad that you search has ended with us. We are your best choice! Get high-quality college essay writing from our magnificent team of knowledgeable and dedicated writers right now!


Quality Assignment/Homework Help

We give the students premium quality assignments, without alarming them with plagiarism and referencing issues. We ensure that the assignments stick to the rules given by the tutors. We are specific about the deadlines you give us. We assure you that you will get your papers well in advance, knowing that you will review and return it if there are any changes, which should be incorporated.