Basic Excel Page

Objectives

Students will

• • input data into spreadsheet cells.

  • understand basic spreadsheet terminology such as: cell, column, row.

Keywords

spreadsheet, data collection, data analysis, survey, fat food

Materials Needed

• • computer access

  • Tasty Tech Activity template (provided), or have students make their own.

  • Microsoft Excel (Note: With a few modifications, AppleWorks, Quattro, or other software programs also can be used.)

Lesson Plan

Do your students need basic spreadsheet skills, but you aren't an expert with Excel? Never fear! This lesson plans breaks down the basic skills of inputting data and adding graphs so even users with the most basic skills can quickly gain confidence and competence with Excel. The lesson is best taught as a whole class in a lab, cart, or one-to-one setting, but can be modified for a classroom center of one to four computers.

Begin by explaining to students that they will learn how to create colorful graphs by adding data to a computer program called Excel. Have each student watch you as you open the TastyTech template. Demonstrate to students the following three steps:

• 1. Click cell A2, where the words "Teacher's Name" are and type your name instead. Explain that the box around your name is called a cell, and that the cell you used is called A2 because it's in column A, row 2.

  2. Ask students to name three of their favorite fast food items, such as a burger, milkshake, chicken nuggets, and so on from a specific restaurant. Highlight the words "Fast Food Item #1," "Fast Food Item #2," and "Fast Food Item #3." Type instead the names of the foods they choose.

  3. Explain to students that you are going to rate the food 3, 2, or 1. A "3" means they love it; "2" means it's okay; and "1" means it's yukky! Demonstrate by putting scores in cells B2, C2, and D2 for each of the food items. (You should have a 3, 2, or 1 in each of those cells.)

Have students open the TastyTech 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 food. The rest of the class then types each student's name and score for each food 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

• 1. For Step One: Make sure "Column" is selected under Chart type, and then click Next.

  2. For Step Two: Click Next.

  3. For Step Three:

     1. • Under Chart Title, type "Student Name Fast Food Chart" (Replace Student Name with real students' names.)

        • Under category (X) axis, type "Names."

        • Under Value (Y) axis, type "Our Evaluations."

        • Click Next.

  4. For Step Four: Click "As New Sheet" and then click Finish.

Each student now should see a graph of the fast food survey results. Students can print the graphs for class work credit.

Assessment

Students will be assessed on

• • The data input into the spreadsheet cells.

  • Their ability to follow directions based upon classroom observation and printed work.

  • The accuracy of the printed graph.

The instructions are for Microsoft Excel, but the data and chart can be recreated using any suitable spreadsheet application.

Teachers poll students with a show of hands of their favorite ice cream flavor.

Teacher takes a tally using the tally sheet provided and projects it for students to view, or writes the tallies and results on the whiteboard.

Students use the tally results with a spreadsheet program to create a column chart illustrating the results of their classmates' favorite ice cream flavors.

Download: what-is-your-favorite-ice-cream-flavor-tally-sheet.pdf

Download: rubric-for-spreadsheet-with-chart.pdf

Download: excel-what-is-your-favorite-ice-cream-flavor-chart.xlsx

Excel Party Supplies List

Students can use this list to choose items for their spreadsheet. Students are having a party and have invited several classmates, family members and friends.

Students choose at least 6 different foods, drinks, and party gifts that they think their friends will enjoy.

Students create a simple spreadsheet and chart using their chosen items.

Download: excel-party-supplies-list.pdf

Excel Tutorial:

Use this mini excel tutorial to guide your students in entering the data and creating the chart.

Excel Vocabulary Words: Spreadsheets, Cells, Rows, Columns, Labels, Values.

Instructions:

• 1. Type your title "Caleb's Party Food Chart" in Cell B1, then Enter.

  2. Add the party food data in Column A cells.

  3. Add the quantities in Column B cells.

  4. Select (highlight) the food labels and number values in columns A and B.

  5. On the Insert menu tab select bar chart, choose 2 D bar.

  6. Double click the chart and then choose "chart layouts" on the ribbon. Choose a chart layout.

  7. Adjust the chart position if necessary and then Print.

Excel Tutorial Your First Chart - Printable Instructions:

Download: excel-tutorial-your-first-chart-instructions.pdf