Educational Technology Policy, Research, & Outreach

AAAS

DC Advancing Achievement in Technology and Science (DC ACTS)
Fellows Summer Leadership Institute

Developing Strategic Plans and Strategies to Increase Student Achievement in Science
August 15 through August 19

Day 1

• Agenda [Word ... PDF]
• Introduction [PPT]
• Graphic Organization [RTF]
• Flow Chart [JPG]
• 3_teachers_chem_graphing.xls [Excel]
• Science_grades_raw_data.xls [Excel]
• Standards Based Lesson Plans
  • Unit Planner [Word ... PDF]
  • DCPS Template [Word ... PDF]
  • Example [Word ... PDF]
  • Example Feedback [Word ... PDF]
• Better Science Lesson Plan with Standards [Word ... PDF]
• Homework: External Analysis Template [Word ... PDF]

Day 2

• Overview [PPT]
• Identifying Desired Results School Data Analysis through a Short Term WebQuest. [Word ... PDF]
• Internal Assessment [Word ... PDF]
• So What? [Word ... PDF]

Day 3

• Overview [PPT]
• AAAS Excel Profile
• Excel Mini-Exercise 1 Getting Started [Word ... PDF]
• Excel Graphing Exercise [Excel]
• Variance and Standard Deviation [Word ... PDF]
• Here are some readings that you might find interesting:
  • DATA: Maximize Your Mining, Part One
  • DATA: Maximize Your Mining, Part Two
• Improving Teaching and Learning with Data-Based Decisions: Asking the Right Questions and Acting on the Answers [Word ... PDF]

Day 4

• Overview [PPT]
• Conditional Formatting Feature [Word ... PDF]
• High School Raw Data [Excel]
• Filtering (highlight- Data-Filter-AutoFilter) [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]
• Case Study Scenario LOOKUP and Analysis [Excel]
• How to Directions [Word ... PDF]
• AAAS Post Workshop Profile
• Here are some readings that you might find interesting:
  • DATA: Maximize Your Mining, Part One
  • DATA: Maximize Your Mining, Part Two
• Improving Teaching and Learning with Data-Based Decisions: Asking the Right Questions and Acting on the Answers [Word ... PDF]

Day 5

• Overview [PPT]
• High School Raw Data [Excel]
• 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]
• Case Study Scenario LOOKUP and Analysis [Excel]
• How to Directions [Word ... PDF]
• AAAS Post Workshop Profile
• Here are some readings that you might find interesting:
  • DATA: Maximize Your Mining, Part One
  • DATA: Maximize Your Mining, Part Two
• Improving Teaching and Learning with Data-Based Decisions: Asking the Right Questions and Acting on the Answers [Word ... PDF]