Microsoft Excel Fun with Math for ESL teachers and - DOC - DOC

Document Sample
Microsoft Excel Fun with Math for ESL teachers and - DOC - DOC Powered By Docstoc
					      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
  adjacent cells, click and drag.
 Select Columns Point to the Column
  header and click. To select multiple


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

  adjacent columns, click and drag.
 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:
                         addition                   +
                         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
Basic numbers and addition
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
Student Lists, grade book




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