Mindtools:
Spreadsheet Resources
Back to The Mindtool Resource Page
**Web links verified June 1, 2004**
|
| The resources below are provided by those that posted them. Mistakes, inaccuracies, or those that promote copyright infringement or other netiquette violations should be reported immediately. |
|
Submit New Spreadsheet Resources
Here Back to The Mindtool Resource Page **Web links verified June 1, 2004** |
| Spreadsheet Resource: | article |
| Grade level: | 11/12 |
| Subjects: | Social Studies and Mathematics |
| Title: | Distributing Representatives: Using Spreadsheets To Study Apportionment |
| URL: | none |
| Location: | EJ547759 |
| Identifier: | Learning and Leading with Technology; v24n8 p26-29 May 1997 |
| Description: | ABSTRACT: discusses the use of mathematics, specifically spreadsheets, to study apportionment in the U.S. House of Representatives. Topics include the interdisciplinary nature of the study, how population changes affect the distribution, different methods of apportioning representatives that have been used throughout history, and analyzing the data. |
| Submitted by: | Chris Warders |
| Personal URL: | none |
Feb 24, 1998 13:02 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | 9/10,11/12 |
| Subjects: | |
| Title: | Exploring Number Structures with Spreadsheets |
| URL: | none |
| Location: | |
| Identifier: | Learning-and-Leading-with-Technology; v24 n8 p32-36 05/97 |
| Description: | Exposing students to spreadsheets can significantly "round" their technological base and help prepare them for future experiences with technological math. |
| Submitted by: | Serenna R. Wright |
| Personal URL: | none |
Feb 28, 1998 13:48 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | 9/10,11/12 |
| Subjects: | Sutherland, Rosamund. |
| Title: | A Spreadsheet Approach to Solving Algebra Problems |
| URL: | none |
| Location: | Journal-of-Mathematical-Behavior |
| Identifier: | v12 n4 p353-83 Dec 1993 |
| Description: | Strategies for using spreadsheets while working with algebra problems. |
| Submitted by: | Serenna R. Wright |
| Personal URL: | none |
Feb 28, 1998 13:52 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | 9/10,11/12 |
| Subjects: | Sgroi, Richard J. |
| Title: | Systematizing Trial and Error Using Spreadsheets |
| URL: | none |
| Location: | Arithmetic-Teacher Journal |
| Identifier: | V39 n7 p8-12 March 1992 |
| Description: | Spreadsheet usage utilizing the famous trial and error technique. |
| Submitted by: | Serenna R. Wright |
| Personal URL: | none |
Feb 28, 1998 13:55 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | 9/10,11/12 |
| Subjects: | Computer Assisted Mathematics Instruction |
| Title: | Exploiting Technology in the Mathematics Classroom |
| URL: | none |
| Location: | |
| Identifier: | EJ547807 |
| Description: | Illustrates the diverse ways in which the computer spreadsheet can be used by both teachers and students as a problem-solving tool in high school math, and provides detailed examples of spreadsheet use in word problems. Discusses the functions of spreadsheet tables,columns, & graphs. |
| Submitted by: | Aloyce Hudson |
| Personal URL: | none |
Feb 28, 1998 14:55 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | All |
| Subjects: | Area, Perimeter, Volume, Measurement (Geometry) |
| Title: | Teaching Mathematics with Technology:Patterns in Measurement |
| URL: | none |
| Location: | Arithmetic-Teacher; v40 n5 p.292-95 Jan.1993 |
| Identifier: | EJ464711 |
| Description: | Presents four hands-on and computer-based activities to develop measurement skills. Students examine, measure, compare, and contrast the area, perimeter, and volume of geometric figures using concrete materials and computer spreadsheets. |
| Submitted by: | Aloyce Hudson |
| Personal URL: | none |
Feb 28, 1998 15:11 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | 9/10,11/12 |
| Subjects: | Science |
| Title: | Spreadsheet, Powerful Tools in Science Education |
| URL: | none |
| Location: | EJ415480 |
| Identifier: | School Science Review; v71 n257 p47-57 June 1990 |
| Description: | ABSTRACT: Examined are applications of computer spreadsheets from simple record/observation tables to custom built analysis systems. The advantages and disadvantages depending on the use of these software packages are discussed. Several examples are used to illustrate possible applications. |
| Submitted by: | Chris Warders |
| Personal URL: | none |
Feb 28, 1998 15:23 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | 9/10,11/12 |
| Subjects: | Algebra |
| Title: | Solving Equations with Spreadsheets |
| URL: | none |
| Location: | Computers in Math and Science Teaching; v11 n3-4 p.337-45 1992 |
| Identifier: | EJ458233 |
| Description: | Examines the use of spreadsheets for solving equations by the iterations method. The combination of the spreadsheets and graphical representation is shown to be appropriate for teaching and learning the iterations method and for investigating properties of equations. |
| Submitted by: | Aloyce Hudson |
| Personal URL: | none |
Feb 28, 1998 15:27 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | 9/10,11/12 |
| Subjects: | Science |
| Title: | Integrating PC Tools for Presenting Information in Science Classes |
| URL: | none |
| Location: | ERIC NO. ED396682 |
| Identifier: | In: Recreating the Revolution. Proceedings of the Annual National Educational Computing Conference (15th, Boston, Mass. June 13-15, 1994) |
| Description: | Describes a method for science students to use in preparing data for analysis and dissemination. A sample project demonstrates the general procedure to develop a project by data generation with a computer, organizing and labeling data on a spreadsheet, constructing a graph and incorporating it into a word processing document for presentation. An appendix provides a sample basic program. |
| Submitted by: | Chris Warders |
| Personal URL: | none |
Feb 28, 1998 15:39 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | Middle,Intermediate |
| Subjects: | Science - classification of objects |
| Title: | Science: Database Programs and the Study of Seashells |
| URL: | none |
| Location: | |
| Identifier: | EJ445107 |
| Description: | From Computing Teacher; v19 n7 p32-34 Apr 1992. Discusses using spreadsheets to study the characteristics of seashells. |
| Submitted by: | Nancy Mokelke |
| Personal URL: | none |
Feb 28, 1998 15:58 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | All |
| Subjects: | Technology Integration |
| Title: | The Computer as a Scientific Tool: Integrating Spreadsheets into the Elementary Science Curriculum |
| URL: | none |
| Location: | |
| Identifier: | EJ547804 |
| Description: | From Computers in the Schools; v13 n1-2 p125-31 1997. Discusses integrating spreadsheets into the elementary curriculum from analyzing the software and its fit with the curriculum objectives including both computer and non-computer activities. |
| Submitted by: | Nancy Mokelke |
| Personal URL: | none |
Feb 28, 1998 16:08 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | All |
| Subjects: | Technology Integration |
| Title: | Using One Computer for Teacher-Pupil Group Work |
| URL: | none |
| Location: | |
| Identifier: | EJ405621 |
| Description: | From Education and Computing; v4 n3 p197-201 1988. Discusses how spreadsheets can be used with limited computer resources - a one computer classroom. |
| Submitted by: | Nancy Mokelke |
| Personal URL: | none |
Feb 28, 1998 16:16 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | Middle,9/10,Intermediate,11/12 |
| Subjects: | Spreadsheets, Databases, & Mail Merge |
| Title: | Using Productivity Software for Beginning Language Learning |
| URL: | none |
| Location: | Fletcher Library |
| Identifier: | Learning & Leading w/Technology Sept. 97 p. 12-17 |
| Description: | This article features language-learning exercises for the spreadsheet, database, and mail merge functions. |
| Submitted by: | Rosemary Brocker |
| Personal URL: | none |
Mar 1, 1998 18:40 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | Primary,Intermediate |
| Subjects: | Classroom Projects-one had 5th grade using spreadsheets for baseball statistics |
| Title: | Little Kids, Big Projects |
| URL: | none |
| Location: | Fletcher Library |
| Identifier: | Technology & Learning Oct 97 p. 44 |
| Description: | This short article is part of a section in the magazine called WHAT WORKS. Many, many ideas for technology inspired activities in elementary classrooms. Sketchy but plants seeds for thought and discussion |
| Submitted by: | Rosemary Brocker |
| Personal URL: | none |
Mar 1, 1998 18:52 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | Middle,9/10,Intermediate,11/12 |
| Subjects: | Maps, Minds, and Concepts |
| Title: | The Social (Studies) Side of Technology |
| URL: | none |
| Location: | Fletcher Library |
| Identifier: | Technology & Learning Sept 94 p.37 |
| Description: | This article is in the WHAT WORKS section of the magazine and discusses a unit in Government and Economics involving practical money managements as budgeting and balancing a checkbook. |
| Submitted by: | Rosemary Brocker |
| Personal URL: | none |
Mar 1, 1998 19:00 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | Middle,9/10,Intermediate,11/12 |
| Subjects: | Maps, Minds, and Concepts |
| Title: | The Social (Studies) Side of Technology |
| URL: | none |
| Location: | Fletcher Library |
| Identifier: | Technology & Learning Sept 94 p.37 |
| Description: | This article is in the WHAT WORKS section of the magazine and discusses a unit in Government and Economics involving practical money managements as budgeting and balancing a checkbook. |
| Submitted by: | Rosemary Brocker |
| Personal URL: | none |
Mar 1, 1998 19:04 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | Middle |
| Subjects: | using spreadsheets data to display different graphic formats |
| Title: | Choose the right graph |
| URL: | none |
| Location: | ASU West Library |
| Identifier: | The Computing Teacher. Feb. 1995, vol.22, #5, pg. 31 |
| Description: | This article covers an array of spreadsheets and their graphing capabilities, including Labquest, Excel, Clarisworks and Cruncher. It explains how students can move from organizing data in a spreadsheet, to how it can displayed in different graphic formats. |
| Submitted by: | Jo Wiechens |
| Personal URL: | none |
Mar 1, 1998 19:53 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | Middle |
| Subjects: | Clarisworks spreadsheet and graphing |
| Title: | Analyzing and Interpreting Graphs in the Middle Grades--Bottles and Beyond |
| URL: | none |
| Location: | Fletcher Library |
| Identifier: | The Computing Teacher. Dec/Jan 1994 vol.22, #4 |
| Description: | This article describes a clarisworks spreadsheet lesson where the students analyzed and interpreted graphical communications. |
| Submitted by: | Jo Wiechens |
| Personal URL: | none |
Mar 1, 1998 20:00 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | Middle |
| Subjects: | 2nd language learning |
| Title: | Spreadsheets, Databases, and Mail merge |
| URL: | none |
| Location: | Fletcher Library |
| Identifier: | Learning and Leading with Technology. Sept. 1997, vol.25, #1 |
| Description: | This article features language-learning exercises for the spreadsheet, database and mail merge functions of popular productivity software packages. |
| Submitted by: | Jo Wiechens |
| Personal URL: | none |
Mar 1, 1998 20:05 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | Middle,9/10,Intermediate,11/12 |
| Subjects: | Foreign Language |
| Title: | Using Productivity Software for Beginning Language Learning |
| URL: | none |
| Location: | Learning and Leading With Technology--v25 n1 September 1997 |
| Identifier: | Learning and Leading with Technology |
| Description: | article discusses how software can be used to motivate beginning foreign-language students |
| Submitted by: | Mary O'Malley |
| Personal URL: | none |
Mar 1, 1998 20:49 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | 11/12 |
| Subjects: | Foreign Language |
| Title: | Connectivity: Transferring FL Files |
| URL: | none |
| Location: | |
| Identifier: | Hispania, v73 n4 p1185-95 December 1990 |
| Description: | lengthy article that describes uses of computer technology in exchanging spreadsheets in modern foreign languages |
| Submitted by: | Mary O'Malley |
| Personal URL: | none |
Mar 1, 1998 20:58 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | Middle,Primary,Intermediate |
| Subjects: | Science or Any |
| Title: | The Computer as a Scientific Tool: Integrating Spreadsheets into the Elementary Science Curriculum |
| URL: | none |
| Location: | Journal: Computers in the Schools, Vol. 13, Numbers 1/2, 1997 |
| Identifier: | |
| Description: | Focuses upon using "The ABCD Model for computer-Curriculum Integration." The model includes four steps: (A) Analyzing the software and curriculum; (B) Brainstorming connections between parts of the software and the content areas: (C) Creating connections among the curriculum, the information obtained during the brainstorming, and non-computer classroom activities; and (D) Defining curriculum objectives which can be incorporated, and activities that will be used to address those objectives. The example sited in the article used a spreadsheet prototype and happened to research (science) electromagnetism. |
| Submitted by: | Kat Schulz |
| Personal URL: | none |
Mar 3, 1998 15:53 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | All |
| Subjects: | Science/Ecology, Math, Writing |
| Title: | Talking Trash on the Internet: Working Real Data Into Your Classroom |
| URL: | none |
| Location: | Learning & Leading With Technology |
| Identifier: | Feb. 1998, Vol. 25, No. 5 |
| Description: | This is a great way to integrate a unit on trash/litter/recycle or "Earth Day." Students begin by analyzing their own "personal trash inventory" both graphically and statistically. They make predictions, use formulas, and compare their findings with other real world web sites. |
| Submitted by: | Kat Schulz |
| Personal URL: | none |
Mar 3, 1998 16:11 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | Middle,9/10,Intermediate,11/12 |
| Subjects: | Math with Reading and Writing |
| Title: | Modeling Mathematics Concepts: Using Physical, Calculator, and Computer Models to Teach Area and Perimeter |
| URL: | none |
| Location: | Learning & Leading With Technology |
| Identifier: | Feb. 1998, Vol. 25, No. 5, Pages 32-35 |
| Description: | Using a "real world problem" like creating a quilt (or tiling--patterning), the teacher had students find possible answers using a spreadsheet and graphed the responses. The teacher also provided a list of questions to "Extend the Problem" which included comparing/contrasting and providing proof of the answer given. |
| Submitted by: | Kat Schulz |
| Personal URL: | none |
Mar 3, 1998 16:23 EST |
|
| Spreadsheet Resource: | web site |
| Grade level: | Middle,Primary,Intermediate |
| Subjects: | Cross Curriculum |
| Title: | Nutrient Counting |
| URL: | http://www.dpi.state.nc.us/Curriculum/Computer.skills/lssnplns/SSlesson.G6.2.2.2.html |
| Location: | Public Schools of North Carolina |
| Identifier: | |
| Description: | This site is a link to a computer skills curriculum spreadsheet lesson plan. The topic is nutrients counting. The lesson plan helps the students to develop a spreadsheet full of information they gathered from labels of products. Included in the lesson plan is listed competencies that they lesson plan meets, other ideas and lessons linked to this subject that cross curriculum, black line masters of examples for presenting material to students, terminology along with glossary of terms. Pre-activities, easy to follow steps to teach the lesson, and extension activities. |
| Submitted by: | Suzanne Munguia |
| Personal URL: | none |
Mar 3, 1998 23:21 EST |
|
| Spreadsheet Resource: | other (provided in description) |
| Grade level: | Middle,Intermediate |
| Subjects: | Math/Physical Education |
| Title: | Gearing Up |
| URL: | none |
| Location: | |
| Identifier: | Math at Work Series, Center for Occupational Research Development Inc. |
| Description: | An integrated lesson on using technology to map out a bike course,
build a bike, calculate gear ratio. It is aimed at grades 5-8. Spreadsheets
would be essential in the lesson. Gearing Up Math at Work Series Center for Occupational Research Development Inc PO Box 21206 Waco TX 76702-1206 |
| Submitted by: | Trisha Geffs |
| Personal URL: | none |
Mar 3, 1998 23:53 EST |
|
| Spreadsheet Resource: | web site |
| Grade level: | All |
| Subjects: | Mathematics |
| Title: | Spreadsheets In The Math Class |
| URL: | http://www.math.byu.edu/~lfrancis/readings302/Spreadsheets.html |
| Location: | |
| Identifier: | |
| Description: | This site includes information about spreadsheets. Included at this site are links to other ideas and issues to know about spreadsheets. It includes topics like NCTM position statement on technology, what is a spreadsheet, what type of information can be inserted into a cell, what are the benefits of using a spreadsheet, data analysis ideas from the real world, and a sample archives to introduce spreadsheets to students. |
| Submitted by: | Suzanne Munguia |
| Personal URL: | none |
Mar 3, 1998 23:58 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | Middle,Intermediate |
| Subjects: | decimals and division |
| Title: | Making Division Meaningful with a Spreadsheet |
| URL: | none |
| Location: | |
| Identifier: | Arithmetic Teacher v36 n3 p18-21 Nov 1988 |
| Description: | A spreadsheet is used to help students understand division and decimals in the middle grades. |
| Submitted by: | Jody Henneman |
| Personal URL: | none |
Mar 4, 1998 10:10 EST |
|
| Spreadsheet Resource: | other (provided in description) |
| Grade level: | All |
| Subjects: | Spanish Levels 1 and 2 |
| Title: | Computers in the Spanish Classroom |
| URL: | none |
| Location: | |
| Identifier: | NYC Board of Education, Brooklyn, NY DIV.of Computer information Services. |
| Description: | This was found with ERIC ED316030. The Clearing House number is FL018343. It contains a series of lesson plans common to Spanish Levels 1 and 2, with technology applications. |
| Submitted by: | Jody Henneman |
| Personal URL: | none |
Mar 4, 1998 10:22 EST |
|
| Spreadsheet Resource: | web site |
| Grade level: | Middle,Primary,Intermediate |
| Subjects: | Math |
| Title: | Introduction to Math and Spreadsheets |
| URL: | http://forum.swarthmore.edu/sum95/math_and/spreadsheets/intro.html |
| Location: | |
| Identifier: | Title |
| Description: | Provides several examples of graphs converted from SS info., including a spiral, parabola, pyramid, and SS grid. Also lists other references of websites that illustrate the use of SS |
| Submitted by: | Valerie Szenyes |
| Personal URL: | none |
Mar 4, 1998 20:07 EST |
|
| Spreadsheet Resource: | web site |
| Grade level: | Middle |
| Subjects: | Math |
| Title: | Spreadsheets in Education |
| URL: | http://sunsite.univie.ac.at/Spreadsite/ |
| Location: | |
| Identifier: | Title |
| Description: | Seventh grade math textbook including a chapter by Erich Neuwirth on using SS in math as part of the standard curriculum. Possible ideas for lesson plans included. |
| Submitted by: | Valerie Szenyes |
| Personal URL: | none |
Mar 4, 1998 20:10 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | Middle,9/10,Intermediate |
| Subjects: | |
| Title: | Maps, Minds and Concepts |
| URL: | none |
| Location: | Technology and Learning |
| Identifier: | p.37 sept 1997 |
| Description: | students can create a spreadsheet based on hands on research in which they compare, make predictions and analyze inflation in our economy. |
| Submitted by: | Dawn Ball |
| Personal URL: | none |
Mar 4, 1998 20:27 EST |
|
| Spreadsheet Resource: | article |
| Grade level: | Middle,Intermediate |
| Subjects: | |
| Title: | Exploring Different Equations with spreadsheets |
| URL: | none |
| Location: | |
| Identifier: | Learning and Leading with Technology v.24 Sept 1996 p. 28-32 |
| Description: | This article provides lesson plans which use spreadsheets to look at population growth, and interest (simple/compound) |
| Submitted by: | Dawn Ball |
| Personal URL: | none |
Mar 4, 1998 20:31 EST |
|
| Spreadsheet Resource: | web site |
| Grade level: | Middle |
| Subjects: | English, Math, Computers |
| Title: | Astronomy Mission |
| URL: | http://www.dpi.state.nc.us/Curriculum/Computer.skills/lssnplns/SSlesson.G8.3.2.1.html |
| Location: | |
| Identifier: | |
| Description: | This is a fun lesson which involves cross-curricular objectives. Students learn how to manipulate spreadsheets in order to answer "what if" questions. Students are required to enter and edit data and become involved in the lesson as they learn how to use spreadsheets. |
| Submitted by: | Chris Lannin |
| Personal URL: | |
Mar 4, 1998 21:06 EST |
|
| Spreadsheet Resource: | web site |
| Grade level: | 9/10,11/12 |
| Subjects: | Earth Science |
| Title: | Distributed Image Spreadsheet |
| URL: | http://www.nren.nasa.gov/apps/diss.html |
| Location: | internet |
| Identifier: | |
| Description: | This site explores uses for the Distributed Image Spreadsheet developed by Nasa Goddard Space Flight Center. The project is designed to provide "tools to perform advanced visualizations of very large datasets". The site has an explanation, project ideas and links to sites. |
| Submitted by: | Kim Williams |
| Personal URL: | none |
Mar 4, 1998 21:12 EST |
|
| Spreadsheet Resource: | web site |
| Grade level: | 9/10,11/12 |
| Subjects: | Math and Science |
| Title: | Sine and Cosine |
| URL: | http://www.lerc.nasa.gov/www/K-12/Sample_Projects/Sine_Cosine/sin_cosin.html |
| Location: | internet |
| Identifier: | |
| Description: | This site contains a project which uses ClarisWorks spreadsheet to answer the question "What is the relationship between a Cosine and Sine curve?" You will find step by step instructions, examples, and links to help pages and expansion projects. |
| Submitted by: | Kim Williams |
| Personal URL: | none |
Mar 4, 1998 21:17 EST |
|
| Spreadsheet Resource: | web site |
| Grade level: | Middle,9/10,11/12 |
| Subjects: | Math, Science |
| Title: | Collecting Data on Running Speeds Lesson Plan |
| URL: | http://www.lerc.nasa.gov/www/K-12/WindTunnel/Activities/collct_rning_spee.html |
| Location: | internet |
| Identifier: | |
| Description: | This is a great lesson that uses the spreadsheet as a mindtool while working with real data. Students get experience collecting, organizing, and logging in data as well as analyzing and graphing. |
| Submitted by: | |
| Personal URL: | none |
Mar 4, 1998 22:32 EST |
|
| Spreadsheet Resource: | web site |
| Grade level: | Middle |
| Subjects: | Earth Science |
| Title: | Astronomy Mission |
| URL: | http://www.dpi.state.nc.us/Curriculum/Computer.skills/lssnplns/SSlesson.G8.3.2.1.html |
| Location: | internet |
| Identifier: | |
| Description: | This is a lesson exploring information in astronomy using computer skills- specifically spreadsheets. Students will compile and enter data as well as manipulate given data to equate differences in weight on any given planet. |
| Submitted by: | Kim Williams |
| Personal URL: | none |
Mar 4, 1998 22:49 EST |
|
| Spreadsheet Resource: | seminar/class |
| Grade level: | Middle,9/10,11/12 |
| Subjects: | Spreadsheets and At-Risk Students |
| Title: | Encouraging Spread Sheet Use With Students Who Hate Them. |
| URL: | none |
| Location: | |
| Identifier: | Canadian Journal of HELP. Vol. 23, Pages 2-10. |
| Description: | At-Risk students must be motivated, and using spreadsheets effectively is just the answer. Give it a try. |
| Submitted by: | Serenna R. Wright |
| Personal URL: | none |
Mar 4, 1998 23:10 EST |
|
| Spreadsheet Resource: | web site |
| Grade level: | Middle,9/10 |
| Subjects: | Science/Earth Science |
| Title: | Solar Energy / Global Warming / Measuring Solar Radiation |
| URL: | http://whyfiles.news.wisc.edu/004antarctic/teacher4/solar.html |
| Location: | |
| Identifier: | |
| Description: | This is a great, complex, authentic activity which integrates spread sheeds in an authentic way. Spread sheets are used as a mindtool as well as a productivity tool. Within an authentic learning experience it is hard to distinguish the two. The student will: Collect information on the sun and the use of solar energy as natural resource Describe the manner in which the sun produces energy Discuss methods of collecting and storing solar energy Explore current uses of solar energy as an alternative energy resource Collect information on the heating process that occurs in the lower atmosphere Compile a list of human activities that enhance the global warming process Discuss the techniques that are used to measure global warming Explore the arguments that are made in the scientific community in the debate about global warming Build a device to measure solar radiation Collect data on solar radiation in your locale with your device Discover the effect that certain variables have on solar radiation Compare data on solar radiation with that collected at a distant site |
| Submitted by: | Bryan McCoy |
| Personal URL: | none |
Mar 24, 1998 21:45 EST |
|
| Spreadsheet Resource: | web site |
| Grade level: | Intermediate |
| Subjects: | Math/Science |
| Title: | Honey Bee Facts and Figures: Math Skills |
| URL: | http://ag.arizona.edu/pubs/insects/ahb/ |
| Location: | |
| Identifier: | |
| Description: | The lessons as outlined at this web site do not use spread sheets, however the data and math activities provided lend themselves perfectly to the use of spreadsheets to both solve the calculations and the word/authentic problems. A natural extension of the activities would be to add graphing to clarify the answers. |
| Submitted by: | Bryan McCoy |
| Personal URL: | none |
Mar 24, 1998 21:56 EST |
|
| Spreadsheet Resource: | web site |
| Grade level: | Middle,9/10,11/12 |
| Subjects: | Mathematics |
| Title: | Interactive Spreadsheets for Exploring Mathematics |
| URL: | http://www.teacherlink.org/content/math/interactive/interactiveexcel.html |
| Location: | Curry Center for Technology and Teacher Education |
| Identifier: | |
| Description: | Several Excel spreadsheets that can be freely downloaded. They explore topics such as: probability, fractions/decimals/percents, projectile motion, maximizing area of a rectangle, and general forms of equations |
| Submitted by: | Hollylynne Drier |
| Personal URL: | |
Aug 15, 1999 12:56 EST |
|