01. Organising work in Microsoft 365
Practical objective
Working plan and storage rules.
Scenario
Fictional case: a team organises an open day with documents, deadlines and meetings without using real accounts.
Key concept
Map documents, conversations and tasks. assign a source-of-truth location.
Guided workshop
- Map documents, conversations and tasks
- assign a source-of-truth location
- prevent unmanaged local copies
Independent exercise
Using the supplied dataset, repeat with one additional record and log what changes. The deliverable must not trigger any external action.
Solution and evidence
Expected output : Working plan and storage rules. Acceptance check: two people should be able to locate the deliverable and understand the decision without an oral explanation.
Caution : Simulated workshop, not tested in a live software account. Recheck available commands and plan restrictions in your environment.
02. Word: controlled co-authoring
Practical objective
Meeting notes and change log.
Scenario
Fictional case: a team organises an open day with documents, deadlines and meetings without using real accounts.
Key concept
Structure meeting notes with decision, owner and due date. propose an edit on a mock document.
Guided workshop
- Structure meeting notes with decision, owner and due date
- propose an edit on a mock document
- distinguish comment, review and approve
Independent exercise
Using the supplied dataset, repeat with one additional record and log what changes. The deliverable must not trigger any external action.
Solution and evidence
Expected output : Meeting notes and change log. Acceptance check: two people should be able to locate the deliverable and understand the decision without an oral explanation.
Caution : Simulated workshop, not tested in a live software account. Recheck available commands and plan restrictions in your environment.
03. Excel: reliable tracking table
Practical objective
Tracking table with checkable calculation.
Scenario
Fictional case: a team organises an open day with documents, deadlines and meetings without using real accounts.
Key concept
Import eight sample tasks. count overdue tasks against a given date.
Guided workshop
- Import eight sample tasks
- count overdue tasks against a given date
- check blanks and duplicates before summary
Independent exercise
Using the supplied dataset, repeat with one additional record and log what changes. The deliverable must not trigger any external action.
Solution and evidence
Expected output : Tracking table with checkable calculation. Acceptance check: two people should be able to locate the deliverable and understand the decision without an oral explanation.
Caution : Simulated workshop, not tested in a live software account. Recheck available commands and plan restrictions in your environment.
04. PowerPoint: useful presentations
Practical objective
Five-slide storyboard with key message.
Scenario
Fictional case: a team organises an open day with documents, deadlines and meetings without using real accounts.
Key concept
Turn meeting notes into five slides: problem, goal, plan, risks and decision. limit text blocks.
Guided workshop
- Turn meeting notes into five slides: problem, goal, plan, risks and decision
- limit text blocks
- test projection legibility
Independent exercise
Using the supplied dataset, repeat with one additional record and log what changes. The deliverable must not trigger any external action.
Solution and evidence
Expected output : Five-slide storyboard with key message. Acceptance check: two people should be able to locate the deliverable and understand the decision without an oral explanation.
Caution : Simulated workshop, not tested in a live software account. Recheck available commands and plan restrictions in your environment.
05. Outlook: email and calendar workflow
Practical objective
Reviewed invitation draft.
Scenario
Fictional case: a team organises an open day with documents, deadlines and meetings without using real accounts.
Key concept
Draft a fictional invitation with subject, agenda and timezone. set response deadline.
Guided workshop
- Draft a fictional invitation with subject, agenda and timezone
- set response deadline
- never send a real email in the exercise
Independent exercise
Using the supplied dataset, repeat with one additional record and log what changes. The deliverable must not trigger any external action.
Solution and evidence
Expected output : Reviewed invitation draft. Acceptance check: two people should be able to locate the deliverable and understand the decision without an oral explanation.
Caution : Simulated workshop, not tested in a live software account. Recheck available commands and plan restrictions in your environment.
06. Teams: meetings and decisions
Practical objective
Agenda and action log.
Scenario
Fictional case: a team organises an open day with documents, deadlines and meetings without using real accounts.
Key concept
Assign facilitator, note-taker and reviewer. capture decisions in an action list.
Guided workshop
- Assign facilitator, note-taker and reviewer
- capture decisions in an action list
- separate discussion from approved decision
Independent exercise
Using the supplied dataset, repeat with one additional record and log what changes. The deliverable must not trigger any external action.
Solution and evidence
Expected output : Agenda and action log. Acceptance check: two people should be able to locate the deliverable and understand the decision without an oral explanation.
Caution : Simulated workshop, not tested in a live software account. Recheck available commands and plan restrictions in your environment.
07. OneDrive: sharing and permissions
Practical objective
File-by-recipient sharing matrix.
Scenario
Fictional case: a team organises an open day with documents, deadlines and meetings without using real accounts.
Key concept
Compare specific-people links versus broader sharing. choose view or edit rights.
Guided workshop
- Compare specific-people links versus broader sharing
- choose view or edit rights
- examine risks of a forwarded link
Independent exercise
Using the supplied dataset, repeat with one additional record and log what changes. The deliverable must not trigger any external action.
Solution and evidence
Expected output : File-by-recipient sharing matrix. Acceptance check: two people should be able to locate the deliverable and understand the decision without an oral explanation.
Caution : Simulated workshop, not tested in a live software account. Recheck available commands and plan restrictions in your environment.
08. SharePoint: team workspace
Practical objective
Folder structure and document policy.
Scenario
Fictional case: a team organises an open day with documents, deadlines and meetings without using real accounts.
Key concept
Design a document library with owners and naming rules. distinguish personal from team documents.
Guided workshop
- Design a document library with owners and naming rules
- distinguish personal from team documents
- plan access review
Independent exercise
Using the supplied dataset, repeat with one additional record and log what changes. The deliverable must not trigger any external action.
Solution and evidence
Expected output : Folder structure and document policy. Acceptance check: two people should be able to locate the deliverable and understand the decision without an oral explanation.
Caution : Simulated workshop, not tested in a live software account. Recheck available commands and plan restrictions in your environment.
09. Forms: collecting quality responses
Practical objective
Questionnaire and six-row dataset.
Scenario
Fictional case: a team organises an open day with documents, deadlines and meetings without using real accounts.
Key concept
Draft fictional feedback form without sensitive data. define mandatory items and suitable consent.
Guided workshop
- Draft fictional feedback form without sensitive data
- define mandatory items and suitable consent
- prepare six sample responses
Independent exercise
Using the supplied dataset, repeat with one additional record and log what changes. The deliverable must not trigger any external action.
Solution and evidence
Expected output : Questionnaire and six-row dataset. Acceptance check: two people should be able to locate the deliverable and understand the decision without an oral explanation.
Caution : Simulated workshop, not tested in a live software account. Recheck available commands and plan restrictions in your environment.
10. Planner and task coordination
Practical objective
Task view with dependencies.
Scenario
Fictional case: a team organises an open day with documents, deadlines and meetings without using real accounts.
Key concept
Assign eight tasks by owner and due date. separate blocked from complete.
Guided workshop
- Assign eight tasks by owner and due date
- separate blocked from complete
- document one dependency
Independent exercise
Using the supplied dataset, repeat with one additional record and log what changes. The deliverable must not trigger any external action.
Solution and evidence
Expected output : Task view with dependencies. Acceptance check: two people should be able to locate the deliverable and understand the decision without an oral explanation.
Caution : Simulated workshop, not tested in a live software account. Recheck available commands and plan restrictions in your environment.
11. Copilot: assistance and verification
Practical objective
Simulated-summary verification rubric.
Scenario
Fictional case: a team organises an open day with documents, deadlines and meetings without using real accounts.
Key concept
Draft a summarisation request on fictional text. verify dates, decisions and quotations against the source.
Guided workshop
- Draft a summarisation request on fictional text
- verify dates, decisions and quotations against the source
- note licensing and untested features
Independent exercise
Using the supplied dataset, repeat with one additional record and log what changes. The deliverable must not trigger any external action.
Solution and evidence
Expected output : Simulated-summary verification rubric. Acceptance check: two people should be able to locate the deliverable and understand the decision without an oral explanation.
Caution : Simulated workshop, not tested in a live software account. Recheck available commands and plan restrictions in your environment.
12. Final project: coordinated workspace
Practical objective
Five consistent deliverables without real sending.
Scenario
Fictional case: a team organises an open day with documents, deadlines and meetings without using real accounts.
Key concept
Combine Word minutes, Excel tracker, PowerPoint storyboard, Outlook invitation and sharing policy. populate fictional data.
Guided workshop
- Combine Word minutes, Excel tracker, PowerPoint storyboard, Outlook invitation and sharing policy
- populate fictional data
- cross-check consistency across all five
Independent exercise
Using the supplied dataset, repeat with one additional record and log what changes. The deliverable must not trigger any external action.
Solution and evidence
Expected output : Five consistent deliverables without real sending. Acceptance check: two people should be able to locate the deliverable and understand the decision without an oral explanation.
Caution : Simulated workshop, not tested in a live software account. Recheck available commands and plan restrictions in your environment.
