Is it possible to do this in excel?

[Kineas]

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.

[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.

[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-systems/89106-live-mis-data-google-spreadsheets.html

 

If you don't have google apps then any old spreadsheet app could do what you want, including excel.

[sted]

Wouldn't access possibly be a better bet?

[laserblazer]

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.

[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.

Edited June 10, 2012 by Steven_Cleaver