QHO447 Module Title : Data Analysis, Tools and Application Assessment Title : Data Analysis Project Assessment Task The assessment includes both group work and individual research, focusing on data analysis. Groups of five to six students will collaborate to choose a data analysis domain to explore. The availability of relevant data is essential for this decision. Possible domains include impactful topics such as the environment, population distribution, wealth, business, health, education, or international issues. Datasets can be sourced from various platforms, including government websites like the Office for National Statistics (ONS) and GOV.UK. You may also use open data platforms such as the World Bank or Kaggle, which provide a wide range of publicly accessible datasets.
Once the group selects a domain, each member will define their own individual topic within that domain. This allows for a deeper investigation into the chosen area, enabling each student to generate meaningful insights from their individual analysis. These findings will then be combined for the group presentation.
Individual Data Analysis Task For your individual topic, you will conduct a data analysis and create a PowerPoint presentation. You must clearly define your analysis objectives and follow the data analysis process outlined below:
Collect raw data: Obtain unanalysed data from a single or multiple sources, depending on your analysis needs.
Prepare your data: Organise and format the data appropriately for
Analyse the data: Use tools such as Excel to apply suitable analysis methods (e.g., descriptive, predictive, or prescriptive analysis).
Present your findings: Use appropriate data visualisation techniques to clearly communicate your results.
At the end of the module, your individual analysis and findings will be summarised and integrated into a group presentation for stakeholders.
Individual PowerPoint Slide Submission – Suggested Format Individual Topic and name
Objectives
Data Analysis: Cover your objectives, data collection, preparation, analysis techniques, and findings
Data Collection: Describe where and how you obtained your data. Include link to the data
Data Preparation: Explain how you prepared the data. This may include understanding the data (e.g., variables collected), cleaning (e.g., handling missing values), pre-processing (e.g., selecting variables, merging files, sorting)
Data Analysis: Identify and apply appropriate analysis methods using tools like Excel, aligned with your objectives.
Findings: Present your results using suitable
Group Presentation The group will deliver a combined oral presentation. The total presentation time is no more than 35 minutes, structured as follows:
30 minutes: Group presentation
5 minutes: Q&A session
The group must demonstrate a cohesive effort, with each member confidently presenting their contribution. The group presentation should cover:
The group’s analysis topic and objectives
Group data analysis: Data collection, preparation, analysis and results of individual members
Group conclusions and recommendations for stakeholders
Assessment will be based on individual contributions and the group’s overall performance, evaluated against the assessment criteria.
Group PowerPoint Slide for presentation – Suggested Format Project Title
Group Members
Introduction: Purpose of the project, importance of the topic, aims, and objectives
Data Analysis: Combining of each member’s analysis (data collection, preparation, analysis, and results)
Conclusion: Overall findings
Recommendations
References: List of all sources used in the group project