Google for Education Level 1 Unit 8
CORRECT 100%
True/False: You can only input data into a Google Sheet through a Google Form. -
ANSWERFalse
Which feature limits the type of data that can be entered into a cell? - ANSWERData
Validation
Which of the following are types of data you can collect with Google Forms? -
ANSWERText; Dates; Numbers
Which app allows you to analyze data? - ANSWERGoogle Sheets
What Google tool creates a digital questionnaire to collect entries from users? -
ANSWERGoogle Forms
Which function ignores duplicates in a list and returns a single instance of each
item? - ANSWERUnique
Which of the following are types of data you can store in a Google Sheet? -
ANSWERNumber; Text; Dates
True/False: Users can only use Google Sheets on a Chromebook. - ANSWERFalse
True/False: Charts created in Google Sheets can be added to a Google Site. -
ANSWERTrue
Which chart can be used to represent trends over time - ANSWERLine chart
Google Forms are most helpful in which types of tasks? - ANSWERMeasure student
progress over time; Classroom quick checks
Which function would provide Mrs. Michaud a compressed list of the standards she
has assessed? - ANSWER\=unique(E:E)
Which type of graphs represent values as percentages of a whole? - ANSWERPie
chart
True/False: Google Sheets can be used to share student performance data with
others. - ANSWERTrue
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
CORRECT 100%
True/False: You can only input data into a Google Sheet through a Google Form. -
ANSWERFalse
Which feature limits the type of data that can be entered into a cell? - ANSWERData
Validation
Which of the following are types of data you can collect with Google Forms? -
ANSWERText; Dates; Numbers
Which app allows you to analyze data? - ANSWERGoogle Sheets
What Google tool creates a digital questionnaire to collect entries from users? -
ANSWERGoogle Forms
Which function ignores duplicates in a list and returns a single instance of each
item? - ANSWERUnique
Which of the following are types of data you can store in a Google Sheet? -
ANSWERNumber; Text; Dates
True/False: Users can only use Google Sheets on a Chromebook. - ANSWERFalse
True/False: Charts created in Google Sheets can be added to a Google Site. -
ANSWERTrue
Which chart can be used to represent trends over time - ANSWERLine chart
Google Forms are most helpful in which types of tasks? - ANSWERMeasure student
progress over time; Classroom quick checks
Which function would provide Mrs. Michaud a compressed list of the standards she
has assessed? - ANSWER\=unique(E:E)
Which type of graphs represent values as percentages of a whole? - ANSWERPie
chart
True/False: Google Sheets can be used to share student performance data with
others. - ANSWERTrue
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
