Teachers Network
Translate Translate English to Chinese Translate English to French
  Translate English to German Translate English to Italian Translate English to Japan
  Translate English to Korean Russian Translate English to Spanish
Lesson Plan Search
Our Lesson Plans
TeachNet Curriculum Units
Classroom Specials
Popular Teacher Designed Activities
TeachNet NYC Directory of Lesson Plans TeachNet NYC Dirctory of Lesson Plans

VIDEOS FOR TEACHERS
RESOURCES
Teachers Network Leadership Institute
How-To Articles
Videos About Teaching
Effective Teachers Website
Lesson Plans
TeachNet Curriculum Units
Classroom Specials
Teacher Research
For NYC Teachers
For New Teachers
HOW-TO ARTICLES
TEACHER RESEARCH
LINKS

GRANT WINNERS
TeachNet Grant:
Lesson Plans
2010
TeachNet Grant Winners
2009
TeachNet Grant Winners
Adaptor Grant Winners
2008
TeachNet Grant Winners
Adaptor Grant Winners
2007
TeachNet Grant Winners
Adaptor Grant Winners
Other Grant Winners
Power-to-Learn
Math and Science Learning
Ready-Set-Tech
Impact II
Grant Resources
Grant How-To's
Free Resources for Teachers
ABOUT
Our Mission
Funders
   Pacesetters
   Benefactors
   Donors
   Sponsors
   Contributors
   Friends
Press
   Articles
   Press Releases
Awards
   Cine
   Silver Reel
   2002 Educational Publishers Award

Sitemap

TeachNet NYC: Lesson Plans

Graphing and Analyzing Our School’s Attendance

Grade Level: 9

Standards:     Math:

Organize data

Interpret representation of data, compare distribution of data and critique conclusion

Technology:

Students use productivity tools to collaborate in constructing technology-enhanced models, prepare publications, and produce other creative work.

Students use technology tools to process data and report results.

English Language Arts:

Read and comprehend authentic documents.

Write reports using correct conventions and grammar.

Aim:    How do we analyze our attendance?         

Motivation:

The students will receive the school’s average attendance since the beginning of the year. A few questions will be asked:

  1. 1.                  What can we do with all these numbers?
  2. 2.                  What do they represent?
  3. 3.                  Can we use all these numbers to understand our community/school?
  4. 4.                  Can we create graphs and charts using these numbers?

By answering these questions students will be motivated to work on the project and mostly they will understand the final objective of the project.

On the transparency, a few examples of possible graphs will be given.

                                   

 Materials:

            Computer with the following software:

  1. a.                  Power Point
  2. b.                  Excel or Works
  3. c.                  Word or Works
  4. Transparency and Overhead Projector
  5.  LCD Projector in order to show one screen to entire class.
  6. Construction paper, oak tag, scissors, markers, glue.

Development and Pivotal Question:

           a.                  Students at this point will be asked to              write down three reasons why by analyzing             the attendance of the school they will create a better community/school.

  1. b.                  What’s the difference between a Bar graph and a histogram?
  2. c.                  Why are some graphs better than others to represent data?
  3. d.                  What should we use to graph the attendance?
  4. e.                  What’s the difference between analysis and predictions?
  5. f.                    How do we analyze a set of data?

Possible questions to ask when we analyze data:     

      1. 1.      Why do some months have a higher attendance?
      2. 2.      Does the weather have an influence on attendance?

3.  Is this the beginning or the end of the school year?

  1. g.                  How do we make predictions?

Possible questions to ask when we make predictions:

      1. 1.      Based on the data what can we expect for the future?
      2. 2.      Is the end of the year going to affect attendance?
      3. 3.      Is the nice weather going to affect attendance?

 

Instructional Format and Exploration:

            After the motivation, and the Pivotal questions, students will have a clear understanding of the project. They will understand the difference between different graphs, and between analysis and prediction.

At this point they will be separated in groups of three or four.

Each group will receive a package with instructions of how to use Power Point, Excel, and TI-83 graphing calculator.

 

Each group will terminate the work in two days.

At the end of the project each group will have:

Name of the Project

Name of students and their role in the group

Board or power point Slides with graph, predictions and analysis for each month

 The projects will be graded based on a rubric that will be attached.

---------------------------------------------------------------------- 

                  TI –83 Graphing Calculator.

 

1.               Turn on the TI-83 [Bottom left]

2.               First thing we want to do is enter the data in the calculator

                  Press STAT [1:EDIT should be highlighted, if not go to 1:EDIT]

                  Press ENTER

In order to clear all the columns go to the top of the column with the up arrow key and press CLEAR.

Press ENTER. [The all column should be clear]

Repeat for every column. Make sure they are all clear.

3.               Got to column L1

                  Enter all the data.

4.               Now is time to see mean, standard deviation and other valuable information.

                  Press STAT

                  Go to CALC

                  Press ENTER

1-Var Stats should be highlighted, if not highlight 1: 1-Var Stats

1-Var Stats shows on your display.

Press ENTER

Here you have mean, the sum of all the value, the sum square, sx [this is the standard deviation], the number of data entered if you press down arrow key you will see the Minimum, First quartile, Median, Third quartile, and finally the Maximum value.

All this information can be printed if your computer Lab has the Texas Instrument software view on the computer screen the TI-83 display.

5.               To see the histogram, scatter plot or any other graph.

                  Press 2nd

                  Press Y=

                  STATS PLOTS should come up

                  Press 1: Plot1

                  Make sure ON is highlighted, if not go on ON and press ENTER

Now you have six pictures: to choose the one that you want go on the desired one and press ENTER

From the top left: Scatter Plot, Line graph, Histogram, Box Whisker Plots, Box Whisker Plots and line graphs.

X list :L1 [L1 if the data is entered in column 1. If the data is in L2 then press L2 for Xlist]

The graph will use the highlighted MARK to show the graph.

6.               In order to see the graph

                  Press ZOOM

                  Press 9:ZoomStat

                  Press ENTER

                  Press GRAPH

You can copy or print using the software or copy the graphs

                 

 -----------------------------------------------------------------------                

                  EXCEL

 

  1. 1.                  With excel you have a lot of cells
  2. 2.                  In cell A1 you can type any information such as: Months, or the title of the project.

 

Attendance project

 

 

 

Month

Percent of students

 

 

February

 

 

 

March

 

 

 

 

 

 

 

 

  1. 3.                  Enter all the data in the cells as explained above.
  2. 4.                  At the end after all the information is entered highlight all the cells except the titles. [Only the months and the data entered for each month]
  3. 5.                  On top click the Wizard Chart. [Little button that has a little bar graph on it]
  4. 6.                  Step 1: Choose the type of graph that you want.
  5. 7.                  Click NEXT
  6. 8.                  Step 2: Data range will be shown. SERIES IN: Rows should have a mark.
  7. 9.                  Click NEXT
  8. 10.             Step 3: Fill in all the information. The Tab on top is self-explanatory. This section will give all the information on how the graph will look in terms of labels.
  9. 11.             If you make mistake you can go back at any time using the Back key.
  10. 12.             Step 4: This will decide where to place the chart.
  11. 13.             In order to make any changes double click on the graph.
  12. 14.             The data in the spreadsheet can also be printed.
  13. 15.             In order to make changes to the format of the cells:

a.         Highlight the cells

    1. b.      Go to FORMAT
    2. c.      Cells
    3. d.      Make any change that you want.

16.       To print go to FILE and PRINT.

 -------------------------------------------------------------------------------

Power Point 5.1

 

  1. 1.                  Click on Power Point Icon on your desktop.
  2. 2.                  You can create a new presentation using:
  3. a.                  Auto content wizard [This one will give you ideas how to create a presentation]
  4. b.                  Design template [Using this one you can choose from a wide range of design. Each design has a little preview.]
  5. c.                  Blank presentation [You have to create one. There is no design]

 

In this little set of instructions I will show you how to create a presentation using the design template. Understanding how to use this one will give a clear idea how to use any other one.

 

  1. 3.                  Click on design template, and a little dot will appear.
  2. 4.                  Click NEXT
  3. 5.                  Each design has a little preview on the bottom right. Choose the one that you like the most.
  4. 6.                  After you design which design you like, click NEXT
  5. 7.                  The next window you have to choose the Layout that you need.

In our case the best one will be the one that contains chart and text.

Choose the Layout that you want a press OK.

  1. 8.                  At this point you have a complete layout of your slides.
  2. 9.                  At this point the only limit is you imagination.
  3. 10.             At each slide you can right click with you mouse and you will see a variety of command that will help you customize your presentation.

----------------------------------------------------------------

Summary and Presentation:

The groups will do presentations.

Presentations will be done on the overhead projector or using the computer screen with projector.

The projects done with oak tag will be presented at the board.

 

Homework:

            Find on the web the attendance rate of two schools in the neighborhood where you live. How do they compare the attendance rate at our school?

About The Teacher

Francesco Ianni teaches mathematics at University Neighborhood High School. Francesco is always in search of new, different ways to reach “at-risk” students. His teaching integrates technology and hands-on activities, where students can really discover on their own that math is all around us. 

Together with his mentors, Francesco led a workshop at the NYU ACTIII Conference in May entitled “Electronic Communications and the 3R’s:  Reading, Writing, and Arithmetic”.  He demonstrated technology lessons and resources they developed this year to target Math and ELA performance standards. 

Email Contact: cicco@mindspring.com

Estimated Class Periods To Complete: 3-4 class periods, including 2 days in the computer lab

Subject:
Algebra, Statistics, Technology

Beginning Grade Level: 9

Ending Grade Level: 12

 

Come across an outdated link?
Please visit The Wayback Machine to find what you are looking for.

 

Journey Back to the Great Before