Google Educator Training #2

U5L1 - Which Google Sheets Function creates line graphs and different types of bar charts right in the cell of a spreadsheet?

=chart

U5L2 - Which function will give you the total number of times a value appears if it meets certain criteria?

=countif

U5R - The 25 students in your class have used a Google Form to give peer feedback on presentations that they are doing. The questions are based on a rubric that you created.The first question asks, "Who is presenting?" and there is a dropdown list of all students in the class. The other questions are based on the rubric.After the class you want to see all the feedback that was given for Jimmy Wong. The responses for "Who is presenting?" are listed in column C on the Form Responses sheet. Columns D, E, and F have the peer feedback.Select the formula that could be used to show only the peer feedback from columns D, E, and F for Jimmy Wong.

=filter(D:F,C:C="Jimmy Wong")

U5L2 - The options to summarize data in a pivot table report include: (Select all that apply.)

=sum =counta =average

U4L4 - What is required of a guardian to reserve an Appointment Slot?

A Google account

U3L4 - Which of the following is true?

Add-ons extend the functionality of Google Workspace

U4L2 - What types of components can you display on a Google Site?

All of the above

U2L2 - What types of media can be linked in a HyperDoc? (Select all that apply.)

Anything with a link Google Docs Video Pictures

U2L1 - Which of the following learning techniques allow time for a teacher to pull aside a small group for additional learning during class time? Select all that apply.

Blended Learning Project-Based Learning (PBL) Flipped Classroom

U5L1 - Which of the following ways can you apply conditional formatting to a cell? (Select all that apply.)

By date By text contained in the cell By a number in the cell

U1L2 - YouTube Live

Can be saved on the creator's YouTube channel

U3L3 - Where can you find Chrome Apps and Extensions?

Chrome Web Store

U5L1 - What feature is used to color code cells based on their contents?

Conditional Formatting

U3 REVIEW - Mr. Menon answers the same questions via email over and over from parents at the beginning over every school year. How might Mr. Menon become more efficient in his communications within Gmail?

Create a template

U3 REVIEW - Which of the following can be used to customize your Google Calendar?

Density and color

U4L4 - How can parents and guardians join a teacher conference via Google Meet? (Select all that apply)

Dial the number on the calendar invitation Click the link to join on the calendar invitation

U3L3 - How can you share apps and extensions with your class, even if you don't have Chromebooks? (Select all that apply.)

Emailing the link from the Chrome Web Store Through your Google Groups Email the Chrome Web Store link to a Google Group email address

U2 REVIEW - A great way to showcase student work is to create a Google Site for students to link their projects and information to, but Google Sites is much more than just a content repository. What other mediums does Google Sites support? (Select all that apply.)

Embedding a Google Calendar to keep track of important dates Uploading recordings to cater to audio learners Adding images directly to the pages for visual (and educational!) appeal Linking downloadable PDFs and other digital documents

U4L1 - After collecting responses, how can you view Google Forms results all in one place?

Export responses to a Google Sheet

U2L2 - A teacher provides the most authentic audience for students' creative work.

False

U3L1 - By default, every user on Google Workspace for Education Fundamentals receives a personal calendar as well as a classroom calendar.

False

U3L2 - Advanced features can only be enabled by a system administrator.

False

U4 REVIEW - When using the appointment slot feature in Google Calendar, multiple people can select the same appointment slot.

False

U5L2 - If you change the sort or filter criteria in a filter view everyone viewing that Sheet will also have their data sorted or filtered.

False

U1L1 - Organizing a tech committee at your school will support teachers by:

Giving teachers a voice on effective tech integration

U2 REVIEW - Mr. Jones has been talking with you about personalizing his classroom more using a blended model. He is arguing that creating a HyperDoc on a Google Doc is a better way to do this than a Google Site. Why would he say this? (Select all that apply.)

Google Docs can be distributed in Google Classroom for ease of organization. Google Docs can be shared and edited by students more easily than a page on Google Sites. A teacher would have to create a Google Site for every student and then create pages for each HyperDoc on those sites for every student Docs are easier and more efficient to grade for this type of assignment.

U4 REVIEW - Where would you go to view responses to your Google Form?

Google Forms

U4 REVIEW - Which outreach methods can be used to provide class guardians with information? (Select all that apply)

Google Groups Google Sites

U2L3 - Which app is like an online whiteboard that allows students to include various multimedia sources, items (some) from Drive, and annotate them?

Google Jamboard

U2L3 - Which app allows students to save images, text, graphs and more from their research?

Google Keep

U3 REVIEW - What can you use add-ons for Forms, Sheets and Docs to do? (Select all that apply.)

Grade quizzes Create a table of contents Mail merge Change the response choices on a multiple choice form question

U2 REVIEW - Project-Based Learning or PBL involves which major concepts? (Select all that apply.)

Group collaboration Real World problems and solutions Asking Questions and Finding Answers

U1 REVIEW - Your principal has asked you to share tips to improve collaboration with students and teachers at the next faculty meeting. You could share: (Select all that apply.)

How to create a newsletter using Blogger A YouTube playlist of video tutorials for creating Google Sites

U2L3 - What are some examples of visual products students could create using Google Workspace for Education Fundamentals tools?

Infographics Flowcharts Printed Media (Ex: Brochures)

U4 REVIEW - Which is an appropriate use case for Google Classroom's Guardian Summaries?

Inform guardians about their student's overdue assignments

U3 REVIEW - Which of the following Chrome apps will run offline and also works with Google Drive?

Kami Google Drawings

U3L4 - Which of the following Apps can you not find add-ons for?

Keep

U4L3 - How can you confirm who submitted a communication log Forms entry?

Keep the "Collect email addresses" setting checked

U4L1 - Which response types can be used in your Google Form? (Select all that apply)

Multiple choice Short answer Checkboxes

U4L2 - Which Join the Group permission setting guarantees that you select or approve every individual who becomes a group member? (Select all that apply)

Only invited users Anyone can ask

U4L2 - Which Post permission setting allows you and anyone you select (such as an assistant teacher) to send messages to the group? (Select all that apply)

Owners of the group Managers of the group

U3 REVIEW - Add the Save to Google Drive extension to your Chrome browser. After installing it, check out the options for it. Which of the following file types could you save a website as? (Select all that apply.)

PNG Google Doc HTML

U1L1 - When creating a technology plan for your school, you should include the following people in the decision making: (Select all that apply.)

Parent organizations Administrators Teachers Students

U1 REVIEW - Finding and sharing online resources is an ongoing effort to keep curriculum fresh and interesting. YouTube is a great option for finding new content, but some educators worry about searching for videos during class because it wastes time and inappropriate content might show up. Select the benefits of using a YouTube channel and playlists to address these concerns: (Select all that apply.)

Playlists allow you to organize pre-selected videos so you don't waste class time searching for them YouTube channels allow you to organize and share your playlists with students, parents, and other teachers

U3L1 - In order to allow parents to see the new calendar, Mr. Jones must make it:

Public

U5L3 - What are some benefits to using Google Classroom for assignments?

Quickly see which students have completed work Classroom can organize learning outcomes

U5L2 - What chart would be best to compare an individual group to the larger population?

Radar Chart

U2 REVIEW - Which of the following could students do at home for a Flipped Classroom model that doesn't involve video? (Select all that apply.)

Read an Online Article Contribute to a Class Slide Show Analyze a photo Listen to a historical speech

U5L3 - What are some benefits, specific to assessments, to using Google Classroom for assessment?

Reduce the time between teaching and knowing what students learned. Google Classroom provides an opportunity to individualize instruction, assessment, as well as assessment feedback

U3L2 - Using the Advanced features, the chat box can be relocated to which part of the screen?

Right

U3L2 - Canned responses can help you to:

Save time when sending the same information

U1 REVIEW - Teachers in your school have complained about a one-size-fits-all model of training that has been used in your district for years. They would like to personalize the professional learning that goes on in school. Which of the following models provides the most relevant and timely support to teachers on an individual basis when they need it:

School site mentors

U3L4 - When you come across something in a Google Workspace App that you'd like to be able to do but don't think you can you should: (Select all that apply.)

Search the help center to see if you can do it using the core functionality Search the add-ons menu for an add-on that might Search the web for ideas Search the Chrome Store for an extension that might

U3 REVIEW - A colleague has included you on an email that is irrelevant to you, but it continues to come to your inbox because people are using the Reply All button when responding. You want some peace and quiet. What can you do to quiet message notifications coming in? (Select all that apply.)

Select the message and use the m keyboard shortcut

U5L3 - Good formative assessments should include which of the following? (select multiple)

Serve a defined purpose Align with learning outcomes Meet the needs of the teacher Highlight student learning

U4L1 - How can a Google Form be distributed to guardians? (Select all that apply)

Share a form link on your school or class website Email a form

U3 REVIEW - How could you help students find apps and extensions for Chrome?

Share links to apps and extensions via email Recommend to your domain administrator to push apps and extensions to student devices Help students find apps and extensions on the Chrome Web Store

U5R - Which criteria could a pivot table be applied to: (Select all that apply.)

Student Names Assignment Dates Assignment Scores

U2L2 - Which of the following activities can be used to personalize learning in the classroom? (Select all that apply.)

Student created websites to demonstrate understanding Group-created slideshows to teach a concept Google Forms to assess and inform formative learning

U2L1 - Blended Learning is where:

Students learn in the classroom setting with a teacher and online with guided activities

U5R - With conditional formatting, teachers can alter the cell color based on the value for: (Select all that apply)

Text Dates Numbers

U4L4 - Which is true of Appointment Slots in Google Calendar?

The appointment slot becomes a calendar event from which participants can join a virtual conference You set the duration of individual appointments You set the time period during which you're available for conferences

U4 REVIEW - Which is required for families to receive Guardian Summaries related to your class? (Select all that apply)

The educator must turn on Guardian summaries for each class The guardian must sign up to receive email updates

U3 REVIEW - To enable people to make appointments when you use appointments slots you have to share the URL of your appointment page. How does your appointments page view differ from a normal public view of a Google Calendar?

There are buttons to book an appointment slot

U2 REVIEW - What are some benefits of having students watch specific instructional video before arriving in class? (Select all that apply.)

There will be an archive of videos for students to watch later if needed. Students can come to class with questions ready to ask. Teachers can do a quick formative assessment on the previous night's content to determine what needs to be further explained.

U1L1 - Online tools work best for teachers when: (Select all that apply.)

They have a mentor working with them They have access to quality digital resources

U4L3 - Which is true of guardian summaries in Google Classroom?

This feature informs guardians about upcoming deadlines and late work

U1L1 - Administrators can support teachers by modeling good uses of technology.

True

U1L2 - Tagging blog posts helps when searching a blog for specific content.

True

U1L2 - When using a shared folder, the share settings and permissions of the folder will give all of the contents the same settings.

True

U2L1 - Flipped Learning can help students learn at their own pace: alleviating educators from conducting whole class reviews of concepts with students who already understand them.

True

U2L1 - Personalized learning can occur in any subject area.

True

U2L2 - The Flipped Learning model allows student access to concepts at any time of the day.

True

U2L3 - True/False: Students can animate their drawings using Google Slides.

True

U3L1 - Making appointment slots is only available to users that are on a Google Workspace for Education Fundamentals and Work domains, but registering for someone else's appointment slot is available to users with any Google account.

True

U3L3 - Apps generally have more functionality than extensions.

True

U3L3 - Chrome apps and extensions can be force-installed on Chromebooks in your education domain.

True

U4L3 - Maintaining a progress tracker in Google Sheets is valuable because guardians can see teacher notes updated in real time.

True

U5L1 - Custom functions can be used for conditional formatting.

True

U5L3 - Google Forms results can be imported into Google Classroom

True

U5R - Which advanced Google Sheets function gives you a list that removes all duplicate values?

Unique

U3L2 - Which of the following are Advanced features in Gmail?

Unread message icon Auto-advance

U5R - What is one (efficient) way to format data on a sheet using color?

Use conditional formatting

U4 REVIEW - How can you join a Google Meet? (Select all that apply)

Web browser Telephone

U3L4 - Add-ons are created using Google Apps Script: (Select all that apply.)

Which is based on JavaScript Which provides a way for students with a coding interest to create their own Add-ons

U4 REVIEW - Which is a benefit of using Google Groups to email your class guardians? (Select all that apply)

You can bypass Gmail's daily sending limit of one hundred emails You can send an email to just one email address to reach all guardians Guardians can find and search previous class emails in one place at groups.google.com

U4 REVIEW - Which is true about creating a Google Group with the setting "Only invited users?"

You must submit specific email addresses for those guardians to join the Group

U1 REVIEW - The primary reason it is a good idea to use YouTube Live vs. Google Chat for professional development sessions is

YouTube Live is recorded and can be shared on YouTube.

U1L2 - How can a teacher easily curate their favorite videos?

by Creating a YouTube channel with playlists.

U3L1 - Guardian email summaries from Google Classroom are ... (Select all that apply)

sent to guardians regularly (based on preferences). available for setup to Google Workspace for Education Fundamentals teacher accounts.