Unit 09: Integrating Spreadsheets into Student Learning

Topic outline

• 

  Unit 9: Integrating Spreadsheets into Student Learning

  
  

  • Announcements Forum
• 

  Unit Introduction

  • In this unit we will use a spreadsheet package, MS Excel, and investigate ways students might use the package to learn. Our task will be to determine how students might harness technology, in this instance spreadsheets, to demonstrate that they have acquired a competency, knowledge or values as outlined in the curriculum? We can't provide lesson plans for every subject or grade so we will showcase a few examples and then challenge you to think how the software might be used in your classes and share your ideas with others.

    By the end of the lesson you should be able to the following:

    
    

    Select at least one of the links below to start your lesson. Even if these are not your subject see if the lesson plans spark an idea about how this tool could be used in your subject or grade.
    

  • Spreadsheets in Natural Sciences Lesson
  • Spreadsheets for Languages Lesson
  • Technical Skills

    Feel you need better spreadsheet technical skills? This lesson focuses on the integration of spreadsheets into teaching and learning and assumes you have mastered the basic skills. If you feel you need more practice use the tutorial resources below.
    

  • GLC LearnFree. (2017). Tutorial: Excel 2016. Goodwill Community Foundation URL
  • Microsoft. (2017). Excel Help Centre URL
• 

  Assessment instructions

  • 
    

    Use the assignment submission tool below to upload a lesson plan, created in a word processor, describing how you would use a spreadsheet program to encourage learners to master one of the curriculum skills. This document will become part of your e-portfolio.
    

  • Lesson plan that uses a spreadsheet program Assignment
• 

  Attribution & References

  • Attribution (Open Educational Resources)

    • Allen, A. (2008). Graphs Galore. LEARN NC. . Available online at http://www.learnnc.org/lp/pages/3301 
    • Blevins, S. (2008). Planets' Relative Gravity Spreadsheet. LEARN NC. . Available online at http://www.learnnc.org/lp/pages/3279
    • Munk, T. (2008). Grammar Scramblers, Spreadsheets, and Parts of Speech. LEARN NC. . Available online at http://www.learnnc.org/lp/pages/3328

    • Murray, J. (2011). How to Use Excel to Teach Math Arrays. Ask-a-Teacher. . Available online at http://askatechteacher.com/2011/10/06/how-to-use-excel-to-teach-math-arrays/

    Open Images

    • Schwarzer, K. (2011). Planet Surreal. Flickr. . Available online at https://www.flickr.com/photos/postsumptio/5442540195 
    • Thielan, A. (2007). Spreadsheet. Flickr. . Available online at https://www.flickr.com/photos/mag/352840656
      

    References

    • GLCLearnFree. (2017). Tutorial: Excel 2016. Goodwill Community Foundation. (C) Free to use. Available online at http://www.gcflearnfree.org/excel2016/
    • Microsoft. (2017). Excel Help Desk. (C). Available online at https://support.office.com/en-US/Excel
      
• 

  License

  • 
    
    This unit on Integrating Spreadsheets into Student Learning, part of the Teachers' ICT Integration Course by Matthew Goniwe School of Leadership and Governance is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License with the exception of the following resources:

    GLCLearnFree. (2017). Tutorial: Excel 2016. Goodwill Community Foundation.
    Microsoft. (2017). Excel Help Centre
    
    All content not licensed under a Creative Commons license is all rights reserved, and you must request permission from the copyright owner to use this material.