LEARN NC

K–12 teaching and learning · from the UNC School of Education

Learn more

Related pages

  • The Alphabet Tree: After reading The Alphabet Tree by Leo Lionni to students, the students will retell the events on a flow map. Then using Kid Pix software, each child will choose an event, illustrate it, and write a caption for it. The students will then put their events in order in a Kid Pix Slide Show they can present to the class.
  • Word-processing valentines: This lesson combines the need to practice keyboarding skills, completion of rhymes, a popular children's book, and the motivational aspects of the Valentine holiday.
  • Phonics fun: Kid Pix Deluxe software is needed for this lesson. Using this program, students will decode and blend one-syllable short-vowel words and words ending with silent "e" to match pictures with words as well as to spell names of pictures.

Related topics

Help

Please read our disclaimer for lesson plans.

Legal

The text of this page is copyright ©2008. See terms of use. Images and other media may be licensed separately; see captions for more information and read the fine print.

Learning outcomes

Students will use a spreadsheet to organize compound words they find in the book Cloudy With a Chance of Meatballs. After entering the data, they will sort the columns by alphabatizing the words. As a fun ending activity, they will re-sort, using only one column of words, thus creating “new” compound words. Students will write a sentence with their new compound word.

Teacher planning

Time required for lesson

40 minutes

Materials/resources

Cloudy With a Chance of Meatballs by Judi Barrett

Technology resources

  • Spreadsheet program - such as Microsoft Excel or Microsoft Works (Works 4.0 is used in the example)
  • Printer

Pre-activities

The teacher will read the book Cloudy With a Chance of Meatballs. Students will compile a list of 10 compound words from the story. There are over 15 compound words throughout the story. The teacher will decide the best way for students to compile the list. For example, the story could be read aloud again and students could write down the compound words as they hear them, or the students could make a class list as the teacher rereads the story. Also, the book(s) could be made available to the students who would be responsible for reading it and recording the words during appropriate work times. Several days may be needed to allow for this option.

Activities

Part I

  1. Students would bring their lists of compound words to a computer lab where each student should have access to a computer and a spreadsheet program.
  2. If the teacher has not already introduced the parts of a spreadsheet, s/he would do so before entering any data. Make sure that ‘row’, ‘column’, ‘cell’, and ‘entry bar’ have been defined.
  3. Students will enter data into two columns. For this exercise, they will not have a column heading.
  4. Each cell in one row will have part of a compound word. Example: ‘meat’ and ‘balls’ for ‘meatballs’. Go down to the next row for the next word.
  5. Students should save no later than after having entered the fifth word. Encourage them to save early and to save often.
  6. Once all 10 compound words have been entered, save again.
  7. Students will select all the cells (both columns) and sort them in ascending order (alphabetically).
  8. Save

Part II

Just for fun, students will now create ‘new’ compound words by mixing up the order of the word parts.

  1. Select all the words in only one column and sort them in descending order. This will create ‘new’ and silly compound words.
  2. Students should then choose one ‘new’ compound word and type a sentence using the new word. Encourage them to be creative and have fun. In Microsoft Works 4.0 (spreadsheet), students can type a sentence using the Text Tool in the Tool Palette.
  3. Save
  4. Students should made sure their name is on their document. Print.

See Attachment below for an example of how the spreadsheet would look after they have been sorted and ‘new’ compound words have been created.

Extension

  • Students could write a ’sister story’ to Cloudy With a Chance of Meatballs using their new silly compound words.
  • Or, students could illustrate their new compound word in a drawing program such as Kid Pix.

Assessment

  • As students enter their compound words, the teacher(s) circulates and observes that the students understand how compound words are formed by noting that they are divided correctly into the two columns on the spreadsheet. Individual assistance is given if needed.
  • The printed copy of the spreadsheet will be evidence of the student’s ability to separate the word parts in a compound word.

Supplemental information

Comments

This lesson was designed to be an extension to a unit on weather where Cloudy With a Chance of Meatballs is used to introduce the unit. This language arts extension for compound words is good practice (or a starting point) for students to enter data into a spreadsheet. After this exercise, they are ready to enter data into a spreadsheet and then create a graph. Maybe they’ll collect temperature data and graph its changes!

North Carolina curriculum alignment

Computer Technology Skills (2005)

Grade 2

  • Goal 1: The learner will understand important issues of a technology-based society and will exhibit ethical behavior in the use of computer and other technologies.
    • Objective 1.08: Identify and discuss spreadsheet terms/concepts (e.g., sort, classify, line graphs). Strand - Spreadsheet
  • Goal 2: The learner will demonstrate knowledge and skills in the use of computer and other technologies.
    • Objective 2.03: Enter/edit data in a prepared spreadsheet as a class/group and observe the changes that occur to make predictions. Strand - Spreadsheet
    • Objective 2.04: Use spreadsheet software in content areas to enter, display, and identify sources of data as a class. Strand - Spreadsheet

English Language Arts (2004)

Grade 2

  • Goal 1: The learner will develop and apply enabling strategies and skills to read and write.
    • Objective 1.01: Use phonics knowledge and structural analysis (e.g., knowledge of syllables, suffixes, prefixes, root words) to decode regular multi-syllable words when reading text.

  • Common Core State Standards
    • English Language Arts (2010)
      • Reading: Foundational Skills

        • Grade 2
          • 2.RFS.3 Know and apply grade-level phonics and word analysis skills in decoding words. 2.RFS.3.1 Distinguish long and short vowels when reading regularly spelled one-syllable words. 2.RFS.3.2 Know spelling-sound correspondences for additional common vowel...

  • North Carolina Essential Standards
    • Information and Technology Skills (2010)
      • Grade 2

        • 2.TT.1 Use technology tools and skills to reinforce classroom concepts and activities. 2.TT.1.1 Use a variety of technology tools to gather data and information (e.g., Web-based resources, e-books, online communication tools, etc.). 2.TT.1.2 Use a variety...