Georgia State University
Georgia State University: Creating Spreadsheets Using Ms Excel
This Georgia State University site gives in outline form the basic principles of using spreadsheet software. At the end of the outlines, specific uses for spreadsheets in recordkeeping are suggested.
Other
Nearpod: Spreadsheets: Using Formulas
In this lesson on spreadsheets, students explore the different parts of a spreadsheet and use equations within spreadsheets to learn about their applications.
BBC
Bbc Bitesize: Spreadsheets
Spreadsheets are used to store information and data. Once we have our information in a spreadsheet we can run powerful calculations, make graphs and charts and analyse patterns.
Texas Instruments
Texas Instruments: Spreadsheets Anyone
This activity is meant to give students a quick review on how to navigate their cursors in Activity Center.
Science Education Resource Center at Carleton College
Serc: Salmon Use of Geomorphically Restored Streams at Point Reyes Nat. Seashore
A lesson plan with an accompanying PowerPoint learning module for learners where they learn about coho salmon and a repair done to a culvert in Point Reyes National Seashore. The repair was intended to help the salmon make their journey...
Science Education Resource Center at Carleton College
Serc: Yellowstone! A National Park on a Hot Spot
A lesson plan with an accompanying PowerPoint learning module for students where they learn about the volcanic features of Yellowstone National Park. They use spreadsheets to make various calculations, such as the volume of material...
Teachnology
Teachnology: Spreadsheet Guide for Teachers
A Spreadsheet is a wonderful tool with applications well beyond simple calculations. This site provides a collection of lesson plans, tutorials and worksheets that help bring spreadsheets into the classroom.
Science Education Resource Center at Carleton College
Serc: The "Perfect" Date: Ranking and Rating Decisions With a Spreadsheet
A lesson plan that includes a PowerPoint learning module for students. The purpose of the lesson is to use spreadsheets to explore a rating and ranking method for choosing someone to date. They look at the problems that arise when...
National Council of Teachers of Mathematics
The Math Forum: A Collection of Secondary Math Units
Teachers of grades 9-12 can explore these seven math units for their classes. Data collection and analysis, problem solving with spreadsheets, and linear transformation are just a few of the topics covered here.
Microsoft
Microsoft Education Lesson Plan: Candy Is Dandy
Explore color distribution of M&M candies using this detailed lesson plan. An engaging integrated lesson plan that requires understanding of spreadsheets and formulas, and logical reasoning. Links to related websites.
Science Education Resource Center at Carleton College
Serc: Creating a Household Budget
In this Spreadsheets Across the Curriculum PowerPoint module, students create a household budget by tracking their expenditures over a month-long period. Students use Microsoft Excel to create a spreadsheet to track their own...
Other
Anguilla Library: Lessons for Achieving Computer Literacy
This site presents lessons on software usage by members of a computer club. Lessons include Basic Dos Systems, Windows, Spreadsheets, Basic Programming, and more.
TeachEngineering
Teach Engineering: Energy Perspectives
Students utilize data tables culled from the US DOE Energy Information Agency to create graphs that illustrate what types of energy we use and how we use it. An MS Excel workbook with several spreadsheets of data is provided. Students...
Google
Google for Education: Working With Large Tables of Data
Students work with large tables of GPS data and sort, manipulate, and visualize the data so it can be easily understood.
Other
The University of Arizona: Study Finance: Getting Started With Excel
A great tutorial that takes you through all the steps you need for mastering the Microsoft Excel spreadsheet application.
Google
Google for Education: Data Aggregation and Decomposition (Python)
Students learn how to use and analyze data to draw conclusions about information collected from classmates. Then they use computational thinking by collecting and aggregating data onto a spreadsheet, identifying patterns in their data,...
Google
Google for Education: Sorting the World's Cities (Python)
The second of two similar lessons where students learn how a Python program can organize and sort data. When taught in conjunction with Sorting the World's Cities with Excel, students make the connection between writing a program and...
National Council of Teachers of Mathematics
The Math Forum: Seventh Grade Mathematics: Data Sense
This site has some interesting ways to collect and evaluate data. There are some activities about note taking, spreadsheets, surveys, and a cool bridge construction project. Teachers may want to use this site as a resource for some...
University of Oregon
Magnet Lab: University of Oregon Virtual Laboratory
The collection of interactive physics applets offered by the University of Oregon is an excellent resource for students. The applets are grouped in broad subject areas including astrophysics, energy and environment, mechanics and...
Texas Instruments
Texas Instruments: Social Security Issues
In this activity, you will look at the relationship between the age at which you start drawing social security and the amount drawn. Both graphs and spreadsheets will be used.
Science Education Resource Center at Carleton College
Serc: Using Microsoft Excel to Explore Gravity Forces and Accelerations
Students will learn about the force of gravity and the factors that affect it, and use and analyze the universal gravitation equation using Excel spreadsheets.
Science Education Resource Center at Carleton College
Serc: Average Rates of Change and Trend Lines
In this Spreadsheets Across the Curriculum activity, students calculate the average rate of change and graph a scatter plot of status high school dropout rate for 1975-2002. The module combines interpretation of rate of change in the...
Science Education Resource Center at Carleton College
Serc: The Mole in Chemistry: Determining the Number of Atoms in Everyday Items
Students explore the concept of the mole as a measure of quantity. They build spreadsheets that allow them to convert between moles, grams, and atomic mass units for given quantities of everyday items, elements, and simple chemical...
American Association of Physics Teachers
Com Padre Digital Library: Open Source Physics: Data Tool Program
Use this online data analysis tool to build graphs and display results from scientific investigations. Data can be entered directly with the keyboard or imported from, and exported to spreadsheets.
Other popular searches
- Excel Spreadsheets
- Microsoft Excel Spreadsheets
- Meteorology and Spreadsheets
- Using Excel Spreadsheets
- Math Using Spreadsheets
- Heart Rate and Spreadsheets
- Creating Spreadsheets
- Math Spreadsheets
- Using Spreadsheets
- Spreadsheets Charts
- Excel Spreadsheets Graph
- Excel Spreadsheets Planets