I Heart Matters is a health and wellness center that promotes lifestyle changes. They want to issue a public service announcement to a targeted audience, those without healthcare coverage, and they need your help! Specifically, you have been asked to gather preliminary data to address the following research question: What is the relationship between patients without health coverage that smoke regularly and those that have been told they have asthma? To help Heart Matters achieve their goal, you must gather relevant data. That data must then be analyzed. For this assignment, you will gather preliminary data, properly format the data, import the data into an SQL table for analysis, and finally document your process in a status report using the template provided. Prompt To address the research question, complete the following steps to gather preliminary data for analysis: Variables of Interest Examine the Heart Matters LLCP 2017 data set and codebook and determine the variables of interest to address this research question. Discuss their relevance to the research question in your status report. Consider what other variables or types of data you may need to fully address the research question. Data Set Preparation Delete all other columns of data, leaving only the essential data to import into the MySQL Workbench. Identify the variable names in Row 1 and their associated datatypes based on the information provided in the accompanying codebook. Be sure to capture this information in order to accurately import the data and for use in your status report. Unfamiliar with Datatypes? Review the MySQL Data Types article to become familiar with datatypes in MySQL. Next, delete Row 1 to remove the variable names from the data set and ensure the data is imported properly. Save the revised data set in the proper format as Revised_LLCP2017_data set.csv. Be sure to save the file in a place where it is easily accessible, such as your Desktop. You will submit this revised data set as a CSV file, in addition to your status report. Now that your data file has been modified to include only variables of interest, you need a tool to aid in the analysis of this data. For this assignment, you will work in the MySQL Workbench via Codio. Navigate to Codio by going to the Codio module and clicking Codio. Upload the revised data set you prepared in Step 5. To do this, drag and drop the data set from your File Explorer into the Filetree in Codio as shown below. The Desktop File Explorer window is overlaid on the Codio Terminal. Within the File Explorer Window, an Excel file titled Navigate to the MySQL Workbench by following the instructions in the Launching MySQL in Codio Tutorial. Gathering Data Follow the steps outlined in How to Import a CSV File into MySQL Workbench to create a new table and import the revised data set (Revised_LLCP2017_data set.csv) into the new table. Include a screenshot in your status report to show you have effectively gathered the relevant data using the tool provided. Process for Gathering Data Now your data is ready for analysis! It is important to discuss the steps you took to gather the data, in order to show how the data has changed over time and how it will be used. In your status report, clearly explain each step of the process for gathering data into the proper format using the tool (MySQL) provided. Guidelines for Submission Complete the status report using the template provided, removing all bracketed text. Submit your completed status report. Be sure to include and annotate the screenshots as outlined in the Prompt above. You will also submit the revised CSV file you prepared in Step 5.have an assignment due on Saturday and need help.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
