Notes, summaries, assignments, exams, and exercises for Computer science for Secondary education

Computer System Essentials

Core Operating System Components

Kernel: The OS's Foundation

The operating system's core, a platform that allows other software to execute.

Shell: User Interaction Interface

The operating system's interface for users to interact with all computer elements.

Thread: A Running Program or Task

Any program or task that is currently running.

File System: Data Storage & Retrieval Protocol

A protocol that defines how files are stored and retrieved on disk drives, or by threads and programs.

Disk Formatting: Setting a File System

The process of setting a disk's file system.

Major Operating Systems and Their Focus

• Microsoft Windows: Focuses its operating system on security.
• Linux: Emphasizes customizability.
• Chrome OS: Centered on web

This section addresses key concepts regarding digital media processing, file formats, and data requirements.

1. Stereo vs. Mono Audio Data Requirements

   Question: What is the difference between stereo and mono audio?

   Answer: Stereo audio usually requires twice as much data as mono audio.

2. Quickest Audio Format for Web Download

   Question: Which audio format would be quickest to download from a website?

   Answer: AAC (Advanced Audio Coding).

3. Audio File Format Compatibility

   Statement: All audio file formats will work on all media players.

   Answer: FALSE. Compatibility depends on the specific media player and the codecs supported.

4. Defining Bit Depth

   Question: What is bit depth?

   Answer: Bit depth is the number of bits it is possible to have in each sample or frame of

Faster Report Creation via Database Window

Another faster way is from the Database window with the object selected (reports) by double-clicking on Create report by using assistant.

First Wizard Window: Field Selection

The first wizard window appears, asking us to enter the fields to include in the report.

1. Select the table or query where you will fetch data from the Tables/Queries box. This will be the source of the report.
2. If you pull data from multiple tables, it is best to create a query for the data and then choose that query as the source of the report.
3. Select the fields by clicking on the field to select it and clicking the > button, or simply double-click on the field.
4. If you select a field by mistake, press the < button to remove it from

Tasks 10–20

10. Protect and password-protect sheets in a workbook: Tools > Protection > Protect Sheet > enter a password to unprotect.
11. Set a background image on a sheet: Format > Sheet > Background > Browse > select image file.
12. Fill a series (numeric or chronological): numerical and chronological (date, month, etc.): write the first two values, select them, click the bottom-right corner (AutoFill handle) of the selected range and drag.
13. Apply color to cells or ranges: Format > Cells > Fill (Shading) or Format > Font > Color, respectively.
14. Draw cell borders: Format > Cells > Border (choose line style, color, and which edges to apply).
15. Hide gridlines on a sheet: Tools > Options > View > uncheck Gridlines.

Understanding Spreadsheet Basics

What is a Spreadsheet?

A spreadsheet is a grid with rows and columns, primarily designed for numeric data but also accommodating alphabetic entries to organize information effectively.

Each individual spreadsheet is referred to as a sheet. Each sheet has a label or name, visible at the bottom of the workbook or worksheet interface. When a new workbook is created, Excel typically opens with three default sheets: Sheet 1, Sheet 2, and Sheet 3. These names can be customized by the user, and additional sheets can be added or removed as required.

Workbook Explained

A workbook is the collection of worksheets within a single document. Multiple workbooks can be open simultaneously in separate windows.

Active Cells and Selection

A...

Framing bit stuffing:

Framing in Computer Network. Data link layer is responsible for something called Bit Stuffing in Computer Network. It is the division of stream of bits from network layer into manageable units (called frames). Frames could be of fixed size or variable size. Bit stuffing is the insertion of non-information bits into data.

framing: A frame is a digital data transmission unit in computer networking and telecommunication.

Bit Stuffing: Bit stuffing is the process of inserting non-information bits into data to break up bit patterns to affect the transmission of the network.

Byte Stuffing: It is a process that transforms a sequence of data bytes that may contain illegal or reserved values.

Gestión de Concesionario

Bienvenido al sistema de administración de vehículos. Utilice las siguientes opciones para gestionar su inventario:

• Crear Base de Datos
• Alta de Vehículos
• Consultar Inventario

Configuración de Base de Datos

El script de inicialización crea la base de datos coches y la tabla ocasion con los campos necesarios: marca, modelo, combustible, color, año y precio.

Formulario de Alta de Vehículos

Datos del Vehículo

Marca: VolvoSaabFiatAudi
Modelo:
Color:

Combustible:

Diesel Gasolina
Año de matriculación:
Precio:

Procesamiento de Datos (PHP)

El archivo Alta.php recibe los parámetros mediante el método GET y realiza la inserción en la base de datos MySQL utilizando la conexión establecida.

Understanding Digital Certificates

A digital certificate (or electronic certificate) is a computer file generated by a certification authority that associates identity data with a natural person, organization, or company, confirming their digital identity on the internet.

What Is Code Signing?

Code signing is a method that uses a certificate-based digital signature to sign executables and scripts. This process verifies the author’s identity and ensures the code has not been altered or corrupted since it was signed. This helps users and software determine whether an application can be trusted.

HTTPS and SSL Encryption

HTTPS (Hypertext Transfer Protocol Secure) is an extension of HTTP that utilizes SSL (Secure Sockets Layer) encryption. It creates...

Understanding Linux: Kernel, Free Software, and Distributions

Like any operating system, Linux is a combination of a main program, or kernel, and a series of added tools and libraries that enable its use. It possesses two distinguishing features:

• It is free software.
• It is distributed with its source code.

Most programs and libraries added to the Linux kernel to create a more user-friendly system have been developed by the GNU Project. For this reason, some people refer to Linux as GNU/Linux, clarifying that the operating system comprises not only the kernel but also all those programs and libraries.

Key Concepts Defined

Free Software

Software that can be used, copied, studied, modified, and redistributed freely.

Source Code

A set of text lines that