Class materials - Digit and AI
Challenge 11: Talent Identification Project
Scenario
You are a youth coach working for a sports club. The club would like to recruit talented young athletes for one specific track and field event.
You have received performance test results from 200 young athletes. Your task is to analyze the data and identify the three most promising athletes for your chosen event.
Remember: Talent identification is not only about current performance. Young athletes may differ in age, development level, and future potential.
Questions to Consider
- Which variables are most important for success in this event?
- Which athletes perform best in those variables?
- How important is age in your decision?
- Would you select the athlete with the best current performance, or a younger athlete with slightly lower results but greater long-term potential?
- How do you balance current performance and future development potential?
Available Events
Choose ONE of the following events:
- 100 m Sprint
- 1500 m Run
- Shot Put
- Javelin Throw
- High Jump
Part 1: Microsoft Excel
Data Analysis
- Download and open the dataset.
- Decide which performance indicators are most relevant for your chosen event.
- Sort and filter the data.
- Identify the Top 10 athletes.
- Create at least one chart that supports your selection.
Questions to Consider
- Which variables are most important for success in this event?
- Which athletes perform best in those variables?
Part 2: Microsoft Word
Coach's Recommendation Report
Prepare a short professional report (approximately one page).
Include:
- Chosen event
- Selection criteria
- The role of age in your decision-making process
- Names of the Top 10 athletes
- Justification for each selection
- Final 3 recommendation to the club
Use clear headings and professional formatting.
Part 3: Microsoft PowerPoint
Talent Identification Presentation
Create a presentation containing:
- Title slide
- Chosen event
- Selection criteria
- Top 3 athletes
- Conclusion
Requirements
- 2-3 slides
- At least one chart from your Excel analysis
- Clear and readable slides
- Keywords instead of long paragraphs
Important
- Complete the Excel analysis before writing the report.
- Use evidence from the dataset to support your decisions.
- Create all slide content before formatting the presentation.
- Review your presentation in Slide Show mode before submission.
Deliverables
Submit (sebesi.balazs):
- Excel file
- Word report
- PowerPoint presentation
Goal
Use digital tools in a realistic coaching scenario to analyze performance data, identify talented athletes, justify your decisions, and communicate your findings professionally.
There is no single correct answer. Different coaches may make different selections depending on how they value current performance, age, and long-term potential. The key is to justify your decisions using evidence from the dataset.
Help & Hints
Microsoft Excel
Sorting Data
Sorting helps you identify the athletes with the best results in a specific test.
To sort the dataset:
- Select any cell within the dataset.
- Open the Sort & Filter option.
- Choose Filter.
- Select the column you want to sort by.
- Choose the appropriate order.
Remember that lower values are better for sprint and running events, while higher values are better for jumping and throwing performances.
Creating Charts
Charts can help you compare athletes and support your decisions.
To create a chart:
- Select the required data.
- Open the Insert tab.
- Choose a chart type.
- Add a chart title.
- Check that the chart is easy to understand.
Using Age in Your Analysis
The goal is not necessarily to select the athletes with the best current performances.
Consider whether a slightly younger athlete with strong results may have greater long-term potential than an older athlete with similar performance levels.
There is no single correct approach, but your decisions should be supported by evidence from the dataset.
Microsoft Word
Writing Tips
Use clear headings to organize the report.
Support every recommendation with data from the dataset.
Explain why each athlete was selected.
Describe both performance and potential where appropriate.
Use professional language throughout the report.
Questions to Consider
Why did you choose these athletes?
Which variables influenced your decision the most?
How much importance did you give to age?
Would another coach using the same data reach the same conclusion?
Microsoft PowerPoint
Creating the Presentation
Your presentation should summarize the results of your analysis.
Presentation Design
Create all slide content before making design changes.
Use short bullet points instead of long paragraphs.
Include at least one chart from your Excel analysis.
Keep the design consistent throughout the presentation.
Ensure that all text is readable from a distance.
Presenting Data
Focus on the most important findings.
Do not copy the entire Word report onto the slides.
The slides should highlight key points, while the explanation is provided by the presenter.
Final Check
Before submitting your work:
- Review the Excel analysis.
- Check the Word report for clarity and professionalism.
- Run the PowerPoint presentation in Slide Show mode.
- Verify that all files support the same conclusions.
Email Submission
Use a clear and professional email.
Subject:
Challenge 11 Submission
Example:
Dear Dr. Sebesi,
Please find attached my files for Challenge 11.
Best regards,
Your Name
Before sending, make sure all required files are attached and named appropriately. Academic emails should be clear, polite, and concise.
How Coaches Make Decisions
Talent identification is rarely based on a single performance measure.
Different coaches may select different athletes based on:
- Current performance
- Age
- Long-term potential
- Strengths in multiple tests
As long as your decisions are supported by data and your reasoning is explained clearly, your solution can be considered valid.