# Is it possible to do this in excel?

Printable View

• 10th June 2012, 10:41 AM
Kineas
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.
• 10th June 2012, 10:56 AM
Michael
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, 11:51 AM
CyberNerd
Google Apps spreadsheets.
You could import live data directly from SIMS, share the results or publish the live graphs directly on you website
http://www.edugeek.net/forums/mis-sy...eadsheets.html

If you don't have google apps then any old spreadsheet app could do what you want, including excel.
• 10th June 2012, 12:06 PM
sted
Wouldn't access possibly be a better bet?
• 10th June 2012, 12:31 PM
laserblazer
Quote:

Originally Posted by sted
Wouldn't access possibly be a better bet?

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.
• 10th June 2012, 03:34 PM
Steven_Cleaver
Hi
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.