Summary: Excel might be able to crunch serious numbers for accountants, but new charts make Google Spreadsheets a better choice for displaying data on the Web.
Having just completed a Google Apps training session for one of my clients today, I tucked away Google’s announcement of improved charts within their Spreadsheets App for a followup session. While Excel remains king of the spreadsheets, the revised charting and other recent enhancements to the editor and interface make Google Spreadsheets a competitive tool for most users.
Google introduced the new features Tuesday in a blog post and the movie below shows the enhancements.
And while Excel may be king of the spreadsheets, Google has a few tricks up its sleeve. The organization chart, for example, is generated dynamically based on data in the spreadsheet (click here to see an example). Excel requires users to create org charts as SmartArt graphics with no data-driven or programmatic interfaces. Similarly, the longitudinal representations of data are quite powerful. When combined with a form or other interface to add data which are updated in real time and reflected immediately on the chart (which can be embedded in a web page), then there is a lot of functionality that leverages the cloud in ways that Excel just can’t. Click here for an example of the “motion chart” (longitudinal analysis).
In fact, I would argue that if your goal is generally to represent data on the Web and your needs don’t extend to really sophisticated database-driven analytics, then Google Spreadsheets is actually a better choice than Excel. With virtually any other tool, making dynamic, data-driven charts appear on the Web is no small feat. With these new charting features, it’s as easy as entering the data and embedding the chart on a Web page or blog.
I’ve argued before that Google is better off not trying to create an Office clone in its Apps suite. Rather, they need to focus on exploiting the features of a cloud-based tool that Office just can’t match (at least not without SharePoint behind it). In this case, they did just that with attractive, dynamic charts that are simple to create and embed.
Chris Dawson is a freelance writer and consultant with years of experience in educational technology and web-based systems. In 2011, he became the Vice President of Marketing for WizIQ, Inc., a virtual classroom and learning network SaaS provider.
Christopher Dawson is the Vice President of Marketing for WizIQ, Inc., by day and a freelance writer and educational technology consultant by night. Well, most of his colleagues at WizIQ are based in India, so really he's working with them whenever he can stay awake. He has worked for his local school district as a teacher and technology director, for the Johns Hopkins University School of Public Health, and for Biogen, Inc. (now Biogen-IDEC, Inc.).
He has also consulted with STATNet and Cytyc Corporation and retains close ties with X2 Development Corporation (now owned by Follett Software, the supplier of the student information system he administered for several years). Follett is paying him a monthly honorarium to act as a presenter for their "SIS Voices for Student Achievement" community (he produces occasional blog posts and hosts a monthly webinar on the use of student information systems to inform data-driven instruction and school-wide change.
He regularly purchases and/or recommends Dell hardware. This is because Dell makes good hardware and has truly committed itself to education in innovative ways, particularly with their "Connected Classroom" initiative. It isn't because he has dealings with the company through his role at WizIQ (which he does) or because they have provided him with long-term loans of a variety of equipment for in-depth testing (which they have).
Intel (reference designer for the Classmate PCs he has implemented in his local schools) has provided him with long-term loans of Classmate PCs for testing, as have Dell and Lenovo with their educational offerings. He may report on any of these companies as his experiences with them have direct bearing on educational technology; positive reports are not necessarily an endorsement and he receives no direct financial compensation from these companies or any others.
Intel paid all expenses for his attendance at the 2009 Intel Classmate PC Ecosystem Summit which he attended as the sole representative of the technology press. He was invited to attend in 2010 but his wife would have killed him if he spent 3 days in Vegas geeking out and left her home alone with a new baby. Acer provided him with a 50% discount on an Aspire One netbook in early 2009 after he tested it for 30 days through their educational seed program. He liked the netbook at the time but it has since broken and sits unused in his office. Canonical sent him Ubuntu lanyards, t-shirts, and mousepads for his kids. He stole one of the lanyards and proudly hangs his keys from it and occasionally features his 8-year old wearing an oversized Ubuntu t-shirt on his Facebook profile. Gunnar Optiks sent him a pair of computer glasses to evaluate for a holiday gift guide. He is wearing them now as he types this because they never asked for them back and they rock out loud. Seriously - they work brilliantly and make it much easier to spend 20 hours a day staring at an LCD. If they ever asked for them back, he would fork over the $99 and buy a pair.
Microsoft gave him 2 free copies of Office 2010 professional, a desktop clock, and a useless book on Office 2010 when he attended the launch of Office/Sharepoint 2010. He occasionally uses the SharePoint lanyard they gave him instead of the Ubuntu lanyard for his keys, but feels dirty afterwards.
Adobe provided him with a pre-release version of the CS5 Master Collection for evaluation and ultimately provided a full, licensed copy for ongoing testing of educational applications of this admittedly expensive software. Like the Gunnars, if the license expires or they come out with CS6, he'd actually go out and buy it himself. Which is saying something, because he's actually pretty cheap.
Any other companies wishing to send him cool things to evaluate, wear, or otherwise adorn his kids are more than welcome to; he promises to disclose it here if he keeps any of the stuff.
Finally, because WizIQ is a virtual classroom and learning network provider, Chris, as VP of Marketing, frequently interacts with, seeks out deals with, and directly or indirectly competes with a whole lot of LMS, SIS, and other Education 2.0 companies. In general, he'll limit his reporting about these companies to news that does not impact his relationship with them or with WizIQ. If he reports on them, it's because what they are doing is newsworthy or worth the attention of his readers and not because he's trying to broker some deal, damage competition, or otherwise advance his position in his day job. LMS and SIS companies, along with other online learning communities, are a pretty important part of Ed Tech. If he stops reporting on them completely, there won't be a whole lot left. He'll be sure to call out any overt conflicts of interest if they are unavoidable.
Finally, Follett Software Company pays him a little tiny honorarium every month to present on their SIS Voices webinars and to write the occasional blog or discussion thread for them. Since Follett recently bought X2 (maker of an awesome web-based SIS that Chris just happened to have used, served in advisory groups for, and frequently reported on), this is probably also worth disclosing.
Biography
Christopher Dawson
Christopher Dawson grew up in Seattle, back in the days of pre-antitrust Microsoft, coffeeshops owned by something other than Starbucks, and really loud, inarticulate music. He escaped to the right coast in the early 90's and received a degree in Information Systems from Johns Hopkins University. While there, he began a career in health and educational information systems, with a focus on clinical trials and related statistical programming and database modeling. This focus led him to several positions at Johns Hopkins, a couple-year stint in private industry, teaching high school math and technology, and 2 years as the technology director for his local school district. Most recently, he started his own consulting business and is now the Vice President of Marketing for WizIQ, Inc., a virtual classroom and learning network provider.
He lives with his wife, five kids (yes, 5), 2 dogs, and a hateful cat in a small town in north-central Massachusetts. Although he is no longer teaching, his roles with WizIQ and ZDNet allow him to continue helping students and teachers add value to education with technology rather than merely adding to the bottom line.
RE: Google Spreadsheets gain sophisticated charting
JACOBSONR14th Oct
Good day to confirm this comment I would appreciate T h e b e s t o f Z D N e t d e l i v e r e d your website very nice to everyone Yes, Oracle is the only one with shared-disk architecture, but that is there advantage. It means you can add or remove nodes and the database lives on. In a shared nothing architecture, if you lose a node, you lose the system. I'm sure Oracle appreciates EMC highlighting their advantage.I also desire to signal in your RSS feeds. Thank you as soon as once again and maintain up the great operate Awesome post! Thank you very much || thanks for nice content this is really benefit to me.
There's no way Google will every make software as good (or even as functional) as MicroSoft. Most of Google's stuff just sounds "cool" on paper but they really offer nothing useful. Instead, Goolge should concentrate on intergrating this to Android before the iPhone kills it.
I used to be more than happy to seek out this internet-site.I wanted to thanks in your time for this glorious read!! I positively enjoying each little bit of it and I have you bookmarked to check out new stuff you weblog post. this thread is amazing i like your work and i appreciate you that you have share a useful stuff thanks for sharing the i shop abatwa
I used to be more than happy to seek out this internet-site.I wanted to thanks in your time for this glorious read!! I positively enjoying each little bit of it and I have you bookmarked to check out new stuff you weblog post.Bookmarking now thanks please consider a follow up post. power sa shop
I think the representation of this article is actually superb one. This is my first visit to your site. Thanks a lot and keep sharing the information. Keep updating the information for all of us. Thanks ZDNet Government was launched as the brand's first industry vertical, with a mission to cater to IT professionals in the public secto I agree with your post. However, do you have any sources I can cite for my paper wheel car com bury
Well welcome, hopefully you can become a vital member of the community and really help to push far ahead of google. Which Im sure the development team would love. This will of course earn you alot points too and get you on the leaders board. z d n e t t h a n k Im not sure i come to an agreement with you on every level, howevor it absolutely was a good posting, many thanks for taking the time to put up your ideas.
Thanks nice info z d n e t I really liked your current article write more..let me add you to its favorite The articles you have on zdnet s i t e are always so enjoyable to read. Good work and I bookmarked it.
Fantastic news about the new release.I positively enjoying each little bit of it and I have you b o o k m a r k e d to check out new stuff you weblog post.Im not sure i come to an agreement with you on every level, howevor it absolutely was a good posting, many thanks for taking the time to put up your ideas
Good day to confirm this comment I would appreciate T h e b e s t o f Z D N e t d e l i v e r e d your website very nice to everyone Yes, Oracle is the only one with shared-disk architecture, but that is there advantage. It means you can add or remove nodes and the database lives on. In a shared nothing architecture, if you lose a node, you lose the system. I'm sure Oracle appreciates EMC highlighting their advantage.I also desire to signal in your RSS feeds. Thank you as soon as once again and maintain up the great operate Awesome post! Thank you very much || thanks for nice content this is really benefit to me.
