Home
Announcements
Power School
School Calendar
Staff Directory
Activities
PTA
Library
Class Web Links
Tools
Team Pages
Lunch Menu
8th Grade ONLY!
Art Gallery
Taft Info

 



 

Microsoft Excel:  Impacting Teaching and Student Learning

 

Web-Based Materials

Day One

Day Two – Learning Theory

Day Three – Standards and Benchmarks

Day Four – Lesson Plans

 

Day One

 

Excel is Elementary

http://www.forsyth.k12.ga.us/kadkins/spreadsheet.htm

 We will use this excellent web site for several activities. Today will we look at the first 2 links:  Ten Reasons and Classroom Strategies.

 

Questions to think about as you look at the Classroom Strategies link:

  • Did you like the lessons?  Why or why not?
  • What is the teacher’s role in this lesson?
  • What is the student’s role?

 

 

Day Two – Learning Theory

 

 

General/Index Sites

Authentic Learning

Bloom

Brain Hemispheric Dominance and Learning Styles

Constructivism

Multiple Intelligences

Project-Based Learning

 

Vivisimo    Recommended Search Engine for Learning Theory

 

 

General Sites

 

Funderstanding

http://www.funderstanding.com/about_learning.cfm

Excellent site!  Great Summaries for several learning theories.

 

Learning Theories and Instructional Strategies Matrix

http://www.kihd.gmu.edu/immersion/knowledgebase/

Matrix that compares Behaviorism, Cognitivism, and Constructivism

 

Instructional Strategies from Sabine Parish School System

http://www.sabine.k12.la.us/vrschool/brainPBLinquir.htm

Links and resources for Project Based Learning, Brain Compatible Learning, Inquiry Based Learning and problem Solving approaches.

 

Authentic Learning

 

Five Standards of Authentic Instruction

http://www.ascd.org/pdi/demo/diffinstr/newmann.html

pdf format   http://www.learner.org/channel/workshops/socialstudies/pdf/session6/6.AuthenticInstruction.pdf

Well known article regarding Authentic Learning by Fred Newmann (who developed the philosophy).

 

Authentic Instruction

http://www.ncrel.org/sdrs/areas/issues/educatrs/leadrshp/le4auth.htm

Summary of Authentic Instruction by NCREL.

 

What Makes Instructional Activities Authentic?

http://www.cew.wisc.edu/mathnet/SupportFrame/authinstr.htm

This site may be useful in determining how technology can be used to enhance he learning process.

 

Providing Hands-on, Minds-on, and Authentic Learning Experiences in Science

http://www.ncrel.org/sdrs/areas/issues/content/cntareas/science/sc500.htm

This is a discussion of Authentic Instruction as used in science curriculum.

 

The Red Tail Ridge Wetlands project

http://www.ncrel.org/sdrs/areas/issues/content/cntareas/science/sc2rt.htm

An example of a project.

 

Authentic Instruction

http://labweb.education.wisc.edu/ep301/Science_Peter/authentic.htm

 

Authentic Learning and Visual Art

http://tiger.coe.missouri.edu/~vlib/mick/Mick1.html#WAL

An article discussing various aspects of Authentic Learning.

 

Bloom

 

Learning Domains or Blooms Taxonomy

http://www.nwlink.com/~donclark/hrd/bloom.html

A good summary of Bloom’s Taxonomies.

 

Benjamin Bloom

http://www.ittheory.com/bloom1.htm

Helpful charts!

 

Bloom's Taxonomy's   Model Questions and Key Words from

http://www.utexas.edu/student/utlc/handouts/1414.html

Excellent resource for terms and term to use for goals/objectives/learner outcomes. From the University of Texas at Austin

 

Taxonomy Verb List

            http://www.iloveteaching.com/steacher/verbs/taxonomy.htm

 

 

Applying Bloom’s Taxonomy

http://www.teachers.ash.org.au/researchskills/dalton.htm

Terrific site for the elementary classroom.

 

Major Categories in the Taxonomy of Educational Objectives

            http://faculty.washington.edu/krumme/guides/bloom.html

          Categories, verbs, and internet links.

 

Brain Hemispheric Dominance and Learning Styles

 

Right Brain-Left Brain

http://www.funderstanding.com/right_left_brain.cfm

Another great summary from Funderstanding.

 

Index of Learning Styles by North Carolina State University

http://www.ncsu.edu/felder-public/ILSpage.html

Links to an online assessment – try it!  As well as general information about hemisphericity.  Good resources!

 

How to Learn

http://www.howtolearn.com/personal.html#from_index_nav_tab_learningstyles

Be sure to click on the learning styles tab.  There is also a free inventory.

 

Learning Styles and Hemispheric Dominance

http://www.leapingfromthebox.com/art/kmg/learningstyles1.html

http://www.leapingfromthebox.com/art/kmg/learningstyles2.html

These articles provide good basic information.  Part 2 includes some charts that might be helpful.

 

How do People Learn

http://www.nmathletictrainers.org/howdopeoplethink.pdf

Great summary in PDF format.

 

Learning Styles

http://www.mtsu.edu/~studskl/hd/learn.html

Great information and an online assessment.

 

Brain Dominance Instrument

http://www.speakersandtraining.com/downloads/braindominance.pdf

An instrument for determining dominance.

 

The Brain Explorer

http://www.thinkquest.org/library/site_sum.html?tname=C0110299&url=C0110299/interact/interact.php%3fbrain_test

A ThinkQuest includes a section on dominance.

 

Constructivism

 

Constructivism as a Paradigm for Teaching and Learning

http://www.thirteen.org/edonline/concept2class/month2/demonstration1.html

This site is definitely worth a look. Take a look at some lesson plans designed using the Constructivism Theory.  The Middle and High school lessons also include Internet sources.  Look at all the information on the tabs:  Explanation, Demonstration, Exploration, and the KEY Principles on the Implementation tab!

 

Constructivist Model for Learning

http://www.ncrel.org/sdrs/areas/issues/content/cntareas/science/sc5model.htm

A short explanation with a summary of major points by North Central Regional Educational Laboratory.

 

How do You Use Constructivism

            http://www.spearfish.k12.sd.us/west/master/const/how.html

          A terrific site – be sure to check out the What is and the Why Use links.

 

Under Constructivism – Upgrading to a Constructivist Theory

http://www.kn.pacbell.com/wired/fil/pages/listconstrucle.html

A web quest for Constructivist Theory that is very helpful.  Some of the links are no longer active.

 

 

Constructivism

            http://www.cesa8.k12.wi.us/tlcf/constlinks

Good comparison between the traditional and constructivist classroom.  Most of the additional links on the page are dead links.

 

Learning Styles and Computer Assisted Education

http://hagar.up.ac.za/catts/learner/lindavr/home.htm

The link to Constructivism contains a summary as well as key words and phrases.

 

Constructivism Overview

http://www.uib.no/People/sinia/CSCL/HMM_Constructivism.htm

Interesting visual picture of Constructivism.

 

University of Colorado at Denver

http://carbon.cudenver.edu/~mryder/itc_data/constructivism.html

An index of sites regarding various interpretations of the Constructivism Theory.

 

Multiple Intelligences

 

Funderstanding

http://www.funderstanding.com/multiple_intelligence.cfm

Terrific summary of Gardner’s Theory.

 

Tapping into Multiple Intelligences

http://www.thirteen.org/edonline/concept2class/month1/index.html

One of the best web sites for information regarding the multiple intelligence theory.  Be sure to try the interactive at the bottom of the Explanation Tab. All the tabs have helpful information.

 

Learning Activities for the 7 Intelligences

http://www.inspiringteachers.com/tips/packet/activities.html

Great place to look for how technology can enhance learning with multiple intelligences.

 

Multiple Intelligence Profiler

http://www.new-oceans.co.uk/new/multi.htm

An interesting site with a quiz to help determine learning preferences.

 

New Horizon’s for Learning

http://www.newhorizons.org/future/Creating_the_Future/crfut_gardner.html

A short explanation by Howard Gardner of his theory.

 

New Horizon’s for Learning  - Teaching and Learning Strategies

http://www.newhorizons.org/strategies/mi/front_mi.htm

This site provides an index of articles related to Multiple Intelligences

Theory.

 

Penn State College of Education

http://www.ed.psu.edu/insys/ESD/gardner/MItheory.html

Links regarding Gardner’s theories.

 

Project-Based Learning

 

Project Based Learning

http://college.hmco.com/education/pbl/background.html

 

Project-Based Instruction Creating Excitement for Learning

http://www.nwrel.org/request/2002aug/intro.html

Good information from NW Regional Educational Laboratory.

Project-Based Learning and Information  Technologies

 

Road Ahead – Project-Based Learning

http://www.iste.org/research/roadahead/pbl.cfm

A perspective from the International Society for Technology Education (ISTE).  Scroll down the page to see the article.

 

Center for Problem-Based Learning

http://www2.imsa.edu/programs/pbl/problem.html

Good tutorial regarding project-based learning.

 

Project-Based Learning:  A Primer

http://www.techlearning.com/db_area/archives/TL/2003/01/project.html

An article from the Tech and Learning magazine

 

Instructional Strategies from Sabine Parish School System

http://www.sabine.k12.la.us/vrschool/brainPBLinquir.htm

A terrific list of web sites regarding Project-Based Learning.

 

PBLnet

http://www.pblnet.org/

Comprehensive resource.

 

 

Day Three – Standards and Benchmarks

 

Web Site – Technology Supported Lesson Plans

Boise State University – Educational Technology     http://edtech.boisestate.edu/bridges/tslessons.htm#LESSON%20PL   ANNING%20RESOURCES

o       Look through this web site for sample lessons using Excel. 

o       Questions to think about:

§         Did you like the lesson?  Why or why not?

§         What is the teacher’s role in this lesson? What is the student’s role?

How does the lesson support learning?  Which Learning Theory?

 

Standards and Benchmarks Web Sites

 

Task One – Web Sites           Task Two – State and Curriculum Web Sites

 

Task One  - Web sites:

International Society for Technology in Education  (ISTE)

http://www.iste.org/
 

National Educational Technology Standards (NETS)

http://cnets.iste.org/
http://cnets.iste.org/currstands/index.html

 

NETS – Introduction      

http://cnets.iste.org/intro.html

 

NETS  

http://cnets.iste.org/getdocs.html

print NETS standards

 

NETS

http://cnets.iste.org/currstands/

print Information Literacy standards

 

back to top

 

Task Two – Web Sites

Developing Educational Standards

http://edstandards.org/Standards.html#State

Standard links by subject, state, and state education departments.

 

Education Standards

http://www.eduscapes.com/tap/topic28.htm

Great list of web sites dealing with standards and benchmarks.

 

State Standards

http://www.statestandards.com/

Links for all states

 

National Content Standards for PreK-12 Students

http://www.uni.edu/currtech/standards.html

One of the useful features of this page are the links to the National Organizations

 

Mid-continent Research for Education and Learning

http://www.mcrel.org/standards-benchmarks/

A compilation of content standards for K-12 curriculum in both searchable and browsable formats.

 

U.S. Department of Education

http://www.ed.gov/index.jhtml?src=a

 

National Association of State Boards of Education

http://www.nasbe.org/index.html

 

American School Counselor Association
http://www.schoolcounselor.org/content.asp?contentid=173

 

back to top

 

 

Day Four – Lesson Plans using Microsoft Excel

 

 

 

Lesson Plans

Specific Lessons

Rubric Web Sites

 

Lesson Plans

 

To Excel is Elementary

http://www.forsyth.k12.ga.us/kadkins/spreadsheet.htm

This is the web site used on the first day of class.  The links for ABC’s, as well as others will lead you to lesson plans.  Timeline links can be found on the ABC page.

 

Boise State University -  Bridges Project

http://edtech.boisestate.edu/bridges/LESSON%20PLANNING%20RESOURCES

This is the web site used on the third day of class.

 

Integrating Spreadsheets in the Classroom

http://www.amphi.com/~psteffen/excel.html

 

Everyday Spreadsheets in the Classroom

http://bes.belmar.k12.nj.us/public/everyday_spreadsheets/start.htm

 

Classrooms that Excel

http://www.sabine.k12.la.us/class/excel_resources.htm

Very Comprehensive site of Excel resources!  Not all links are active

 

Microsoft Education

http://www.microsoft.com/education/LessonPlans.aspx

Microsoft Education page for Lesson plans.  Search using by selecting the Product:  Excel.

 

The Tech-Connected Teacher

http://www.esu5.org/techteacher/excel.htm

 

Spreadsheet Application from Monroe County Community Schools

Bloomington, Indiana

http://www.mccsc.edu/CAI/SD/excel/

Sample lessons for elementary, middle and high school.

 

Everyday Spreadsheets in the Classroom

http://bes.belmar.k12.nj.us/public/everyday_spreadsheets/start.htm

 

Lesson Plans that use Microsoft Excel  Office of Instructional Technology  Charleston, SC

http://www.ccsdschools.com/instructionaltechnology/webpages/lessonplans/teacherplans.htm

 

Lesson Plans from LosAngles Unified School District

http://www.lausd.k12.ca.us/lausd/offices/itd/cti/middle_school/m_mac/html/lesson_plans.html

 

Spreadsheet a Variety of Activities

http://www.fi.edu/fellows/fellow4/may99/spreadsheet.html

Details for projects including timelines, interview forms, simple graphing, Civil War &  more simple graphing, not so simple graphing, and probability.

 

Everything You Ever Wanted to Know About Spreadsheets

http://www.manassas.k12.va.us/round/classweb/volz/excelweb/ssclass.htm

 

Infused Lesson Plans

http://muse.widener.edu/~rss0003/LessonPlans/Technology_Infused_Lesson_Plans.html#SpreadsheetLessons

 

4 2explore

http://www.42explore.com/graphs.htm

List of sites with projects using spreadsheets especially graphing.

 

Internet for Classrooms

http://www.internet4classrooms.com/on-line_excel.htm

 

Using Spreadsheets in the Classroom

http://www.trumbull.k12.oh.us/Teachers/resources/usingss.htm

Trumbull County Ohio Educational Service Center

 

Using Spreadsheets in the classroom

http://www.education.gsw.edu/johnson/sprdshts.htm

Georgia Southwestern State University

 

Spreadsheet Tools

http://www.2learn.ca/teachertools/Spreadsheet/ssexemplar.html

sponsored by 2Learn from Alberta, Canada

 

CREATE for Mississippi

http://www.create4ms.org/classroom/lessons.html

Search the Lesson Plan link for spreadsheet or excel.

 

A Hotlist on Spreadsheets as Mindtools in the Classroom

http://www.kn.pacbell.com/wired/fil/pages/listspreadshca.html

 

Using Microsoft Excel to Enhance Teaching and Learning

http://emints.more.net/profdevelopment/modules/excelxp.pdf

 

Teach-nology A Web Portal for Educators

http://www.teach-nology.com/teachers/lesson_plans/

Search the lesson plan data base using the terms spreadsheet or Excel.

 

The Gateway to Educational Materials

http://www.thegateway.org/

With its Gateway to Educational Materials, the US Department of Education aims to make the Web "a more friendly place for teachers." GEM evaluates resources from federal, state, university, nonprofit, and commercial sites and compiles a database of lesson plans accessible through a simple search. There are currently over 140 organizations supplying over 7,000 documents to the database. This site can serve as a source of good ideas for supplementary activities in a well-designed and implemented curriculum. Searchable by subjects, keywords, grade levels, etc.

 

Marco Polo

http://www.marcopolo-education.org/index.aspx

The MarcoPolo program provides no-cost, standards-based Internet content for the K-12 teacher and classroom, developed by national content experts. Online resources include panel-reviewed links to top sites in many disciplines, professionally developed lesson plans, classroom activities, materials to help with daily classroom planning, and powerful search engines. A popular highly respected site among media specialists and technology integration leaders.

 

Lesson Planet

http://www.educationplanet.com/

Search  with the terms  spreadsheet or excel.

 

Lesson Planet

http://www.lessonplanet.com/search/Math/Charts_and_Graphs?startval=10

 

back to top

 

Specific Lessons

 

Back in Time with Timelines

http://www.forsyth.k12.ga.us/kadkins/timeline.htm

 

Mrs. Murphy’s Timelines

http://www.pwcs.edu/pattie/projects/murphy/timeline.html

 

RealTime Data Projects

http://www.k12science.org/currichome.html

Great Site!  Worth a look!

 

Life Saver Project

http://www.pwcs.edu/pattie/projects/ls/ls.html

 

Can you be a Millionaire?

http://www.nevada.edu/~jilll/jillswebquest.html

 

Introduction to Math and Spreadsheets

http://mathforum.org/sum95/math_and/spreadsheets/intro.html

 

Junk Food Survey

http://www.cbv.ns.ca/Teacher_Resources/lessons/Mathematics/Statistical_analysis.htm

 

Creating a Shopping Spreadsheet

http://www.learnnc.org/learnnc/lessonp.nsf/Approved_By_Grade/1A02102F3C9D5F558525679B0075F1EB?opendocument

 

back to top

 

Rubric Web Sites

 

RubiStar

http://rubistar.4teachers.org/index.php

 

Kathy Schrock’s Guide for Educators

http://school.discovery.com/schrockguide/assess.html

 

Mid-Link Magazine Rubrics and Evaluation Resources

http://www.ncsu.edu/midlink/ho.html

 

back to top