*Re-size Windows so you can have two at once on your screen.Directions:

*Work between two applications

*Read directions and follow them carefully. Re-read directions when confused.

Directions:

1. Download the worksheet, open it, minimize it so it is ready.Worksheet Click here.

2. You are going to fill in the blanks on a worksheet. Find the missing words from the website given. Have both the website and the document up at the same time. Look at the image on 4th Grade Assignment #18 post for an illustration. Website click here.

2. You are going to fill in the blanks on a worksheet. Find the missing words from the website given. Have both the website and the document up at the same time. Look at the image on this post for an illustration. Website click here.

2. Understand the job and what you are doing. You are keeping a spreadsheet to count the number of books individual classrooms have donated to a school book drive. Any class that comes up with more than 250 books will win a pizza party donated by the local pizza place. You are to put all the numbers you get into the spreadsheet and write a short letter to the principal telling her which classes get pizza parties.

3. Enter these numbers into your spread sheets. Assume the numbers are given in order for the dates that apply. Room 101 got 25, 76, 46, 35, 45, 13 books totaled each Friday of the drive. Room 102 got79, 12, 16, 55, 61, 28 books totaled each Friday of the drive. Room 103 got 12, 43, 32, 67, 46 books totaled each Friday of the drive. Room 104 got 65, 22, 21, 24, 60, 43 books totaled each Friday of the drive.

4. Once you have the numbers put in, put in math formulas in the “Grand total of books” cell for each room. We will do this today with the function wizard. Click menu “Insert” then “Function”. You get a window that looks like the one posted in the image on this blog. Choose the “Sum” function.

5. Follow the steps outlined in the functions wizard, going to “next” after you choose sum. In the “next” step you click the icon I circled in the image of this blog post. Choose the cells you want to add up. Click “Finish”.

Show Mr. Litt to check off. We will continue this project in the next assignment.

2. Go to the website by clicking on the link. return to the blog to read further directions after you’ve opened the website. Click here for website

3. Follow the directions on the sheet. find answers for the questions. Do not copy and paste. Our learning goal is to learn from websites by reading and understanding. Take the time to put your own voice into your answers to take ownership of them.

*Review the 4 basic steps to writing spreadsheet math formulas.

*Learn how to put division into spreadsheet math formulas.

Directions:

1. Read this to understand the story first.

Ms. Dolores’ class was learning estimating. Ms. Dolores bought many bags of M & Ms and put them in a jar. The class used different ways to estimate how many were there. When they were done, Ms. Dolores challenged the class. “Figure out how many bags of M & Ms I bought and I will let you eat all of them!” One student had Mr. Litt’s class and said, I know how we can figure this out with a spreadsheet!”

2. Put the umbers of M & Ms the class counted into the spreadsheet. There were 157 reds, 162 greens, 225 blues, 165 browns, and 226 yellows.

3. Put math formulas into cell D11 and D13 that will tell us how many bags Ms. Dolores bought. Read the guide carefully, it brings you through how to solve this problem step by step.