Posts

Showing posts from January, 2026

MS Excel – Spreadsheet Software

Image
                          📕 CHAPTER 5                                 MS OFFICE SUITE          (MS WORD – MS EXCEL – MS POWERPOINT)          DEEP PRACTICAL ORIENTATION FOR KPSC 5.1 Introduction to MS Office MS Office is a bundle of application software developed by Microsoft, widely used in government and private offices. Common MS Office Applications: MS Word MS Excel MS PowerPoint MS Access 5.2 MS Word – Word Processing Software MS Word is used to create, edit, format, and print documents. Uses: Letters Reports Government notices Office files 5.3 Features of MS Word Text formatting Spell check Grammar check Mail merge Tables & images 5.4 Formatting in MS Word Font Formatting Bold Italic Underline Font size Font color Paragraph Formatting Alignment Line spacing Indentation 5.5 Page Setup O...

COMPUTER SOFTWARE

Image
  CHAPTER 4 COMPUTER SOFTWARE (STARTED – WILL CONTINUE AUTOMATICALLY) 4.1 Introduction to Computer Software Computer software is a set of programs and instructions that tells the computer what to do and how to do it. Hardware without software is useless. 📌 Exam definition: Software is the logical component of a computer system. 4.2 Types of Software Software is broadly classified into: System Software Application Software 4.3 System Software System software controls the overall functioning of computer hardware. Examples: Operating System Device Drivers Utility Programs 4.4 Operating System (Overview) Operating System acts as an interface between user and hardware. Functions: Process management Memory management File management Device management 4.5 Types of Operating Systems Single-user OS Multi-user OS Batch OS Real-time OS 4.6 Examples of Operating Systems MS Windows Linux UNIX Android 📌 Linux is open-source 4.7 Application Software Application software is designed for specific...

COMPUTER HARDWARE

Image
  📕 CHAPTER 3 COMPUTER HARDWARE (KPSC Group-C Non-Technical – HIGH WEIGHTAGE CHAPTER) 3.1 Introduction to Computer Hardware Computer hardware refers to the physical and tangible components of a computer system that can be seen and touched. Hardware forms the backbone of any computer system, without which software cannot function. In KPSC examinations, hardware questions are: Direct Device-based Frequently repeated 3.2 Classification of Computer Hardware Computer hardware is broadly classified into: Input Devices Output Devices Processing Devices Storage Devices Peripheral Devices 3.3 Input Devices Input devices are used to enter data and instructions into the computer. 3.3.1 Keyboard Most commonly used input device Contains alphanumeric keys, function keys, control keys Types of keys: Alphabet keys (A–Z) Numeric keys (0–9) Function keys (F1–F12) Special keys (Enter, Shift, Ctrl, Alt) 📌 KPSC fact: F1 key = Help 3.3.2 Mouse Pointing device Used to select, drag, scroll Types: Mechan...

HISTORY & GENERATIONS OF COMPUTERS

Image
  📕 CHAPTER 2 HISTORY & GENERATIONS OF COMPUTERS (KPSC Group-C Non-Technical – Core Scoring Chapter) 2.1 Introduction to Computer History The history of computers is the story of human effort to reduce manual work, increase speed, and improve accuracy. From simple counting devices to modern supercomputers, computer evolution passed through mechanical, electro-mechanical, and electronic stages. For KPSC exams, this chapter is high-yield because: Questions are direct Generations are frequently repeated Matching & chronology questions are common 2.2 Early Calculating Devices (Pre-Computer Era) 2.2.1 Abacus Invented around 3000 BC Used in China, Egypt, Mesopotamia First manual calculating device Used beads and rods 📌 Exam point: Abacus is NOT an electronic device 2.2.2 Napier’s Bones (1617) Invented by John Napier Used for multiplication and division Based on logarithms 2.2.3 Slide Rule (1622) Invented by William Oughtred Used logarithmic scales Used by engineers before elect...