Lesson+C

__**Lesson Title**__: Putting it all together __**Grade Level**__: 4 __**Related Lessons**:__ Using Excel and powerpoint __**Unit:**__ School budget

__**Content Standards:**__ Present information to acheive a particular purpose. (GPS) (4LA_A2009-15) communicate mathematical thinking coherently to peers, teachers, and others (GPS) (4MA_A2009-11) **Goals:** __**ISTE - NETS-S**__ 1. Creativity and innovation 2. Communication and Collaboration 3. Research and information fluency 4. Critical thinking, problem solving, and decision making 5. Technology operations and concepts

__**Instructional Objective**__ Students will be able to create a spreedsheet with an expense column and an income column. Students will be able to use the function key to compute sums and subtract numbers. Students will be able to come up with creative ways to cut down on expenses and show case their ideas using PowePoint or another creative way. **Action** __**Before class preparation:**__ Teacher will reserve the computer lab.

__**During Class**__ 8:30 - 9:00 Students will create 2 columns. (Expense and Income) Students will use the local school budget sheet and determine which items belong in each column. 9:00 - 9:10 Students will add up each column to get a final total. 9:10 - 9:20 Students will subtract th expense column from the income column. 9:20 - 10:30 students will determine how they can decrease 5 items on the expense column a explain their rational on a Powerpoint. Example: Teacher will say,students, the school is spending $624.00 on damaged library books. What can students, parents, teachers, administration do to minimize this expense? Teacher will give the example that the student councel can conduct a presentation on how to keep library books protected from liquids, and the cost associated with damaged books. The Powerpoint will contain pictures, and words.
 * Time**

10:30 - 11:45 Students will practice giving their presentations before presenting it to the board members (board members will be the class and the teacher) 11:45- 12:30 Students will present their presentations __**Technology used**__ -computer -Microsoft Excel -Microsoft Powerpoint

__**Monitor**__ Teacher will monitor that students are on task, answer questions, and facilitate thinking by asking questions to the students as they conduct their project.

__**Ongoing Assessment:**__ __**Accomodations and Extensions:**__ Instead of using Powerpoint students can draw pictures on poster board instead of using PowerPoint. The parapro will be available to help guide students.

__**Back-up Plan;**__ If labs are not available, students can work in the classroom. __**Evaluation**__ Teacher and board members will hold a vote to determine if the reasons on how to decrease expenses are reasonable. __**Lesson Reflections and Notes:**__ Teacher will reflect on the lesson to see what changes can be made next time to insure that the unit runs smoothly.