|
 Lesson
IV-Spreadsheet
Objectives
~ NJ Curriculum Standards ~ Subject
Areas ~ Materials ~ Procedures/Activities
~ Assessment ~ References
Lesson
ILesson
IILesson
IIILesson
V
Objectives:
Top of Page
1. Students will create a spreadsheet using the research information
about their endangered animal that will include at least one function.
2. Students will create a chart in Excel.
NJ
Core Curriculum Content Standards:
Top of Page
Cross-Content Workplace Readiness
Standard 2: All students will use technology, information and other tools.
Standard 3: All students will use critical thinking, decision-making,
and problem solving skills.
Standard 4: All students will demonstrate self-management skills
Language Arts Literacy
Standard 3.1-All students will understand and apply the knowledge of sounds,
letters, and words in written English to become independent and fluent
readers, and will read a variety of materials and texts with fluency and
comprehension.
Standard 3.2-All students will write in a clear, concise, organized language
that varies in content and form for different audiences and purposes.
Math
Standard 4.1-All students will develop number sense and will perform standard
numerical operations and estimations on all types of numbers in a variety
of ways.
Standard 4.4-All students will develop an understanding of the concepts
and techniques of data analysis, probability, and discrete mathematics,
and will use them to model situations, solve problems, and analyze and
draw appropriate inferences from data.
Technology
Standard 8.1-All students will use (technology skills and tools) computer
applications to gather and organize information and to solve problems.
Subject
Areas: Top
of Page
Math, Language Arts and Technology
Materials/Software
Needed: Top
of Page
1. Computer lab
2. Microsoft Excel
3. Access reports from each student’s animal, enough for the whole
class
4. Spreadsheet question handouts
Procedures/Activities:
Top
of Page
1. Instruct the students on how to create a spreadsheet and chart and
using Excel.
2. Distribute the endangered animal Access reports to the students. Each
student should have one Access report for each animal.
3. Students will enter the data from the following fields in the spreadsheet-name
of animal, the number of animals existing, average lifespan and the location.
4. Next, students will format the spreadsheets by changing the font style
and size, background, etc.
5. Students will complete the lesson by creating a chart. The chart is
to be named and labeled.
6. Divide the students into groups and have them work together to answer
the spreadsheet question handout.
7. Students will then share their answers with the class.
Assessment:
Top of Page
Students will be assessed using the Spreadsheet
and Chart Rubric.
References:
Top of Page
Students will use the information they have obtained from Lesson
III.
|
|
