Department of Defense
Do Dea: Spreadsheet Software: M1: L5: Show Me Your Skills: Practice Skills
In Module 1 Lesson 5 of this course on spreadsheets, students review what they have learned in the previous four lessons. Content is stored in the Resources section. Practice tasks are not available online so teachers would need to...
Department of Defense
Do Dea: Spreadsheet Software: M3: L2: In the Library: Calculate With Functions
In Module 3 Lesson 2 of this course on spreadsheets, students learn about naming cells and cell ranges and how a name moves with the range it is attached to. Names can also be used in constructing absolute cell reference formulas....
Department of Defense
Do Dea: Spreadsheet Software: M4: L5: Show Me Your Skills: Practice Skills
In Module 4 Lesson 5 of this course on spreadsheets, students review what they have learned in the previous four lessons about building charts, using conditional formatting, and enhancing their spreadsheet by inserting images, text, and...
Department of Defense
Do Dea: Spreadsheet Software Applications: M4: L1: Chart It! Working With Charts
In Module 4 Lesson 1 of this course on spreadsheets, students learn how to build a chart from their spreadsheet data so that it is easier to interpret. Includes a glossary and slideshow tutorials.
Department of Defense
Do Dea: Spreadsheet Software: M5: L4: Work With Me! Collaboration Options
In Module 5 Lesson 4 of this course on spreadsheets, students will learn how to collaborate on a spreadsheet document while working from different locations. Includes slideshow tutorials.
Department of Defense
Do Dea: Spreadsheet Software: M6: L3: Outside the Box: Get External Data
In Module 6 Lesson 3 of this course on spreadsheets, students will learn how to import data that is in different formats and from a variety of sources, and transpose and format it. Includes slideshow tutorials.
Other
Laus Dnet: Grade 5 Excel Lesson Plan
In this online instructional activity, students will survey students in their school to determine their favorite type of hand-held ice cream. Before performing the survey, students will make predictions about which ice creams they think...
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...
Science Education Resource Center at Carleton College
Serc: The Digital Divide: A Data Analysis Activity Using Subtotals
A lesson plan that includes a PowerPoint learning module for students. The purpose of the lesson plan is to teach how to use Excel to analyze a large amount of data, in this case from the US Census. The example being used is the...
NASA
Nasa: Cosmic Chemistry: An Elemental Question
Explore the periodic table like never before! This downloadable program module for students comes absolutely complete with teacher modules, student assessments, PowerPoints, Excel spreadsheets, historical text readings and more. Students...
Goodwill
Gcf Global: Excel Formulas: Functions
A function is a predefined formula that performs calculations using specific values in a particular order. All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and...
Goodwill
Gcf Global: Excel Formulas: Complex Formulas
A simple formula is a mathematical expression with one operator, such as 7+9. A complex formula has more than one mathematical operator, such as 5+2*8. When there is more than one operation in a formula, the order of operations tells...
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...
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: Simple vs. Compound Interest Spreadsheeting the Difference
A lesson plan that includes a PowerPoint learning module for students. The goal of the instructional activity is to learn the difference between simple and compound interest and to use the functions in Excel to perform the calculations...
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...
Other
Fast Food Fun
Use your knowledge of spreadsheets to analyze the calories and fat content of fast food choices. This project gives links to a USDA site and a final report format. A sample spreadsheet and grading rubric is also provided.
Other
Personal: Let's Go Shopping
This personal site provides a student activity that allows learners to practice spreadsheet skills in inputting data and creating function formulas. The activity is based on the collection and comparison of shopping receipts using max,...
Other
Tonya Skinner Business Ed Lesson Plans: Grocery Shopping
This personal site provides a student activity that allows learners to plan a class party while organizing the budget details in a spreadsheet program. Learners will demonstrate computer skills in inputting data, formatting data, and...
Other
Jan's Web Work: Jan's Illustrated Computer Literacy 101
Illustrated and interactive web tutorial that guides learners through to achieving strong, basic computer knowledge. The tutorial is broken into chapters with interactive quizzes.
Department of Defense
Do Dea: Spreadsheet Software: M1: L2: Ethical and Efficient Use of Computers
In Module 1 Lesson 2 of this course, students are introduced to issues related to copyright, public domain, and licensing agreements. They will also learn about industry certification for this course on spreadsheet applications.
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...
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...
University of Waterloo (Canada)
Wired Math: Organizing Data Grade 7 [Pdf]
A collection of worksheets that focus on data analysis and organizing data. Includes detailed examples, colorful visuals, and a link to a related game. Acrobat Reader required.
Other popular searches
- Microsoft Excel Spreadsheets
- Using Excel Spreadsheets
- Excel Spreadsheets Graph
- Excel Spreadsheets Planets
- Creating Excel Spreadsheets
- Excel Spreadsheets Football
- Excel Spreadsheets Grades
- Nfl Excel Spreadsheets
- Excel Spreadsheets Soccer
- Basic Excel Spreadsheets
- Excel Spreadsheets Di Da