+ 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
    Location
    Gloucestershire
    Posts
    707
    Thank Post
    160
    Thanked 88 Times in 49 Posts
    Rep Power
    40

    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 09:27 AM.

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,432
    Thank Post
    1,432
    Thanked 1,160 Times in 794 Posts
    Rep Power
    705
    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

    Join Date
    Feb 2011
    Location
    Dudley
    Posts
    119
    Thank Post
    17
    Thanked 32 Times in 22 Posts
    Rep Power
    12
    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, 02:23 PM
  2. Replies: 1
    Last Post: 19th August 2010, 09: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, 12:35 PM
  4. Replies: 2
    Last Post: 11th December 2008, 12:04 PM
  5. Want software to show me whos currently logged in.
    By MrLudwig in forum Wireless Networks
    Replies: 20
    Last Post: 9th September 2006, 11:09 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
  •