Font size
WorksheetsLevel 2 Certification Part 4
Total questions: 45
Worksheet time: 28mins
What feature is used to color code cells based on their contents?
Data Validation
Drive Template Gallery
Summary
Conditional Formatting
Which Google Sheets Function creates line graphs and different types of bar charts right in the cell of a spreadsheet?
=chart
=graph
=mod
=sparkline
Custom functions can be used for conditional formatting.
True
False
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
By an image in the cell
What feature is used to color code cells based on their contents?
Data Validation
Drive Template Gallery
Summary
Conditional Formatting
Which Google Sheets Function creates line graphs and different types of bar charts right in the cell of a spreadsheet?
=sparkline
=mod
=graph
=chart
Custom functions can be used for conditional formatting.
True
False
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
By an image in the cell
What chart would be best to compare an individual group to the larger population?
Bar Chart
Scatter Chart
Pie Chart
Radar Chart
Which function will give you the total number of times a value appears if it meets certain criteria?
=averageif
=sumif
=countif
=count
The options to summarize data in a pivot table report include: (Select all that apply.)
=average
=counta
=countif
=sum
If you change the sort or filter criteria in a filter view everyone viewing that Sheet will also have their data sorted or filtered.
True
False
What are some benefits, specific to assessments, to using Google Classroom for assessment?
Since student cannot resubmit assignments, there is little or no benefit.
Google Classroom provides an opportunity to individualize instruction, assessment, as well as assessment feedback
A digital classroom is always better
Reduce the time between teaching and knowing what students learned.
What are some benefits to using Google Classroom for assignments?
Quickly see which students have completed work
Classroom can organize learning outcomes
A public space to see how and what students are learning
Real time collaboration
Google Forms results can be imported into Google Classroom
True
False
Good formative assessments should include which of the following? (select multiple)
Highlight student learning
Meet the needs of the teacher
Align with learning outcomes
Serve a defined purpose
With conditional formatting, teachers can alter the cell color based on the value for: (Select all that apply)
Text
Images
Dates
Numbers
Which advanced Google Sheets function gives you a list that removes all duplicate values?
Filter
Average
Data Validation
Unique
Which criteria could a pivot table be applied to: (Select all that apply.)
Student Names
Assignment Dates
Assignment Scores
Shared Collaborators
What is one (efficient) way to format data on a sheet using color?
Use the bucket to manually change each cell
Use the =colorif formula
Print the sheet and use a highlighter
Use conditional formatting
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:E,F:D)
=sum(D:F,C:C="Jimmy Wong")
=sum(D:E,F:D)
=filter(D:F,C:C="Jimmy Wong")
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 lesson
Don’t use external tools; you can do everything you need in Classroom
Link content from external sites directly into the Stream
Each class within Classroom can have 3 levels of hierarchy, for example Grade, Class and Section?
True
False
Who should you let post on the Classroom Stream?
Only you
All students in the class
It will depend on your instructional goals for the Stream
You and a subset of students
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
You can use tablets to make a blog post on a Blogger blog.
True
False
All blogs are public to the world.
True
False
Which of the following can you include in a blog post? (Select all that apply.)
Photos
YouTube video
Text
Links to websites
. Who can be a blog author?
Teachers
Students
Administrators
All of the above
It is not possible to email existing collaborators of a document from within the document.
True
False
What can you embed into your syllabus to make it more engaging? (Select all the apply.)
Images
Videos
Tables
Drawings
Which formatting feature allows you to not only style text consistently, but also create links within a Google Doc?
Hyperlinks
Conditional Formatting
Paragraph Styles
Bookmarks
How can you notify people of changes to your document? (Select all that apply.)
Inserting a comment and mentioning their email address with a +
They are automatically emailed whenever a change is made
Using the File > Email collaborators option
Clicking the email icon in the toolbar
You have to decide to use Drive or Sites to house student work, as you can’t use both.
True
False
On a Google site, you can insert: (Select all that apply.)
Videos
Images
Slides
Maps
One way to digitize student work such as paintings, models and sculptures is:
Upload it to Google Maps
Using Google Forms
Analog work cannot be digitized
Taking photos and video
Google Sites, like Drive documents, can be set by the user to be private or public.
True
False
Why would you use URL shortener with a Google Sites URL?
It makes your Google Site look nicer
It creates a short URL that is easy for students to type into the address bar
It allows you to give edit access to your Google Site to many different people
It allows you to purchase a domain name and create a custom domain for your Google Site
What age students are able to create blog posts to share their learning?
7 year olds
12 year olds
18 year olds
All of the above
Which of the following is a way to set up Blogger in your classroom? (Select all that apply.)
Teacher is the sole author. Students can leave comments
Teacher and students can all be authors
Students are authors each with his or her own blog
A team of teachers that are all authors on one shared blog
Which of the following is true about using a Google Doc as a class syllabus? (Select all that apply.)
Once you send it to your students, you can’t make any changes
You can only share it by attaching the file to an email
You can collaborate with a teaching partner to create a shared syllabus
You can share your syllabus with the world
What are some ways to make a Google Doc more engaging?
Use a table of contents
Use different fonts for each paragraph
Use images with purpose
Alert collaborators using "+" in comments
Why have students create a digital portfolio? (Select all that apply.)
To reflect on their learning
To collect evidence of learning
To use in a college application
To share with family
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? (Select all that apply.)
In the Google Site
In Google Drive
On YouTube
In Google Photos
What are some ways to make a Google Doc more engaging?
Use a table of contents
Use different fonts for each paragraph
Use images with purpose
Alert collaborators using "+" in comments
