Lesson for making charts in Excel
UBD Lesson Plan
Todd Hamontree
Title of Unit Making charts Grade Level Teachers
in Excel
Standard: NETS
• Teachers demonstrate a sound understanding of technology
operations and concepts. Teachers:
A. Demonstrate introductory knowledge, skills, and understanding of concepts
related to technology.
• Teachers plan and design effective learning environments and
experiences supported by technology. Teachers:
A. Design developmentally appropriate learning opportunities that apply
technology-enhanced instructional strategies to support the diverse needs of
learners.
• Teachers implement curriculum plans, which include methods and
strategies for applying technology to maximize student learning.
Teachers:
C. Apply technology to develop students' higher order skills and creativity.
Understandings:
1) Where can teachers find things to add to lessons?
2) Where can teachers find Excel charts?
3) What can Excel do to build lessons that are engaging?
Related Misconceptions:
1) Excel is too complicated for me (teachers).
2) It takes too much time to make charts in Excel.
Essential Questions:
Overarching Questions: Topical Questions:
1) Can you create engaging 1) How can charts enhance your
lessons using Excel chart student’s work?
maker for your students?
2) What can the charts do to help
2) Can you create charts for your students understand your
lessons to create more student lesson better?
engagement?
Stage 3: Plan Learning Experiences
Agenda
• The instructor will first open up by welcoming everyone to the seminar. (H, T)
Notes to the Instructor
Use this area, if needed, to explain to the instructor how your planned
activities above satisfy specific elements of the scoring rubric.
WHERETO is denoted in the plans above using the following codes:
W- Where the unit is going, Why it is going there, What is required
H- Hooks
E- Explorations and Experiences, Equip for performance task
R- Rethink, Rehearse, Revise, and Refine
E2- Self Evaluation
T- Tailored to learners
O- Organized
Unit Understandings are denoted in plans above using the following codes:
U1- Understanding #1: Knowing that creating charts in Excel does not
have to be as intimidating as they think.
U2- Understanding #2: Knowing how easy it is to make a chart and to
put into lessons to help the engagement of lessons for their students is
quick and easy.
U3- Understanding #3: Knowing how to change a chart to meet the
needs of the lesson is quick and easy.
The Elements of the NETS standards are denoted in plans above using the
following codes:
A- Demonstrate introductory knowledge, skills, and understanding of concepts related to
technology.
B- Design developmentally appropriate learning opportunities that apply technology-enhanced
instructional strategies to support the diverse needs of learners.
C- Apply technology to develop students' higher order skills and creativity.
UbD Stage 2 Template
Stage 2 – Determine Acceptable Evidence
Title of Lesson on Making Grade Teachers
Unit charts in Excel Level
Stage 1 – Identify Desired Results
List the understandings of your unit:
Students will understand that:
1) Creating lessons using the Excel charts is not as intimidating as
they think.
2) Putting in charts into lessons can increase the level of
engagement for their lessons.
3) That there are many chart they can create and use in Excel to
enhance their lessons.
Related Misconceptions:
1) That word is the only office product to use to create lessons.
2) Charts are too difficult to learn how to put into lessons.
Essential Questions
(copy and paste from Stage 1)
Overarching Questions: Topical Questions:
1) Can you create more 3) How can charts enhance your
engaging lessons using student’s work?
charts?
1) What can the charts do to
2) Can you create charts in Excel help your students
quickly and easily? understand your lesson
better?
Stage 2 - Evidence
Performance Task(s)
Be sure to indicate:
Goal: To teach teachers how to be comfortable using the Excel to create charts
to help create engaging lessons for their students.
Role: The instructor will be the mediator between using the program and the
teachers at the seminar.
Audience: Teachers of all grades and subjects.
Situation: The teachers want to learn how to use the Excel program to create
charts for themselves as well as to put into lessons.
Product Performance and Purpose: To teach teachers to be comfortable
using the Excel program on their own to create charts to help create engaging
lessons for their students.
Standards and Criteria for Success: The teachers will be able create a chart
using the Excel program, and implement the chart in a lesson.
Student Self-Assessment and Reflection
The teachers will create a chart to be put into a lesson for their classroom,
and send it to the instructor for commenting within 2 weeks of this
seminar. The teachers will ask the instructor any question they have or
concerns they ran into. The teacher will write comments on how their
experience went on make their chart for the instructor to look over and
comment on.
