Skip to content

2. Create and Share Your Spreadsheet
attachment

Playback Speed:
Transcript

In this video, you and your partner will create a shared spreadsheet.

To create and play your word jumble game, you will write a function that will provide ten random letters on your spreadsheet.

Then, you will use those random letters to form as many words as you can.

To start, choose one partner to create and rename a new spreadsheet from their own computer.

This partner will share the spreadsheet with the other partner.

Give your partner edit access, so they can make changes to the spreadsheet.

Now, the partner who did not create the spreadsheet can open it from their email.

Spreadsheets are made up of rectangles called cells.

A cell is a space where you enter information, like numbers, letters, formulas or functions.

Cells are organized into rows and columns.

A row is a horizontal set of cells and is labeled with a number.

A column is a vertical set of cells and is labeled with a letter.

Every cell has a cell reference, which based on its column and row. Cell A1, is in column A, row 1. Cell B3 is in column B, row 3. In Cell A1, type the word “Letters” and bold the text.

You will generate your random list of letters in the cells below this one.

Now move on to the next video to write a formula to generate a random letter.

Now, it’s your turn: Create, rename and share a new spreadsheet, Open the spreadsheet, And type “Letters” in cell A1.

Instructions

  1. Create, rename and share a new spreadsheet.
  2. Open the spreadsheet.
  3. Type “Letters” in cell A1.
Before sharing your work with your teacher, follow these steps to give them access to your file:
  1. Open your file.
  2. Click "Share" in the upper right corner.
  3. Add your teacher's email address.
  4. Give them "Commenter" or "Editor" access
  5. Click "Done"