Using Excel in the Teaching and Learning Process

Prerequisite: You must have basic computer skills to participate in this class.

Course Objective(s):

• The participant will create a chart using Microsoft Excel in order to demonstrate the ability to use technology in the teaching and learning process.
• The participant will use a scoring tool to evaluate a chart created in Microsoft Excel and use Microsoft Excel to create a chart to analyze data in order to demonstrate the ability to use technology in the teaching and learning process.
• The participant will use the database features in Microsoft Excel in order to analyze the nutritive value of foods as an example to demonstrate the ability to use technology in the teaching and learning process.
• The participant will create a simple quiz using Microsoft Excel in order to demonstrate the ability to use technology in the teaching and 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 and 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
  • Fundamental Skills Checklist
  • Maryland Teacher Technology Standards
  • BCPS Technology Skills Continuum
  • Microsoft Excel 2003 Personal Budget How To
  • Scoring Tool (Session 1, Activity 5 - Using Microsoft Excel to Create a Chart or Graph to Support the Teaching and Learning Process)
  • Microsoft Excel 2003 Hours of Sleep How To (Elementary)
  • Microsoft Excel 2003 Population Density How To (Secondary)
• Session 2
  • Scoring Tool (Session 1, Activity 5 - Using Microsoft Excel to Create a Chart or Graph to Support the Teaching and Learning Process)
  • Scoring Tool (Session 2, Activity 5 - Using Microsoft Excel to Create a Chart or Graph to Support the Teaching and Learning Process)
  • Microsoft Excel 2003 Nutrition Activity How To
  • Session 2 Activity 4 Sample
• Session 3
  • Nutrition Activity Table
  • Scoring Tool (Session 3, Activity 5 - Using Microsoft Excel to Create a Spreadsheet to Support the Teaching and Learning Process)
  • Scoring Tool (Session 3, Activity 8 - Using Microsoft Excel to Create a Spreadsheet to Support the Teaching and Learning Process)
• Session 4
  • Creating a Quiz in Microsoft Excel
  • Scoring Tool (Session 4, Activity 5 - Using Microsoft Excel to Create a Quiz to Support the Teaching and Learning Process)
  • World Cultures Quiz (Excel file)
  • Resources Quiz (Excel file)
  • Accounting Quiz (Excel file)
  • Session 4 Activity 5 Sample
• Session 5
  • Technology Skills Assessment for Microsoft Excel
  • Inservice Course Activity Template
  • Scoring Tools to Assess Student Technology Indicators

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

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