Oregon Skills USA

Your organization is working to grow new chapters and provide training support.

They need a system to:

• Track chapters
• Monitor training progress
• Organize contact information
• Identify which chapters need help

You have been hired to build a tracking system and presentation.

Your Task

Using:

• Microsoft Excel
• Microsoft PowerPoint

You will create a system to track chapters and present your findings.

Part 1: Excel (Main Project)

You are creating a reusable system that someone else could use later.

Step 1: Enter the Data

Use the dataset provided at the bottom of this sheet.

Step 2: Create Calculations

You must create formulas for:

• Training Status
  
  • “On Track” (Training Completed = Yes)
  • “Needs Training” (Training Completed = No)
• Priority Level
  
  • High Priority → No training AND 20+ students
  • Medium Priority → No training AND less than 20 students
  • Low Priority → Training complete

Step 3: Format the Sheet

• Highlight High Priority rows
• Make your sheet clean and easy to read
• Use clear headings

Step 4: Create a Summary Section

Include:

• Total number of chapters
• Number needing training
• Number fully trained
• Number of high priority chapters

Step 5: Create Charts (at least 2)

• Chart 1: Chapters by Training Status
• Chart 2: Chapters by Program Area

Part 2: PowerPoint

Create a 3–5 slide presentation:

1. What your system does
2. Key findings (who needs help)
3. Charts from Excel
4. Your recommendations

Rules

• Work individually
• Use only the provided data
• No outside help
• Keep everything professional

 What You Are Being Judged On

• Accuracy of formulas
• Organization and design
• Ability to identify priorities
• Quality of charts
• Clear communication

Add aat least two of the following 

• Drop-down lists (Data Validation)
• Excel Tables (Ctrl + T)
• COUNTIF or COUNTIFS formulas
• Nested IF formulas
• Filters or sorting tools
• Pivot Tables
• Slicers (interactive filters)
• Dashboard-style layout

👉 These features make your system more professional and easier to use.

Data example to use here https://docs.google.com/spreadsheets/d/17Wzfl7C_RParaJ3TKR1-vh5RN05CXPqg/edit?usp=sharing&ouid=103480188669051474808&rtpof=true&sd=true