PART 01 Computer Architecture

Chapter 01 How Computers Work
Lesson 01 The Evolution of Computers
Lesson 02 Boolean Algebra
Lesson 03 Simplifying Logical Expressions
Lesson 04 Logic Circuits
Lesson 05 Combinational Logic Circuits
Lesson 06 Sequential Logic Circuits

Chapter 02 Representation of Data
Lesson 07: Organizing Data / Transitioning the Number
Lesson 08 Fixed-Point Numbers
Lesson 09 Floating Point Numbers
Lesson 10 Text Material
Lesson 11 Types of Operations

Chapter 03 Central Processing Unit
Lesson 12 Components of a Computer System
Lesson 13 Control and Computing Units
Lesson 14 Commands
Lesson 15 Addressing Methods
Lesson 16 Command Execution and Control
Lesson 17 Micro Operations

Chapter 04 Memory Device
Lesson 18: The Concept of Memory
Lesson 19 Special Memory Devices
Lesson 20 Auxiliary Memory Devices

Chapter 05 Input/Output Devices
Lesson 21 DMA and Channels
Lesson 22 Interrupts
Lesson 23 Input/Output Interfaces

Chapter 06 Parallel Processing
Lesson 24 Parallel Computer Architecture

PART 02 Operating System

Chapter 01 Operating System Concept
Lesson 25: Operating System Concepts
Lesson 26 Types of OS, Input/Output Methods, and Virtual Machines

Chapter 02 Process Management
Lesson 27 Processes and Threads
Lesson 28 Process Scheduling
Lesson 29 Interprocess Synchronization
Lesson 30 Deadlock

Chapter 03 Memory Management
Lesson 31: Memory Allocation Techniques and Management Policies
Lesson 32: Implementing Virtual Memory
Lesson 33 Page Replacement Technique

Chapter 04 File Management
Lesson 34 File Management System

Chapter 05 Unix
Lesson 35 Unix

PART 03 Database

Chapter 01 Database System
Lesson 36 Databases and DBMS
Lesson 37: Configuring a Database System

Chapter 02 Data Modeling
Lesson 38 Data Model

Chapter 03 Relational Data Model
Lesson 39 Relational Data Structures
Lesson 40: Relational Data Operations

Chapter 04 Relational Database Language
Lesson 41: SQL Concepts, SQL Definition Language
Lesson 42 SQL Manipulators
Lesson 43 View

Chapter 05 Normalization
Lesson 44 Normalization

Chapter 06 Advanced Database
Lesson 45 Transactions / Failure and Recovery / Concurrency Control
Lesson 46 Distributed Databases

PART 04 Software Engineering

Chapter 01 Software Engineering Concepts
Lesson 47 Software Life Cycle 1
Lesson 48: Software Life Cycle 2

Chapter 02 Project Management
Lesson 49: Cost, Schedule, and Risk Analysis

Chapter 03 Quality Assurance and Configuration Management
Lesson 50 Quality Assurance / Configuration Management

Chapter 04 Requirements Analysis and Design
Lesson 51: Requirements Analysis
Lesson 52 Software Design

Chapter 05 Object-Oriented Paradigm
Lesson 53 Object-Oriented Concepts
Lesson 54 UML / Design Pattern

Chapter 06 Test
Lesson 55 Testing Techniques
Lesson 56: Testing Strategies

Chapter 07 Maintenance and Reengineering
Lesson 57 Maintenance / Reengineering / CASE

PART 05 DATA COMMUNICATION

Chapter 01 Concept of Data Communication
Lesson 58 Transmission Format

Chapter 02 Transmission Control Method
Lesson 59 Transmission Methods

Chapter 03 OSI Reference Model
Lesson 60 OSI 7 Layers

Chapter 04 Data Circuit Network
Lesson 61 Exchange Method
Lesson 62 LAN

Chapter 05 Multimedia
Lesson 63: The Concept of Multimedia

PART 06 Internet

Chapter 01 Internet in General
Lesson 64 TCP/IP Protocol
Lesson 65 IPv4
Lesson 66 IPv6

Chapter 02 Internet Services
Lesson 67 Internet Access Services
Lesson 68: New IT Technology Terminology

Chapter 03 Web Interface
Lesson 69 Web Services and Scripts

Chapter 04 Network Security
Lesson 70 Internet Security
Lesson 71 Security Technologies

PART 07 Excel

Chapter 01 Excel
Lesson 72 Formulas and Functions

Ⅰ.
West Gate
This textbook contains the largest number of questions among all published exam books, as it includes previously unpublished exam questions.
In particular, we have categorized the past exam questions according to the table of contents of the Gian Edu theory book so that test takers can efficiently understand the past exam questions in a shorter period of time.
Therefore, it is an optimized textbook that allows you to study the contents of the theory book while simultaneously checking past exam questions.

The process of gathering and refining the information you need and turning it into your own knowledge is a huge, difficult, and confusing task for all test-takers.
Accordingly, the author thoroughly analyzed and categorized past exam questions to minimize trial and error for many test takers during their exam preparation. Based on the know-how and high-quality materials accumulated through many years of academy lectures, the author decided to write this book, which is different from existing study materials.

Ⅱ.
Features of this textbook
In-depth analysis of the latest exam questions and trends
Among the seven general computer sections, recent exam questions have been mostly related to computer architecture, operating systems, and software engineering. To help test takers grasp this trend at a glance, we have thoroughly analyzed the frequency of questions by year and topic and included them.

Detailed classification of past exam questions by unit
We have thoroughly analyzed the most recent national, Seoul Metropolitan Government, local government, education office, military, police, national assembly, and accounting exam questions (2010-2025) and included them categorized by each part and chapter.
Therefore, we have made it possible for test takers to organize the vast amount of past exam questions more efficiently.

Detailed explanation and related theory
This textbook was originally designed to be optimized for video lectures, but it also includes detailed explanations of past exam questions, ensuring that you can study on your own without any difficulties.

Past exam questions with the same table of contents as the theory book
For test takers who want to delve deeper into related theories while solving past exam questions, we have edited the table of contents to be identical to the Gian Edu theory book, maximizing user convenience.
Additionally, a checkbox has been added to the top of the problem to check your understanding, allowing you to revisit difficult problems.

Ⅲ.
Recent exam trends
The scope of past exam questions continues to expand.

The scope of questions continues to expand in proportion to the popularity and competition rate of civil service exams.
Until 2015, questions on computer architecture and operating systems were mainly asked, but recently, questions from various fields have begun to appear, and in particular, the frequency of questions on databases, data communications, and the Internet is gradually increasing.

Questions that require understanding of concepts rather than simple memorization are often asked.
If we analyze recent exam questions, we can see that new technology trends and questions that mix theory and practice are occasionally asked, and in particular, database and internet questions are given a lot of weight, and new concept questions that reflect recent IT trends (big data, artificial intelligence, blockchain, etc.) are frequently appearing.
Therefore, it is necessary to carefully organize the terms at issue, and study with a focus on a broader understanding of concepts rather than simply memorizing the content.

Ⅳ.
Book Structure and Use
? It is composed of a total of 7 parts (Part 1 - Computer Architecture, Part 2 - Operating System, Part 3 - Database, Part 4 - Software Engineering), Part 5 - Data Communication, Part 6 - Internet, Part 7 - Excel) in the same structure as the theory book.

First, refer to the question frequency table to understand the question trend for each year and topic.
At this time, in addition to understanding the exam trends, we organize the key theories for each unit based on existing theory books.

?Isolate past exam questions for each unit to identify and improve your weak areas.
One thing to keep in mind here is that you should not expand your learning scope just because of one or two questions that deviate from the textbook.

④ Since the implementation of the consignment system, the recent past exam questions have the same format with only the difference in difficulty regardless of the issuing agency, so I tried to adapt to the questions with the mindset that I would get 100% correct on the questions similar to the past exam questions included in this book.
I hope you learn.

V.
Acknowledgements
The technical and theoretical background of this textbook was written based on the writings of many professors.
Just as I was able to meet such a precious companion during my long writing period, I hope this book will serve as a valuable companion, like a compass, to all of you during your arduous exam preparation period. I sincerely hope that all of you who use this book will pass your exams.

Finally, I would like to express my gratitude to the many successful candidates who helped me proofread this book, and to all the staff at Gian Edu who provided valuable support, both material and spiritual, in the process of publishing this book.
thank you