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.

This Lesson Plan is available at (