EdTech 541: Week 7 Spreadsheets & Databases Pt. 2 Assignments

Week 7: Spreadsheets & Databases Pt. 2

This week you will wrap-up your Spreadsheet or Database project and submit it for grading. I have also posted a few additional resources I think you will enjoy.


Resources

Some fun things to do with Excell

Spreadsheet or Database Project

You will have this entire week to wrap-up your spreadsheet or database lesson. Once it is complete, put all parts in your website and post a link to your assignment into the assignment “dropbox”.

Technology Supported Lesson Requirements and Rubric – please carefully review these prior to submission.

  1. Develop a lesson plan for a content area of your choosing that involves the use of technology.
  2. Although the technology used should be a dominant component of the lesson, technology skills instruction should not be the main focus of the lesson – the lesson should revolve around a content area standard.
  3. Your lesson should incorporate the use of identified instructional models appropriate for the technology. For example, a database lesson will typically involve fact-fact-conclusion questioning that requires students to make a decision, make a prediction, or describe an unknown. Spreadsheet lessons typically revolve around relationships, what if thinking, estimation or solving story problems.
  4. Your lesson should clearly describe how you will use the technology and what students will do.
  5. You are required to develop a sample of the application that students would develop or that the instructor would provide.
  6. The sample should incorporate advanced skills associated with the tool. I am looking for evidence that you understand how
  7. to use the tool. Include student worksheets such as question lists or conclusion worksheets. Also, include any other handouts that might be used with the lesson, such as PowerPoint presentations, instructions or online resources.
  8. Technology supported lessons encourage student-centered, constructivist instructional approaches that address higher level thinking. Keep this in mind as you develop your lesson. A lesson using technology should not revolve around fact-only worksheets and one-page essays.
Criteria Outstanding
90-100
Proficient
80-89
Basic
70-79
Below Expectations
0-69
Lesson Plan Content
Elements of the Lesson
Plan Template
AECT Standards
1.1.2.b
All elements listed in thelesson plan template are thoroughly completed. All elements listed in the lesson plan template are completed. Some of the items in the lesson plan template are incomplete. Most of the items in the
lesson plan template are incomplete.
Organization of
Content

Content of the lesson
plan.

Logical, intuitive
sequence of
information. All
information is clear and
direct.
Logical sequence of
information. Information
is clear and direct.
Some logical sequence of information. Somewhat
confusing or flawed.
Little or no logical
sequence of information.
Objectives
What the student(s) will
know and be able to do
after completing the
lesson.
AECT Standards
1.1.1.a, 1.1.1.b
Objectives for lesson areclear and realistic for the intended lesson. There is adequate
identification of
objectives for the
intended lesson.
There is some mention of objectives, but they are inadequate or incomplete for the lesson No educational objectives
or objectives that do not match the lesson.
Standards
Objectives are tied to
established content area and grade level
standards
AECT Standards
1.1.1.c
The lesson plan clearly
identifies and addresses
appropriate content
area and grade level
standards. May also
include technology
standards but these are
not the main focus of
the lesson.
The lesson addresses
appropriate content area and grade level standards but they are not clearly identified.
There is some indication
that content area
standards could be
addressed in this lesson
but the main focus is on
technology use, not
subject matter.
No content area
standards are addressed.
Activities
Tasks to be completed
during the lesson.
The detailed steps
necessary to
successfully complete
the lesson are provided.
The learning activities are presented, but some lack
sufficient detail.
The learning activities
outlined are incomplete
and some are vague and
confusing.
The learning activities are vague, confusing, and lack detail.
Materials
Attached handouts,
reports, PowerPoint,
databases,
spreadsheets, etc used
as part of the lesson.
Support materials are
attached. The materials
are high quality and
support the lesson well.
Support materials are
attached. The materials
are of good quality and
support the lesson.
Support materials are
attached. The materials
are of marginal quality or do not adequately
support the lesson.
Support materials are not attached, are of inferior quality, or do not support the lesson.
Technology
Incorporation of
technology into the
lesson.
The application tool
used in the lesson is
highly appropriate for
the subject matter.
The application tool used in the lesson is somewhat
appropriate for the
subject matter.
The application tool used in the lesson has the potential to be
appropriate for the
subject matter.
The application tool used in the lesson is not
appropriate for the
subject matter.
Skill
in using the technology.
The lesson and/or
sample indicate a high
level of skill in using
advanced features of
the application tool.
The lesson and/or sample indicate some skill in using advanced features of the application tool. The lesson and/or sample indicate very little skill in using advanced features
of the application tool.
The lesson and/or sample indicate no skill in using advanced features of the
application tool.
Instructional
Approach
Student-centered vs.
teacher-centered.
AECT Standards
1.1.2.b, 1.1.5.c, 1.3.a
The lesson incorporates
constructivist
approaches to learning.
The activities are
student-centered,
project-based, address
higher level thinking,
and use alternative
forms of assessment.
The lesson incorporates
some components of
constructivist approaches
to learning. The activities
are somewhat student centered, but may not be project-based, address higher level thinking, or use alternative
assessments.
The lesson incorporates
mostly teacher-centered approaches to learning that may address higher
level thinking with
standard forms of
assessments. (i.e. direct
instruction, lecture,
worksheets, multiple
choice tests, one-page
essays)
The lesson incorporates
only teacher-centered
approaches to learning
that address lower level
thinking with standard
forms of assessments.(i.e. direct
instruction, lecture,
worksheets, multiple
choice tests, one-page
essays)
Instructional Models
associated with
technology tools.
Clearly delineates and
incorporates the use of
identified instructional
model appropriate for
the technology.
Incorporates the use of
identified instructional
model appropriate for the technology.
Incorporates the use of
identified instructional
model but it is not
appropriate for the
technology.
Does not incorporate the use of any identified
instructional model.
Writing
Mechanics, organization
and logic
Free of grammatical or
spelling errors. Well
organized and easy to
understand.
Reminder: Here is a PDF version of this assignment project rubric.



checkmark
Week 7 Assignments
Due: 3/5/2012

  • Submit a link to the page of your website that contains your completed database or spreadsheet project to the Spreadsheet/Database Assignment Dropbox.
Advertisements
This entry was posted in EdTech 541 and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s