Google Educator Level 2 Certification Answers
This guide helps you get prepared to Google Certified Educator Level 2.
Get prepared, explanation of the correct answers to help you study and get a better understanding of what topics you need to deep dive more by understanding the test format, and detailed explanation on several topics.
The exam consist in:
- 26 Questions
- 12 Practical
The study guide contain:
- The actual Questions of theory and Practical part (recommended to practise before the exam to save your time)
- Video about doing practice part of the exam
The language of the answers are in English.
Miss Tanaka regularly runs review sessions for her students before exams, as her students forget what topics have been covered and where they can access the resources used in class.
How should she use Blogger effectively to reduce the amount of review sessions she needs to run?
She can embed a Sheet containing the class topics and links to resources, and update it after each class.
She can create a video giving students a quick overview of the semester, and upload it to Blogger at the end of the semester.
She can upload all her lesson plans and notes into the File Cabinet in Blogger so students can only access them at school.
She can create a new blog post after every class with the lesson overview, notes and links to resources.
Match each personalized learning method to its corresponding learning process by moving the rows up and down.
(Personalized learning method)
Students work through the content outside of school hours and spend classroom time discussing the content in more depth.
Students work individually or within a group to decide how to solve a problem and present their findings to the rest of the class.
An integration of online and classroom-based instruction, freeing teachers to assist smaller groups of students who require additional support.
Mr Franco is a busy high school teacher who wants to increase his productivity between classes using some of the core G Suite for Education tools.
What can he do to achieve this?
Subscribe to the Google for Education YouTube channel for tips and tricks to make better use of core G Suite for Education tools.
Install G Suite Business for advanced versions of the G Suite for Education tools.
Explore features like Undo Send, Canned Responses, and Advanced features to enhance their core features and add new functionality.
Install Chrome extensions to enhance his Chrome browser search bar functionality.
Ms. Weber distributes a Google Doc to students on the subject of plant biology. Some students have trouble understanding some of the key terms.
What are some ways Ms. Weber can coach her students to use features in Google Docs to better help her students comprehend key vocabulary?
Hint: "embed" implies the item appears within the item and is not a hyperlink
Ms. Weber can prompt students to right click on key vocabulary and select "Define" or "Explore"
Ms. Weber can embed a Google Drawings in the original Google Doc to visually represent complex terms
Ms. Weber can embed Google Slides into the original Google Doc as a reference to previous lectures
Mr Morgan wants his students to watch a long video he produced in YouTube, and then discuss specific sections in the following lesson. What is the most efficient way he can make it easier for students to find specific sections within the video, without leaving YouTube?
Provide a Doc or Sheet listing key sections and their timestamps.
Provide a table of contents at the start of the video with links to each section.
Edit the video into smaller individual sections with relevant names.
List the key sections, timestamps, and links to specific times in the video in the Comments section of the video.
Mr Biggins wants his students to develop their vocabulary as their creative writing skills often lack creativity. A fellow teacher mentioned that by simply using a dictionary Chrome extension can help.
Where can he find Chrome extensions?
Google Play for Education
Google Search Advanced Tools
Chrome Web Store
Mr Grant has experienced issues with students losing focus and not being able to find information online that they had previously found.
What can Mr Grant do to help his students improve their online research productivity?
Install a desktop monitoring application so he can see each student's desktop in real-time and provide tips on how to improve their search activities.
Encourage students to use the bookmark feature in Chrome
Force users to follow the same search criteria when searching for information online.
Remove their device if they are found searching for irrelevant and inappropriate content.
Mr Snipes is trying to explain to the department head of English why his school should look into using Google Lit Trips to improve enthusiasm for reading.
What should he mention in this discussion?
Lit Trips are library tours run by the Google for Education team, showcasing how public libraries have adopted G Suite to enhance reading.
Teachers can buy Lit Trip audio books for students who struggle to read at the same pace as the rest of their class.
Lit Trips are interactive journeys using Google Earth to plot geographical elements from a story or text so readers can see the landscapes they are reading about.
Teachers can download ready-made Lit Trips or create their own using Google Earth.
Lit Trips are Google-designed field trips that incorporate Google tools and apps to enhance the learning experience.
Mr Vega is comparing feedback scores from students on a coastal erosion field trip that he has led for the last six years.
What can he do to analyze the data quickly and more efficiently on his own?
Use a calculator plug-in to calculate the average feedback scores
Use a Form to create a new questionnaire to gather more concise feedback from his students
Use a pivot table to display just the relevant feedback from the results
Send the data to the IT team to analyze it with advanced analytics tools
Mr. Sprowston has determined that Google Sites offers the most ﬂexible option to showcase different kinds of student work from his Geography classes. Use drag and drop to show the 4 different types of media which can be easily integrated into site, and which ones cannot.
Site Page integration
Integration not possible
Mr. Vanko is marking student assignments and keeps ﬁnding incorrect facts supported by unreliable sources. What should he explain to his students about ﬁnding online sources?
Verify all online information with textbooks
Check the integrity of the author, and whether they are an expert on the topic
Contact the author directly to understand their research
Check that the website looks reputable and professional
They shouldn’t trust any information found online
You have given your history class an assignment to produce a document detailing key events of World War 2. What value do the Google Explore Button and Google Translate in Docs bring to this exercise?
The entire presentation can be translated in a few clicks
The entire text of a google Doc can be converted from one language to another language
The power of search is tightly integrated within the application
Convert document text into a spoken audio file in any language
Exclusive access to educational resources online
Ms. Yang’s students love reading books in which they can choose how the story progresses by making choices for the characters. These books are also known as “create-your-own-adventure” stories. She wants to deliver more dynamic content to her students based on their answers and discussions in class. What are some ways she can do this with google tools?
Create Sheets that contain links to jump to a particular slide in a separate Slide presentation
Record topics that were discussed with the most enthusiasm in a Sheet and share it with the students.
Create Slide presentations that jump to particular slides based on certain responses or discussion points
Create a YouTube video containing a Form with a list of questions, with responses fed directly into a Sheet
Create Forms that redirect students to specific questions or content based on their answers
One of your students is hoping to get elected to the school council. She has asked you for advice on how to run her election campaign. By moving the rows up and down, match the Google tool with its potential use case to show how the tools can help.
Google Tool Use Case
Forms Survey students on Issues
Groups Email Campaigns
Drawings Campaign Posters
You are teaching a class on politics in the media, and you want your students to search for trending political stories online. What is the best and most eﬃcient way they can ﬁnd information on trending subjects?
Create a questionnaire in Forms to send to fellow students to understand trends within a school
Do a Google search for “Political trends” and search for relevant information
Go to Goolge.com/trends and browse through current trends across multiple categories and countries
Go to Google Analytics to see most viewed web pages and searches
You strongly believe that students need a voice so they can inﬂuence their environment and make a real difference. You have decided to support the creation of a school newspaper. Move the rows up and down to match each Google tool with the way it can be used to reimagine the traditional school newspaper online.
Google Tool Use Case
Sites Web hosting and publishing the newspaper
Google Photos Storing photos and images
Docs Drafting and editing articles
YouTube Video hosting and editing
Calendar Assigning draft due dates and final deadlines
Students in a programming class have asked if you can help them arrange a hackathon to support their autonomous robot development project. Move the rows up and down to show the best way each Google tool could be used to help facilitate the planning and execution of a hackathon.
Hackathon Tasks Google tool
Creating a print-friendly schedule Docs
Creating a project timeline to ensure everyone Sheets knows what deadlines and responsibilities they have
Gathering feedback from other programming students Forms on their preferred development tools
Presenting the final solution to an audience Slides
Creating a flow diagram for the development process Drawings
Forms can be adaptable based on the answers provided by the recipients. For example, if they get a question wrong, they can be directed to review the content again, and retake the question. Describe the process of making a “Create-Your-Own-Adventure” quiz using forms. Move the rows up and down to put the steps in the correct order.
Create a form
Add a “multiple choice” or “choose from list” question
Check the “go to page based on answer” checkbox
Select the page you want users to redirect to based on each answer, or to submit the form
Repeat these steps until the form is complete
Ms Coulson is teaching her students about nutrition and eating habits in other countries. What can she do to give her students ﬁrst-hand information on this subject without spending any money?
Invite an overseas student or teacher to come into class to speak when they are available
Arrange a Hangout with a class in a different country for a question and answer discussion session
Take he students on an international road trip to try out different foods
Host a Hangout on Air with willing schools around the world to discuss the topic and make it available to watch at a later date
Arrange a Hangout with someone she knows from a different country and pass on the information to her students
Match each scenario of sharing resources with other educators with the most effective tool for the job by moving the rows up and down.
Mr. Portman has found videos that his students find particularly engaging, and wants to share them with the rest of the teachers in the school.
Ms. Lee is quick to understand and apply new online tools in her classroom on Air and wants to provide screencast tutorials and have discussions with teachers who are slower to adopt new technology.
Ms. Hopkins has been teaching for decades and has a large volume of useful documents and templates she wants to share with the rest of her colleagues.
Mr. Foster wants one location for all resources, news, and information for the Geography department.
Hangouts on Air
Ms. May can use Gmail and Calendar proﬁciently, but wants to increase her productivity as she has very little time for catching up on emails and scheduling one-to-one sessions with her students. By moving the rows up and down, match the productivity gains she can receive using the following Advanced features for Gmail.
View the number of unread messages are in your inbox with a quick glance
Quickly accessing additional functionality without using a mouse
Responding to multiple emails quickly with the same reply
View the next conversation instead of your inbox after you delete, archive, snooze, or mute a conversation
G Suite tool feature
Unread message icon
Custom Keyboard shortcuts
Miss Jackson wants to create a classroom full of independent learners. Why should she ﬁrst teach her class how to search, browse and explore effectively online?
So students will understand how to get assistance beyond their teacher
Because it’s too easy for students to get distracted by online games
So students can find answers to their questions quickly
So students never have to carry paper books again
Because YouTube is full of disruptive content
Mrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data eﬃciently without having to search through it manually?
Protect the sheets to keep an original copy of the data in case of errors or accidental deletion of data.
Use the “Scan All” function to locate specific values and student names.
Use filters to display required data and hide unwanted data.
Use charts to visually represent student progress.
Match the most suitable personalized learning activity with the most appropriate Google tool for the job by moving rows up and down.
Personalized learning activity
Creating a project-based learning activity and storing all resources, research, and results in one place for relevant parties.
Assigning students a set of tasks based on various online resources that they can work through.
Distributing a video to students to watch and answer questions on in their own time.
Mr Jackson is an enthusiastic geography teacher, and wants to inspire other geography teachers to make use of Google tools to help their students understand the world they live in and meet other students overseas. What activity could he do to promote cross-continent discussions with other geography classes?
Send a questionnaire using Forms to teachers around the world to distribute to their students asking about their life where they live
Offer Mystery Location Calls using Hangouts with his class and other classes across the world for students to guess where they are based
Get his students to create a group class presentation using Slides about what they do in their spare time, and share it with schools in other countries
Send a Calendar invite to schools across the world to see who would be available for a face-to-face discussion
Mr White is the school’s advocate for recycling and reducing paper waste for both teachers and students. What can he do, using Google tools to actively reduce paper waste in his school?
Create a video about why recycling is important for the environment, and upload it to YouTube.
Record teacher and student printing activity in a Sheet to identify those with high printing volumes.
Encourage teachers to put student worksheets, downloadable forms and display student work on their own class Site.
Run a workshop for teachers and students on how to use smart printing tools to print more efficiently.
Using the different functionalities of Google Maps, students and teachers can create their own maps and virtual tours, and explore areas and locations across the globe. Match the functionality or Google maps tool with the correct class-based activity.
Google Maps student activity
Identify the types of stones used to build the pyramids of Giza
Recreate the journey travelled by Lewis and Clarke on their famous expedition with images at key locations
Create a map of which countries you have visited and calculate the distance you’ve travelled
Google Maps tool
What key points do students need to understand when creating an instructional video?
Cards should be used throughout the video as subtitles so the audience does not mishear any dialogue
Instructional videos should be at least three minutes long, otherwise they are not detailed enough to instruct an audience
Cards must have a clear purpose and not distract the audience from the content
Always add humour to an instructional video to keep audiences engaged
There is a clear goal and purpose for the video
Ms Acton is coaching her students who struggle to write long essays, especially when it comes to ﬁnding relevant articles and citing their sources. How can her students use Google Scholar to help improve these skills?
Request results within a date range
Use the “Cite” tool to correctly format citations
Access and read the entirety of all search results in a free online library
Use the “Related Articles” feature to find additional research related to specific search results
Search for articles by a particular author
Find academic sources and save the links to “My library” within Scholar
Mr Thurman has a class of mixed-ability students, and wants to use video so he can effectively teach all students at the correct pace. How can he use video instruction to help him achieve this goal?
Give students with slower learning pace access to fun YouTube videos to watch when the class discussion gets too complex
Use video instruction to cover the lesson material so he can spend more time with individual students that need help
Use YouTube analytics to track which students have watched which videos, and how often they paused and rewound the video
Give students instructional videos to watch in their own time, at their own pace, so they can ask questions about it during class
Give faster students fun videos to watch while they wait for slower student to catch up
You classroom has the latest technology to allow students access to facts and ﬁgures within a few clicks. Why should your students be encouraged to become independent learners and seek out answers to questions? Select 2 correct answers
To foster students’ naturally inquisitive minds
So the knowledge students gain is consistent
To discourage collaboration
So the teachers workload is reduced
So students become masters of their own learning
Mr Manuel wants to use Google Earth to enhance his geography lessons. Which activities could he use with his students to understand the earth’s geographical form?
Have students to mark the geographical locations of the world's largest volcanoes
Zoom into street view in real time to see live camera feed in a desired location
Compare the terrain and elevation between different locations
Run simulations to show how islands are impacted by tsunamis
Mr. Lim is creating a website for the science department. He wants to embed a video that his students created on the homepage. What are the steps involved in doing this? Drag and drop the steps in the correct order by moving the rows up and down.
Create a new site and name it.
Select the required area on the page for the video.
Verify there’s room for welcome text and a video.
Search for and Click the video
What is the best description and use for Google Scholar in a classroom?
An online thesaurus that finds definitions and provides examples of how to use words in sentences, to help improve writing queality.
A useful Search tool to find academic or scholarly sources, for research purposes and citation within original work.
A curated reading list based on a specified topic and grade level, for students to find additional information outside of the class text.
A chat tool that links students with other students to provide peer support and answer questions on a particular topic.
Ms Erskine is explaining to her colleagues how easy it is to install add-ons, including adding a Thesaurus. What should she explain to her colleagues?
Add-ons can be found in the Chrome Web Store and installed like any other Chrome app.
Add-ons enhance the functionality of core G Suite apps
Add-ons for a Google App can be found and installed from a Google Doc, Slide, Sheet or Form.
Scenario 1/11 Task 1 of 2
You’ve drafted a simple text outline of the course syllabus for your chemistry class. You want to turn this into an attractive digital document which can be easily updated and shared online.
Open the document Chemistry Planning in your
From Google Docs create a new document called Chemistry Syllabus
Copy the text from the document Chemistry Planning to the new document and use a table with 2 columns to make the layout more One column should contain the topic titles and the other column should contain the lesson objectives for that topic.
Scenario 1/11 Task 2 of 2
You want to make sure your chemistry class is adequately prepared for the learning ahead. You decide that you will share the outline of the syllabus with them and then add more details later.
Share the Chemistry Syllabus document with your class email@example.com
Scenario 2/11 Task 1 of 3
You are teaching your students about the beneﬁts of having a healthy lifestyle and you want to send your students a short questionnaire to gather information about their eating and drinking preferences.
Use the short questionnaire in Drive titled, Healthy Lifestyle Questionnaire, and create a new form titled Healthy Lifestyle Questionnaire with the questions in the
Send the form to the students in your firstname.lastname@example.org) to answer the questions.
Scenario 2/11 Task 2 of 3
You need to edit an existing Form to create a quiz for your students on nutrition and exercise, and you want the quiz to grade itself before your next lesson.
Using the form titled Nutrition and Exercise Quiz, make the Form a quiz, set each question for 1 point, and set the correct answers to the following:
Question 1 - 1 hour
Question 2 - Cheeseburger
Question 3 - 8-10 hours
Question 4 - about 3 liters
Scenario 2/11 Task 3 of 3
Now that your Google Forms Quiz is setup how you like, there are couple ﬁnal steps to deliver it to your students.
Be sure to restrict who can ﬁll out your form to those in the domain @myeducert.org
Be sure to limit students to 1 response
Send the Quiz to the students in your class (email@example.com) to answer the questions.
Scenario 3/11 Task 1 of 4
You are teaching a class on famous artists, and you are looking for some information on Pablo Picasso to share with students interested in studying his work.
Using advanced search tools or techniques in Google Search, ﬁnd a suitable PDF document containing facts about Pablo Picasso and upload it to Google Drive.
Scenario 3/11 Task 2 of 4
You want to collect and share some images of Picasso with your students which will be showcased publicly on the school website as part of the student’s projects.
Search for a suitable JPEG image that is “free to use or share” and upload it into Google Drive.
Scenario 3/11 Task 3 of 4
One student has taken a strong interest in Picasso and wants to read more about him in her spare time.
Using search in Google Books, ﬁnd the book “Picasso, His Life and Work” by Sir Roland
In Gmail, send an email to Heidi Koch with a link to the book from Google Book results.
Scenario 4/11 Task 1 of 2
Your school has received a number of letters from parents concerned about the safety of their child at school. As an expert in G Suite, Principal Anderson has asked you to use Forms to create an anonymous survey to gauge parent opinion. All details to include in the form can be found in the document titled, Student Safety Survey.
In Drive create a new form called, Safety Survey - 522850006 and add a
Conﬁgure the form so that it is accessible outside of the school domain, anonymous, and there can only be one response per person.
Include 3 questions to assess the opinions of parents
Replace the message on the information page with “Thank you for completing the survey”
Send the form to the school’s email distribution list for parents: firstname.lastname@example.org.
Scenario 4/11 Task 2 of 2
Based on the feedback from the Google Form Student Survey, your principal asks to set up time to conference with guardians. You know this is a perfect opportunity to use the feature “Appointment Slots” within G Suite for education Calendar.
Using this calendar named Student Assignment, setup 3 hours of time using appointment slots Title the event Student Safety Discussion with Guardians
Send the link to “Go to appointment page for this calendar” to email@example.com.
Scenario 5/11 Task 1 of 3
Hint: Please use New google Sites to complete this question. If you ﬁnd yourself on the old Google Sites homepage, please click through to “New Google Sites” from the menu on your left. You want to create a Site for your history class as a portfolio for your student’s work.
Create a site called History Grade 11 - 522850++++ that has the theme ‘Vision” The site should also contain the following pages:
A homepage titled Welcome, Time Travelers containing a one-sentence overview to the site
A page titled Class Presentations containing a list of the following students with their assigned history (What caused the Civil War - Chris Smythe; The North and its ideologies - Samantha Chong, The South and its ideologies - Wayne Lewis)
Scenario 5/11 Task 2 of 3
You have found a relevant video on the American Civil War that you think help bring the class portfolio to life: [youtube link]
Create another page in the site titled, Videos, and embed the YouTube video in the page so that it can be watched directly from the page.
Scenario 5/11 Task 3 of 3
Your students have a bad habit of missing assignment deadlines, so you want to expand your class portfolio to include some helpful reminders. Speciﬁcally, you want to embed a student assignment calendar on the front page of the site.
Insert the Student Assignment calendar on the homepage of the site.
Scenario 6/11 Task 1 of 3
You’ve been reaching French for 15 years, and a newly-qualiﬁed French teacher has just joined your school. You want to share your lesson plans with her for reference.
Create a Lesson Plans folder
Add the following lesson plans from Drive (French Lesson Plan 1; French Lesson Plan 2; French Lesson Plan 3)
Share the folder with Mrs Brady and give her access to edit the content
Make sure she will be informed that you shared the folder with her as she is waiting for your ﬁles.
Scenario 6/11 Task 2 of 3
You’ve also gathered quite a substantial collection of useful French language-themed videos from YouTube and want to share them with Mrs Brady. Tip: You will need to create a YouTube channel in order to create a Playlist.
Click on the proﬁle icon on the top right, select “create a Channel”, then “Get Started”. Select “Use your name”. If your YouTube browser tab automatically closes after selecting “use your name”, re-open YouTube in another tab and you will see the channel is automatically created.
Create a playlist of ﬁve relevant French language-themed videos and name the playlist French Language
Share the playlist with Mrs Brady at her email address firstname.lastname@example.org.
Scenario 6/11 Task 3 of 3
An email thread about the use of old textbooks has sparked a heated debate among the community of French teachers. This argument would be better solved outside of the discussion board. You want the French department chairs to meet to decide on the agenda for the debate, but schedule are hard to align to meet in-person.
Schedule a video call using Calendar for the following Be sure to include a Meet link.
Invite Schneider and Mrs Brady to join the call.
Scenario 7/11 Task 1 of 2
You’re browsing through the Chrome Web Store to ﬁnd an extension that will save you time distributing assignments. You ﬁnd Share to Classroom extension, which you think will create a more interactive classroom for you and your students. Before you push apps or extensions out to your students, you typically ask your teaching assistant, Mrs Brady, to trial them ﬁrst.
Search the Chrome Web Store for the Share to Classroom extension created by Google
Share it with Mrs Brady so she receives a link via
Scenario 7/11 Task 2 of 2
You’ve also found some interesting extensions that your students will ﬁnd useful for improving their own productivity.
Search the Chrome Web Store for the Save to Google Drive extension by Google
Share it with Mrs Brady so she receives a link via email.
Scenario 8/11 Task 1 of 3
Hint: Please use New google Sites to complete this question. If you ﬁnd yourself on the old Google Sites homepage, please click through to “New Google Sites” from the menu on your left. You are English teacher and you want to create a class website that contains overview of the year and resources for classroom and assignment activities.
Create a basic website using Name your website English Grade 11 - XXXXXXXXXX
Name the homepage English Semester Overview
On the homepage, add an overview for the The text for the overview can be found in the document called English Site Homepage.
Create a subpage under homepage called Student Resources and embed the English Reading List document from your drive.
Scenario 8/11 Task 2 of 3
You want to add a page to your site in order to send your students interesting links related to class material. You have found a movie that you think would be fun for your students to watch in their free time. Create a sub page called You might also like… and add a text box that contains a link to information about the movie. The content of the page should include:
Movie Title: Shes the Man
Link and Description: ([copy paste a link from your task text] - a modern-day adaptation of Shakespeare's Twelfth Night
Scenario 8/11 Task 3 of 3
One of your topics this semester is classic English writers. You want to assign your students a set of tasks based on a blended learning approach so that they can work at their own pace. You think the best way to do this is by creating a hyperdoc to organize a series of resources in a Google document with a guiding question to explore each resource.
In Google Docs, create a hyperdoc titled Shakespeare on the theme of
The guiding question “How many new words and phrases did William Shakespeare invent?” That is hyperlinked with this video ([copy paste youtube link])
The string jpg hyperlinked to the Shakespeare_Theatre.jpg image in Google Drive
The guiding question “What is the name of this theater built in 1599 by Shakespeare’s playing company, The Lord Chamberlain’s Men?” hyperlinked to the location of the jpg image in Google Drive.
You should also insert the image directly into the
The guiding question ‘What is considered to be Shakespeare’s ﬁrst play?” hyperlinked to the webpage ([copy paste the link])
Scenario 9/11 Task 1 of 2
You’re teaching a new class on linguistics. One of the highlights of the class is a ﬁeld trip in which your students will travel abroad. At the start of the semester you receive many calls from parents asking when they can expect more details about the ﬁeld trip. You don’t have time to call everyone back individually, so you want to create a template email message so that you do not have to type the same message multiple times.
In Gmail settings under Advanced tab, enable Templates to accomplish the following
Save the following text as a template called American Literature Field Trip
Send an email to parent Mary Chan with the subject line American Literature Field Trip and insert the Template called American Literature Field Trip
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 mp4 in Drive and upload it to YouTube. Tip: You will need to create a channel. You will need to download the video ﬁrst, and then upload it to YouTube.
Give it an appropriate description, keep the name Innovate with google 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 ﬁnish processing in order to submit the exam.
Scenario 10/11 Task 1 of 1
You are organizing a ﬁeld 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 ﬁnd driving directions from the Eiffel Tower, to the Champs Elysees, and on to the the
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
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 ﬁnished Senior year with an “F” grade.
In Drive, create a pivot table using the data in the Senior Results 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 ﬁnal average Filter - Filter the pivot table by “Final Grade” and only show of “F”
More info of other products in:
You've purchased this product
See it in your libraryView in Library
We charged your card and sent you a receipt
You'll need an account to access this in our app. Please create a password to continue.
Download from the App Store or text yourself a link to the app
Good news! Since you already have a Gumroad account, it's also been added to your library.