Introduction the MS Excel
- Computer
- Middle

- Activity Time
- Materials
- Concepts / Topics
- Resource Type
Students set up an Excel spreadsheet, enter grocery items and prices, use AutoSum to total prices, and submit a printed spreadsheet for assessment.
Introduction to Microsoft Excel
Computer Applications Jimmy Yu Oak Avenue Intermediate
Subjects: Computer Applications and Math
Time: 2 class periods (2–3 hours)
Student Technology Standard Addressed
1(e): Sort, organize, interpret, and display information using spreadsheets, databases, and graphs.
Learning Objectives
- Open MS Excel and set up a spreadsheet.
- Use the MS Excel AutoSum feature to total columns that contain constants—in this case, prices.
- Identify the parts of an MS Excel spreadsheet: cells, rows, and columns.
- Efficiently input information in MS Excel.
- Understand the importance of AutoSum and how formulas are created in MS Excel.
- Understand the importance of creating and maintaining a spreadsheet to manage numbers-related tasks.
Resources Needed
Teacher-created class handouts and a computer for each student with MS Office software, including MS Excel.
Hook and Prior Knowledge
- Have you ever shopped in a supermarket?
- Do you or your parents use a grocery checklist?
- Do you or your parents ever compare prices?
Review basic MS Office tools: bold, font changes, font size, highlighting, and text alignment.
Review data input in MS Excel, including columns, rows, and cells, and types of data: labels, constants, and formulas.
Check for Understanding
What are we going to do today?
- Create a spreadsheet.
- Input data in MS Excel.
What are we going to use the AutoSum tool for?
- To efficiently create a formula to total prices.
Concept and Skill Development: Guided Practice
Model making a short grocery checklist with prices.
| ITEM | AMOUNT | QTY/LBS | TOTAL |
|---|---|---|---|
| Apples | $1.39 | 2 | |
| Orange juice | $2.78 | 1 | |
| New York steak | $7.99 | 2 | |
| Plastic cups | $3.59 | 1 | |
| GRAND TOTAL |
Show how to properly set up a spreadsheet in MS Excel. Use the AutoSum feature to total the prices.
Essential Questions
- What did I do?
- Why did I do this?
- How can this help me?
- Why is the AutoSum feature necessary?
Why Is This Important?
- Learning technology.
- Making life easier.
- Helping with organization.
Independent Practice
Students will create an MS Excel spreadsheet, focusing on the AutoSum tool.
Student Assessment
- Visually check students’ work at their computers to see whether they are using the AutoSum function correctly.
- Students will print and turn in a spreadsheet for assessment.
Differentiation of Instruction
GATE / High-Level Achievers
Students will analyze and compare the use of formulas with the more traditional method of simple calculations. They will produce a brief summary of their analysis. Additionally, they will model and explain the steps to others in the class to demonstrate their understanding of the subject.
Below Grade Level
Students will work in groups and discuss what a spreadsheet is and the function of a formula. They will insert data into MS Excel, identify a formula, and recall the AutoSum feature.
English Language Learners (ELL)
ELL students will be paired with a helpful, high-achieving student to reinforce the strategies given by the teacher. They will be encouraged to use the electronic dictionary to aid comprehension. Additionally, they will receive teacher-typed notes that summarize or outline the oral instructions given in class. They will identify a formula and a spreadsheet, and recall the AutoSum feature.
Closure
The closure activity will be the independent activity and the printed assignment turned in for assessment. Afterward, I will use the LCD projector and ask individual students to identify parts of an MS Excel spreadsheet.
Post-Lesson Reflection / Assessment
Oral instruction will be provided along with a teacher-created handout. I will go over the handout with the students to ensure understanding. I will activate prior knowledge by discussing grocery checklists, balance sheets, calculations, and basic math terms. Students will be encouraged to work cooperatively to share knowledge and information during guided practice and independent practice.
Next Steps
Next logical steps include reteaching the lesson in another format. For example, I will add a lesson that calculates an account balance (credits, debits, and subtotals), as well as one that calculates percentages (basketball shooting percentages). Follow-up activities will involve the entire class to reinforce the importance of spreadsheets and formulas.
Teachers.Net · https://teachers.net/lessons/4191.html