Data+Lesson+Plan

** Resources:  ** · [] - I will retrieve the information from the Philadelphia Zoo website, and will then upload the animals in the zoo onto an excel spreadsheet as a list. This will become the first sheet in the students excel document. · Microsoft Excel · Instruction sheet that I’ve created to help them with this assignment.  1. Now that you have opened Sheet 1 (the animal list) click on Sheet 2, which is at the bottom of the page.  2. Type Mammals at the top of Column B.    3. Type Amphibians at the top of Column C.    4. Type Reptiles at the top of Column D.    5. Type Birds at the top of Column E.    6. Type Primates at the top of Column F.     **Primates are mammals, but for this assignment put them into a different category than mammals.  7. Begin sorting the animals from the list into the different categories. Under the correct heading Copy and Paste the animals name from Sheet 1 to Sheet 2.  8. Once you have finished sorting all of the animals, you now have to count the animals in each category, but the computer is going to count it for you!  9. In the column that is empty, type the word TOTALS in the cell that is A27.  10. At the end of the list of mammals, type =COUNTA(     11. Now go up to the top of your page, and beginning with the first animal name in the mammal column left click and drag down until you reached the last name in the list. ***If your group did this correct, there should be a box around the words that you dragged your mouse over. Now close the parenthesis.      12. Do steps 10 and 11 for each animal category.      **Remember when you drag down your mouse, only include the animals in the list not the words Amphibians, Reptiles, Birds, and Primates.     13. The last part is putting all the data you’ve just sorted into a table.  14. Click on Sheet 3 on the bottom of the page.  15. At the top of the page in column A type Animal Class.  16. Under that type Mammals. Under that type Amphibians. Under that type Reptiles. Under that type Birds. Under that type Primates. <span style="margin: 0in 0in 0pt 1.25in; mso-add-space: auto; mso-list: l2 level1 lfo3; text-indent: -0.25in;"> 17. At the top of column B type Total Number. By clicking on sheet 2 at the bottom of the page, go back to see what your group got as the totals for each animal class. Type those totals next to the animal class that it goes with. An example would be next to Mammals type 25 and next to Amphibians type 9. <span style="margin: 0in 0in 0pt 1.25in; mso-add-space: auto; mso-list: l2 level1 lfo3; text-indent: -0.25in;"> 18. By left clicking the mouse and dragging, highlight all of the words ** except ** for Animal Class and Total Number. <span style="margin: 0in 0in 0pt 1.25in; mso-add-space: auto; mso-list: l2 level1 lfo3; text-indent: -0.25in;"> 19. Click the Insert Tab at the top of the page and find where it says Bar. Click on Bar. <span style="margin: 0in 0in 0pt 1.25in; mso-add-space: auto; mso-list: l2 level1 lfo3; text-indent: -0.25in;"> 20. Now click on the first choice that you see. <span style="margin: 0in 0in 0pt 1.25in; mso-add-space: auto; mso-list: l2 level1 lfo3; text-indent: -0.25in;"> 21. Your group now put your data into a graph. <span style="margin: 0in 0in 0pt 1.25in; mso-add-space: auto; mso-list: l2 level1 lfo3; text-indent: -0.25in;"> 22. Choose a Title for your graph. Click anywhere on your graph and at the top of your page look for the tab that says Layout. Click Layout and look for the words Chart Title. Click Chart Title and choose where you want your title to be. Type the name of your graph and click enter. <span style="margin: 0in 0in 10pt 1.25in; mso-add-space: auto; mso-list: l2 level1 lfo3; text-indent: -0.25in;"> 23. Raise your hand so that I can come over and see what you and your group has created. **  Procedure:   ** 1. Group students into groups of 4. 2. Have students upload the Philadelphia Zoo animal list onto their computers by going to the class folder. 3. Pass out instruction sheet. 4. Read the directions that are on the instruction sheet to the class and ask them if there are any questions. 5. If there are no questions have students begin working and remind them that if they have a question to raise their hand and I will come and help. 6. Walk around to each group, to make sure they are staying on task and understanding what they are suppose to be doing. **  7.   **  Once all of the groups have completed the assignment, ask them to answer these questions in their notebook. <span style="margin: 0in 0in 0pt 1in; mso-add-space: auto; mso-list: l1 level2 lfo2; text-indent: -0.25in;">**  a.   **  Which animal class had the greatest number of animals in it? <span style="margin: 0in 0in 10pt 1in; mso-add-space: auto; mso-list: l1 level2 lfo2; text-indent: -0.25in;">**  b.   **  Which animal class had the least number of animals in it? **  Assessment:   ** **<span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">1 **  ||  **<span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">Developing ** **<span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">2 **  ||  **<span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">Accomplished ** **<span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">3 **  ||  **<span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">Exemplary ** **<span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">4 **  ||  **<span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">Score **   || || <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">Failed to do what the directions asked them to do. || <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">The work is not of the highest quality. Sorted most animals incorrectly and did not produce the correct graph. || <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">Provides high quality work. May have sorted a few animals incorrectly or forgotten minor details. || <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">Provides work of the highest quality. Sorted the information correctly and produced the correct table. ||  || ||  <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">The group was never on task. Always needed someone there to be sure they were doing what they needed to do. Did not complete project on time. || <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">The group easily got off task. Had to be asked many times to focus. Project was not fully completed on time. || <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">The group is almost always on task. Project was completed on time. || <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">The group is always on task. Project was completed on time. ||  || ||  <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">N/A    ||  <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">The groups skills in Microsoft Excel did not improve with this assignment. Had to continuously ask questions. Could not repeat a step that you just showed them. || <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">N/A    || <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">It is obvious that the groups’ skills in Microsoft Excel have improved. Ask little questions. If you showed them once they could do it again. ||  || ||  <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">Student never listens to, shares with, and supports others in the group. Not a ‘team player.’   ||  <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">Student rarely listens to, shares with, and supports others in the group. || <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">Student usually listens to, shares with, and supports others in the group. || <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">Student always listens to, shares with, and supports others in the group. A ‘team player.’  ||   || ** 21st Century Skills Goal:  ** The 21st century skill that my lesson incorporates is ITC Literacy. My lesson incorporates this because it completes two of the three bullets listed: (1) the students use technology to research, organize, evaluate, and communicate information; and (2) the students use digital technologies such as computers appropriately to access, manage, integrate, evaluate, and create information to successfully function in a knowledge economy. The purpose of my lesson was for my students to use technology to organize/ manage a list of information that I had gathered from the internet into categories of mammals, amphibians, reptiles, birds, and primates; communicate that information to their audience by creating a graph on Microsoft Excel; and finally using the graph that they created to evaluate their findings by answering the 2 questions that I listed on the provided instruction sheet. ** NETS*T Standard:  ** My lesson plan meets the second standard: Designs and Develop Digital-Age Learning Experience and Assessments. My lesson creates a relevant learning experience through the incorporation of digital tools and resources. The lesson focuses around the use of technology to promote the fulfillment of individual curiosities. The students can manage their own learning and access their own progress. Overall, the lesson works to have all the students develop a digital footprint. With this assignment I provided an instructional sheet which enabled the students to develop the overall goal of a digital footprint. They were able to work independently and solve problems with limited need for asking questions. The students were able to explore many aspects of Microsoft Excel within their groups. They were also able to judge their own progress. If they could not complete a step on the instruction page they now know that they need to work a little harder at understanding excel. If they were able to successfully complete the assignment without any trouble they recognize themselves as being good Microsoft Excel users. Rather than using paper and pencil and manually counting and sorting every animal, the students were able to use digital tools to do that work for them. By using Microsoft Excel I was also able to create a learning activity that addresses students’ diverse learning styles, working strategies, and abilities. Using excel approach many different learning styles. Those students who do well at organizing information were able to use their skill in this assignment. Those students who are visual learners were able to succeed in this assignment as well. Rather than just simply leaving the information as a sorted list, the information was communicated through a graph. I grouped the children so that one student’s weakness would be another student’s strength and vice a versa. The students who are better at reading directions and completing a task were able to help those who struggle in that area. Students who are more familiar with technology skills such as highlighting a group of words, were able to help those students who may not do so well in that area.
 * Goal: **Students will be able to correctly classify animals in the categories of mammals, primates, amphibians, reptiles, and birds. Using Microsoft Excel students will then be able to organize the data into an excel spreadsheet and represent their findings in the form of a graph.
 * || **<span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">Beginning **
 * <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt; line-height: 115%;">Quality of Work
 * Time Management
 * Shows good use of Microsoft Excel
 * <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt; line-height: 115%;">Working with others
 * <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">Contributions   ||  <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">Student did not contribute to this group assignment.    ||  <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">Student almost never provides useful information to his/her group.    ||  <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">Student almost always provides useful information to his/her group.    ||  <span style="font-family: 'Verdana','sans-serif'; font-size: 10pt;">Student always provides useful information to his/her group.    ||   ||