State Economy Chart
Payette School District
Content Area Objectives Addressed:
Students will research and record statistics on the economy of an assigned state.
Students will create a spreadsheet in Excel to report the data.
Students will create a 3D Pie graph using the Chart Wizard in Excel to represent their states’ data.
Addressed: Spreadsheet model showing a relationship
What was the process that your students went through to complete this lesson?
Anticipatory set (Smart Board and Projector) “Creating a simple spreadsheet using Excel”.(10 minutes).
Students worked on their game boards or other State Fair projects while one group at a time is cycled through the computers to create their spreadsheet and graph.
Students continued cycling through the computers until each group had a turn on the computer and had successfully created a graph.
Students compared and contrasted their graph by discussing the similarities and differences and formed a hypothesis on the relationship between location and economy.
How did you monitor student
I walked around the classroom observing students at the computers as well as the table groups.
Was there a template or an
example that students were expected to follow?
Yes, see attached
How much time did you
dedicate to this project?
Two 45 minute class periods
How was the final product
Students show their product in their State Fair presentation.
Who was the audience for the
Teacher, classmates, family, guests
What prior knowledge was required on the part of the students in order for them to be successful in this project? (include curriculum and technology knowledge)
Ability to research information from a encyclopedia article, and make note of data.
Ability to create a new workbook in Excel, knowing basic vocabulary such as row and column, and labels
Ability to enter data using a keyboard
Ability to name and save a file
Ability to print a file
What was the student to
Five computers to one student
How did you schedule your
students’ computer time?
I used stations. Students were busy with other “State Fair” related activities while they waited to cycle through the computer station.
What was the location of the
computers and other technology equipment used by students?
In the classroom
How would you suggest beginning teachers obtain computer resources for their students? (Knowing some of your strategies would be valuable for our pre-service teachers.) Beg, write grants, beg again, offer to partner with someone that has computers in their classroom, did I mention begging?
Rate the level of access for
students to use computers/other technologies as they needed
--high, medium, low
Rate the level of
supervision required for students during the project, specifically for computer
and other technology use –high, medium, low
What hardware was required for your project?
Five P. C. Computers, and a network printer, with the bonus of a projector to show the class how to do the activity first.
What software was required for your project?
Microsoft Excel (Microsoft Works would do also)
Construction paper, art supplies, a set of encyclopedias
What kind of assessment did you use for this
project? (Include a copy if you can.)
I would judge the final product produced in the activity.
What categories did you
assess? (I.e.: content, screen
design, depth/breadth, etc)
Content, color, and layout
How does the product that you submitted
compare with other students’ products for this same project?
What did you like best about this project?
I really like the fact that the students began to help each other, and even repeat what I modeled in the classroom! I love it when they use the same type of questioning strategies to help students complete the task at hand!
What did the students like
best about this project?
The students enjoyed playing other student-designed board games, and they loved creating charts using the chart wizard! Many wanted to customize their color choice further.
Rank the level of student
involvement in this project –high, medium, low
Rank the level of student
interest in this project –high, medium, low
Would you teach this lesson
Yes, this is a wonderful lesson, and we will do it again on a higher level before we present “State Fair”