| |
Description:
Designed with classroom use in mind, this course offers introductory training on Excel, PowerPoint, and Publisher, with some tips for maximizing your use of Word. Participants accumulate a “portfolio” of instructional plans that include sample student assignments or products created with Office software for use in the classroom. Software skills are presented in a context of strategies for effective educational application, and many examples of project-based learning and constructivist teaching are included. Together, participants discuss and explore all aspects of the learning process from setting the stage for learning through assessing students’ understanding. We encourage participants to come with core standards on which to base their instructional plans, and to incorporate critical thinking strategies and Internet resources along with the Office products in their activities.
Pre-requisites:
Basic computer skills such as copy/cut/paste and save.
Skill Level:
Little Computer Experience
Type of course:
In Person
Learning Outcomes:
- Design an assignment that utilizes proven teaching and learning strategies and uses Office products to support student achievement of a curriculum-based learning goal.
- Demonstrate understanding of at least one strategy to use Office products to assess student learning.
- Evaluate student projects using a rubric.
- Excel skills: enter basic math formulas, format a spreadsheet, use the chart wizard to create a graph or chart, use efficiency features such as AutoFill and other shortcuts.
- PowerPoint skills: create slides of different formats, use drawing tools and templates, insert text, images, hyperlinks, audio and video.
- Publisher skills: use wizards to create and then customize graphically enhanced documents.
- Word skills: review efficiency features such as key stroke commands, learn to make and insert screen captures into Word documents.
Things to bring:
Materials for note-taking and a blank CD or USB drive for saving materials.
Credit:
2 hour USOE credit
2 semester hour SUU credit
Points:
28 licensure points
Assignment:
Develop one or more instructional plans that have clearly stated state core learning goals. (One plan may incorporate all the products, or several unrelated plans might incorporate the products.) Use either a product you create with the software, or design an activity for students to complete that requires them to use the software in the instructional plan. Using the UEN lesson plan tool for your instructional plan(s), submit the following portfolio of items for credit:
-
If creating a single unit plan that incorporates all four products, all materials may be associated with one lesson plan. Otherwise, create a lesson plan for each different lesson that incorporates one or more of the products. The instructional plan(s) should include:
- A learning goal tied to the core curriculum.
- An outline of the plan detailed enough that the reviewer can see the context for the computer activity.
- Directions for students for the assignment/activity, OR the description of how you present your product.
- Description of how you plan to assess student learning
- For each of Word, Excel, PowerPoint and Publisher, submit a sample product you would expect to receive from students, OR the product you created for use in the lesson.
This class meets the following NETS for teachers:
I. A
I. B,
II. A,
II. D,
II. E,
III. A,
III. B,
III. C,
III. D,
IV. A,
IV. C,
V. A,
V. B,
V. C,
V. D,
VI. A,
VI. B,
VI. C
|
|
