K5 Computer Lab Lesson Plans

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.



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

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

    Computer Lab Rules Essentials
  • California Regions

    California Regions Brochure
  • Amazing Animals

    Amazing Animals
  • I Am
    Poem Generator

    I Am Poem Generator
  • "Floater"

    I Can Float Animation
  • Copy and Paste

    Copy and Paste Practice
  • Learn PowerPoint
    in One Minute

    Learn PowerPoint in One Minute
  • M & M
    Excel Chart

    Excel Pie Chart
  • Newspaper

    Newspaper Template