From computer basics to advanced Word and Excel skills

This course introduces students to the fundamentals of computing while building practical skills in Microsoft Word and Excel. Participants will learn how computers function, how to manage files and folders, and how to effectively use word processing and spreadsheet applications for personal, academic, and professional tasks. Through hands-on practice, students progress from basic to advanced skills, including document formatting, mail merge, spreadsheet formulas, and data analysis tools. By the end of the course, students will be able to apply computing concepts confidently in real-world situations.

Students will:

• Understand the fundamentals of computing, including hardware, software, storage, files, and folders.
• Create, edit, format, and manage documents in Microsoft Word, using tools such as tables, headers, footers, page layouts, and advanced features like mail merge and SmartArt.
• Develop spreadsheet skills in Microsoft Excel, from basic formulas and formatting to advanced concepts like graphs, charts, filtering, and conditional logic (IF statements).
• Gain an introduction to networking, the internet, and the applications of IT in everyday life.
• Build practical computer skills that support academic success, workplace efficiency, and personal productivity.

PART 1

THEORY

1. Fundamentals of Computing

• Definitionandfunctionofa computer
• TypesofComputers
• InputandInputDevices
• OutputandOutputdevices
• StorageandStoragedevices
• Definitionoffiles,foldersand drives
• FileandFolderCreationandFile Management

2. WORD PROCESSING Using Microsoft Word

Microsoft Word Basics

• UsefulWordProcessing terminologies
• Partsofthe Word Window
• Opening,savingandclosinga document
• Formatting(fontandparagraph) and Editing a document
• Headersand Footers
• Pagenumbering
• ParagraphandPage breaks
• Tables (creation, inserting and deletingrowsandcolumns,sorting, merging cells)
• Pagelayout(Settingmargins,page size and orientation)
• Tabbing(Settingtabstops)
• Columns (Breaking a paragraph in desiredamountofcolumnsandline between)
• Bulletsand numbering

3. SPREADSHEET using Microsoft Excel

MicrosoftExcel basics

• UsefulSpreadsheetterminologies
• PartsoftheMicrosoftExcelWindow
• NavigatingtheSpreadsheet
• Populatinga Spreadsheet
• SimpleSpreadsheetformulas (Addition, Subtraction, Multiplication and Division)
• Formatting Cells
• WideningColumnsandRows
• Merging cells
• Insertinganddeletingrowsand columns
• Functions(Sum,Max,Min, Average)

PART 2

1. THEORY

INDEPTH CONCEPTS

• Categoriesofstorage devices
• Categoriesofinputdevices
• Categoriesofoutput devices
• FundamentalsofNetworkingand the Internet
• DataStorageandrepresentation basics
• ApplicationsandImplicationsofIT in everyday life

2. WORD PROCESSING using Microsoft Word

AdvanceWordProcessingConcepts:

• SuperscriptandSubscript
• Footnotesand Endnotes
• Findand Replace
• Format painter
• Embeddingshapes,Smartartand images in documents
• InsertingTextboxesandWordArt
• Tables (Inserting Formulas, text direction,Splitcellsandtable,Table Styles)
• Managing Columns (Inserting column and continuous breaks, Increasingdecreasingcolumnwidth, left and right columns)
• Tab(Tabalignment, leaders)
• Mail Merge
• Addinganddeletingcomments

3. SPREADSHEET Using Microsoft Excel

AdvanceSpreadsheet concepts

• TextDirection
• Alignment(Top,middle, bottom)
• Headersand Footers
• FreezeandUnfreezeColumnsand Rows
• Absoluteandrelativeaddressing
• Creatinggraphsand charts
• SimpleandCustom Sorting
• SimpleandAdvanceFiltering
• Ifstatements