Favorite Colors

After collecting all of the information the students will create an excel document with all of their information on it.

Day 1:

Divide the students into groups of four, have them sit together in these groups. Give them a copy of " Our Favorite Colors color chart."  As a group have them collect the information and enter it into the chart. Make sure that all of their names are on the chart, and collect the charts at the end.

Day 2:

Take the students to the computer lab, they will be working together in their groups of four. Each group gets one computer.

Have the students open up Excel on their computers. They will be recreating the chart that they have filled out. Make sure that they all take turns typing.

Step 1:

Start on square 2B, fill in the color names ex: red, then click on 2C and fill in orange. Repeat this until all the colors are entered into the chart. Them have them add on "totals" in the last square, 2H.

Step 2:

Highlight squares 1A through 1H, once these squares are highlighted have the students click on the button at the top of the screen that looks like a "square with an a" in it, this will merge the cells.  Then they can title their cells "Our Favorite Colors".

Step 3:

Go to square 3A and fill in their name where it say "Yours" on their paper graph, then down to square 4A and fill in another group members name where it says "Friend 1", keep doing this until all four friends are entered in. In square 7A have the students enter in "Totals."

Step 4:

Have the students highlight the entire graph and then have them click on the "borders" button at the top of the screen, it looks like a square with little squares in it. Have them select the border that has all the solid lines.

Step 5:

Have students go to square 3B and enter in their information, have them continue doing this for all their information, all of row 3. Have each student enter in their own information in their row (4,5,and 6).

Have students save their information on their disk. Take students back to class.

Day 3:

Take students back to the computer lab, have them get back into their groups and find a computer. Make sure they have their disks.

Step 1:

Have student open their charts and highlight square 3H, then have them go up to the insert button and click on the "function" icon, have them choose the first function "SUM", they want to get the sum of their numbers. Make sure that they click that they want to collect the info across, not down. Once they click "ok" the sum of their numbers will be in the "Totals" square. Have the students do this for every row.

Step 2:

After students have completed that have them click on and highlight 7B they are then going to do the same thing as before, they need to go up to the top and hit"insert" and then "function" this time make sure that they have it tally down instead of across, clicking the "SUM" button.  Once again have them make sure that the right cells are highlighted and then click "ok". At this point all of their totals are tallied and they can make a chart.

Step 3:

Have the students click on "insert" and then down on the "chart" function. Their chart type needs to be column, and their chart sub-type will be "clustered column with a 3-D visual effect." Once that is highlighted have the students click on the "next" button at the bottom of that page. They will get to view how the graph will look and click "next" again. Then they will have to label their graph. An example of the labels would be; title- Our Favorite Colors, X axis- Colors, Z axis- number of people. After filling this in they need to click on the "next" button. Have the students click the second choice positioning their graph in as an object in their table. Click "finish" and then have the students stretch their graph so that all of the color names are seen. Have them print them off and take the students and their graphs back to class.

Once in class have each group present their graph and talk about all the different colors that everyone likes and why our graphs look so different.