4th Gr. Assignment #19

Learning Goals:

*Read Web sites to find information

*Read headings to find the right place to read

*Gather information

Directions:

1. Download the spreadsheet here, open it, then minimize it to use later. Spreadsheet click here.

2. Go to this webpage to find the information needed on the spreadsheet. Website click here.

3. Scroll down to the heading that says “Population Size”. Put the populations into the spreadsheet from the webpage.

4. Go the heading that says “Food”. Read that section to make the list of foods they ate on the spreadsheet.

5th Grade Assignment #4

Learning Goals:

*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.

4th Grade Assignment #18

Learning Goals:

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

*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. Download worksheet by clicking 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.

4th Gr. Asssignment #17

Learning Goals:

*Four steps to making math formulas on spreadsheets

*Using spreadsheets to sort information

Directions:

1. Download the spread sheet by clicking the link, open it, then minimize it so it is ready. Spreadsheet download 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.

 

5th Gr. Assignment #3

Learning Goals:

*Use headings on web pages to target what sections you read

Directions:

1. Download the worksheet, open it, then minimize it so it is ready. Open Worksheet by clicking here

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.

4th and 5th Gr. Assigment #16

Learning Goals:

*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!”

Download the spreadsheet by clicking here.

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.

Guide click here.