Using Advanced Excel in the Teaching and Learning Process

Prerequisite: Using Excel in the Teaching and Learning Process

Course Objective(s):

• The participant will create a gradebook using Microsoft Excel in order to demonstrate the ability to use technology to support the teaching/learning process.
• The participant will create a chart and a quiz using Microsoft Excel in order to demonstrate the ability to use technology to support the teaching/learning process.
• The participant will create problem solving activities using Microsoft Excel in order to demonstrate the ability to use technology to support the teaching/learning process.
• The participant will create a technology integrated learning activity and a scoring tool incorporating Microsoft Excel in order to demonstrate the ability to use technology in the teaching/learning process.
• The participant will share with other participants a technology integrated learning activity and a scoring tool incorporating Microsoft Excel in order to demonstrate the ability to use technology in the teaching/learning process.

Resources:

• Session 1
  • Microsoft Excel 2003 Window
  • Using Microsoft Excel 2003
  • Importing Graphics into Microsoft Excel 2003
  • Using Microsoft Excel 2003 as a Database
  • Using the Chart Wizard in Microsoft Excel 2003
  • Technology Skills Assessment for Microsoft Excel
  • Gradebook Skills
  • Maryland Teacher Technology Standards
  • BCPS Technology Skills Continuum
  • BCPS Educational Technology Learning Goals and Indicators PreK-12
  • How to Create a Gradebook in Microsoft Excel 2003
  • Gradebook Sheet 1
  • Gradebook Sheet 2
  • Scoring Tool
• Session 2
  • Accounting Quiz (Excel file)
  • World Cultures Quiz (Excel file)
  • Resources Quiz (Excel file)
  • How to Create a Quiz in Microsoft Excel 2003
  • Scoring Tool
• Session 3
  • Loan Calculator (Excel file)
  • School Fair (Excel file)
  • Black Death Problem and Answer (Excel file)
  • Black Death Problem Worksheet
  • Multiple Mania (Excel file)
  • How to Create Multiple Mania
  • Scoring Tool
• Session 4
  • Inservice Activity Template
  • Scoring Tools to Assess Student Technology Indicators
  • Population Density Prototype (Excel file)
  • Scoring Tool
• Session 5
  • Inservice Activity Template
  • Scoring Tools to Assess Student Technology Indicators
  • Scoring Tool (Session 4)
  • Technology Skills Assessment for Microsoft Excel

Professional development for technology literacy and technology integration is provided by the Office of Instructional Technology, Baltimore County Public Schools.