i signed up for storage at the box.net.
it was very easy to upload my files and very fast!
i feel much better knowing that i can access my files online
in case i do not have my flash drive.
it would also be helpful for me with work and work files that i
may need when i am at a different location.
Friday, February 6, 2009
lesson plan 1- using digital spreadsheet
Lesson Title “My Monthly Budget”
Teacher’s Name – Shannon Bukikosa
Grade 10-12th
Content Area: Business/Clerical
Lesson Length: 2 weeks (Total Time)
Analyze Learners
1. 15-18 students
2. 4 girls:1 boy
3. 14-18 year olds
4. Students in the class are on the Career Path
5. Current Knowledge, Prerequisites, and Notes about Learner Attitudes
·1 Basic knowledge of Excel
·2 Internet search capabilities
6. Learning Styles o Visual – 60%
o Auditory (Aural) – 20%
o Kinesthetic (Hands On) - 20%
State Objectives
Students will be able to participate in groups of 2 to represent a family
Students will be able to create an Excel spreadsheet for a monthly budget
Students will be able to research websites to support salaries and expenses
Students will use the given factors that must be incorporated into calculations in spreadsheet:
Students must -
· Choose an occupation for self and spouse
· Determine how many children the family will have
· Choose to rent an apartment or buy a house
· Determine monthly rent or mortgage payment
· Determine monthly costs for power, water, gas for house or apartment
· Determine monthly cost for telephone and cell phones
· Determine monthly cable expense
· Determine monthly expenses for 1 or 2 cars which includes auto loan, insurance, maintenance, and gas
· Determine monthly expenses for family entertainment; must list at least 2 activities
· Determine monthly food and toiletry expenses
· Determine monthly childcare expenses
· Determine monthly clothing expenses
· Determine a monthly expense for special occasions such as birthdays or holidays
· Determine monthly amount to deposit into a savings account
Spreadsheet should contain formulas for future input of expenses
Students will be able to produce a graph to visually breakdown monthly expenses
Students will be able to present their graph to class
Select Media, Materials, and Methods
Internet/Search Engines
Computer/laptop
Excel software
Multi Media (projector)
Utilize Media, Materials, and Methods
Teacher will preview resources of search engines to be used by students to gather valuable information to determine expenses.
Teacher will preview students’ work before presenting to class
Teacher will prepare handouts and rubrics
Teacher will prepare necessary equipment and make available to students
Teacher will present objectives of the lesson and the handouts
Teacher will discuss guidelines and rubrics
Teacher will remind students of acknowledging sources, plagiarism and copyright penalties
Teacher will review proper use of equipment by students
Require Learner Participation
Students must present their budget to the class on a projector
Students must share experience on this lesson.
Evaluate & Revise
Teacher will evaluate participation in group activity and presentation
Teacher will check if students used each factor in spreadsheet
Students will cite resources used
Teacher will evaluate spreadsheet formulas
Teacher will evaluate graph and presentation
Students will provide feedback on lesson
Teacher will revise lesson plan based on student feedback
my first real lesson plan
It was very difficult for me to come up with an idea for this lesson plan, at first. I was having a hard time trying to figure out what to do so I asked my classmate for her help. She then asked one question, “what is your background?” Then it hit me, accounting! I can do a lesson on creating a monthly budget for a family.
I would say that 2E from the NETS*T standards can apply to this assignment. This lesson plan addresses plan strategies to manage student learning in a technology-enhanced environment. The use of the Excel program shows that the lesson is applying technology to develop students’ higher order skills and creativity (NETS 3C). The media needed to complete this lesson applies to using multiple methods of evaluation to determine students’ appropriate use of technology (NETS 4C).
I learned that there are many different sites you can use to plan your lessons. So many teachers want to help others and show this by posting their lessons on a website. I used several websites to help with ideas on this lesson. I searched for the topic on budget lessons and several different articles came up. I downloaded a couple of resources like the ASSURE Model, I also learned that there are so many aspects of planning a lesson. “The ASSURE Model is an example of one popular educational model that teachers can use to plan for technology integration into instruction. Planning is important on all levels from the district, to the classroom, to planning individual lessons. Using The ASSURE Model will organize and prepare lesson plans in classrooms with the help of technology.” (Alen, June, 2004) There are also so many variables that you have to consider when creating a lesson plan.
I liked learning and finding out for myself that there is an abundance of resources for teachers. It is very comforting to know that as a teacher, I will have support as long as I know how to search and ask for it!
1. Alen, E. (2004). The ASSURE Model. Retrieved January 31, 2009, from website: http://www-personal.umd.umich.edu/~aelisha/assure_files/frame.htm
2. NETS for Teachers. (2008). Retrieved February 7, 2009, from International Society for Technology in Education. Website: http://www.iste.org/Content/NavigationMenu/NETS/ForTeachers/2008Standards/NETS_for_Teachers_2008.htm
I would say that 2E from the NETS*T standards can apply to this assignment. This lesson plan addresses plan strategies to manage student learning in a technology-enhanced environment. The use of the Excel program shows that the lesson is applying technology to develop students’ higher order skills and creativity (NETS 3C). The media needed to complete this lesson applies to using multiple methods of evaluation to determine students’ appropriate use of technology (NETS 4C).
I learned that there are many different sites you can use to plan your lessons. So many teachers want to help others and show this by posting their lessons on a website. I used several websites to help with ideas on this lesson. I searched for the topic on budget lessons and several different articles came up. I downloaded a couple of resources like the ASSURE Model, I also learned that there are so many aspects of planning a lesson. “The ASSURE Model is an example of one popular educational model that teachers can use to plan for technology integration into instruction. Planning is important on all levels from the district, to the classroom, to planning individual lessons. Using The ASSURE Model will organize and prepare lesson plans in classrooms with the help of technology.” (Alen, June, 2004) There are also so many variables that you have to consider when creating a lesson plan.
I liked learning and finding out for myself that there is an abundance of resources for teachers. It is very comforting to know that as a teacher, I will have support as long as I know how to search and ask for it!
1. Alen, E. (2004). The ASSURE Model. Retrieved January 31, 2009, from website: http://www-personal.umd.umich.edu/~aelisha/assure_files/frame.htm
2. NETS for Teachers. (2008). Retrieved February 7, 2009, from International Society for Technology in Education. Website: http://www.iste.org/Content/NavigationMenu/NETS/ForTeachers/2008Standards/NETS_for_Teachers_2008.htm
Subscribe to:
Posts (Atom)
