CollateBox Inc http://www.collatebox.com/ Simplest way to share and act on parts of your spreadsheet data.
Spreadsheet Task 2: Employee Wages http://www.what2learn.com/fs_ict/wages_spreadsheet_fs_ict/ Spreadsheet Task 2: Employee Wages (Functional Skills ICT)
This activity is part of a series of resources to help teachers delivering Edexcel Level 2 Functional Skills in ICT. All resources provided here are the strict copyright of What2Learn Ltd and must not be published elsewhere without our written consent.
In this lesson students will develop skills in presenting data accurately using spreadsheet software. They will perform basic calculations and be introduced to using the IF function. More able students will also investigate the use of conditional formatting. These are tasks they will have been introduced to in the previous lesson – it is important that in this lesson students are encouraged to work with a greater level of independence.
Microsoft Excel 2007 for teachers http://bit.ly/cCMuEM Microsoft Excel 2007 for teachers: introduction (course)
In this free online class, you will discover many of the easy to use features of Excel and learn to create simple formulas to automatically calculate your data.
You will also learn several classroom uses for both curricular and personal productivity applications.
Free Spreadsheets http://freespreadsheets.org/ Download free spreadsheet templates for numerous purposes, including calorie tracking, grocery lists, and more.
The site includes downloads as well as links to many other spreadsheet templates on other sites.
OpenOffice http://www.openoffice.org/ OpenOffice is a complete replacement office suite, including replacements for Word, Excel and Powerpoint.
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.
Free Spreadsheets for Business & Personal Use http://www.practicalspreadsheets.com Free spreadsheets ranging from financial reports to grocery lists.
Excel tips and custom spreadsheet services too.
Flash Introduction to Spreadsheets http://bit.ly/10wSp5 Flash Introduction to Spreadsheets and Excel 2007 with Quiz (Unit 7.4)
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.
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,
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.
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 |
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 |
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.
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 |
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 |
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.
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.
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 |
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.
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
Mr Excel http://www.mrexcel.com/ Mr Excel
When you need help with Excel - whether it's solving an immediate emergency or simplifying a task - MrExcel.com is there. MrExcel.com is an entire community of Excel power users who are dedicated to helping you unleash the power of Excel.
Led by Mr. Excel himself, the community is always available to help you save time, create accurate, useful reports and make you the hero of your company meetings. And unlike a software support hotline or an independent "Excel genius", MrExcel.com can usually give you free, quick solutions through our Message Board. The MrExcel.com community is constantly checking for new questions and posting solutions. They're passionate about making Excel work for you.
Spreadsheets Teaching Theme http://teachers.teach-nology.com/themes/comp/spreadsheets/ Spreadsheets Teaching Theme
Some excellent spreadsheet teaching & learning resources ... and links to resources.
Tutorials (Beginner)| Graphing Activities | Hands-on Activities | Web Quests |
Spreadsheets - Alternative Software (free) http://www.shambles.net/pages/school/MSoffice/ Just as Microsoft Excel is a part of the "MS Office" package .... there are a number of free open source software packages such as OpenOffice, Star Office, ThinkFree Office ... that also contain Spreadsheet applications.
Creating Pictographs in Excel - Lesson Plan http://www.pics4learning.com/lessonplan_details.php?id=m05 Creating Pictographs in Excel
Objective - Students will complete a survey in Excel and create a spreadsheet using their data.
They will then use the Chart Wizard feature to create a pictograph using data and pictures they took in class or found on Pics4Learning.
Vocabulary Enrichment Using Excel http://www.pics4learning.com/lessonplan_details.php?id=204 Vocabulary Enrichment Using Excel
Objective - Students learn and/or review vocabulary words by labeling a picture in Excel.
This activity would be a great addition to a foreign language class, or any class that requires students to learn or review specific vocabulary words or places.
Excel spreadsheets for the daily Mathematics lesson http://www.kented.org.uk/ngfl/numeracy/spreadsheets.htm Excel spreadsheets for the daily Mathematics lesson: simple, highly visual and ready to use.
Cards, games and grids
Excel Template for Calculation Years and months http://www.virtualteacher.com.au/yrsmths.xls Excel Template for Calculation Years and months given a child's birthdate.
Includes formulas. DO NOT CLICK TO OPEN THIS LINK, download this link by right clicking on the mouse and select, download link to disk.(for mac just hold the mouse down and dialogue box will come up).
After downloading open file in Microsoft Excel.
Excel Formulas Learning Video Online http://easylink.playstream.com/cbtnuggets/mous/formulas.wvx Excel Formulas - Learning Video Online .. try it now!
GREAT online free tutorial
Spreadsheet | spreadsheets | tutorial | excel | video | online | Free Video Lessons from CBT Nuggets |
The Spreadsheet Page http://www.j-walk.com/ss/ The Spreadsheet Page ... lots of serious and informative stuff ... but also a small area entitled : "Spreadsheet Jokes"
Office 11 Watch | Who Knew Excel Could Do That? | PUP v5 | Excel Developer Tips | Excel User Tips | JWalk Chart Tools | Excel Newsgroups | Top-10 pages at this site | Excel Charts |
Spreadsheets in Education http://sunsite.univie.ac.at/Spreadsite/ Spreadsheets, Mathematics, Science, and Statistics Education
This page tries to collect some information about spreadsheets with an emphasis on mathematics and statistics education.
Spreadsheets in Education
Mathsnet - Spreadsheets http://www.mathsnet.net/ssheets.html Mathsnet - Spreadsheets
Using spreadsheets in education, not just for data handling but for pure mathematical investigation too.
Find out what a spreadsheet is, view a dictionary of basic spreadsheet terms and try out some ideas. Have a look also at these animations of common spreadsheet operations.
Embedded spreadsheets
For you to view and use the embedded spreadsheets on these pages, you will need to install a free plug-in from Formula One/NET. Go to the download page for details.
spreadsheets | spreadsheet | math | maths |