K17: Principles of Productivity Software Applications Used to Create, Update, Edit, Manage, and Present Data and Information Including How to Support Stakeholders in Their Use
Assessment Method: Professional Discussion underpinned by a portfolio
Plain-English Explanation
K17 is about understanding how productivity software (like Microsoft Word, Excel, PowerPoint, and similar tools) works and how to use it effectively. It also means being able to help others use these tools confidently and correctly.
Examples of How Apprentices Demonstrate This at Work
Creating professional documents using Word templates
Using Excel formulas and macros to manage and analyze data
Designing a clear and engaging presentation in PowerPoint
Supporting a colleague by showing them how to use a feature (e.g., conditional formatting in Excel)
Automating repetitive tasks with Power Automate to improve productivity
Common Gaps and Misconceptions
Thinking productivity software is just for basic tasks—ignoring advanced features like macros or templates
Believing automation is too complex when simple tools like Power Automate can save time
Not considering accessibility when creating documents or presentations
Forgetting to explain steps clearly when supporting others
Links to Resources and Tools
Podcast: Boosting Productivity with Office Tools (Insert your podcast link here)
Why It Matters
Improves efficiency and accuracy in everyday tasks
Helps colleagues work more effectively
Reduces errors and saves time through automation
Portfolio Evidence Ideas
Screenshots of:
A macro-enabled Excel spreadsheet
A Power Automate flow for automating a repetitive task
A professional document or presentation you created
A short write-up explaining how you supported a stakeholder in using a productivity tool
EPA-Style Questions
How do you use productivity software to improve efficiency?
Can you give an example of when you helped someone use a digital tool?
Why are templates and automation important in productivity software?
Embedded Topics
Equality & Diversity: Ensuring documents and presentations are accessible to all users
Sustainability: Reducing paper use by creating and sharing digital documents
British Values: Promoting fairness and collaboration through shared digital tools