Home Gr. Level Lesson Plans Poem Generators iPad Classroom Tech Integration iPad - Mac
Graphic Organizers
Excel Word Word - Graphic Organizers PowerPoint MultiMedia Internet Research Apple Mac Keynote Apple Mac Pages Apple Mac Numbers Apple Mac Multimedia Tech Coordinator Tutorials Video Reversal Video Tutorials Resources
About Me:
Steve Ignacio
My name is Steve Ignacio. Technology director and instructor since 2004.
M.A. Educational Technology

Excel Lesson Plan- Make Your First Chart

This Excel Lesson Plan Teaches Beginning Excel Users to Enter Data and Create a Simple Chart.

The instructions are for Microsoft Excel 2007 - 2013 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.

When printing the excel chart, be sure to have the students use print preview to check the proper positioning of the chart and data on a single page before printing.

Grades 2+

 

 

 

How to Create Your First Chart - Video Tutorial = 25 Seconds:

 

 

Finished Excel Chart:

Excel First Chart - Party Supplies

 

 

 

 

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 Party Supplies List

 

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

 

 

Excel Tutorial - Your First Chart Instructions

 

 

Excel Spreadsheet Rubric for Grading Assignments:

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

 

 

Spreadsheet Rubric

 

Popular for iPads - iWork

For PC's and Microsoft Office

Excel Bar Chart Excel Halloween
Costume Chart
Green Screen
Photo Edting
Computer Lab Rules
Excel Bar Chart Excel Halloween Costume Chart Green Screen Photo Editing Computer Lab Rules Essentials
California Regions
Brochure
Amazing Animals
PowerPoint
I am Poem Generator "Floater" Animation
California Regions Brochure Amazing Animals I Am Poem Generator I Can Float Animation
Learn PowerPoint
in One Minute
Copy and Paste
Practice
M&M Chart Newspaper Template
Learn PowerPoint in One Minute Copy and Paste Practice Excel Pie Chart Newspaper Template

 

Related Content:

Excel Bar Chart

Excel M & M Chart

Excel Expense Chart

Excel Shopping Budget

Excel Lemonade Stand

Excel Line Chart

Excel Valentine's Day Chart