State advantages and disadvantages of the following system implementation strategies
Phased:
Advantages:
Disadvantages:
Pilot:
Advantages:
Disadvantages:
Direct:
Advantages:
Disadvantages:
Parallel:
Advantages:
Using an example, explain a difference between a primary key and a foreign key in a relational database.
A primary key is a table field that uniquely identifies each record and ensures that duplicate entries are not allowed
A foreign key is primary key of a parent table placed in a child table to ensure that any record added to a child table is related to the one in parent table.
A foreign key is a field (or a set of fields) in one table that refers to the primary key of another table. It is used to establish and enforce a link between the data in the two tables, ensuring referential integrity.
State the functions of the following:
Bridge: Joins together two networks that use the same base protocols.
Hub: Copies all packets of data to all devices on the network.
Router: Stores the addresses of computers on the network and transfers data between devices.
Switch : Analyses each data packet and sends it to the computer it was intended for.
State and briefly describe three program control structures
Sequence: Sequential execution of a program one line after another
Selection: Involve the a decision between two or more options e.g if...then...else
Loops/Repetitions: Used for looping i.e a line of code can be made to execute a given number times before terminating.
Explain how a magnetic hard disk drive (HDD) operates
Explain the difference between the sequential and parallel computational models.
Any four of:
Sequential:
• Individual instructions are executed one after another
• Flow control is accomplished by jump/branch/goto instructions
• Results are usually achieved less quickly than parallel processing (do
not award twice)
Parallel:
• Individual instructions can be routed to different processors for
simultaneous execution
• Results are usually achieved quicker than sequential instruction (do not
award twice)
• Requires multi-core processors or multiple microprocessors
• Tasks may be split into different parts with each part executed on a
different processor
• Results need to be merged back together after completion
What precaution would you take in a computer lab if humidity falls below normal for prolonged periods due to weather changes?
Use a humidifier: Using a humidifier can help maintain a consistent level of humidity in the computer lab, which can prevent the negative effects of low humidity.
Avoid dry air: Avoid creating a dry environment in the computer lab by opening windows or using fans to increase air circulation.
Regular maintenance: Ensure that all computer components are properly maintained and cleaned to prevent damage due to static electricity.
Backup data: Regularly backup all important data to avoid data loss in case of hardware failure caused by low humidity.
Monitor humidity levels: Use a hygrometer to monitor the humidity levels in the computer lab and take corrective measures if the levels fall below a safe range.
Use anti-static materials: Use anti-static mats or wristbands when handling computer components to prevent static electricity buildup.
Give two other uses of hexadecimal in computer science.
Maranda Mock CRE Paper 2 2024
c) Six ways in which Christians can assist the physically challenged members of the society (6mks)
Establishing special institutions for them
Donating equipment, which assists them in their movement.
Giving them vocational training
Assisting them in their daily chores
Accepting them as human beings like themselves
Helping them to develop their talents e.g. games, music, drama etc.
Identifying their abilities and giving them employment.
Encouraging relatives to live with them.
Giving them financial assistance to start income generating projects
a) The parable of the shrewd manager in Luke 16:1-33. (7mks)
There was a rich man who had a steward. He received charges that the steward was wasting his goods.
He called him what he was hearing about him. He told him to turn in account of his stewardship for he could no longer be steward.
The steward asked himself what he would do since his master was taking the stewardship away from him.
He was not strong enough to dig and was ashamed to beg.
He decided what to do so that people may receive him into their house when he is out of the stewardship
He was to summon his masters’ debtors one by one. He went to the first one and asked him how much he owned his master. The debtor said a hundred measures of oil, which he was told to write fifty.
He asked another how much he owned his master. He said a hundred measures of wheat he was told to write eighty
The master commended the dishonest steward for his shrewdness for the sons of his world are shrewder in dealing with their own generation that the ones light.
Seven causes of conflict between Jesus and the Jewish leader in Jerusalem. (7mks)
They questioned the authority Jesus was using to teach Lk 20:1-8.
Jesus accused them of persecuting and rejecting Gods servants in the parable of tenants. Lk 20:9-18.
They had conflict on the issue of whether to pay taxes to cease or not. Lk 20:19-26
The question on resurrection by the Sadducees on Levites marriage. Lk 20:27-39
He claimed to be the messiah and said that even David called Him Lord in the book of Psalms Lk 20:4-44
Jesus openly condemned the hypocrisy of the Jewish leader Lk 20:45-47
Jesus prophesied the destruction of temple of Jerusalem
He condemned the offerings of the rich Jewish leaders, which were meant to show off, but praised the widows’ offerings, which was made out of self-sacrifice Lk 21:1.
Six ways in which parents can resolve misunderstanding with their children. (6mks)
Allowing dialogue
Listening to their views
Presenting them with the correct, picture of the situation
Setting a good example to them
Giving them appropriate time for leisure activities
Seeking help from church leaders
Guiding them on how to choose friends
Advising them on the right moral values
Praying for and with them to bring about understanding
Committing the children to God’s will
Discussing the problem with their friends and relatives
a) Seven reasons why Jesus sent the Holy Spirit to the disciples after his ascension. (7mks)
The holy spirit would comfort the disciples
He was to counsel the disciples
He would guide the disciples on what is right / God’s righteousness
He was to convict people of their sins
He was to show disciples on what is right
He was to reveal the future / enable the disciples to prophet’s / God’s will
He would glorify Jesus through the work of the disciples
He would enable the disciples to witness Christ throughout the world
He would replace the physical presence of Jesus
He would empower the disciples to be able to speak with courage
b)How the unity of believers is expressed in the body of Christ? (8mks)
St Paul describes the believers as the body of Christ
Christ is the head of the church
The believers form parts of the body
The body has different organs, in the same way the church has different members
They all need to work together for the well-being of the church
Every part of the body is needed to make it whole/ all parts interdependent / one part cannot be without the other
The different church members are given different spiritual gifts by the holy spirit to carry out God’s work
Believers are united through baptism in the Holy Spirit.
c)The church in Kenya help to bring about the unity in the country. (6mks)
Assisting the government is developing a curriculum schools that teaches about patriotism
Advocating for peaceful co-existence among Kenyans
Fighting corruption, discrimination, tribalism, nepotism and all forms of favourism
Acting as a voice of reason among the ruling political class demanding their unity as a government
Assisting the less fortunate in the society thus fighting disparity
Condemning and reporting to the relevant authorized groups that bring disharmony in the society
Developing joint rallies, prayers and reconciliatory meetings together.
Forgiving one another to avoid disunity
Obeying church rules/ leaders
Chastity is a virtue
a) Attitude of Christian towards human sexuality. (7mks)
Sex is sacred
Man and woman are for companionship
Both man and woman are equal before God
It is for procreation
Man and woman are complementary
Man and woman were created in the image of God
They became one in marriage
Human beings have the ability to control sexual desire
All forms of irresponsible sex are condemned
Chastity is a virtue
b)Six ways in which sex is abused in Kenya today. (6mks)
Sex before marriage / fornication/ pre-marital sex
Sex outside marriage / adultery
Prostitution
Bestiality
Homosexuality/ lesbianism/ sodomy/oral sex
Pornographic literature/mass media using of technological devices in sex
Incest
Masturbation
Rape /defilement of minors
c)Why are minors sexually abused in Kenya today? (7mks)
Permissiveness
Lack of self-control
Influence of the mass media
Mental illness / stress/ drug and substance influence
Erosion of the African culture moral value
False religious / devil worship /strange cults
To avenge for oneself
Breakdown of religious values
Irresponsible parenthood
Indecent dressing
Leniency of the law
Idleness
Poverty / unemployment
6 a) Six practices in the African Society that promoted law, order and justice? (6mks)
Cultural taboos/dos and don’ts in the society
Kinship ties had rules which governed their relationships
Oaths – swearing while making agreements.
Rites of passage e.g. during initiation, the youth were taught laws/secrets of society.
Practice of rituals in the society promoted good relationships between the living/living dead.
Communal life i.e. “I am because we are, and since we are therefore Iamb.”
Inheritance of property was done fairly which brought justice /order.
Worship of God/veneration of ancestors created orderliness
b). Seven reasons for the need of law, order and justice in the society. (7mks)
In order to safeguard peoples personal rights.
To ensure security and protection of the people and their property.
To promote peace and harmony
To attract both local and foreign investment in the country
To promote peaceful relationship between countries.
To safeguard freedom of the citizens
To control and check the powers of those in authority
To enable the gov’t to implement its taxation policies effectively and to use the money
collected for the good of the community
To enable Christians worship God in peace and freely spread the good news.
c) Explain the factors which hinder effective maintenance of law and order in the (7 marks)
Increase in the rate of crime especially in urban areas
Political instability e.g. Post election violence
Greed for power and wealth
Political selfishness leading to dictatorship and despotism
High rate of unemployment leading to idleness / crime
Corruption especially by custodians of the law e.g. police.
Hypocrisy i.e. leaders misleading the society
High level of poverty forcing others into crime
Describe how a FRID works.
RFID stands for radio frequency identification. There is an RFID reader and tag.RFID is used in contactless credit and debit cards as well as in some hotel room cards. Inside an RFID tag is a chip that contains a small amount of memory. The chip is attached to a coil of wire which acts as an antenna. When an RFID tag is scanned, the reader emits radio waves which are picked up by the tag’s antenna. The power induced in the tag’s antenna from these waves is enough to power the chip which then uses its antenna to emit its own radio wave, which contains the information held on the chip. This wave is picked up by the reader which decodes the information and returns the information to a computer.
List three electronic data processing modes used in computers
Computer System Questions
Parallel data transmission
Serial data transmission
b) Give one benefit of each type of data transmission.
Serial
Give one application of each type of data transmission. Each application must be different
Parallel
Serial
State what is meant by the term USB
Describe two benefits of using USB connections between a computer and a device.
DVD - optical media which use one spiral track; red lasers are used to read and write data on the media surface; makes use of dual-layering technology to increase the storage capacity
ROM - non-volatile memory chip; contents of the chip cannot be altered; it is often used to store the start-up routines in a computer (e.g. the BIOS)
SSD/ Solid State Drive/memory (SSD): a non-volatile memory device that uses NAND flash memories (which consist of millions of transistors wired in series on single circuit boards)
Blue Ray - optical media that uses blue laser technology to read and write data on the media surface; it uses a single 1.1 mm polycarbonate disc
Viruses, pharming and phishing are all examples of potential Internet security issues.
Explain what is meant by each of these three terms.
Virus
Pharming - malicious code/software installed on a user’s hard drive/actual webserver
– this code redirects users to a fake website (without their knowledge)
– to obtain personal/financial information/data
Phishing - legitimate-looking emails sent to a user – as soon as the recipient opens/clicks on the link in the email/attachment, the user is directed to a fake website (without their knowledge) – To obtain personal/financial information/data
control bus- this bus carries signals used to coordinate the computer’s activities
address bus - this uni-directional bus carries signals relating to memory addresses between processor and memory
data bus - this bi-directional bus is used to exchange data between processor, memory and input/output devices
The seven stages in a von Neumann fetch-execute cycle
Modern LCD monitors and televisions use LED-backlit technology.
Give two advantages of using this new technology compared to the older cold cathode fluorescent lamp (CCFL) method
Describe how ICT is used in marketing
Jane has noticed the following problems with her computer (2mks)
State three possible causes of these problems and how they can be solved (3mks)
There could be several possible causes for the issues Jane is experiencing with her computer keyboard, including:
1. Software Issues
- Cause: Outdated or corrupt system files, drivers, or operating system.
- Solution:
- Ensure the operating system and drivers are up-to-date.
- Run a system file checker to repair any corrupted system files (e.g., on Windows, run "sfc /scannow" from the Command Prompt).
- Consider reinstalling the operating system if issues persist.
2. Hardware Issues:
- Cause: Physical damage or malfunction in the keyboard hardware.
- Solution:
- Check for physical damage or debris under the keys and clean the keyboard if necessary.
- If cleaning doesn't help, consider replacing the keyboard with a new one.
3. Resource Overload:
- Cause: The computer may be running too many background processes or lacking sufficient hardware resources.
- Solution:
- Close unnecessary background applications and processes to free up system resources.
- Consider upgrading the computer's RAM, CPU, or storage if it's outdated and unable to handle current software demands.
- Use task manager or activity monitor to identify and terminate resource-intensive processes.
4. Malware or Viruses:
- Cause: Malicious software can slow down a computer, cause hanging, and delay startup.
- Solution:
- Perform a full system scan using reputable antivirus or anti-malware software to remove any threats.
- Ensure that the operating system's security patches are up-to-date.
5. Disk Fragmentation:
- Cause: Fragmented files can slow down the loading of applications and overall system performance.
- Solution:
- Run a disk defragmentation tool (e.g., Windows' built-in tool) to optimize file storage on the hard drive.
- Consider upgrading to a solid-state drive (SSD) for faster application loading times.
6. Insufficient Storage:
- Cause: If the hard drive is nearly full, it can cause slow performance.
- Solution:
- Free up space by deleting unnecessary files and programs.
- Consider upgrading to a larger capacity hard drive or SSD if storage space remains an issue.
7. Background Processes and Startup Items:
- Cause: Too many unnecessary programs running in the background or starting up with the computer.
- Solution:
- Disable or remove unnecessary startup items and background processes to improve startup time.
- Use the Task Manager or System Preferences (on macOS) to manage startup items.
It's important to diagnose the specific cause of the issues Jane is facing by troubleshooting each potential problem one by one. In some cases, a combination of these solutions may be necessary to fully resolve the problems with her computer keyboard.
State two ways of protecting computers against viruses.
Explain the following terms
(a) Disk mirroring
(b) Encryption
(c) Backup
(a) Disk mirroring- Data is written on two or more disks simultaneously.
(b) Encryption - Contents are scrambled so they cannot be understood without a decryption key
(c) Backup - A copy of the data is taken and stored in another location
Describe how the denial of service strategy works to compromise the security of networks.
5 Artificial intelligence is an emerging trend in computer science.
(a) Discuss the use of artificial intelligence by describing some of its characteristics, the ways in which it may be used and the ethical issues associated with its use.
Branch of computer science based on enabling computers to
behave like humans/mimic aspects of human intelligence
• AI is implemented in software.
• Combines psychology, biology, linguistics, mathematics, neuroscience,
and philosophy (ethics)
• AI is not the same as the general intelligence of human beings
Uses – Any of the following:
• Game playing (chess, quiz, video games)
• Analytics (analyse buying patterns, predicting behaviours, predictive
text, financial markets)
• Image processing (recognising objects/patterns)
• Logistics (scheduling, order fulfilment)
• Control systems (cars, manufacturing, weapons, navigation)
• Expert systems (medical, mechanical, electrical diagnosis)
• Neural networks (simulating neuron behaviours as in brains)
• Natural languages processing (chatterbots, chatbots, speech
recognition)
• Robotics (dangerous situations, help aged or disabled)
Ethical issues – Any of the following:
• Take the work of humans, thereby affecting employment rates
• Is a computer to be trusted to make decisions (life-death)?
• If a computer discovers something that humans can’t prove, should it be
accepted as truth?
• Do AI machines have rights?
• Will people be comfortable interacting with machines that are
considered intelligent?
Name three types of cables used in data communication
Twisted pair cables
Coaxial cables
Fibre optic cables