Thursday, May 19, 2005

Free Spreadsheets

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/index.html
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.


Microsoft Excel : Online Tutorial
http://www.wcu.edu/ccenter_inf/CatOnline/MSEX/index.html
Microsoft Excel Spreadsheet : Online Tutorial


Practise spreadsheet skills : an online quiz
http://www.school-resources.co.uk/FramesForKS3SpreadsheetQuiz.htm
Practise spreadsheet skills : an online quiz



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 Spreadsheet Software
http://www.pricelessware.org/2004/PL2004BUSINESS-HOME.htm#Spreadsheet
Free Spreadsheet Software ... an alternative to buying 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.


Lewisham (UK) : KS4 GCSE ICT Writing Frames - Spreadsheets
http://www.lgfl.net/lgfl/leas/lewisham/communities/ICT/resources/Secondary/KS4_5/KS4.db_psc
Lewisham (UK) : KS4 GCSE ICT Writing Frames - Spreadsheets


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


Are small bananas better value? - Spreadsheet
http://www.kented.org.uk/ngfl/ssheet/bananas.doc
Are small bananas better value? ... a great example of using spreadsheets.


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.


Excel Spreadsheets and Add-Ins (free)
http://members.aol.com/johnp71/javasta2.html#Excel
Free plug-ins for the Excel spreadsheet


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 |


Evaluation of Sheetwise
http://www.ncte.ie/SoftwareCentral/Evaluations/Sheetwise/
"Sheetwise is a simple spreadsheet program for children. It introduces them to the concept of a spreadsheet, formulae and data handling without the clutter of more advanced programs."


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.


Students Spreadsheets at CLEO (UK)
http://www.cleo.net.uk/communities/
"Student Spreadsheets" - These are free Excel spreadsheets that can be used by students and pupils to enhence their work across various areas of the curriculum
If you are a first time visitor then you will need to register - free


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


Using Chart tool in Excel to Graph spelling results
http://www.virtualteacher.com.au/graphing.doc
Using Chart tool in Excel to Graph spelling results


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.


Spreadsheets... IT Advice for Novices
http://www.ictadvice.org.uk/new2computers/opt/menu_spread/page/tutorials
Spreadsheets... IT Advice for Novices
Excel 97 samples (PDF 109 KB) Covers performing calculations | How to set up Excel (PDF 168 KB) | Using spreadsheets (PDF 254 KB) |


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 |


Other Spreadsheet Information
http://www.j-walk.com/ss/other/index.htm
Although Excel makes up the bulk of spreadsheet use, there are some other useful spreadsheet products available. This pages lists some products and spreadsheet-related tools that you may be interested in .. some are free.
spreadsheet | spreadsheets | software | free | download | downloads |


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


Spreadsheet modelling from Devon (UK)
http://www.devon.gov.uk/dcs/ict/models/index.html
Spreadsheet modelling
Modelling - an introduction | Dictionary definitions | What is modelling? | Computer modelling | examples | spreadsheet | spreadsheets |


TRC Teacher Resource Exchange
http://tre.ngfl.gov.uk/
The Teacher Resource Exchange is a database of resources and activities designed to help teachers develop and share ideas for good practice. The new-look, redeveloped TRE provides a variety of navigational features designed to deliver resources specific to your needs.
Go to the site and type 'spreadsheet' into the search box to get some great examples from teachers.... in fact over 100 examples .. e.g.
Introducing spreadsheets | Using a spreadsheet to convert Sterling to Euro | Spreadsheets Lesson Plan | Variance Analysis Lesson Plan and Spreadsheet | Using Spreadsheet in Mathematics | Using spreadsheets to record heart rate and other physical data | Using spreadsheets to record heights | Spreadsheets in Business Studies | Spreadsheet Design in Key Skills - a Lesson Plan | Food Costings Spreadsheet | Menu (business) engineering spreadsheet | Teaching spreadsheets using Excel | Importing a spreadsheet and graph from Ecel to a Word document | Compound Interest / Repayment Spreadsheet | Analysis of diet using spreadsheet | Radioactive decay, spreadsheet | Advanced Spreadsheet Work | planning a party | Hundred Square | Floating and Sinking | Is Soil just Soil? | ICT and Maths - Data Handling | Acceleration due to gravity, Spreadsheeet |


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 |


Math lets : Spreadsheet and Graphing Tool
http://illuminations.nctm.org/mathlets/grapher/index.html
Mathlets are math applets you can use to explore math and create interactive lessons.
This interactive math applet combines the features of a spreadsheet and a graphing calculator. It can be used as a general tool or customized for specific purposes. For example, see how this tool can be used to investigate rational functions in the whelk i-Math Investigation, or exponential functions in the the decay of light i-Math or the trout population i-Math.
Grades 6-8 and 9-12
spreadsheet | spreadsheets |


Math lets - spreadsheet in your browser
http://illuminations.nctm.org/mathlets/spreadsheet/index.html
Mathlets are math applets you can use to explore math and create interactive lessons.
This simplified, yet powerful, spreadsheet has many of the same features as a complete spreadsheet. It is provided online so that you can remain in a web-browsing environment while using it, or in case you do not have a complete spreadsheet. It is a modified version of the Spreadsheet and Graphing Tool.
Grades 6-8 and 9-12
spreadsheet | spreadsheets |


Microsoft Excel Viewers and Converters (free)
http://office.microsoft.com/downloads/2000/xlviewer.aspx
The Microsoft Excel 97/2000 Viewer is recommended for use with a stand-alone computer that does not have Microsoft Excel installed. This product allows the user to open and view Excel 97 and Excel 2000 spreadsheet files. The viewer is not suitable for use on a server.
The Microsoft Excel 97 Viewer allows users to view and print Excel 97 and Excel 2000 spreadsheet files, in addition to other Excel for Windows? (versions 2.0 and greater) and Excel for the Macintosh? (versions 2.2a and greater) spreadsheet files. This small, freely distributable viewer gives users the flexibility to view page layout, copy and control cell sizes, and access the zoom and AutoFilter features. This viewer also supports OLE DocObject as well as the ability to view any Excel file.
Microsoft | Excel | Viewer |


Spreadsheets - more than just number crunching
http://top.ngfl.gov.uk/content.php3?content=content/b953743223.html
One of the main benefits of my laptop has been that I can now achieve administrative asks more quickly than before. For instance, I now compose letters, governors' reports and newsletters to parents. Very important to the work of the school, however, has been our use of spreadsheets.
The spreadsheets - or 'Tracking achievement sheets' as we call them - have developed from handwritten records I had been keeping for years.


Good Practice : Working with Excel
http://www.clickteaching.com/good_practice/spotlight_working_with_excel.shtml
Microsoft Excel can look like a complicated hing-functioning program for office users. Yet its features are easy to use, and can be worked to develop rich, interactive content for children to use. By learning some of the basic formualas you can bring all of the National Curriculum subjects alive.
The best way to find out how to use Excel to create interactive worksheets is to view some examples.
When you have downloaded the files, click around the worksheet to see how it is created.


Introduction to spreadsheets
http://www.educate.org.uk/teacher_zone/classroom/ict/unit5d.htm
In this unit children learn to enter numbers, labels and simple formulae into a spreadsheet and to use the data to calculate totals. Children will be introduced to spreadsheet software and will explore how changes in price and quantity can affect total cost. Children will apply what they have learnt in this unit when exploring mathematical and scientific models.
Children will be able to explore the effects of changing data in a spreadsheet.
A guideline sheet to help children produce a spreadsheet to calculate cost of buying several different items for a party.



Using Excel Templates (primary)
http://www.forsyth.k12.ga.us/sbeck/
How to Create a Template in Excel | Samples of Elementary Templates | Categorizing and graphing Skittles, surveying and graphing Eye Color and Pets | Did Somebody say Pizza? | Other Great Ideas for Using Excel with Primary Students |


Spreadsheet Tools
http://www.2learn.ca/teachertools/Spreadsheet/ssintro.htm
Spreadsheets can make you think! Working with spreadsheets can require practice of problem-solving skills.... There is a literacy in being able to input, process and reconstruct information through spreadsheet applications if projections made and conclusions drawn from the data are to be reasonable.


Boxplots in Excel
http://www.mis.coventry.ac.uk/~nhunt/boxplot.htm
A boxplot, or box and whisker diagram, provides a simple graphical summary of a set of data. It shows a measure of central location (the median), two measures of dispersion (the range and inter-quartile range), the skewness (from the orientation of the median relative to the quartiles) and potential outliers (marked individually).


DISCUS
http://www.mis.coventry.ac.uk/research/discus/discus_home.html
DISCUS is a set of interactive spreadsheets, written in Microsoft Excel, which are designed for teaching statistics at sixth form and first year undergraduate level.
The materials are designed to be used off the shelf by students working on their own, and little preparation by teaching staff is required.
It consists of a set of eight Microsoft Excel workbooks, each on a particular topic, and a set of associated photo-copyable workcards which provide a series of thought provoking challenges to help students gain insight and understanding.
Descriptive Statistics | Probability | Binomial Distributions | The Poisson Distribution | Continuous Distributions | Sampling | Regression | Hypothesis Testing |


Dinosaur data files
http://www.nhm.ac.uk/education/online/dinosaur_data_files.html
These dinosaur data files have been designed so that they can be printed out and photocopied for educational use in the classroom, at home or in the Museum itself. We have also created some suggestions for activities you may like to try, and a spreadsheet file in Excel format containing much of the data in these data files for further classroom work.


Spreadsheet resources
http://atschool.eduweb.co.uk/allsouls/ssheets/ssheet.html
Click on the icons below to download a set of Excel 5 spreadsheets that enables you to generate simple worksheets. Useful for homework or differentiation.
Simple 1,2 & 3 digit addition and subtraction plus simple multiplication
Simple function machines and addition squares
Putting numbers in order

No comments:

Post a Comment