54 results
Physics laboratories for Microsoft Excel
BACK TO SCHOOL BUBBLEGUM SCIENCE LAB
Break the ice of the first few days of back to school science class, while teaching your students your expectations of how to write an excellent lab report. This fun, high interest student lab does just that. In groups of three, students will chew bubblegum and measure the bubbles to see if sugar free bubblegum makes bigger bubbles than regular bubblegum. Students can collect their data on the form provided and use our pre-formatted Microsoft Excel spreadsheet to create a line chart and colu
Subjects:
Grades:
7th - 12th
Types:
6 Do At Home Physics Labs
These labs can be performed in school or at home with or without partners. Equipment needed: m&m’s; cell phone or watch w stopwatch function, clay or Play Dough; small stones; a marble or a golf ball; a couple of rulers or small sticks; a 2-foot board or cookie baking sheet; 2 books or boards to slap together to make a loud noise. Included are:1. Measuring the acceleration of gravity. Drop stones out of a second story window or down a stairwell and measure fall times with stopwatch on a c
Subjects:
Grades:
10th - 12th
Types:
CCSS:
Water Droplet Velocity and Displacement Activity
This is a fairly simple to perform data collection activity to illustrate the concepts of one-dimensional motion and the associated graphing techniques. Students will use plastic water bottles to perform a series of motions and collect data. The data can then be analyzed using included Excel automatically calculating workbooks in two follow-up lessons. This activity can easily be performed in a distance learning setting as it uses materials found in most households.
Subjects:
Grades:
8th - 12th
Types:
CCSS:
NGSS:
HS-PS2-1
Study the acceleration of a Rocket - video analysis
Use video analysis to measure the acceleration of a falcon 9 rocket. How to determine the position, velocity, and acceleration of the rocket over time? How to use the data collected to analyze the rocket's motion? This lab activity is divided in four main sections, Introduction, data collection and data plotting , Analysis questions, and post-lab questions. any online source showing telemetry from a rocket launch may be used.
Subjects:
Grades:
9th - 12th, Higher Education, Adult Education, Staff
Types:
LAB - How fast is a solar cart?
Students study the motion of a solar powered cart using video analysis.Students will determine the speed of a solar cart from a position vs. time graph, and they will also be able to use the information from the chart to describe the motion. Is the velocity of the solar powered cart constant? How constant the velocity is?A video of the motion is uploaded for the video analysis, and a key is also provided. results may differ depending on the cart used.
Subjects:
Grades:
9th - 12th, Higher Education, Adult Education, Staff
Types:
Gravity and Circular Motion for AP-C Physics-bundle
This bundle includeslecture notes on Newton's Law of Universal Gravitation, weightlessness and orbits as the result of free fall around a curved Earth, and motions that result from a centripetal force (including vertical circles, horizontal circles, and orbits) as well as additional information (how the calculus Newton developed leads to the inverse square law, demo and handouts for vertical and horizontal circular motion, escape velocity and orbits as bound systems)circular motion lab and analy
Subjects:
Grades:
9th - 12th
Types:
Waves Lab Electronic Notebook : ELN: Waves Unit
Electronic/Digital Lab Notebook in Google Sheets, Numbers and Excel. I created this to streamline the Lab Process. It can be paired with IoT sensors.This Lab Notebook is divided up into a Dashboard, Pre-Lab Inquiries, Observations Log, Data Analysis, and Post-Lab Inquiries.This meets the Scientific Process and Science Inquiry requirements. The Observation Log houses the unit's vocabulary with links to the definitions so students can reference itas they enter data. There is an automatic graph, Ti
Grades:
6th - 12th
Types:
Acceleration of a cart in a ramp
Students will be able to measure the acceleration of a cart down the ramp for different inclination angles, collected data may be used to predict the acceleration of the cart for an angle of 90 degrees by extrapolation. A graph of acceleration vs. sine(angle) should yield a strait line with a slope equals to the free fall acceleration g. A key and student sample data is provided.
Subjects:
Grades:
10th - 12th, Higher Education, Adult Education, Staff
Types:
Physics Lab Bundle: Interactive Spreadsheets
When run on a computer these 11 labs act like a teacher, flagging possible errors and encouraging students to do their best. They’re the result of my 13 years’ experience and are designed for an algebra-based physics course. All the files are templates, so they can’t be accidentally over-written. These interactive labs help students get the most out of the lab experience. When needed, error messages pop up addressing students by name, e.g.: “Mike, your calculations don’t follow from your input d
Grades:
10th - 12th, Higher Education
Types:
Pi activity for High School students
Determining the value of π experimentallyIn this activity, students use circular objects to find the value of pi (π) experimentally. It can be used as a lab activity in Science classes where students practice their data collection and graphing skills. OR, math teachers can use it as an activity for Pi Day. The activity goes over two methods to plot the data collected: MS Excel and graph paper. For students who have not mastered MS Excel graphing skills yet, the activity involves a link that help
Grades:
9th - 12th
Types:
Hooke's Law graphing lab
Simple STEM focussed activity to teach Hooke's law. Students will collect data, and analyze it graphically. The lab looks at solving Hooke's law problems by graphing data and then using the graph to solve problems about each specific spring. Some basic spreadsheet skills are also taught with this exercise, as students use Google sheets to develop and analyze their graphs.There is minimal set-up required, and not much equipment is needed. Teachers will only need 5 different "springs" (rubber band
Subjects:
Grades:
9th - 12th
Types:
High School Physics - Solar System Lab
This is a computer lab for consolidating astronomy based concepts such as Kepler's laws, Universal gravitation, escape velocity and satellite motion. This package includes a powerpoint for introducing Kepler's laws, an excel file with the orbital elements of the planets, and a fill-in-the-blanks document that guides the students through the tasks of the lab. This is a good activity to do in a high school physics class that covers astronomy related topics. It also gives students good experience i
Subjects:
Grades:
10th - 12th, Adult Education
Types:
CCSS:
NGSS:
HS-ESS1-4
Computer Skills for Science
This is a tutorial assignment for students to teach them the necessary skills in Word and Excel in order to type a proper lab report and to analyse their lab results. It also explains how to perform these skills in other platforms as well such as Google Docs and Sheets. This bundle includes the 2 other extension tutorial assignments for more advanced functions in Excel.
Subjects:
Grades:
9th - 12th
Types:
Human power lab - calculations
This lab allows students to workout in a weight room and measure the power of major muscle groups. There is a worksheet to record data on paper while working out, and a google sheet to automatically calculate the work done and power used for each exercise. Of course, you could have the students calculate everything themselves, but this is used as an introduction to power before we break out the calculators. The final google doc is a set of four conclusion questions.
Subjects:
Grades:
9th - 12th
Types:
Also included in: Human Power Lab Bundle
LAB-Acceleration of a cart on a tilting incline
Students investigate the acceleration of a cart down an incline for different incline angles, they will use the data obtained in this investigation to estimate the acceleration the cart would have if the angle is 90 degrees (vertical drop). This lab may be used to make the connection between accelerated motion and free fall motion.
Subjects:
Grades:
9th - 12th, Higher Education, Adult Education
Types:
All in one conversion table
The conversion table has just about everything you need to make your daily conversions as well as the scientific conversions that are a bit tougher to do. This spreadsheet contains eight different conversion tables that are easy to use. Each conversion starts with one starting unit that is then converted to all other types of measurements within that group.
Subjects:
Grades:
3rd - 12th, Higher Education, Adult Education
Types:
Computer Skills for Science - Excel Extension Part 2
This is a tutorial assignment for students to build on their skills in Excel in order to type a proper lab report and to analyse their lab results. It is the second expansion on using Excel for data analysis. The original and first expansion are in my store.
Subjects:
Grades:
9th - 12th
Types:
Also included in: Computer Skills for Science
Computer Skills in Science Extension Activity for Excel
This is a tutorial assignment for students to continue to build on the necessary skills in Excel in order to analyse data for their lab results. There are 1 other extension tutorial assignment for more advanced functions in Excel in my store.
Subjects:
Grades:
9th - 12th
Types:
Also included in: Computer Skills for Science
Golden ratio class activity / lab
Determining the value of golden ratio experimentallyIn this activity, students use golden rectangles to find the value of phi (φ) experimentally. It can be used as a lab activity in Science classes where students practice their data collection and graphing skills. OR, math teachers can use it as an activity for golden ratio related topics such as Fibonacci sequence.The activity goes over two methods to plot the data collected: MS Excel and graph paper. For students who have not mastered MS Excel
Grades:
9th - 12th
Types:
Universal Gravitation Lab Grading Spreadsheet
One of the greatest things about these labs is that each student (or lab group) is responsible for generating their own data, which leads to individual answers. The problem is that grading can be complicated…until now! These grading spreadsheets were originally only available on CD-ROM…but now they can easily be downloaded and used. When the teacher wants to grade a lab, they simply enter the student data into the yellow spreadsheet cells. Then the pink cells automatically calculate the answ
Subjects:
Grades:
7th - 12th, Higher Education
Types:
Inclined Planes and Friction Lab Grading Spreadsheet
One of the greatest things about these labs is that each student (or lab group) is responsible for generating their own data, which leads to individual answers. The problem is that grading can be complicated…until now! These grading spreadsheets were originally only available on CD-ROM…but now they can easily be downloaded and used. When the teacher wants to grade a lab, they simply enter the student data into the yellow spreadsheet cells. Then the pink cells automatically calculate the answ
Subjects:
Grades:
7th - 12th, Higher Education
Types:
LAB-Determine the acceleration of a pull-back toy cart
In this activity student will use a motion sensor to collect the position of a pull-back toy cart. Students will use the equations of kinematic to determine the acceleration from a velocity vs time graph, or a position vs time graph. Students will use the information obtained to answer the post lab questions. Students also will learn and practice on data collection, and display using data tables and graph.
Subjects:
Grades:
8th - 12th, Higher Education, Adult Education
Types:
How fast is a solar powered cart?
Lab activity:Use video analysis or similar technology to measure the velocity of a solar powered cart. Students will learn how to use excel or google sheets to graph data, plot a graph and obtain information from the graph as evidence to support a claim. Students may work in groups share the work, compare and communicate their results to the rest of the class. Students explore concepts like average velocity and instantaneous velocity.
Subjects:
Grades:
8th - 12th, Adult Education
Types:
Free Fall Lab Grading Spreadsheet
One of the greatest things about these labs is that each student (or lab group) is responsible for generating their own data, which leads to individual answers. The problem is that grading can be complicated…until now! These grading spreadsheets were originally only available on CD-ROM…but now they can easily be downloaded and used. When the teacher wants to grade a lab, they simply enter the student data into the yellow spreadsheet cells. Then the pink cells automatically calculate the answ
Subjects:
Grades:
7th - 12th, Higher Education
Types:
Showing 1-24 of 54 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands