|
Subject: Creating a simple list |
|
1. Topic-
|
Open, Create and Save a Spreadsheet |
|
|
2. Content-
|
Students will be given a project to create a spreadsheet by entering
the items on their shopping lists and perform the calculation the
total cost of all the items. |
|
|
3. Goals: Aims/Outcomes-
|
1. to successfully create a spreadsheet for a simple list
2. to successfully modify the existing spreadsheet if a new data is
collected
3. to successfully perform the calculation without any error or mistake
after entering the new data
4. to learn about other stores on-sale items and compare them |
|
|
4. Objectives-
|
1. Students will be able to create and complete a problem-oriented
spreadsheet.
2. Students will be able record related discount coupons for the items
that are already on sale.
3. Students will learn about how much discount they can get when combining
coupons with items that are on sale.
4. Students constantly will compare store prices. |
|
|
5. Materials and Aids-
|
Students will be provided a laptop.
Students will use Microsoft Excel to develop a spreadsheet and the
data they collect.
Students will have access to the Internet.
Students will have access to the coupons that come with flyers and
Sunday's paper.
Students will be given a list of web sites of the grocery stores to
explore.
Students will be required to bring a flash drive to save their own
work.
The instructor will either have a copy on her flash drive or will
be e-mailed by students the copy of their work. |
|
|
6. Procedures/Methods-
|
A. Introduction-
1. First, we will take a look at what students have on their shopping
list.
2.Second, we will discuss how to enter these items onto a spreadsheet.
3. Last, we will develop a rubric together for their own use during
the development of the spreadsheet. |
|
|
B. Development-
1. I will start by demonstrating a quick presentation by creating
a spreadsheet.
2. The students will be watching me.
3. After a few examples of entering some of the items on the list,
I would let the students keep going slowly with the rest of the list.
4. We will then look at the other grocery stores and compare prices.
I would discuss with them how to modify the existing spreadsheet to
add or remove data.
5. I would teach them how to create formulas for finding the average,
adding and subtracting. |
|
|
C. Practice-
1. Students will have the opportunity to share their work with their
peers.
2. I will keep demonstrating each step on the projector, and after
each step, I will have the students do the same.
3. Students will be able to ask for help when they get stuck.
4. Students are allowed to help each other.
|
|
|
D. Independent Practice-
1. Each student will work on her / his shopping list by modeling
a spreadsheet and create a formula that will find the sum, the discounted
total and how much money they will save after coupons and discounts.
2. Each student will display a detailed result. |
|
|
E. Accommodations (Differentiated Instruction)-
I will simply work with students one-on-one to provide the necessary
accommodation. |
|
|
F. Checking for understanding-
1. I will check the spreadsheet.
2. I will check whether all the items were entered correctly.
3. I will check whether the sum and the total of discounted was done
correctly.
4. I will check if the detailed result matches with the provided data.
5. I will give the student to present her/his work to see if the work
was done with understanding. |
|
|
G. Closure-
1. Each student will reflect in what they have learned.
2. Students will answer my questions to explain more onto formulas. |
|
|
7. Evaluation-
|
1. Each student will be evaluated by using a rubric.
2. I will provide a graded rubric with comments for each students
after the project is finished. |
|
|
8. Teacher Reflection-
|
Each student will be provided a rubric with my personal comments
onto how much they understood and what needs to be improved along
with their scores. |
|
|