ScenarioA middle school has decided that it would like to make its students' grades available to their parents via an online parent portal. In addition, this system will allow for important announcements to be posted. The school has decided that a system will be developed in-house to complete this project. In doing so, a number of processes need to be identified during the planning of the project.Some of the processes for teachers can include: Logging in to the system Uploading grades Posting announcements Some of the processes for parents can include: Log on to the system Accessing and reading important announcements Viewing student’s grades Sending an e-mail to the student's teacher via the system on questions regarding the student's gradesBased on the scenario, choose any of the processes, for teachers or for parents, and complete the following tasks to create a report in a Microsoft Word document: Define the problem and the current need in the given situation. Create a hierarchy chart depicting the chosen situation. Develop a flowchart and provide a brief explanation for it. Develop an algorithm and provide a brief explanation for it. Explain how arrays can be used within your choice.Part 2: Alice TutorialThe output will be an Alice World file.Build a world containing a person who can calculate the average from a sequence of numbers in his or her head. Have the person ask the user how many numbers are in the sequence and then use the getDoubleFromUser() function to get the numbers from the user. When all the numbers have been entered, have the person “say” the average of those numbers.Support your responses with appropriate research, reasoning, and other examples.Cite any sources in APA format on a separate page.Name your document SUName your Alice World file as SU

Data Presentation Assignment Complete the following using Excel spreadsheet software.  If you wish, you may create one file for each number.  Construct a two variable bar graph comparing the ages of death of males and females for the grouped frequency distribution (see data below). Age Group Males Females Total 80-89 2 3 5 70-79 2 1 3 60-69 2 4 6 50-59 4 5 9 40-49 4 2 6 30-39 2 1 3 20-29 0 1 1 10-19 0 0 0 0-9 1 1 2 Construct a two variable bar graph comparing the number of deaths under 48 hours and over 48 hours (see data below). Deaths Year Under 48 hours Over 48 hours 2000 72 253 2001 68 278 2002 64 268 2003 58 254 2004 52 246 Construct a line graph of autopsy rates, comparing the percentage of deaths that were unautopsied versus those that were autopsied or were coroner’s cases (see data below). Year Deaths Unautopsied Autopsies Coroner # % # % # % 2000 312 247 79 58 19 7 2 2001 344 281 82 52 15 11 3 2002 338 273 81 55 16 10 3 2003 310 264 85 41 13 5 2 2004 323 272 84 47 15 15 1 Construct a histogram showing the frequency distribution of the lengths of stay of patients at least 1 year old that underwent neurosurgery (see data below). LOS (days) Frequency 33-34 1 31-32 0 29-30 0 27-28 0 25-26 0 23-24 0 21-22 1 19-20 1 17-18 0 15-16 1 13-14 4 11-12 1 9-10 1 7-8 6 5-6 14 3-4 24 1-2 21 Semiannual surgical records reveal the following number of surgical procedures performed on inpatients, and their respective percentages.  Construct a pie graph to represent the data below. Procedure by Medical Specialty Number of Procedures % Cardiovascular surgery 62 18 Thoracic/Pulmonary surgery 36 10 ENT surgery 12 3 General surgery 111 32 Neurosurgery 5 1.5 Orthopedic surgery 57 16 Urologic surgery 27 8 Gynecologic surgery 40 11.5 The average length of stay (number of days) for the years 1980, 1990 and 2000, by age groups were recorded.  Construct a 3 variable bar graph to represent the data below. Age 1980 1990 2000 <5 years 7.8 6.2 5.2 5-14 years 4.3 5.2 5.0 15-44 years 7.6 5.4 4.4 45-64 years 10.7 6.7 5.6 65-74 years 11.9 8.0 6.5 75+ years 12.4 8.9 7.7 All ages 8.9 6.7 5.6 The average length of stay (number of days) for the years 1980, 1990 and 2000, by geographic region, were also recorded.  Construct a 3 variable bar graph to represent the data below. Region 1980 1990 2000 Northeast 10.1 7.3 6.9 Midwest 8.7 6.2 5.0 South 8.2 6.7 5.6 West 8.9 6.3 5.4 Pretend that you have just aggregated the data below.  You now need to present this to me, your supervisor.  Create 3 graphs to show me the 3 most significant findings you can identify from the data.  (You determine the significance – there is no correct answer.)  Show me some interesting stuff so I don’t have to spend a lot of time analyzing the data myself. The number of cases of cancer per 100,000 population for the years 1980, 1985, 1990, 1995 and 2000 were recorded as follows: Population 1980 1985 1990 1995 2000 White males:   Colorectal 58.7 63.4 59.0 53.0 48.1   Pancreatic 11.1 10.7 10.1 9.8 9.2   Lung & bronchial 82.2 82.0 80.9 74.5 71.2   Non-Hodgkin’s lymphoma 12.6 15.9 19.6 20.6 20.8   Prostate 78.8 87.1 133.0 140.0 129.8 Black males:   Colorectal 63.5 60.8 59.7 59.8 53.5   Pancreatic 17.6 19.7 15.4 17.4 15.1   Lung & bronchial 131.0 131.3 118.6 113.3 115.7   Non-Hodgkin’s lymphoma 9.3 10.0 14.2 17.9 18.6   Prostate 126.7 133.6 173.3 245.7 210.1 White females:   Colorectal 44.7 45.9 40.2 37.0 36.4   Pancreatic 7.3 8.1 7.7 7.6 7.2   Lung & bronchial 28.2 35.9 42.5 44.5 44.0   Non-Hodgkin’s lymphoma 9.2 11.4 12.9 13.5 12.4   Breast 87.8 107.2 114.4 114.8 115.7 Black females:   Colorectal 49.6 45.9 49.5 46.9 43.3   Pancreatic 13.0 11.3 10.3 12.0 12.5   Lung & bronchial 33.8 40.2 46.9 49.3 42.7   Non-Hodgkin’s lymphoma 6.0 7.1 9.3 7.2 9.5   Breast 74.3 92.5 97.7 101.9 101.3