Graphing and Data Analysis in Google Sheets

Graphing and Data Analysis in Google Sheets

Assessment

Interactive Video

Chemistry, Computers, Science

9th - 10th Grade

Hard

Created by

Patricia Brown

FREE Resource

This video tutorial guides students through creating graphs using Google Sheets. It covers entering data, sorting it, and visualizing it through bar charts. The tutorial focuses on graphing atomic numbers against properties like O in oxide and boiling points, including converting Celsius to Kelvin. Students are encouraged to practice by creating additional graphs and analyzing patterns.

Read more

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the primary purpose of using Google Sheets in this tutorial?

To write essays

To create and analyze graphs

To design websites

To edit videos

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which data is first entered into Google Sheets for graphing?

C inquired and atomic number

Atomic number and O in oxide

Boiling point and atomic number

Melting point and atomic number

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What type of chart is recommended for visualizing the data?

Area chart

Bar chart

Line chart

Pie chart

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you ensure the atomic numbers are in order in the chart?

By using the sort range feature

By using a filter

By deleting and re-entering the data

By manually rearranging them

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the formula to convert Celsius to Kelvin?

K = C + 273.15

K = C + 100

K = C - 273.15

K = C + 32

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the next step after converting Celsius to Kelvin in the spreadsheet?

Create a pie chart

Create a line chart

Create a scatter plot

Create a bar chart

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What additional graphs are students asked to create?

Graphs for speed and time

Graphs for melting points and C inquired

Graphs for density and volume

Graphs for mass and weight

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?