100% Free & updated Google Educator Level 2 Certification Test Exam Questions & Answers.
Google Certified Educator Level 2:
In order to receive the Google Certified Educator status, you will need to pass the corresponding Level 2 exams.
Google Certified Educator Level 2 Assessment Details:
When you’re comfortable with the material, take the certification exam. Your exam will be ready to take within 24 hours of registration.
- Time limit: 180 minutes, no pauses
- Exam fee Questions: $25
- Exam URL: https://teachercenter.withgoogle.com/certification_level2
🙏 Help Us to Better Serve You: If you did not find any question or if you think any question’s answer is wrong, let us know. We will update our solutions sheet as much early as possible. Contact Us Now.
(Click on the questions, to get the correct answers)
Part 1. Certification Test Questions and Answers.
✅ 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
✅ Your 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
- 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.
- Select “YouTube”
- Search for and Click the video
- Click “Select”
- 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.
- 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.
✅ 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
- Flash animation
- 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|
- 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||Google Maps tool|
|Identify the types of stones used to build the pyramids of Giza||Street view|
|Recreate the journey travelled by Lewis and Clarke on their famous expedition with images at key locations||Tour Builder|
|Create a map of which countries you have visited and calculate the distance you’ve travelled||My Maps|
- 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
✅ 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 knows what deadlines and responsibilities they have||Sheets|
|Gathering feedback from other programming students on their preferred development tools||Forms|
|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
- 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
- Arrange a Hangout with someone she knows from a different country and pass on the information to her students
|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.||YouTube|
|Ms. Lee is quick to understand and apply new online tools in her classroom and wants to provide screencast tutorials and have discussions with teachers who are slower to adopt new technology.||Hangouts on Air|
|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||Google Drive|
|Mr. Foster wants one location for all resources, news, and information for the Geography department.||Google Sites|
✅ 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.
|Productivity gains||G Suite tool feature|
|View the number of unread messages are in your inbox with a quick glance||Unread message icon|
|Quickly accessing additional functionality without using a mouse||Custom Keyboard shortcuts|
|Responding to multiple emails quickly with the same reply||Templates|
|View the next conversation instead of your inbox after you delete, archive, snooze, or mute a conversation||Auto-advance|
- 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.
|Personalized learning activity||Google tool|
|Creating a project-based learning activity and storing all resources, research, and results in one place for relevant parties.||Google Sites|
|Assigning students a set of tasks based on various online resources that they can work through.||Google Docs|
|Distributing a video to students to watch and answer questions on in their own time.||Google Forms|
✅ 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
Part 2. Practice exercises.
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 Drive.
- 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 attractive. One column should contain the topic titles and the other column should contain the lesson objectives for that topic.
- If you don’t see a document, use the search box to ﬁnd a document Chemistry Planning. Open it and copy the whole texts (ctrl+a, ctrl+c.)
- Create a new document and name it. +new | Google Docs | Blank Document | Name the document Chemistry Syllabus | paste the text there (ctrl+v). Tip – always copy paste document names and double-check them. Misspelling titles could lead to disapproval of your work.
- To draw a table go to insert | table | select 2 columns layout | arrange text as described
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 protected]
- To share a document simply press the Share button on the top right | enter (copy-paste) an email address | Click “done”.
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 Doc.
- Send the form to the students in your [email protected]) to answer the questions.
- To create a Form select +New | More | Google Forms | Blank Form | name it (copy-paste) as Healthy Lifestyle Questionnaire.
- Add questions from the doc Healthy Lifestyle Questionnaire. Use the search box to ﬁnd the document.
- To send your form, press the “send” button on the top right and enter (copy-paste) the email address | press Send button.
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
- Search in the drive for a form Nutrition and Exercise Quiz and open it.
- To make a form a quiz, go to setting icon | go to “quizzes” tab | select “make this a quiz”.
- Press Answer key to add values to correct answers.
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 protected]) to answer the questions.
- To restrict who can ﬁll out your form go to Settings icon | general settings | select restrictions and limitations.
- To send the form, press Send button on the top right | enter (copy-paste) email address | click “Send” button
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.
- You can perform this task in multiple ways. Go to https://www.google.com/advanced_search for example. Enter Pablo Picasso and select the ﬁle format PDF.
- Open the desired document. Download it to your device. Go to drive | new | ﬁle upload | select your PDF ﬁle | click “upload”
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.
- You can perform this task in multiple ways. Go to https://www.google.com/advanced_search for example. Enter Pablo Picasso and select usage rights as “free to use or share”.
- Tip: Most probably Google won’t check the usage rights evaluating your test, but I recommend selecting an image with “Public domain picture” to be sure. Open the image, right-click on it, save as JPEG to your device.
- Go to drive | new | ﬁle upload | select your JPEG ﬁle | click “upload”
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 Penrose.
- In Gmail, send an email to Heidi Koch with a link to the book from Google Book results.
- Go to https://books.google.com
- Enter “Picasso, His Life, and Work” by Sir Roland Penrose.
- Open the book, press the Link button on the top menu bar.
- Copy the link.
- Go to Gmail, write an email to Heidi Koch paste a link.
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 description.
- 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: [email protected]
- To create a new form go to my drive | new | more | Google forms | Blank Form | name your form as stated (copy-paste). Tip copy paste form name from your task, the number can be different each time.
- To set accessibility options go to settings | general | untick restrict to users box | tick limit to 1 response box
- To replace the message go to settings | presentation | conﬁrmation message
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 feature. Title the event Student Safety Discussion with Guardians
- Send the link to “Go to appointment page for this calendar” to [email protected]
- –Appointment slots are useful when you don’t know who needs to meet with you, but you want to make yourself available.
- –To create an appointment slot open your Calendar | create | select Appointment slots tab | name your appointment as stated (copy-paste the text)
- –To send the link your appointment and then Go to the appointment page for this calendar. Copy and paste the appointment page link from your browser.
Task 1 of 3
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 presentations. (What caused the Civil War – Chris Smythe; The North and its ideologies – Samantha Chong, The South and its ideologies – Wayne Lewis)
- Go to Google Sites | press + to create a new blank Site, name it as indicated in the task (copy-paste the text, note that numbers can be different each time, double-check you name it correctly). Select Theme vision from Right sidebar menu tab “Themes”
- To rename a page – go to Pages tab on the right sidebar menu | select page | click three dots menu | properties
- To create a new page – go to Pages tab on the right sidebar menu | click + icon | new page
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:
- 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.
- To create a new page – go to the Pages tab on the right sidebar menu | click + icon | new page.
- To embed a video – simply select embed icon on the Insert menu on the right sidebar. Copy-paste a YouTube link from your task | click insert.
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.
- To embed a calendar simply look at Insert tab menu on the right sidebar | scroll down to “calendar” | select Student Assignment calendar to embed it into your homepage
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.
- Go to My drive | new | folder | name your folder as indicated (always copy-paste, do not retype titles).
- Add lesson plans to the folder (Docs)
- To share the entire folder right click on folder | share | add Mrs Brady | Make sure to select Editor as her role | check the box to notify her | click send.
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 Videos.
- Share the playlist with Mrs Brady at her email address [email protected]
- To create a playlist – creator studio | playlists |new playlist on the top page | name your playlist as indicated (copy-paste from the task)
- To add videos click three dots menu below playlist title | use the search box to ﬁnd relevant videos
- To share the playlist click the arrow icon near and enter an email address.
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 week. Be sure to include a Meet link.
- Invite Mr. Schneider and Mrs Brady to join the call.
- Go to your Calendar | click on the time you want to add video call | event | Add Google Meet video conferencing (tip: click “more options” if you don’t see this option) | add guests to your Meet | click save and send invitations in the pop up window.
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 email.
- Extension page is here https://chrome.google.com/webstore/detail/share-to-classroom/adokjfanaflbkibffcbhihgihpgijcei
- To share it simply copy a link and send it via email.
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.
- Extension page is here https://chrome.google.com/webstore/detail/save-to-google-drive/gmbmikajjgmnabiglmofipeabaddhgne
- To share it simply copy a link and send it via email.
Task 1 of 3
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 Sites. Name your website English Grade 11 – XXXXXXXXXX
- Name the homepage English Semester Overview
- On the homepage, add an overview for the semester. 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.
- Go to Google Sites | Start a new site | Blank Site | give it a name as indicated (copy-paste not retype the title, note that numbers can be different each time)
- To rename the page go to Pages tab on the right sidebar menu | click home | three dots menu | properties – To create a subpage go to pages tab on the right sidebar menu | click home | properties | add a subpage
- To embed a document go to Insert tab on the right sidebar menu | scroll down | select docs | select the document you need
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
- To create a subpage go to pages tab on the right sidebar menu | click home | properties | add a subpage
- To insert text box simply press the Tt text icon on the Insert tab on the right sidebar menu.
- Copy-paste the link and description from your task to that text box.
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 Shakespeare.
- 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 Shakespeare_Theatre.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 Shakespeare_Theater.jpg image in Google Drive.
- You should also insert the image directly into the document.
- The guiding question ‘What is considered to be Shakespeare’s ﬁrst play?” hyperlinked to the webpage ([copy paste the link])
- To complete this task you just need to create a Google doc and add links to described sections.
- Do not retype but copy paste titles and links to avoid possible typos.
- To insert a link simply select the string | press the link icon | copy-paste the destination URL
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
- Insert use template click “compose” a new email | at the right bottom click three dots menu |templates | select template
- Tip: do not retype text but copy-paste text and titles to avoid typos. Test results are evaluated automatically, typos can lead to disapprovals.
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 ﬁrst, 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 ﬁnish processing in order to submit the exam.
- 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.
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 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
- 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
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 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 ﬁnal average
Filter – Filter the pivot table by “Final Grade” and only show of “F”
- Pivot tables help you summarize data, ﬁnd 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 ﬁlter, 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 ﬁlters: Under Filters, click Add and select a column to ﬁlter. Under Show, click the Down arrow and deselect the items you want to hide. Click OK.