|
Description:
Designed for those who are unfamiliar with spreadsheet programs, this class covers basic Excel functionality, including simple math formulas, formatting and the chart wizard. We focus on classroom projects and applications, especially activities your students can do with Excel. The course aims to provide a sufficient foundation in Excel, so that participants feel comfortable showing students how to use it, and assigning projects that use Excel as a tool to help students develop critical thinking skills and enhance their learning of curriculum standards.
Pre-requisites:
Basic computer skills; no prior experience with Excel or other spreadsheets is expected.
Skill Level:
Some Computer Experience
Type of course:
In Person
Learning Outcomes:
Participants will be able to:
- Design an assignment that utilizes proven teaching and learning strategies and uses Excel to support student achievement of a curriculum-based learning goal.
- Help their students use higher order thinking skills to analyze spreadsheet data and make inferences and conclusions.
- Help their students enter basic math formulas, format the spreadsheet and use the chart wizard to create a graph or chart.
- Help their students use efficiency features such as AutoFill and other shortcuts.
Online Materials:
Course Lesson Plan with Materials
Credit:
1 hour USOE credit
1 semester hour SUU credit
Points:
14 licensure points
Assignment:
Create a student project that involves your students in the use of Excel. Create a sample product (what you expect your students to produce upon completion of the project). In one page or less, describe how you would include this project in your curriculum, and what curriculum objective it would help students to learn.
This class meets the following NETS for teachers:
I. B
II. A,
III. A,
III. B,
III. C,
IV. A,
IV. B,
V. C,
VI. A,
VI. B
|
