Google Educator Training #2 TEST
Questions and Answers(A+
Solution guide)
U4 REVIEW - How can you join a Google Meet? (Select all that apply) - Answer ✔✔-
Web browser
Telephone
U4 REVIEW - Which is true about creating a Google Group with the setting "Only invited
users?" - Answer ✔✔- You must submit specific email addresses for those guardians to
join the Group
U4 REVIEW - Which is required for families to receive Guardian Summaries related to
your class? (Select all that apply) - Answer ✔✔- The educator must turn on Guardian
summaries for each class
The guardian must sign up to receive email updates
U4 REVIEW - Which outreach methods can be used to provide class guardians with
information? (Select all that apply) - Answer ✔✔- Google Groups
Google Sites
U4 REVIEW - When using the appointment slot feature in Google Calendar, multiple
people can select the same appointment slot. - Answer ✔✔- False
U4 REVIEW - Which is a benefit of using Google Groups to email your class guardians?
(Select all that apply) - Answer ✔✔- 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
U5L1 - What feature is used to color code cells based on their contents? - Answer ✔✔-
Conditional Formatting
U5L1 - Which Google Sheets Function creates line graphs and different types of bar
charts right in the cell of a spreadsheet? - Answer ✔✔- =chart
U5L1 - Custom functions can be used for conditional formatting. - Answer ✔✔- True
U5L1 - Which of the following ways can you apply conditional formatting to a cell?
(Select all that apply.) - Answer ✔✔- By date
By text contained in the cell
,By a number in the cell
U5L2 - What chart would be best to compare an individual group to the larger
population? - Answer ✔✔- Radar Chart
U5L2 - Which function will give you the total number of times a value appears if it meets
certain criteria? - Answer ✔✔- =countif
U5L2 - The options to summarize data in a pivot table report include: (Select all that
apply.) - Answer ✔✔- =sum
=counta
=average
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. - Answer ✔✔- False
U5L3 - What are some benefits, specific to assessments, to using Google Classroom
for assessment? - Answer ✔✔- Reduce the time between teaching and knowing what
students learned.
Google Classroom provides an opportunity to individualize instruction, assessment, as
well as assessment feedback
U5L3 - What are some benefits to using Google Classroom for assignments? - Answer
✔✔- Quickly see which students have completed work
Classroom can organize learning outcomes
U5L3 - Google Forms results can be imported into Google Classroom - Answer ✔✔-
True
U5L3 - Good formative assessments should include which of the following? (select
multiple) - Answer ✔✔- Serve a defined purpose
Align with learning outcomes
Meet the needs of the teacher
Highlight student learning
U5R - With conditional formatting, teachers can alter the cell color based on the value
for: (Select all that apply) - Answer ✔✔- Text
Dates
Numbers
U5R - Which advanced Google Sheets function gives you a list that removes all
duplicate values? - Answer ✔✔- Unique
U5R - Which criteria could a pivot table be applied to: (Select all that apply.) - Answer
✔✔- Student Names
, Assignment Dates
Assignment Scores
U5R - What is one (efficient) way to format data on a sheet using color? - Answer ✔✔-
Use conditional formatting
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. - Answer ✔✔-
=filter(D:F,C:C="Jimmy Wong")
U6L1:
How might you simplify the use of external resources or tools with Classroom? (Select
all that apply)
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 lessonLink content from external sites directly into the Stream
Each class within Classroom can have 3 levels of hierarchy, for example Grade, Class
and Section?
FALSE
Who should you let post on the Classroom Stream?
It will depend on your instructional goals for the Stream
Which of the following could you include in a "Materials" post? (Select all that apply)
Introductory video
Class description
Syllabus
Links to 3rd Party Sites - Answer ✔✔-
U6L2:
You can use tablets to make a blog post on a Blogger blog.
TRUE
All blogs are public to the world.
FALSE
Which of the following can you include in a blog post? (Select all that apply.)
Photos
YouTube video
Questions and Answers(A+
Solution guide)
U4 REVIEW - How can you join a Google Meet? (Select all that apply) - Answer ✔✔-
Web browser
Telephone
U4 REVIEW - Which is true about creating a Google Group with the setting "Only invited
users?" - Answer ✔✔- You must submit specific email addresses for those guardians to
join the Group
U4 REVIEW - Which is required for families to receive Guardian Summaries related to
your class? (Select all that apply) - Answer ✔✔- The educator must turn on Guardian
summaries for each class
The guardian must sign up to receive email updates
U4 REVIEW - Which outreach methods can be used to provide class guardians with
information? (Select all that apply) - Answer ✔✔- Google Groups
Google Sites
U4 REVIEW - When using the appointment slot feature in Google Calendar, multiple
people can select the same appointment slot. - Answer ✔✔- False
U4 REVIEW - Which is a benefit of using Google Groups to email your class guardians?
(Select all that apply) - Answer ✔✔- 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
U5L1 - What feature is used to color code cells based on their contents? - Answer ✔✔-
Conditional Formatting
U5L1 - Which Google Sheets Function creates line graphs and different types of bar
charts right in the cell of a spreadsheet? - Answer ✔✔- =chart
U5L1 - Custom functions can be used for conditional formatting. - Answer ✔✔- True
U5L1 - Which of the following ways can you apply conditional formatting to a cell?
(Select all that apply.) - Answer ✔✔- By date
By text contained in the cell
,By a number in the cell
U5L2 - What chart would be best to compare an individual group to the larger
population? - Answer ✔✔- Radar Chart
U5L2 - Which function will give you the total number of times a value appears if it meets
certain criteria? - Answer ✔✔- =countif
U5L2 - The options to summarize data in a pivot table report include: (Select all that
apply.) - Answer ✔✔- =sum
=counta
=average
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. - Answer ✔✔- False
U5L3 - What are some benefits, specific to assessments, to using Google Classroom
for assessment? - Answer ✔✔- Reduce the time between teaching and knowing what
students learned.
Google Classroom provides an opportunity to individualize instruction, assessment, as
well as assessment feedback
U5L3 - What are some benefits to using Google Classroom for assignments? - Answer
✔✔- Quickly see which students have completed work
Classroom can organize learning outcomes
U5L3 - Google Forms results can be imported into Google Classroom - Answer ✔✔-
True
U5L3 - Good formative assessments should include which of the following? (select
multiple) - Answer ✔✔- Serve a defined purpose
Align with learning outcomes
Meet the needs of the teacher
Highlight student learning
U5R - With conditional formatting, teachers can alter the cell color based on the value
for: (Select all that apply) - Answer ✔✔- Text
Dates
Numbers
U5R - Which advanced Google Sheets function gives you a list that removes all
duplicate values? - Answer ✔✔- Unique
U5R - Which criteria could a pivot table be applied to: (Select all that apply.) - Answer
✔✔- Student Names
, Assignment Dates
Assignment Scores
U5R - What is one (efficient) way to format data on a sheet using color? - Answer ✔✔-
Use conditional formatting
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. - Answer ✔✔-
=filter(D:F,C:C="Jimmy Wong")
U6L1:
How might you simplify the use of external resources or tools with Classroom? (Select
all that apply)
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 lessonLink content from external sites directly into the Stream
Each class within Classroom can have 3 levels of hierarchy, for example Grade, Class
and Section?
FALSE
Who should you let post on the Classroom Stream?
It will depend on your instructional goals for the Stream
Which of the following could you include in a "Materials" post? (Select all that apply)
Introductory video
Class description
Syllabus
Links to 3rd Party Sites - Answer ✔✔-
U6L2:
You can use tablets to make a blog post on a Blogger blog.
TRUE
All blogs are public to the world.
FALSE
Which of the following can you include in a blog post? (Select all that apply.)
Photos
YouTube video
