|
|
Microsoft Excel: Impacting Teaching and Student Learning
Day Three – Standards and Benchmarks
Day One
Excel is Elementaryhttp://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:
Day Two – Learning Theory
General/Index SitesAuthentic LearningBloomBrain Hemispheric Dominance and Learning StylesConstructivismMultiple IntelligencesProject-Based Learning
Vivisimo Recommended Search Engine for Learning Theory
General Sites
Funderstandinghttp://www.funderstanding.com/about_learning.cfm Excellent site! Great Summaries for several learning theories.
Learning Theories and Instructional Strategies Matrixhttp://www.kihd.gmu.edu/immersion/knowledgebase/ Matrix that compares Behaviorism, Cognitivism, and Constructivism
Instructional Strategies from Sabine Parish School Systemhttp://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 Instructionhttp://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 Instructionhttp://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.htmThis 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 Sciencehttp://www.ncrel.org/sdrs/areas/issues/content/cntareas/science/sc500.htmThis is a discussion of Authentic Instruction as used in science curriculum.
The Red Tail Ridge Wetlands projecthttp://www.ncrel.org/sdrs/areas/issues/content/cntareas/science/sc2rt.htm An example of a project. Authentic Instructionhttp://labweb.education.wisc.edu/ep301/Science_Peter/authentic.htm
Authentic Learning and Visual Arthttp://tiger.coe.missouri.edu/~vlib/mick/Mick1.html#WAL An article discussing various aspects of Authentic Learning.
Bloom
Learning Domains or Blooms Taxonomyhttp://www.nwlink.com/~donclark/hrd/bloom.html A good summary of Bloom’s Taxonomies.
Benjamin Bloomhttp://www.ittheory.com/bloom1.htm Helpful charts!
Bloom's Taxonomy's Model Questions and Key Words fromhttp://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 Listhttp://www.iloveteaching.com/steacher/verbs/taxonomy.htm
Applying Bloom’s Taxonomyhttp://www.teachers.ash.org.au/researchskills/dalton.htm Terrific site for the elementary classroom.
Major Categories in the Taxonomy of Educational Objectiveshttp://faculty.washington.edu/krumme/guides/bloom.html Categories, verbs, and internet links.
Brain Hemispheric Dominance and Learning Styles
Right Brain-Left Brainhttp://www.funderstanding.com/right_left_brain.cfm Another great summary from Funderstanding.
Index of Learning Styles by North Carolina State Universityhttp://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 Learnhttp://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 Dominancehttp://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 Learnhttp://www.nmathletictrainers.org/howdopeoplethink.pdf Great summary in PDF format.
Learning Styleshttp://www.mtsu.edu/~studskl/hd/learn.html Great information and an online assessment.
Brain Dominance Instrumenthttp://www.speakersandtraining.com/downloads/braindominance.pdf An instrument for determining dominance.
The Brain ExplorerA ThinkQuest includes a section on dominance.
Constructivism
Constructivism as a Paradigm for Teaching and Learninghttp://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 Learninghttp://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 Constructivismhttp://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 Theoryhttp://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.
Constructivismhttp://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 Educationhttp://hagar.up.ac.za/catts/learner/lindavr/home.htm The link to Constructivism contains a summary as well as key words and phrases.
Constructivism Overviewhttp://www.uib.no/People/sinia/CSCL/HMM_Constructivism.htm Interesting visual picture of Constructivism.
University of Colorado at Denverhttp://carbon.cudenver.edu/~mryder/itc_data/constructivism.html An index of sites regarding various interpretations of the Constructivism Theory.
Multiple Intelligences
Funderstandinghttp://www.funderstanding.com/multiple_intelligence.cfm Terrific summary of Gardner’s Theory.
Tapping into Multiple Intelligenceshttp://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 Intelligenceshttp://www.inspiringteachers.com/tips/packet/activities.html Great place to look for how technology can enhance learning with multiple intelligences.
Multiple Intelligence Profilerhttp://www.new-oceans.co.uk/new/multi.htm An interesting site with a quiz to help determine learning preferences.
New Horizon’s for Learninghttp://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 Strategieshttp://www.newhorizons.org/strategies/mi/front_mi.htm This site provides an index of articles related to Multiple Intelligences Theory.
Penn State College of Educationhttp://www.ed.psu.edu/insys/ESD/gardner/MItheory.html Links regarding Gardner’s theories.
Project-Based Learning
Project Based Learninghttp://college.hmco.com/education/pbl/background.html
Project-Based Instruction Creating Excitement for Learninghttp://www.nwrel.org/request/2002aug/intro.html Good information from NW Regional Educational Laboratory. Project-Based Learning and Information Technologies
Road Ahead – Project-Based Learninghttp://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 Learninghttp://www2.imsa.edu/programs/pbl/problem.html Good tutorial regarding project-based learning.
Project-Based Learning: A Primerhttp://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 Systemhttp://www.sabine.k12.la.us/vrschool/brainPBLinquir.htmA terrific list of web sites regarding Project-Based Learning.
PBLnetComprehensive 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) National Educational Technology Standards (NETS)
http://cnets.iste.org/
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
Task Two – Web SitesDeveloping 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
Day Four – Lesson Plans using Microsoft Excel
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 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 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
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
|