Office Software Thread, Is it possible to do this in excel? in Technical; I have been requested to create something, possibly a spreadsheet, that would have on it all of the kids from ...
10th June 2012, 11:41 AM #1
- Rep Power
Is it possible to do this in excel?
I have been requested to create something, possibly a spreadsheet, that would have on it all of the kids from the school. It would then detail their gender, and what after school activites they attend. I need it to be able to show me statistics such as % of kids that are doing after school activities, and maybe show %'s of different genders too. I'm thinking it's best to have a column for each club and either have a 0 if they don't attend it, or a 1 if they do. After this point I hit a brick wall.
Any help would be great, or suggestions of other software that could do this.
IDG Tech News
10th June 2012, 11:56 AM #2
Yes - Excel would be the way to go. You can export a lot of this info from CMIS or SIMS, then write formulas to calculate other percentages for you.
10th June 2012, 12:51 PM #3
Google Apps spreadsheets.
You could import live data directly from SIMS, share the results or publish the live graphs directly on you website
Live MIS data in Google Spreadsheets
If you don't have google apps then any old spreadsheet app could do what you want, including excel.
10th June 2012, 01:06 PM #4
Wouldn't access possibly be a better bet?
10th June 2012, 01:31 PM #5
I'd say not. Excel will do it quickly and easily. You can bet your life that every five minutes you will be asked to modify it and that's quicker to do in Excel.
Originally Posted by sted
10th June 2012, 04:34 PM #6
Excel would do this since you are in Birmingham school presume you are using CMIS if not SIM's should be able to Export most of the initial information Student No, Surname, Forename, Class, Year, Gender etc from these systems in a report into Excel. Add the extra Columns to the exported information so other after school activities. Use COUNTIF to count criteria so =COUNTIF(C3:C9,"M") to count male =COUNTIF(C3:C9,"F") Female, to get percentage use =male Total (cell reference)/Total Students (Cell reference)*100 example =C10/C12*100.
You could also use Pivot Tables to produce different reports on different criteria.
Last edited by Steven_Cleaver; 10th June 2012 at 04:35 PM.
By AyatollahPies in forum Windows Server 2008 R2
Last Post: 12th October 2010, 04:53 PM
By farquea in forum Windows
Last Post: 17th June 2010, 12:46 PM
By PEO in forum Graphics Requests
Last Post: 2nd June 2010, 10:42 AM
By cheredenine in forum MIS Systems
Last Post: 9th October 2009, 11:35 AM
By ChrisH in forum Windows
Last Post: 29th March 2006, 09:16 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)