WorksheetsGCE Level-1 Quiz 8
Total questions: 20
Worksheet time: 12mins
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
Which function would provide Mrs. Michaud a compressed list of the standards she has assessed?
\=average(E:E)
\=unique(E:E)
\=sort
\=count(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 customized.
Both are designed to display information over a period of time.
Both can pull data from multiple sources.
Both can be shared publicly.
Which of the following is not a modifier used to narrow results in a search?
“ “
$
%
-
It is easy to differentiate between results which are ads and natural results in a search.
True
False
Teaching students to ‘search smart’ reinforces that they: (Select all that apply.)
Save time
Become critical thinkers
Can access information easily
Understand how to narrow search results
It is possible to narrow search results to return results based on the following file type(s):
Adobe Acrobat (.pdf)
Microsoft Excel (.xls)
Microsoft PowerPoint (.ppt)
All of the above
Which of the following domain extensions is likely to have the most accurate information about the government?
Copyright laws only apply to online content that makes people money.
True
False
What are some essential points to consider when evaluating the validity of a website? (Select all that apply.)
Ask yourself what opinions or ideas are missing
Consider who published the information
How professional the website looks
Look at the domain extension for the site
Using Advanced search, it is easy to filter images based on usage rights.
True
False
