Grade Level (s): K or 1
Subjects: English/Language Arts, Mathematics
Learner Outcomes: The learner will be able to match words and pictures by using various forms of sorting. The learner will also, with help, transfer the sorting to a pictograph using Microsoft Excel.
Duration of Lesson: 1 hour
Materials: Examples of environmental print, overhead projector, transparencies with examples of environmental print, internet, computer, printer, Microsoft Excel program
Technology Tools/Courseware: Overhead projector, internet, printer, computer, Microsoft Excel program
Teacher Notes: Since the print that each child can "read" depends on his/ her environment and experiences, the print used in the lesson should be made into transparencies and reviewed on an overhead projector so everyone has a fair chance in the sorting game.
Procedures:
1. Review what environmental print is. Discuss
examples of print as referred to in Lesson 1(procedure
#2).
2. Review examples of environmental print that you have prepared onto transparencies for this activity. Good places to find your own examples of environmental print include the internet, newspapers, and your own cupboard.
3. Discuss some things that all of these have in common (in order to prepare for the sorting activity soon to follow). Prompt the children to come up with their own ideas. Some possibilities include: kinds of food, restaurants, beginning letter, ending letter, medial vowel sounds (for more advanced students), logos, syllables.
4. Make a list of the possibilities on the board and divide students into groups depending on class size and ability. Assign each group a way to sort the examples of print that you have given them.
5. Have students present their print and how they sorted them.
6. Group by group, I guide the students through the Microsoft Excel program, helping them display their work in chart form.
Modifications: If applicable, the teacher will need to develop any modifications found necessary by a Individualized Education Plan.
Enrichment Activities: Without using groups, students individually sort examples of print.
Evaluation/Assessment: Observation of groups, print out of graph, use this rubric
West Virginia Content Standards:
RLA.1.1.6 Understand
level appropriate sight words and vocabulary.
RLA.1.1.16 Use
reading skills and strategies to understand a variety of informational resources
to support literacy learning ( e.g., environmental print; written directions;
signs; caption; labels; informational books).
.
MA.1.2.1 Sort
and classify objects by more than one attribute.
MA.1.5.1 Identify
and investigate various forms of data collection.
MA.1.5.2 Read
and interpret a pictograph with each picture representing a single unit.
MA.1.5.5 Tally
by one's, organize the data in a chart / table, and construct a bar graph;
read and interpret tally chart and tables.
MA.1.5.6 Analyze
data represented on a graph using grade level appropriate questions.
SC.1.2.4 Collect, record, and compare information using a variety of classification systems and using a variety of communication techniques.
TEC.1.1.1 Use
a keyboard to input information using letters, numbers, arrow key and delete
key: begin to use left/right hand position.
TEC.1.1.2 Use
a mouse to click and drag.
TEC.1.1.3 Start
and exit programs as well as locate files.
TEC. 1.3.2 Create
text and insert images.
National Standards:
1. Use input devices and output devices
to successfully operate computers and other technologies.
2. Use variety of media and technology resources
for directed and independent learning activities.
3. Communicate about technology using developmentally
appropriate and accurate terminology.
4. Use developmentally appropriate multi-media
resources to support learning.
5. Work cooperatively and collaboratively
with peers, family members, and others when using technology in the classroom.
Job/Career Clusters: N/A
Additional References:
http://www.usd.edu/trio/tut/excel/
Authors:
Liza Jonczak
Pam Chambers
Stephanie Unger
Shepherdstown Elementary
| Overview | Lesson 1 | Lesson 2 | Lesson 3 | Lesson 4 | Lesson 5 |