Google Level 2

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

=countif

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 in a rubric that you created. Select the formula that could be used to show only peer feedback from Columne D, E F for ______

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

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

=sparkline

The options to summarize data in a pivot table report include

=sum =counta =average

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

A Google account

What age are students able to create blog posts to share their learning?

Any age

Which of the following learning techniques allow time for a teacher to pull aside a small group for additional learning during class?

Blended learning, Project-Based Learning, Flipped Classroom

what options in the YouTube creator studio allow interactivity to be added to videos?

Cards

Where can you find Chrome Apps and Extensions?

Chrome Web Store

What feature is used to color code calls based on their contents?

Conditional Formatting

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

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

Density and color

How can parents and guardians join a teacher conference via Google Meet?

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

How can you share apps and extensions with your class, even if you don't have Chromebooks?

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

What type of components can you display on a Google Site

Existing Google Docs, YouTube videos, Photos

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

Export responses to a Google Sheet

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

False

Advanced features can only be enabled by a system adminstrator

False

All blogs are public to the world

False

By default, every user on G Suite for Education receives a personal calendar as well as a classroom calendar.

False

Each class within Classroom can have 3 levels of hierarchy, for example Grade, Class and Section?

False

It is not possible to email existing collaborators of a document from within the document

False

Which outreach methods can be used to provide class guardians with information?

Google Groups, Google Sites

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

Google Jamboard

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

Google Keep

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?

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., Docs are easier and more efficient to grade for this type of assignment.

What can you use add-ons for Forms, Sheets, and Docs to do?

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

Project Based Learning involves which major concepts?

Group collaboration, Real World problems and solutions, Asking questions and finding answers

What can you embed into your syllabus to make it more engaging?

Images, Tables, Drawings

Student work can take many forms. When students include documents, videos, and other media on a Google Sites portfolio, best practice indicates they should store that media where?

In Google Drive, On YouTube, In Google Photos

What are some examples of visual products students could create using G Suite for Education tools?

Infographics, Flowcharts, Printed Media (Brochures)

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

Inform guardians about their students overdue assignments

How can you notify people of changes to your document?

Inserting a comment and mentioning their email address with a +, Using the File> Email collaborators option

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:

Instructional coaches, School site mentors

Which of the following could you include in a "Materials" post?

Introductory video, Classroom description, Syllabus, Links to 3rd Party Sites

Why would you use URL shortener with a Google Sites URL?

It creates a short URL that is easy for students to type into the address bar

Who should you let post on the Classroom Stream?

It will depend on your instructional goals for the Stream.

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

Kami, Google Drawings

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

Keep

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

Keep the "Collect email addresses" setting checked

Which response types can be used in your Google Form?

Multiple choice, Short answer, Checkboxes

Which Join the Group permission setting guarantees that you select or approve every individual who becomes a group member?

Only invited users, Anyone can ask

Which Post permission setting allows you and anyone you select (such as an assistant teacher to send messages to the group?

Owners of the group, Managers of the group

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?

PNG, Google Doc, HTML

Which formatting feature allows you to not only style text consistently, but also create links within a Google Doc?

Paragraph Styles

What can you include in a blog post?

Photos, YouTube video, text, links to websites.

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:

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

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

Radar Chart

Which of the following could students do at home for a Flipped Classroom model that doesn't involve video?

Read an online article, Contribute to a class slide show, analyze a photo, listen to a historical speech.

When you come across something in a G Suite App that you'd like to be able to do but don't think you can you should:

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

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 the message and use the m keyboard shortcut

How can a Google Form be distributed to guardians?

Share a form link on your school or class website, email a form

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

Which criteria could a pivot table be applied to?

Student names assignment dates assignment scores

Blended Learning is where

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

One way to digitize student work such as paintings, models and sculptures is:

Taking photos and video

Who can be a blog author?

Teachers, Students, Administrators

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

Which is required for families to receive Guardian Summaries related to your class?

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

What are some benefits of having students watch specific instructional videos before arriving in class?

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.

Which is true of guardian summaries in Google Classroom?

This features informs guardians about upcoming deadlines and late work.

Why have students create a digital portfolio?

To reflect on their learning, to collect evidence of learning, to use in a college application, to share with family

Add-ons extend the functionality of G Suite

True

Apps generally have more functionality than extensions

True

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

True

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

Google Sites, like Drive documents, can be set by the user to be private or public.

True

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

True

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

True

Students can animate their drawings using Google Slides

True

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

True

You can use tablets to make a blog post on a Blogger blog.

True

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

Unique

Which of the following are Advanced features in Gmail?

Unread message icon, Auto-advance

How might you simplify the use of external resources or tools with Classroom?

Use Assignments to detail which activities in an external site students should complete; Use the Share to Classroom button to give your students a recent news article that corresponds to a lesson; Link content from external sites directly into the Stream

What are some ways to make a Google Doc more engaging?

Use a table of contents, Use images with purpose, Alert collaborators using "+" in comments

what is one efficient way to format data on a sheet using color?

Use conditional formatting

How can you join a Google Meet?

Web browser, Telephone

Add-ons are created using Google Apps Script:

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

Which is a benefit of using Google Groups to email your class guardians?

You can bypass Gmail's daily sending limit of 100 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

What is true about using a Google Doc as a class syllabus?

You can collaborate with a teaching partner to create a shared syllabus; You can share your syllabus with the world

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

The primary reason it is a good idea to use YouTube Live vs. Google Meet for professional development sessions is:

YouTube Live is recorded and can be shared on YouTube.

Which of the following can you add to a slide to make it interactive?

a link to a form, instructions to guide completion of a creative piece of work

how can you apply conditional formatting to a cell?

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

Google Slides are capable of transforming learning by

enabling students to collaborate, share, and create interactive learning experiences that werent possible before

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

Organizing a tech committee at your school will support teachers by

giving teachers a voice in effective tech integration

Your principal has asked you to share tips to improve collaboration with students and teachers at the next faculty meeting. You could share...

how to create a newsletter using blogger a YouTube playlist of video tutorials for creating Google Sites

Using Google slides interactively in the classroom benefits learning in all of the following ways EXCEPT

it allows for lectures to be colorful and include transitions

When having your students create with Google Slides you should always

offer choice, give authentic purpose, and encourage collaboration which showcases greater depths of knowledge

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

public

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

right

Templates can help you to

save time when sending the same information

Guardian email summaries from Google Classroom are

sent to guardians regularly (based on preferences); available for setup to G Suite for Education teacher accounts.

Custom functions can be used for conditional formatting

true

Google Forms results can be imported into Google Classroom

true

Tagging blog posts helps when searching a blog for specific content

true

cards have a clickable teaser that appears over the video

true

On a Google site, you can insert:

videos, images, slides, maps