+ Post New Thread
Results 1 to 5 of 5
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 ...
  1. #1
    rocknrollstar's Avatar
    Join Date
    Jun 2008
    Location
    Hampshire
    Posts
    435
    Thank Post
    387
    Thanked 28 Times in 24 Posts
    Rep Power
    20

    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.

    Any thoughts?

    Thank you

  2. #2
    User3204's Avatar
    Join Date
    Aug 2006
    Location
    Wirral
    Posts
    769
    Thank Post
    55
    Thanked 66 Times in 62 Posts
    Rep Power
    34
    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 12:53 PM.

  3. #3

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,572 Times in 1,252 Posts
    Rep Power
    340
    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.

  4. #4


    Join Date
    Sep 2007
    Location
    UK
    Posts
    5,449
    Thank Post
    1,447
    Thanked 889 Times in 570 Posts
    Rep Power
    647
    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.

  5. #5
    rocknrollstar's Avatar
    Join Date
    Jun 2008
    Location
    Hampshire
    Posts
    435
    Thank Post
    387
    Thanked 28 Times in 24 Posts
    Rep Power
    20
    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.

    Many thanks

SHARE:
+ Post New Thread

Similar Threads

  1. PICS Levels in censornet
    By gh256 in forum How do you do....it?
    Replies: 5
    Last Post: 10th December 2007, 03:59 PM
  2. Sorting Music
    By OutLawTorn in forum How do you do....it?
    Replies: 10
    Last Post: 23rd November 2007, 11:10 AM
  3. Sorting Programs List by Name
    By Midget in forum Windows
    Replies: 17
    Last Post: 24th January 2007, 11:04 AM
  4. Wireless signal Levels
    By ChrisH in forum Wireless Networks
    Replies: 2
    Last Post: 19th July 2005, 09:08 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •