ED 566L Spreadsheets in Education
Course Syllabus
Credits: 1 Instructor: Melissa Reese, 835-3066
melissa_reese@valdez.ccDate: March 2, 2007 Cost: $125.00 Course Description:
This course is tailored to educational uses of Microsoft Excel. MS Excel for Education explores practical spreadsheet applications encountered by teachers. Students will learn advanced features of MS Excel to maximize their productivity and to manage student data.
Student Learning Outcomes:
Students will use problem solving skills and acquired MS Excel knowledge to determine the best formulas and layouts for educational spreadsheets. Formula considerations include creating custom formulas and using built-in functions. Page layout considerations include column and row formats, charts, graphic elements, and hypermedia. Students will demonstrate usage of the MS Excel menu bar, ruler, and button bars.
Student Learning Outcomes
Link to PWSCC General Education Outcomes**
Assessment Methods
Upon successful course completion, the student will:
Contributes to student achievement of the following General Education Outcome(s):
This Outcome will be assessed by one or more of the following:
Create and format a spreadsheet.
Outcome 6a
Project
Create formulas and functions.
Outcome 2a
Project
Create charts.
Outcome 2a
Project
Format cells.
Outcome 6a
Project
Design a classroom project.
Outcome 2c
Project
Course Text, Required and Suggested Materials:
Teacher handouts
Evaluation and Grade Determination:
Lab Activities 50%
Project for Students 25%
Final Teacher Project 25%Content Outline:
- Create and format worksheets
- Insert formulas and functions
- Create charts and objects
- Apply cell formats
- Import and export data
- Design a student project
- Design a teacher project
VHS Course Pages
