45 results
Higher education biology resources for Microsoft Excel
Digital biodiversity Simpson Index virtual interactive lab sheets answer key
*Editable resource*Link provided to easily copy to Google DriveObviously field study is preferred as the most effective form of research although lack of travel funds and time may not allow field study in every area of study. Use this online virtual interactive lab to study the biodiversity of macro-invertebrates of a freshwater community. Students will use the online virtual freshwater stream linked here to collect, compare, and analyze the data acquired from the virtual non-polluted, moderatel
Subjects:
Grades:
9th - 12th, Higher Education
Types:
Carrying Capacity of Alligators | Graphing and Analyzing Data | Ecology
BIOTIC POTENTIAL CARRYING CAPACITY ENVIRONMENTAL RESISTANCE This is a Google Doc assignment with a link to a Google Sheets data sheet that the students will use to generate a graph. They then copy the graph into their Google Doc and then answer the questions about the carrying capacity, population dynamics, and biotic potential.
Subjects:
Grades:
9th - 12th, Higher Education
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:
Biology - DNA - Escape Room Challenge
Escape Room Time. This Challenge has 6 levels. Each level can only be unlocked when the previous level has been completed correctly. Included is the Excel document which self-checks. It will give a 4-digit code to open the lock and the lock will give a 6-digit code to unlock the next level. In addition is a pdf explaining how to use the excel file to complete. It is locked so that only the windows for answers can be inputted. This is a great assignment to asses students knowledge of the introduc
Subjects:
Grades:
5th - 12th, Higher Education
Types:
Also included in: Biology - Escape Room Bundle
Biology - Natural and Artificial Selection - Escape Room Challenge
Escape Room Time. This Challenge has 6 levels. Each level can only be unlocked when the previous level has been completed correctly. Included is the Excel document which self-checks. It will give a 4-digit code to open the lock and the lock will give a 6-digit code to unlock the next level. In addition is a pdf explaining how to use the excel file to complete. It is locked so that only the windows for answers can be inputted. This is a great assignment to assess students knowledge of Natural
Subjects:
Grades:
6th - 12th, Higher Education
Types:
Also included in: Biology - Escape Room Bundle
Punnett Square - Monohybrid Crosses - Self-Correcting Excel Worksheet
This Excel Spreadsheet is designed for Students to meet all types of Punnett Squares they will encounter when they begin to learn Genetics. This will familiarise students with dominant and recessive genes, Homozygous and heterozygous, and genotypes and phenotypes. This document will go perfectly with Genetics PPTDon't forget to leave feedback to earn points to use towards FREE TPT purchases!
Subjects:
Grades:
6th - 12th, Higher Education
Types:
Evolution of Cooperative Behavior Lecture + Activity Bundle
Lecture slides for evolution of cooperative behavior. Lecture objectives include:•Understand the costs and benefits of interaction•Define inclusive, direct, and indirect fitness•Differentiate between cooperation, mutualisms, and symbiosis•Discuss different hypotheses of cooperation (kin selection, group selection, altruism, reciprocity)•Understand evolutionary stable strategiesActivity to illustrate the evolution of cooperative behavior. Students will test different hypotheses through playing di
BLASTing through the kingdom of life answer key 2016
Updated August 2016. This Excel file has the answer key for BLASTing through the kingdom of life.
BLASTing Through the Kingdom of Life is accompanied by popular animated tutorial BLAST for beginners and a data set of 16 different sequences chosen to represent diverse forms of life. This activity is perfect for studying evolution and looking at evolutionary relationships.
Check out our new digital book to learn how we interpret the BLAST results for each of the 17 unknown sequences or get th
Subjects:
Grades:
9th - 12th, Higher Education, Adult Education
Types:
Island Biogeography Activity + Workbook
Activity to illustrate the main concepts of the theory of island biogeography using ping pong balls, cups, and bowls. Student play "island pong" to understand the impacts of isolation (distance) and island size on the number of species and species turn-over. Includes worksheet with questions and workbook to create figures and tables given the results of this activity.
Subjects:
Grades:
11th - 12th, Higher Education
Types:
Biology and Chemistry - Escape Room Bundle
This bundle includes 8 unique escape rooms based on the following topics. For BiologyDNA - Biology - DNA - Escape Room ChallengeGenetics - Biology - Genetics - Escape Room ChallengeNatural and Artificial Selection - Biology - Natural and Artificial Selection - Escape Room ChallengeGene Manipulation - Biology - Gene Manipulation - Escape Room ChallengeFor ChemistryChemical Processes - Chemistry - Chemical Processes - Escape Room ChallengeChemical Reaction - Chemistry - Chemical Reactions - Escape
Subjects:
Grades:
5th - 12th, Higher Education
Types:
Biology - Gene Manipulation - Escape Room Challenge
Escape Room Time. This Challenge has 6 levels. Each level can only be unlocked when the previous level has been completed correctly. Included is the Excel document which self-checks. It will give a 4-digit code to open the lock and the lock will give a 6-digit code to unlock the next level. In addition is a pdf explaining how to use the excel file to complete. It is locked so that only the windows for answers can be inputted. This is a great assignment to assess students knowledge of Gene Ma
Subjects:
Grades:
5th - 12th, Higher Education
Types:
Also included in: Biology - Escape Room Bundle
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
Island Biogeography Activity Results Datasheet
A workbook that creates figures and tables given the results of the "Island Biogeography Activity".Activity to illustrate the main concepts of the theory of island biogeography using ping pong balls, cups, and bowls. Student play "island pong" to understand the impacts of isolation (distance) and island size on the number of species and species turn-over.
Subjects:
Grades:
11th - 12th, Higher Education
Types:
Also included in: Island Biogeography Activity + Workbook
Fish Frequency Lab (Companion Spreadsheet) for Hardy Weinberg Equilibrium
This is the companion spreadsheet that will help calculate and display class data for the lab.Understanding natural selection and the Hardy-Weinberg Equilibrium equation can be confusing and difficult.Let this lab activity help clear some of the confusion for your students! In this laboratory activity, you will use fish crackers to help further your understanding of natural selection and the role of genetics and gene frequencies in evolution and natural selection.The only supplies you need are 2
Grades:
9th - 12th, Higher Education, Adult Education
Types:
NGSS:
HS-LS4-2
, HS-LS4-1
, HS-LS4-6
, HS-LS4-3
, HS-LS4-4
...
Biology - Escape Room Bundle
This bundle includes 4 unique escape rooms based on the following topics. DNA - Biology - DNA - Escape Room ChallengeGenetics - Biology - Genetics - Escape Room ChallengeNatural and Artificial Selection - Biology - Natural and Artificial Selection - Escape Room ChallengeGene Manipulation - Biology - Gene Manipulation - Escape Room ChallengeThis bundle is perfect for revision, review and concept checking. It is also a fun activity for students to complete within class or even at home. Create your
Subjects:
Grades:
5th - 12th, Higher Education
Types:
Evolution of Cooperative Behavior Activity Results File
MS Excel file used with the "Evolution of Cooperative Behavior Activity". This activity will illustrate the evolution of cooperative behavior. Students will test different hypotheses through playing different rounds of the Prisoner's Dilemma and then answer questions regarding their results. Works with the "Evolution of Cooperative Behavior Activity Datasheet" and the "Evolution of Cooperative Behavior Lecture Slides."
Subjects:
Grades:
11th - 12th, Higher Education
Types:
Also included in: Evolution of Cooperative Behavior Lecture + Activity Bundle
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!)
Teach With Fergy Resource Listing
Please download the free file to view my entire resource list.All of the files listed can also be purchased separately (simply click ctrl+left click) on the Excel document or as a whole by Purchasing My Store BY CLICKING HERE.**Please note** If you have purchased anything from my store in the past, I will refund the total amount of your purchases via PayPal ASAP once you send me an email with your TpT username - devon@teachwithfergy.comIf you purchase my store you will gain access to:- all of my
Subjects:
Grades:
3rd - 12th, Higher Education, Staff
Types:
Biology - Genetics - Escape Room Challenge
Escape Room Time. This Challenge has 6 levels. Each level can only be unlocked when the previous level has been completed correctly. Included is the Excel document which self-checks. It will give a 4-digit code to open the lock and the lock will give a 6-digit code to unlock the next level. In addition is a pdf explaining how to use the excel file to complete. It is locked so that only the windows for answers can be inputted. This is a great assignment to assess students knowledge of the int
Subjects:
Grades:
5th - 12th, Higher Education
Types:
Also included in: Biology - Escape Room Bundle
Cellular Respiration Crossword Puzzles (electronically fillable & printable)
From these crossword puzzles, students will: (1) describe the process of aerobic cellular respiration; (2) describe the stages of glycolysis, the Krebs cycle, and the electron transport chain; (3) identify the main reactants and products of those stages; (4) state where glycolysis, the Krebs cycle, and the electron transport chain occur; (5) describe the process of lactic acid fermentation and alcoholic fermentation, and explain their importance; and (6) describe the role of ATP in the cell.
Th
Subjects:
Grades:
9th - 12th, Higher Education
Types:
Population dynamic transition stages and survivorship with virtual cemetery data
Students will utilize this Excel Spreadsheet to study survivorship curves and transitional pyramid stages by collecting population data from either virtual cemeteries provided in the interactive or from local cemeteries in order to personalize the data and increase student investment. This resource can be differentiated so that all of the formulas are left in the spreadsheet or may be altered so the students are required to calculate their data and/or make their own charts.This would be a great
Genetics solver (monohybrid cross with codominant or intermediate inheritance)
Automated spreadsheet to determine the result of a monohybrid cross with dominance or intermediate inheritance.You can select the letter, description of the traits, and genotypes.The appropriate laws of Mendel appear when applicable.The spreadsheet is optimized for mobile use but can be used on other devices as well.You can easily translate this spreadsheet into your language and pass it on to your pupils.It can be used as a check during exercises or as a resource during guided independent learn
Subjects:
Grades:
9th - 12th, Higher Education, Adult Education, Staff
Types:
Homeostasis Heart Rate Lab
This lab can be used for middle school sciences, any Biology-based science class, or mathematics statistics classes. Included are a word document with instructions, lab, an excel spreadsheet with example data, a blank sheet with formulas that will calculate data, and a PowerPoint with student instructions.
Subjects:
Grades:
6th - 12th, Higher Education
Types:
Protein Synthesis Crossword Puzzle (electronically fillable & printable)
From this crossword puzzle, students will: (1) describe the overall structure of DNA and its components; (2) identify the complementary base pairs of DNA; (3) relate gene, DNA, RNA, and protein; (4) describe the overall process by which proteins are produced; (5) describe how the cell making proteins is like a factory making food items; (6) describe the structure of RNA; (7) describe the main differences between RNA and DNA; (8) describe the complementary base pairing in RNA; (9) describe the r
Subjects:
Grades:
9th - 12th, Higher Education
Types:
Showing 1-24 of 45 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands