Computer Studies Paper 2 Questions and Answers - BSJE Mock Exams 2023

• Write your name and index number on the CD/Removable storage medium provided.
• Write the name and version of the software used for each question attempted in the answer sheet provided.
• Answer all the questions.
• All questions carry equal marks.
• Passwords should not be used while saving in the CD/Removable storage medium.
• All answers must be saved in your CD/Removable storage medium.
• Hand in all the printouts and the CD/Removable storage medium used.
• Candidates should answer the questions in English

                                                                                       Question One

                             The data in the tables below were extracted from Bondo Sub county Games Management system. 

Table 1: TEAMS TABLE 

Table 2: RESULTS TABLE 

1. Create a database named Football to store the data above.                                         (12marks)
2. Format the Reg. Fee field as follows:
   1. To display the entries with the prefix: “KSh.”Correct to two decimal places.          (2marks)
   2. Restrict entries to positive values only and should return an error message “Error: enter positive values only” if an out of range value is entered.         (2marks)
3. Validate Team Code to 2 characters only.                                                                      (2marks)
4. Create a suitable table relationship between the tables.                                                 (3marks)
5. Design a form for each table and use it to enter the data into the tables.                       (9marks)
6. Create a query named TotalGamesQuery to display the fields: Team Code, Team Name and Total games played.  (4 marks)             
7. Create a query to show the team name and total points. (Note: A Win in a game earns team 3 points, a draw 1 point and a loss 0). The query should show the 3 best teams based on the total points. Save the query as BestTeamsQuery.  (5 marks)                     
8. Create a report named RegReport to display the Team Name, Address, Reg. Fee. The report should show the total registration fee collected from all teams.         (5marks)
   1. Sort the records to show the team that has paid the highest amount of registration fee first.  (2 marks)                                           
   2. Title the report as “income from registration”.                                          (2 marks)
9. Print each of the following:                    (2marks)                           
   1. Teams table and Results table 
   2. TotalGamesQuery and BestTeamsQuery RegReport.

Question Two 

(a) Type the following passage using a word processing package and save as Networking. Answer the questions that follow. (25marks)

COMPUTER NETWORK

A Computer network is a group of computers and other devices connected together by a suitable media.

Advantages of computer Networks 

1. Multiple users can communicate, exchange and share information
2. Resource sharing including program, data base, hardware etc. is possible 
                                                    
   By definition communications refers to the transfer of information from one place to another between two individuals using agreed symbols, signs or even human behavior such as nodding. Exchange of information relies on a communication system to convert, amplify and send signal through a common medium. Message, Sender, Medium and Receiver are the essential components of communication systems. If a system is extended by cascading more communication systems, it is called networked systems.
   
   In case communication involves the sending of information over a significant distance, it must use telecommunications as an aid. By definition, telecommunications refers to the transmission of information between distant locations by some electromagnetic means.
   
   Data communications is defined as the interchange and processing of encoded (digital that is, 1s and 0s) information between distant locations using telecommunications.
   
   Data communications is regarded as the collection and distribution of the electronic representation of information which can be text, voice, graphics or image, from and to remote computing facilities. As information can only be carried to the remote site provided that the information carrier supports that particular type of data transmission, information may undergo data conversion processes if the nature of data signal is incompatible with the characteristics of the signal carrier.
   
   Communication networks are usually defined by their size and complexity. We can distinguish four main types:
   • Local area networks (LAN). These networks connect computer equipment and other terminals distributed in a localized area, e.g. a university campus, factory, office. The connection is usually a cable or fibre, and the extent of the cable defines the LAN.
   • Metropolitan area networks (MAN). These networks are used to interconnect LANs that are spread around, say, a town or city. This kind of network is a high speed network using optical fibre connections.
   • Wide area networks (WAN). These networks connect computers and other terminals over large distances. They often require multiple communication connections, including microwave radio links and satellite.

COMPARISON AMONG DIFFERENT TOPOLOGIES 

Below are the advantages and disadvantages of various LAN topologies. 

TRANSMISSION MEDIA
Transmission can be by cable or wireless methods. There are 3 common types of cable: 

• Twisted pair,
• Co-axial
• Fiber optic.
  Wireless transmission includes:
• Microwave transmission.
• Satellite transmission.
• Radio waves transmission.
• Infrared transmission.

TWISTED PAIR

Consists of two insulated copper wires arranged in a regular spiral pattern to minimize the electromagnetic interference between adjacent pairs

Often used at customer facilities and also over distances to carry voice as well as data communications.

TWISTED PAIR ADVANTAGES

• Inexpensive and readily available
• Flexible and lightweight
• Easy to work with and install

TWISTED PAIR DISADVANTAGES

CO-AXIAL ADVANTAGES

Higher bandwidth

• 400 to 600Mhz
• Up to 10,800 voice conversations
• Can be tapped easily (pros and cons)
• Much less susceptible to interference than twisted pair

CO-AXIAL DISADVANTAGES

• High attenuation rate makes it expensive over long distance
• Bulky
• Greater capacity (bandwidth of up to 2 Gbps)
• Smaller size and lighter weight
• Lower attenuation
• Immunity to environmental interference
• Highly secure due to tap difficulty and lack of signal radiation

FIBER OPTIC CABLE

• Relatively new transmission medium used by telephone companies in place of long-distance trunk lines
• Also used by private companies in implementing local data communications networks
• Require a light source with injection laser diode (ILD) or light-emitting diodes (LED)

ADVANTAGES OF FIBER OPTIC

• Greater capacity (bandwidth of up to 2 Gbps)
• Smaller size and lighter weight
• Lower attenuation
• Immunity to environmental interference
• Highly secure due to tap difficulty and lack of signal radiation

DISADVANGES OF FIBER OPTIC

• Expensive over short distance
• Requires highly skilled installers
• Adding additional nodes is difficult

(B) Required:

1. Open a new document then copy and paste the content of Networking on the new document (2marks)
2. Save the new document as Networking Edited.                                                          (2marks)
3. Change the title  Computer Network as follows.                                                         (4marks)
   • Alignment – Centre
   • Font Size – 23
   • Font colour - Red
   • Font type –Elephant
   • Kerning -12 point
   • Spacing – Expanded
   • Scale- 100%
   • Position- Raised
4. Convert the paragraphs immediately under Communications into a hanging indent.(2marks)
5. Insert your name into the passage as a footer and Index number at the Header.         (4 marks)
6. Convert the paragraph under Classification of communication networks to two columns and justify them.    (4 marks)                       
7. Insert Water mark a cross the page the page “ COMPUTER NETWORKING “    (2marks)
8. Change the Drop cap lines to two.              (1mark)
9. Insert page border using the following setting.               (2marks)
   • Border – Shadow
   • Border – Three line
   • Colour -  Orange
10. Print the document networking and Networking Edited.                                             (2marks)

                                                                               MARKING SCHEME