Wednesday, February 10, 2016

Free Linear Graphing Template for the 2016+ IB Physics Syllabus

 Update: new, free, version released. See post here.

 
Download the Free Version of the IB Physics Graphing Template for 2016+ Here!

Enter your Data and Uncertanties and Let Excel Draw your Graph!
IB Physics Students Graduating in 2016 and later face a larger and more sophisticated Internal Assessment (IA). When it comes to making Linearised Graphs, the biggest difference is that students should now consider all their data when drawing best-fit, max, and min trendlines. 
Fortunately, I've updated the IB Physics Graphing Template to help do just that! Now when it calculates the max and min trendlines, it will search through every possible combination of corners of your data and select only the most extreme slopes that pass through all your error bars:

The Max and Min Trendlines consider all data points.

That's not the only update. Based on my experience with my own students, I've added a slider to adjust the number of significant figures reported in the trendline equations:

You can adjust the number of Significant Figures in the trendline equations.
The last big update is that the template now offers you feedback on your graph and data, to help you spot mistakes, make your analysis, and draw conclusions! For example, the last data point in this graph appears to be preventing any straight line from fitting through all the error bars:


The last data point appears to be preventing any straight line from fitting through all the error bars
To help students catch these issues, the template offers feedback:
The above error is automatically generated to let you know that something has gone wrong with your graph

Anyone can download and share the free version of the template which offers all the above features forever for as many graphs as you like. If you are a Physics teacher, you may be interested in purchasing a school-wide license for the full version which offers two extra features:

Additional Full (Paid) Version Features:

  • Demonstrate Animated Graphs (like the video at the top of this post)
  • Receive further feedback beyond error messages. How much frustration will you save if your students were automatically reminded of key bits of information like:

Example of Additional Feedback available in the Full (Paid) Version


Example of Additional Feedback available in the Full (Paid) Version
The full version comes with a school-wide license that doesn't expire, or require account management. Just share the file with your students like you would any other file. You can purchase the full version from the store in the upper right hand side of this page.

FAQ


Operating System Compatibility:

No matter what your operating system is, your going to need Microsoft Excel installed. The template will not work with other spreadsheet software like Numbers, Open Office, or Libre Office.
The template works very well in Windows, and acceptably well in Mac OS although I would suggest you download the free version to test functionality on your system before buying a full version license. Linux is untested at this time.

Macros:
 Because this template has a lot of new, sophisticated functionality, it wasn't possible to build it without Macros. Macros are extra bits of software written by the spreadsheet author (me, in this case) to add functionality to the spreadsheet. You must enable macros to run this software. If in doubt, talk to the IT department at your school.

Support:

 I'm not able to offer a guarantee of support but I will do my best to help you out if you have problems. Just post a message in the comments below and I'll get back to you. I'd recommend you check out the free version before buying the full (paid) version to make sure it meets your needs.

It's Running So Slowly!

In my experience the process of drawing the graph takes quite a while if: your on a Mac, you have a lot of data, or you are animating the graph. To keep things running smoothly, consider un-checking the "automatically generate graph" box. Once you've finished entering your data and uncertainties, then click the "generate graph" button. This way, nothing happens in the background until you're ready.

8 comments:

  1. I downloaded the free version which is very easy to use. However is there a feature to allow for a curve line in the free or paid version<

    ReplyDelete
    Replies
    1. Neither version has special features for Curved Fits, but both versions will allow you to fit a curve using the built-in excel tools though:

      https://support.office.com/en-US/Article/Add-a-trend-or-moving-average-line-to-a-chart-3c4323b1-e377-43b9-b54b-fae160d97965

      The tricky thing about fitting curves is that while there is only one "best" fit for a curve, there may be many "maximum" or minimum" curves. In a linear equation, the slope and the y-intercept are both maximised or minimised for the same condition - steepest line that fits all the error bars. However for curves, there can be competing parameters - one may not be maximised under the same conditions as another. I don't know if an automated tool could do that for you.

      Delete
  2. It says that I need a password to make changes to the template...

    ReplyDelete
    Replies
    1. You're not really supposed to make changes outside of the data fields because you can break functionality in unexpected ways.

      However, if you want to get adventurous, here's the password: ISjsd(Sk2

      Delete
  3. Why are the max min lines not working when error bars are small???? plz help

    ReplyDelete
  4. The program looks for the steepest and shallowest lines that fit all the error bars. If the error bars are very smaller, but the data isn't actually very close to a straight line, then no straight line will fit through all the error bars and no steepest and shallowest lines meet the criteria. If that's the case for you, re-consider the size of your error bars or the linearization you chose.

    ReplyDelete
  5. Is is possible to get a FREE version of the graphing template that is compatible with Google Sheets for students who do not have MS Excel?

    ReplyDelete
    Replies
    1. Hey, funny you should ask. I have just finished the newest version of the graphing program and it's free. You can read more about it here: https://davidkann.blogspot.com/2021/02/free-linear-graph-template-with-error.html

      As for compatibility, I would say it is compatible with google sheets in the sense that you don't need google sheets or MS Excel or any other particular software to run the newest version. Just your browser. You should be able to copy/paste your data from Google Sheets or wherever into the table at https://ibphysicsgraphjs.herokuapp.com/

      Delete