Part Certification Test Questions and Answers

Scenario 9/11
Task 2 of 2
One of your colleagues has created a short video on some of her favorite American Literature that you want to share with your students later in the semester.

• 
  Locate the video titled, Innovate with Google Translate.mp4 in Drive and upload it to YouTube. Tip: You will need to create a channel. You will need to download the video first, and then upload it to YouTube.
  
• 
  Give it an appropriate description, keep the name Innovate with google Translate.mp4 and make it a private video (enable it is a child appropriate video, then proceed to next screen to adjust visibility) You do not need to wait for the video to finish processing in order to submit the exam.
  

Hint

• 
  To upload a video to YouTube go to your Youtube channel | press upload icon on the top right page | select a video to upload and follow instructions. A new YouTube studio interface will guide you through the uploading process.
  

Scenario 10/11
Task 1 of 1
You are organizing a field trip to Paris and want to share the travel itinerary with the other teachers involved. You will be renting a large bus in order to accommodate the students and chaperones.

• 
  Use Google Maps to find driving directions from the Eiffel Tower, to the Champs Elysees, and on to the the Louvre.
  
• 
  Open Gmail and send an email with the subject line Paris Field Trip with a link to the the shared map with Mr Evans and Miss Garcia
  

Hint

• 
  Go to Google Maps | Search for Eiffel Tower | press directions button | select car icon (you are driving not taking city bus) | enter two other locations.
  
• 
  To share your map open menu on the top left | scroll down to share or embed map | copy a link
  

Scenario 11/11
Task 1 of 1
You are looking at the grades for your students’ progress over four years, but there is a huge volume of data, making it hard to analyze. You want to see the yearly averages for all students who finished Senior year with an “F” grade.

• 
  In Drive, create a pivot table using the data in the Senior Results Sheet. Use these settings to edit your table.
  

Rows – the names of students
Columns – None
Values – The year-end averages for each of the 4 years and the final average
Filter – Filter the pivot table by “Final Grade” and only show of “F”
Hint

• 
  Pivot tables help you summarize data, find patterns, and reorganize information. You can add pivot tables based on suggestions in Google Sheets or create them manually. After you create a pivot table, you can add and move data, add a filter, drill down to see details about a calculation, group data, and more. In Sheets, open your spreadsheet and select the columns with the data that you want to analyze. Make sure your data is in columns with headers. Click Data and then Pivot table. Under Insert to, choose where to add your pivot table. Click Create. Hide data with filters: Under Filters, click Add and select a column to filter. Under Show, click the Down arrow and deselect the items you want to hide. Click OK.