The City Montessori School and College
Pakki Mor Campus
"Skills for All"
Course Contents/ Lesson Plan
Course Title: Basic Computer
Course
Duration: One Month
Basic Computer Course
Trainer Name
Course Title Basic Computer Course
Course Objective The objective of this course is to equip participants with comprehensive
skills in Microsoft Word, PowerPoint, and Excel, enabling them to create,
format, and edit professional documents, design engaging presentations, and
perform effective data analysis and visualization. By mastering advanced
features, integrating these applications, and applying practical problem-
solving techniques, participants will enhance their productivity and
confidence in using Microsoft Office tools for a variety of professional and
academic purposes. Through hands-on exercises and real-world projects, the
course aims to foster both individual proficiency and collaborative
teamwork.
Learning Outcome By the end of this course, participants will be able to:
of the Course
• To understand the fundamentals of computer:
• To know what is Computer.
• To know what is Input and Output.
• To know what is Hardware.
• To know what is Software.
• To know how to Manage Files and Folders.
• To know how to File Transfer in Phone to Computer
• Create and Manage Documents in Microsoft Word:
• Develop professional-quality documents with advanced formatting,
styles, and templates.
• Efficiently use tables, images, and SmartArt to enhance document
presentation.
• Apply document automation tools such as mail merge and references
(e.g., table of contents, footnotes).
• Utilize Microsoft Excel for Data Analysis:
• Create and format spreadsheets to organize and manage data
effectively.
• Apply formulas and functions for calculations and data analysis.
• Design and customize charts and graphs to visually represent data.
• Implement data management techniques like sorting, filtering, and
validation to handle large datasets.
• Design Engaging Presentations in Microsoft PowerPoint:
• Create visually appealing presentations with well-structured slides
and layouts.
• Incorporate multimedia elements such as images, videos, and audio to
enhance presentations.
• Use animations and transitions to add professional polish and engage
the audience.
• Apply the slide master and layout features for consistent slide design
Basic Computer Course
throughout the presentation.
• Integrate Microsoft Office Applications:
Scheduled Module• Title
Seamlessly integrate Word, Excel, and PowerPoint to create cohesive
Learning Units
Week projects and presentations.
• Embed and link data between applications to maintain consistency
Week 1 Fundamentals of Day 1 Hour#1 Introduction to computer
and accuracy.
Computer
• Produce comprehensive reports and presentations that include textual
Introduction
analysis, and
information, dataHour#1 to input and output
visual elements.
• Demonstrate Hour#2
Day 3 Hour#1
Practical Introduction
Overview of
and Collaborative tothe
software
Skills: and hardware
Excel interface
Week 2 Microsoft Excel
problems using
Hour#2
• Solve real-world &2 Creating,
How to saving,
manage
Microsoft and
files and
Office opening
folders
tools in computer
through
Hour#3
practical exercises and [Link]
How to transfer file from mobile to computer
Week 1 Microsoft Word
• CollaborateDay 2 Hour#1
with Basic
Overview
peers on group cell operations
of theenhancing
projects, (entering
Word interface data,
teamwork and
communication skills. copying, and pasting)
Hour#1 Creating, saving, and opening documents
Practice
Hour#3 literacy,
• Improve overall computer increasing confidence in copying,
using
Hour#2 Basic text editing (typing, deleting,
Microsoft Office for variousand professional
pasting) and academic tasks.
Day 4 Hour#1 Number formats (currency, percentages,
Hour#3 Practice
&2 dates)
Day 3 Hour # Formatting
Cell font
stylesand styles,
themessizes,slide
andcustomizing and colors
Course
Week Execution
4 Total
Microsoft Duration
Power Pointof Course: one Months
Day 1 Hour#1 Choosing
Paragraph layouts
1 &2 Conditionalformatting
formatting (alignment, line spacing,
Plan Class Hours: 3 Hours per day&2 indentation)
Applying themes and variants
Theory: 20% Practical: 80%Hour # Practice
Using the slide master for consistent
Hour#
3 Using bullet points and numbering
formatting
3 Practice
Day 5 Hour
Hour#1# Practice
Arithmetic operations (addition, subtraction,
Day 4 Hour
3 # Margins, orientation, and paper size
&2 multiplication, division)
Day 2 1Hour#1
&2 Headers,
Adding footers,
and
Basic functions
and page
formatting textnumbers
(SUM, AVERAGE, boxesMIN, MAX)
No of Students --- Inserting and formatting tables
&2 Inserting
Relative andandabsolute
formatting cellimages,
referencesshapes, and
Hour # Practice
SmartArt
Hour#3 Practice
3 Using charts and tables in slides
Week 3 Microsoft Excel Hour#3 Sorting
Day 1 Hour#1 Practiceand filtering data
Day 5 Hour # Inserting and formatting
Data validation images lists
and drop-down
Day 3 1Hour#1
&2 Adding shapes and SmartArtslide transitions
Applying and customizing
Hour#2
&2 Usingtext
Adding
Using tables
and andandnamed
managing
boxes ranges for slide
animations
WordArt
Learning Place Classroom/Lab elements
Hour # Practice
Hour#3 Practice
Setting animation timings and triggers
3Hour#3
Practice
Week 2 Microsoft Word Applying different
1 Hour#1 Creating
Day 2 and modifying
types styles
of charts (column,
Day 4 Hour # Inserting and formatting audio and video
&2 Creating
line, pie) and using templates
1-2 Adding hyperlinks and action buttons
Table of contents
Customizing chartand document
elements (titles, legends,
Embedding YouTube videos and other online
navigation
data labels)
content
Hour#3
Hour#2 Practice
Hour # Using Sparklines
Practical exercises fortoquick
create data
and format a
Day 2 3Hour#1 visualization
Practical exercises
presentation, usingtotext,
create a formatted
images, and
&2 document, including text, tables, and images
animations
Hour # Practice
Day 5 Hour
3 # Plan the content and structure (e.g., a
Day 3 1-2
Hour#1 business proposal, to
Practical exercises a school
createproject)
and format
&2 Create the main document
spreadsheets, using formulas in and
Word, including
charts
Hour#3 text,
Reviewtables, and graphics
and Q&A
Create supporting spreadsheets in Excel,
Day 4 Hour # Review
Hour#3 Create aand
including dataQ&A
budget analysis
or dataand chartsspreadsheet
analysis
1-3 Link
with or embed
charts andExcel data intodata
summarized the Word
Week 3 Microsoft Power Point Day 5 Hour#1 documentOverview of the PowerPoint interface
&2 Creating, saving, and presentation
Create a PowerPoint opening presentations
Basic Computer Course Basic slide operations
summarizing the project (adding, deleting,
rearranging)
Hour # Review and feedback session
3Hour#3 Practice