Actual examples of spreadsheets

Examples of Spreadsheets from Previous Mindtool course's Students

• Type of resource: Spreadsheet examples
• Source: multiple
• Description: Click on the following files to download them to your computer.
  Please note! - To save these files to your computer, you'll need to click/hold on the hyperlink (right button click/hold on a Windows machine). That will bring up a pop-up menu where you can choose to "save/download the link/target to disk." (If you were to just click on the link, you would only see a bunch of garbage in your browser window.) Then, to view the saved file, you need Microsoft Excel. If you don't have the software, you should search the Web site of the vendor to see if a demo version is available.
  • Simulations
    • BatterySeries
    • FISHPOP.XLS
    • Fourtone.XLS
    • Pathogens.XLS
    • SeriesResistors
    • SimpleCircuits
  • Computation Tools
    • CarAcc.XLS
    • GasLaws
    • Pense.XLS
    • Vapor3.XLS
    • Wheels.XLS
  • Numerical Comprehension
    • Quadradic

The Spreadsheet Page

• Type of resource: Web site
• Source: http://www.j-walk.com/ss/index.html
• Description: JWalk and Associates maintains this Web site, which professes to provide a central source for information about spreadsheets of all types. It includes a lot of helpful tips and links to many other Web sites that have spreadsheet info (organized by product).

The Webquest Page

• Type of resource: Web site
• Source: http://edweb.sdsu.edu/webquest/webquest.html
• Description: This great site describes "WebQuest"-- "an inquiry-oriented activity in which most or all of the information used by learners is drawn from the Web. WebQuests are "designed to use learners' time well, to focus on using information rather than looking for it, and to support learners' thinking at the levels of analysis, synthesis, and evaluation" and can make use of many different tools including databases, spreadsheets, microworlds, and others. Check out the "overview" page for more information about the WebQuest model, and the "example" link for many examples of projects already developed.

Spreadsheets in Education

• Type of resource: Web site
• Source: http://SunSITE.univie.ac.at/Spreadsite/
• Description: This expansive site includes a number of different topics about using spreadsheets in math, science and statistics education, including recommended books and journals, articles about spreadsheets, example spreadsheets and products, and other resources.

Spreadsheets

• Type of resource: Web site
• Source: http://mailer.fsu.edu/~jflake/spreadsheets.html
• Description: This site has a number of links to other resources on the use of spreadsheets in educational settings.

Meteorology - Does Weather Happen Randomly?

• Type of resource: Web site
• Source: http://www.cl.ais.net/rlevine/Weathr20.htm
• Description: This site is an interesting on-line weather unit in which middle school students use current weather data to answer questions and draw conclusions about today's weather. The students construct spreadsheets to organize and analyze their data.

Immigrants Unit

• Type of resource: Web site
• Source: http://www.cl.ais.net/rlevine/imm20.htm
• Description: This award winning Internet-based unit has students examining completed spreadsheets to analyze the experience of Irish immigrants to Boston in 1840 and the immigrant experience today. Final projects for the unit can take many forms, ranging from charts and graphs to drama or musical numbers.

Algebra Using Excel

• Type of resource: Web site
• Source: http://www.mste.uiuc.edu/courses/ci301fall98/edsel/excel_int.html
• Description: This site describes a lesson created for secondary algebra students which uses an Excel spreadsheet. The problem is to find the maximum number of cars passing a point in a given amount of time. The teachers found that "Excel proved to be extremely beneficial in efficiently solving this traffic problem... Having all the data in the spreadsheet form makes it easy to understand and convenient to display the results graphically."

NCAA Basketball Finals

• Type of resource: Web site
• Source: http://www.mste.uiuc.edu/meseke/ncaa.html
• Description: This site describes a statistics lesson for middle school students. Using Excel, students analyze data on scores and teams from NCAA Basketball Championship Games. The students answer questions, draw conclusions, and make predictions based on their interpretation of the data.

Copyright ©2001, University of Missouri-Columbia