+ Post New Thread
Results 1 to 3 of 3
General Chat Thread, Excel Assesment Data in General; I have a large excel file of all of our Year 11 grades, Effort, Attainment, Grade etc for each subject ...
  1. #1

    Join Date
    Apr 2006
    Location
    UK
    Posts
    939
    Thank Post
    39
    Thanked 70 Times in 54 Posts
    Rep Power
    29

    Excel Assesment Data

    I have a large excel file of all of our Year 11 grades, Effort, Attainment, Grade etc for each subject x 15

    E.g.

    Admission Subject Effort Attainment Grade
    0001 Maths 5 6 A
    0001 English 7 6 B

    Etc for 200 pupils and 15 subjects

    I need to change the layout, i need subjects across the top of the sheet, admission stays where it is, but duplicates get removed,

    Any ideaS?

  2. #2
    skunk's Avatar
    Join Date
    Mar 2006
    Location
    North West
    Posts
    311
    Thank Post
    88
    Thanked 40 Times in 33 Posts
    Rep Power
    29
    You want to use pivot tables, these are a great way of condensing data and pivoting it as well.

    They can take a bit to get used to, but once you have you will never look back.

    Skunk

  3. #3

    elsiegee40's Avatar
    Join Date
    Jan 2007
    Location
    Kent
    Posts
    10,709
    Thank Post
    1,784
    Thanked 2,170 Times in 1,605 Posts
    Rep Power
    770

SHARE:
+ Post New Thread

Similar Threads

  1. Programatic data extraction from SIMS.net Data Base
    By NetworkGeezer in forum MIS Systems
    Replies: 108
    Last Post: 16th February 2010, 09:22 PM
  2. Risk Assesment - URGENT
    By Ben_Stanton in forum School ICT Policies
    Replies: 4
    Last Post: 21st November 2007, 11:37 AM
  3. Excel 2007
    By wesleyw in forum How do you do....it?
    Replies: 7
    Last Post: 25th June 2007, 05:39 PM
  4. Serco School Self Assesment
    By budgester in forum MIS Systems
    Replies: 3
    Last Post: 26th February 2007, 10:45 AM
  5. Interactive assesment KS3 Geography
    By ChrisH in forum Educational Software
    Replies: 19
    Last Post: 6th December 2006, 02:02 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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