Sports day program

[imullings]

I have been asked to find/create a program to manage our sports day results.

I am just about to start the coding but I wondered what other schools do?

Have you found a good free/commercial program to handle this job?

Ian Mullings

Devizes School IT Support

[kesomir]

Open Office calc.

 

Alternatively, you could use excel.

[jcollings]

Excel here - enter results, works out points, gives form and year totals etc.

 

Welcome to a copy if you want.

[Oops_my_bad]

Can the P.E staff not just write them down? That's what they do here..

 

Or would this be too much work for them?

[jcollings]

Can the P.E staff not just write them down? That's what they do here..

 

Or would this be too much work for them?

 

Our staff used to do that, then manually work out points etc.

 

The point of the new system is that they can enter results as events happen and get instant winners/points etc. Our guys loved it.

 

I guess that is what the OP is doing it for.

 

I built ours 'cos it seemed like an obvious place IT could make their lives better which is pretty much what I'm there for! ;-)

Edited June 17, 2008 by jcollings

[benIT]

We have a commercial product, I will get the name when in work monday.

 

got about 6 utils relating to sports day - PM me if you have not heard from me by mon pm

 

cheers

 

ben

[linkazoid]

Our PE Staff use a really old product called Sports16, used to be on a couple of old floppies..

 

Dunno much more about it, i can find our for you when they are back on monday tho.

 

Michael

[linkazoid]

Hi Ian,

 

Just found out that the product is sold by AVP - Educational Software, DVD and Equipment Product Number W08-sls18

 

Michael

[dezt]

Excel here - enter results, works out points, gives form and year totals etc.

 

Welcome to a copy if you want.

 

Any chance of getting a copy of that here?

[iatkinson]

Couple of worksheets I knocked up in excel, you'd have to tailor them to your own tutor groups but anyone's welcome to use them. Sports Day 07.zip

[jcollings]

Any chance of getting a copy of that here?

 

Sure - it's attached.

There's lots of hidden columns and things so points can be looked up.

 

Also as male and female can compete in different events you need to enter males and females seperately -- I do this by just filtering on gender. I think next year I'll create seperate sheets for them. Also Y7&8 score on one system and Y9&10 on another.

 

Give me a yell if you need any more help with it as it's all in my head and not documented.

Sports Day 2008.zip

Edited June 18, 2008 by jcollings

[dezt]

Thanks, i'm sure we've got sports day coming up soon.

[jcollings]

Just to say the sheet I uploaded yesterday had one or 2 errors in it. The link now has an amended version with the corrections made.

 

Sorry

[Domino]

Anyone using sharepoint can quite easily set up a web based version as we have.

 

obviously this means no applications needed, less likelyhood of it being deleted/messed about with, etc

 

Windows also have some application templates which are quite good

Application Templates for Windows SharePoint Services 3.0

 

and one of these is a Sports League - could be adapted for you needs

http://www.microsoft.com/downloads/details.aspx?FamilyId=F811D8C1-2C55-4960-8B59-25808DB5F793&displaylang=en

 

Of course, this requires either WSS or MOSS to begin with - but I can really recommened it for schools anyway

[dhockridge]

Hi,

do you have the password so i can edit them?

Thanks

Dave