Notes, summaries, assignments, exams, and problems for Computers

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... Continue reading "Spreadsheet Essentials: Cells, Formulas, and Data Management" »

Turing's Thesis and the Problem of Computability

Thesis 1

"Every problem that can be solved algorithmically can be solved by a Turing machine."

Concepts Associated with Thesis 1

• Algorithm: A set of rules that can be mechanically applied to solve a problem of a given class. Mainly used in mathematical contexts.
• Calculation: Any transaction which is carried out by manipulation of symbols as a means of representation. The symbolic operations are atomic, that is, quite simple, and are held in a computer. The action of the computer will depend on the symbols that have the system and the internal state in which the computer is.

Thesis 2

"Every computable function can be computed by a Turing machine. Every problem that can be solved by algorithmic methods

Core Computing Terminology

• CBT: Computer-Based Training
• GUI: Graphical User Interface (icons and mouse)
• PDA: Personal Digital Assistant (portable computer)
• CPU: Central Processing Unit (measured in Gigahertz)
• RAM: Random Access Memory
• ROM: Read-Only Memory
• ALU: Arithmetic Logic Unit
• VDU: Visual Display Unit

Hardware Components

• Input Devices: Mouse, keyboard, trackball, scanner, barcode readers, touchpad.
• Output Devices: Monitor, printer, plotter, speakers, VDU.

Note: Adding more RAM improves computer performance. It is the main working memory of the computer and functions as read/write memory.

Information Technology and Communications

• IT: A term used to describe hardware, software, and communications technologies.
• PSTN: Public Switched Telephone Network (

Core Concepts in Computer Science and Programming

Microprocessor Components

Arithmetic Logic Unit (ALU) Explained

The Arithmetic Logic Unit (ALU) performs all mathematical and logical operations, such as comparisons, within the CPU.

Role of the Control Unit

The Control Unit is responsible for controlling all operations of both internal microprocessor components and external peripherals.

Memory and Data Storage

Understanding RAM (Random Access Memory)

Another name for volatile memory is RAM (Random Access Memory). It is generally used to store two primary types of information:

• Program instructions
• Operating data associated with those instructions

Algorithm Fundamentals

Defining an Algorithm

An algorithm is defined as a finite set of well-defined, unambiguous... Continue reading "Essential Computer Science and Programming Fundamentals" »

1.5 The Human Element in Computer Systems

The human element, or personnel, is the most important component within a computer system. It comprises a group of people who perform various functions related to the use and maintenance of computers and applications.

Key Roles in Computer System Personnel

• Staff Director: Responsible for directing and coordinating a department, a data processing center, or any related division.
• Staff Analysis (System Analyst): Manages application development, focusing on design, production of algorithms, and analyzing possible uses and modifications.
• Programming Personnel: In charge of transcribing the algorithms designed by the analyst into a specific programming language. This role also involves implementing the programs

Of these nine flags, six of them change after running many of the arithmetic and logic instructions. The six flags are:

• C (Carry): Indicates a carry after addition or a borrow after a subtraction. The carry flag also indicates error conditions on certain programs and procedures.
• P (Parity): It is zero for odd parity and 1 for even parity.
• A (Auxiliary Carry): Indicates a carry after addition or a borrow after a subtraction from bit 3 to bit 4 in the result.
• Z (Zero): Indicates if the result of an arithmetic or logic operation is zero. If Z = 1, the result is zero, and if Z = 0, the result is not zero.
• S (Sign): Indicates the arithmetic sign of the result after an addition or subtraction. If S = 1, the result is negative. If S = 0, the result is

Process Planning

Objectives

• Justice: Avoid favoring some processes over others.
• Maximum Number of Interactive Users: Focus on most time-sharing systems.
• Predictability: The strategy must enable the execution of processes.
• Minimizing Overhead: Minimize context switches.
• Balance in the Use of Resources: Resources must be used fairly and for as long as possible.
• Safety Priorities: Established priorities should be respected.
• Maximum Capacity of Execution: Minimize process changes.

Criteria

• Response Time: Speed with which the system responds to a request.
• Service Time: Response time minus time for I/O.
• Runtime: Service time minus timeout.
• Processor Time: Processor time occupation.
• Timeout: Waiting times in queues.
• Efficiency: Processor utilization.
• Yield: Number

Software Metrics Classification and Analysis

Analysis Model Metrics

• PF (Prediction Factor) Metrics: Used to predict the size of a system based on the analysis model.
• Bang Metric: Provides an independent indication of the system's implementation size.
• Quality Metrics of the Specification: Characteristics used to assess the quality of the analysis model and the Engineering Requirements Specification (ERS).

Design Model Metrics

• Object-Oriented (OO) Design Metrics: Provide indicators for OO design characteristics (e.g., inheritance, coupling, size of classes).
• Component-Level Design Metrics: Focus on cohesion, coupling, and complexity of individual software components.
• User Interface Design Metrics: Based on the appropriateness of the design as a metric

SPC Control System

SPC Control System refers to the method of controlling a switching system.

• Centralized SPC Control: If a given processor has direct access to all resources of the node and performs all system functions. This usually means the node has a single central computer (doubled for security).
• Distributed SPC Control: If a processor is in a given state but does not have access to some of the resources and/or is not able to run only some of the functions of the system. In practice, this leads to an existing digital system with a high number of microprocessors that perform the control node as a whole.

Functions of Switching Systems

Switching systems provide power and signaling with user terminals. The user, via the wire pair of the switching... Continue reading "SPC Control Systems: Centralized vs. Distributed" »

Information Technology and Communication (ICT)

Technologies based on microelectronics, robotics, computer, and communication networks.

Computing Fundamentals

Computing: The set of techniques and activities that address information, allowing it to be stored quickly and automatically with computers.

System: The set of elements needed to perform automatic processing of information.

Hardware Components

Hardware: Includes all the physical elements of the computer system.

Computer: A machine that can automatically receive information, store it in memory, and process it using programs or instruction sets.

Microprocessor (CPU): Responsible for coordinating and carrying out all operations of the system.

Peripherals

External elements that allow communication between... Continue reading "Essential Concepts of Computing and Information Technology" »