Translate
 Lesson Plan Search All Subjects Arts Classroom Management English/Language Arts Foreign Language Global Education Health/Physical Education Instructional Inquiry Mathematics Relations Service Learning Science Social Studies Special Education Technology Grade Level Elementary Middle School High School Google Search Our Site Google Search the Entire Web
 Proud New Owners of teachnet.org... We're Very Flattered... But Please Stop Copying this Site. Thank You.
 Our Lesson Plans TeachNet Curriculum Units Classroom Specials Popular Teacher Designed Activities TeachNet NYC Dirctory of Lesson Plans

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

GRANT WINNERS
 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
 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

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:

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
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?

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