Office Software Thread, Sorting levels in Excel - eg 2a 2b 2c in Technical; Hi, we use Excel for pupil level tracking. Levels are stored as 2a, 2b, 3c for example (according to QCA/SATs ...
14th September 2008, 12:54 PM #1
Sorting levels in Excel - eg 2a 2b 2c
Hi, we use Excel for pupil level tracking. Levels are stored as 2a, 2b, 3c for example (according to QCA/SATs levelling).
I'd like to be able to sort these sensibly, but in Excel, 2a will come before 2b and so on. When we want to sort ascending, this won't work as 2a will be before 2b, but it should be the other way round.
Has anyone got any ideas for doing this?
Also- if you wanted to produce graphs of pupil progress, this will obviously make it difficult- drawing a graph using letters and numbers won't really work.
14th September 2008, 01:48 PM #2
I'm at home, where I use OpenOffice, so I don't know if it works the same... although it must be possible...
Anyway.. in OpenOffice (ver 2. whatever) If you click on the Tools > Sort > options, you can define a "custom sort order".
..Oh, and you'll have to have predefined a list from Tools > Options > OpenOffice Calc > Sort Lists
Dunno about the graphs.
Last edited by User3204; 14th September 2008 at 01:53 PM.
14th September 2008, 02:33 PM #3
I've produced spreadsheets for schools for monitoring/leveling. The easiest way around your problem is to use filtering, so when you specify a certain level, you just view all the pupils who are at that level.
14th September 2008, 05:49 PM #4
You could split the number and letter into separate columns. Then sort on the number column first then letter column. Hiding the two new columns. Just tried it and it seems to work ok.
15th September 2008, 08:21 PM #5
Thanks for your help on this.
I came across Sorting in Excel which lets you define custom sorting orders (so that a 2b comes before 2a) etc.
I'm also looking into using VBA macros to help with finding sub level progress.
By gh256 in forum How do you do....it?
Last Post: 10th December 2007, 04:59 PM
By OutLawTorn in forum How do you do....it?
Last Post: 23rd November 2007, 12:10 PM
By Midget in forum Windows
Last Post: 24th January 2007, 12:04 PM
By ChrisH in forum Wireless Networks
Last Post: 19th July 2005, 10:08 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread