Group items tagged

Google Spreadsheet is a powerful and free tool to manage complex spreadsheets. This tutorial illustrates ten useful formulas you must know to help you simplify the way you work in Google Spreadsheet.

displays the results of a search in a spreadsheet format. This spreadsheet format allows users to quickly compare the results of a search. Users can alter the fields in the spreadsheet to further refine a search. 

Prompted in part by a presentation I have to give tomorrow as an OU eLearning community session (I hope some folks turn up - the 90 minute session on Mashing Up the PLE - RSS edition is the only reason I'm going in…), and in part by Scott Leslie's compelling programme for a similar duration Mashing Up your own PLE session (scene scetting here: Hunting the Wily "PLE"), I started having a tinker with using Google spreadsheets as for data table screenscraping.

Like any good spreadsheet program, Google Spreadsheets supports a wide array of built-in functions.There are old standbys like SUM and AVERAGE. Mathematical, financial or statistical functions to help you crunch numbers. Even functions that manipulate dates and text. Enter them manually, or use the formulas tab to find the functions you need.

There are lots of reasons that you might use Google Spreadsheets instead of Microsoft's Excel or SPSS. Here I'll focus on just a narrow set of the benefits you'll find with Spreadsheets.

I am trying to count cells based on multiple criteria from multiple cell ranges using google docs.  In Excel the formula is simply: =COUNTIFS(S2:S26, "IN", E2:E26, "A") This would select all of the cells with the word "IN" and the Letter "A" in the same corresponding row.  Can anyone help me figure out a workaround for not being able to use the "countifs" function in google spreadsheet?

Spreadsheet of TED talks

 his is fast becoming one of my favorite uses of Twitter. Combined with Google collaborative docs, Twitter becomes a powerful tool. Start your project in Google docs, spreadsheet or presentation and then Tweet a request to your followers for help

Self-Checking Excel Spreadsheet

Creating a map mashup from data filtered thru Yahoo pipes

Google Spreadsheets Formula Help

Any author (with or without a disability) can use the Accessibility Checker feature to find potential accessibility issues and instructions for how to fix them. This article provides details on the issues the Accessibility Checker looks for, and gives some information on how to resolve them. Through notifications in the Backstage View and a task pane that helps authors navigate to, and resolve issues in their file, the purpose of the Accessibility Checker is to help authors improve the accessibility of documents, spreadsheets, and presentations that they create.

lThe course introduces pre-service teachers to the applications of different instructional technologies in mathematics classrooms (K - 12).  Students will examine and interpret the meanings of effective and appropriate use of technology through readings and activities.  Using technology along with existing school curriculum, either as an aid or as a supplement, students will learn to create, adapt, and find technological resources.  Students will be exposed to and use Web-applets and other resources on the Internet, computer-based learning software, multimedia presentations, mathematics forums, interactive whiteboards, spreadsheets, dynamic geometry software, calculators, and calculator based laboratories (CBL).  

presents text, pictures, urls and other stuff from a spreadsheet so it's updatable in real time

A quick way for us to keep track of who is stopping by during the open office hours. The form works well on an iPad, or on a laptop.

Bboogle is software that lets you embed Google Documents (including spreadsheets, and presentations) , Google Calendars and Google Sites in a Blackboard course site. Everyone with access to the course can get to linked Google content without logging in a second time. Students and instructors are automatically added as collaborators to the documents, even if they join after the link is made.   Bboogle is also an open source project that you can join. We are looking for skilled developers and educational institutions who want to contribute time to creating the best possible connection between Google Apps and Blackboard. Please see our list of Frequently Asked Questions at  FrequentlyAskedQuestions?

used in 2011, 2012, and  2013?

crowd sourced list of apps,many in music

So you probably all already know that Google Calendar is a lifesaver when it comes to organizing classes. The problem, though, is that sometimes professors don't create a Calendar-ready syllabus for us! Don't fret - here I'll share how I've managed to harness the power of Google Docs to streamline a Calendar for each of my classes, so hopefully you can do the same. Start by loading the template located at http://bit.ly/importtemplate, then rename it to correspond to the name of the class syllabus you're working on. Leaving the header row, fill in the assignment and due date, as well as the time.