Educational Technology Policy, Research, & Outreach

Harford County

Technology Literacy for Administrators Workshop

Assessment and Design Strategies with Technology Tools for Improving Student Learning
July 21, 2005 Harford County

• Pre Workshop Activities
  • Please take the time to complete the 30 question Harford County Excel Profile . This will help the workshop faciliators have a better understanding of everyone's level of expertise with Excel
• Here are some readings that you might find interesting:
  • DATA: Maximize Your Mining, Part One
  • DATA: Maximize Your Mining, Part Two
• So What? [Word ... PDF]
• Improving Teaching and Learning with Data-Based Decisions: Asking the Right Questions and Acting on the Answers [Word ... PDF]
• Agenda [Word ... PDF]
• Harford County Excel Profile
• Overview [PPT]
  • Visual [Word ... PDF]
  • Visual
• Identifying Desired Results School Data Analysis through a Short Term WebQuest. [Word ... PDF]
• Excel Mini-Exercise 1 Getting Started [Word ... PDF]
• Excel Graphing Exercise [Excel]
• Variance and Standard Deviation [Word ... PDF]
• Conditional Formatting Feature [Word ... PDF]
  • JoJo Case study Excel file [Excel]
  • Tilly Case study [Excel]
  • Grade books-template [Word ... PDF]
  • Case studies to filter
    • Elem [Excel]
      • Elem Answers [Excel]
    • Elem math [Excel]
    • Elem Case Study: Combining Classes [Excel]
      • Answers [Excel]
    • High School [Excel]
      • High School-more advanced [Excel]
• Filtering (highlight- Data-Filter-AutoFilter) [Word ... PDF]
• Case Study Scenario LOOKUP and Analysis [Excel]
• How to Directions [Word ... PDF]
• Working with your data [Excel]
• Harford County Post Workshop Profile