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