Educational Blog - Ajiboye Gbenga @ Sunlite Digital ALBESTA ACADEMY LEKKI

  DATA MODEL MEANING AND TYPES OF DATA MODELS A model is like a blueprint of a more complex real-world object or event. A data model is a picture or description which shows how data is to be arranged to serve a specific purpose. A data model defines how data is connected to each other and how they are processed and stored inside the system. A data model documents and organizes data, how it is stored and accessed, and the relationships among different parts of data. TYPES OF DATA MODEL 1 .  Flat file model : A flat data is a type of database that stores data in a single table. Flat file databases are generally in plain-text form, where each line holds only one record. The fields in the record are separated using delimiters such as tabs and commas  2.  Hierarchical model : In this model, data is organised into a tree like structure. The data is stored as records which are connected to one another through links. In a hierarchical model, each child record has only one pa...

  THE INTERNET II   DEFINITION OF TERMS, AND BENEFITS OF THE INTERNET Definition of Internet Internet is a worldwide network of computers that share information. It is also defined as a global system of interconnected computer networks that use the Internet protocol suite to link devices worldwide. Internet Definition of Terms 1. Cyber café: An internet café or cyber café is a place which provides internet access to the public, usually for a fee. 2. Cyberspace: It is the electronic medium of computer networks, in which online communication takes place. 3. Download: To transfer a file from a remote computer to a local computer. In other words, it means to transfer a file from a web server to a web client. 4. Upload: Transfer a file from a local computer to a remote computer. In other words, it means to transfer a file from a web client to a web server. 5. E-mail is mail that's electronically transmitted by your computer. 6. File Transfer Protocol (FTP) is the standard meth...

 BASIC BUILT-IN FUNCTIONS A function is a structure that simplifies a complex operation into a single step. BASIC built-in functions are predefined functions that perform a wide range of operations. BASIC has several built-in functions that greatly extend its capability. They include the following: (i) SQR (X) - SQUARE ROOT FUNCTION (ii) ABS (X) - ABSOLUTE VALUE FUNCTION (iii) LOG (X) - LOGARITHM FUNCTION (iv) SIN (X) - SINE FUNCTION (v) TAN (X) - TANGENT FUNCTION (vi) RND (X) - RANDOM NUMBER FUNCTION (vii) EXP (X)- EXPONENT FUNCTION (viii) ROUND (X,N) -  ROUNDS THE NUMBER X TO THE NUMBER OF DIGITS N (ix) INT (X) - FIND THE INTEGER OF A REAL NUMBER

  SS3 1ST  TERM SCHEME OF WORK (I.C.T) 1. BASIC pr ogramming Language II (Advanced) – Built In Functions – Simple BASIC program. 2. BASIC programming Language II (Cont) – Simple BASIC program/WAEC/NECO approach 3. The Internet II – Meaning, Definition of terms, Benefits of the Internet 4. The Internet III – Electronic Mail Services – Definition, Creating Email Account, Email Address, Differences Between Email and Website 5. WAEC/NECO Practical – Microsoft Word/Microsoft Excel 6. Networking 1 – Definition- Types of Network – LAN –WAN- PAN- CAN and Network Topology 7. Mid Term Break 8. Networking 2 – Network Devices – Hub – NIC Card – The Switch – The Router – The Modem e.t.c 9. Networking 3 – Cables and Connectors ·       Network Cables– Twisted Pair Cable – Coaxial Cable – Fibre Optics Cable – Telephone Cable – Power Cable – Data Cables ·       Network Connectors – RJ 11, RJ 45, BNC T – Connector, Mal...

  JS3 COMPUTER STUDIES 1ST TERM SCHEME OF WORK WKS 1. The Internet Environment - Search Engine - Meaning - Examples - and Uses of Search Engine ·        2. Practical - The Use of Search Engine - Google.com, Microsoft Bing, Ask.com. DuckDuckGo ·        Make use of a search engine to search and download information into the computer system 3. Digital Divide 1 - Concept of Digital Divide - Features of Old and New Economy- Benefits of New Economy 4. Digital Literacy - Meaning, Characteristics of Digital - Education - Workforce - Society. 5. Database 1 - Definition - Terminologies - Data Items 6. Database (Practical with Microsoft Access) 7. Mid Term Break 8. Spreadsheet Package 1 - Meaning, Examples and Uses 9. Spreadsheet Package 2 - (Practical) - Features - Terminologies - Row - Column - Cell - Worksheet e.t.c 10. Revision 11-12. Examination 13. Vacation

  SS1 1ST TERM SCHEME OF WORK - I.C.T 1. Overview of Computer System 1 - Definition - Constituents - Parts of a Computer and Characteristics  2. Historical Development of Computer Devices 1 - (Pre Computing age to 19th Century) - Abacus, Slide Rule, Napier's Bone, Pascal's Calculator (Pascaline), Leibnitz Multiplier, Difference Engine e.t.c 3. Historical Development of Computer Devices 2 - ( 20th Century to Date) - ENIAC -EDVAC -UNIVAC - Desktop Personal Computers- Laptop & Notebook computers - Palm Top computer 4. Computer Hardware - Classification of Hardware - System Unit - Peripherals - Input - Output Devices - Storage Devices 5. Input Devices - Definition and Examples - Keyboard, Mouse, Joystick, Light Pen, Microphone  e.t.c 6. Output Devices - Definition and Examples - Monitor (VDU), Printers, Projector, Speakers e.t.c 7. Mid Term Break 8. Computer Software 1 - Meaning and types of Software - System and Application S...

  JS1 (FIRST TERM COMPUTER STUDIES SCHEME OF WORK) 1. Basic Computer Concept: Meaning, Parts, categories, description of input and output devices 2. Technology of different Information Age- Stone Age, Iron Age, Industrial Age, Electronic Age 3. Historical Development of Computer- Early counting Devices, Mechanical, and electromechanical 4. Generation of Computers: 1st, 2nd, 3rd, 4th, and 5th Generations 5.          Data and Information Transmission- Meaning, types, sources, and qualities of a good information 6. Information Transmission- Meaning, methods, and modes 7. Mid - Term Break   8.   Classification/Means of Transmitting Information - Invention of    printing, radio and television, computers and linking up   computers with information technology (IT) 9..           I.C.T App...

  SS3 - 1ST TERM DATA PROCESSING SCHEME OF WORK  1. Computer Networking 1 – Meaning and types of Network 2. Computer Network 2 - Classes- intranet – Extranet – Significance/importance of Computer Network 3. Computer Network 3- Network Topology – bus – star – ring – mesh e.t.c 4. The Internet II –Create an Email Account – File Attachment – Send and Receive Email – Concept of Social Media, Online Registration, Introduction to CBT 5. Computer Virus – Meaning – Types – Sources – Virus Warning Signs – Virus Detection/Prevention 6. Maintenance of Computer I-II – Hardware and Software Maintenance – Ways of Protecting Computer Software 7. Mid Term Break 8. Career Opportunities in Data Processing 1 -2 – Professionals in Computer – Qualities of a good data processing Professional – Computer Professional Bodies – NCs – CPN –ISPAN – NIG e.t.c 9. Career Opportunities in Data Processing 2 - Qualities of a good data processing Professional – Computer Professional Bodies – N...

  SS1 - 1ST TERM DATA PROCESSING SCHEME OF WORK  WKS 1. History of Computing 1 – Concrete device in computing, Numbering System in Pre-Computer Age, Decimal, Whole Number e.t.c) 2. History of Computer – Early Counting Devices – Abacus – Analytical Engine- Jacquard Loom e.t.c 3. Classification of Computer by Generations( 1 st – 5 th Generations) 4. Classification of Computer By Size – Super –Mainframe – Mini – Micro Computer 5. Classification of Computer By Type – Analog – Digital – Hybrid – Special – Generation Purpose Computers 6. Components of Computer – Definition – Computer as a System –Hardware and Software 7. Mid Term Break 8. Components of Computer – Input – Output Devices 9. System Unit and Storage Devices – Differentiate Between System Unit and Storage Devices – List Examples of System Unit device and Storage Device 10. Data and Information – Ways of handling data – Electronic/Non Electronic – Definition of Information – Use of Information – Wa...

  SS2- 1ST TERM ICT SCHEME OF WORK FOR 2024/25 ACADEMIC SESSION WKS 1. The Central Processing Unit 2 - Registers - Meaning and Types of Registers : MDR, CIR, Accumulator, Differences Between Registers and Main Memory. 2. The Memory Unit 1 - Meaning, Types and Description Practical - JAVA Console Input Statement  3. The Memory Unit 2 - Unit of Storage in Order - Conversion from One Unit of Storage to the Other. 4. Logic Gates/Circuits 1 - Definition and Types of Logic Gates/Circuits - Logic Gate Symbols - Uses of Logic Gates 5. Logic Gates/Circuits 2 - Truth Table and Equation for each Logic Gate. 6. Logic Gates/Circuits 3 - Truth Table and Equation for each Logic Gate (Continuation)   Practical - JAVA Console Control Statement  7. Mid Term Break 8. Logic Gates/Circuits 3 - Alternative Logic Gates - Description - Truth Table Practical - Video Editing 1  9. Computer Data Conversion - Definition of Terms - Address Bus - Data Bus...

  1ST TERM DATA PROCESSING SCHEME OF WORK 1. Introduction to Database Management System 1 - Definition, Examples, Uses and Data Items. 2. Database Management System - Practical (With Microsoft Access) 3. Data Model 1 - Definition and Stages 4. Data Model 2 - Types of Data Model - Flat - Hierarchical - Network Model - Object Oriented Model 5. Data Modelling 1 - Creating Tables - Forms  and Creating Queries Reports. 6. Data Modelling 2 - Significance of Data Modelling and Examples of Standard Data Models 7. Mid Term Break 8. Normalization 1: Definition - Tables in 1st, 2nd and 3rd Normal Form - Problems of Tables in 1st Normal Form. 9. Normalization 2 : Keys - Primary Keys - Foreign Keys - Composite Keys 10. Revision 11-12. Examination 13. Vacation