MASTER TECHNOLOGY TEACHER CERTIFICATION PROGRAM

Education Service Center
Region XI

LaVonda Miller

Learner factors that may impact student learning.

Factors
Description
Advantage or Constraint
Initial Ideas for Maximizing Positive Factors or Minimizing Negative Factors
Age/Academic Range 7-8 years old

2nd Grade

 +   Students are thought to be on grade level.
Sex Distribution 50 / 50 +   Balance within class groups tends to result in less behavior problems. More opportunities to adjust seating in lab to encourage good behavior.
Developmentally Appropriate All students are developmentally advanced enough to complete this lesson.  +   Expectations for the lesson are based upon the Math and TA-Teks standards, and therefore, students should have the capacity to be successful.
Prerequisite Knowledge Basic understanding of computer use (mouse, home-row keys, how to save files) +   Students passed technology competencies exam as first grade students.
Race, Ethnic Diversity: 95% Hispanic, 5% White +   Race has no affect on the implementation of this lesson.
Disability or Impairment Learning Disabled (LD) +   Modifications of academic expectations will be made according to the terms of the student's IEP.
Related Experience Students are familiar with MS Excel from their 1st grade classes. +   Review Excel basics with students prior to completing the lesson.
Competitiveness Yes; The students always seem to see who can finish first. +   Helps to serve to keep the students on task as they work towards being the first one to finish.
Motivation for Learning Highly motivated; the students will enjoy taking something they have created using paper and pencil and converting digitally. + Students desire to use computers is a strong motivator.
Expectations from Course To understand how to create and interpret a bar graph. +   Although 2nd grade students do not take the TAKS exam, they do take six weeks benchmark exams as well as an end of year achievement exam (ITBS). Graphing is covered on the exam. This lesson will teach them how to read graphs as well as prepare them for upcoming exams.
Attitude Toward Subject Mixed; some students enjoy math while others do not.   - The addition of computer use to this lesson will serve as a motivator to those students who do not care for math.

Environmental factors that may impact adult learning.

Analyzing the environment is a means to identify the issues that will impact the (a) process of the design and production, (b) implementation, and (c) outcomes of the learning experience

Factors Description Advantage or Constraint Initial Ideas for Maximizing Positive Factors or Minimizing Negative Factors
Design and Production Factors:
Materials Required

Paper, Sample of completed graph on paper, pencils, Survey form

 

 +   These materials are currently available.
Production Equipment Available

Computer lab, LCD projector, printer, paper

 +  These are currently available.
Time for Design and Production
 5 days   - Schedule time in advance for planning activity
Department Technology Requirements
none +    
Implementation Factors:
Class Size
18 students +    
Class Period Length
1 hour, 45 minutes  +    
Time Allocation

First three days - 1 hour and 45 minutes of regular math instruction time in the regular classroom.

Remaining two days - 45 minutes in computer lab.

   - Check often for understanding and allow for independent practice
Location
Classroom and computer lab +  
Temperature
Classroom and computer lab are adequately cooled for student and teacher comfort. + NA
Noise
 Not a factor +   NA
Equipment
Classroom: ActivBoard, computer, LCD projector

Computer Lab: ActivBoard, laptop, LCD projector, student computers

 +  All needed equipment is available and functioning properly.
Outcome Factors:
State Requirements 2nd Grade Math TEKS: 111.14: 11A, 11B, 11C

TA TEKS K-2: 1A, 1B, 2A, 7A, 7B

 +  
Employer Needs
Technology integration for increased learning. + NA
Co-worker Needs
 Technology integration for increased learning. + NA

Content factors that may impact adult learning.

Analyzing the content is a means to identify in general terms the topics to be addressed in your course and to analyze these topics in terms of the perquisite sub-topics, and degree of learning difficulty

Main Topics Sub-Topics (What Is Involved In Learning Each Main Topic?) Readiness To Learn (Prerequisites Mastered) Degree of Learning Difficulty (Real / Imagined) Possible Instructional Strategies to Reduce or Manage Learning Difficulty
STUDENTS        
1. Conduct a classroom survey to collect data.

1. Create questions to obtain information to complete an assigned survey.

2. Ask appropriate question to complete survey form.

3. Tally results of completed survey into specified categories.

 The students have the ability to write and add the tally marks that they will make when conducting their classroom survey. Moderate Provide a form for students to set up their classroom surveys.
2. Create, read and interpret a bar graph using pencil and paper.

1. Identify the X and Y axis of a graph and understand how they are used.

2. Identify how and where survey data should be placed on a bar graph.

3. Independently create a bar graph on paper.

The students will need instruction in understanding how a graph is constructed and how the data is placed on it to represent their survey. High  Use the ActivBoard to demonstrate how to create a graph on paper, as well as provide explanation of the design of a bar graph.
3. Use the data presented in the bar graph to ask and answer question about the data contained on the bar graph.

1. Demonstrate an understanding of the meaning of numbers on a bar graph.

 The students will need instruction on how to analyze their completed graph in order to ask and answer questions about the data. Moderate Model how to ask and answer appropriate questions about data.
4. Use the Chart Wizard tool in MS Excel to create a bar graph based upon data collected in a classroom survey. 1. Demonstrate an understanding of the data contained in rows and columns of a spreadsheet program when creating a graph. Students will need instruction on entering data appropriately into rows and columns to create a graph using MS Excel. Additionally they will need instruction on how to use the Chart Wizard. Low Demonstrate how to enter survey data into MS Excel as well as how to use the Chart Wizard to create bar graph.
TEACHER        
5. Gain understanding of how a spreadsheet software program can be used to enhance instruction in mathematics. 1. Develop math lessons plans that will utilized different features of MS Excel to support instruction in mathematics. Teacher has had some training using MS Excel. She needs additional support on how to use formulas, macros and other features of the software program. Moderate Provide samples of lesson plans that utilize MS Excel to support mathematic instruction.
6. Develop a comfort level using technological tools that technology-infused lessons will be created on a regular basis. 1. Complete practice exercises using MS Office Suite to increase comfort-level of software application and to support the decision-making process of appropriate software selection when creating lesson plans. Teacher has basic knowledge of the MS Office Suite. She needs more advanced training in order to support the decision-making process of when it would be appropriate to use the software products contained in the Office Suite to support instruction. Moderate Provide multiple tutoring sessions to allow teacher to practice and increase comfort level using different software products.