Richard+Orr

 ﻿ Unit Plan for Walden course 6713

Technology Integration for Meaningful Classroom Use


 * < **__Daily Lesson GAME Plan __**  ||
 * < **__Lesson Title __**: Can I buy This Item? ||< **__Related Lessons __**: Solving Equations, Percents,  ||
 * < **__Grade Level __**: High School ||< **__Unit __**: Calculating Interest Rates  ||

· Examine statements and decisions involving risk; e.g., insurance rates and medical decisions. · Define function formally and with f( //x //) notation. · Solve equations and formulas for a specified variable; e.g., express the base of a triangle in terms of the area and height. || · Critical thinking, problem solving, and decision making · <span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Creativity and Innovation ||
 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">GOALS __** ||
 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Content Standards __**<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">:
 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">ISTE NETS-S: __**

· <span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Reserve the computer lab so students can work on Excel and research for the project · <span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Create a list of restrictions and stipulations that the students must follow ||
 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">ACTION __** ||
 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Before-Class Preparation: __**


 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">During Class __** ||
 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Time __**

<span style="display: block; font-family: 'Times New Roman','serif'; font-size: 12pt; text-align: center;">5 minutes

<span style="display: block; font-family: 'Times New Roman','serif'; font-size: 12pt; text-align: center;">5 minutes

<span style="display: block; font-family: 'Times New Roman','serif'; font-size: 12pt; text-align: center;">20 minutes

<span style="display: block; font-family: 'Times New Roman','serif'; font-size: 12pt; text-align: center;">10 minutes ||  **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Instructional Activities __**

<span style="font-family: 'Times New Roman','serif'; font-size: 12pt; line-height: normal; margin: 0in 0in 0pt;">Students will find the average yearly earnings for the occupation that they are considering, and using Excel find out how much money that they will make a week.

<span style="font-family: 'Times New Roman','serif'; font-size: 12pt; line-height: normal; margin: 0in 0in 0pt;">Students will find a large item that they would like to purchase such as a house or a car to see if they can afford to purchases the item and the strain that it could cause them financially.

<span style="font-family: 'Times New Roman','serif'; font-size: 12pt; line-height: normal; margin: 0in 0in 0pt;">Using Excel the students will calculate how long they would have to pay till the object was paid off fully and how much they could pay given other financial obligations.

<span style="font-family: 'Times New Roman','serif'; font-size: 12pt; line-height: normal; margin: 0in 0in 0pt;">Students will write the equations that they used to find their calculations and a short summary of their findings along with a print out of the Excel sheets with their work. || **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Materials and Resources __** <span style="display: block; font-family: 'Times New Roman','serif'; font-size: 12pt; text-align: center;">Computer, Excel

<span style="display: block; font-family: 'Times New Roman','serif'; font-size: 12pt; text-align: center;">Computer

<span style="display: block; font-family: 'Times New Roman','serif'; font-size: 12pt; text-align: center;">Excel program

<span style="display: block; font-family: 'Times New Roman','serif'; font-size: 12pt; text-align: center;">Word program ||


 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">MONITOR __** ||
 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Accommodations: __**

<span style="font-family: 'Times New Roman','serif'; font-size: 12pt; line-height: normal; margin: 0in 0in 0pt;">Follow the students IEP’s allowing for any modifications that are needed.

**__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Extensions: __**

<span style="font-family: 'Times New Roman','serif'; font-size: 12pt; line-height: normal; margin: 0in 0in 0pt;">To finish the assignment the students will make a small one to two minute presentation the following day to see if they could have their dream house or the dream car. They will need to create a PowerPoint presentation to show to the class that has two slides, one slide will be of the item that they are buying and the other slide will be the Excel sheet that shows their data.

**__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Back-Up plan: __**

<span style="font-family: 'Times New Roman','serif'; font-size: 12pt; line-height: normal; margin: 0in 0in 0pt;">If the computers cannot be used the students will be given three options for things they can buy and three different salaries to choose from, they will have to do all the calculations by hand with paper, pencil and a calculator. ||


 * ~ EVALUATION ||
 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Lesson Reflection: __**

<span style="font-family: 'Times New Roman','serif'; font-size: 12pt; line-height: normal; margin: 0in 0in 0pt;">Ask students the importance of knowing how do calculate interest and how they will be able to use this information when making decisions with their money. Also have the students give an example how this can benefit them now with limited resources available to them and they want to purchase an item. || **<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Technology Integration for Meaningful Classroom Use ** <span style="display: block; font-family: 'Times New Roman','serif'; font-size: 12pt; text-align: center;">Unit Plan Assignment: Online Collaboration Lesson
 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Daily Lesson GAME Plan __** ||
 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Lesson Title __**<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">: Curfew for Students? || **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Related Lessons __**<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">: Creating Tables and Charts  ||
 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Grade Level __**<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">: High School || **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Unit __**<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">: Survey Bias  ||


 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">GOALS __** ||
 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Content Standards __**<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">:

· <span style="font-family: 'Palatino-Roman','serif'; font-size: 12.5pt;">Design and perform a statistical experiment, simulation or study; collect and interpret data; and use descriptive statistics to communicate and support predictions and conclusions.

· <span style="font-family: 'Palatino-Roman','serif'; font-size: 12.5pt;">Evaluate the validity of claims and predictions that are based on data by examining the appropriateness of the data collection and analysis. ||
 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">ISTE NETS-S: __**

· <span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Critical thinking, problem solving, and decision making

· <span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Creativity and Innovation ||


 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">ACTION __** ||
 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Before-Class Preparation: __**

· <span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Reserve the computer lab so students can work on Excel and research for the project

· <span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Create a list of questions that need to be asked.

· <span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Have students make predictions of the outcomes of the survey.

· <span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Break the students into four groups; the groups will each be given a grade level.

· <span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Ask the English teachers to allow for students to fill out the survey in their respected classes. ||


 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">During Class __** ||
 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Time __**

<span style="display: block; font-family: 'Times New Roman','serif'; font-size: 12pt; text-align: center;">15 minutes

<span style="display: block; font-family: 'Times New Roman','serif'; font-size: 12pt; text-align: center;">15 minutes

40minutes

<span style="display: block; font-family: 'Times New Roman','serif'; font-size: 12pt; text-align: center;">20 minutes

15 minutes

<span style="display: block; font-family: 'Times New Roman','serif'; font-size: 12pt; text-align: center;">30 minutes 20 minutes || **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Instructional Activities __** **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Day One __** <span style="font-family: 'Times New Roman','serif'; font-size: 12pt; line-height: normal; margin: 0in 0in 0pt;">Students will create an e-mail that has the link to the class’s blog where students can summit their answers. Email will include an explanation of what the student needs to do.

<span style="font-family: 'Times New Roman','serif'; font-size: 12pt; line-height: normal; margin: 0in 0in 0pt;">Students will create an Excel spreadsheet that will be used to collect the data

**__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Day Two __** <span style="font-family: 'Times New Roman','serif'; font-size: 12pt; line-height: normal; margin: 0in 0in 0pt;">Students will enter data into the Excel spreadsheet. The students will create graphs that will represent the data they have collected.

**__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Day Three __** <span style="font-family: 'Times New Roman','serif'; font-size: 12pt; line-height: normal; margin: 0in 0in 0pt;">Students will create a combined product that includes all the grade levels.

<span style="font-family: 'Times New Roman','serif'; font-size: 12pt; line-height: normal; margin: 0in 0in 0pt;">Students will then posted their findings on the blog and send another Email to the students that completed the survey and ask for them to post comments on the findings.

**__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Day Four __** <span style="font-family: 'Times New Roman','serif'; font-size: 12pt; line-height: normal; margin: 0in 0in 0pt;">Respond to the students that posted comments on the blog.

<span style="font-family: 'Times New Roman','serif'; font-size: 12pt; line-height: normal; margin: 0in 0in 0pt;">Discuss as a class how the information that was found could be bias and how we could change our method to find more accurate information. || **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Materials and Resources __**

<span style="display: block; font-family: 'Times New Roman','serif'; font-size: 12pt; text-align: center;">Computer Computer, Excel

<span style="display: block; font-family: 'Times New Roman','serif'; font-size: 12pt; text-align: center;">Excel program

<span style="display: block; font-family: 'Times New Roman','serif'; font-size: 12pt; text-align: center;">Word program

<span style="display: block; font-family: 'Times New Roman','serif'; font-size: 12pt; text-align: center;">Computer

<span style="display: block; font-family: 'Times New Roman','serif'; font-size: 12pt; text-align: center;">Computer ||
 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">MONITOR __** ||
 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Accommodations: __**

<span style="font-family: 'Times New Roman','serif'; font-size: 12pt; line-height: normal; margin: 0in 0in 0pt;">Follow the students IEP’s allowing for any modifications that are needed.

**__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Extensions: __**

<span style="font-family: 'Times New Roman','serif'; font-size: 12pt; line-height: normal; margin: 0in 0in 0pt;">Have the students send out another Email to the teachers and student body asking them to come up with a survey question that they would like to be asked. Also contact another math teacher that would possible be will to participate with my and combine the information from both schools. <span style="font-family: 'Times New Roman','serif'; font-size: 12pt; line-height: normal; margin: 0in 0in 0pt;">Included in the email, tell the students body that the blog is also available for helping students with math. Trying to keep the students communicating with each other and helping each other with math problems.

**__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Back-Up plan: __**

<span style="font-family: 'Times New Roman','serif'; font-size: 12pt; line-height: normal; margin: 0in 0in 0pt;">Have the students perform the survey doing noon hour. Then use Excel to calculate the finding of the survey. ||


 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">EVALUATION __** ||
 * **__<span style="font-family: 'Times New Roman','serif'; font-size: 12pt;">Lesson Reflection: __**

<span style="font-family: 'Times New Roman','serif'; font-size: 12pt; line-height: normal; margin: 0in 0in 0pt;">Ask students the importance of knowing how do examine a survey and to see how the information could be bias. Students will also be able to construct better plans to collect data. ||