GCE Level-1 Quiz 8

Which of the following are types of data you can store in a Google Sheet? (Select all that apply.)

• Videos

• Numbers

• Text

• Dates

Users can only use Google Sheets on a Chromebook.

• True

• False

Charts created in Google Sheets can be added to a Google Site

• True

• False

Which chart can be used to represent trends over time

• Bar Chart

• Pie Chart

• Scatterplot

• Line chart

Which type of graphs represent values as percentages of a whole?

• Bar Chart

• Pie chart

• Scatterplot

• Line chart

Google Sheets can be used to share student performance data with others.

• True

• False

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 Docs

• Google Draw

• Google Slides

• Google Forms

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

• \=Average

• \=Av

• \=Av(Mean)

• \=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 all that apply.)

• Protected Range

• Protected Menu

• Protected Sheet

• Protected Slide

Google Forms are most helpful in which types of tasks?Select All Correct Responses

• Drafting responses to email

• Communicating to large groups of educators

• Classroom quick checks

• Measure student progress over time