Spreadsheet Calculations

Introduction

File: Spreadsheet commands - copy this file and study the associated videos

VIDEOS: 

• Spreadsheet math - introduction [16:57] ss- (commands)

• Count, CountA, CountBlank, CountIfs [9:16]

• Basic statistics: Max, Min, Average, [6:06]

• Logic Statements: Now, If, And [3:26]

• Commands - Split, Concatenate, Transpose, [4:49]  ss-filea

• Using the ImportRange command to link spreadsheets [7:27]

• Quickwrites - Collaborative Spreadsheets [6:44]

• Sorting on a calculated column [3:37] - ss (forests)

• Count, CountA, CountIF, CountIFS, CountBlank [8:10] ss- (SoCal birds)

• Data Validation [4:46] - ss-(succesion) 

• Filter [9:43] - ss (earthquakes)

• Translate [3:49] - ss (translate)  

• Absolute and Relative References [2:31] - ss (forests)

• Performing operations on data in a remote spreadsheet [6:15]

(1) Calculations in Science - Reaction Energy

• Calculate the energy of the following reactions (1) combustion of methane; (2)  formation of ethanol from ethylene and water, (3) formation of water from hydrogen and oxygen

(2) Calculations in Science - Scale Models

• Calculate a model of the scaled diameters and distances from the Sun of the planets in our solar system.  Compare it with "If the Moon were only a pixel", and explain how you help students understand the concept of scale. 

• Complete the table  and create a graph that demonstrates  solar light intensity on various planets. 

• For more information about scientific notation

(3)  Calculations-1

Examine the formulas embedded in the locked sheets.  Once you understand them, input the necessary formulas in the quiz sheet to auto-generate the correct answers. 

• Task: Calculations-1 quiz

(4)  Calculations-2

Examine the formulas embedded in the locked sheets.  Once you understand them, input the necessary formulas in the quiz sheet to auto-generate the correct answers. 

• Task: Calculations -2 quiz

(5) Calculations-3

Examine the formulas embedded in the locked sheets.  Once you understand them, input the necessary formulas in the quiz sheet to auto-generate the correct answers. 

• Task: Calculations-3 quiz

(6) Calculations - 4

Create equations with appropriate reference cells for each of the equations in this spreadsheet

• Task: Calculations-4 quiz