Lesson_plan

Lesson plan page

** Health & Technology Lesson Plan **
Campus: || State Standards [] |||| Subject Specific: Health
 * Title of Lesson: Spreadsheets For Dinner ||  Date:5/28/10Timeframe of Lesson: 90 minutes  ||
 * Author(s): Casey DeGrand & Laurie Myers ||  School District: Green Bay Area Public Schools
 * Subject Area(s): Health and Technology ||  Grade Level(s)/Course: 4th grade/Health  ||

Health
 * A.4.1 ** Identify positive mental, emotional, social, and physical factors that influence
 * A.4.3 ** Identify ways to be healthy during childhood

//Technology Specific:// [] **A.4.3** Use a computer and productivity software to organize and create information - identify spreadsheet terms: row, column, and cell - resize the cells, insert data, and add the data in the columns - be able to integrate technology into other curriculum areas || 1. Students will have a forty minute introduction to spreadsheets in the computer lab.Rows, columns, and cells will be introduced.Students will be shown how to resize the cells and add columns.For practice, students will be given row heights, column widths, and a list of numbers to insert and add.
 * A.4.4** Use a computer and communications software to access and transmit information ||
 * Stated Objective(s) |||| Students will:
 * Procedures for Lesson ||||  Day 1:

Day 2: 1. Together, teacher and students will visit nutrition websites to determine the effect fats, carbohydrates, cholesterol, sodium, and proteins have on your body (see “Learn More” section in the sidebar). The class will discuss that fats should be moderate and cholesterol should be avoided. 2. Students will be given the task of planning a dinner menu. They will be provided with nutritional guidelines such as how much protein their dinner must have and what their cholesterol limit should be. The teacher will model on the board the sort of information the students will be required to look for and what they will have to write down. 3. In groups, students will be given a menu planner, []and nutritional labels from several types of foods. The groups will have to plan a dinner that will stay within the nutritional guidelines they have been given. 4. When they are finished planning their meal, students will go to the computer and create a spreadsheet that has columns for food, protein, carbohydrate, fat, cholesterol, sodium, and a row for the totals. Students will add up the columns to show that they stayed within the guidelines.

** For students who may have trouble creating a spreadsheet from scratch, you can use the nutrition sample ** [] || - Students will find the information on a school lunch and enter the information on their spreadsheets to see if a school lunch is within the guidelines. || - Computer lab or classroom computers (one per student) - Internet access - Nutritional labels from several types of food - Menu planning sheet []  - Nutrition sample sheet []  - Pencils - Access to printer from each computer ||
 * Assessment or Evaluation ||||  Completed and printed spreadsheets in which the student has stayed within the nutritional guidelines.  ||
 * Enrichment ||||  - Students will plan two days worth of meals (breakfast, lunch & dinner) with the Menu Planner and will enter the data into spreadsheets.They will share their two day menus and spreadsheet information with the class.
 * Materials |||| - Spreadsheet program such as AppleWorks, ClarisWorks, or Microsoft Excel
 * |||| __ Technology Resources __ : // URLs, Software, # of Computers, Printers, etc… //

__ Other Resources __ : // Book Titles, Art Supplies, Manipulatives, etc…. // ||