+ Post New Thread
Results 1 to 2 of 2
How do you do....it? Thread, Display Audit Infomation in Technical; Hi We have carried out an staff audit asking what training sessions would you like over the next year. The ...
  1. #1

    Join Date
    Mar 2007
    Thank Post
    Thanked 4 Times in 3 Posts
    Rep Power

    Question Display Audit Infomation


    We have carried out an staff audit asking what training sessions would you like over the next year.

    The form had 10 training session to choose from and a box next to each session name.

    The boxes have been filled in 1-10 1 being the most wanted training session.

    Now i have to display this information and workout what traing session should be booked and who should be on them.

    Anyone have a good and hopefully easy solution for this as i cant work it out.



  2. #2

    SYNACK's Avatar
    Join Date
    Oct 2007
    Thank Post
    Thanked 2,730 Times in 2,309 Posts
    Blog Entries
    Rep Power
    Chuck the results in excel, use the formula
    =11-F6{place holder for the cell with the 1 - 10 rating in it}

    Now you have the values as 10 being the most wanted and 1 the least, total all of the values for each session across all of the staff members and then bar graph that. It should give you a nice clear graph of the staffs overall preference.

    Didn't see the bit about allocating to teachers to courses you could probably take the most popular course and then see which teachers had it within their top placings 1-3 and assign them to it and do the same for the others. I'm not really to sure on this one.

    Yay 1000th post
    Last edited by SYNACK; 17th June 2008 at 08:00 PM.

  3. Thanks to SYNACK from:

    cooper (17th June 2008)

+ Post New Thread

Similar Threads

  1. Hardware Audit
    By sLiDeR in forum Network and Classroom Management
    Replies: 15
    Last Post: 11th November 2008, 11:43 AM
  2. Audit Tool - How do you Audit your exuipment
    By Nij.UK in forum General Chat
    Replies: 7
    Last Post: 4th November 2008, 12:33 PM
  3. Hardware Audit
    By Mr_M_Cox in forum Windows
    Replies: 12
    Last Post: 4th June 2008, 12:51 PM
  4. Audit
    By sdc in forum General Chat
    Replies: 4
    Last Post: 29th April 2008, 08:08 PM
  5. software Audit
    By bishopsgarthstockton in forum How do you do....it?
    Replies: 3
    Last Post: 26th September 2007, 10:43 AM

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