Athletics App


I have built Access Database (accdb) Application which is working in my school on the network and on laptops. I want to convert this to a web site so that many schools can use it but don't have the time to learn a new skill set. The database is intended to record students performance in Athletics events, award points from a lookup table and produce queries based on event, class(teaching group), year group, house, gender, etc..

Events are:

Sprints (100m,200m,300m,400m,800m,1500m, 3000m)

Jumps (long jump, high jump, triple jump, pole vault)

Throws (shot, javelin, discus, hammer)

Teacher needs to look up the class, select the event. The application then displays a list to which the teacher can add the student performance. The application then looks up the points to be awarded for this event and displays them as the student data is entered. The teacher can then print out that list, if they wish, while it is current so that students can quickly view their performance.

All data is stored for all events in order that students can be ranked by their performance in each Event, or the 'Best3' scores for a Sprint, Jump and Throw, or the 'Best5' scores - which is best Sprint, Jump and Throw plus the next best 2 events not used in the Best3. Staff need to be able to construct queries with up to 2 parameters eg best girl in ([house]) or ([year group]) or just by class (teaching group), year group, house, gender etc, and sort by performance ie time or distance.

Individual records also need to be produced as a record sheet for all events. ie a student's best performance (and points) for each event (even if not taken part in) and the award (if any) - see below

There is an award system that awards levels when a student has achieved different thresholds of points from their best performances eg a student's best performances this year add to 400 points which gets him "Level 4".

To summarise there are 4 main sequences:

1. Admin - staff need to be able to upload and edit class lists to the database -this must obviously be specific for a school or institution as many schools may wish to use it (i hope)

2. staff need to select a class and event and enter data for a selected group and a selected event with a date field for the Event. Data enterd will be either in seconds, minutes and seconds, or meters and centimetres. Staff also need to enter DNS (did not start) or DNF (did not finish). All times are converted to seconds to lookup in my current database.

3. staff need to be able to query the database with up to 2 parameters (cant think why they might need any more) for class/group lists or to produce individual performance sheets and make awards

4. after each school year the records need archiving in order that best performances/ school records may be maintained. Schools like to remember that John Smith ran 100m in 8 seconds(!) in 2013 or the highest best3 or best5 was Amy Jones in 2014. These are targets for later students to aspire to.

I suggest that the best 3 (not'Best3') performances by girls and the best 3 by boys, for each event and each year group ( in my school there are 5 year groups in each calendar year - years 7 to 11) including Best3 and Best5 are archived.

I suggest that the site can only be accessed by staff from staff computers/laptops so the username of the device must be quietly required before password and name are asked for. Schools are really cagey (rightly) about data going out on the web. Is it possible that names do not leave the school, only the admission number and that names are removed when the data goes out and added when the data comes back in. This would require a browser of some kind (dont know the terminology) but I envisage some kind of local application which views the external site and edits the data going out and coming back in so that anyone hacking the external site directly, without using this application, would not get meaningful info. Does this make sense? Am I being paranoid?

Skills: Anything Goes, ASP, PHP, Website Design

See more: web awards, the jones group, sprint application, look for part time staff, look for dns, learn php best, high jump, highest ranked, different views of a house, convert site to app, part time teacher, level it app, school app, going out app, database - student list, aspire, app teaching school, amy, admin staff required, calendar web app, convert access application web access application, wish list app, teacher calendar, calendar views, app calendar list

About the Employer:
( 0 reviews ) Okehampton, United Kingdom

Project ID: #4650761

27 freelancers are bidding on average £1270 for this job


Hello, I have reviewed your project posting and believe that we will be able to assist you in your need.Do check PMB for more details about us. Regards

£1237 GBP in 30 days
(122 Reviews)

Please see PMB for more detailed message.

£1546 GBP in 40 days
(33 Reviews)

Hi We are interested in your project and read your requirements.We have completed 150+ big projects in last 5 years. Please check private message board for details.

£1288 GBP in 8 days
(59 Reviews)

Hello, I am ready to develop this app.

£1546 GBP in 20 days
(512 Reviews)

Check your PMB for details!!!

£1221 GBP in 22 days
(75 Reviews)

Right profile and high quality work await your acceptance. Plz. check PMB for details. Thanks & regards,

£1500 GBP in 45 days
(75 Reviews)

Please see inbox

£1000 GBP in 45 days
(114 Reviews)

Appreciate if you can kindly check my comments, in the following message board. We look forward to your advice.

£1498 GBP in 45 days
(69 Reviews)

Thanks for your consideration, please see our message and if you would like to discuss the project further do get in touch and I'll give you a call.

£1578 GBP in 25 days
(26 Reviews)

Greetings from EUPHORBIA(TM)! Please check your PMB for our detailed bid. Quality work & your satisfaction is 100% guaranteed or we will gladly refund your money. Please review our portfolio & client feedback rating. O More

£1000 GBP in 35 days
(96 Reviews)

Hi, We can help you to build this Athletics app using PHP CodeIgniter+Twitter Bootsrap. Thanks.

£1500 GBP in 30 days
(94 Reviews)

Hi, I went through your requirements , we are expert in web developments with web2.0 standards, website design and customization. i am sure we will deliver a good quality of work. Please have look of our portfoilio and More

£1546 GBP in 45 days
(49 Reviews)

I'm interested and ready to work on this project.

£1262 GBP in 30 days
(20 Reviews)

Please check your PM. Thanks.

£1000 GBP in 14 days
(24 Reviews)

Please check the pmb

£1371 GBP in 30 days
(5 Reviews)

We can work in your Athletics App. I am a leader of the team expert in several tecnologies like PHP, .NET, Oracle, SQL, Movil applications. I have 14 Years of experience in Software development Windows and Web. Expert More

£1237 GBP in 30 days
(4 Reviews)

Hi, I (Myself a senior ASP.NET programmer using C# and VB) have a team having experience of more than 5 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-fre More

£1050 GBP in 30 days
(8 Reviews)

Dear sir, I am a senior developer with strong php knowledge and very much interested to start work with you. I have already done same kinds of works. Please check PMB. thanks

£750 GBP in 39 days
(1 Review)

Hello, No, you are not being paranoid and your concern about data security is absolutely valid. Now whatever data you are trying to protect will need to reside in some database. If you are using an Internet based sy More

£1250 GBP in 10 days
(6 Reviews)

We are ready for this project. We clearly understand the work. We want you to initiate chat so that we can have a better understanding on the project. Please see PMB Regards, SB RaidMax

£884 GBP in 27 days
(5 Reviews)