23 results
Free physics resources for Microsoft Excel
Significant Figures Card Sort
Review significant figures with this card sort! Can print, laminate & cut out.Can use the following ways:Card sorts for individual students, pairs or groupsGive one numbered card to each student, and have them physically sort themselves into correct groups
Subjects:
Grades:
10th - 12th
Types:
Velocity vs. Time Graphs - Area and Slope
This is a daily do now that generates and randomizes the numbers for interpreting velocity vs. time graphs that have constant acceleration. It asks for the acceleration of the car and the distance covered in a time interval. You can make an infinite number of problems with the file due to the randomization. Ideal for daily warm ups and quizzing students on skills aligned to standards.
I focus on one skill a week. Every day they practice the skill at the beginning of class. At the end of the wee
Subjects:
Grades:
9th - 12th
Simple Machines: Notes
Simple Note taking Chart for Simple Machines Unit.
Subjects:
Grades:
3rd - 5th
Types:
Kirchhoff's Laws Drill: Physics Question Generator
Dear Physics Teachers,1. This resource will help you students practise their circuit analysis skills.2. This resource is to be projected on a screen, used by students on a computer or used to print worksheets.Info:I analysed 185 past paper questions about electric circuits and identified 20 unique circuit topologies that are assessed. I then distilled those 20 into one, whose components can be replaced at random to produce the 20. This spreadsheet generates an almost unlimited number of circuit
Subjects:
Grades:
8th - 12th, Higher Education
Types:
Simplified Projectile Motion Activity
This simplified activity can be used during the discussion on projectile motion in classes more pressed for time or where students have not yet been exposed to trigonometry. This activity allows students to use an Excel workbook to calculate the horizontal displacement in order to place a target when the initial velocity, angle, and height of the projectile launcher are known. The digital download includes:- The Excel calculation workbook- An activity sheet to guide students through the activi
Subjects:
Grades:
6th - 12th
Types:
NGSS:
HS-PS2-1
Stephanie Elkowitz Physical Science Lessons Catalog
This download includes an Excel sheet of all my available Physical Science lessons with learning objectives and links. Lessons are organized by subject and unit.Interested in a custom bundle? Visit www.stephanieelkowitz.com/custom-bundle for additional information. *********************************************************************************************************PHYSICAL SCIENCE LESSONSAtoms• History of Atomic Science• Atomic Structure (MS-PS1-1)• Electron Configuration• Atomic Mass &
Subjects:
Grades:
3rd - 9th
Ohm's Law Calculator
This physics calculator calculates total current, total voltage, and total resistance.single resistor, for more resistors look at our Circuits: Series CalculatorINPUT: 2 of 3 variablesOUTPUT: answer with 3 incorrect choicesCHOICES: many of the choices are calculated using common algebra mistakes(Excel File: no macros)ALSO INCLUDED:Random number generator (helps with creating multiple versions of the same worksheet)Drill Work - example worksheets (Word)OTHER USES:create multiple versions of the i
Grades:
9th - 12th
Types:
Smartphone spectroscope exercise
A spectroscope is used to identify and characterize substances. This exercise has students calibrate a smartphone spectroscope and use it to observe line emission spectra.
Subjects:
Grades:
9th - 12th, Higher Education
Types:
6/25Work,MA (mech adv),IMA,&efficiency calculation practice on Excel,self check
This is an Excel spreadsheet (expires 6/2025, update available annually) exercise allowing students to practice calculations of work input and output, mechanical advantage, ideal mechanical advantage, and efficiency. The spreadsheet is set up to provide a unique set of problems for each student, so while students can help each other in how to do calculations, they can't just copy answers (unless the teacher wants them to). This exercise is similar to other Excel exercises I have created for va
Subjects:
Grades:
9th - 12th
Types:
Google Sheets 8.5x11 Quick Reference for Science & Engineering
This is a quick reference sheet for using Google Sheets in the Sciences and Engineering. It is broken down into the following areas:
- Data Table Calculator
- Working From a Theoretical Equation
- Working from Experimental Data
- Comparing Experimental Data to a Theoretical Equation
- Calibrating Sensor Data
Subjects:
Grades:
9th - 12th, Higher Education
Dealing with Data on Excel - sample data
This is a free companion document with the “Activity - Dealing with Data on Excel”. It is the complete spreadsheet that students will create during the activity, and it can be used by the teacher to evaluate student progress.
Physics design lab template
Students are provided with a general design lab template, with suggested point allocations, as described by the following outline:
Title and experimental statement/question
Experimental procedure
Materials list
Free body diagram
Sample calculations
Graphical analysis
Conclusion and analysis
Subjects:
Grades:
8th - 12th
Work and Power on Excel; self checking, immediate feedback
This Excel assignment is intended to give students practice on calculating work, force, distance, power, and time. Expires 6/2020. Students should have covered or have a reference to the equations relating the above factors. The assignment then gives each student a unique set of problems to solve for the various factors when the other factors are known. Therefore, while students can help each other, students can't simply copy each others answers. The student needs to fill in the yellow cel
Subjects:
Grades:
8th - 12th
Types:
Projectile Motion Calculator
This excel spreadsheet calculates the total travel time, time to reach peak, maximum range, and maximum height of a projectile. The user simply enters in the speed, launch angle, and surface gravity of whatever planet you're considering and the spreadsheet will do all of the calculations. It also graphs the trajectory.
Grades:
10th - 12th, Higher Education
Types:
Electric Charge Converter
This physics calculator converts between charge and electron gain/loss.INPUT: quantity of electrons gained or lostOUTPUT: charge of objectorINPUT: charge of objectOUTPUT: quantity of electrons gained or lost(Excel File: no macros)OTHER USES:create questions on the fly when reviewing for an assessmentcheck keys for assignments collected from fellow teachers, internet, and district share drivesEXCELLENT for ensuring each and every student is getting the practice they need instead of copying from e
Grades:
9th - 12th
Types:
Also included in: Electrostatics Calculators: Bundle
Speed Lab Baseball and Softball with MPH conversion Graphs
Take the data from the Speed Lab Baseball and Softball and "Graph it"
Bar Graphing
Subjects:
Grades:
6th - 11th
Types:
Go4Schools Create New Task Timesaver
Go4Schools is very clunky and time-consuming when it comes to entering data.To enter homework you can go to the Create New Task window but this takes a long time.This little application is an Excel spreadsheet which allows you to enter your homework efficiently in the form of a grid.It then transfers your information, row by row, into the format needed by Go4Schools so that you can simply paste each row of data.
Subjects:
Grades:
Staff
Physics Analysis Spreadsheet Template (QCAA IA2)
This template can be provided to students to help them analyse their IA2 data and create appropriate graphs. The majority of calculations are automated, and the spreadsheet will create the following graphs - all trials, mean, linearised mean and measured vs theoretical.
Subjects:
Grades:
11th - 12th
Types:
Also included in: QCAA Physics IA2 Bundle
Terminal Velocity Simulation Written on a Spreadsheet
EXPAND THE USE OF SPREADSHEETS IN YOUR PHYSICS CURRICULUM... This Physics activity good for all levels of Physics is a free preview of "The Spreadsheet Lab Manual." It guides students to construct a mathematical simulation starting from a blank spreadsheet that quantitatively models freefall with air resistance as an object reaches terminal velocity. Students will be guided through an inquiry based simulation as they answer assessment questions and gain skills on spreadsheets while manipulati
Subjects:
Grades:
9th - 12th, Higher Education, Adult Education, Staff
Types:
Mouse Trap Car Project Teacher Ballots
Here is the grading ballots for my mousetrap car projects. It goes along with the project I have posted in my store.
Subjects:
Grades:
6th - 12th
Types:
Law of Universal Gravitation Calculator
This Excel calculator goes with the activity "Newton's Law of Universal Gravitation."
It calculates the force due to gravity between 2 objects.
It is locked.
Subjects:
Grades:
9th - 12th
2020-2021 Science- Apollo 11 Addendum
This is a free addition of questions on Apollo 11. I missed it while originally making the questions.
Subjects:
Grades:
9th - 12th
Also included in: 2021 Cold War Science Questions
Calculating Work
Students enter the missing information into the cells to show they understand how to calculate work.
Subjects:
Grades:
7th - 8th
Types:
Showing 1-23 of 23 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands