BASIC COMPUTER COURSE REVISION (OVERVIEW)

1. WINDOWS

What is Windows?

Windows is an operating system developed by Microsoft. It manages the computer and allows users to
run programs.

Main Parts of Windows

 Desktop
 Start Menu
 Taskbar
 Icons
 Recycle Bin
 File Explorer
 This PC
 Control Panel
 Settings
 Notification Area
 Common Operations
 Open a program
 Close a program
 Minimize
 Maximize
 Restore

 Create Folder
 Rename Folder
 Copy
 Cut
 Paste
 Delete
 Undo
  Search files

Keyboard Shortcuts

 Ctrl + C → Copy
 Ctrl + V → Paste
 Ctrl + X → Cut
 Ctrl + Z → Undo
 Ctrl + y -- redo
 Ctrl + A → Select All
 Ctrl + S → Save
 Ctrl + P → Print
 Ctrl + N → New
 Ctrl + O → Open
 Alt + F4 → Close Window
 Windows + E → File Explorer
 Windows + D → Show Desktop

2. MICROSOFT WORD

What is MS Word?

MS Word is a word processing program used to create and edit documents.

Important Features ( meelaha ugu muhiimsan)

 Create a document
 Save
 Save As
 Open
 Print
 Font
 Font Size
 Font Color
 Bold
 Italic
 Underline
 Text Alignment
 Bullets
  Numbering
 Line Spacing
 Page Layout
 Margins
 Insert Picture
 Insert Table
 Insert Shapes
 Header & Footer
 Page Number
 Find & Replace
 Spell Check

Common File Extension

.docx

3. MICROSOFT EXCEL

What is MS Excel?

MS Excel is a spreadsheet program used for calculations and data analysis.

Important Terms ( erey-bixinada muhiimka ah )

 Workbook
 Worksheet
 Row
 Column
 Cell
 Active Cell
 Cell Address
 Formula Bar
 Name Box

Basic Formulas ( xisaabaadka )

=SUM()

=AVERAGE()
=MAX()

=MIN()

=COUNT()

Common Operations ( shaqooyinka caanka ah )

 Insert Row
 Insert Column
 Delete Row
 Merge Cells
 Format Cells
 Sort
 Filter
 AutoFill
 Charts

File Extension

.xlsx

4. MICROSOFT POWERPOINT

What is MS PowerPoint?

MS PowerPoint is presentation software.

Important Features ( meelaha ugu muhiimsan )

 Create Slides
 New Slide
 Slide Layout
 Themes
 Design
 Insert Picture
 Insert Video
  Insert Audio
 SmartArt
 Shapes
 Tables
 Charts
 Transitions
 Animations
 Slide Show
 Presenter View

File Extension

.pptx

5. MICROSOFT PUBLISHER

What is MS Publisher?

MS Publisher is desktop publishing software used for designing printed materials.

Used for Creating ( waxyaabaha aad naqshad ka diyaarin karto )

 Business Cards
 Flyers
 Brochures
 Posters
 Banners
 Certificates
 Calendars
 Invitations
 Newsletters

Important Features

 Templates
 Text Box
 Picture
  Shapes
 WordArt
 Page Design
 Color Scheme
 Print Preview

File Extension

.pub

6. MICROSOFT ACCESS

What is MS Access?

MS Access is a database management program.

Important Database Objects ( waxyaabaha ugu muhiimsan )

 Database
 Table
 Record
 Field
 Primary Key
 Query
 Form
 Report

Uses ( waxa loo isticmaalo)

Store data

Organize information

Search records

Generate reports

File Extension
.accdb

7. MICROSOFT OUTLOOK

What is MS Outlook?

MS Outlook is an email and personal information management program.

Main Features ( noocyada ugu waaweyn)

 Send Email
 Receive Email
 Reply
 Reply All
 Forward
 Attach Files
 Contacts
 Calenda
 Tasks
 Notes
 Signature
 Inbox
 Outbox
 Sent Items
 Drafts
 Deleted Items

Common Email Fields

 To
 Cc
 Bcc
 Subject
 Attachment
File Extension

.pst (Outlook Data File)

COMMON COMPUTER TERMS ( Erey-bixinada computer ka)

 Hardware
 Software
 Operating System
 CPU
 RAM
 Hard Disk (HDD)
 SSD
 Monitor
 Keyboard
 Mouse
 Printer
 Scanner
 USB Flash Drive
 Folder
 File
 Network
 Internet
 Browser
 Download
 Upload
 Login
 Logout
 Password

COMPUTER SAFETY ( Badbaadooyinka computer ka)

 Use a strong password.

FINAL REVISION QUESTIONS

1. What is Windows?

2. Name five parts of the Windows desktop.

3. What is the function of the Start Menu?

4. What is File Explorer used for?

5. What is MS Word used for?

6. Name five formatting tools in MS Word.

7. What is the file extension of a Word document?

8. What is MS Excel used for?

9. What is the difference between a row and a column?

10. Write five basic Excel formulas.

11. What is a cell address?

12. What is MS PowerPoint used for?

13. What is the difference between Transitions and Animations?

14. What is MS Publisher mainly used for?

15. Name five publications you can create in Publisher.

16. What is a database?

17. Name the four main objects in MS Access.

18. What is a primary key?

19. What is MS Outlook used for?

20. What is the difference between To, Cc, and Bcc?

21. What is the difference between hardware and software?

23. What is the difference between RAM and Hard Disk?

24. What is the purpose of antivirus software?

25. Write ten keyboard shortcuts and explain their functions.