This Article is About
spreadsheet tools
line graph
small stuff
important things
Excel-lence In Science Education
Join 1000's of Authors at StreetArticles Today!

Looking for a new way to help your students achieve EXCELlence in Science? Look no further than Excel as a great way to help students understand trends, graphs and mathematical relationships.

I know we want stduents to learn how to draw graphs, understand x and y axes, explain lines of best fit and so on, but seriously.

Surely one of the most important things we can teach our students is to use the most appropriate tools and encourage them to spend their time analysing their results. We want them to discuss what the result mean for them and how they may or may not support their pre-conceptions or the current paradigm.

So instead of sweating the small stuff, ask your students to carry out an experiment. It may be as simple as boiling water. Get them to record their results in their practical books, because this is good scientific practice. Once they have a set of results, then we can start playing with Excel. In Excel your students can transcribe their values into two columns of data (eg time and temperature). If we select the data and then select the insert tab, there is a whole range of different types of graphical representations for the data.

This allows you to discuss the difference between continuous and discontinuous data (linear relationships, vs groups) and explain why we might use a line graph over a histogram for a particular problem.

The key message here is, don't worry if the data or labels or anything else doesn't come up the way you were expecting. Once you have your graph, clicking on it will bring up a new tab called Chart Tools. This allows your students to change the design, the layout and the format. I like to start with the design tab and select data. This enables me to add extra lines, change some values or name the different series. Use the layout tab to change the axes names and max values, chart title and even add a line of best fit from the trendlines group.

I find these spreadsheet tools an excellent support when teaching students about trends, eg when studying the periodic table. The key trends across a period and down a group are tedious and time-consuming to draw by hand (just ask some of my ex-students), but excel gives you the power to focus time on the meaning of the graphs and not solely on their construction. So we can talk about why atomic radius increases down a group, or why first ionisation energy increase across a period (generally).

To make the most of technology for science education, make sure your students see the power of applications. If they see the power of technology to simplify their work or make portions of it easier to complete, they may well feel more comfortable using technology for their learning. Of course, this applies equally to their teachers as well.


Street Talk

No comments present
You May Also Like
Why Do I Give Away Free Spreadsheet Tools?
To help businesses and promote myself at the same time.Why spreadsheet tools?Spreadsheets are what business people invariably first use when they start up their business. They are very useful as they keep a permanent record of transactions, sales, clients and so on. This is very important as it will help…
By: Franc Sutherland in  Business  >  Small Business   Nov 10, 2011  
0
  Likes: 0

Improve Grades With Assistance Of English, Physics And A Level Tutors
Worried about your child’s grades at school? Then private tuition is the best solution for you to enhance the grades of your child. When you hire a private tutor for your child, it means you invest in an individual tutor who gives the full attention to your child and meets…
By: Muhammad Mazhar in  Reference and Education  >  Science   Mar 14, 2016  
0
  Likes: 0

Web 2 - What Impact Has it Had on Science Teaching?
Why does technology often make you feel like there is a big conspiracy and you are the last one to know? Terms like Web 2.0 are thrown around with such abandon that they are just as likely to be incorporated into the name of a very familiar product without us…
By:  in  Reference and Education  >  Science   Mar 28, 2011  
0
  Likes: 0

Prelims for A Technical Career In Pharmacy World
There are many students who intend to pursue a career in the medicinal world without actually being a pharmacist. They want to take care of people’s health by indulging into some other aspects of pharmacy that principally requires technical knowledge and abilities. If you are also among those aspirants who…
By: Harry Millers in  Reference and Education  >  Science   Apr 26, 2014  
0
  Likes: 3

A Problem Shared is A Problem Halved - How to Improve Your Powerpoint Slide Show Science Lessons
I've written previously about the impact of presentations in Science lessons and lamented to excuse of technology for poor pedagogy. The reality is many of our teaching colleagues are using powerpoint to teach their classes, so how can we improve our use of this ubiquitous tool? Let me say firstly…
By:  in  Reference and Education  >  Science   May 12, 2011  
0
  Likes: 0

One Day Science Fair Projects Make Educational Middle School Homework Assignments
When you see the words "science fair projects" it is easy to think you are talking about the school gym filled with kids, parents and display boards full of pictures and graphs. But one day science fair projects can also be used as middle school homework assignments for science concepts…
By: Sue Gnagy Fegan in  Reference and Education  >  Science   Apr 13, 2011  
0
  Likes: 0

Easy Science Experiments for Kids Make for Great Fun at Home
Easy science experiments for kids to do at home can help make science fun and show kids and their families that science is really about what you see and experience every day. People are using scientific principles to solve problems all the time, and often do not realize it. Learning…
By: Sue Gnagy Fegan in  Reference and Education  >  Science   Apr 11, 2011  
0
  Likes: 2

The Need for Professional Development for Nurses In Australia
Today, there are so many complex developments and advancements in medical technology and the healthcare industry that medical professionals can never consider their learning is finished. To keep themselves abreast of the latest techniques they must necessarily keep attending workshops, medical conferences and undertake courses in professional development. Reading medical…
By: georgescifo in  Reference and Education  >  Science   Apr 18, 2012  
0
  Likes: 0

Multiple Metaphors - the Promise And Perils Of Technology In Science
What are your views on 'educational technology'? If there was ever a potential oxymoron, or a phrase to strike cheer or terror into the heart of a teacher, one of the nominees would surely be educational technology. Depending on the strength of your historical or mythological understandings, technology may have…
By:  in  Reference and Education  >  Science   May 13, 2011  
0
  Likes: 0

Science Experiments for Middle School Make Science Fairs More Fun
A middle school science fair can be a fun and interesting event for both students and parents.  Parents are generally pretty amazed at how in-depth science experiments for middle school can be and how many different ideas that are covered. Some of the concepts that are displayed and being demonstrated…
By: Sue Gnagy Fegan in  Reference and Education  >  Science   Mar 11, 2011  
0
  Likes: 0

Parabolic Solar Collector Making Concept
This article offers an illustrated description of a method to produce a closed parabolic trough solar energy collector box based on the elasticity of the material. What is described here is basically a manual method to make high efficiency solar collectors against very low cost, which is particularly suited for…
By: Moriala Putula in  Reference and Education  >  Science   Jul 10, 2015  
0
  Likes: 0

Where Einstein And Modern Physicists Fudged Up Or What the Aliens Know That Our Scientists Do Not! Part VI Black Holes Full Of Worm Holes?
In 1916 when Einstein first published his General Theory of Relativity there was a Prussian Officer, Karl Schwarzschild, a former math teacher in Germany who immediately produced an equation that showed a mass could be so dense as to never let light escape a certain critical radius. Today this radius…
By: Franklin N Williams in  Reference and Education  >  Science   Nov 17, 2011  
0
  Likes: 0

Where Einstein And Modern Physicists Fudged Up Or What the Aliens Know That Our Scientists Do Not
The first thing that the aliens know, if there are intergalactic aliens, is that traveling at the speed of light and greater is not only possible, but common place for them and secondly, one does not travel into the past when exceeding the speed of light. How is this possible…
By: Franklin N Williams in  Reference and Education  >  Science   Sep 02, 2011  
1
  Likes: 1

Effective Multidisciplinary Cohesion
Technology is big business in Education. Laptops, data shows, interactive whiteboards and hand held data devices are becoming increasingly common in schools across the globe. The progress is inevitable, but not equitable and in many cases the technology is lying idle as teachers with limited technological expertise and/or interest struggle…
By:  in  Reference and Education  >  Science   Mar 16, 2011  
0
  Likes: 0

WHERE EINSTEIN AND MODERN PHYSICISTS FUDGED UP OR WHAT THE ALIENS KNOW THAT OUR SCEINTISTS DO NOT! PART II: FASTER THAN LIGHT!?
Because of Einstein’s theory of relativity we have been told that nothing can go faster than light and his equation E=mc^2 will cause mass to increase infinitely as it approaches the speed of light. While any physicist will tell you this is true it is strictly a mathematical concept and…
By: Franklin N Williams in  Reference and Education  >  Science   Mar 07, 2012  
1
  Likes: 1

Article Views: 1337    Report this Article