Understanding Patient Data
Data Presentation: NJ OSME Drug-Related Deaths in NJ Counties
This assignment focuses on data presentation and management using drug-related death data from New Jersey counties. The assignment is part of the Understanding Patient Data course and develops practical skills in inspecting, cleaning, organizing, analyzing, and presenting patient-related datasets using Microsoft Excel. Students are required to use the data provided in the file “5.3a Chart on Drug Deaths by NJ County (2015)” and input the county-level information into an Excel spreadsheet. The assignment requires students to inspect and clean the data where necessary, including removing, imputing, and explaining incomplete data entries. Students must also organize and sort the data and obtain descriptive statistics for heroin drug-related deaths and a second variable of their choice. The analysis includes creating descriptive statistics for four variables and comparing the descriptive statistics of heroin with a selected variable. Students must create a copy of the original dataset on a separate worksheet, sort total deaths from largest to smallest, and create a 2-D bar chart and scatterplot. The charts are then used to develop interpretive statements about heroin-related deaths based on the combined analysis of the visualizations. The assignment also requires students to use descriptive statistics to compare the central tendency of three specified variables: Cocaine, Fentanyl, and Oxycodone. A separate worksheet must contain a key or log explaining variable names, abbreviations, and terms used in the dataset. The assignment develops practical skills in Excel-based healthcare data analysis, descriptive statistics, data visualization, interpretation of patient data, and data management. The grading criteria include data input and cleaning, descriptive statistics, sorted data, bar chart creation, scatterplot presentation, and interpretive analysis. The completed assignment must be submitted electronically in Microsoft Excel (.xls or .xlsx) format.
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 →