Constructing a Bar Graph in Microsoft Excel

1
Constructing a Bar Graph in Microsoft Excel

• By MaryFrances McLoryd
• Joyce Kilmer School
• Mahwah, NJ

2
Components Of Lesson

• TARGET audience-5th grade math students
• LESSON outcome-students will increase their
  knowledge of technology and how it can be used to
  report information.
• SPECIFIC content-groups of students will
  construct a bar graph using Microsoft excel.

3
Gregorc Learning Styles

• Concrete Sequential
• Gathering the Data
• Charting the Data
• Concrete Random
• Math Statements
• Gathering the Data
• Finding Sources

• Abstract Sequential
• Presentation
• Math statements
• Sources
• Abstract Random
• Presentation
• sources
• Charting the Data

4
TECHNOLOGY

• TVScan with Computer
• Use the Website to compare data to other students
• Microsoft Excel to graph data

• Use this technology to explain Excel to the total
  group
• Navigation through this website allows students
  to compare data
• Here students graph their results

5
PRIMACY-RECENCYEffect

• The retention of knowledge depends on the length
  of the Learning Episode as well as the Teaching
  Method-Sousa
• Prime-time 1
  10 Min..
• New Information
• Down-time
  10 Min.
• Practice
• Prime-time 2
  10 Min.
• Closure
  10 Min.

6
SENSE AND MEANING

• The graphing of the data in the MMs project has
  SENSE for the student in that it allows him/her
  to see very quickly the results of their
  findings.
• The student, being a consumer, finds MEANING in
  the lesson because this is a product that he/she
  consumes, and they feel a sense of ownership

7
INFORMATION PROCESSING MODEL

• External Environment
• 95 of all information is received through
  our senses
• Working Memory
• Focuses on chunking information
• Long-Term Storage
• A learning Episode must have these components
  in order to end up in Long-Term Storage

8
Bibliography

• Sousa, Dr. David A., How the brain learns, A
  classroom teachers guide. Virginia the national
  association of secondary school principals, 1995
• Silver, H., Strong, R., Perini, M., Integrating
  learning styles and multiple intelligences.
  Educational leadership/September 1997
• The first seven,. Educational
  leadership/September 1997