view a plan
These “First Excel Lessons” teach students how to enter and format data to create simple bar charts
Computers & Internet, Math
5, 4, 3, 2
By – Steve Lee Ignacio
Primary Subject – Computers / Internet
Secondary Subject – Math
Grade Level – 2-5
Introduction: These lessons teach students how to enter and format data to create simple Excel charts and bar graphs.
- The first lesson teaches how to enter data and create a simple chart.
- The second lesson builds on the first lesson by requiring formatted labeling.
- The lessons serve as a quick guide, not as a detailed comprehensive Excel tutorial.
- The instructions are for Microsoft Excel 2007 version, but the data and chart can be recreated using any of the various Excel versions or even non-Microsoft variants.
- I have used this successfully with 2nd and 3rd graders, but your mileage may vary.
Make your first Excel chart.
- Type your title “Caleb’s Party Food Chart” in Cell B1, then -Enter-.
- Add the party food data in Column A.
- Add the quantities in Column B.
- Select (highlight) the food labels and number values in columns A and B.
- On the Insert menu tab select bar chart, choose 2 D bar.
- Double click the chart and then choose “chart layouts” on the ribbon. Choose a chart layout.
- Click the office button and choose Print > Print preview.
- Adjust the chart position if necessary and then -Print-.
Lesson 2 Introduction: This lesson builds on lessons learned in the first Excel chart lesson by adding the following requirements:
- Merge and Center the title. “Nicole’s Fruit Chart”
- Apply formatting to the title such as font size, color, and style.
- Enhance the chart by using “Chart Layouts” menu and labeling the title and horizontal and vertical axis.
Label an Excel chart.
- Enter your chart title in C1, then -Enter-.
- Click in cell C1 and drag mouse to H1. In the Home tab, alignment group, find and apply “Merge and Center” to the title.
- With the title still selected, on the Home tab, Font group, apply a new font color, font size and font style.
- Enter the fruit labels in column A starting with cell A3. Enter the fruit quantities in column B starting in cell B3.
- Click in cell A3 and drag mouse down to select all the foods down to cell A6. Continue to drag to select all the numerical values on column B.
- Create a bar chart. Go to Insert tab > Charts group > Bar > 2D bar.
- Format the chart. Click to select the chart. Go to Design tab > Chart layouts group > choose a chart layout that will produce a chart title and horizontal and vertical axis labels.
- Fill in the appropriate text for the Chart Title and the axis. “Nicole’s Fruit Chart, Fruits and Quantity”.
- In the Design tab > Chart Styles group, choose a style for the bars.
- Go to Print > Print preview, make adjustments to chart position as necessary. -Print-.
E-Mail Steve Lee Ignacio !