Spreadsheets

toc =Excel Spreadsheet=

Good day class. Please open your book to page 395 ursGrades. In the book directions under "Your Turn" you are to open a project from the Computer 8 Lab 114 Templates. These are located on your computer in your finder in the Computer 8 Lab Folder. Once there go to Templates, Unit 7 and look for the project you are to open. Remember to save the document right away in YOUR Documents, Unit7 folder as ursGrades. To do this project you must use some functions. Please follow along with these instructions to make sure you do this correctly.

SUM
When you add a row of numbers, drag your mouse over them and continue to drag so you add one additoinal empty cell at the end of the row. Now go up and click on the arrow to the right of the funny looking E in your toolbar. There you will find the word SUM that you can click on. If you click on it it will put the total in the empty cell. Now..you do not have to keep doing that same process for each row of numbers to add. YOu can now just click and drag over the other cells where you want totals to go ....click on Edit in your menu bar and choose Fill. Now choose Fill down or fill right or fill up or whichever direction you want to fill that same function of SUM to copy. This is a way not to have to do but one function for any type of chore you have. Fill does just that. It fills the empty cells with the function you already used for one row of numbers.

AVERAGE
NOW for Average. Please click on the cell where you want to find an Average. Now go up to that funny looking E again and click on the arrow to the right of the E. Choose Average. Once that function pops up into the cell, click and drag over the numbers you wish to average. The computer will just put in the correct cells that you want to average ifyou just click and drag over them. It is automatic. Just because the average function pops up in your cell does not mean it has the correct numbers to average. YOU MUST click and drag over the numbers you are averaging to make sure the answer is correct. Once you click and drag over the row you want to average, hit Return or Enter and it will automatically average for you.

MIN/MAX
Understand that the same exact process works for MIN and MAX. You will be asked to find the highest grade or the biggest dollar amount and at that point you go up to the E which by the way is the icon for SUM... and click on the arrow to the right of it and choose MAX. Again, click and drag over the numbers you want to find the max for then hit return. Do the same for the lowest grade or smallest dollar amount etc. but choose MIN.

Charts
Now we will do page 403 urs RainfallSeasons. Open the project for this assignment the same way you opened ursGrades. It is already typed for you in your Unit 7 templates in the Computer 8 Lab 114 folder. Now go down to the Charts Silent Video Tutorial to learn how to add a chart. It is really easy..just watch and read as the video plays to see how to ...when you do your chart for this project, choose pie.

You will be expected to do page 397 ursStudentCouncil and page 401 ursTemperatures on your own next class period.



VideoTutorials
Here you will find a set of silent Video tutorials to show you how to work with Microsoft Exel Spreadsheets. Please watch the video you need to answer any questions you may have about using spreadsheets. You may pause and try things as they go or just watch them all the way through. Remember you can always hit pause, rewind, or forward to find parts you need to see over or to go parts you have already seen.


 * SILENT** **Videos Tutorials**

[|How to Get Around Excel Spreadsheets]

Formulas
[| Autosum, and other tools you need to know for Excel Spreadsheets]

Formatting
[| Learn to change the text, center, add colums and rows and more]

Charts
[| Now learn to make a chart using an Excel Spreadsheet]