Google Level 1 Fundamental Training Unit 8

Throughout the school year Mrs. Michaud has her students create many science projects and would like to track the progress of her students. She creates a Google Sheet that contains her students’ names with each assignment, date, score, and standard addressed. The columns are:

A: Name

B: Assignment

C: Date

D: Score

E: Standard Addressed

What tool can Mrs. Michaud use to add data to her Google Sheet more easily?

• Google Draw

• Google Docs

• Google Slides

• Google Forms

Which formula would be used to calculate the average scores in column D?

• \=Av

• \=Mean

• \=Average

• \=Av(Mean)

Mrs. Michaud wants to share the results with another teacher, but not allow the teacher to alter the data. Which of these choices allow this? (Select the 2 that apply.)

• Protected Range

• Protected Menu

• Protected Slide

• Protected Sheet

Google Forms are most helpful in which types of tasks? Select the 2 that apply.

• Communicating to large groups of educators

• Measure student progress over time

• Classroom quick checks

• Drafting responses to email

Which function would provide Mrs. Michaud a compressed list of the standards she has assessed? 

• \=unique(E:E)

• \=count(E:E)

• \=sort

• \=average(E:E)

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

• Both can be shared publicly.

• Both can pull data from multiple sources.

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

• Both can be customized.