Prerequisite: Using Excel in the Teaching and Learning Process

Course Objectives:

• 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

---

View a complete listing of all technology integration inservice courses and register online at: https://www.bcps.org/apps/registration/.

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

Back to Technology Integration Inservice Courses Page