Interactive Spreadsheet Guide and Worksheet http://bit.ly/2nGBiZ Interactive Spreadsheet Guide and Worksheet
This is an interactive guide to the basics of spreadsheets and creating formulae. It includes lots of interaction and some sounds for a bit of fun. It is ideal to do as a class on an interactive whiteboard or you could let the kids loose on it themselves for self based learning.
eXpresso http://www.expressocorp.com/ eXpresso is a way to share Excel spreadsheets with people.
eXpresso enables multiple contacts to work on the same spreadsheet at the same time, saving all changes to a common version in real-time.
Google Spreadsheet Gadgets and More http://blogoscoped.com/archive/2008-03-19-n20.html Google Spreadsheet Gadgets and More
Google Spreadsheets as part of the Google Docs suite added several new features; better revisions comparison through color highlights, change notifications, and a Google spreadsheet gadgets directory. (Auto-completion of values in cells may also be new, I’m not perfectly sure.)
Google Spreadsheets : NewGadgets http://googlesystem.blogspot.com/2008/03/google-spreadsheets-adds-gadgets.html Google Spreadsheets : NewGadgets
Now you can get email notifications when your collaborators make changes or edit some specific cells. You can also get notifications when someone submits new data using a form.
Excel Video Tutorials http://www.the-tutorial-library.com The Tutorial Library is an ever growing set of video tutorials covering every subject you'll ever need to improve your Excel knowledge and experience.
14 Online Spreadsheet Applications http://mashable.com/2008/02/06/forget-excel-14-online-spreadsheet-applications/ 14 Online Spreadsheet Applications
The gap between online and offline is closing more each day, and working with your spreadsheets in a collaborative atmosphere is not a bad reason to try an online spreadsheet editing tool. We’ve got 14 choices for you for working with your spreadsheets online; most are free, a few aren’t,
Blist : online database and spreadsheet creations http://www.blist.com/ blist is the world’s easiest database. blist is all about discovering, sharing, publishing, distributing, and subscribing to data at home and at work.
blist makes it easy for anyone to create private or collaborative databases for anything from party or wedding guest lists, fantasy football statistics, and personal finances to professional information such as sales contacts, project management sheets, campaign tracking, status reports, patient records, and more.
A community of data and data templates allow you to get started right away, and keeps you from duplicating tedious data entry work wherever possible.
wikiCalc http://www.softwaregarden.com/wkcalpha/ The wikiCalc program is a web authoring tool for pages that include data that is more than just unformatted prose.
It combines some of the ease of authoring and multi-person editing of a wiki with the familiar visual formatting and data organizing metaphor of a spreadsheet.
It can be easily set up to publish to basic web server space accessed by FTP and there is no need to set up server-side programs like CGI. It can, though, run on a server and be used with nothing more than a browser on the client.
EditGrid : A Web 2.0 Online Spreadsheet http://www.editgrid.com/home EditGrid : A Web 2.0 Online Spreadsheet
An online spreadsheet featuring real-time-update and extensive collaboration features.
4 quick tips for using Excel http://www.microsoft.com/athome/moredone/4exceltips.mspx 4 quick tips for using Excel
Enhance your spreadsheets with these helpful hints
Locking columns and rows | Forcing line breaks | Creating a drop-down menu | Converting complex calculations into handy charts |
Lightweight data exploration in Excel http://www.juiceanalytics.com/weblog/?p=236 Lightweight data exploration in Excel
We often are given a chunk of data in Excel that we need to explore. Of course, the first tool you should pull out of your toolbox in cases like this is the trusty PivotTable (it slices, it dices!). But at times we have to dig a little deeper into the toolbox and pull out the in-cell bar chart.
Here? what it looks like.
Google Spreadsheet http://spreadsheet.google.com/ Google Spreadsheets : Create, store and share spreadsheets on the web.
Create basic spreadsheets from scratch.
You can start from scratch and do all the basics, including changing the number format, sorting by columns, and adding formulas.
Upload your spreadsheet files.
Upload spreadsheets or worksheets from CSV or XLS format - all your formulas and formatting will come across intact.
Choose who can access your spreadsheets.
Just enter the email addresses of the people you want to share a given document, and then send them a message.
Share documents instantly.
People with whom you share a given spreadsheet can access it as soon as they sign in.
web 2.0
wikiCalc www.softwaregarden.com wikiCalc
The wikiCalc program is a web authoring tool for pages that include data that is more than just unformatted prose.
It combines some of the ease of authoring and multi-person editing of a wiki with the familiar visual formatting and data organizing metaphor of a spreadsheet.
It can be easily set up to publish to basic web server space accessed by FTP and there is no need to set up server-side programs like CGI. It can, though, run on a server and be used with nothing more than a browser on the client.
EditGrid : spreadsheets on-the-web http://www.editgrid.com/ EditGrid : spreadsheets on-the-web
See changes in real-time when someone modifies a spreadsheet. We call it RTU (real-time update).
Import from and export to common formats. Including MS Excel, CSV, Gnumeric and OpenOffice.org Calc.
Access rights for every spreadsheet. Only share yours with those you have invited.
ajaxXLS viewer http://www.ajaxxls.com/ ajaxXLS viewer
A web-based viewer application with a look and feel similar to Microsoft Excel.
With one click you can easily open any .xls file in just a few seconds.
The interactivity and responsiveness provided by AJAX programming allows you to enjoy the power and utility of a spreadsheet without the cost of conventional software.
Dabble DB http://www.dabbledb.com/ Dabble DB
Dabble DB combines the best of group spreadsheets, custom databases, and intranet web applications into a new way to manage and share your information on the web.
Although this is a web 2.0 database website it is also an unusual hybrid using RSS feeds and spreadsheets.
Import data from anywhere: spreadsheets, contact lists, databases ?or just start from scratch. Add as much as you like, and extend it or change it at any time.
Access your database from anywhere using a web browser. Add multiple users to collaborate with colleagues. Export to your spreadsheet or to PDF. Keep tabs on changes through a newsreader or calendar.
Zoho Sheet : Create & share spreadsheets online. http://www.zoho.com/ Zoho Sheet : Create & share spreadsheets online.
spreadsheet | web 2.0 | Access Anywhere | Calculate using Formulas | Import & Export Excel | Analyze with Charts | Share, don't attach | Tag your Sheets |
MS Excel sample spreadsheets http://bodmas.org/blog/?page_id=351#excel MS Excel sample spreadsheets
Download various Excel spreadsheets that illustrate level 2 and 3 Maths topics.
Sundera - Real-Time Spreadsheet Collaboration http://www.sundera.com Sundera enables real time collaboration between multiple Excel users.
It distributes and collects data, not files, directly to your spreadsheet from and to multiple spreadsheet sources by secure and easy way.
Just install Sundera software on your PC and forget about difficulties with sending Excel files by mail back and forth. Think about the many spreadsheet types which you may enhance by Sundera way: budgeting, planning, cash flow, mortgage, business plan, sales forecast, lesson plans, family budget, toys, etc. spreadsheets.
iRows : Web based online spreadsheets http://www.irows.com/ iRows : Web based online spreadsheets
Includes the ability to add graphs to the spreadsheets
web 2.0 | spreadsheet |
Numbler http://numbler.com/ Numbler, the web based spreadsheet that enables instantaneous collaboration with anyone on your project team. With Numbler multiple users can work with a spreadsheet, view changes in real time, and discuss changes.
Your sheets are accessible from any web browser, anywhere in the world, and are easily shared with your colleagues and partners.
If you've ever poured your time into editing a spreadsheet that you later found is weeks out of date, and the latest is on some vacationing guy's laptop, you might give Numbler a try. It's impossible to have an out-of-date version--you're always editing the master. You can import data from and export data to desktop spreadsheet applications at any time.
web 2.0 | spreadsheet |
Num Sum : Easy, Sharable Online Web Spreadsheets http://numsum.com/ Num Sum : Easy, Sharable Online Web Spreadsheets
Keep your records, lists and spreadsheets in one place online. Easily slice, dice and share with others.
Free Excel Personal Finance Spreadsheets http://www.uncommonwaytowealth.com/excel-finance-spreadsheets/ Millionaire calculator, wealth spreadsheet, grocery spreadsheet (price book), Mary Hunt's Rapid Debt Repayment Plan spreadsheet, Latte Factor spreadsheet, and more.
Primary (Y1-Y6) Spreadsheets and Databases http://www.primaryresources.co.uk/ict/ict2.htm Primary (y1-y6) Spreadsheets and Databases
Code Breaking | Textease Branch: Musical Instruments | Word Grid Excel | Spreadsheet Formatting | Vocab Poster: Spreadsheets | Introduction to spreadsheets planning | Vocab Poster: Databases | Ben's Burger Bar - Australian Currency | Budget for Class Party | Introduction to Formulae |
Self-tutored guides to ICT applications http://www.new-media-learning.com/nml_page2.html The following guides are designed to provide one-hour self-tutored course in the essential features of some PC uses and applicitions. At the end of each guide there is a self assessment sheet. Being able to tick most of the boxes means that the user will be competent in 90% of everyday uses of the application. These guides may be freely used for non-commercial purposes.
PC Basics guide - a guide to the basics of using PCs
Word Guide - a guide to using Word
PowerPoint Guide - a guide to using PowerPoint
Excel Guide - a guide to the using Excel
Front Page Guide - a guide to using Front Page
Excel Tutorials http://www.educationworld.com/a_tech/archives/techtorials.shtml Excel Tutorials
Create a Chart or Graph with Excel | Create a Grade Book in Excel | Create a Labeling Worksheet | Create a Timeline Using Microsoft Excel | Create an Adlib Story with Excel | Create an Interactive Map | Create Class Surveys with Excel | Create Tessellations with Excel | Excel-ent Activities Across the Grades | Make A Poster With Excel! | Teaching Excel | Using Excel to Create Interactive Crossword Puzzles | Using Spreadsheets to Create Interactive Grade Books |
cVue http://www.winsite.com/bin/Info?21000000038832 cVue is a spreadsheet that has been designed to better organise your work: arrange
your sheets in our workbook, segregated by dividers (see screenshot). Much better
than tabs!
Featurewise, you can enter values, text, dates etc. and format them as you might
with any other spreadsheet. We support many formulas, a few unique formats and
tools, and an import from Microsoft Excel. Currently, we are working on providing
cross sheet linking and will eventually add charting and drawing tools.
We currently have no plans to charge for this software once the beta period ends.
However, please be aware that this might change.
This download includes an uninstaller. It will not install any spyware or send
to us any personal information.
Custom Spreadsheet Software http://www.spreadsheet123.com Custom Spreadsheet software and accounting systems development. Web site is full of free spreadsheets ready to download.
The Excel MVP Page http://www.oaltd.co.uk/MVP/Default.htm Welcome to the Excel MVP page. This page is intended to become a file library where the Microsoft Excel MVPs can place example files and utilities.
This page contains third party Excel add-ons .. for the more advanced users.
Blackcat : Spreadsheets and Graphs Software http://www.blackcatsoftware.com/catalog/products/numbox2.html NumberBox 2 is a spreadsheet package that has been specifically designed for use within the classroom.
Dynamic graphs | Export to HTML and Excel files | Attach notes to your spreadsheet using the built-in word processor | Easy access to resources | Save clippings for later use | Insert a sound file in a cell |
E-mail spreadsheets to other users |
DataSweet : Data Handling Suite inc. Spreadsheet http://www.kudlian.net/products/datasweet/ DataSweet : Data Handling Suite inc. Spreadsheet : DataCalc
DataSweet has been developed specifically to meet the needs of data handling for the National Curriculum at Key Stages 1, 2 & 3. DataSweet is a powerful, yet clear and easy to use application which means that pupils are able to concentrate on the data handling activities without worrying about the complexity of the software.
The suite comprises of a graph drawing application, databases and a spreadsheet.
Age Range: 4 ?14 yrs.
As-Easy-AS Spreadsheet for Win95/98/Me/NT/2K/XP http://www.triusinc.com/asawin.htm As-Easy-AS Spreadsheet for Win95/98/Me/NT/2K/XP .. Shareware
Powerful 32-bit spreadsheet program with over 130 math, financial, scientific, statistical, string, date and time functions. Superb graphics. New macro programming language implementation. Min/Max Linear Programming. Goalseeking. Linear and Non-linear Multi-variate Regression. Internal and External User-definable Functions. Text Search & Replace. File Linking. Integration & Recursion. Beta and Gamma functions. Gaussian & Poisson distributions.
Free 30 day evaluation can be downloaded ... then US$49
Data analysis in Excel - helpsheets http://tinyurl.com/22cev Data analysis in Excel - helpsheets
Brief descriptions of how to use the data analysis tools in Excel
Filtering data in Excel | Subtotals in Excel | List of useful Excel functions | Summarising data in Excel | Data validation in Excel | Conditional formatting in Excel | Data entry in Excel |
Free Microsoft Excel Files, Templates and Utilities http://www.winsite.com/edu/excel/ Free Microsoft Excel Files, Templates and Utilities
Including ..
Provides Search/Replacement function for textboxes or shapes | Free Financial Modeling lessons | Template for Excel. Punch card caulculator | Matrix and Linear Algebra for EXCEL | Random Task Assignments for 100 Volunteers | Rotating Shift Schedules for 25 People | If you want to learn microsoft excel follow these CBT lessons |
Max's Sandbox - K-2 interface for Word, Excel and PowerPoint http://www.maxssandbox.com/ Max's Sandbox - K-2 interface for Word, Excel and PowerPoint
All the time kids are having fun with Max? Sandbox they are learning important life skills such as word processing, how to use spreadsheets and how to create professional-looking presentations.
Using Spreadsheets as a Problem-Solving Tool http://www.crews.org/curriculum/teacher/GaETC/spreadsheets.htm Using Spreadsheets as a Problem-Solving Tool
Spreadsheets are a very powerful tool that allows students to understand complicated word problems. They allow students to "spread" out data for manipulation, analysis, and reflection. Below are many examples that you can use to teach students how to use a spreadsheet as a tool to think at a higher level in order to solve real life word problems.
GCSE - Spreadsheets http://www.ictgcse.org.uk/frm_projs.htm GCSE - Spreadsheets | Fantasy League Project | Cinema/School Play Seating Project | A small business spreadsheet |
Community Students Spreadsheets http://www.cleo.net.uk/community/spreadsheet?invite=1 This community is for teachers to use with their students/pupils. It has two distinct 'audiences'.
The first is for the teacher introducing students/pupils to spreadsheet applications or developing pupils understanding of how a spreadsheet can be used.
The examples remove the need to know how to prepare a spreadsheet or start with an over-facing screen of blank cells both for teacher and student.
There are various themes available but I am very willing to develop a theme from your own idea.
Just e-mail the idea with a few details of what you hope the spreadsheet will do.
The second audience is the teacher as a classroom administrator. Several spreadsheets are designed to make those tedious tasks a little easier.
5 Tips for Working with Multiple Worksheets in Excel http://office.microsoft.com/assistance/2002/articles/pwExcelMultiWkShts.aspx 5 Tips for Working with Multiple Worksheets in Excel
Many projects involving Excel require you to work with a number of worksheets in a workbook. And often, the changes you make in one worksheet affect the data in another. Check out these five tips for working with data in multiple worksheets.
A blog about Maths and Numeracy http://bodmas.blog-city.com/briefcase.cfm A blog about Maths and Numeracy teaching pointing to resources and ideas for activities. Click on the month name in the calendar to see what I have been up to this month. Use the search box to find information on keywords like 'fractions' or 'spreadsheets'. - Keith Burnett.
One downloadable item is - e.g MS Excel spreadsheet to demonstrate the straight line and quadratic graphs