1. Topic-
|
Solar System-
Students will be collecting, analyzing, and recording data about the
Solar System, through the use of electronic sources. Students will
demonstrate knowledge of the use of the computer, programs, and applications,
while collaborating and problem solving. |
| |
|
2. Content-
|
Massachusetts Curriculum Frameworks- Technology
Grades 6-8:
1.13 Create an original spreadsheet, using formulas
1.14 Use various number formats (e.g., scientific notation, percentages,
exponents) as appropriate.
1.15 Produce simple charts and graphs from a spreadsheet.
1.18 Use Web browsing to access information (e.g., enter a URL, access
links, create
bookmarks/favorites, print Web pages).
1.23 Use e-mail functions and features (e.g., replying, forwarding,
attachments, subject lines,
signature, and address book.)
3.2 Collect, organize, and analyze digital information from a variety
of sources, with attribution.
3.5 Use and modify databases and spreadsheets to analyze data and
propose solutions.
3.9 Use a variety of telecommunication tools (e.g., e-mail, discussion
groups, Web pages, blogs,
Web conferences) to collaborate and communicate with peers, experts,
and other audiences
(at district's discretion).
10. Compare and contrast properties and
conditions of objects in the solar system
(i.e., sun, planets, and moons) to those on
Earth (i.e., gravitational force, distance
from the sun, speed, movement,
temperature, and atmospheric conditions) |
| |
|
3. Goals: Aims/Outcomes-
|
1. to successfully create spreadsheets and utilize sum and average
functions
2. to be able to research for data using select electronic resources
3. to successfully collect mandatory data while understanding parts
of the solar system
4. to be able to collaborative with other students
5. to be able to communicate with the teacher and other students through
the use of electronic sources |
| |
|
|
4. Objectives-
|
1. Students will be able to develop a spreadsheet.
2. Students will be able to utilize certain spreadsheet functions.
3. Students will gather information through selected electronic resources.
4. Students will collaborate with other students.
5. Students will learn about the solar system.
6. Students will communicate with the teacher and other students using
electronic sources. |
| |
|
5. Materials and Aids-
|
Students will be using computers or i-Pad in the teacher's computer
lab, along with the Smart Board for information.
Students will be utilizing Microsoft Excel to develop spreadsheets
with the data they obtain and Microsoft Word to record ideas or information.
Students will be utilizing the Internet to obtain data.
Students will be emailing information to the teacher and peers through
Microsoft Outlook and using Twiducate to reflect.
Students will have access to the Share Drive to view information that's
provided to them by the teacher, including websites and the rubric. |
| |
|
6. Procedures/Methods-
|
|
A. Introduction-
1. To begin the project, the class would have a discussion about
what they've learned about the Earth and Solar System.
2. Next we would open Excel and recap how to use the necessary tools
and functions, with a student using the Smart Board to review for
the class.
3. I would then discuss a rubric and show them what I developed. I
would then ask if anyone would like to add or potentially change something
on it.
4. Students would choose one partner for the project. |
| |
|
|
B. Development-
1. The class would begin by having a discussion about spreadsheets,
with me asking the students if they remember how to use them and certain
functions of it.
2. Together as a class we'd create a sample spreadsheet, during which
discussion and questions would take place.
3. As a class, we'd have a review of how to use the sum and average
functions. |
| |
|
|
C. Practice-
1. With a partner, students will create a spreadsheet based on the
Solar System.
2. While doing the assignment, students will be able to ask me questions
or I encourage them to ask the people around them.
3. I'd remind students to cite their resources. |
| |
|
|
D. Independent Practice-
1. Using the spreadsheet the students and I created as a reference,
students will practice the sum and average functions on their own
spreadsheets.
2. I'd remind students to cite their resources. |
| |
|
|
E. Accommodations (Differentiated Instruction)-
1. Students on IEPs will have accommodations.
2. I'd allow students to check their work using a calculator for students
who are lower level or who need to.
3. If an aide is available, I'd have one in the classroom to help
students with myself.
4. I'd provide low lever students additional information about the
Solar System. |
| |
|
|
F. Checking for understanding-
1. Students will have the opportunity to present information if
they'd like to. Additional points would be given.
2. All students would email me their spreadsheets and I'd post them
to the Share Drive for all to see.
3. Students will access themselves and students will be able to ask
questions after viewing others' spreadsheets on the Share Drive. |
| |
|
|
G. Closure-
1. Students will answer a question or two on Twiducate that I ask
them.
2. Students will give a final reflection through email to me. |
| |
|
7. Evaluation-
|
1. Students will be evaluated using a rubric.
2. A graded rubric with necessary comments would be provided to them
through email after the project is completed. |
| |
|
8. Teacher Reflection-
|
| A graded rubric with necessary comments and feedback would be provided
to them through email after the project is completed. |
| |
|