Font size
WorksheetsGCEL1 UNIT 8: MEASURE, UNDERSTAND, AND SHARE STUDENT GROWTH
Total questions: 6
Worksheet time: 5mins
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 Forms
Google Slides
Which formula would be used to calculate the average scores in column D?
=Mean
=Average
=AV
=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 all that apply.)
Protected Range
Protected Sheet
Protected Slide
Menu
Google Forms are most helpful in which types of tasks?
Drafting responses to email
Classroom quick checks
Measure student progress over time
Communicating to large groups of educators
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 all 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.
