Tech Tips for Teachers
  • Lesson Index
  • About Us

Excel Activity for ESOL or Basic Skills Classroom

9/19/2013

3 Comments

 
: : Tech skills:  typing numbers and inserting data into cells

Of the fabulous three of Microsoft Word, PowerPoint, and Excel, I find that Excel is least used by teachers integrating technology. Perhaps this is because some think it is harder for students to learn, but maybe it is because being math-phobic like me, some teachers view it as more daunting than need be. (Do fewer teachers integrate spreadsheets into projects and other classwork? Let us know what you think and comment below.)

Anyway, here is a very simple activity that actually could even be used in beginning ESOL classes when starting to talk about students’ families. It also has the potential to be extended into a complex project with more advanced ABE/GED students reading census data and surveying their own community. Using this spreadsheet template you can have your students input their own family sizes to find the class' average.

Picture
Lesson ideas:


Opening activity:
  • Begin by explaining to the class your purpose for the activity. (e.g., “We are talking about families…” “We have been learning about averages…” “We have been working on understanding charts and data from the census...”)
  • Review the meaning of the word “average.” Ask the class if anyone knows what the average family size in the United States is? Ask if they know the average in countries where they (or their ancestors) are from? Depending on the class, you might ask about changes over time and why in some countries family size has diminished. 
  • Present a challenge or driving question. Depending on whether or not you plan on a broader-reaching project or not, you might ask (and discuss) one of the following: 
    - What do you think the average family size is in our class? 
    - What do you think the average family size is in our school or community?
    - What is the average family size in the United States and how does it compare to our community or class size?
  • If need be, introduce or review basic functions of a spreadsheet and when they are used. 

Options for the activity: 

  • One computer class - If you are working on one computer (preferably with a projector) ask students to come up and type their name and family size into the cells. So they keep engaged, ask the rest of the class to call out the number when an individual types in the family size. Also have them notice and call out the new average as it automatically changes. (Click in the cell and show them how the average has been programmed to change as data is entered. If your goal is for students to learn this aspect, use this segue to instruction.)
  • 1:1 – If you have a computer lab make sure students are able to access the document. Ask students to take a short survey and enter the names of students next to them. 
  • In the cloud - You might create a spreadsheet document on Google Drive where students can all access and enter their own names and family size at the same time. 

Closing activity: After students have gathered and entered data, have them save the spreadsheet and report their results to the class.

Note:  If you are using this as an English language learning activity, if need be, before they start, prepare students on how to ask questions. For example: “How many people are in your family?”  Encourage them to ask more questions too such as, “How many sisters do you have?” Don’t forget to work on phrases like: “The average family size in my survey is/was…”

Follow up/Extension: Have the class answer and discuss the following questions: 
  • Is the average family size what you expected it would be? Why or why not? 
  • Organize a survey of the school or local community. Then compare the data to census data. If there is a difference can they think of why? Have a class discussion and consider being in experts as guest speakers on the topic. 

Variations:

  • Ask the class to develop a new survey on a different topic.
  • Expand the survey using a free survey tool such as Survey Monkey.  
  • Focus more on the math and spreadsheet aspect such as creating formulas with this being one example of how to do so. 
  • Ask the class to research the following: Why is family size larger in some countries? Was the average family size larger? If so, why? 

Steve Quann

Share any comments, your experience using this activity or any suggested variations you have (particularly using other technologies).  
3 Comments

Webinar Recording - Improving Adult Literacy: Using Technology to Support Learning and Motivation

9/10/2013

0 Comments

 
We hope you were able to attend the webinar on September 6, Improving Adult Literacy: Using Technology to Support Learning and Motivation, but if you missed it, the recording is now available. For more details about the webinar, you can refer to our previous post.
Picture
0 Comments
    We've moved! Find us at 
    edtech.worlded.org/blog/​

    This blog is intended for adult education teachers and tutors looking for straight-forward help on integrating technology into instruction. We hope that you find some inspiration here to try something new!
    World Education Logo

      Join our mailing list

    Subscribe
    Follow @WorldEdUS

    RSS Feed


    Categories

    All
    Career Readiness
    Cell Phones
    Charts And Graphs
    Classroom Management
    College Readiness
    Digital Literacy
    Game Based Learning
    Listening
    Numeracy
    Organizing Information
    Reading
    Research
    Science
    Speaking
    Surveys
    Video
    Vocabulary
    Writing


    Cast Your Vote!

    Enjoy taking polls? Here's another one from our 100th post!

    Archives

    December 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013
    July 2013
    June 2013
    May 2013
    April 2013
    March 2013
    February 2013
    January 2013
    December 2012
    November 2012

TECH TIPS For TEACHERS

We've moved! Visit us at http://edtech.worlded.org/blog/
​

Tech Tips for Teachers is a blog for the adult education field devoted to integrating technology into instruction. Our posts provide ideas that teachers can use to support instruction in their classrooms today! We are a project of the EdTech Center at World Education. 
  • ​About Us
  • Index
  • Email Us
  • Follow US on Twitter
​World Education

In the United States, World Education supports adult and older youth learners by strengthening the educators, organizations, and systems that serve them. 
Picture
​EdTech Center

The EdTech Center brings together World Education's educational technology projects and amplifies their services through our partners.
Picture
© COPYRIGHT 2016. ALL RIGHTS RESERVED.