Unit 3 Review - GSheets

How do we refer to the orange box?

• Cell 3B

• Cell B3

• Column B, Row 3

• Row B, Column 3

Which of the following describes binary search?

• Sort the list. Find the middle value in the data set. Eliminate 1/2 of list. Repeat until item found.

• Work through the list item by item, in order, until you find the item.

• Randomly select items from in the list and check them. Repeat until item is found.

• Wait. The answer will appear eventually...

Which ONE of the following statements is TRUE?

• Rows go up and down

• The vernier sensors (CO2, Light, Sound) are a form of output

• .csv files can only be opened in spreadsheet software

• linear search = can be sorted or unsorted; does not matter at all

Which ONE statement is NOT True?

• Binary search is significantly faster on LARGE data sets

• plt.xlabel("years"). xlabel is the method

• ROYGBIV all combine together into white light

• All problems in existance can be solved in a reasonable time

Which would best describe discrete data (in comparison to analog data)?

• Data that must be sampled from some input and is stored as a numerical data

• Continuous data that is described by complex values with infinite samples

• The data produced by the sun as light, as sound, and as smell

• Data that is searchable

Which of the following measurements is incorrect?

• Sound intensity is measured in decibles (db)

• Light is measured in luminocity (lux)

• CO2 concentrations are measured in parts per million (ppm)

• All of the answers are true

Assuming column A is Time and displayes a data point for every second. The first 4 numbers displayed in GSheets with this code: =MOD((A2:A), 10)=0

• 1, 11, 21, 31

• 0, 10, 20, 30

• 0, 1, 2, 3

• 0, 2, 4, 6

• 1, 3, 5, 7

Which is true when comparing MODE and AVERAGE?

• They are always the same

• AVERAGE is the middle number of the data set

• AVERAGE can be skewed by outliers if the data set is small

• AVERAGE is always more appropriate to use

What is the biggest reason to use spreadsheets?

• Spreadsheets help us visualize data and make connections

• Spreadsheets are easiest to type in

• Spreadsheets are the only tool we have for data analysis

• Spreadsheets process big data!

Which graph/chart is best suited to show changes over time?

• line graph

• bar chart

• pie chart

• It doesnt' matter. Just graph it!