I need help with d3 in data Visualization

 YO19_IntegratedProject_1_LaundryProposal 1.1

YO19_IntegratedProject_1_LaundryProposal 1.1

Project Description:

As a student at the university, you have an entrepreneurial spirit and have dreamed of starting your own business. You have noticed that the coin laundry in your dorm is always full and crowded. You saw an opportunity to start a business that picks up laundry at the dorms, launders the clothes, folds the clothes, and returns the laundry in a single day. The first step to starting this business is to create a proposal for the university to approve the service to have some operations within the dorms. You started by conducting a survey of your fellow students. The next step is to process the survey results and create a proposal for the university.

Steps to Perform:

Step

Instructions

Points    Possible

1

Start   Word. Download and open the file named IntegratedProject_1   – LaundryUProposal.docx. Grader has automatically added your last name to   the beginning of the filename. Click Enable Editing, if necessary.

0

2

Branding is always important both internally and   externally. Images and logos can help you brand.
 

  Press CTRL+HOME to place the cursor at the beginning of the document. insert   the image LaundryULogo.jpg. Change   the width of the image to 1.5 inches. Change the layout to In Front of Text   and then align the image Right relative to the margin.
  Hint: On the Picture Format tab, use the tools in the Arrange group and the   Size group to format the picture.

4

3

Change   the document theme to Feathered and the theme colors to Blue Warm. Change the   margins to Narrow.
 

  If the theme is not available, click Browse for Themes, and then select the   downloaded theme file Feathered.thmx.

2.4

4

Spelling mistakes are unprofessional as they make   the author appear to be unable to spell properly.
 

  Check the spelling to correct all spelling errors. LaundryU is the name of the business and is spelled correctly.

2

5

Styles   help you format even if you are not very good with design.
 

  Set the style for the first three lines in the document to Heading 1.
  On the sixth line down change the salutation of Dear Director, to a style of Heading 2. Change the line that   reads We did a survey of 100 students   in the dorm and found: style to be Heading 2.

4

6

A name should look like a signature.
 

  On the next to last line, change the font of Matthew Thomas to Lucida Handwriting.

0.8

7

Open   the downloaded LaundryUSurvey.xlsx   file. On the Q1 worksheet, in cell E2, enter a function that calculates how   many students answered yes to the survey using the data in cell B2:B101.
  Hint: You will be using the COUNTIF Function. See Excel Chapter 2: Activity   2.08

2

8

On the Q1 worksheet, in cell E3, enter a function   that calculates how many students answered no to the survey using the data in   cell B2:B101.

2

9

Using   the data in cells D2:E3, insert a 3-D Pie Chart. Change the chart title to Interested in   LaundryU Service?   Change the chart style to Style 3.

4

10

Select the chart and copy it. Display the IntegratedProject_1 –   LaundryUProposal.docx file, and be sure your insertion point is   positioned on the line underneath Would   you be interested in a laundry service that picks up and delivers to your   dorm? On the Home tab, in the Clipboard group, click the Paste arrow, and   then under Paste Options, click Use Destination Theme & Link Data.

4

11

In the IntegratedProject_1 –   LaundryUProposal.docx file, center the chart. Set the width of the chart   to 4 inches and the height to 2 inches. Change the font size of the chart   title to 12.

2.4

12

When looking at results of this survey, it is   important to look at more than just the average price the students are   willing to pay to get an idea of distribution of the results. Considering   just an average in a decision could lead to erroneous or poor decisions.
 

  Display LaundryUSurvey.xlsx. On the   Q2 worksheet using the data in cells B2:B40, calculate the following:
  In cell F2 calculate the average price students were willing to pay.
  In cell F3 calculate the standard deviation of the sample.
  In cell F4 calculate the sample size.
  In cell H3 calculate the minimum price students were willing to pay.
  In cell H4 calculate the maximum price students were willing to pay.
  Hint:
  For Standard Deviation, use the STDEV.S Function
  For the Sample Size, use the COUNTA Function

6

13

On the   Q2 worksheet, format cells F2, F3, H3, and H4 to Accounting. Format cell F2   to bold. Set the fill color for cells F2:H4 to White, Background 1.

2.4

14

Select cells   E2:H4 and copy the range. Display the IntegratedProject_1   – LaundryUProposal.docx file, and be sure your insertion point is   positioned on the line underneath If   yes, how much would you be willing to pay per bag (approximately 1 load of   laundry)? On the Home tab, in the Clipboard group, click the Paste arrow,   and then click Paste Special. In the Paste Special dialog box under As, click   Microsoft Excel Worksheet Object. Then, click OK. Center the embedded Excel   Worksheet Object.

4

15

Save   and Exit Excel. Save and close IntegratedProject_1   – LaundryUProposal.docx. Exit Word. Submit your Word file as directed.

0

Total   Points

40

Exp19_Excel_Ch03_CapAssessment_Movies

Exp19 Excel Ch03 CapAssessment Movies

Project Description:

You are an assistant manager at Premiere Movie Source, an online company that enables customers to download movies for a fee. You need to track movie download sales by genre. You gathered the data for April 2021 and organized it in an Excel workbook. You are ready to create charts to help represent the data so that you can make a presentation to your manager later this week.

Start   Excel. Download and open the file named Exp19_Excel_Ch03_CapAssessment_Movies.xlsx. Grader has automatically added   your last name to the beginning of the filename.

You want to create a pie chart   to show the percentage each category contributes to the monthly movie   downloads.
 

  Select the ranges A5:A10 and F5:F10. Create a pie chart and move it to a   chart sheet named April Pie Chart.

The chart needs a descriptive   title that is easy to read.
 

  Type April   2021 Downloads by Genre as the chart title, apply bold, 18 pt font size, and Black, Text   1 font color.

Percentage and category data   labels will provide identification information for the pie chart.
 

  Add category and percentage data labels in the Inside End position. Remove   value data labels and the legend. Apply 14 pt font size and Black, Text 1   font color.

You want to focus on the comedy   movies by exploding it and changing its fill color.
 

  Explode the Comedy slice by 7% and apply Dark Red fill color.

A best practice is to include   Alt Text for accessibility compliance.
 

  Add Alt Text: The pie chart shows percentage of downloads by genre   for April 2021.   (including the period)

Next you want to create a combo   chart to depict the monthly totals and percentages by category.
 

  Display the Data sheet, select the ranges A4:A10 and F4:G10, and then create   a Clustered Column – Line on Secondary Axis combo chart.

You want to position the chart   below the data source.
 

  Cut the chart and paste it in cell A13. Change the height to 3.5″ and the width to 6″.

Change the combo chart title to April 2021   Downloads.   Apply Black, Text 1 font color to the chart title.

Axis titles will help   distinguish the number and percentage of downloads.
 

  Add a primary value axis title and type Number of Downloads. Add a secondary value axis   title and type Percentage of Monthly Downloads. Apply Black, Text 1 font color   to both value axis titles.

Now that you added an axis title   for each vertical axis, you can remove the legend and format the secondary   value axis to display whole percentages.
 

  Remove the legend for the combo chart. Display 0 decimal places for the   secondary value axis.

You want to add some color to   the plot area for the combo chart.
 

  Apply Light Gradient – Accent 1 gradient fill color for the plot area.

A best practice is to include   Alt Text for accessibility compliance.
 

  Add Alt Text: The combo chart shows the number and percentage of   downloads by genre for April 2021. (including the period).

To provide a visual summary of   the weekly totals for each genre, you will insert sparklines.
 

  Select the range B5:E11. Insert Line Sparklines in the range H5:H11. Apply   Black, Sparkline Style Dark #4

Displaying the markers helps   identify the specific points on the sparklines. You will also change the high   point to a different color to stand out.
 

  Show the high point and markers for the sparklines. Change the high point   marker color to Red.

Your last major task is to   create a bar chart for weekly downloads.
 

  Select the range A4:E10. Create a stacked bar chart. Move the chart to new   chart sheet. Type Weekly Downloads for the sheet name. Apply Style 8 chart style.

Add a chart title above the bar   chart and type April 2021 Weekly Downloads by Genre. 

Increasing the font size will   make the chart elements easier to read.
 

  Apply 11 pt font size to the category axis, value axis, and the legend for   the bar chart.

Because the largest value is   less than 9,000, you can reduce the maximum bound in the chart. In addition,   you want to display the category labels in the same order that they are in   the worksheet.
 

  Change the maximum bounds for the value axis to 9000 and set the Major Units to 500 for the bar chart. Use the Axis   Options to format the category axis so that the category labels are in   reverse order in the bar chart.

Although the bar chart displays   major gridlines, minor gridlines could improve the appearance.
 

  Add primary minor vertical gridlines to the bar chart.

A best practice is to include   Alt Text for accessibility compliance for the bar chart.
 

  Add Alt Text: The stacked bar chart shows downloads by each week for   each genre.   (including the period).

Insert a footer with Exploring   Series on the   left, the sheet name code in the center, and the file name code on the right   on all the sheets. Change to Normal view.

Save and close Exp19_Excel_Ch03_CapAssessment_Movies.xlsx.   Exit Excel. Submit the file as directed.

1. What is the definition of data mining that the author mentions?  How is this different from our current understanding of data mining?
2. What is the premise of the use case and findings?
3. What type of tools are used in the data mining aspect of the use case and how are they used?
4. Were the tools used appropriate for the use case?  Why or why not?

 Follow PDF attached are part 1 and 2 I need part 3 done when you complete it please answer the following question  Provide the instructor with a short (8-12 sentence) reflection on the progress your group has made so far.

• What do you like about the way the final project is going?
• What are you unsure about?
• What have you learned during this process that will be useful to you in your career? 

This is a chance to ask direct questions to your instructor before submitting your final project in Unit 7.   

Write a 2-3 page paper (deliverable length does not include the title and reference pages)

• Describe how to use Web browser settings and browser additions to create stronger security
• List several Internet security best practices

You will review both quantitative and qualitative research.  The topic is up to you as long as you choose a peer-reviewed, academic research piece.  I suggest choosing a topic that is at least in the same family as your expected dissertation topic so that you can start viewing what is out there.  There are no hard word counts or page requirements as long as you cover the basic guidelines.  You must submit original work, however,  and a paper that returns as a large percentage of copy/paste to other sources will not be accepted.  (Safe Assign will be used to track/monitor your submission for plagiarism. Submissions with a Safe Assign match of more than 25% will not be accepted.) Please use APA formatting and include the following information:

• Introduction/Background:  Provide context for the research article.  What led the author(s) to write the piece? What key concepts were explored? Were there weaknesses in prior research that led the author to the current hypothesis or research question?
• Methodology:  Describe how the data was gathered and analyzed.  What research questions or hypotheses were the researchers trying to explore? What statistical analysis was used?
• Study Findings and Results:  What were the major findings from the study? Were there any limitations?
• Conclusions:  Evaluate the article in terms of significance, research methods, readability, and the implications of the results.  Does the piece lead to further study? Are there different methods you would have chosen based on what you read? What are the strengths and weaknesses of the article in terms of statistical analysis and application? (This is where a large part of the rubric is covered.) 
• References  

Identification and description of the key components of a comprehensive Incident Response Plan(IRP) for any attack on an organization’s network and data. The plan starts with the identification of trigger events and includes immediate actions that should be taken. 

Provide a reflection of at least 500 words of how the knowledge, skills, or theories of “Human-Computer interaction and usability” course have been applied, in a practical manner to your current work environment (As a Dot net developer). 

Provide a reflection of at least 500 words of how the knowledge, skills, or theories of “Organ leader and decision making” course have been applied, in a practical manner to your current work environment (As a Dot net developer). 

Assignment:

This project requires you to develop an Excel spreadsheet from scratch that incorporates the key features that you have learned about throughout the course. You will be graded on use of all features, professional impact, organization, creativity and overall impression. (Remember, creativity makes an impression!) Upon completion, upload your Project to the Assignments area of the classroom.

Topic: Management assigned you the task of organizing an award ceremony for your organization. They have asked you to organize data into a spreadsheet so they can easily view and manipulate the award types and amounts before decisions are made. The overall budget is an amount of your choosing. All of this information should be fictitious. You are required to create a spreadsheet to track all of the following items:

Details:
– Organization size: 30
– Award Ceremony Date: December 5th
– Two Types of Awards: Performance Award and Special Commendation Award
– Performance Awards can be given in the range of $500 – $5000
– Special Commendation Awards can be given in the range of $500 – $2000

Data to include:
– List of all employees receiving awards (should be at least 50% of employees)
– Type of award each employee will receive
– Amount of award each employee will receive
– Percentage of overall budget that each employee’s award will represent
– Percentage of overall budget that each type of award will represent
– Column totals using formulas

Features of Excel to Include:
– Use of formulas for adding and computing percentages
– Changes to font size and style, as appropriate for impact
– Label on worksheet 
– Use Headings/Titles for each category listed
– Format currency to zero decimal places
– Adjust width of columns or wrapping the text within cells to avoid overlap of adjacent cells by long text entries
– Use color to emphasize important aspects of the sheet
– Use borders to separate sheet into appropriate sections
– Charts to show data

Submission Instructions: Submit your completed project as a Microsoft Excel attachment