Google-Unit 8

True

Charts created in Google Sheets can be added to a Google Site. True or false?

A B and D

Comparing the line graph and pie chart feature set, which of the following is accurate for both? (Select all that apply) A. Both can be shared publicly B. Both can pull data from multiple sources C. Both are designed to display information over a period of time D. Both can be customized

B. Classroom quick checks and C. Measure student progress over time

Google Forms are most helpful in which types of tasks? (Select all that apply) A. Drafting responses to email B. Classroom quick checks C. Measure student progress over time D. Communicating to large groups of educators

True

Google Sheets can be used to share student performance data with others. True or false?

A. Protected Range and B. Protected Sheet

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) A. Protected Range B. Protected Sheet C. Protected Slide D. Protected Menu

C. Google Forms

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? A. Google Draw B. Google Docs C. Google Forms D. Google Slides

False

Users can only use Google Sheets on a Chromebook. True or false?

D. Google Forms

What Google tool creates a digital questionnaire to collect entries from users? A. Google Search B. Google News C. Gmail D. Google Forms

D. Google Sheets

Which app allows you to analyze data? A. Search B. Gmail C. Google Forms D. google Sheets

D. Line Chart

Which chart can be used to represent trend over time? A. Bar chart B. Pie chart C. Scatterplot D. Line Chart

B. Data Validation

Which feature limits the type of data that can be entered into a cell? A. Formatting B. Data Validation C. Sum D. Transpose

B. =Average

Which formula would be used to calculate the average scores in column D? A. =Mean B. =Average C. =Av D. =Av(Mean)

B. Unique

Which function ignores duplicates in a list and returns a single instance of each item? A. Sort B. Unique C. Average D. Transpose

A. =unique(E:E)

Which function would provide Mrs. Michaud a compressed list of the standards she has assessed? A. =unique(E:) B. =count(E:) C. =sort D. =average(E:E)

A B and D

Which of the following are types of data you can collect with Google Forms? (Select all that apply) A. Text B. Dates C. Fingerprints D. Numbers

B C and D

Which of the following are types of data you can store in a Google Sheet? (Select all that apply) A. Videos B. Numbers C. Text D. Dates

B. Pie Chart

Which type of graph represent values as percentages of a whole? A. Bar chart B. Pie chart C. Scatterplot D. Line chart

False

You can only input data into a Google Sheet through a Google Form. True or false?