wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Google Certified Educator Fundamentals Training Units 8-9

Total questions: 10

Worksheet time: 10mins

Name
Class
Date
1.

Which formula would be used to calculate the average scores in a column of grades in a Google Sheet?

a)

\=Mean

b)

\=Average

c)

\=Av

d)

\=Av(Mean)

2.

Mrs. Michaud wants to share information on her Google Sheet with another teacher, but not allow the teacher to alter the data. Which of these choices allow this? (Select all that apply.)


Protected Menu

a)

Protected Range

b)

Protected Sheet

c)

Protected Slide

d)

Protected Menu

3.

Google Forms are most helpful in which types of tasks?


a)

Drafting responses to email

b)

Classroom quick checks

c)

Measure student progress over time

d)

Communicating to large groups of educators

4.

Which function would provide Mrs. Michaud a compressed list of the standards she has assessed (standards addressed are listed in column "E")


a)

\=unique(E:E)

b)

\=count(E:E)

c)

\=sort

d)

\=average(E:E)

5.

Comparing the line graph and pie chart feature set, which of the following is accurate for both? (Select all that apply.)

a)

Both can be shared publicly.

b)

Both can pull data from multiple sources.

c)

Both are designed to display information over a period of time.

d)

Both can be customized.

6.

Which tool would help a student search more efficiently?


a)

Search Filters

b)

The Explore tool

c)

Google Translate

d)

Google Slides

7.

Extensions are best defined as:


a)

Tools for viewing and interacting with webpages

b)

Shortcuts to webapps

c)

A tool to help you catalog your bookmarks

d)

Available only on Chromebooks

8.

An essential skill today is knowing how to cite sources properly. Creative Commons has a system of licenses and tools for creators to retain copyright while allowing others to:

a)

Copy

b)

Distribute

c)

Remix work

d)

All of these

9.

A digitally literate person must be able to find, evaluate, use, and communicate information digitally. Which of the following tools help facilitate and enhance digital literacy? (Select all that apply.)


a)

Google Search

b)

Google Scholar

c)

Chrome web store

10.

When evaluating the validity of a website beyond its URL, you can practice the “Rule of 3” which means:


a)

Look at 3 different pages from the same website

b)

Compare 3 sources of information about the topic

c)

Find 3 people in the classroom who agree with your opinion

d)

Make sure that the URL for the website has 3 different extensions in it