COURSE PLAN in Microsoft Advanced Productivity
Course Title Microsoft 365 - Advanced Course Code: MSFT365 - AP
Productivity
The objective of this course is to provide Deped Teachers and School Personnel with a comprehensive
understanding of Microsoft 365 and its various components. By the end of this course, Deped Teachers and School
Personnel will be able to navigate and use Microsoft 365 to create, share, and collaborate on various documents and
projects. Deped Teachers and School Personnel will also learn how to effectively use the different tools and
Course Description
applications within Microsoft 365, including OneDrive, Teams, Word, Excel, PowerPoint, and OneNote, to increase
productivity and efficiency in their personal and professional lives. Additionally, Deped Faculty and Staff will gain
an understanding of new ways of working and modern meetings through Microsoft 365, as well as best practices for
using the platform.
Course Intended Learning After completing this subject, Deped Teachers and School Personnel will be able to effectively use Microsoft 365 to
Outcomes (CILO) create and manage documents, collaborate with others, and enhance their productivity.
Specifically, DEPED TEACHERS AND SCHOOL PERSONNEL WILL BE ABLE TO:
1. Navigate and use the different applications and tools within Microsoft 365, including OneDrive, Teams,
Word, Excel, PowerPoint, and OneNote.
2. Effectively use Microsoft Teams to communicate, collaborate, and manage projects with their team.
3. Create and edit documents, spreadsheets, presentations, and other files using Microsoft 365.
4. Collaborate with others in real-time on documents and projects using Microsoft 365's collaboration features.
5. Organize and manage files and folders using OneDrive.
6. Understand best practices when using Microsoft 365.
7. Apply the skills learned in this course to increase their productivity and efficiency in their personal and
professional lives.
Module Module 1: Introduction to Microsoft 365
Overview of Microsoft 365's features and applications
Logging in to Microsoft 365
Navigating the Microsoft 365 interface
Module 2: Introduction to OneDrive
Overview of OneDrive
Organizing and managing files and folders
Sharing files and folders with colleagues
Module 3: Introduction to Microsoft Teams
Overview of Teams' features and tools
Communicating and collaborating with colleagues using Teams
Managing projects using Teams' project management tools
Module 4: Introduction to Microsoft Word
Creating and formatting documents
Inserting and formatting images and other media
Saving and sharing documents on OneDrive
Microsoft 365 Exclusive Features for Word
Module 5: Introduction to Microsoft Excel
Creating and formatting spreadsheets
Working with formulas and functions
Saving and sharing spreadsheets on OneDrive
Teacher-related Excel functions and formulas
Module 6: Introduction to PowerPoint
Creating and formatting presentations
Inserting and formatting images and other media
Saving and sharing presentations on OneDrive
Microsoft 365 Exclusive Features for PowerPoint:
Teacher-related PowerPoint features (Live Presentation and Recording Presentations)
Module 7: Introduction to OneNote
Introduction to OneNote
Overview of OneNote's features and benefits
Navigating the OneNote interface
Organizing and managing notebooks
Taking notes in OneNote
Inserting images, audio, and video
Using OneNote for research and collaboration
OneNote on different platforms
Module 8: Final Assessment
Review and wrap-up
Review of key concepts and skills learned throughout the course
Q&A session
Course evaluation and feedback
Module 1 : Introduction to Microsoft 365
Intended Learning Outcomes Suggested Teaching/Learning Assessment References
Hours Content Standards
(ILO) Activities Tasks
1 hr Overview of Microsoft Describe and be able to Lecture Knowledge [Link]
365's features and understand Microsoft 365 features Check
applications and application. Lecture & Demonstration
(8AM- Logging in to Microsoft Differentiate different applications Hands-on walkthrough with the trainer
9AM) 365 within Microsoft 365
Navigating the Microsoft
365 interface Be able to understand the process
of logging in to Microsoft 365
Be able to navigate the Microsoft
365 interfaces
Module 2: Introduction to OneDrive
Intended Learning Outcomes Assessment References
Hours Content Standards Suggested Teaching/Learning Activities
(ILO) Tasks
Overview of OneDrive Understand the benefits of using Lecture Knowledge
OneDrive for file storage and Check
Organizing and managing organization. Lecture & Demonstration
files and folders
Create and manage files and folders Hands-on walkthrough with the trainer
1 hr
Sharing files and folders with in OneDrive.
(9AM-
colleagues
10AM)
Share files and folders with others
using OneDrive's sharing features.
Collaborate on files in real-time with
others using OneDrive.
Apply the skills learned in this course
to increase their productivity and
efficiency in their personal and
professional lives.
Module 3: Introduction to Microsoft Teams
Intended Learning Outcomes Assessment References
Hours Content Standards Suggested Teaching/Learning Activities
(ILO) Tasks
1 hr Overview of Teams' features Navigate and use the different Lecture Knowledge
(10AM- and tools features and tools within Microsoft Check
11AM) Teams, including chat, meetings, and Lecture & Demonstration
Communicating and channels.
collaborating with colleagues Hands-on walkthrough with the trainer
using Teams Schedule and conduct meetings with
colleagues and clients using
Managing projects using Microsoft Teams.
Teams' project management
tools Collaborate with team members in
real-time on documents and projects
using Microsoft Teams' collaboration
features.
Organize and manage projects using
Microsoft Teams' project
management tools, such as Planner
and Lists.
Create Class Teams/Professional
Learning Community to manage
synchronous or asynchronous
sessions
Publish Reading Progress
assignments to develop learners'
reading fluency
Apply the skills learned in this course
to increase their productivity and
efficiency in their personal and
professional lives.
Module 4: Introduction to Microsoft Word
Intended Learning Assessment References
Hours Content Standards Suggested Teaching/Learning Activities
Outcomes (ILO) Tasks
1 hr Creating and formatting Navigate and use the Lecture Knowledge
(11AM- documents different features and tools Check
12NN) within Microsoft Word. Lecture & Demonstration
Inserting and formatting
images and other media Create and format Creating a formatting mock document
documents using styles,
Saving and sharing themes, and templates.
documents on OneDrive
Insert and format text,
Microsoft 365 Exclusive images, tables, and other
Features: media in documents.
- Dictate
- Editor Use formatting tools such
- Researcher as font size, color, and style
to enhance document
appearance.
Edit and proofread
documents using spelling
and grammar check tools.
Save and share documents
on OneDrive.
Get familiarized with
Microsoft 365 exclusive
features for Word
Apply the skills learned in
this course to increase their
productivity and efficiency
in their personal and
professional lives.
Module 5: Introduction to Microsoft Excel
Intended Learning Outcomes Assessment References
Hours Content Standards Suggested Teaching/Learning Activities
(ILO) Tasks
Creating and formatting Navigate and use the different Lecture Knowledge
spreadsheets features and tools within Microsoft Check
Excel. Lecture & Demonstration
Working with formulas and
functions Create and format spreadsheets using Working on a practice file
formulas, functions, and formatting
Saving and sharing tools.
spreadsheets on OneDrive Insert and format text, numbers,
dates, and other data in spreadsheets.
Teacher-related Excel
1 hr functions and formulas Use Excel's data analysis tools,
(1PM- including sorting, filtering, and pivot
2PM) tables.
Understand and apply basic statistical
and mathematical functions in Excel.
Create charts and graphs to visually
represent data.
Save and share spreadsheets on
OneDrive.
Apply the skills learned in this course
to increase their productivity and
efficiency in their personal and
professional lives.
Module 6: Introduction to Microsoft PowerPoint
Intended Learning Outcomes Assessment References
Hours Content Standards Suggested Teaching/Learning Activities
(ILO) Tasks
Creating and formatting Navigate and use the different Lecture Knowledge
presentations features and tools within Microsoft Check
PowerPoint. Lecture & Demonstration
Inserting and formatting
images and other media Insert and format text, images, Creating their own presentations
videos, and other media in slides.
Saving and sharing
1 hr presentations on OneDrive Use slide transitions and animations
(2PM- to enhance the presentation.
3PM) Microsoft 365 Exclusive
Features for PowerPoint: Use presenter view and other delivery
- Designer options to effectively present the
- Morph slides.
- Zoom
Save and share presentations on
- 3D Models
OneDrive.
Teacher-related PowerPoint
features (Live Presentation Apply the skills learned in this course
and Recording Presentations) to increase their productivity and
efficiency in their personal and
professional lives.
Module 7: Introduction to OneNote
Intended Learning Outcomes Assessment References
Hours Content Standards Suggested Teaching/Learning Activities
(ILO) Tasks
1 hr Introduction to OneNote Navigate and use the different Lecture Knowledge
(3PM- features and tools within Microsoft Check
4PM) Overview of OneNote's OneNote. Lecture & Demonstration
features and benefits Create and manage notebooks,
Navigating the OneNote sections, and pages within OneNote. Hands-on walkthrough with the trainer
interface
Insert and format text, images, audio,
Organizing and managing and video into OneNote.
notebooks
Use OneNote for research and
Taking notes in OneNote collaboration, including capturing
webpages and sharing notes with
Inserting images, audio, and others.
video
Understand and apply best practices
Using OneNote for research OneNote.
and collaboration
Use OneNote across multiple
OneNote on different platforms, including desktop, web,
platforms and mobile devices.
Apply the skills learned in this course
to increase their productivity and
efficiency in their personal and
professional lives.
Module 8: Final Assessment
Intended Learning Outcomes Assessment References
Hours Content Standards Suggested Teaching/Learning Activities
(ILO) Tasks
0.5 hr Review and wrap-up Summarize the topics discussed in the Lecture Short Quiz-
(4PM- session like game
4:30PM) Review of key concepts and Assessment Check
skills learned throughout the
course. Q&A session
Feedback and evaluation gathering
Recommendations
Module 1: Introduction to Microsoft 365
Overview of Microsoft 365's features and applications (include Bookings, Sway, Stream, Planner, Whiteboard, Delve…)
Logging in to Microsoft 365 (include account activation and reset)
Navigating the Microsoft 365 interface (desktop, mobile, and web)
Module 2: Introduction to OneDrive
Overview of OneDrive
Organizing and managing files and folders
Sharing files and folders with colleagues
Desktop Folder Sync, Free up Sync Space
Creating a File Request
Module 3: Introduction to Microsoft Teams
Overview of Teams' features and tools
Communicating and collaborating with colleagues using Teams (include Shared Channels, guests/external, and switching
tenants)
Managing projects using Teams' project management tools
Teams for Edu Types: Class, Professional Learning Community, Staff, Other
Teams Classroom, Assignment, Grades, Insights
Teams Meetings, Meeting Apps, Recordings
Teams Webinar, Teams Live Event
Teams Reading Progress
Module 4: Introduction to Microsoft Word
Creating and formatting documents
Inserting and formatting images and other media
Saving and sharing documents on OneDrive
Microsoft 365 Exclusive Features for Word
Document Templates
Sensitivity Tagging
Editor
Version Control, Co-Authoring, Reviews
Mail Merge
Module 5: Introduction to Microsoft Excel
Creating and formatting spreadsheets
Working with formulas and functions
Saving and sharing spreadsheets on OneDrive
Teacher-related Excel functions and formulas
Converting/Connecting CSV, PDF, Web tables
Pivot tables, Data Tools (Flash fill, validation, duplicates, what if analysis)
Microsoft Forms – internal, public, embedding, quizzes, co-authoring
Module 6: Introduction to PowerPoint
Creating and formatting presentations
Inserting and formatting images and other media
Saving and sharing presentations on OneDrive
Microsoft 365 Exclusive Features for PowerPoint:
Teacher-related PowerPoint features (Live Presentation and Recording Presentations)
Designer, Embedding Live Tables, Embedding Apps, Presentation Coach
Cameo, 3D, Templates, Slide Master, Subtitles, Re-Use Slides
Module 7: Introduction to OneNote
Introduction to OneNote
Overview of OneNote's features and benefits
Navigating the OneNote interface
Organizing and managing notebooks
Taking notes in OneNote
Inserting images, audio, and video
Using OneNote for research and collaboration
OneNote on different platforms
OneNote Class Notebook
Module 8: Final Assessment
Review and wrap-up
Review of key concepts and skills learned throughout the course
Q&A session
Course evaluation and feedback
