# Microsoft Excel Fun with Math for ESL teachers and - DOC - DOC by tvg18870

VIEWS: 9 PAGES: 7

• pg 1
```									      Microsoft Excel: Fun with Math for ESL teachers and students

 A little bit about Excel
The Excel Window

Standard
toolbar
Formula Bar

Formatting
toolbar

Sheet tabs

The Excel window displays a workbook. The main work area is the worksheet. The
workbook is made up of multiple worksheets.

In this workshop we’ll use the Toolbar buttons. As with everything, there are almost
always several other ways to do any one thing. For example, most of the functions on the
Toolbars are also accessible through the Menus. Using Toolbars is just my preferred way.
If you’re not sure what a Toolbar button is, just hover your mouse over the button and
wait for the Tool Tip to display.
2

The Worksheet
A worksheet is a grid. A grid is made up of columns and rows. The columns are identified by
letters. The rows are identified by
numbers.

The intersection of each column
and row is a cell. The cell is called                                  C5
by its column letter and row
number.
For example, this is cell C5.

The active cell is the cell in which
you can enter data. You can make
any cell active by clicking on it. The
active cell has a darker border
around it.

       Which is the active cell in this picture? __________

Entering text or numbers in the worksheet
To enter text or numbers,
1. Click in the cell.
2. Type the information. Use the numberpad to type numbers.
3. Press Enter or press an arrow key.

Mouse Pointers in Excel

Select: point and click to                                                       Copy: point to the
select a cell. Click and                                                         lower right corner of
Move: point to the border of the
drag to select a range of                                                        the cell. Click and
active cell. Click and drag to
cells.                                                                           drag to copy.
move.

Formatting in Excel
Before you format anything you have to select it. To:

 Select Cells Just point to the cell with the Select pointer, and click. To select multiple
 Select Columns Point to the Column
header and click. To select multiple

S.A. Hovanesian, Technology Learning Center, 2005
3

 Select Rows Point to the Row header and click. To select multiple adjacent
rows, click and drag.

Once you make a selection, format using the Formatting Toolbar buttons.

You can format:
 Font
 Font Size
 Font Styles
 Alignment
 Number Styles
 Border lines
 Fill Color
 Font Color
 and more…
Resizing Columns and Rows
Point to the boundary between column or row headers. When you see the double-headed
arrow, click and drag.

Practice
Try some of the formatting
you see in the example at
the right.

Basic Formulas

AutoSum
Use the AutoSum button to add the numbers in a series of cells.
AutoSum button

 Enter numbers in the cells as in the example.
 In cell A7, click the AutoSum button two times.

Wow! 

S.A. Hovanesian, Technology Learning Center, 2005
4

Writing a simple formula
Excel formulas have a special format. It looks like this:
=B15*C15
 This formula means "multiply the number in B15 by the number in C15."
 You can use actual numbers or cell references in the formula.
 A formula always begins with an equal sign (=).
 Use these keys on the number pad:
subtraction                -
multiplication             *
division                   /

 Click in the cell and write a formula.
Solve these math problems in Excel using formulas.
87*95= ________ 164/27= _________               435 -94.5=__________

 Fun Things for students
Practice saying and listening to numbers with a partner addition jigsaw. Give each partner
different addition problems (or have them make up their own) with answers. Partners have
to dictate their problems while the other partner listens and enters the numbers in an Excel
worksheet. Then they can use AutoSum to check the answer. It’s great because if the
answers don’t match, using Excel allows them to check back and see where they went
wrong. It sounds deadly boring, but the students can’t get enough…

Example:
1223
Partner A: “1223 plus 9911 plus 7894 equals…”
9911
Partner B: Listens, enters numbers, gets result with AutoSum. “19028”            7894
19028
Partner A: “That’s right!”

S.A. Hovanesian, Technology Learning Center, 2005
5

Surveys
Doing surveys is a great way to
get students interacting, and
they can be done at any level.
Just vary the complexity of
topics. Higher levels can also
write a narrative analysis of the
survey results. Here’s a very
basic one that you could do in
the lowest levels.

Math Word problems
Give students word problems which they have to solve in Excel.

For example:
You work in the bookstore. You have to do an inventory of some new books. You
count the books and find that you have 85 copies of Side by Side2, 120 copies of
Focus on Grammar, and 165 copies of Going Places Book 1. Side by Side costs
21.95 each. Focus on Grammar costs 25.49. Going Places costs 19.35.

1. What is the total cost of all the books? ____________

2. How many total books are there? _____________

The worksheet might look something like this.

S.A. Hovanesian, Technology Learning Center, 2005
6

Personal Budget Project
This is a real favorite with my students.
I’ve done it in various ways. Here’s one:

 Introduce concept and terminology
of budgeting.
 Students brainstorm expense
categories. (Food, Rent,
Transportation, etc.) This is
excellent for generating
vocabulary.
 They can use real, estimated, or
fantasy (ex. My Dream Budget)
figures.
 They enter their information in a
worksheet. (Here is an example.)
 They make a Pie Chart of their
expenses. Below is an example of
a student’s chart.

My Expenses

Money to m y m other
Recreation
10%
2%

Health
Rent
10%
41%

Food
Utilities
26%                                      Transportation
3%
Debt                  2%
6%

S.A. Hovanesian, Technology Learning Center, 2005
7

 Fun Things for teachers

Alphabetize names:

 Select the cells with
the information you
want to sort.
 Click the Sort
Ascending button on
the Standard Toolbar.

Groovy Schedule
Grid

Fill in days of the
week (and other
sequences)
automatically.

   Enter any day of
the week in a
cell.
   Point to the
copy handle.
   Click and drag.

S.A. Hovanesian, Technology Learning Center, 2005

```
To top