WorksheetsGoogle Level 1 Fundamental Training Unit 8
Total questions: 6
Worksheet time: 12mins
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.
