8 Sheets 1 Age On Planets

8TH SHEETS AGE ON PLANETS

Strand 6: Technology Operations and Concepts

Concept 2: Application 

Select and use applications effectively and productively.

PO 3: Enter/edit data using simple formulas while using spreadsheet(s) to perform calculations. 

MP.5 Use appropriate tools strategically.

YOUTUBE VIDEO

Vocabulary

Row

Column

Formula Bar

Charts

AutoSum

Complete the following assignment Save As: (7 or 8)Sheets1 your name 

Sign in to Google and open a blank Sheets document

1. In Cell A1 type your First and Last name.

Cell B1 type Length of Earth Year

Cell C1 type Your Age On Earth

Cell D1 type Your Age On Planets

2. In Cell A2 Type Planets

3. In Cells A3 – A11 type the following planets in order:

Mercury

Venus

Earth

Mars

Jupiter

Saturn

Uranus

Neptune

Pluto

4. In cell B1 type: Length of Year (Earth Year)

5. In Cell C1 type: Your Age on Earth

6. In cell D1 type: Your Age on Planets

7. In cells B3 – B 11 type the following numbers:

0.24

0.62

1

1.88

11.86

29.46

84.07

164.82

248.6

8. In Cell C3 type in your current age in years

9. Use the fill handle to complete filling in the rest of the cells to cell C11

10. To fill in formulas in cells D3 – D11 use the following hints:

You use an = then C3 (operation sign) B3

10. To check your answers the Mercury number should be at or near 58 if you are 14 or 54 if your are 13

11. Save as: Sheets1 your name

12. MFT

Your Name

Length of Year (Earth Year)

Your Age on Earth

Your Age On Planets

Planets

Mercury

0.24

14

58.33

Venus

0.62

14

Earth

1

14

 14

Mars

1.88

14

Jupiter

11.86

14

Saturn

29.46

14

Uranus

84.07

14

Neptune

164.82

14

Pluto

248.6

14