Ryan+Collopy+Page

=Ryan Collopy Page - Progress and Information=


 * || Ideas for your Math/Technology Open ended Project .................................................................................................................................................................. ||
 * 1 || The first idea I had was using my itsLearning page to have students help each other. Students could post questions and answers over topics that have been covered or will be covered in class. They could create a videos showing how to do different types of problems. This will help students expand their knowledge of a topic. If a student can explain it to another student then they truly understand the topic. ||
 * 2 || The second idea I had was to use Excel to teach students about staying within a budget for a years time frame given normal "adult" bills such as mortgage, electric, gas, etc. They would use formulas to calculate net gain/loss in their own account. Each month students would pick a number between 1-10 that correspond to either an event that will subtract money from their account (unexpected life event) or possibly add to their account (such as a tax refund or birthday gift). ||
 * 3 || The final idea I had was to create a game (Who Wants to Be a Millionaire Style) to be hosted on my itsLearning page that students could use as a review both in the classroom and out. ||


 * **Name**

Place your name next to your comment here || **Comments ** ||
 * Sue Becker || I will make a comment on each and everyone of your ideas. I am hopeful that many of you will also comment on each others work as well. Collaboration is a 21st Century Skill and can be very helpful to everyone! ||
 * Sue Becker || Ryan, You have great ideas. I think all three are great. However, being selfish, I would love to see you develop 1 or 3 because no one else in the grant has done anything like that. Please go ahead and start filling out the Project proposal on one of these ideas listed above. Nice ideas and let me know if you need any help with your project proposal. Nice work! ||
 * Sue Becker || RyanCould you visit your page again and post your information on your project. You have nice ideas I just would like information in that helps to define what you did on your project. Please make sure you also fill out the questions in RED also. If you have any questions feel free to email or call me. We are hoping that everyone has this done by June 8th. I will watch your responses here and if you need more information... I will let you know later next week. Thanks again... Suebe ||

Place your Final Open Ended Project Proposal Here --
Use Excel to teach students about staying within a budget for a years time frame given normal "adult" bills such as mortgage, electric, gas, etc. They would use formulas to calculate net gain/loss in their own account. Each month students would pick a number between 1-10 that correspond to either an event that will subtract money from their account (unexpected life event) or possibly add to their account (such as a tax refund or birthday gift). They will also use a circle graph to show percentages that shows what percent of their budget is going towards any particular bill or item they purchase.
 * __ Project Proposals __**

Ryan Collopy
 * Name: **

Waggoner Road Junior High School
 * School: **

7th grade math
 * Grade Level and Class: **

I will be developing the project over the summer and will be implementing it next school year beginning in September and running through May of 2013.
 * Estimated time for development and implementation (if possible): **

This project will allow students to become familiar with excel and how it can be used in the real world to benefit them. It will also prepare them for the unexpected events that occur in life and what effect it can have on their budget. Since this is a long-term project it will teach them to stay focused for an extended period of time on a particular goal (staying at a positive balance in their account).
 * Project Goal(s) and Objectives: **

Students will display a knowledge of formulas in excel. They will learn to consider bills, taxes and unexpected events into their budget and how it effects their account balance over the course of a year.
 * Content Objectives: **


 * Description of the Project: **

The objective of this project is for students to set up a budget that would allow them to live the type of life they would like, as well as to understand what skills and/or education they need to get there. This will include developing a budget, paying bills and dealing with unexpected events. This project involves doing calculations on Excel. I also hope students observe realities about what it takes to be a successful adult in the world today. It isn't easy and it takes a lot of money!

I will focus the lesson on budget since they will pertain to the 7th grade standards the most. Students will need to know how to create and enter mathematical formulas into excel. I always have a mix of students in terms of ability level and they tend to have many different learning styles. I may consider spending varying amounts of time helping them set up their initial budget to help them be successful.
 * Considerations **
 * Student Learning Outcomes:
 * Mathematical Content:
 * Pedagogical Considerations:

Excel - This is a very valuable program that most students probably do not have a lot of experience with and can be used to help them in real world situations involving budget.
 * Technology Chosen and Why: **

Use of the schools computer lab for at least one day per month.
 * Instructional and/or Technical Support You will Request from District Staff: **

This is a school year long project that will require one to two days per month for students to complete the required final product.
 * Implementation Timeline (if appropriate): **


 * Project Submission Information should be updated as needed. **

Use this set of short questions to help guide you in your reporting about your progress. These include:

// How does TPACK play a role in your project or activity? // TPACK played a role in the development of this lesson by deciding to actually use technology in a lesson that could be used to help students in their futures. TPACK has taught me to consider technologies that can be used to enhance the lessons that I already use on a daily basis.
 * TPACK consideration

// What do you need to learn? Or need to know to help to complete the project? // I will need to learn the best way of teaching excel to students since most do not have much experience.
 * 21st Century skill development

// Do you feel you have addressed these topics? // I can differentiate the project based on how much "extra room" I leave in their budget. I may help some get started setting up their budget and let others explore on their own how to set up their budget and formulas.
 * Differentiation, digital natives or other course concepts

The digital natives will be fairly comfortable with this project because they are accustomed to using the computer for various activities.

The project also involves real world boundaries and allows them to make decisions regarding their own budget.

// How does your project align with your Math objectives? // In 7th grade the students must be able to: find percentages and create and solve formulas based on a problem.
 * Alignment with Math objectives

// How can you demonstrate that your learning plan is working? If possible, include artifacts showing results of the project. It would be wonderful if you could take photos and/or video, possible links or other resources to share with other members of this eTech project // Each month students will have a print out of their budget so I can see if they are using their formulas correctly and if they are staying out of the red in terms of their budget.
 * Transformative evidence of how this may or may not be working

// Why did you choose a particular technology tool? What worked and what did not work? // I chose computers and excel because they are user friendly and are useful tools that the students could use both in class and in the real world.
 * Reasoning for your choice of technology