SS 1 Data Processing (1st, 2nd & 3rd Term)

INPUT DATA After the field names and their data types have been specified, records are stored in the database by specifying the appropriate input. In MS Access, to input data: Double-click on the Student Table at the left-hand pane of MS Access windows Enter the data beneath the field names and click on the next […]

Database packages are used to design a database in a computer. Example of a common database package is Microsoft Access. MS Access is a Relational Database Management System used to create and modify databases. USING MS- ACCESS FOR DATABASE To create a database on the computer with MS Access Load MS Access: do the following;

Database is an application that is used to store information in a structured way. It is a collection of records or data in an organized form. A database management system is a collection of computer software that enables users to define, create and maintain a database. A database management system (DBMS) is a computer application

LOADING EXCEL APPLICATION Click on all programs, check the programs and click on the Microsoft suites then click on the excel application.  CREATING EXCEL DOCUMENT Once Excel is open, you can enter data into a file by clicking on a particular cell, then typing text, numbers, or formulas. Your changes will be entered into the

EXAMPLES OF SPREADSHEET Microsoft Excel Google Sheets Apple Numbers LibreOffice Calc OpenOffice Calc Zoho Sheet Lotus 1-2-3 Quattro Pro SuperCalc StarCalc WPS Office Spreadsheets PlanMaker (part of SoftMaker Office) Gnumeric OnlyOffice Spreadsheets Sheetster These software options vary in functionality and compatibility, catering to a range of user needs from basic data handling to advanced analytics.

A spreadsheet is a collection of cells organized into rows and columns where data is stored and manipulated. The spreadsheet is known as a worksheet. A spreadsheet begins with row number one and column A. A cell is a space in a worksheet formed by the intersection of a row and a column. Each cell

CREATING A WORD DOCUMENT Click on the start icon to display the start icon to display the start menu and then click on the Microsoft word icon. The program gives you an empty one to type. HOW TO SAVE A DOCUMENT Start a new document in word and type your text. Click file in the

A word processor is a computer software application that performs the task of creation and printing of electronic documents. There are several types of word processors; they include Word Perfect, Word Star, MS-Word, Loco Script, Ami-Pro, Word Craft, and WordPad etc. Microsoft Word: it is part of the Microsoft office suite. Word consistently wins the

Word processing is the phrase used to describe using a computer to create, edit and print documents. It is also the creation, input, editing and production of a document with a computerized device. A word processing package enables you to type in and manipulate text.  It helps you to enter, store, format, copy and print

An operating system is a group of computer programs that coordinates all the activities among computer hardware devices. It is the first program loaded into the computer by a boot program and remains in memory at all times. Functions of an operating system The basic functions of an operating system are: Booting the computer Performs

Definition: An operating system is a collection of programs that control the application software that users run and provides a link between the hardware and software currently running on the computer. The operating system is also responsible for the management and control of all resources (memory, hard drives, monitor, etc.) that are shared amongst the

An operating system (OS) is system software that manages computer hardware and software resources and provides common services for computer programs. The operating system is a component of the system software in a computer system. Application programs usually require an operating system to function. Time-sharing operating systems schedule tasks for efficient use of the system

Anti-virus software is your computer’s best defence against malware (e.g., viruses, Trojan horses, worms, spyware) – install and update anti-virus software on your computer and regularly scan your computer to make sure it is free from malware. Computer safety measures are essential to protect your digital data and ensure a secure computing environment. Here are

There are various means of transmitting information, and the choice of method often depends on the nature of the information, the distance it needs to travel, and the desired speed and reliability of transmission. Here are some common means of transmitting information: 1. Wired Communication: This involves the use of physical cables or wires to

A chart, also called a graph, is a graphical representation of data, in which “the data is represented by symbols, such as bars in a bar chart, lines in a line chart, or slices in a pie chart”. A chart can represent tabular numeric data, functions or some kinds of qualitative structure and provides different

Information processing is the acquisition, recording, organization, retrieval, display and dissemination of information. Information processing could also be referred to as the manipulation of digitalized information by computers and other digital electronic equipment, known collectively as Information technology. A computer information processor processes information to produce understandable results. For example, an information processor works to

Data are raw, unorganized or unprocessed facts that need to be processed. Data can be something simple and seemingly random and useless until it is organised. TYPES OF DATA Qualitative data  i.e descriptive information Quantitative data  i.e  numeric information   SUBDIVISION OF QUANTITATIVE DATA Continuous data: this can take any value. It is also known

ICT has turned this world to a global village. Apart from communication, that is, reaching people both far and near; it has also made the work easier and better. Better productivity, salaries, health care and even farming and education. SECTORS WHERE ICT HAS PLAYED MAJOR ROLE Education Banking Industry Commerce EDUCATION ICT is applied in

COMPONENTS OF A COMPUTER SYSTEM A computer system consists of three main parts otherwise called components. They are : Hardware Software People ware   HARDWARE COMPONENT The computer hardware could be defined as the physical parts of the computer that we see, feel and handle. It consists of device for input, processing, storage, output and

Digitalization is the process of converting information into digital format. This information may represent an object, image, sound, document or a signal (usually an analog signal) organized into discrete set of its points or samples. This is the binary data that computers and many devices with computing capacity (such as digital camera and digital hearing