+ 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
    733
    Thank Post
    176
    Thanked 97 Times in 52 Posts
    Rep Power
    42

    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,492
    Thank Post
    1,451
    Thanked 1,197 Times in 812 Posts
    Rep Power
    711
    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
    120
    Thank Post
    18
    Thanked 32 Times in 22 Posts
    Rep Power
    13
    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
  •