COMPUTER STUDIES QUESTIONS WITH ANSWERS
List any four tasks that an electronic spreadsheet should be able to perform other than calculations27/12/2020 (a) List any four tasks that an electronic spreadsheet should be able to perform other than calculations.
(b) Explain what is meant by automatic recalculation as used in a spreadsheet.
Feature of electronic spreadsheet system which runs anytime a cell is updated, causing all formulas, functions and macros which depend on that cell to automatically update their computations
0 Comments
Explain the impact of information on organizations in each of the following areas:(a) Competition
An organization that has access to quick and relevant information will obviously be ahead of its competitors and can therefore strategize itself accordingly. Information is a powerful tool in a competitive environment
(b) Pace of growth
Organizations need to advertise themselves therefore information is a very important ingredient to their pace of growth. An organization that advertises itself accordingly will be known and will therefore be ahead of its competitors.
Give three advantages of separating data from the application that use the data in database design.27/12/2020 Give three advantages of separating data from the application that use the data in database design.
The first column in the table below contains the formulae as stored into the cell F10 of a spreadsheet. Enter the formulae, as they would appear when copied to the cell M20 of the same spreadsheet. Expected ResponseA 3 by 4 matrix M is to be added to another 3 by 4 matrix array N so as to give a third 3 by 4 matrix array P. Using a high level programming language, write a program segment that assigns the sum of M and N to P.
Program add matrix (input, Output);
Type Matrix = Array (14, 13) of integer; Var A, B, C: Matrix; I, J: Integer; Producer add (Var X, Y, Z: Matrix); Begin (add) For I: to 3 do Begin For J: 1 to 4 do Z [l,J]: X [l, J] + Y[l,J]; End End; {add} High level programming languagesWhat is batch processing?
Transaction are accumulated over a period of time and then processed at a pre-specified time to produce a batch of output
Give one advantage and one disadvantage of batch processingAdvantages
Disadvantages
Related SearchesFunctions of the UPS
Compare the two types of diskettes used in microcomputers in terms of physical size and densities.27/12/2020
Compare the two types of diskettes used in microcomputers in terms of physical size and densities.
Question Source: KNEC KCSE 1998 Computer Studies
The ‘while…do’ loop is a control structure designed to execute the same block of code again and again until a certain condition is fulfilled. This loop is used if a condition has to be met before the statements within the loop are executed. A firm intends to purchase new software. List three items that should accompany the software26/12/2020 (a) A firm intends to purchase new software. List three items that should accompany the software (3mks)
(a) What are computer viruses?
A computer program designed specifically to damage other programs or cause irregular behaviour.
(b)
|
Single-user operating system |
Multi-user operating system | |
1. Definition |
It is designed for use by only one person |
A multi-user operating system allows for multiple users to use the same computer at the same time and different times. |
2. Differences |
designed to be used by a single person |
designed to be used by more than one person at the same time |
3. Examples |
|
|
Step 1: Start spelling and grammar tool
Differentiate between primary memory and secondary memory
Primary memory is volatile, i.e. contents held are lost on power loss.
Secondary memory is non-volatile or permanent, i.e. Contents held are not lost on power loss.
Clear differences between primary memory and secondary memory
Primary Memory |
Secondary Memory |
|
1. Capacity |
Low storage capacity |
High storage capacity |
2. Storage mechanism |
Volatile (loses content when power is switched off) |
Non-Volatile (does not lose content when power is switched off) |
3. Speed of storage/access/retrieval of information |
Fast |
Slow |
4. Storage terms |
Store data temporary unless it is a special type of ROM |
Store data permanently |
5. Examples |
RAM and ROM |
Optical Disks such as DVDs, Magnetic Disks such as HardDisk, Solid state disks such as Flash disk and Memory stick |
6. Uses |
Handles data currently needed by the computer |
Stores data that is needed for future reference or data being transfered from one machine to another. |
State two methods of minimizing dust in a computer laboratory
- Regular cleaning and mopping
- Computer laboratory should be built while doors facing away from wind direction.
- Ensure proper ventilation in the computer laboratory
- Dry cleaning methods should be observed.
- Air blowing
- Use a carpeted/tiled floor (gathers dust slowly and does not raise dust)
- Users to remove muddy shoes or clean them to ensures that no dust is carried to the room.
Categories
All
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2022
Analogue And Digital Systems
Applications Areas Of ICT
Areas Where Computers Are Used
Auxiliary Storage Devices
Basic Computer Set Up And Cabling
Binary Conversion
Booting
CABLES AND PORTS
Career Opportunities In ICT
Classification Of Computers
Coaxial Cables
Coding Schemes
COMPACT DISK
COMPLETE PAPERS
Computer Crimes
Computer Files
Computer Memory
Computer Software
Computer Systems
COMPUTER VIRUS
Dashboard
Database
Data Collection
Data Communication
Data Integrity
Data Processing
Data Representation In A Computer
Data Security And Controls
Definition And Development Of Algorithm
Desktop Publisher
Development-of-computers
DTP
DVD
Electronic Data Processing Modes
Elementary Programming Principles
Errors-in-data-processing
Evolution-of-computer-systems
Fibre Optic Cables
File Management Using An Operating System
File-organization-methods
Flowchart
Form 1 Level
Form 2 Level
Form 3 Level
Form 4 Level
Formatting Features
Hands On Skills
HARDCOPY OUTPUT DEVICES
Hard Disk
Hardware
Impact Of Ict On Society
IMPACT PRINTERS
Information
Input Devices
Internet And Email
Introduction To Computers
Introduction To Networking And Data Communication
ISP
Levels-of-programming-languages
Midterm-exams
Mind-blowing-q-a
Mocks
Network Topologies
Network-topology
NON-IMPACT PRINTERS
Ones And Twos Compliments
Operating Systems
Output Devices
Paper 1
Parts Of A Computer
Practical Hands On Skills
Printers
Processing-devices
Processors
Program-construction
Program-control-structures
Program-design
Program Development
Program-documentation
Protocols
Registers
Review Questions
Revision Kits
Secondary Storage Media
Section A
Section B
Security Threats And Control Measures
Software
Spreadsheets
Stages Of System Development
Storage Devices
Symbolic-representation
System-design
System Development
System-documentation
Term-1
TERM 2
The Computer Laboratory
The CPU
The Keyboard
Types Of Computer Files
Types-of-networks
User Interface
Uses-of-computers
Word Processors
Worksheet-formatting
Archives
December 2024
January 2024
December 2023
October 2023
September 2023
July 2023
June 2023
February 2023
November 2022
September 2022
April 2022
January 2022
December 2021
November 2021
July 2021
March 2021
February 2021
January 2021
December 2020
October 2020
April 2020
February 2020
October 2019
August 2019
July 2019
April 2019
March 2019
November 2018
August 2018
July 2018
December 2017
November 2017
October 2017
July 2017
August 2016
June 2016
January 2016
December 2015
November 2015
We Would Love to Have You Visit Soon! |
Hours24 HR Service
|
Telephone0728 450425
|
|
8-4-4 materialsLevels
Subjects
|
cbc materialsE.C.D.E
Lower Primary
Upper Primary
Lower Secondary
Upper Secondary
|
teacher support
Other Blogs
|