Desktop Publishing Applications Basic 5 Computer Studies Lesson Note

Learning Objectives: By the end of the lesson, pupils should be able to:

• Experiment with Microsoft Word
• Experiment with Microsoft Excel
• Experiment with Microsoft PowerPoint

What is Desktop Publishing?

Desktop Publishing is using computer software to create documents that combine text, images, and graphics for printing or digital sharing. It allows people to create professional-looking documents like newsletters, brochures, reports, and presentations.

MICROSOFT WORD

What is Microsoft Word? Microsoft Word is a word processing program used to create, edit, and format text documents like letters, reports, essays, and books.

Key Features of Microsoft Word:

1. Document Creation:

• New document – Start with blank page or template
• Templates – Pre-designed formats for letters, resumes, reports
• Page setup – Choose paper size, margins, orientation
• Multiple pages – Create documents with many pages

2. Text Formatting:

• Font changes – Different typefaces (Arial, Times New Roman)
• Font size – Make text bigger or smaller
• Bold, italic, underline – Emphasize important text
• Text color – Change color of words and sentences
• Alignment – Left, center, right, or justified text

3. Paragraph Formatting:

• Line spacing – Single, double, or custom spacing
• Indentation – Move text in from margins
• Bullet points – Create lists with dots or numbers
• Borders and shading – Add frames and background colors

4. Insert Features:

• Pictures – Add photos and images to documents
• Tables – Create organized rows and columns
• Shapes – Add circles, rectangles, arrows
• Headers and footers – Text that appears on every page
• Page numbers – Automatic numbering of pages

Basic Word Experiments:

1. Create a simple letter with proper formatting
2. Make a school report with headings and pictures
3. Design a poster using text, colors, and images
4. Create a table to organize information

MICROSOFT EXCEL

What is Microsoft Excel? Microsoft Excel is a spreadsheet program used to organize data in rows and columns, perform calculations, and create charts and graphs.

Key Features of Microsoft Excel:

1. Spreadsheet Structure:

• Cells – Individual boxes where data goes (A1, B2, C3)
• Rows – Horizontal lines numbered 1, 2, 3…
• Columns – Vertical lines labeled A, B, C…
• Worksheets – Individual spreadsheet pages
• Workbooks – Files containing multiple worksheets

2. Data Entry:

• Text – Names, labels, descriptions
• Numbers – Quantities, prices, scores
• Dates – Automatic date formatting
• Formulas – Calculations using =, +, -, *, /

3. Basic Calculations:

• Addition – =A1+B1 (adds values in cells A1 and B1)
• Subtraction – =A1-B1 (subtracts B1 from A1)
• Multiplication – =A1*B1 (multiplies A1 by B1)
• Division – =A1/B1 (divides A1 by B1)
• SUM function – =SUM(A1:A5) (adds all values from A1 to A5)

4. Formatting:

• Cell formatting – Change number formats, colors, borders
• Column width – Make columns wider or narrower
• Row height – Adjust height of rows
• Font formatting – Bold, italic, different fonts
• Cell alignment – Center, left, right alignment

5. Charts and Graphs:

• Column charts – Compare different categories
• Pie charts – Show parts of a whole
• Line graphs – Show changes over time
• Bar charts – Horizontal comparison charts

Basic Excel Experiments:

1. Create a class grade sheet with student names and scores
2. Make a family budget with income and expenses
3. Design a simple chart showing favorite foods survey
4. Calculate simple math problems using formulas

MICROSOFT POWERPOINT

What is Microsoft PowerPoint? Microsoft PowerPoint is a presentation program used to create slideshows with text, images, animations, and multimedia for sharing information with audiences.

Key Features of Microsoft PowerPoint:

1. Slide Creation:

• New presentations – Start with blank or template
• Slide layouts – Title slide, content slide, picture slide
• Multiple slides – Create presentations with many slides
• Slide themes – Pre-designed colors and fonts

2. Content Addition:

• Text boxes – Add titles, bullet points, paragraphs
• Images – Insert photos, clip art, online pictures
• Shapes – Add circles, arrows, callouts, diagrams
• SmartArt – Create professional diagrams and flowcharts

3. Design Elements:

• Background colors – Change slide backgrounds
• Fonts and colors – Consistent text formatting
• Layouts – Organized arrangement of content
• Themes – Coordinated design elements

4. Animation and Transitions:

• Slide transitions – How slides change (fade, slide, wipe)
• Animation effects – How content appears (fly in, bounce)
• Timing – Control when animations happen
• Sound effects – Add audio to transitions and animations

5. Presentation Features:

• Slide show mode – Full-screen presentation view
• Speaker notes – Hidden notes for presenter
• Slide sorter – See all slides at once
• Print options – Print slides, handouts, notes

6. Multimedia Integration:

• Audio files – Add music or sound effects
• Video files – Insert movie clips
• Hyperlinks – Connect to websites or other slides
• Interactive elements – Buttons and navigation

Basic PowerPoint Experiments:

1. Create “About Me” presentation – Personal introduction with photos
2. Make a school subject report – Educational presentation with text and images
3. Design a story presentation – Tell a story with pictures and animations
4. Create a “How to” guide – Step-by-step instructions with visuals

Common Features Across All Applications:

File Management:

• Save – Keep your work (Ctrl+S)
• Open – Access existing files
• New – Create new documents
• Print – Make paper copies
• Share – Send files to others

Editing Tools:

• Undo – Reverse last action (Ctrl+Z)
• Redo – Bring back undone action (Ctrl+Y)
• Copy – Duplicate content (Ctrl+C)
• Paste – Insert copied content (Ctrl+V)
• Cut – Move content (Ctrl+X)

Help Resources:

• Help menu – Built-in assistance
• Templates – Pre-made examples
• Online tutorials – Microsoft’s learning resources
• Practice files – Sample documents to experiment with