Creating a
Spreadsheet and Graph
What is a spreadsheet?
A spreadsheet is a document which helps you organize data in rows and columns of cells. Each cell can contain words, a number, or a formula. A formula does calculations with the numbers in other cells. You can make charts and graphs automatically.
Objectives:
Students will be able to:
input data into spreadsheet cells.
understand basic spreadsheet terminology such as: cell, column, row.
Time Required:
1 to 2 days
Vocabulary:
spreadsheet, cell, column, row, survey, data, data collection, graph, chart, x axis, y axis
Materials:
Microsoft Excel
Computer access
Procedures:
Have students open the Yummy
Jellybean template on their own computers (Be sure to put the file on
students' computers beforehand, or show them how to access it on the
school's network if that's an option). Call on each student individually,
and have students call out their evaluations (3, 2, or 1) for each flavor.
The rest of the class then types each student's name and score for each
flavor on their own worksheets. Walk around to make sure students are
putting the information in the correct cells and that no student is behind.
When the spreadsheets are complete, have students save and print their work. Next, walk students through the four easy steps of creating a graph of their work. Have them click Insert > Chart at the top of the screen and then:
Each student now should see a graph of the Yummy Jellybean survey results. Students can print the graphs for class work credit
Evaluation:
Students will be assessed on
Extension Activities:
Have students name three of their favorite fast food items, such as a burger, milkshake, chicken nuggets, and so on from a specific restaurant. Explain to students that they are going to survey 10 friends/family members to rate the food 3,2, or 1. A "3" means they love it; "2" means it's okay; and "1" means it's yucky!
Students are to follow the same procedures as demonstrated in class. They will print their spreadsheet and graph to share with the class.
Home Learning:
Survey classmates to find out how many hours of homework they do each night. At home use Excel to display the results as bar graph or pie chart.