Module Code : 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