Department of Physics and Physical Oceanography


 
Welcome to our webpage for online tutorials. On this page you will find tutorials that will help you learn the basics of how to use Excel and Mathematica.
 

Excel Tutorials:


Turorial 1:
This tutorial will introduce you to the basic features of Excel such as the worksheet environment and various tools bars. People who are familiar with Excel may want to skip to the next tutorial.
 
Tutorial 2:
This tutorial will show the viewer how to insert data into cells, how to use formulas to calculate data and how to plot and print your results.
 
Tutorial 3:
This tutorial shows how to import and plot foreign data into Excel. Also using the Solver tool we show how to fit any equation to experimental data.
 
Mathematica Tutorials:

Tutorial 1:
An introduction and guide to the Mathematica Interface. This tutorial will explore the main toolbar and describe some of the main features of Mathematica. People who are already familiar with Mathematica can go to Tutorial 4.
 
Tutorial 2:
An introduction on Mathematica syntax and entering data into Mathematica. This tutorial will show how to input questions into Mathematica and how to perform operations.
 
Tutorial 3:
An introduction to the main syntax of Mathematica, and how to search the help topics. How to define functions and values in Mathematica. As well, understanding the output.
 
Tutorial 4:
An introduction on how to manipulate algebraic functions by factoring, expanding, solving and simplifying.
 
Tutorial 5:
This tutorial will demonstrate how to solve and simplify systems of equations by eliminating variables, solving, and finding the roots.
 
Tutorial 6:
This tutorial explains how to define functions in Mathematica and how to enter built in functions. It also covers basic plotting, labelling your plot, plot options, and also it will show how to find a minimum on a graph.
 
Tutorial 7:
This tutorial will show how to combine plots in Mathematica by using different colours to distinguish between them. It will also show some more advanced graphing.
 
Tutorial 8:
This tutorial will show how to enter data into a list plot and how to characterize the plot by using different options available for list plots. It will also show how to fit data to a model. Finally it will show how to apply error bars to your data points in a list plot.
 
Tutorial 9:
This tutorial will demonstrate how to rearrange equations using Mathematica. It will also show some statistical measurements. This tutorial is also an introduction to entering matrices into Mathematica and using basic operations to manipulate the matrices.
 
Tutorial 10:

This tutorial will show how to find the determinant, transpose, and inverse of a matrix. It will also show how to find the eigenvectors and eigenvalues of a given matrix.

 
Tutorial 11:
This tutorial will show how to differentiate, integrate and how to find limits of functions using Mathematica.
 
Tutorial 12:
This tutorial will show how to solve ordinary differential equations. It will also introduce how to create a power series and how to manipulate series using basic operations.
 

Visitors to this site: Hit Counter
Web Site Hit Counter