26 results
Biology laboratories for Microsoft Excel
Living Environment Lab Tracker
Throughout the year, students are required to complete 1200 minutes of labs and their accompanying questions. This google sheets allows teachers to monitor students progress to see if they are on track for completion of lab minutes. It calculates the time student have completed and highlights the names of students that are regents ready
Subjects:
Grades:
8th - 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:
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:
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
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
...
The Effect of Cell Size and Osmolarity on Diffusion Rates Laboratory
This bundle provides the following materials: the laboratory handout for the lab, a spreadsheet designed for importing, processing and presenting student data, a rubric for grading and supplemental directions if you wish students to complete their own serial dilutions.
Subjects:
Grades:
11th - 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:
Science Lab Report Classical Conversations Challenge II Editable
I edit and use this to help my homeschooler with lab reports. We use it for Classical Conversations Challenge 2 Apologia Biology. You can use it for other curriculums. It is editable.
Grades:
8th - 12th
Flower Dissection with Pink Jasmine
Students will dissect a pink jasmine flower to review structure and function of plant reproduction parts. Included is a student handout that organizes student dissection as well as has an alternative virtual dissection website for those allergic to pollen. Students further demonstrate their understanding by creating similes for each structure and function of each flower part. Included are teaching tips and dissection tips gathered from 15 years of teaching experience. When my principal evalu
Subjects:
Grades:
4th - 9th
Types:
New York Regents Lab Minute Tracker (Self-Scoring)
New York State requires students obtain 1200 lab minutes in order to be eligible for the Regents Science Exams (Living Environment, Earth Science, Chemistry, and Physics). This tracker helps students stay accountable. This lab tracker requires students to update their copy to match yours. This will encourage students to become familiar with using google sheets. They will be responsible to enter basic formulas so the sheet can automatically tabulate if they earn the lab minutes according to NYS g
Subjects:
Grades:
8th - 12th
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!)
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:
Forensic Science RFLP DNA simulation activity
This is an excel file containing printable materials for use to simulate a very basic Restriction Fragment Length Polymorphism (RFLP) analysis of DNA.
This is a paper/pencil simulation of RFLP! It does not include animations or directions for the actual manipulation of DNA.
The activity has students analyze the DNA of 7 subjects, then compare those subjects' DNA to three known DNA sources.
Items include teacher directions, student directions, DNA strips to fill in, a simulated gel box to
Subjects:
Grades:
10th - 12th
Zoology Animal specimen lab post lab sheet (see Bundle)
Important Note: individual pieces of this lab are available separately in my store. I recommend getting the bundle to get the full lab. Because the lab includes a word doc, a power point and excel sheets I had to list items separately https://www.teacherspayteachers.com/Product/Kingdom-Animalia-Specimen-Lab-unit-3-5943527 Animal Specimen lab teacher instructions:This lab is designed to give students a chance to become familiar with terminology that they will be using throughout the zoology cours
Grades:
9th - 12th, Higher Education
Types:
Also included in: Kingdom Animalia Specimen Lab
Zoology Specimen Lab sheet 1 (see bundle)
Important Note: individual pieces of this lab are available separately in my store. I recommend getting the bundle to get the full lab. Because the lab includes a word doc, a power point and excel sheets I had to list items separately https://www.teacherspayteachers.com/Product/Kingdom-Animalia-Specimen-Lab-unit-3-5943527 Animal Specimen lab teacher instructions:This lab is designed to give students a chance to become familiar with terminology that they will be using throughout the zoology cours
Grades:
9th - 12th, Higher Education
Types:
Also included in: Kingdom Animalia Specimen Lab
Radish Seedlings in Dark and LIght: Spreadsheet for Class Data Sharing
This spreadsheet enables you to record class data for the Radish Seedling Dark and Light Experiment. You can read more of a description of this experiment at my website at http://www.sciencemusicvideos.com/curriculum/scientific-method-unit-with-handouts/
Look at the pdf preview to get a sense of the data layout. For classroom implementation, upload this spreadsheet to google so multiple student teams can enter data at the same time.
Subjects:
Grades:
9th - 10th
Types:
Genetic Phenotypes Lab
A fun class activity to interview their classmates on different phenotypes
Subjects:
Grades:
Not Grade Specific
Types:
Forces of Evolution Lab
Using beads or materials of different colors, student do tests lab to see how the forces of evolution operate
Subjects:
Grades:
Not Grade Specific
Types:
The Effect of Cell Size and Solution Osmolarity on Diffusion Rates Spreadsheet
This spreadsheet is designed to be used with the lab of the same name. It is available as part of a bundle as well, which also includes a rubric for assessment. I have found that students generally do not know how to effectively use spreadsheets, so I use this lab and spreadsheet application as a teaching exercise to make them more comfortable with spreadsheets. They will be using them throughout the year, so familiarizing them with this format is important. Each tab of the spreadsheet is used f
Subjects:
Grades:
11th - 12th
Types:
Also included in: The Effect of Cell Size and Osmolarity on Diffusion Rates Laboratory
Plant Field Lab Spreadsheet
Lab spreadsheet chart to fill out while performing outside plant activity
Subjects:
Grades:
Not Grade Specific
Types:
Plant Identification Comparison Spreadsheet
A spreadsheet to compare the differences between the plant types
Subjects:
Grades:
Not Grade Specific
Types:
Excel File to Collect Student Data for Genetics Monohybrid Crosses Exercise
This Excel file (valid 16/17 school year) is meant to be a means of collecting student data in a monohybrid cross exercise that would accompany a fundamentals of genetics lesson, such as the one found in Holt, Rinehart, and Winston's "Modern Biology." The lab is also available at http://www.central.rcs.k12.tn.us/Teachers/gullettp/documents/L-ModelingMonhybridCrosses.pdf, or http://content.ccsuvt.org/ehs/2010/08/Lab-Modeling-Monohybrid-Crosses-2011-2012.pdf (in the latter, the dominant trait is
Grades:
7th - 10th
Types:
Materials List for Honors Biology
The items listed in this Excel spreadsheet account for all labs and activities in our Honors Biology Full Year Curriculum for a 24-student class.All materials are organized alphabetically according to the following categories:ChemicalConsumableReusableSpecimenWhile cost estimates are included, prices widely vary based on region and other factors. These estimates are primarily included to enable quick calculations while ordering supplies for your classroom.Basic lab equipment, such as glassware &
Subjects:
Grades:
9th - 12th
Types:
Living Environment Lab Tracker
Throughout the year, students are required to complete 1200 minutes of labs and their accompanying questions. This google sheets allows students to monitor their progress to see if they are on track for completion of lab minutes.
Subjects:
Grades:
8th - 12th
Types:
Showing 1-24 of 26 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands