by kathy barber. a.it is kind of like a tablecloth, but you put it on a bed. b. it is a computer...
TRANSCRIPT
![Page 1: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/1.jpg)
By Kathy Barber
![Page 2: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/2.jpg)
A.A.It is kind of like a tablecloth, but It is kind of like a tablecloth, but you put it on a bed.you put it on a bed.
B.B. It is a computer program that It is a computer program that performs math calculations and can performs math calculations and can help people organize information.help people organize information.
C. It is a sheet you spread out before C. It is a sheet you spread out before you lay on it.you lay on it.
![Page 3: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/3.jpg)
Your teacher’s Grade Book Your Reading Record A Calendar Your mom’s checkbook An inventory of your video games Now let me show you a couple of
spreadsheets I use here at school.
School Schedule Week 1 AR Participation
![Page 4: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/4.jpg)
![Page 5: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/5.jpg)
Column CRow 2
Cell A2 stands for column A,
row 2.
Each column is identified by a letter such as A, B or C. Columns are vertical (up and down).
Each row is identified by a number such as 1, 2 or 3. Rows are horizontal(side to side).
When a column and a row form a rectangle, it is called a cell.
![Page 6: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/6.jpg)
Whatever you type in a cell, appears in the formula bar.
To move from cell to cell (across from left to right), you
can use the TAB button!
To move up and down, just use your arrow keys!
![Page 7: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/7.jpg)
What’s the difference between a row and a column?
Rows are labeled by numbers and are horizontal. Columns are labeled by letters and are vertical.
What is a cell? What shape is a cell?A cell is the point a row and column
meet. It is a rectangular shape. How can you move across on a row?You use the tab key to move across a
row. How do you move down to the next
cell in a column? You use the arrow keys to move down a
column.
![Page 8: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/8.jpg)
![Page 9: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/9.jpg)
Let’s vote on our favorite French Fries! Someone go to the board to gather the
data. Your choices are: McDonald’s, Wendy’s,
or Burger King. Count how many students chose each
restaurant and write it on the board. Now open your laptop. Open Excel. Go to Start-Programs-Microsoft Office-
Excel. In Cell A1-Type: Restaurant
Stop---hint time….
![Page 10: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/10.jpg)
When you create a new spreadsheet to enter data, you can easily adjust column widths to display the data.
Double click on the line that separates
the columns to make the column expand to fit your text. Use
this when your words won’t fit!
![Page 11: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/11.jpg)
Double-click the line between the columns, so the word will fit.
In Cell B1- Type: How Many Double-click the line between the columns
again. In Cell A2-Type: McDonald’s In Cell B2-Type: How many people voted
for McDonald’s. In Cell A3-Type: Wendy’s In Cell B3-Type: How many people voted
for Wendy’s. In Cell A4-Type: Burger King and then put
the data for the Burger King vote in Cell B4.
![Page 12: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/12.jpg)
Click and hold here, then drag your mouse to highlight everything you typed. Then change the size of the font to 20.
Now Double click the lines between the columnsso your words will fit.
![Page 13: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/13.jpg)
1. Click and drag to highlight yourWords again. Make sure you are in the cell that gives the number of votes for Burger King.
2. Click on InsertPull down to Chart.
![Page 14: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/14.jpg)
2. Click on each bar to change its color.
3.Click on words to change their size.
1. Click on Title to change it.
4. You can click on the bars and then click “add data labels” to get these numbers.
![Page 15: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/15.jpg)
2. Click and drag to highlight the area that you have created.
3. Choose: File-Page Set up-Landscape. ThenChoose print preview. If it looks right, then print!
1. Type your nameIn Cell A12.
![Page 16: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/16.jpg)
![Page 17: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/17.jpg)
Open Excel Beginning in cell A1-Type the name of one
person at your table. Push enter. In cell A2-Type another persons name. Push
enter. Keep typing until you get everyone’s name
typed.
![Page 18: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/18.jpg)
Click and drag to highlight your names.
Then change the font size.
![Page 19: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/19.jpg)
See this tool?This is the tool thatWill sort your informationEither in alphabetical (Ascending)Or backwards alphabetically (Descending).
It will sort numbers too!
![Page 20: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/20.jpg)
Ascending means: A to Z Descending means: Z to A
Practice sorting your names both ways.
Now let’s type our spelling words and sort them.
![Page 21: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/21.jpg)
![Page 22: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/22.jpg)
We are going to keep a spreadsheet on our laptops of our reading log.
Open Excel At cell A1-Type Date In Cell B1-Type Title In Cell C1-Type Points Skip row 2. Now look at your Reading Log. Create a spreadsheet that matches your
Reading Log.
![Page 23: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/23.jpg)
Once you get all yourDates, Titles, and PointsTyped, skip several rows then Type “Total Points.
![Page 24: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/24.jpg)
Then click in the cell thatis under your points and besidethe words “total points”.
Next click on the dropDown arrow beside the funny littleIcon called: Auto Sum. Pull down to choose: Sum.
![Page 25: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/25.jpg)
When you see this. Push enter.
Now you should see a total of allyour points!
![Page 26: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/26.jpg)
An Excel spreadsheet is the only Microsoft Office product that can do math!
When you add number together you get a “sum”.
Your teacher would use the “Average” to get a grade for your report card. We will learn more about this later.
![Page 27: By Kathy Barber. A.It is kind of like a tablecloth, but you put it on a bed. B. It is a computer program that performs math calculations and can help](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697bff71a28abf838cbec62/html5/thumbnails/27.jpg)