Objective

Students will be able to…

• open the MS Excel application
• open workbook and worksheet
• create a new worksheet and enter the data
• perform simple calculations
• save an Excel workbook
• close a worksheet

Prerequisites

• Computer basics
• Keyboard and mouse skills
• Prior knowledge of Microsoft Word, Microsoft PowerPoint

Goal

Operational Definition

All – This gives the goal, which is the minimum that the teacher must achieve for all students in the classroom.
Some – This gives the goal that the teacher may try to achieve for some students in the classroom who can achieve the suggested goal over and above the goal stated for ‘All’.
Few – This gives the goal that the teacher may try to achieve for few students in the classroom who can achieve the suggested goal over and above the goal stated for ‘Some’ and ‘All’.

Materials Required: 

Technology

• An audio-enabled computer with an internet connection, smartboard projector and screen.
• All devices like laptops, tablets and desktop computers with accessibility features enabled.
• Screen readers like JAWS and NVDA.
• Large keyboards, built-in screen magnifiers, hearing aids, text-to-speech and speech-to-text software.
• Voice recognition software like Siri, Windows Speech Recognition, etc.
• Headsets.
• Student writing or typing tools.
• MS Excel is installed on their computers

Teacher Materials

• Whiteboard and markers or blackboard and chalk.
• Pre-teach vocabulary cards and worksheets.
• Lesson videos.

Student Handouts

• Handout 1: Yes or No Cards
• Handout 2: Thumbs Up and Down Card
• Handout 3: Worksheets

Print Preparation

• Thumbs up and Thumbs down Card for students
• Yes or No Cards for students
• Pre-teach vocabulary cards
• Worksheets for students

Preparation for the Activity:

1. All the learning and teaching materials needed for this lesson plan must be ready before the lesson begins.
2. Ensure that there are enough copies for all children. Multiple copies can be made by photocopying too.
3. Please have the assistive technologies and accessibility features ready for your inclusive classroom.

Setup for transacting the lesson:

This topic must be taught in the computer lab.

Instructions to the teacher:
Introduce the new words to the students.

LTM: Pre-teach Vocabulary

1. Warm-Up

1. Write the word Excel on the board.
Ask students to write down the first thing that comes to mind when thinking of the word Excel.

Possible Answers: Numbers, calculations, worksheet, rows, columns, etc.
2. The teacher should ask, ‘Who has seen an Excel sheet before? What does it look like?

2. What is MS Excel?

Excel is a spreadsheet. It has many rows and columns. This spreadsheet is like a giant table made up of little squares. These little squares are called “cells”.
What is the use of these cells?
These cells are used to enter information in the form of text or numbers and do calculations like addition, subtraction, multiplication and division. Excel also helps to sort information in different ways. It is also used to make graphs and charts.
For example:
-numbers like the amount of money spent on books
-words like the names of your cartoon characters
–or even dates like the birthdays of your family and friends

Video: What is MS Excel

LTM: Uses of MS Excel in Daily Life

3. Opening MS Excel Application

To start an Excel application, follow the steps given below:

• Click on the Start button. 
• Scroll through the alphabetical list on the left.
• Under alphabet M, locate Microsoft Office 2010
• Search for Microsoft Excel 2010 from the sub-menu and click on it.

Video: Opening MS Excel Application in Windows 10

Video: Opening MS Excel Application in Windows 10 ISL

Try Me: Opening MS Excel Application in Windows 10

Wordwall: Opening MS Excel Application in Windows 10

4. Workbook and Worksheet

An Excel file is called a Workbook. The workbook has many worksheets, also called spreadsheets.
Each workbook is composed of rows and columns. Rows run horizontally; columns run vertically. Columns are labelled by letters and rows are labelled by numbers. The place where a row and a column are called a cell. All cells store data. The data could be text, numbers, dates, formulas, etc. Each cell has an identifier, which is called its cell address. 

Video: Workbook and Worksheet

5. Do it Yourself

Preparation for the activity

1. Please go through the LTM video well in advance to prepare to conduct the given activity.
2. Download the video and show them to the children while conducting the given activity.
3. Please ensure that all children can see the video when played and follow the activity as instructed.
4. Please keep the required materials for conducting the different activities. 
5. Go through the suggestions for the variation of pace and scaffolds for assistance and practice and ensure necessary preparation accordingly.

Preparing will help you to conduct a practical activity in an inclusive classroom and achieve the aim. 

Setting for the activity:

All are computer lab activities, but variations for open space are suggested wherever possible. All children can work individually on the computer. However, children who need peer support can work with their peers.

Materials required for this activity:

• All student devices, like laptops, tablets and desktop computers with assistive technologies and accessibility features.
• A sheet with data to be filled out in the Excel sheet.

Procedure:

• The students should open an Excel file.
• Click the File tab. 
• Excel shows the Backstage view. 
• Choose New.
• Select the Blank workbook icon
• Click on the Create button. A new blank workbook will open in the Excel window. The shortcut key to create a new workbook is Ctrl+N.
• To enter data in a cell, Click on the cell in which you want to enter data.
• Start typing your content. 
• Press the Enter or Tab key to move to the next cell.
• To edit or modify anything in a cell.
• Double-click inside the cell that you want to edit. 
• A cursor will be seen.
• Make changes
• Select a specific content in a cell and then type new data. This will replace your old data with the new one.
• Type the data in the respective cells as shown.

LTM: Data sheet

6. Activity Sheet

Worksheet: Activity

7. Perform Simple Calculations

We can do simple calculations in Excel using formulas. Let us learn how to add in Excel by entering the formula.
Look at the Excel sheet.

LTM: Sample Excel sheet

Column A contains the names of items purchased. Item names are stored from cell A2 to cell A9. Column B contains the prices of the items purchased. The prices are entered from B2 to B9.
We must add the data in cells B2 to B9 to find the total expenditure. To find the total, follow the steps given below:

• Click on the cell in which you want to enter the formula.
• In this example, the formula has to be entered in B10.
• Type = (an equal sign).
• Select the cells you want to add.
• Click on the first cell B2. It will change to a dotted line.
• Now type the + sign from the keyboard.
• Click on the next cell, ie B3, and type the + sign.
• Continue to select all the cells you want to add.
• The formula will be shown in the formula bar as: =B2+B3+B4+B5+B6+B7+B8+B9.
• Press Enter. The total is seen in cell B10.

8. Excel with ‘Excel’

“Hello Uncle, one Tata tea packet, please!” shouted Sneha, looking all around for the shop owner. She spotted him behind the counter tapping the keys on his computer, muttering 8, 9, 7, 0 plus 1, 3, 7, 8, 5…

“What are you doing, Uncle?” asked Sneha, curious to see what he was typing.

“Well, the new stock came in today, and I have to clear the invoice. Trying to check if the amount is right,” Uncle replied.

Oh, that’s easy peasy; just use MS Excel,” said Sneha cheerfully.”

But I don’t know MS Excel,” Uncle said, looking so woebegone. “It’s simple; I’ll help you,” smiled Sneha. First,

• Enter an ” = ” sign in the cell where you want the total to be shown.
• Click on the first cell from which you want, add a ” + ” sign next to it, continue to the next cell, and repeat the same.
• Now you can see how the formula is shown for the selected cells. B2 + B3 + B4 + B5
• When you press enter, you can see the total in B6.

“With practice, it becomes easy, and you can quickly replicate the same for other functions like subtractions, multiplication, and division. So, you see, it is this simple.”
“Let me try,” said Uncle, and he keyed the numbers exactly as Sneha taught him.

“Hurray, you got it, Uncle,” cried Sneha.

Thank you, teacher,” replied Uncle, smiling broadly.

Video: Excel with ‘Excel’

Video: Excel with ‘Excel’ with ISL

9. Do it Yourself

Preparation of the activity

• Please go through the LTM video well in advance to prepare to conduct the given activity.
• Download the video and show them to the children while conducting the given activity.
• Please ensure that all children can see the video when played and follow the activity as instructed.
• Please keep the required materials for conducting the different activities. 
• Go through the suggestions for the Variation of Pace and Scaffolds for Assistance and Practice and ensure necessary preparation accordingly.

Preparing will help you to conduct a practical activity in an inclusive classroom and achieve the aim.

Setting for the activity:

All are computer lab activities, but variations for open space are suggested wherever possible. All children can work individually on the computer. However, children who need peer support can work with their peers.

Materials required for this activity:

• All student devices like laptops, tablets, and desktop computers with assistive technologies and accessibility features.
• A sheet with data to be filled out on the Excel sheet.

Procedure:

• The students should Open an Excel file.
• Click the File tab. 
• Excel shows the Backstage view. 
• Choose New.
• Select the Blank workbook icon
• Click on the create button. A new blank workbook will open in the Excel window. The shortcut key to create a new workbook is Ctrl+N.
• Click on the cell in which you want to enter the formula.
• In this example, the formula has to be entered in B8.
• Type = (an equal sign).
• Select the cells you want to add.
• Click on the first cell B2. It will change to a dotted line.
• Now type the + sign from the keyboard.
• Click on the next cell, ie B3, and type the + sign.
• Continue to select all the cells you want to add.
• The formula will be shown in the formula bar as =B2+B3+B4+B5+B6+B7
• Press Enter. The total is seen in cell B8

LTM: Data sample

10. AutoSum Function

We can also use the Auto Sum function to add the total marks
To use the AutoSum function, follow the steps given below: 

1. Select all the marks, i.e., from B2 to B7.
2.  Go to the Menu bar and click on the Formulas menu.
3. Click on the AutoSum button.
4. The total will be automatically calculated and displayed in cell B8.

Video: AutoSum Function

Video: AutoSum Function with ISL

11. Dance of Cells

In cells and rows, our data flows,
With formulas, our insight grows.
From A1 to Z, we chart our course,
In Excel’s realm, we find our force.
Functions guide as we calculate,
In Microsoft’s world, we navigate.
In rows and columns, we excel,
With each keystroke, our data shows.

Video: Dance of Cells

Video: Dance of Cells with ISL

12. Do it Yourself

Preparation of activity

• Please go through the LTM video well in advance to prepare to conduct the given activity.
• Download the video and show them to the children while conducting the given activity.
• Please ensure that all children can see the video when played and follow the activity as instructed.
• Please keep the required materials for conducting the different activities. 
• Go through the suggestions for the Variation of Pace and Scaffolds for Assistance and Practice and ensure necessary preparation accordingly.

Preparing will help you to conduct a practical activity in an inclusive classroom and achieve the aim.

Setting for the activity:

All are computer lab activities, but variations for open space are suggested wherever possible. All children can work individually on the computer. However, children who need peer support can work with their peers.

Materials required for this activity:

• All student devices like laptops, tablets, and desktop computers with assistive technologies and accessibility features.
• A sheet with data to be filled out on the Excel sheet.

Procedure:

• Students should Open an Excel file.
• Click the File tab. 
• Excel shows the Backstage view. 
• Choose New.
• Select the Blank workbook icon
• Click on the Create button. A new blank workbook will open in the Excel window. The shortcut key to create a new workbook is Ctrl+N.
• Using the AutoSum function, find the sum of the numbers from 1 to 15
• Select all the numbers, i.e., from A1 to A15.
• Go to the Menu bar and click on the Formulas menu.
• Click on the AutoSum button.
• The total will be automatically calculated and displayed in cell A16.

LTM: Data sample

Video: Do it Yourself

13. Saving an Excel Workbook

To save an Excel workbook, follow the steps given below:

• 1. Click on File. 
• 2. Select Save As. 
• 3. In the File name box, type a name for your workbook. 
• 4. Choose Save to finish

Video: Saving an Excel Workbook

14. Opening an existing workbook

• Click on the File tab. This will display the Backstage view.
• 2. Click Open. The Open dialogue box appears. 
• 3. Select the workbook that you want and click on Open.

Video: Opening an existing workbook

15. Exiting Excel

Do any of the following to exit Excel

• Choose file ________________ Exit
• Press Alt +F4
• Click the close button(X) in the upper right corner.

Video: Exiting Excel

16. Assessment:

Worksheet: Working with Excel

17. Assistive Technologies

Video: Assistive Technologies

Teacher Resource Document

Source and Attribution of images: All images used in the above Assets and Aids are originally created.

This digital material has been developed by the Sri Sathya Sai Vidya Vahini Inclusive Education Project, a unit of Sri Sathya Sai Central Trust, Prasanthi Nilayam, as a collaborative offering in the service of our nation.