Filter by keyword, subject, or both. Updates live as new model answers are added to our portal.
Business
850 words
HopeLink Community Support and Food Security Database
This assignment requires students to design, develop and analyse a relational database for HopeLink Community Support and Food Security, a fictitious non-profit organisation working across rural and urban communities to reduce poverty and hunger. HopeLink currently relies on spreadsheets, which have resulted in inefficiencies and reporting errors. The proposed database is intended to improve operational efficiency, transparency and evidence-based reporting while supporting the organisation's work towards United Nations Sustainable Development Goals (SDGs) 1 and 2: No Poverty and Zero Hunger. The database development project involves five main entities: Beneficiary, Donor, Product, Collection and Collection Detail. Students are required to create a data dictionary defining the tables, attributes and appropriate validation rules. They must then use SQL within Microsoft Access to create the required tables through SQL View, rather than using the Access front end. Primary keys and foreign keys must be identified and implemented as part of the database design. Students must also establish relationships between the database entities and enforce referential integrity to maintain accurate information for management reporting and decision-making. Appropriate validation rules, user-friendly error messages, drop-down lists and input masks should be implemented where required. The database must be populated with sufficient realistic data for testing, with minimum requirements of 10 Beneficiary records, 10 Donor records, 20 Product records, 10 Collection records and 20 Collection Detail records. A further component requires students to develop five useful SQL queries in Microsoft Access to support analysis and reporting for HopeLink. The queries must follow specific requirements, including one parameter query, at least three queries containing a WHERE clause, at least one aggregate query and at least two queries involving joins across more than two tables. Students must provide screenshots of the SQL code and resulting outputs, together with an English explanation and a short justification of how each query could support HopeLink's operations and decision-making. The final component is an 850-word maximum business insights report investigating the use of food banks in the UK and considering how initiatives could support SDG 1 and SDG 2. Students are expected to use reliable external data, present relevant graphs and analyse current trends in food-bank usage. This section requires Harvard referencing and should use reliable academic, industry and other appropriate sources. The report is based on SDG 1 and SDG 2 and is not directly linked to the database developed for the assignment. Overall, the assignment assesses students' ability to apply data-modelling techniques, database design principles, SQL and data analytics to support organisational operations and strategic decision-making. It combines practical database development in Microsoft Access with data analysis and a business-focused evaluation of food-bank trends and sustainability goals.
Read Model Answer →
Applied Modelling and Visualisation
2,500 words
Applied Modelling and Visualisation – Hexawing Airways Passenger Satisfaction Analysis
This assessment is a 2,500-word consultancy report for the Applied Modelling and Visualisation module within the MSc Management with Data Analytics programme at BPP University. The assignment requires students to work as Data Analytics Consultants for the fictional Hexawing Airways and analyse a passenger satisfaction dataset containing more than 103,000 records from the airline's database. The purpose of the assessment is to apply machine learning, data analysis and visualisation techniques to identify factors that influence passenger satisfaction and communicate meaningful findings to a varied corporate audience, including the Chief Executive Officer, senior flight personnel and cabin crew. The dataset contains a range of passenger and flight-related features, including gender, satisfaction status, age, age band, type of travel, travel class, flight distance, destination, continent and ratings for services such as inflight Wi-Fi, online booking, gate location, food and drink, online boarding, seat comfort, inflight entertainment, onboard service, leg room, baggage handling, check-in service, inflight service and cleanliness. It also includes departure and arrival delay information. These variables provide the basis for exploratory analysis, predictive modelling and visual communication of passenger satisfaction patterns. The assessment requires the development of a data-driven solution using Python and relevant Python libraries. Students must follow an established analytical methodology such as PPDAC or CRISP-DM and demonstrate an Extract, Transform and Load process, data preparation, exploratory data analysis and appropriate visualisations. Two analytical models must be selected, trained and tested to predict passenger satisfaction. The available modelling approaches include Logistic Regression, Naive Bayes, Decision Tree, Bagging, Random Forest, AdaBoost, XGBoost, Artificial Neural Networks or another appropriate state-of-the-art algorithm. The second task requires critical analysis of the two selected models, including their strengths and limitations, an explanation of the chosen loss function, discussion of accuracy metrics and a comparison table of model performance. The third task focuses on communicating findings through data visualisation, including outputs such as correlation matrices, heat maps and confusion matrices. The analysis should explain how exploratory data analysis guided model selection and how visualisation techniques communicate insights effectively. The final report should demonstrate the ability to formulate data-driven solutions, critically evaluate analytical models and appraise data visualisation techniques. The assessment also requires independent research, appropriate academic referencing and supporting evidence from the analytical process. A pre-run Python notebook must be embedded in the MS Word submission or provided through an appropriate shared link.
Read Model Answer →
Big Data and Cloud Computing
2,500 words
Big Data and Cloud Computing: FieldVision Cloud-Based Big Data Solution for AgroNova
This assessment is a 2,500-word individual report for the Big Data and Cloud Computing module within the MSc Management with Data Analytics programme at BPP University. The report is based on a fictional agricultural technology company, AgroNova, and its FieldVision project. AgroNova provides climate change and crop monitoring services to farmers in the UK and intends to expand internationally. However, its existing ageing infrastructure and manual processes present challenges to international expansion and the development of data-driven decision-making. The FieldVision project aims to use Internet of Things (IoT) technology and cloud-based big data solutions to collect, store and analyse real-time information from agricultural environments. The report requires students to act as a big data and cloud solution consultant and provide recommendations to senior management at AgroNova. The project involves IoT devices such as CropCam aerial cameras supplied by HydroSense and SmartHarvester solar-powered sensors supplied by SoilTech. These technologies collect information including crop imagery, soil moisture, temperature and humidity. The resulting data can support crop monitoring, risk assessment, early warning alerts, irrigation decisions, crop-failure claims validation and other farming-related insights. The first task focuses on Big Data Requirements and Storage Solutions. Students must identify the requirements arising from the scenario and critically evaluate a range of cloud-based big data storage solutions. The evaluation should consider factors such as capacity, functionality and costs. The second task requires students to propose one appropriate cloud-based solution architecture supported by an architecture diagram showing the essential components from data sources through to reporting. The selected architecture must be analysed in relation to AgroNova's requirements and the storage solutions considered in Task 1. The third task addresses Project Risks and Issues. Students must critically appraise the risks and issues associated with deploying the proposed cloud-based big data solution and identify appropriate mitigation approaches. These issues should be connected directly to the storage solutions and proposed architecture. The scenario highlights concerns from AgroNova's CISO, CFO and Chief Reputation Officer regarding potential data breaches, high costs and poor returns on investment, making security, financial viability and organisational risk important considerations. The report should contain an approximately 200-word introduction, an 800-word analysis of Big Data Requirements and Storage Solutions, a 500-word Proposed System Architecture section supported by relevant diagrams, an 800-word Project Risks and Issues section, and an approximately 200-word conclusion. Harvard referencing, academic research and appropriate supporting appendices are also required. The assessment addresses three learning outcomes: designing an architecture that supports complex data collection, critically evaluating data storage solutions from an enterprise systems perspective, and critically appraising issues involved in enterprise-system deployment.
Read Model Answer →
Big Data Analytics / Machine Learning
3,000 words
Machine Learning on Big Data Using PySpark: Large-Scale Data Analysis and Predictive Modelling
This group-based Machine Learning on Big Data project requires students to apply machine learning techniques to a large real-world dataset using PySpark DataFrames and Spark machine-learning libraries. Students select a substantial dataset, ideally between approximately 300 MB and 1 GB, from sources such as Kaggle, workplace data or other valid repositories, and develop an end-to-end big-data analytics workflow. CN7030 CRWK 26T1 The project begins with data loading and preprocessing using PySpark. Students are expected to handle missing values, perform data normalisation and feature engineering, identify class imbalance and propose appropriate mitigation strategies. Where text datasets are selected, additional preprocessing may include stemming, lemmatization and TF-IDF representation. CN7030 CRWK 26T1 The modelling stage requires implementation of an appropriate machine-learning approach using PySpark MLlib or Spark ML. The brief expects a multiclass rather than binary classification problem and allows techniques including multiclass classification, ensemble learning, clustering and text mining. Students must justify their model choice and consider model robustness, bias and variance when attempting to improve predictive performance. CN7030 CRWK 26T1 Students then perform hyperparameter tuning using techniques such as grid search or random search and evaluate the resulting model with appropriate measures. Relevant evaluation outputs may include accuracy, F1-score, precision, recall and a confusion matrix. Results should also be visualised or clearly presented and interpreted to identify meaningful patterns and performance characteristics. CN7030 CRWK 26T1 The project additionally requires consideration of Legal, Social, Ethical and Professional (LSEP) issues. Students discuss potential ethical concerns associated with their dataset, including bias and privacy risks, and propose suitable mitigation strategies. The final work is consolidated into a single user-friendly HTML analytics report that clearly presents the group's preprocessing, modelling, optimisation, evaluation and interpretation. CN7030 CRWK 26T1 CN7030 CRWK 26T1 Overview word count: approximately 335 words. If you are also uploading the presentation separately to the Reference Library, that should be a second entry under “Presentations and Academic Posters”, because the presentation forms a distinct 40% component and assesses understanding of Spark, preprocessing, modelling, optimisation, evaluation and responses to examiner questions. CN7030 CRWK 26T1
Read Model Answer →
Data Science / Data Analytics
Airline Passenger, Ticket Price and Revenue Analysis Using Python
This applied Data Science project requires students to use Python to analyse passenger demand, ticket prices and airline revenues across the period 2021–2023. Two datasets are provided: one containing daily passenger counts and revenue or average-price information for 2021 and 2022, and another containing a representative sample of individual journeys made during 2023. The datasets may include domestic, European and intercontinental routes as well as standard/economy and business/club travel classes. 202526_SmallProject_semB Students must develop Python code that reads the assigned datasets and produces a series of analytical visualisations. A core requirement is to plot daily passenger numbers for economy and business classes across all three years, combining scatter plots with smoothed trend lines. The smoothing must be calculated using the first eight terms of a Fourier series through the supplied scrfft.py module. 202526_SmallProject_semB Further analysis examines changes in average ticket prices, including monthly comparisons across 2021, 2022 and 2023, together with annual average prices that incorporate revenue generated from additional services such as seat reservations and extra baggage. 202526_SmallProject_semB A fourth analysis is personalised according to the final digit of the student's ID. Depending on the allocated task, students may investigate weekly journey distributions, seasonal travel patterns, price-versus-distance relationships, business and economy class behaviour, additional-service revenues, weekend journeys or linear relationships between selected variables. Three additional numerical values, labelled X, Y and Z, must also be calculated according to the assigned scenario. 202526_SmallProject_semB The final report must include four figures, relevant mathematical formulae and a critical discussion of the findings. Students are expected to interpret trends in passenger numbers, prices, revenues, seasonal patterns and airline profitability rather than simply presenting calculations. The report is limited to five A4 pages, while the Python source code and report are submitted separately. 202526_SmallProject_semB Overview word count: approximately 330 words. Note: the university name is not printed directly in the visible assignment heading, but the submission instructions use a herts.ac.uk module-leader address and StudyNet/Canvas, which identifies the institution as the University of Hertfordshire. 202526_SmallProject_semB
Read Model Answer →
Information Visualisation / Data Analytics / Data Science
1,500 words
Information Visualisation Project Using Power BI and Python
Assignment overview — ready to paste This Information Visualisation project requires students to design, implement and critically evaluate effective data visualisations using two different technological approaches: Microsoft Power BI and Python. The assessment focuses on the practical application of information-visualisation principles, including data preparation, visual design, interaction, audience requirements and the extraction of meaningful patterns and insights from complex datasets. Assignment 002 Coursework 2025-… Task 1 focuses on interactive visualisation using Power BI. Students work with the UK Department for Transport's Road Safety Open Data (STATS19), which contains information relating to road traffic accidents, casualties, vehicles, locations, times and contributing factors. Students may analyse one year or multiple years of data depending on their visualisation objectives. Assignment 002 Coursework 2025-… The Power BI work requires students to identify an appropriate target audience and report type, select relevant variables, clean and transform the data, develop an appropriate data model and create analytical measures using Data Analysis Expressions (DAX). The resulting dashboard should communicate the context of the data and reveal meaningful trends, patterns and insights. Assignment 002 Coursework 2025-… Task 2 requires students to develop visualisations programmatically using Python, with Jupyter Notebook recommended as the implementation environment. Students independently select a real-world, publicly available dataset containing at least 10,000 observations and more than five variables. Unlike Task 1, visualisation tools that automatically construct visualisations, such as Tableau or Power BI, cannot be used for this component because programming is an explicit requirement. Assignment 002 Coursework 2025-… Assignment 002 Coursework 2025-… The submitted Jupyter Notebook should operate as an educational technical report explaining the selected dataset, preprocessing procedures, visualisation choices and resulting insights. Students are expected to justify their visualisation techniques, critically evaluate findings and discuss challenges encountered during development. The textual content of the notebook is limited to 1,500 words, excluding code and visualisations. Assignment 002 Coursework 2025-… The complete assessment contains several deliverables, including a maximum 6-minute Power BI demonstration video, a maximum 2-page Power BI report, the .pbix file, an 8-minute Python/Jupyter visualisation demonstration, the Jupyter Notebook, dataset and README file. All materials must ultimately be packaged into a single ZIP submission. Assignment 002 Coursework 2025-… Assignment 002 Coursework 2025-… Important: the brief does not specify a named referencing style or academic level, so I would select Not specified for those two portal fields rather than guessing. It also explicitly states that generative AI must not be used to create any part of the assessed submission, including code, debugging, writing, paraphrasing or bibliographies. Assignment 002 Coursework 2025-…
Read Model Answer →
Digital Marketing
Three Weekly Digital Marketing Tutorial Challenges
This assessment consists of three weekly digital marketing tutorial challenges designed to develop practical skills in digital marketing, consumer insights, content creation, inclusive communication, ethical storytelling and campaign design. The assessment accounts for 45% of the module and requires students to apply digital marketing theory and consumer insight techniques in real-world marketing contexts. The activities are completed through tutorial-based learning, where students participate in discussions, receive tutor guidance and develop their work before submitting it through Canvas. The assessment focuses on applying consumer insights, data analytics tools and digital marketing strategies to create meaningful and responsible customer experiences. Challenge 1, titled “Are You Being Inclusive?” – Brand Audit & Persona for Ethical Reach, focuses on ethical digital auditing and inclusive persona design. Students select a brand from their home country and evaluate the inclusiveness and accessibility of its digital marketing across its website, social media and paid advertising. They then develop two to three detailed customer personas representing underserved or marginalised customer groups. Students also use AI analytics tools such as Google Trends, SparkToro or simulated AI insights to identify audience behaviours and preferences. The challenge is linked to SDG 10 – Reduced Inequalities and includes consideration of the ethics of using AI in digital marketing and its effect on the credibility of consumer insights. Challenge 2, titled “Don't Just Capture Attention – Respect It” – Campaign Idea Pitch, focuses on sustainable branding and growth. Students research the client's existing branding, examine opportunities to expand or sustain its audience and use consumer insight tools such as Google Trends, reviews and surveys to understand public perceptions. Students then create a visual mini-campaign promoting sustainable and transparent brand messaging, including social media content and AI-generated visuals. The campaign is connected to SDG 16 – Peace, Justice and Strong Institutions. Challenge 3, titled “Create, Educate, Disseminate & Evaluate”, develops digital social marketing and consumer engagement. Students extend the campaign developed in Challenge 2 into an interactive digital event that promotes positive behavioural change and educates audiences about a social issue. The activity must consider audience interests, increase interactivity and engagement, and provide evidence of positive engagement. This challenge is linked to SDG 4 – Quality Education. Overall, the assessment develops students' ability to combine digital marketing strategy, consumer insights, ethical considerations, sustainability and creative campaign design in practical marketing activities.
Read Model Answer →
Business Intelligence / Data Analytics / Project Management
Business Intelligence and Data Analytics for Project Progress Evaluation
This assessment for the Data Analytics and Project Management for Business Intelligence module requires students to critically evaluate the progress of a live-style project through the application of business intelligence and data analytics techniques. Working as a group of Project Analysts, students select either a Convocation project or Concert project associated with Northumbria University London and prepare a professional presentation assessing its progress, stakeholders, deliverables and performance. The assessment begins with development of a clear project problem or opportunity statement, followed by identification and analysis of the key stakeholders and deliverables associated with the selected project. Students then use Business Intelligence and Data Analytics techniques to examine project progress and communicate findings through dashboards. The assessment permits the use of Microsoft Excel or other suitable software for dashboard development. A central part of the task is the creation and critical evaluation of a project dashboard. Students are expected to use realistic assumed or projected data where necessary, as the assessment is designed to test the ability to design, interpret and critically evaluate dashboards rather than the accuracy of real project data. The data should therefore be internally consistent, relevant to the selected project and capable of generating meaningful management insights. Students must also critically justify their chosen BI and analytics tools, explaining how the dashboard supports project monitoring and informed decision-making. The assessment concludes with recommendations for the successful implementation and use of a Business Intelligence or Data Analytics solution within the selected project. Academic references and relevant examples should be used to support the analysis. The marking criteria place the greatest emphasis on application of BI tools and techniques (30%), followed by stakeholders and deliverables (20%) and justification of BI tools (20%). Project and opportunity analysis, conclusion and recommendations, and presentation and referencing each contribute a further 10%. Higher-performing work is expected to demonstrate critical evaluation, meaningful dashboard insights, strong theoretical or industry justification and professionally presented recommendations. If the file you want to upload is the resubmission report instead Use the same University, Subject and Module Name, but change these fields: Title: Business Intelligence and Project Analytics: Individual Critical Analysis of Project Performance Assignment type: MS Technical and Scientific Writing Word count: 1,500–2,000 words Key topics: Business Intelligence, Data Analytics, Project Management, Stakeholder Analysis, BI Tools, Dashboard Evaluation, Project Opportunity Analysis, Project Deliverables, Critical Analysis, Project Recommendations The resubmission is an individual written report in which the student selects only one area from the original project—Project & Opportunity Analysis, Stakeholders & Deliverables, Application of BI Tools & Techniques, Justification of BI Tools, or Conclusion & Recommendations—and develops it in depth. It should use the same Convocation or Concert project context while demonstrating independent critical analysis, reflection and application of theory.
Read Model Answer →
Big Data Analytics / Data Analytics
4,000 words
Big Data Analytics Using Python and Business Intelligence with Tableau
This individual Big Data Analytics assessment requires students to critically analyse data using programming languages, statistical techniques, data visualisation methods and business intelligence software. The assessment combines practical data analytics using Python with interactive business intelligence and dashboard development using Tableau, requiring evidence of technical implementation, research, critical appraisal and justification of the selected analytical approaches. The first section, worth 70%, is based on a dataset containing accidental drug-related deaths recorded in Connecticut between 2012 and 2024. The dataset contains 12,964 observations and 49 variables. Students are required to conduct exploratory data analysis using Python, develop three to four research questions, formulate null and alternative hypotheses, and apply appropriate statistical methods. The analytical process also requires an evaluation of alternative technologies and methodological approaches, supported by relevant research. Students must justify their selected methodology and present a clear workflow diagram. The solution-development stage involves data preprocessing, descriptive statistical analysis, visualisation, answering the research questions and conducting statistical significance testing to determine whether the null hypothesis should be accepted or rejected. Evidence of coding and a link to working code are also required. The final Python component requires evaluation of the findings, consideration of limitations and recommendations for future development using emerging technologies. The second section, worth 30%, focuses on Business Intelligence using Tableau and uses a historical Olympic Games dataset containing 271,116 rows and 15 columns. Students analyse relationships between medals and host cities, athlete age and medal type, season and medal counts, and sex and medal type. The section culminates in an interactive Tableau dashboard containing at least four interconnected sheets, where changes to relevant parameters are reflected across the dashboard. Overall, the assessment develops practical competence in Python-based analytics, statistical reasoning, research-question development, hypothesis testing, data visualisation and interactive business intelligence dashboard design. Overview word count: approximately 350 words. AI note: the brief permits AI for limited support such as grammar, structure, organisation of ideas and suggestions, but states that the main content, analysis and conclusions must remain the student's own work. AI use must also be declared.
Read Model Answer →
Business Intelligence / Data Analytics / Project Management
Business Intelligence and Data Analytics Dashboard for Project Progress Evaluation
This group assessment requires students to act as Project Analysts and critically evaluate the progress of a university project using business intelligence, data analytics and project management techniques. The scenario is based on Northumbria University London planning two major events: a Convocation and an associated Concert. Students must select one of these projects and assess its progress through a professionally structured presentation. The assessment requires students to begin by defining the main problem or opportunity associated with the selected project. They must then identify and analyse the project's key stakeholders and deliverables. A major component of the work involves evaluating project progress using suitable business intelligence and data analytics techniques and developing an appropriate dashboard, which may be created using Microsoft Excel or other suitable software. Students must not only present the dashboard but also critically analyse and justify its design, selected metrics, analytical methods and usefulness for project monitoring and decision-making. Because the projects are treated as already being in progress, students are permitted to create assumed or projected data to demonstrate their dashboards. The assessment does not primarily evaluate the accuracy of real project data; instead, it assesses students' ability to design, present and critically evaluate meaningful dashboards. Any assumed data should therefore remain realistic, internally consistent and relevant to the selected project. The presentation should conclude with evidence-based recommendations for the successful implementation and use of the proposed business intelligence or data analytics solution. Academic references and relevant examples must support the presentation, and a single reference list must be included. Assessment weighting places particular emphasis on application of BI tools and techniques (30%), followed by stakeholders and deliverables (20%) and justification of BI tools (20%). Project and opportunity analysis, conclusions and recommendations, and presentation/referencing are each worth 10%. The final assessment is a 15-minute group presentation followed by a 5-minute question-and-answer session. Every group member must contribute to the presentation. The PowerPoint submission is made electronically through Turnitin. Do not select Harvard automatically for this one. Unlike the previous Roehampton brief, this Northumbria brief requires academic references and a reference list but does not state a specific referencing style in the uploaded document.
Read Model Answer →