Transcript Creating Graphs with Excel - NWACC

Instructor: Barbara Rademacher
By: Wendy Bailey
Brief History
 Fifth grade students from Russell Jones Elementary, in
Rogers, AR, were given the opportunity to integrate
technology as they applied math concepts Students
collected their own data and evaluated the data using Excel
computer software to create graphs.
 Before using computer techn0logy, the students collected
data sets and evaluated using low tech methods. Graphs
were generated by hand.
Goals:
 To enhance the students’ knowledge of graph making
through technology, particularly Microsoft Excel
 To help students’ better understand the application of
graphing with technology
Community Benefits:
 My community is the business community.
 By introducing 5th grade students to the Excel program and
teaching them how to create graphs using technology, I have
helped prepare them to be assets to the business community
that they live in by introducing them to the importance of
data analysis, correct presentation of data, and familiarizing
them with computer program widely used in businesses.
Course Content:
Graphs and Tables:
 Frequency tables, histograms, and distribution polygons of
favorites, income and age data.
 Pie charts or favorites, age, and income data with
analyses.
 Mean, median, mode, range and midrange of three data
sets.
Statistics – applied equations:
 Standard Deviations of three data sets
 Linear, quadratic and cubic regression data of favorites vs.
income and favorites vs. age data with
correlation coefficient.
 Included discussion of correlational coefficient: r .
Methods
I.
Coordinate with teacher at Elementary School
II.
Assessed needs of students
III.
Developed activities to engage students in learning of course
content
IV.
Review of previously mastered skills
gathering data
recording data analyzing data
V.
Facilitate in hands on activity
VI.
Review skills learned
Timeline – managing the project
 January: researched topic and studied different graphs
 February:
1) collaborated with Mrs. Sweeney concerning 5th SLE
2) discussed extended learning opportunities
3) organized materials, time and implementation of
lesson
 March- April: compiling information from collaboration
with teacher, implementation of lesson, and create
presentation
Technology
Computer
MS Excel
Digital camera
Printer
Pencil/paper
Line Graphs
Plain vs. Peanut M&M
50
45
40
35
30
25
Peanut
20
Plain
15
10
5
0
1
2
3
4
BarValentine
Graphs
Colored M&Ms
Ernesto, Selene, Brandon
Valentine Colored M&Ms
Plain vs. Peanut M&M Mary,
100
80
Oscar, Jessica
red
601450
white
401240
hot pink
10
20 830
6
0 20
4
210
0
0Plain
light pink
Series1
red
Series2
Series3
Orange
21
Red
31
Brown
29
81
Histograms
Peanut
Plain M&M Color Frequency
45 45
40 40
35 35
30 30
25 25
20 20
yellow
yellow
15 15
10 10
5 5
0 0
blue
blue
brown
brown
red
red
orange
orange
green
green
brown
brown
blue
blue
green
green
orange
orange
red
red
yellow
yellow
Distribution Polygons
M&M Distribution
45
41
40
35
yellow
30
30
25
20
23
red
orange
22
18
green
15
14
10
blue
brown
5
0
yellow
red
orange
green
blue
brown
Pie Graphs
M&M Valentine Colors
15, 20%
23, 30%
Red
White
Light Pink
Hot pink
11, 14%
27, 36%
Regression Line
Is 5th Grade Student M&M Color Preference a
Color Frequency Preferance
Function of Age?
725
675
y = -3.7641x + 600
R = -0.2579
Poor negative correlation
625
575
525
475
425
125
130
135
140
145
Students' Ages in Months
150
155
Statistics
Total
Mean
Median
Mode
St. Dev.
M&M Color Stats
327
21.8
22
23
7.55
45
Pl. orange, 41
type/color/number of M&M's
40
35
30
Pl. green, 30
25
Pl. red, 23
20
Pl. light pink, 28
Pl. blue, 22
Pt red, 29
Pl. white, 23
Pt blue, 22
Pt yellow, 20
Pl. yellow, 18
Pl. hot pink, 17
15
Pl. brown, 14
Pt orange, 14
Pt green, 11
10
Series1
Pt brown, 15
5
0
0
2
4
6
8
10
12
14
16
Skills Acquired
• Learned to think
mathematically, and use core
concepts of class.
• Oral and Written
Communication
• Working with Peers:
Team Building
Cooperation
• Responsibility
• Time Management and
Organization
• Networking:
Within and Outside the
NWACC Community
• Over all Professional
Enrichment
Academia
Technology
• Service to the Community
OUTCOMES / RESULTS
Student application of learning
Community Contacts
 Dianne Philips – EAST Lab Coordinator

 Barbara Rademacher – Math Instructor NWACC
 Mary Sweeney – 5th grade teacher Jones Elementary
 Kim Staab (NBPTS) – 2nd grade teacher Jones Elementary
 Ozark Natural Science Center
 Arkansas Game and Fish Commission
Future Projects
•Students could continue to explore presenting data
they collect with various other graphs with the new
MS Excel technology they have just learned.
•Students could graph grades, past and present
scores from standardized testing using the new MS
Excel technology they have just learned.
•Go online and look up project with Excel for 5th grade
students
Helping shape the futures
of tomorrow by investing
in lives today…….
Presenting our future
leaders and business
people of our community!