Group items tagged

Spreadsheet lessons. Several assignments. This website seems like aa really good website to introduce Spreadsheets and teaching students how to utlize spreadsheets.

"Google forms are fabulous for gathering information, but sometimes, the data in the spreadsheet can be difficult to view. In this post, I'll share a simple-to-implement formula that will make it much easier to deal with (and even print) form-fed data!"

"Doctopus is a Google Spreadsheet script developed by Andrew Stillman that can help teachers manage the flow of shared work in in their Google Drive accounts. The basic concept behind the script is to enable teachers to quickly share documents with all of the students on a roster, monitor usage of shared documents, and give students feedback within that roster spreadsheet."

"The Google Docs collection provides a streamlined, collaborative solution to writing papers, organizing presentations and putting together spreadsheets and reports. But besides the basic features, there are lots of little tricks and hacks you can use to make your Google Docs experience even more productive. Here are 100 great tips for using the documents, presentations and spreadsheets in Google Docs."

This Google Spreadsheet has a listing of all of the TED talks from 2006 through to 2010. It includes a short summary of the talk as well as listings by date, conference and speaker first name

Google spreadsheet of TEDTalks

For those of you who watch TedTalks, a spreadsheet with all TedTalks to date with links to the videos and descriptions of each. Works as a good index if you are looking for something specific.

An invaluable guide for Australian Teachers on twitter. Very comprehensive and organised by subject area on google spreadsheet. I will put in my favourites:

A Google Spreadsheet of some classrooms that tweet

gClassFolders is a free, Google-Spreadsheet-based add-on for Google Apps for EDU that creates class folders for students and teachers to simplify and streamline their experience of using Google's world class productivity and collaboration tools in the classroom.

gClassFolders is a free, Google-Spreadsheet-based add-on for Google Apps for EDU that creates class folders for students and teachers to simplify and streamline their experience of using Google's world class productivity and collaboration tools in the classroom.

"TimelineJS - Beautifully crafted timelines that are easy, and intuitive to use. It can pull in media from different sources and has built in support for: Twitter, Flickr, Google Maps, YouTube, Vimeo, Dailymotion, Wikipedia, SoundCloud and more media types in the future. Creating one is as easy as filling in a Google spreadsheet or as detailed as JSON."

via @camaxwell

"For Teachers: Classroom Assessment Easily create your own rubrics Complete rubrics on iPads, tablets or phones Collect data offline with no internet access Compute scores automatically Print rubrics or save as PDF or spreadsheet "

Use Flubaroo with google spreadsheets to automatically correct tests created in Google forms.

"Take your professional learning community to the next level by using Google Docs to collaborate with colleagues. Google Docs is an online office suite that allows you to create, edit, share, and publish documents, including spreadsheets and presentations. Because everything is stored and even modified on the web, Google Docs makes it easy to collaborate with colleagues - and even to edit the same document from multiple computers simultaneously. This session will focus on the use of Google Docs to promote and support collaboration within a PLC, including strategies for creating common assessments, sharing best practices, and capturing the conversation - even between meetings. Google Docs can even be used for data collection and analysis. This one tool can revolutionize the way your PLC collaborates. And it's free. (This is a hands-on DOUBLE session: 2.5 hours.)"

"Using a combination of Google Spreadsheets as a data source and a simple web interface to add interactivity it's possible to let users explorer your entire event hashtag and replay any of conversations."

Followed the instructions and BOOM! An interactive visualisation of the relationships within a Twitter chat e.g. http://bit.ly/HhvBGo

Numbers (itunes link) spreadsheet app directly from Apple, is a worthy Microsoft Excel-like competitor for the iPad. It is a powerful tool for teachers who own an iPad, and can be used for assessment, especially during report card season. It is a $9.99 app that is part of Apple's iWork suite which also includes Pages and Keynote.

"The use of Twitter to collecting tweets around an event hashtag allowing participants to share and contribute continues to grow and has even become part of mass media events, various TV shows now having and publicising their own tag. This resource is often lost in time, only tiny snippets being captured in blog posts or summaries using tools like Storify, which often loose the richness of individual conversations between participants. It doesn't have to be this way. Using a combination of Google Spreadsheets as a data source and a simple web interface to add interactivity it's possible to let users explorer your entire event hashtag and replay any of conversations."

"Create free timelines. Follow interesting stories, get updates and notifications with "Today in history". myHistro is an interactive diary and a story-flow generator for bloggers. Unlimited space, unlimited number of photos! Create as many stories as you want and export these into Google Earth (KML) or spreadsheet format (CSV)! See the story on map and timeline, read more by "manually" turning pages or see the story summary as a simple chronological list of events. Try them all! My Histro also has an app.

"Did you know that Google Docs has support for QR codes built-in? That's right, if you know the right function, the Spreadsheets app can generate QR codes with whatever inputs you like."