Create a Graph Chart Using software (Excel, Numbers, Google Sheets, etc.) to display the satisfaction level of the patients on the excel chart uploaded
create the Graph Chart correctly with the appropriate number of sectors, appropriate title, and percentage callouts. also highlight the percentage to support the answer.
See attached grading rubric
|
Criteria |
Ratings |
||||
|
Create a Histogram Using software (Excel, Numbers, Google Sheets, etc.) |
7 Points Proficient Student created the Histogram correctly with the appropriate number of bars and class width. |
5 Points Above Average Student created a Histogram with the correct number of bars, but the frequencies are incorrect due to an incorrect class width. |
3 Points Average Student created a Histogram with the wrong number of bars, but it is based on the correct data. |
2 Points Needs Improvement The student created a Bar Graph (Did not fix gap width) or some other major mistakes were found such as drawing a graph on paper. |
0 Points No Effort The student did not attach work for review OR the Histogram was made with the wrong data set. |
|
Histogram Analysis |
10 Points Proficient Student discusses key characteristics of why a Histogram is used versus a Bar Graph highlighting characteristics of both graphs. |
7 Points Above Average Student discusses key characteristics of why a Histogram is used versus a Bar Graph but only highlights characteristics of a Histogram. |
4 Points Needs Improvement Student does not discuss key components of why a Histogram would be used versus a Bar Graph. |
0 Points No Effort The student does not have an answer for review. |
|
|
Create a Pie Chart Using software (Excel, Numbers, Google Sheets, etc.) |
7 Points Proficient Student created the Pie Chart correctly with the appropriate number of sectors, appropriate title, and percentage callouts. |
5 Points Above Average Student created a Pie Chart with the correct number of sectors but is missing appropriate tile and/or percentage callouts. The pie chart is made |
3 Points Average Student created a Pie Chart with the wrong number of sectors, but it is based on the correct data. |
2 Points Needs Improvement The student created use a different type of graph or some other major mistakes were found such as drawing a graph on paper. |
0 Points No Effort The student did not attach work for review OR the pie chart was made with the wrong data set. |
|
Pie Chart Analysis |
10 Points Proficient The student chooses the correct answer and highlights the percentage to support their answer. |
7 Points Above Average The student chooses the correct answer but does NOT highlight the percentage to support their answer. |
5 Points Average The student chooses the incorrect answer but the pie chart was constructed correctly. |
3 Points Needs Improvement The student chooses the correct answer based on pie chart that was constructed incorrectly (based on the correct data). |
0 Points No Effort The student does not have an answer for review. |
|
Create a Bar Graph Using software (Excel, Numbers, Google Sheets, etc.) |
7 Points Proficient Student created the Bar Graph correctly with the appropriate number of bars, appropriate title and axis labels. |
5 Points Above Average Student created a Bar Graph with the correct number of bars, but it is missing a tile or axis labels. OR The student changed the order of the bars which could make the graph Misleading. |
3 Points Average Student created a Bar Graph with the wrong number of bars, but it is based on the correct data OR The graph is correct but it is missing both the title and axis labels. |
2 Points Needs Improvement The student submitted a graph that was not a bar graph or some other major mistakes were found such as drawing a graph on paper. |
0 Points No Effort The student did not attach work for review OR the Bar Graph was made with the wrong data set. |
|
Bar Graph Analysis |
12 Points Proficient The student makes an inference based on the graph AND The student provides research of how patient satisfaction can be improved in the ER AND The student cites at least one source. |
8 Points Above Average The student makes an inference based on the graph AND The student provides research of how patient satisfaction can be improved in the ER but does not provide at least one source. |
7 Points Average The student makes an inference based on the graph OR The student provides research of how patient satisfaction can be improved in the ER AND The student cites at least one source. |
4 Points Needs Improvement The student makes an inference based on the graph OR The student provides research of how patient satisfaction can be improved in the ER but the student does not cite at least one source. |
0 Points No Effort The student does not have an answer for review. |
|
Determining an appropriate graph. |
12 Points Proficient The student chooses the correct type of graph to display the assigned data AND The student provides proficient reasoning to why the graph selected should be constructed AND The student discusses key points that a viewer of the graph would extract if the graph was constructed. |
8 Points Above Average The student chooses the correct type of graph to display the assigned data AND The student provides basic reasoning to why the graph selected should be constructed AND The student discusses key points that a viewer of the graph would extract if the graph was constructed. |
7 Points Average The student does not choose the correct type of graph to display the assigned data AND The student provides reasoning to why the graph selected should be constructed AND The student discusses key points that a viewer of the graph would extract if the graph was constructed. |
4 Points Needs Improvement The student does not choose the correct type of graph to display the assigned data AND The student provides reasoning to why the graph selected should be constructed OR The student discusses key points that a viewer of the graph would extract if the graph was |
0 Points No Effort The student does not have an answer for review. |
,
Sheet1
| Wait Time | Age | Weight | Height | Temp | Insurance | Out of Pocket Pay | Income | Satisfaction |
| 18 | 40 | 165 | 69 | 99 | Shield | 25 | 180000 | 5 |
| 15 | 27 | 118 | 64 | 98 | Blue Cross | 20 | 65500 | 5 |
| 60 | 23 | 135 | 66 | 98.9 | PPPlan | 20 | 60000 | 3 |
| 35 | 18 | 120 | 69 | 101 | PPPlan | 30 | 50000 | 4 |
| 90 | 20 | 208 | 71 | 99 | Blue Cross | 20 | 70000 | 1 |
| 10 | 88 | 125 | 68 | 102 | Shield | 20 | 85000 | 4 |
| 30 | 84 | 275 | 69 | 99.9 | No Insurance | 200 | 60000 | 3 |
| 45 | 90 | 115 | 54 | 100.1 | Shield | 30 | 40000 | 4 |
| 8 | 25 | 189 | 68 | 98 | Stone | 30 | 85000 | 5 |
| 27 | 75 | 190 | 67 | 103 | PPPlan | 25 | 67000 | 4 |
| 20 | 15 | 109 | 73 | 102 | Blue Cross | 40 | 45000 | 3 |
| 15 | 65 | 154 | 68 | 102 | Shield | 50 | 50000 | 5 |
| 30 | 30 | 220 | 67 | 101.5 | Shield | 15 | 55000 | 3 |
| 35 | 20 | 134 | 60 | 99 | PPPlan | 20 | 108000 | 4 |
| 38 | 88 | 145 | 61 | 103 | Blue Cross | 25 | 95000 | 4 |
| 39 | 90 | 176 | 69 | 98.7 | Shield | 25 | 88000 | 3 |
| 66 | 22 | 230 | 73 | 98.7 | Shield | 30 | 95000 | 2 |
| 90 | 85 | 215 | 68 | 101 | Blue Cross | 20 | 60000 | 2 |
| 80 | 49 | 208 | 72 | 102 | Stone | 25 | 90000 | 2 |
| 25 | 59 | 156 | 71 | 97.6 | Shield | 25 | 85000 | 4 |
| 40 | 41 | 155 | 66 | 98 | Stone | 25 | 75000 | 3 |
| 45 | 88 | 135 | 69 | 96.8 | Blue Cross | 40 | 108000 | 2 |
| 60 | 30 | 188 | 65 | 97 | Stone | 20 | 90000 | 3 |
| 61 | 65 | 134 | 65 | 99.9 | Shield | 25 | 65000 | 3 |
| 40 | 45 | 175 | 69 | 98.2 | Blue Cross | 30 | 80000 | 3 |
| 60 | 20 | 123 | 60 | 98 | No Insurance | 20 | 50000 | 3 |
| 70 | 21 | 200 | 72 | 99 | Shield | 50 | 50000 | 2 |
| 85 | 18 | 135 | 59 | 103.1 | Blue Cross | 50 | 70000 | 1 |
| 80 | 23 | 130 | 58 | 102 | PPPlan | 20 | 85000 | 2 |
| 88 | 42 | 190 | 67 | 98 | Blue Cross | 25 | 60000 | 2 |
Sheet2
Patient Satisfaction
Out of Pocket Pay Shield Blue Cross PPPlan PPPlan Blue Cross Shield No Insurance Shield Stone PPPlan Blue Cross Shield Shield PPPlan Blue Cross Shield Shield Blue Cross Stone Shield Stone Blue Cross Stone Shield Blue Cross No Insurance Shield Blue Cross PPPlan Blue Cross 99 98 98.9 101 99 102 99.9 100.1 98 103 102 102 101.5 99 103 98.7 98.7 101 102 97.6 98 96.8 97 99.9 98.2 98 99 103.1 102 98 69 64 66 69 71 68 69 54 68 67 73 68 67 60 61 69 73 68 72 71 66 69 65 65 69 60 72 59 58 67 165 118 135 120 208 125 275 115 189 190 109 154 220 134 145 176 230 215 208 156 155 135 188 134 175 123 200 135 130 190 40 27 23 18 20 88 84 90 25 75 15 65 30 20 88 90 22 85 49 59 41 88 30 65 45 20 21 18 23 42 18 15 60 35 90 10 30 45 8 27 20 15 30 35 38 39 66 90 80 25 40 45 60 61 40 60 70 85 80 88 25 20 20 30 20 20 200 30 30 25 40 50 15 20 25 25 30 20 25 25 25 40 20 25 30 20 50 50 20 25 Income Shield Blue Cross PPPlan PPPlan Blue Cross Shield No Insurance Shield Stone PPPlan Blue Cross Shield Shield PPPlan Blue Cross Shield Shield Blue Cross Stone Shield Stone Blue Cross Stone Shield Blue Cross No Insurance Shield Blue Cross PPPlan Blue Cross 99 98 98.9 101 99 102 99.9 100.1 98 103 102 102 101.5 99 103 98.7 98.7 101 102 97.6 98 96.8 97 99.9 98.2 98 99 103.1 102 98 69 64 66 69 71 68 69 54 68 67 73 68 67 60 61 69 73 68 72 71 66 69 65 65 69 60 72 59 58 67 165 118 135 120 208 125 275 115 189 190 109 154 220 134 145 176 230 215 208 156 155 135 188 134 175 123 200 135 130 190 40 27 23 18 20 88 84 90 25 75 15 65 30 20 88 90 22 85 49 59 41 88 30 65 45 20 21 18 23 42 18 15 60 35 90 10 30 45 8 27 20 15 30 35 38 39 66 90 80 25 40 45 60 61 40 60 70 85 80 88 180000 65500 60000 50000 70000 85000 60000 40000 85000 67000 45000 50000 55000 108000 95000 88000 95000 60000 90000 85000 75000 108000 90000 65000 80000 50000 50000 70000 85000 60000 Satisfaction Shield Blue Cross PPPlan PPPlan Blue Cross Shield No Insurance Shield Stone PPPlan Blue Cross Shield Shield PPPlan Blue Cross Shield Shield Blue Cross Stone Shield Stone Blue Cross Stone Shield Blue Cross No Insurance Shield Blue Cross PPPlan Blue Cross 99 98 98.9 101 99 102 99.9 100.1 98 103 102 102 101.5 99 103 98.7 98.7 101 102 97.6 98 96.8 97 99.9 98.2 98 99 103.1 102 98 69 64 66 69 71 68 69 54 68 67 73 68 67 60 61 69 73 68 72 71 66 69 65 65 69 60 72 59 58 67 165 118 135 120 208 125 275 115 189 190 109 154 220 134 145 176 230 215 208 156 155 135 188 134 175 123 200 135 130 190 40 27 23 18 20 88 84 90 25 75 15 65 30 20 88 90 22 85 49 59 41 88 30 65 45 20 21 18 23 42 18 15 60 35 90 10 30 45 8 27 20 15 30 35 38 39 66 90 80 25 40 45 60 61 40 60 70 85 80 88 5 5 3 4 1 4 3 4 5 4 3 5 3 4 4 3 2 2 2 4 3 2 3 3 3 3 2 1 2 2
