BTEC Level 3 National Diploma in Information Technology Unit 4: College tournament

Attached is a Python file which meets all areas of the brief for the 2023 assignment (see below)

***You are a junior employee at a small software development company. Your company recently visited a local college and delivered a guest lecture. The college were pleased with the outcome of the visit and have asked your company to judge an upcoming tournament.

**The college will be running a tournament for students to compete in a series of events for prizes.
Participants may enter the tournament as individuals or as part of a team
It is expected that will be 4 teams each with 5 members and there will be 20 spaces for individual competitors
Each team or individual will complete 5 events
Each event will be defined as a team or individual event
The events will vary in type, from sporting to academic challenges
Individuals and teams will be awarded points according to their rank within each event
The points awarded for each event are as yet undecided and the college are willing to hear any suggestions you may have
Also the college would like to include the possibility of entering for one event only

This solution fully hits the brief and was an efficient way of hitting all the brief requirements in a logical way, using mainly data added to lists. The hardest part for this was populating the data within a table and to do that variables had to be used to define each individual competitor.

The finished program allows the user to collect data for; Teams, individuals completing 1 event only and individuals completing all 5 events. This data is then populated to a table and exported to a excel file. The only problem i could not fix within python was arranging the table to display the winners in rank order, however this can be done with a simple sort on the data after it has been populated to an excel file.

In order export to an excel file you need to ensure the ‘Pandas’ module is installed. This can be installed in the command line by typing ‘pip install pandas’