Sixth Grade Spreadsheet Project Instructions



Sixth Grade Spreadsheet

M&M Project Instructions

Using Excel to record and analyze information.

Getting Ready

Launch Microsoft Excel and get a new workbook.

Make sure you have these three toolbars on: View, Formula Bar and View,Toolbars: Standard, and Formatting

Entering the Information in the Spreadsheet

In Cell A1, type your first and last name.

In Cell A2, type your teacher’s name.

Leave cells A3 & A4 blank.

In Cell A5, type “Red”

In Cell A6, type “Yellow”.

In Cell A7, type “Orange”.

In Cell A8, type “Green”.

In Cell A9, type “Blue”.

In Cell A10, type “Brown”.

In Cell B5, type the number of red M&Ms.

In Cell B6, type the number of yellow M&Ms.

In Cell B7, type the number of orange M&Ms.

In Cell B8, type the number of green M&Ms.

In Cell B9, type the number of blue M&Ms.

In Cell B10, type the number of brown M&Ms.

In Cell B11, Use the AutoSum shortcut to enter a formula for the sum.

When the spreadsheet asks you if the range B5:B10 is correct, hit Enter on your keyboard – this confirms the formula. You should see the total number of M&Ms in Cell B11.

Formatting the Cells

Highlight Cells A5 to C10.

Change the size of the font to 14.

Change the color of the font in Cells A5 to A10, so that each word is the color it represents. For example, change Red to red, Yellow to yellow and so on.

Entering the Formula for Percentage

Make sure you use the number 1, not the lower case L!!

In Cell C5, type “=B5/B11”

In Cell C6, type “=B6/B11”

In Cell C7, type “=B7/B11”

In Cell C8, type “=B8/B11”

In Cell C9, type “=B9/B11”

In Cell C10, type “=B10/B11”

In Cell C11, use the AutoSum short cut to add up the percentages. You should get 100%.

Highlight Cells C5 to C11. Click on the percentage shortcut [pic] in the formatting toolbar. This will change all of your results to a two-digit answer with a percent sign.

Save this file as “M&Ms” and now you can eat them.(

Charting Your Results

Highlight Cells A5 to B10.

In the Menu Bar, go to Insert, Chart

The Chart Wizard starts up. This is how you will create a pie chart, step by step.

Click on Pie.

Choose the first sub-type.

Click Next.

In the Data Range, make sure your series in is Columns and that the pie chart has six slices (one for each color.)

Click Next.

In the Chart Title, type “M&Ms by Color”

On the Data Labels Tab, choose Show Label and Percent

Click Next.

For Chart Location, choose As Object in Sheet 1

Click Finish.

File, Save.

Formatting your Chart

Move your pie Chart under the tally, without covering any of the numbers.

To color-code the legend and the pie slices, double-click on the color box in the legend. This is a little tricky – you need to click on the little square, not the box around the chart legend.

When you double-click the color square, choose the color that matches the data label, so that the Red square is red and so on. This will also change the color of the pie slice in the chart, giving you a very professional-looking color-coded chart.

File, Save.

Printing your Tally and Chart

Highlight the area on your spreadsheet which shows your name, tally and chart.

(This will be a pretty large range, for example, mine was A1:H38. Yours might be larger or smaller.)

In the Menu Bar, go to File, Print Area, Set Print Area.

Check what your page will look like before you print:

In the Menu Bar, go to File, Print Preview.

If you can see your name, chart and information, click Print.

If you need to make adjustments to the print range, click Close, and go back and redo the Print Area by highlighting the information you want to print and then going to File, Print Area, Set Print Area.

Final Instructions

You may take your work and this set of instructions home with you. I would like to post some of your work on the bulletin board, so if you would like to volunteer to have your project posted, let me know before you leave today.

Excel is a very useful tool for manipulating information. I hope that you have enjoyed this project and will use experiment with Excel to see what else it can do for you!

Try the different Chart options, try graphing your grades for a semester and showing your parents before your report card comes home. You can even use Excel to help you in making an argument for increased allowance by charting your expenses in relation to your current allowance.

Excel can make working with numbers fun, so see what it can do for you!

Mrs. Moyle

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download