+ Post New Thread
Results 1 to 3 of 3
Office Software Thread, Excel - graph to show reduction in absence/lates in Technical; Hi, I've been urgently tasked to make a graph showing how lateness for different students has reduced within a certain ...
  1. #1
    Fleetwood's Avatar
    Join Date
    Feb 2012
    Posts
    757
    Thank Post
    189
    Thanked 107 Times in 58 Posts
    Rep Power
    44

    Excel - graph to show reduction in absence/lates

    Hi,

    I've been urgently tasked to make a graph showing how lateness for different students has reduced within a certain date range - my brain tells me a line graph, but I can't work out how to go about implementing the data. Unfortunately Excel/Graphs in general aren't by any means something I enjoy or part of my expertise, but as OFSTED are here for a 3-day inspection I've got to get it done.. but have no idea where to start!

    Any ideas/tips to share? I'd greatly appreciate it. All I've got 'data' wise is on paper, simply with (for example

    30.4.13 | On time
    1.5.13 | Late

    etc.

    Ta
    Last edited by Fleetwood; 22nd October 2013 at 10:27 AM.

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,771
    Thank Post
    1,511
    Thanked 1,294 Times in 884 Posts
    Rep Power
    813
    Which MIS do you use? I'd start there, depending on the MIS you could get it to produce the graphs or at the very least populate a spreadsheet with data so you don't have to type it all in

  3. #3
    spadam's Avatar
    Join Date
    Feb 2011
    Location
    Dudley
    Posts
    157
    Thank Post
    23
    Thanked 41 Times in 31 Posts
    Rep Power
    14
    If your data is only available in the format you describe the way I'd start would be by calculating the percentage attendance for a number of different periods (weeks or terms maybe). Then use these values as the data for a (line) chart. If you're still struggling post some sample anonymised data and I'll try and throw together a 'quick n dirty' example.



SHARE:
+ Post New Thread

Similar Threads

  1. Assigning a excel Macro to work in all workbooks
    By FatBoy in forum Office Software
    Replies: 8
    Last Post: 24th November 2010, 03:23 PM
  2. Replies: 1
    Last Post: 19th August 2010, 10:51 AM
  3. Can't get bullet points to show in Moodle
    By beeswax in forum Virtual Learning Platforms
    Replies: 6
    Last Post: 11th February 2010, 01:35 PM
  4. Replies: 2
    Last Post: 11th December 2008, 01:04 PM
  5. Want software to show me whos currently logged in.
    By MrLudwig in forum Wireless Networks
    Replies: 20
    Last Post: 10th September 2006, 12:09 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
  •