AI & DIGITAL SKILLS MAGAZINE Learn from beginner to expert
Contact EDITION 2026
ISHRAQA7 — The practical digital learning magazine
ISHRAQA 7 ACADEMY · Productivity & Automation

Microsoft 365 & productivity: effective collaboration

Fictional case: a team organises an open day with documents, deadlines and meetings without using real accounts.

  • LevelBeginner → Intermediate
  • Course programme12 modules
  • Course filesPDF · CSV · TXT · ZIP

Also available in Français العربية

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

  1. Map documents, conversations and tasks
  2. assign a source-of-truth location
  3. 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

  1. Structure meeting notes with decision, owner and due date
  2. propose an edit on a mock document
  3. 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

  1. Import eight sample tasks
  2. count overdue tasks against a given date
  3. 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

  1. Turn meeting notes into five slides: problem, goal, plan, risks and decision
  2. limit text blocks
  3. 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

  1. Draft a fictional invitation with subject, agenda and timezone
  2. set response deadline
  3. 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

  1. Assign facilitator, note-taker and reviewer
  2. capture decisions in an action list
  3. 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

  1. Compare specific-people links versus broader sharing
  2. choose view or edit rights
  3. 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

  1. Design a document library with owners and naming rules
  2. distinguish personal from team documents
  3. 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

  1. Draft fictional feedback form without sensitive data
  2. define mandatory items and suitable consent
  3. 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

  1. Assign eight tasks by owner and due date
  2. separate blocked from complete
  3. 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

  1. Draft a summarisation request on fictional text
  2. verify dates, decisions and quotations against the source
  3. 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

  1. Combine Word minutes, Excel tracker, PowerPoint storyboard, Outlook invitation and sharing policy
  2. populate fictional data
  3. 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.

Check your knowledge

1. Organising work in Microsoft 365
1. Which deliverable validates the lesson 'Organising work in Microsoft 365'?
2. What is the first action in the 'Organising work in Microsoft 365' workshop?
3. Which action completes the 'Organising work in Microsoft 365' workshop?
2. Word: controlled co-authoring
1. Which deliverable validates the lesson 'Word: controlled co-authoring'?
2. What is the first action in the 'Word: controlled co-authoring' workshop?
3. Which action completes the 'Word: controlled co-authoring' workshop?
3. Excel: reliable tracking table
1. Which deliverable validates the lesson 'Excel: reliable tracking table'?
2. What is the first action in the 'Excel: reliable tracking table' workshop?
3. Which action completes the 'Excel: reliable tracking table' workshop?
4. PowerPoint: useful presentations
1. Which deliverable validates the lesson 'PowerPoint: useful presentations'?
2. What is the first action in the 'PowerPoint: useful presentations' workshop?
3. Which action completes the 'PowerPoint: useful presentations' workshop?
5. Outlook: email and calendar workflow
1. Which deliverable validates the lesson 'Outlook: email and calendar workflow'?
2. What is the first action in the 'Outlook: email and calendar workflow' workshop?
3. Which action completes the 'Outlook: email and calendar workflow' workshop?
6. Teams: meetings and decisions
1. Which deliverable validates the lesson 'Teams: meetings and decisions'?
2. What is the first action in the 'Teams: meetings and decisions' workshop?
3. Which action completes the 'Teams: meetings and decisions' workshop?
7. OneDrive: sharing and permissions
1. Which deliverable validates the lesson 'OneDrive: sharing and permissions'?
2. What is the first action in the 'OneDrive: sharing and permissions' workshop?
3. Which action completes the 'OneDrive: sharing and permissions' workshop?
8. SharePoint: team workspace
1. Which deliverable validates the lesson 'SharePoint: team workspace'?
2. What is the first action in the 'SharePoint: team workspace' workshop?
3. Which action completes the 'SharePoint: team workspace' workshop?
9. Forms: collecting quality responses
1. Which deliverable validates the lesson 'Forms: collecting quality responses'?
2. What is the first action in the 'Forms: collecting quality responses' workshop?
3. Which action completes the 'Forms: collecting quality responses' workshop?
10. Planner and task coordination
1. Which deliverable validates the lesson 'Planner and task coordination'?
2. What is the first action in the 'Planner and task coordination' workshop?
3. Which action completes the 'Planner and task coordination' workshop?
11. Copilot: assistance and verification
1. Which deliverable validates the lesson 'Copilot: assistance and verification'?
2. What is the first action in the 'Copilot: assistance and verification' workshop?
3. Which action completes the 'Copilot: assistance and verification' workshop?
12. Final project: coordinated workspace
1. Which deliverable validates the lesson 'Final project: coordinated workspace'?
2. What is the first action in the 'Final project: coordinated workspace' workshop?
3. Which action completes the 'Final project: coordinated workspace' workshop?

Course files

Choose a language, then the format you need.

العربية

FileFormatSizeDownload
مورد تدريبي — manuel-ar PDF 49 KB Download — مورد تدريبي — manuel-ar (PDF)
مورد تدريبي — exercices-ar PDF 36 KB Download — مورد تدريبي — exercices-ar (PDF)
مورد تدريبي — corriges-ar PDF 31 KB Download — مورد تدريبي — corriges-ar (PDF)
مورد تدريبي — projet-final-ar PDF 20 KB Download — مورد تدريبي — projet-final-ar (PDF)
مورد تدريبي — donnees-exercice-ar CSV 1 KB Download — مورد تدريبي — donnees-exercice-ar (CSV)
مورد تدريبي — sources-officielles-ar TXT 1 KB Download — مورد تدريبي — sources-officielles-ar (TXT)
مورد تدريبي — grille-controle-ar CSV 1 KB Download — مورد تدريبي — grille-controle-ar (CSV)
مورد تدريبي — kit-pratique-ar ZIP 2 KB Download — مورد تدريبي — kit-pratique-ar (ZIP)

Français

FileFormatSizeDownload
Ressource de formation — manuel-fr PDF 38 KB Download — Ressource de formation — manuel-fr (PDF)
Ressource de formation — exercices-fr PDF 26 KB Download — Ressource de formation — exercices-fr (PDF)
Ressource de formation — corriges-fr PDF 24 KB Download — Ressource de formation — corriges-fr (PDF)
Ressource de formation — projet-final-fr PDF 14 KB Download — Ressource de formation — projet-final-fr (PDF)
Ressource de formation — donnees-exercice-fr CSV 1 KB Download — Ressource de formation — donnees-exercice-fr (CSV)
Ressource de formation — sources-officielles-fr TXT 1 KB Download — Ressource de formation — sources-officielles-fr (TXT)
Ressource de formation — grille-controle-fr CSV 1 KB Download — Ressource de formation — grille-controle-fr (CSV)
Ressource de formation — kit-pratique-fr ZIP 2 KB Download — Ressource de formation — kit-pratique-fr (ZIP)

English

FileFormatSizeDownload
Training resource — manuel-en PDF 35 KB Download — Training resource — manuel-en (PDF)
Training resource — exercices-en PDF 25 KB Download — Training resource — exercices-en (PDF)
Training resource — corriges-en PDF 23 KB Download — Training resource — corriges-en (PDF)
Training resource — projet-final-en PDF 13 KB Download — Training resource — projet-final-en (PDF)
Training resource — donnees-exercice-en CSV 1 KB Download — Training resource — donnees-exercice-en (CSV)
Training resource — sources-officielles-en TXT 1 KB Download — Training resource — sources-officielles-en (TXT)
Training resource — grille-controle-en CSV 1 KB Download — Training resource — grille-controle-en (CSV)
Training resource — kit-pratique-en ZIP 2 KB Download — Training resource — kit-pratique-en (ZIP)