Kiến thức cơ bản về CNTT và ứng dụng phần mềm

Fundamental IT Knowledge and Software Applications

Welcome to this comprehensive course that covers essential concepts in information technology (IT) and everyday software usage. Whether you are a beginner or need a refresher, the lessons below will reinforce key ideas such as data measurement, networking devices, resource sharing, hardware functions, and basic spreadsheet formulas. Each section includes clear explanations, practical examples, and tips for remembering the material—perfect for quiz preparation and real‑world application.

1. Data Measurement: Bytes and Bits

In digital computing, the smallest unit of information is the bit, which can hold a value of 0 or 1. A group of eight bits forms a byte. This standard is universal across all computer architectures.

• 1 byte = 8 bits
• Why eight? The 8‑bit byte balances the need for enough combinations (256) while keeping hardware design simple.

Memory tip: Think of a byte as a “bunch of eight bananas”—you always get eight, never six or ten.

2. Networking Devices: The Role of a Router

Connecting multiple networks together requires a device that can direct traffic based on IP addresses. This device is the router. Unlike ROM, RAM, or the CPU, a router does not store data permanently; it simply forwards packets to their destination.

• Router – routes data between LANs, WANs, and the Internet.
• ROM (Read‑Only Memory) – stores firmware, not used for routing.
• RAM (Random‑Access Memory) – volatile memory for active processes.
• CPU (Central Processing Unit) – executes instructions, not a networking device.

Memory tip: Router = “road‑map” for data packets.

3. Understanding "Share" in Computer Networks

When you see the term Share in a network context, it refers to the ability to make resources—such as files, printers, or drives—available to other users on the same network. This concept is fundamental for collaborative work environments.

• Shared folder – allows multiple users to read/write files.
• Shared printer – any networked computer can send print jobs.
• Shared drive – a common storage space for team projects.

Analogy: Sharing a resource is like cutting a cake so everyone gets a slice.

4. Interpreting Product Catalogs: Pricing Example

Product tables often list items alongside their prices. In the provided example, the price 580,000 đồng corresponds to the security software KIS (Kaspersky). Recognizing patterns in tables helps you quickly locate information without scanning every row.

• KIS – 580,000 đồng
• NOT (Norton) – different price
• BDE (Bitdefender) – different price
• “No product” – incorrect because a matching entry exists.

Quick recall: "KIS – price 580k".

5. RAM Capabilities

Random‑Access Memory (RAM) is volatile memory that temporarily stores data the CPU needs fast access to. Its primary functions include:

• Read, write, and erase information during a computer session.
• Providing a workspace for running applications.
• Enabling multitasking by holding multiple active processes.

Common misconceptions:

• RAM can be upgraded – contrary to the “cannot upgrade” option.
• System stability depends on sufficient RAM; lacking RAM can cause slowdowns or crashes.
• Data in RAM is lost when power is removed, unlike storage drives.

6. Network Scale: LAN vs. WAN

Networks are classified by geographic scope. The smallest typical classification is the Local Area Network (LAN), which covers a single building or campus. Larger networks include:

• MAN (Metropolitan Area Network) – city‑wide.
• WAN (Wide Area Network) – spans regions or countries.
• Internet – the global WAN.

Thus, a LAN is the most limited in scale, making it ideal for home or office environments.

7. Spreadsheet Basics: VLOOKUP Function

The VLOOKUP function searches for a value in the first column of a range and returns a value from a specified column. The syntax is VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

Given the formula =VLOOKUP(4, A1:B5, 2, 0):

• lookup_value = 4
• table_array = A1:B5 (two‑column range)
• col_index_num = 2 (return value from the second column)
• range_lookup = 0 (exact match required)

If the value 4 is not found in the first column, the function returns #N/A. This is the correct answer for the quiz.

8. Spreadsheet Logic: IF and AND Functions

The IF function evaluates a condition and returns one value if true, another if false. Combined with AND, multiple conditions can be tested simultaneously.

Formula: IF(AND(5>3, 2>=2), 2, 3)

• 5>3 is true.
• 2>=2 is also true.
• AND returns true because both conditions are satisfied.
• The IF therefore returns the first argument, 2.

This demonstrates how logical operators can simplify decision‑making in spreadsheets.

9. Summary and Study Tips

Review the key points:

• 1 byte = 8 bits – the universal data unit.
• Routers connect networks; other components (ROM, RAM, CPU) serve different roles.
• "Share" means making resources accessible to other users.
• KIS (Kaspersky) is priced at 580,000 đồng in the sample catalog.
• RAM allows reading, writing, and erasing data during operation.
• LAN is the smallest network classification.
• VLOOKUP with an exact match returns #N/A when the lookup value is absent.
• IF(AND(...)) returns the first result when all conditions are true.

To retain this knowledge, try the following:

• Create flashcards for each term and test yourself daily.
• Build a simple spreadsheet and experiment with VLOOKUP and IF formulas.
• Set up a mini‑LAN at home using a router and share a folder to see "share" in action.

By actively applying these concepts, you will solidify your understanding and be well‑prepared for both quizzes and practical IT tasks.