Spread Sheets
Do not worry about finishing all activities. Start at number 1. Do as many as you can.
1 Starting your Spread Sheet
Watch the video
2 Formatting in a Spread Sheet
Watch the video Then do the tasks in your Spread Sheet
2. Video for computer or laptop - Click picture below
2 Video for iPad phone or tablet - click picture below
Formattingipadspreadsheet.mov
Activity 2 - Formatting
Write your name in a cell
Click Enter Return or Check Mark
Write six other names in cells below
Center the names
Give each person a different color cell
Make the column wider
Make the row taller
3 Repeating - Spread Sheet
Watch the video Then do the tasks in your Spread Sheet
Activity 3 - Repeating
Write a word in a cell
Click Enter Return or Check Mark
Repeat the word in cells going across across
Repeat a different word in cells going below
Try this a few times
4 Adding Numbers - Spread Sheet
Watch the video Then do the tasks in your Spread Sheet
Activity 4 Adding Numbers
Clear all cells
Click on cell A1 and type = 4 + 5 hit enter
In cells below make more addition problems with each one harder and harder
Click on cell B1 and type = 10 - 2
In the cells below make other subtraction problems ... Make at least 5 of each
Y5 and Y6 (Y3 optional).... Try to make some harder problems ... example. 100/5 or 23 x 5,687. or 34+2-6 *89 /2
5 Sorting - Spread Sheet
Watch the video Then do the tasks in your Spread Sheet
Sheetsfilteronphone.mov
Activity 5
Computer/laptop:
Type in six or more numbers
Sort them by selecting Data and then Sort
Type in six or more colors
Sort them selecting Data and then Sort
Activity 5
Phone/iPad/tablet:
Type in a heading called numbers. Type six or more numbers below.
Click on cell called numbers
Click upper right corner of screen with three dots
Select Create a filter
Leave that screen
Click on small triangle in cell called Numbers
Filter A to Z
6 Formulas in a Spread Sheet
Watch the video Then do the tasks in your Spread Sheet
Activity 6
Type 1 in the A1 box Hit Enter or Return
In the B1 box type =sum(A1+1) Hit Enter or Return
Drag the tiny blue box all the way across the screen
Put a new number in the A2 box Hit Enter or Return
Click in the B2 box Try another formula on row 2
7 Make a Graph / Chart in a Spread Sheet
Watch the video Then do the tasks in your Spread Sheet
Activity 7
Type these words in column A
Shirts Pairs of Socks Shorts
Swim Clothes Hats Sunglasses
Stuffed Animals Towels Pictures
Count in your room
Type the counted number for each in column B
Highlight all text Select Insert and then Chart
Video for finding your spreadsheet file on a Computer or laptop
Computer or laptop
Finding the Spread Sheet you made
Go to Google Classroom
Look for a square of 9 dots in top right corner
Click on dots
Click on Google Drive
Click recent or search for CSS
Two clicks on the CSS file
Phone, ipad, tablet
Finding Spread Sheet you made
Go to Google Classroom
Click on the folder symbol at the bottom of the page
Then click on the magnifying glass
There you can type in CSS
No Folder? try these steps......
Go to Google Classroom
Look for a square of 9 dots in top right corner
Click on dots
Click on Google Drive
Click recent or search for CSS
Two clicks on the CSS file
1 Make a Spread Sheet
Watch the video for laptop/computer or phone/iPad/tablet and then click Activity 1
Video for computer or laptop Activity 1
Video for iPad/phone/tablet Activity 1
Ipadgooglesheetsnew.mov
laptop or computer
After clicking Activity 1
Go to File and select Make a Copy
Change the name of the file to CSS
Push the green OK button
Phone, ipad, tablet
Activity 1
Do these steps
Chrome search for Google Sheets
Click on Google Sheets Sign in
Sign in to your Google Account if needed
Click on the rainbow colored plus sign
Click on the pencil
Name your sheet CSS