A variation on the original scaling spreadsheet, this spreadsheet has standard deviation, average (mean) as well as grade scaling.
Updated Mark Scaling Spreadsheet (ideal for teachers)
Bookmark to:
No Comments »
Filed under: Calc, Intermediate
Thanks for the emails.
The Scaling Spreadsheet link is now fixed. Sorry for the inconvenience.
Bookmark to:
No Comments »
Filed under: Calc, Intermediate
For those that need their docs on the go, but are not keep to go mainstream, then this may be an option for you.
Check the Javascript and Java requirements for browser compatibility (especially Linux users), but it seems like a very viable option!
Try Ulteo
Bookmark to:
1 Comment »
Filed under: Online, Useful Tools, Intermediate, OpenOffice
This is some reading that I found recently that makes it easier for OpenOffice and Word to exchange files a little more seamlessly. This has become more important as I am consulting in an environment that is a strict MS user - and being able to have documents that open seamlessly in the MS Word […]
No Comments »
Filed under: Intermediate, Writer, OpenOffice
Yes there is and it can be applied in most of the OpenOffice applications. I am demonstrating it in Writer below, however the same steps are applied to cells in Calc.
1. Highlight the area from which you wish to copy the format from.
2. Click on the format painter icon in the toolbar.
3. When the mouse […]
4 Comments »
Filed under: Intermediate, OpenOffice
For those that aren’t familiar with the term, concatenation is the joining together of things - specifically side-by-side. This is often something that we wish to do, for example, if we have a first name and a family name.
EG. If we had the first name ‘David’ and the family name ‘Collier’ and we wanted to […]
1 Comment »
Filed under: Calc, Intermediate
For those that need to convert documents from images and graphics into text, you may find ScanR a very useful tool.
It allows you to email JPG documents to their site, and uses OCR (Optical Character Recognition) to transform the picture into a text document that you can then edit. There are some requirements in order […]
No Comments »
Filed under: Useful Tools, Intermediate
I was recently requested by a teacher to set up a spreadsheet to assist in scaling an examination result. The spreadsheet allows the user to enter in student numbers, student names, the original marks, the original scale (total marks for the assessment). There are then a number of columns with different scaling ratios applied, and […]
No Comments »
Filed under: Calc, Intermediate
If you like the way that Firefox has tabs, then a simple extension for OpenOffice has been developed that allows you to have this feature while working on Spreadsheets, Word Processing Documents and Slide Presentations.
The Tabbed Windows Extension is a work in process and only has very basic functionality, but it will get rid of […]
No Comments »
Filed under: Intermediate, OpenOffice
I like this post because it has the method for using styles to set up a table of contents.
It’s similar to the way you do it in MS Office.
There is no point re-inventing the wheel, so I will link to it here:
Quick Guide to Creating Automatic Tables of Contents
If you wish to download an […]
1 Comment »
Filed under: Templates, Intermediate, Writer
