00% Free & updated Google Educator Level Certification Test Exam Questions & Answers

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].