Google provides tools that allow visual representation of information using Gadgets. There is also the ability to search on-line data and import that into a spread sheet by using Functions.
Google Forms , Spreadsheets and Scripts
Reference Sheet on Gadgets
Examples of Google Gadgets and Functions In Class Exercise Data
Table Gadget ( no example, this will be a class exercise)