Scenario 4/11
Task 1 of 4
You have recorded the scores your students achieved in their last 4 physics tests. You now plan to analyze the data to review the progress of your students.
-
Open the Physics Test Sheet and use the formula function to calculate the average score for each student.
[Hint: find google sheet Physics Test in your drive | calculate the average score for each student. Note you can drag + sign down the column to apply the same formula to all lines].
Task 2 of 4
You want to compare the top performers in your class.
-
Use the filter to sort the students in descending order (largest to smallest) by average score.
[Hint: use filter to sort by score].
Task 3 of 4
You feel a visual representation would be the best way to compare the students results.
-
Create 2 charts from the student test data and place them in the Sheet.
[Hint: click chart icon on the to tollbar to create a chart | select chart data in the right sidebar].
-
Share the Sheet with your colleague Mr. Evans.
[Hint: click the share button on the top right | find the evans to share the document | click send].
Task 4 of 4
You decide to share the most compelling chart with your school’s principal.
-
Identify one of the two charts that is the most compelling. Use the menu options on the chart to move it to its own sheet titled Physics Test Chart
(Hint: Use the menu on the chart itself.)
[Hint: click on the chart | click dor menu on the top right | select “move to own sheet”].
-
Share Physics Test Chart with your principal Mr. Anderson.
[Hint: click the share button on the top right | find Anderson to share the document | click send].
Do'stlaringiz bilan baham: |
