ATIKA SCHOOL
  • Home
    • JOBS IN KENYA AND ABROAD FOR KENYANS AND BEYOND
    • How its Done
    • KNEC Portal
    • Atika School Advanced Search
    • News and Opinions
    • Academic Environment
    • KNEC KCSE PROJECT INSTRUCTIONS
    • SITEMAP
    • About Us? >
      • About Us
      • Learn more about us
  • OUR PRODUCTS
    • All Categories >
      • Category
      • FREE NOVELS >
        • COURSE BOOKS
        • KCSE KISWAHILI SETBOOKS
        • Backed Up Files and Archives
        • FREE DOCUMENTS
        • PRIMARY 8-4-4 BASED RESOURCES
        • STANDARD 8 RESOURCES
        • HIGH SCHOOL RESOURCES >
          • Biology Paper 3 Exams
          • Secondary Examinations
        • PRIMARY CBC BASED RESOURCES
        • COLLEGE & VARSITY RESOURCES
    • PRIMARY RESOURCES CBC
    • PRIMARY RESOURCES 8-4-4
    • SECONDARY RESOURCES
    • NOTES & TUTORIALS
    • COLLEGE RESOURCES
    • NOVELS and OTHER BOOKS
  • EXAMINATIONS
    • PRIMARY EXAMS >
      • Primary Assignments and Random Exams
      • CBC
      • 8-4-4
      • STANDARD 8 PAST PAPERS 8-4-4 BASED
    • MOCKS AND JOINT EXAMS >
      • FORM 1 QUESTION PAPERS, ANSWERS AND MARKING SCHEMES COLLECTIONS
      • FORM 2 QUESTION PAPERS, ANSWERS AND MARKING SCHEMES COLLECTIONS
      • FORM 3 EXAMINATIONS, QUESTION PAPERS AND ANSWERS
      • MOCKS PAST EXAMS BY REGION
    • KCPE >
      • KCPE BY YEAR >
        • KCPE 2020 RESULTS, REPORTS, QUESTIONS AND ANSWERS
        • KCPE PAST PAPERS 2019 REPORTS, RESULTS, QUESTIONS AND ANSWERS
      • KCPE PAST PAPERS PER SUBJECT
      • KCPE PAST PAPERS AND ANSWERS
      • KCPE MATHEMATICS TOPICAL QUESTIONS FROM 1989 TO LAST YEAR
    • KCSE >
      • KCSE BY YEAR >
        • KNEC KCSE PAST PAPERS, MARKING SCHEMES, QUESTIONS & ANSWERS
      • KCSE BY SUBJECT >
        • KCSE PAST PAPERS BY SUBJECT
        • Free KCSE Past Papers Mathematics
        • Free KCSE Biology Questions and Answers
    • QUESTIONS & ANSWERS >
      • SECONDARY >
        • LANGUAGES >
          • A DOLL'S HOUSE BY HENRIK IBSEN RESOURCES
        • TECHNICALS >
          • COMPUTER STUDIES >
            • COMPUTER STUDIES Q & A
            • kcse computer studies paper 2 AND 3 Questions & Answers
          • BUSINESS STUDIES QUESTIONS & ANSWERS
          • KCSE AGRICULTURE TOPICAL QUESTIONS AND ANSWERS
          • KCSE HOME SCIENCE DIRECT QUESTIONS AND ANSWERS
        • SCIENCES >
          • KCSE Mathematics Topical Questions
          • KCSE Biology Topical Questions and Answers
          • CHEMISTRY TOPICAL QUESTIONS AND ANSWERS
          • KCSE Physics Topical Questions
          • KCSE physics Practical Sample Quiz
        • HUMANITIES >
          • ISLAMIC RELIGIOUS EDUCATION (IRE) QUESTIONS AND ANSWERS
          • KCSE History Topical Questions and Answers
          • GEOGRAPHY TOPICAL QUESTIONS AND ANSWERS
      • PRIMARY >
        • Standard 4-8 Mathematics Topical Questions from Mocks and KCPE
        • Std 6 Mathematics Notes
  • TUTORIALS
    • SECONDARY >
      • SCIENCES >
        • FOCUS MATHEMATICS TUTORIALS AND EXAMS FREE
        • KCSE BIOLOGY NOTES
        • FREE KCSE CHEMISTRY NOTES
        • KCSE PHYSICS NOTES, AUDIOVISUALS AND MORE
      • LANGUAGES >
        • ENGLISH >
          • English KCSE Set Books
          • ENGLISH POETRY QUESTIONS WITH ANSWERS FOR K.C.S.E CANDIDATES
          • ENGLISH GRAMMAR #KCSE
        • CHOZI LA HERI - MWONGOZO
        • KIGOGO - MWONGOZO
        • USHAIRI MASWALI NA MAJIBU
        • MASWALI NA MAJIBU YA TUMBO LISILOSHIBA
        • KCSE Kiswahili Fasihi
      • TECHNICALS >
        • HOME SCIENCE NOTES
        • KCSE BUSINESS STUDIES NOTES
        • COMPUTER STUDIES NOTES LATEST
        • kcse Computer Studies Notes
        • KCSE AGRICULTURE NOTES, SYLLABUS, QUESTIONS, ANSWERS, SCHEMES OF WORK AND OTHERS
      • HUMANITIES >
        • KCSE History Notes Form 1 to 4
        • FREE KCSE CRE NOTES
        • KCSE GEOGRAPHY NOTES
        • IRE NOTES, AUDIOVISUAL, QUESTIONS AND ANSWERS
    • PRIMARY >
      • NOTES >
        • KISWAHILI
        • SOCIAL STUDIES >
          • STANDARD 4: SOCIAL STUDIES
        • SCIENCE
        • ENGLISH >
          • KCPE and Primary Level Compositions
        • MATHEMATICS >
          • KCPE Mathematics Notes
      • EXAMINATIONS >
        • DecaTurbo Online Series Examinations
        • CBC Kiswahili
        • FOCUS A365 SERIES K.C.P.E EXAMINATIONS FOR PRIMARY
        • Standard 8 (std) English Topical Questions
    • Other Supportive Documents >
      • Free Schemes of Work
      • SYLLABUS >
        • Primary 8-4-4 based Syllabus, Objectives and Lessons
        • Primary Mathematics Syllabus
      • MASOMO VIDEOS
  • CURRICULUM
    • NEW CURRICULUM DESIGNS >
      • PRIMARY >
        • PRE PRIMARY ONE CURRICULUM WITH SYLLABUS
        • PRE PRIMARY TWO CURRICULUM WITH SYLLABUS
      • SECONDARY >
        • KNEC KCSE SYLLABUS AND COURSE OUTLINES
      • COLLEGE >
        • Regulations for the TIVET Craft and Diploma Business Examinations
  • HIGH INSTITUTIONS
    • EXAMINATIONS >
      • College and Varsity Past Papers online
    • TUTORIALS >
      • COLLEGE AND UNIVERSITY NOTES AND TUTORIALS
  • CUSTOMER CARE
    • PRICING
    • Contact
    • Help & Support
    • DONATE
    • MPESA FORM
  • BLOGS
    • ENGLISH - EKEGUSII DICTIONARY
  • MEMBERSHIP RESOURCES
    • Assignments and Random Exams
    • TERM 3 2021 PRIMARY PAST REVISION PAPERS
    • SECONDARY EXAMINATIONS
    • Search Free Documents (PDF)
  • Archived Pages
    • C.R.E (CRE) QUESTION AND ANSWERS
    • TOP SECONDARY EXAMS ALL SUBJECTS

List four areas that would be considered in the requirement specification.

18/11/2021

0 Comments

 

​(a) List and describe four strategies for converting from an old system to a new system.  (4mks)

  • Direct approach
    user simply stops using old system and starts using the new one
  • Parallel approach
    old and new system are operated side by side until the new system has shown it is reliable
  • Phased approach
    parts of a new system are phased in separately either at different times or all at one in groups 
  • Pilot approach
    entire system is tried out but only by some users

(b) (i) Distinguish between private data and confidential data  (2mks)

  • Private data
    belongs to an individual and must be accessed through direct permission from the owner
  • Confidential data
    ​held by government or organization about people but can be seen by authorized people only.

(ii) What can be done to stop illegal access to a computer laboratory by unauthorized people  (3mks)

  1. fit strong metallic grills and locks to doors 
  2. don’t welcome strangers into the lab
  3. install alarms
  4. employ guards
  5. burglar proof

​(c) (i) List four areas that would be considered in the requirement specification. (4mks)

  1. output specification
  2. in put specification
  3. file /data/tables
  4. hard ware/soft ware

​(ii) Name any two areas covered in feasibility report during system analysis and design. (2mks)

  • Lost benefit analyst
  • Schedule                   
  • Users
  • Environment           
  • Technology



Read More
0 Comments
Print Friendly and PDF

​The information below is maintained by the sales lady at the school canteen. Study it and answer the questions that follow.

17/11/2021

0 Comments

 

​The information below is maintained by the sales lady at the school canteen. Study it and answer the questions that follow.

Picture

​(a) Describe the basic data types used in this spreadsheet (4mks)

  1. Labels
    describing items names
  2. ​Values
    describing units on column B and C

​(b) Provide a single formula that would be used to
(i) Count the number of items whose units are equal; to 15             (2mks)

=COUNTIF(B2:B5,15)   or ​=COUNTIF(B2:B5,=15)

​(ii) Sum the values of items whole units are equal to 12             (2mks)

=SUMIF(B2:B5,"=12") or =SUMIF(B2:B5,"12")

(c) (i) List and describe four areas of application of spreadsheets  (4mks)

  1. Accounting
  2. What IF analysis (forecasting)
  3. Budgeting
  4. Calendars
  5. Expense reports
  6. Forms
  7. Time sheets
  8. Invoices
  9. Purchase Orders
  10. Receipts
  11. Schedules

(ii) Explain data range legend and axis as used in spreadsheet charts          (3mks)

Axis 
  • A reference line from \which distances or angles are measured in a coordinate system, such as the X-axis and y-axis in the Cartesian coordinate system
Legend
  • Brief description accompanying an illustration (chart) also known as a caption 



Read More
0 Comments
Print Friendly and PDF

List three advantages and three disadvantages of fibre optic cable and Name two types of coaxial cables

17/11/2021

0 Comments

 

(a) List three advantages and three disadvantages of fibre optic cable (6mks)
Advantages

  1. immune to electro magnetic interference and ear dropping
  2. fast and supports high band width
  3. large distance can be covered because it has low attenuation
  4. can be used in hazardous environment
  5. smaller and lighter than copper

​Disadvantages

  1. connecting devices are expensive
  2. installation is difficult
  3. complex to configure
  4. expensive/ difficult to repair

​(b) Describe the following signals and state where each is applied in network communication. (4mks)
Analog



  • made up of continuous varied wave form.
  • it is transmitted over telephone line.
  • a codec converts an analog signal to digital for transmission via a digital medium

​Digital 

  • made up of non continuous discrete wave form computers
  • a modem converts a digital signal to analog for transmission over the analog media 

​(c) Name two types of coaxial cables            (2mks)

  • thin net
  • thick net

(d) (i) Distinguish between microwave and satellite transmissions.  (2mks)

​Microwave transmission consists of point to point transmissions meaning a signal is divided through a focused beam from transmitter to receiver while satellite is usually launched into speck

​(ii) Give an example of internet protocol         (1mk)

  1. ICPIP [Internet Control Message Protocol]
  2. TCP [Transmission Control Protocol]
  3. IP [Internet Protocol]



Read More
0 Comments
Print Friendly and PDF

Describe three methods you would use in error detection during program testing

16/11/2021

0 Comments

 

(a)When invoicing customers, the invoice clerk has to work out the discounts allowable on each order. Any order over 20,000/= attracts a “bulk” discount of 7%. A customer within the trade is allowed 10%. There is also a special discount of 2% allowed for any customer who has been ordering regularly for over 2 years. Using a flowchart show clerical procedure for working out discount entitlement.

When invoicing customers, the invoice clerk has to work out the discounts allowable on each order. Any order over 20,000/= attracts a “bulk” discount of 7%. A customer within the trade is allowed 10%. There is also a special discount of 2% allowed for any customer who has been ordering regularly for over 2 years. Using a flowchart show clerical procedure for working out discount entitlement.

(b) Name the control structures you have used in the flow chart  (2mks)

  1. selection
  2. sequence

Describe three methods you would use in error detection during program testing

error detection methods
  • desk checking (dry-run)
    going through the program while still on paper 
  • using debugging utilities
    enter the program editor where syntax  errors are detected during translation
  • using test date
    ​carries out trial runs
  • various data variations and extreme including good and bad data are entered to see how the program would handle them

Read More
0 Comments
Print Friendly and PDF

A school has been advised to employ a database administrator. State three responsibilities of this personnel in the school.

15/1/2021

0 Comments

 


A school has been advised to employ a database administrator. State three responsibilities of this personnel in the school.

​(b) Explain two ways in which computers can be used in the transport industry. 
(c) Mary was advised to partition a hard disk for her computer. Explain two reasons that may have necessitated this. 
(d) Explain a reason for conducting each of the following studies in systems development:
(i) Schedule feasibility; 
(ii) Technical feasibility. 
RESPONSES
a) Possible responsibilities of a database admin in a school
  •  Carrying out school database backups.
  •  Recovering of lost school data incase of system failure.
  •  Ensuring the security and integrity of the school system.
  •  Adding new users to the school system and managing the user’s accounts.
  •  Designing and developing database application for the school.
  •  Updating or maintaining database for the school.
b) Ways in which computers can be used in a transport industry.
  •  Use of GPS to track vehicles, flights etc.
  •  Bookings to different destinations can be done through the use of computers ( online booking).
  •  The computers can also be used to reduce the speed of vehicles and bring sanity in the industry.
  •  Managing human resource involved in the industry.
c) Reasons for partitioning hard disk
  •  For security purposes, incase one partition fails the second partition remains functional.
  •  If she requires backup copies to be stored in the same hard disk.
  •  If she intends to install more than one operating system.
d) (I Schedule feasibility
  •  To determine if the proposed solution can be developed within the required time.
(ii) Technical feasibility
  •  To determine if the system can be supported by the available technology.
​(b) Explain two ways in which computers can be used in the transport industry. (c) Mary was advised to partition a hard disk for her computer. Explain two reasons that may have necessitated this. (d) Explain a reason for conducting each of the following studies in systems development: (i) Schedule feasibility; (ii) Technical feasibility.

Read More
0 Comments
Print Friendly and PDF

Distinguish between a microwave transmission and a radio transmission.

15/1/2021

0 Comments

 


Distinguish between a microwave transmission and a radio transmission.

​(b) Figure 1 shows a computer, network topology. Use it to answer the questions that follow.
​(b) Figure 1 shows a computer, network topology. Use it to answer the questions that follow.
(i)Identify the type of topology.
(ii) State the function of each of the parts labelled A and B. 
(c) A computer laboratory experiences power supply problems. Describe three power related problems that should be addressed.
RESPONSES
(i)Identify the type of topology. (ii) State the function of each of the parts labelled A and B. (c) A computer laboratory experiences power supply problems. Describe three power related problems that should be addressed.
b) (i) Bus topology
(ii) A - The Bus cable
  • It is a core section of the bus topology network which has all the nodes connected to it and data pass through it.
B — Terminator
  • It destroys data that does not reach its destination so that it doesn’t cause echo back.
c) Problems related to power that should be addressed
  •  Blackout: This is unexpected discontinuation of power supply in the laboratory.
  •  Power sage: Sudden drop of voltage levels that lasts less than a second.
  •  Transients! surge: High voltage flowing.
  •  Brownout: Partial blackout where there’s low voltage flow.
  •  Short circuit: live wires touching each other’s
  •  Loose connection, which may cause tripping or total power failure

Read More
0 Comments
Print Friendly and PDF

Describe three arithmetic errors that may occur during computerised data processing.

15/1/2021

0 Comments

 


Describe three arithmetic errors that may occur during computerised data processing.

​(b) Arnold a programmer intends to create a user input interface screen for a system. State three factors that he should consider. 
(c)With the aid of an example in each case describe the following types of maintenance.
(i) adaptive; 
(ii) perfective; 
(iii) corrective. 
RESPONSES
a) Arithmetic errors
 Truncation error
  • Results due, to shortening or leaving out part of a number or a word.
  •  Rounding off error
  • Arising by approximating a number by replacing it with a number that has fewer significant digits or one with zeros for its ending digits.
 Overflow error
  • Occurs when the results of a computation is larger than the allocated memory space. 
 Underflow error
  • Type of error occurs when the output is low small to be represented in the chosen format.
b) User interface design considerations
  •  Should be user friendly.
  •  Colour, fonts and layout should be appealing to the user.
  •  Consider a consistent layout in the entire system.
  •  Should prompt user clearly.
  •  Should capture the same number of items of date as indicated in the manual data capture form.
(c)Types of maintenance
(i) Adaptive
  • Type of maintenance that is done to make the system to adopt the changing technology e.g. changing the system because to new ois
(ii) Perfective
  • Type of maintenance done to make the system better in its operation e.g. adding a module in a system.
(iii) Corrective
  • Type of maintenance done to correct an error in the system e.g.wrong results during addition.
a) Arithmetic errors Truncation error Results due, to shortening or leaving out part of a number or a word. Rounding off error Arising by approximating a number by replacing it with a number that has fewer significant digits or one with zeros for its ending digits. Overflow error Occurs when the results of a computation is larger than the allocated memory space. Underflow error Type of error occurs when the output is low small to be represented in the chosen format. b) User interface design considerations Should be user friendly. Colour, fonts and layout should be appealing to the user. Consider a consistent layout in the entire system. Should prompt user clearly. Should capture the same number of items of date as indicated in the manual data capture form. (c)Types of maintenance (i) Adaptive Type of maintenance that is done to make the system to adopt the changing technology e.g. changing the system because to new ois (ii) Perfective Type of maintenance done to make the system better in its operation e.g. adding a module in a system. (iii) Corrective Type of maintenance done to correct an error in the system e.g.wrong results during addition.

Read More
0 Comments
Print Friendly and PDF

State two qualities of a good pseudocode.

15/1/2021

0 Comments

 


State two qualities of a good pseudocode.

  • should be short and clean precise
  •  should have start and end clearly shown.
  •  Statements should be clearly defined.
  •  should depict the logical flow of solving the problem.
  •  should not be ambiguous.
  •  it should be indented /neat / legibility

(b) With the aid of flowchart diagrams, describe each of the following programme control structures:
(i) sequence 
(ii) selection 

(i)Sequence
  • Program statements are executed one after the other in the order in which they appear.
(b) With the aid of flowchart diagrams, describe each of the following programme control structures: (i) sequence (ii) selection
(ii) Selection
(b) With the aid of flowchart diagrams, describe each of the following programme control structures: (i) sequence (ii) selection

​(c) Draw a programme flowchart that would accept three numbers and find their sum. If the sum is greater than 200. It adds 30 to the sum, otherwise subtracts 20 from the sum. The programme should then display the results. 

​(c) Draw a programme flowchart that would accept three numbers and find their sum. If the sum is greater than 200. It adds 30 to the sum, otherwise subtracts 20 from the sum. The programme should then display the results.

Read More
0 Comments
Print Friendly and PDF

Explain three ways in which an operating system provides data security in a computer system

14/1/2021

0 Comments

 


Explain three ways in which an operating system provides data security in a computer system

Access control:
  •  Deals with the problem of verifying /authenticating the identity of a user before permitting access to the request resource (e.g. use of passwords, user account);
Encryption
  •  Transforming data into an unreadable format so that they are safely transmitted;
Firewalls
  •  Filters out unwanted data and programs/criminals/hackers/malicoius persons;
Log files
  •  A means by which transactions in a computer system can be recorded thereby detering potential infiltrators;
  • Alerts
  •  Alerting a user when he/she is about to delete a file/folder.
(b)State two instances where observation is not a viable method of gathering data during system analysis stage. 
  •  When the analyst wants to collect confidential information,
  •  When there is a large group of people involved in the system,
  •  Where the people you want to gather information from are vastly dispersed
(c) (i) State the role of each of the following data communication devices:
I. repeater 
  •  A device used to re-construct data signal during data transmission to its original strength/amplify/boost/regenerate.
II. router. 
  •  It is a device used to facilitate movement of data or packets between two or more LANS of different configuration (expansion of networks).
  •  Delivers a packet/data directly to destination computers.
  •  Interconnects different networks/provides network services.
(ii) The figure below shows a network based on the bus topology.
(b)State two instances where observation is not a viable method of gathering data during system analysis stage. When the analyst wants to collect confidential information, When there is a large group of people involved in the system, Where the people you want to gather information from are vastly dispersed (c) (i) State the role of each of the following data communication devices: I. repeater A device used to re-construct data signal during data transmission to its original strength/amplify/boost/regenerate. II. router. It is a device used to facilitate movement of data or packets between two or more LANS of different configuration (expansion of networks). Delivers a packet/data directly to destination computers. Interconnects different networks/provides network services. (ii) The figure below shows a network based on the bus topology.
I. Identify the component labelled P.
  •  The component P is the terminator.
II. State the function of the component labelled P.
  •  Terminator in a backbone is used to prevent data signal from bouncing back/absorb signals.

Read More
0 Comments
Print Friendly and PDF

Figure 2 shows a block diagram of a computer system and its peripheral devices. Use it and answer the questions that follow.

14/1/2021

0 Comments

 


Explain two health issues that could arise from the use of unsuitable computer desk.

No.19.(a) Figure 2 shows a block diagram of a computer system and its peripheral devices. Use it and answer the questions that follow. (i)Name two devices that may be used for storing data for a long duration. 2GB HDD 32 MB Rom (ii) Name three peripheral devices that are used for input. Mouse Scanner CD drive (iii)Name two other devices that a Computer Aided Design (CAD) user might wish to add to the set up above in order to perform his tasks effectively. Digitizer Keyboard USB port 19 (b) A customer wishes to purchase a computer system. The customer can buy word processor, spreadsheet, database, and a drawing package separately or as an integrated package. State three reasons why the customer would prefer an integrated package to separate packages The software provides easy movement of data among the separate applications, A common group of commands is used for all the applications in the software package, Provides easy switching between functions without having to go back to the operating system and ability to share data between functions.
(i)Name two devices that may be used for storing data for a long duration.
  •  2GB HDD
  •  32 MB Rom
(ii) Name three peripheral devices that are used for input.
  •  Mouse
  •  Scanner
  •  CD drive
(iii)Name two other devices that a Computer Aided Design (CAD) user might wish to add to the set up above in order to perform his tasks effectively. 
  •  Digitizer
  •  Keyboard
  •  USB port
(b) A customer wishes to purchase a computer system. The customer can buy word processor, spreadsheet, database, and a drawing package separately or as an integrated package. State three reasons why the customer would prefer an integrated package to separate packages
  •  The software provides easy movement of data among the separate applications,
  •  A common group of commands is used for all the applications in the software package,
  •  Provides easy switching between functions without having to go back to the operating system and ability to share data between functions.

Read More
0 Comments
Print Friendly and PDF

Explain two health issues that could arise from the use of unsuitable computer desk.

13/1/2021

0 Comments

 


Explain two health issues that could arise from the use of unsuitable computer desk.

  • It could lead to back problems if the desk is of an unrealistic height.
  •  If it does not provide good positioning of the monitor, it could result in eye strain.
  •  Wrist problems will arise if the keyboard and mouse seating positions are bad.
  •  Injury as a result of falling computer components due to weak computer desks/ small size.
(b i)Describe two ways in which a positive number and a negative number can be represented in a computer 
  •  In binary one bit usually the most significant or leading bit is used to indicate either positive or negative,and store the unsigned binary representation of the magnitude in the remaining bits.
  •  Signed magnitude.
  •  Using the twos complement.
  •  Using the ones complement.
(ii) A particular computer stores numbers in a single 8-bit word.
Determine how the number 0.3125 base 10 would be represented. 
No.18.(a) Explain two health issues that could arise from the use of unsuitable computer desk. It could lead to back problems if the desk is of an unrealistic height. If it does not provide good positioning of the monitor, it could result in eye strain

Read More
0 Comments
Print Friendly and PDF

With the aid of a diagram, describe the Hierarchical Database Model.

13/1/2021

0 Comments

 


With the aid of a diagram, describe the Hierarchical Database Model.

With the aid of a diagram, describe the Hierarchical Database Model.
Data items are arranged in a tree like format.
  •  Access is through a single path and all from one single item called the root component
(b) List three factors that should be considered when developing a database application and give reasons why each should be considered.
Factors
  •  Complexity of data/user needs/user friendliness
  •  Security and integrity
  •  Complexity of DBMS
  •  Volume of data/size
  •  Software compatibility with existing DBMS
  •  Cost of the data base
Reasons
  •  Complexity of data - Complex data requires complex DBMS.
  •  Security and integrity - Data which is intended to be secured in terms of access, can be handled by complex DBMS which provides for such requirements.
  •  Complexity of DBMS - Complex DBMS do require complex skills, hence more training. It is therefore costly to run/use such system.
  •  Volume of data - Voluminous data require to be ran on stable application.
  • They also take up extra computer system resources.
  •  Software compatibility - enables pre-existing databases to be exported to the new one.
(c) (i) Name three types of validation checks during data entry in data processing.
  •  Field type/data type
  •  Field size
  •  Format
  •  Reasonableness
  •  Range constraint
  •  Presence check
(ii) Differentiate between primary key and index key as used in databases. 
  •  Any index key is a database feature used to speed up search and sort operations in a table; whereas
  •  A primary key is a field that enforces uniqueness in a table so that one record is not entered twice or a primary key is a field that uniquely identifies each record.

Read More
0 Comments
Print Friendly and PDF

Figure 1 shows a flowchart. Use it to answer the questions that follow.

13/1/2021

0 Comments

 


Figure 1 shows a flowchart. Use it to answer the questions that follow.

Figure 1 shows a flowchart. Use it to answer the questions that follow.
(a) Interpret the flowchart. 
(b) Write a pseudo code for the flowchart. 

Read More
0 Comments
Print Friendly and PDF

Explain two ways in which the use of internet could make reporting of corruption easier

10/1/2021

0 Comments

 


Explain two ways in which the use of internet could make reporting of corruption easier

(b) Explain two circumstances under which the use of wireless communication would be preferred in data communication. 
(c) Figure 2 is an extract of a spreadsheet showing what the students had targeted to score and the actual score in a computer remedial class.
(b) Explain two circumstances under which the use of wireless communication would be preferred in data communication. (c) Figure 2 is an extract of a spreadsheet showing what the students had targeted to score and the actual score in a computer remedial class.
A performance factor is obtained by subtracting the target score from the actual score and dividing the difference by the target score.
Write a formula that uses cell references only that would be entered in cell:
(i) D2 to compute the performance factor. 
(ii) E2 to display the statement ‘more remedials’ if the performance factor is less than zero, ‘exempted’ if the factor is greater than zero and ‘optional remedials’ if otherwise. 
(iii) D8 to display the best performance factor. ​​
RESPONSES
(a) Ways ¡n which internet makes reporting of corruption easier.
  •  Interactiveness: the internet based technology enables real-time dialogue hence instantaneous reporting of cases;
  •  Outreach: the technology allows the coverage of wide areas/can be reported from anywhere;
  •  Social mobilisation: It is easy to use technology to create a network with people or organisations with similar concerns;
  •  Anonymity: With use of the technology, it has become easy to report corruption cases without being known;
  •  Security: The message sent reaches the destination with less risk of being intruded.
(b) Circumstances when wireless is preferred
  •  When the targetted recipients are many and diverse e.g. different  platforms, devices, geographical locations.
  •  When the sender or receiver is mobile and it in practical to use wired media.
  •  When there is no space or it is inconvenient to lay cables e.g in a congested town.
  •  When the distance of travel is very big e.g extraterestial communication.
A performance factor is obtained by subtracting the target score from the actual score and dividing the difference by the target score. Write a formula that uses cell references only that would be entered in cell: (i) D2 to compute the performance factor. (ii) E2 to display the statement ‘more remedials’ if the performance factor is less than zero, ‘exempted’ if the factor is greater than zero and ‘optional remedials’ if otherwise. (iii) D8 to display the best performance factor. ​​
  • Use of the 1F function
  • First selection & output
  • Second selection & output
  • Last selection & output
(iii) = Max (D2:D7)

Read More
0 Comments
Print Friendly and PDF

List two techniques of acquiring electronic images to be used in a desktop publishing program.

10/1/2021

0 Comments

 


List two techniques of acquiring electronic images to be used in a desktop publishing program.

​(ii) Describe two layout guides in a desktop publishing program (DTP) that assist a user to place an object in a preferred position. 
(b) Explain three ways of ensuring that data submitted for processing is accurate.
(c)An engineering company requires a computer system to design roads and bridges.
Explain one suitable choice for:
(i) output device; 
(ii) software. ​
RESPONSES
(a) (i) Ways of acquiring images in DTP:
  •  Scanning;
  •  Picture capture via camera;
  •  downloading;
  •  getting from secondary storage.
(ii) Layout guides
  •  Ruler guides: a ruler on the edges of the page that guides a user to position objects and resize them;
  •  Margin guides: used to define page margins so that the user will be prevented from placing objects in non-printable areas of the page;
  • Column guides: Vertical lines used to divide a page into two or more columns;
  •  Row guides: Lines used to divide a publication page into two or more section to help structure the layout;
  •  Snap points: Positions on the screen where the object is stuck on.
(b) Ways of ensuring accuracy of data during data processing
  •  Data is stored in secondary storage in such a way that access to it is controlled.
  •  Encrypting of data before it is transmitted to minimize chances of it being compromised during transmission.
  •  Use of validation methods to ensure that data is correct at the point of input.
  • Use of direct data capture methods which eliminates human errors.
  •  Use of verification methods.
(c) (i) Output device: A plotter because it prints large size drawings to high precision.
(ii) A CAD software because it facilitates in the design of engineering drawings.
​(ii) Describe two layout guides in a desktop publishing program (DTP) that assist a user to place an object in a preferred position. (b) Explain three ways of ensuring that data submitted for processing is accurate. (c)An engineering company requires a computer system to design roads and bridges. Explain one suitable choice for: (i) output device; (ii) software. ​

Read More
0 Comments
Print Friendly and PDF
<<Previous
    COMPUTER STUDIES QUESTIONS AND ANSWERS

    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
    Analogue And Digital Systems
    Applications Areas Of Ict
    Areas-where-computers-are-used
    Auxiliary Storage Devices
    Basic-computer-set-up-and-cabling
    Binary Addition
    Binary Subtraction
    Career Opportunities In ICT
    Classification Of Computers
    Classification-of-computers
    Coaxial Cables
    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
    Definition-of-a-computer
    Desktop Publisher
    Development-of-computers
    DTP
    DVD
    Editing-and-formatting-a-word-document
    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 3 Mock Exams
    Form 4 Level
    Hands On Skills
    HARDCOPY OUTPUT DEVICES
    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-topology
    NON-IMPACT PRINTERS
    Octal
    Operating Systems
    Output Devices
    Paper 1
    Parts-of-a-computer
    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
    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
    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

    RSS Feed

Print Friendly and PDF

Primary Resources
  • K.C.P.E Past Papers
  • ​Pri - Primary 1 Level
  • Pri  - Primary 2 Level
  • Grade 1
  • Grade 2
  • Grade 3
  • Grade 4
  • Standard 5
  • Standard 6
  • Standard 7
  • Standard 8
  • English
  • Kiswahili
  • Social Studies
  • Science
  • Mathematics
  • Kenya Sign Language
  • I.R.E
  • ​H.R.E
  • Notes
  • Termly Questions
  • Mocks
  • K.C.P.E Past Papers
College Resources
  • E.C.D.E
  • P.T.E
  • D.T.E
  • Technical Diploma
  • Technical Certificate
  • Business Diploma
  • Business Certificate
  • Higher Diploma
  • K.A.S.N.E.B Resources
  • K.M.T.C Resources
  • Varsity Resources
Secondary Resources
  • K.C.S.E Past Papers
  • Form 1
  • Form 2
  • Form 3
  • Form 4
  • Term 1
  • Term 2
  • Term 3
  • English
  • Geography
  • History
  • C.R.E
  • I.R.E
  • ​H.R.E
  • Home Science
  • Computer Studies
  • Business Studies
  • Agriculture
  • Chemistry
  • Biology
  • Physics
  • Mathematics ALT A
  • Mathematics ALT B
  • Kiswahili
  • French
  • Germany
  • Arabic
  • Aviation
  • Art & Design
  • Drawing & Design
  • Building & Construction
  • Metal Works
  • Wood Work
  • Music
  • Kenya Sign Language
  • Electricity
Other Useful Links
  • Academic Environment
  • How its Done
  • News and Opinions
  • Manyam Franchise Support
  • About
  • SITEMAP
  • FOCUS A365 SERIES
  • Membership Details (KCPE/KCSE)
  • Secondary Mocks
  • SYLLABUS
Contact Us
Manyam Franchise
P.O Box 1189 - 40200 Kisii
Tel: 0728 450 424
Tel: 0738 619 279
Tel: 0763 450 425
E-mail - sales@manyamfranchise.com
Photos used under Creative Commons from wwarby, JoshMacDonald, Visual Content, wuestenigel, Homini:), Wonderlane, Mike Licht, NotionsCapital.com, The Official CTBTO Photostream, Nabor Garrido, picsaf.com, OER Africa, Jemimus, andronicusmax, Christoph Scholz, cyanocorax, matsuyuki, Mark Hodson Photos, cathyse97, tompagenet, ToGa Wanderings, crstnksslr, machernucha, panpot, ePublicist
  • Home
    • JOBS IN KENYA AND ABROAD FOR KENYANS AND BEYOND
    • How its Done
    • KNEC Portal
    • Atika School Advanced Search
    • News and Opinions
    • Academic Environment
    • KNEC KCSE PROJECT INSTRUCTIONS
    • SITEMAP
    • About Us? >
      • About Us
      • Learn more about us
  • OUR PRODUCTS
    • All Categories >
      • Category
      • FREE NOVELS >
        • COURSE BOOKS
        • KCSE KISWAHILI SETBOOKS
        • Backed Up Files and Archives
        • FREE DOCUMENTS
        • PRIMARY 8-4-4 BASED RESOURCES
        • STANDARD 8 RESOURCES
        • HIGH SCHOOL RESOURCES >
          • Biology Paper 3 Exams
          • Secondary Examinations
        • PRIMARY CBC BASED RESOURCES
        • COLLEGE & VARSITY RESOURCES
    • PRIMARY RESOURCES CBC
    • PRIMARY RESOURCES 8-4-4
    • SECONDARY RESOURCES
    • NOTES & TUTORIALS
    • COLLEGE RESOURCES
    • NOVELS and OTHER BOOKS
  • EXAMINATIONS
    • PRIMARY EXAMS >
      • Primary Assignments and Random Exams
      • CBC
      • 8-4-4
      • STANDARD 8 PAST PAPERS 8-4-4 BASED
    • MOCKS AND JOINT EXAMS >
      • FORM 1 QUESTION PAPERS, ANSWERS AND MARKING SCHEMES COLLECTIONS
      • FORM 2 QUESTION PAPERS, ANSWERS AND MARKING SCHEMES COLLECTIONS
      • FORM 3 EXAMINATIONS, QUESTION PAPERS AND ANSWERS
      • MOCKS PAST EXAMS BY REGION
    • KCPE >
      • KCPE BY YEAR >
        • KCPE 2020 RESULTS, REPORTS, QUESTIONS AND ANSWERS
        • KCPE PAST PAPERS 2019 REPORTS, RESULTS, QUESTIONS AND ANSWERS
      • KCPE PAST PAPERS PER SUBJECT
      • KCPE PAST PAPERS AND ANSWERS
      • KCPE MATHEMATICS TOPICAL QUESTIONS FROM 1989 TO LAST YEAR
    • KCSE >
      • KCSE BY YEAR >
        • KNEC KCSE PAST PAPERS, MARKING SCHEMES, QUESTIONS & ANSWERS
      • KCSE BY SUBJECT >
        • KCSE PAST PAPERS BY SUBJECT
        • Free KCSE Past Papers Mathematics
        • Free KCSE Biology Questions and Answers
    • QUESTIONS & ANSWERS >
      • SECONDARY >
        • LANGUAGES >
          • A DOLL'S HOUSE BY HENRIK IBSEN RESOURCES
        • TECHNICALS >
          • COMPUTER STUDIES >
            • COMPUTER STUDIES Q & A
            • kcse computer studies paper 2 AND 3 Questions & Answers
          • BUSINESS STUDIES QUESTIONS & ANSWERS
          • KCSE AGRICULTURE TOPICAL QUESTIONS AND ANSWERS
          • KCSE HOME SCIENCE DIRECT QUESTIONS AND ANSWERS
        • SCIENCES >
          • KCSE Mathematics Topical Questions
          • KCSE Biology Topical Questions and Answers
          • CHEMISTRY TOPICAL QUESTIONS AND ANSWERS
          • KCSE Physics Topical Questions
          • KCSE physics Practical Sample Quiz
        • HUMANITIES >
          • ISLAMIC RELIGIOUS EDUCATION (IRE) QUESTIONS AND ANSWERS
          • KCSE History Topical Questions and Answers
          • GEOGRAPHY TOPICAL QUESTIONS AND ANSWERS
      • PRIMARY >
        • Standard 4-8 Mathematics Topical Questions from Mocks and KCPE
        • Std 6 Mathematics Notes
  • TUTORIALS
    • SECONDARY >
      • SCIENCES >
        • FOCUS MATHEMATICS TUTORIALS AND EXAMS FREE
        • KCSE BIOLOGY NOTES
        • FREE KCSE CHEMISTRY NOTES
        • KCSE PHYSICS NOTES, AUDIOVISUALS AND MORE
      • LANGUAGES >
        • ENGLISH >
          • English KCSE Set Books
          • ENGLISH POETRY QUESTIONS WITH ANSWERS FOR K.C.S.E CANDIDATES
          • ENGLISH GRAMMAR #KCSE
        • CHOZI LA HERI - MWONGOZO
        • KIGOGO - MWONGOZO
        • USHAIRI MASWALI NA MAJIBU
        • MASWALI NA MAJIBU YA TUMBO LISILOSHIBA
        • KCSE Kiswahili Fasihi
      • TECHNICALS >
        • HOME SCIENCE NOTES
        • KCSE BUSINESS STUDIES NOTES
        • COMPUTER STUDIES NOTES LATEST
        • kcse Computer Studies Notes
        • KCSE AGRICULTURE NOTES, SYLLABUS, QUESTIONS, ANSWERS, SCHEMES OF WORK AND OTHERS
      • HUMANITIES >
        • KCSE History Notes Form 1 to 4
        • FREE KCSE CRE NOTES
        • KCSE GEOGRAPHY NOTES
        • IRE NOTES, AUDIOVISUAL, QUESTIONS AND ANSWERS
    • PRIMARY >
      • NOTES >
        • KISWAHILI
        • SOCIAL STUDIES >
          • STANDARD 4: SOCIAL STUDIES
        • SCIENCE
        • ENGLISH >
          • KCPE and Primary Level Compositions
        • MATHEMATICS >
          • KCPE Mathematics Notes
      • EXAMINATIONS >
        • DecaTurbo Online Series Examinations
        • CBC Kiswahili
        • FOCUS A365 SERIES K.C.P.E EXAMINATIONS FOR PRIMARY
        • Standard 8 (std) English Topical Questions
    • Other Supportive Documents >
      • Free Schemes of Work
      • SYLLABUS >
        • Primary 8-4-4 based Syllabus, Objectives and Lessons
        • Primary Mathematics Syllabus
      • MASOMO VIDEOS
  • CURRICULUM
    • NEW CURRICULUM DESIGNS >
      • PRIMARY >
        • PRE PRIMARY ONE CURRICULUM WITH SYLLABUS
        • PRE PRIMARY TWO CURRICULUM WITH SYLLABUS
      • SECONDARY >
        • KNEC KCSE SYLLABUS AND COURSE OUTLINES
      • COLLEGE >
        • Regulations for the TIVET Craft and Diploma Business Examinations
  • HIGH INSTITUTIONS
    • EXAMINATIONS >
      • College and Varsity Past Papers online
    • TUTORIALS >
      • COLLEGE AND UNIVERSITY NOTES AND TUTORIALS
  • CUSTOMER CARE
    • PRICING
    • Contact
    • Help & Support
    • DONATE
    • MPESA FORM
  • BLOGS
    • ENGLISH - EKEGUSII DICTIONARY
  • MEMBERSHIP RESOURCES
    • Assignments and Random Exams
    • TERM 3 2021 PRIMARY PAST REVISION PAPERS
    • SECONDARY EXAMINATIONS
    • Search Free Documents (PDF)
  • Archived Pages
    • C.R.E (CRE) QUESTION AND ANSWERS
    • TOP SECONDARY EXAMS ALL SUBJECTS