cmpnote blog

Introduction to Database Management Systems - SS1 Digital Technologies TOPIC: Database Management System (DBMS) CLASS: SS 1 Introduction to Databases & DBMS Data Architecture, Storage Hierarchies, Data Types, and MS Access Fundamentals 1. Fundamental Definitions 1. Database: A structured, highly organized depository of related data records stored electronically inside a computer framework. It allows users to quickly search, filter, and extract specific information blocks out of thousands of entries. 2. Database Management System (DBMS): A system software package that serves as the administrative interface between the physical database storage layers and the end-user. It provides formal tools to create, extract, modify, optimize, and lock data records securely. Key Distinction for Exams: A Database is the passive storage container holding the file...

Spreadsheet Fundamentals - SS1 Digital Technologies TOPIC: Spreadsheet Introduction to Electronic Spreadsheets Anatomy, Operations, Formulas, and Data Visualization Definition of Spreadsheet 1. A spreadsheet is an application software that tracks, analyzes, and charts numeric information. 2. It is an interactive computer application program designed for the organization, analysis, and storage of data in tabular form. 3. It is a computer program that allows complex mathematical calculations to be automatically carried out across several interconnected cells containing data. Examples of Spreadsheet Packages Microsoft Excel (Industry standard desktop suite) Google Sheets (Cloud-based collaborative tool) iWork Numbers (Apple Office Suite) LibreOffice Calc / OpenOffice Calc (Open-source alternatives) Ai...

Advanced Word Processing - SS1 Digital Technologies TOPIC: Advanced Word Processing Advanced Word Processing Techniques Automation, Layout Customization, and Multi-user Collaboration 1. Document Styles, Themes, and Templates In basic word processing, text is formatted manually tool-by-tool (changing font, then size, then color). Advanced word processing utilizes Styles to achieve global automation. Styles: A named collection of formatting characteristics (e.g., Font: Arial, Size: 24pt, Color: Navy, Bold) saved as a single command. Applying "Heading 1" to all chapter titles ensures identical formatting across a 500-page book. Themes: A coordination of color palettes, font pairings, and graphic effects that apply to an entire document instantly. Changing a theme alters all active styles dynamically. Templates: Pre-formatted document frameworks...

Number Systems & Data Representation - SS1 Digital Technologies SS1 Digital Technologies Lesson Notes Term 1 — Week 6: Number Systems & Data Representation Introduction to Data Representation In everyday life, humans count using ten digits: 0, 1, 2, 3, 4, 5, 6, 7, 8, and 9. This system is known as the Decimal system (Base 10) . However, because computer memory circuits are made up of millions of tiny electronic switches that can only exist in two distinct physical states (ON or OFF), digital hardware must process numbers using a different mathematical framework altogether. To map data accurately within computing, engineers utilize four primary types of number systems. Each system is defined uniquely by its Base (or Radix) , which indicates the total count of distinct characters available to represent values. ...

Operating Systems (OS) - SS1 Digital Technologies Lesson Notes SS1 Digital Technologies Lesson Notes Term 1 — Week 5: Introduction to Operating Systems (OS) What is an Operating System? Imagine buying a high-end computer or mobile phone with excellent processors and large RAM capacities, but when you switch it on, the screen remains completely blank or displays raw code. Without specialized instructions to control the components, a computer is nothing more than expensive metal and plastic. The software that brings the system to life is the Operating System (OS) . It resides in the computer's storage media and acts as an intermediate coordinator, ensuring application software (like Microsoft Word, web browsers, or video games) can talk directly to physical hardware processors seamlessly. ...

Data Units & Capacity - SS1 Digital Technologies Lesson Notes SS1 Digital Technologies Lesson Notes Term 1 — Week 4: Data Units & Storage Capacity Measurements How Computers Measure Information Just like we measure physical length in meters and liquids in liters, digital technology requires a standard system to measure file sizes, internal memory spaces, and storage capacity. Because computer hardware operates entirely on electronic switches that are either turned Off or On, computers express all data using the mathematical base-2 binary system . The Fundamental Building Blocks: • Bit (Binary Digit): The smallest imaginable unit of digital information. A single bit can only hold one of two possible values: a 0 (representing electrical current off) or a 1 (representing electrical current on). ...