K5 Computer Lab Lesson Plans
HomeGr. Level Lesson Plans Poem Generators Google Classroom
Graphic Organizers
Google Classroom
Spreadsheets
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 Coding For Kids Resources

Valentine's Day Excel Lesson Plan

Students Sort Valentine Candies by Color and Create an Excel Chart

Give each student a box of conversation hearts candies. Have them sort the candy hearts by color.

 

Instructions:

1) Open Excel and create a title similar to "Valentine's Candy Chart" as shown in the illustration.

2) List the candy colors in column A.

3) List the quantities of candy by color in column B.

4) Select the the data in both columns and create a bar chart.

 

 

5) Click two times on the first bar. This will select just that individual bar for changing the fill. Right click on that selected bar and select "Format Data Point".

6) Choose Fill > Picture or texture fill. Now click the insert from File button. Choose a heart picture to fill the bar. The heart will fill the bar but it will be stretched across the whole bar.

7) Choose "stack and scale with 1 picture" to automatically fill the bar with the proper number of hearts.

Continue filling the remaining bars with the proper color and number of hearts.

 

 

Some questions for students to answer about their charts:

 

"Which colors have the most/least hearts?"

 

"How many white and green hearts are there all together?"

 

 

Completed Valentine's Day candy chart example:

Valentines Day Excel Graph Lesson Plan

 

Download these Valentine's Day hearts to use to fill the bars on the charts.

Right click on each Valentine heart and "save picture as.."

valentines day heart green Valentines Day heart green for keeps Valentines Day heart orange Valentine's Day heart orange you and me Valentines Day heart pink Valentines Day heart pink be true Valentines Day heart blue
Valentines Day heart purple xoxo Valentines Day heart purple Valentines Day heart white Valentines Day heart white Valentine's Day heart yellow tweet me Valentine's Day heart yellow Valentine's Day heart blue crazy 4 U

 

How to fill the bars with hearts:

Click twice on an excel bar. This will select only that bar for a fill. Right Click on the bar and click "format data point". Look for the small circles at the bar's corners to identify when the bar is selected.

Valentines Day Excel Lesson Plan

 

In the Format Data Point dialog box, click "Fill" and select the "Picture or texture fill" radio button. Click the "Insert from: File" button and navigate to the hearts you downloaded from above. Click the "Stack and Scale with 1 units / picture" radio button to fill the bar with the proper number of hearts.

Valentine's Day Chart fills

 

Continue filling each of the bars on the Excel chart with the matching candy heart colors.

Valentine's Day Excel Lesson

More Ideas
For PC's and Microsoft Office

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