1
VBA
Automate the workbook routine
Sketch a procedure that targets explicit sheets, finds the last row, processes records and writes a Summary output.
PROOF TO PRODUCEInclude a clean error path and identify every write operation.
⚙️ CROSS-ACADEMY CAPSTONE · 650 XP
Office Automation Pack
Design a practical monthly-report workflow using VBA for Excel work, Python for data transformation and Prompting for the executive narrative.
VBAPythonPrompting
WHAT TO FINISH FIRST
PROJECT RUNBOOK
Four stages. Four visible artifacts.
Use your own editor/notebook/tools. LearnCode gives the brief and records your self-check; it does not pretend to inspect files it cannot see.
2
PYTHON
Transform exported data
Write a small transformation that normalises records or calculates a reusable monthly metric.
PROOF TO PRODUCEShow a before/after record and explain the transformation.
3
PROMPTING
Create the reporting prompt
Design a prompt that turns verified report facts into an executive summary without inventing causes.
PROOF TO PRODUCESeparate evidence, inference and missing explanation.
4
OPERATIONS
Define the human review gate
List the checks a person must complete before the report is considered ready to distribute.
PROOF TO PRODUCEInclude data completeness, totals/reconciliation and output review.
FINAL SELF-REVIEW
What did you learn from combining the skills?
Write at least ~100 characters about the hardest tradeoff, one mistake you caught, and what you would improve next. This is a reflection gate, not automated grading.
0/4 artifacts self-checked · 0/100 reflection characters
Complete the required starter academies before self-checking or claiming capstone completion.