GPT-4o
📚 Education
Intermediate
Create Excel Assignment Guide
Build a structured Excel assignment for students or employees — with instructions, data sets, and grading criteria.
The Prompt
# Excel Assignment Guide Create a complete Excel assignment for [AUDIENCE — e.g., high school students, college students, new employees, data analysis trainees] on the topic of [TOPIC — e.g., budget management, sales data analysis, inventory tracking, gradebook creation]. ## Assignment Overview - **Learning objectives:** 1. [OBJECTIVE_1 — e.g., use SUM and AVERAGE functions] 2. [OBJECTIVE_2 — e.g., create a pivot table] 3. [OBJECTIVE_3 — e.g., build a chart from data] - **Skill level:** [LEVEL — e.g., beginner, intermediate] - **Estimated time:** [TIME — e.g., 45 minutes, 2 hours] - **Excel version:** [VERSION — e.g., Excel 2021, Microsoft 365, Google Sheets compatible] ## Assignment Structure ### Part 1: Setup Instructions - How to open/create the workbook - Sheet naming conventions - Data entry instructions for the provided dataset ### Part 2: Sample Dataset Provide a realistic sample dataset (15–20 rows) relevant to [TOPIC] that students will work with. Include column headers and data. ### Part 3: Tasks (Step-by-Step) For each task: 1. **Task name** 2. **Instructions** (clear, numbered steps) 3. **Excel functions/features used:** [FUNCTION — e.g., VLOOKUP, conditional formatting, SUMIF] 4. **Expected output** description ### Part 4: Stretch Challenge An optional advanced task for fast finishers. ### Part 5: Grading Rubric | Criteria | Points | Description | |---|---|---| | [Criteria 1] | [X] | [Description] | Write everything in full — ready to hand to a student or trainee.
📝 Fill in the blanks
Replace these placeholders with your own content:
[AUDIENCE — e.g., high school students, college students, new employees, data analysis trainees]
[TOPIC — e.g., budget management, sales data analysis, inventory tracking, gradebook creation]
[OBJECTIVE_1 — e.g., use SUM and AVERAGE functions]
[OBJECTIVE_2 — e.g., create a pivot table]
[OBJECTIVE_3 — e.g., build a chart from data]
[LEVEL — e.g., beginner, intermediate]
[TIME — e.g., 45 minutes, 2 hours]
[VERSION — e.g., Excel 2021, Microsoft 365, Google Sheets compatible]
[TOPIC]
[FUNCTION — e.g., VLOOKUP, conditional formatting, SUMIF]
[Criteria 1]
[X]
[Description]
How to use this prompt
1
Copy the prompt
Click "Copy Prompt" above to copy the full prompt text to your clipboard.
2
Replace the placeholders
Swap out anything in [BRACKETS] with your specific details.
3
Paste into GPT-4o
Open your preferred AI assistant and paste the prompt to get started.