 |
How will this lesson plan prepare students to be assessed?
This lesson plan will help prepare students for assessment exams in reading
and mathematics. The spreadsheet exercise will permit students to demonstrate
their ability to respond to a mathematics challenge by organizing and calculating
mathematical information. The writing exercise will permit students to demonstrate
their ability to interpret and explain mathematical information.
Procedure:
This lesson is designed to be taught in one session, though additional classroom
sessions may be desired if the teacher wishes to introduce students to the concepts
of spreadsheets or to teach them to use spreadsheet software.
- Distribute the students version of the Jeanne Coen case
study to your class. Divide the students into groups of two or three.
- Read aloud to them or let them read one section of the case study at a time.
Dont let them read ahead. After each section, use the discussion questions
included with the teaching notes to get students to brainstorm what Jeanne should
do next.
- Finish by reviewing with students the basic concepts behind spreadsheets using
the simple spreadsheet students constructed in Part Three of the case study. Ask
students to develop at least one alternative way to organize the spreadsheet so
as to get almonds to the most customers by the deadline. Discuss how they might
do that. Then, ask them to write a short memo to the processing plant explaining
the instructions their spreadsheet contains.
Closure/Assessment:
Review students spreadsheets and memos for basic writing and presentation skills,
as well as for students ability to explain the steps Jeanne and the processing
plant must take to get almonds to the customers.
Then, in small groups or as a whole group, have students review the steps they should follow when they are confronted with a problem and have many variables to consider. Ask them to share personal experiences of having to think through different alternatives to make a decision or solve a problem. What did they do? How did they use the information they gathered? What did they do right or wrong? What would they do if they were confronted with the same problem today?
Click to continue previewing the teaching notes
on screen. |
|