36 results
Environment activities for Microsoft Excel
El Nino Assignment | Environmental and Marine Worksheet
This graphing assignment comes in two versions, digital and printable. The printable is 3 pages and includes reading, data collection, and graphing. Three colored maps (El Nino, La Nina, and normal conditions) are provided. If you are unable to print them in color for the class, there is a digital version you could project or provide to students. Students begin with a quick reading review of what causes El Nino (very basic). Students analyze colored maps of El NIno, La Nina, and normal condition
Subjects:
Grades:
9th - 12th
Types:
Also included in: AICE Marine Science AS Level Growing Bundle
Raccoon Game: Population Growth and Limiting Factors
This resource is a great way to explore population growth and limiting factors while also getting students up and moving. This resources includes: 1. Class instructions for the activity 2. Google Form Exit Ticket 3. Modified Google From Exit Ticket 4. Spreadsheet to help with calculations for students needing math accommodations 5. Absent student activity All you need from your classroom for the activity is.. 1. Small pieces of paper of different colors (see resource) 2. Blindfolds of some kind3
Subjects:
Grades:
7th - 10th
Types:
NGSS:
HS-LS2-3
, HS-LS4-4
, HS-LS2-2
, HS-LS4-5
Ms. Molina's New Car AP Environmental Science Fuel Efficiency Calculation w/ KEY
In this activity students are asked to compare the costs of several of today's most popular vehicles that are gas-fueled, hybrid and electric. Students will calculate and compare the cost of purchasing the vehicle and annual fuel costs (whether for gallons of gas or cost of electricity) based on up-to-date pricing information and national averages (as of February 2024). Students can work through the calculations independently or in teams. They will then answer analysis questions to weigh the
Subjects:
Grades:
11th - 12th, Higher Education
Types:
CCSS:
NGSS:
HS-ESS3-1
, HS-ESS3-4
Modeling Population Growth (Ideal vs. Logistic Model)
This activity provides instructions to construct a mathematical model on a blank spreadsheet that simulates population growth using an ideal model and a logistic model. The activity provides background discussion and then gives instructions on how to program a spreadsheet to produce and display the ideal and logistic population models. Their results are studied for various cases including human population, rabbits, polar bears, bacterial and yeast colonies.
This quantitative population model
Subjects:
Grades:
9th - 12th, Staff
Types:
Acid Rain Lab Investigation (A Seed Germination Study)
INCLUDED:Google Doc with Google Sheet Link!Google Sheets with automatically perform ALL calculations and produce graphs! In this lab, students model the effects of acid rain on plant structure and function by studying seed germination in various pH treatments. In this investigation students will expose the seeds to various solutions of acid treatments and document the effects on seed germination. By exposing the seeds to various pH levels in a controlled environment, students can determine at wh
Subjects:
Grades:
7th - 12th
Types:
Microplastics Lab (Microscopic Analysis, Chemical Isolation, Food)
This is one of my favorite labs to do with my Environmental Science kids! It has 3 parts: Microscopic analysis of beach sand (you can substitute with any substrate you think might have microplastics!), microscopic analysis of everyday objects (I have my students look at food/snacks that they bring in, and do a dissection of clams/mussels from the grocery store), and chemical isolation/digestion of microplastic-containing samples of muck (we get ours from a pond and a beach). For the chemical dig
Subjects:
Grades:
8th - 12th, Higher Education, Adult Education
Types:
Google Sheets Weather Project like Excel CCSS.ELA-LITERACY.RST.6-8.7
Google has a great spread sheet program called sheets. It is similar to Microsoft Excel.
This project will use Google sheets to chart the predicted weather of a city over a one week period then graph the results automatically using Google sheets
The directions are step-by-step with pictures for each step. Very basic introduction to sheets a great into lesson. This can be done as a class or independently.
This project is designed to meet the Common Core Standard CCSS.ELA-LITERACY.RST.6-8.7
Grades:
4th - 12th
Types:
CCSS:
Modeling Population Growth 2 (Predator-Prey Spreadsheet Model)
This activity allows students to construct a quantitative predator prey population simulation on a spreadsheet. They will then study the behavior or the model based on various situations outlined in the analysis section. The model is programmed by the students and assessment questions guide the students through altering the model variables and observing the effects on the output of the model.
This works as a follow up to "Modeling Population Growth 1" from The Spreadsheet Lab Manual. After p
Subjects:
Grades:
9th - 12th, Staff
Types:
APES Energy FRQ warm ups
This is a tool I used for "warm ups" during the APES energy unit. I took pieces of released FRQ questions, and assigned one per day. Students have 5-10 minutes to respond, I pull up the scoring guidelines and students were expected to revise their answers. It works as a good warm up tool and great unit study guide!
Subjects:
Grades:
11th - 12th
Types:
Biotic Index Field Study
In this outdoor Field Study, students compare the ecological health of two freshwater sites based on macroinvertebrate biodiversity found using leaf packs. GOOGLE DOC & easy to use GOOGLE SHEETS INCLUDED!Also includes Quizlet Set and other Resources!STEPS:Collect leaves and place them in a mesh or coconut fiber bundle (leaf pack).Students place the "leaf pack" on the bottom of a freshwater stream.Students will return to the sites to collect the leaf packs after 1-3 weeks. Bins, dissection
Subjects:
Grades:
8th - 12th, Higher Education
Types:
NGSS:
HS-LS2-2
Eco-Footprint Score Calculator/Analysis
Students can automatically calculate their ecological footprint in an easy to use spreadsheet. It is organized by category, and students will input their score for each activity. Scores are then automatically calculated for each category of impact - later providing the number of acres to sustain their lifestyle. A pie chart and data table will automatically be generated for them to use for analysis. Feel free to modify the assignment any way you see fit for your classes, I hope you enjoy the spr
Subjects:
Grades:
6th - 12th
Types:
NGSS:
HS-ESS3-4
Carbon Footprint Project (FULL BUNDLE!): Chemistry or Environmental Science
This project gives a template for students to calculate their Carbon footprints using skills that are important for Chemistry and/or Environmental Science (e.g. dimensional analysis, understanding the carbon cycle, understanding that different gases have different warming potential, etc). This lays out a comprehensive way to calculate Carbon Footprint particularly at a boarding school in Southern California. You can easily adapt this project for your needs or how much time you'd like to spend on
Subjects:
Grades:
7th - 12th
NGSS:
MS-ESS3-2
, HS-ESS3-2
, MS-ESS3-5
, HS-ESS3-1
, MS-ESS3-4
...
BUNDLE - Enviro Data Series - Using Microsoft Excel to Explore Climate Science
This bundle is a set of 3 Excel Spreadsheet Climate Investigations that can be used together or independently. Some basic knowledge of Microsoft Excel is helpful.
SAVE 50%!
This $6.00 bundle represents a discount of 50%, equaling a savings of $6.00 over the cost of purchasing all data series investigations individually.
Included in the Bundle:
Water Budget Modeling - COMING SOON!
Exploration of Temperature Anomalies
An Historical Record of CO2
Ice Sheet Modeling
You Might Also Like:
Environ
Subjects:
Grades:
10th - 12th
Types:
Interactions and Ecosystems Activity Bundle
Designed to support hands-on environmental education. Includes a FREE long-range planner template!Originally designed for use in the Alberta Science 7 Curriculum. I have taught these lessons for a few years and students have been engaged and excited throughout the lessons. Requires minimal planning and materials, and each can be done in one 60 min class.
Subjects:
Grades:
6th - 9th
Types:
Stream Ecology: Benthic Macroinvertebrate Data Sheet (Part 4)
Data sheet in google sheets which is template for collecting/analyzing data for stream ecology sampling lab for Benthic Macroinvertebrates (Stream Bugs/Aquatic Insects) to middle, high school, or college students! Includes calculations on Biodiversity (% EPT Taxa, Dissolved Oxygen, and Shannon-Wiener Index). This spreadsheet can accomodate many different sampling groups and tabulates results in final sheet.~~ Note: this is PART 4 of larger STREAM ECOLOGY AQUATIC INSECT SAMPLING bundle - you can
Subjects:
Grades:
9th - 12th, Higher Education
Types:
NGSS:
HS-LS2-3
, HS-LS2-4
, HS-LS2-1
, HS-LS2-6
, HS-LS2-2
Also included in: Stream Ecology Lab: Benthic Macroinvertebrates (FULL BUNDLE!)
Biome Climatograph Creation and Analysis
In this digital lab students will take the ecological (temperature and precipitation) data for 12 cities in the US and create excel graphs to analyze and place each city into a biome. Included is a word document with instructions and questions, an excel file of entered data for students to just create a two y-axis graph in excel and a file of correct graphs for comparison.
Grades:
9th - 12th
Types:
NGSS:
HS-ESS2-4
, HS-LS2-2
Energy Flow Crossword Puzzle (electronically fillable & printable)
From this crossword puzzle, students will: (1) describe the different levels of organization that ecologists study; (2) describe the two main forms of energy that power living systems; (3) describe the flow of energy among organisms in an ecosystem; and (4) state the proportion of energy that is transferred from one trophic level to the next.
Words used include: community, ecosystem, producer, autotroph, consumer, heterotroph, photosynthesis, chemosynthesis, herbivore , carnivore, omnivore, det
Subjects:
Grades:
9th - 12th
Types:
Reduce, Reuse & Recycle Computer Lessons - Earth Day Word, Excel & PPT Lessons
If you are looking for Computer Lessons to teach students some basic features while teaching a subject, these lessons will deliver! Three activities for students to use Excel, PowerPoint, and Word.Students will use Excel, PowerPoint, and Word while learning more about Reducing, Reusing, and Recycling. These lessons are great for Earth Day lessons but because they focus on Reducing, Reusing, and Recycling, they are perfect year round lessons.Excel is a great way for younger students to learn to w
Grades:
3rd - 5th
STEM Air Pollution Personal Survey DATA GRAPHING ACTIVITY MS-ESS3-3 EARTH DAY
Middle school data graphing activity for students to learn about their own impact on air pollution. The activity involves tracking their family car for a week, with privacy measures in place, recording their trips and approximate mileage.Note: If tracking the family car is not feasible for your population, I have included realistic data to be used instead. They then classify the trips into 3 categories; necessary, luxury or semiluxury. Using this data, they do multiple graphing activities t
Subjects:
Grades:
6th - 9th
Types:
NGSS:
HS-ESS3-2
, MS-ESS3-3
Also included in: 10 STEM PROJECTS For Middle School- Physics, Life, Environmental Science
Tragedy Of The Commons Game (no food required!)
Looking to play/model the Tragedy Of The Commons without food? Try this game! This excel spreadsheet keeps track AND calculates various values of a shared resource -- fish! All you need to do is set-up groups and fish! The spreadsheet has editable cells for input of country names and quantity of fish. All other info is collected automatically. Rules/set-up is explained on the first worksheet. The second worksheet contains the fish the groups are going to "take" from the common resource. The thir
Subjects:
Grades:
6th - 12th
Types:
VOLCANO Crossword 1 STEM
This 35 clue puzzle comes complete with a one-page-front-and-back handout (from NICERC.org) that has ALL of the content/answers on it. This activity is totally self contained - Just pass it out and tell them to begin! Key included.This could be used to INTRODUCE your Volcanoes Unit; or as a SUB DAY activity; or as an ENRICHMENT activity - after the unit, give this to students WITHOUT the handout - see how much they know!SAMPLE CLUES:2 This can disrupt airplanes for many miles. 3 The
Subjects:
Grades:
5th - 12th
Types:
Homeostasis Game
This is a card game for students to understand balanced and imbalanced ecosystems. Directions for preparing the game and playing the game are included. It is a Microsoft Excel file.
Subjects:
Grades:
4th - 6th
Types:
Pixel Puzzle: Pressure Systems
Vocabulary and concept activity or review for pressure systems.As students complete the activity, a pixel image will appear. Pixels appear every time a correct answer is provided, the entire image will be visible when the activity is correctly completed. A great, quick, activity while also allowing the students to check their own answers!
Subjects:
Grades:
6th - 12th
Types:
Ecology City Planning Project and Game Part 2
Part 2
20 minutes of planning.... 4 days of "educational fun"
Students will design and build a fictional city based on a balance of the needs of the people and the needs of the environment.
Great end of the year project. Time frame is 3 to 4 days maybe a week.
Supplies: copies of student packet, copies of the City Map (maybe on cardstock), copies of game pieces, ziplock bags, glue sticks, colored pencils
There are 4 parts to the activity
Part 1 The student worksheet
Part 2 The game p
Subjects:
Grades:
7th - 10th
Types:
Showing 1-24 of 36 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands