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 ...
22nd October 2013, 10:23 AM #1
Excel - graph to show reduction in absence/lates
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
Last edited by TBlax; 22nd October 2013 at 10:27 AM.
IDG Tech News
22nd October 2013, 10:37 AM #2
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
22nd October 2013, 10:58 AM #3
- Rep Power
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.
By FatBoy in forum Office Software
Last Post: 24th November 2010, 03:23 PM
By zx2012 in forum Web Development
Last Post: 19th August 2010, 10:51 AM
By beeswax in forum Virtual Learning Platforms
Last Post: 11th February 2010, 01:35 PM
Last Post: 11th December 2008, 01:04 PM
By MrLudwig in forum Wireless Networks
Last Post: 10th September 2006, 12:09 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)