Cate Jarvis (http://catejarvis.wordpress.com/ @blinkingnora), one of our technology teachers at ISZL, created a series of videos to help my students with data processing using excel, especially for laboratory reports #MYPSci, internal assessment #IBBio and lab investigations # APBio.
Watch, Learn and Enjoy!!
This one shows how to use excel to calculate average (remember to name it mean for DP Bio), maximum and minimum (important for MYP, DP and AP will use Standard deviation instead), or other basic operations instead of using a calculator. It is very good to learn about the ways to replicate your formula in other cells, this way if you have lots of data (200?) you do not have to type every time but just pull down!