KCSE 2018 Computer Studies Paper 2 with Marking Scheme

QUESTIONS

1.                        
   1. In a school, students reside in three dormitories Red, Blue and Orange. Each dormitory is managed by a patron and each student is required to register for a game.
      1. Open a database program and create a database named schoolgames that would be used to manage the games.(1 mark)
      2. Create the tables named; Student, Patron, Dormitory and Game in the database created in (i) using the following specifications.(7 marks)
         Student Table
         

         Field name	Description
         StudNo	Contains unique registration code
         Studname	Contains the name of a student
         Gamecode	Contains codes of each game
         Dormcode	Contains codes of each dormitory

         Patron Table
         

         Fieldname	Description
         Patroncode	Contains the patron code
         Patronname	Contains the patron name

         Dormitory Table
         

         Field name	Description
         Dormcode	Contains the dormitory code
         Dormname	Contains the dormitory name
         Patroncode	Contains the dormitory patron code

         Game Table
         

         Field name	Description
         Gamecode	Contains the game code
         Gamename	Contains the name of the game

      3. Create the relationships between the tables.(3 marks)                   
   2. 1. Create a form for each table that would be used for data entry.(2 marks)
      2. Enter the following data into their respective tables:(9 marks)
         Student Table
         

         StudNo	Studname	Gamecode	Dormcode
         K001	Anne	Gm004	D003
         K002	Chris	Gm003	D001
         K003	Jared	Gm001	D002
         K004	Julian	Gm004	D003
         K005	Marion	Gm001	D003
         K006	Janet	Gm002	D003
         K007	Tom	Gm002	D002
         K008	Jerry	Gm003	D002

         Patron Table
         

         Patroncode	Patronname
         P001	Maurice
         P002	Edward
         P003	Jane

         Dormitory Table
         

         Dormcode	Dormname	Patroncode
         D001	Red	P001
         D002	Blue	P002
         D003	Orange	P003

         Games Table
         

         Gamecode	Gamename
         Gm001	Basketball
         Gm002	Volleyball
         Gm003	Table tennis
         Gm004	Netball

   3. Create a query to extract each of the following details:
      1. StudNo, Studentname and Gamename for all students who reside in the Orange dormitory or play Basketball. Save the query as orangeq.(5 marks)
      2. StudNo, studentname, gamename for the students whose studentname start with letter "J". Save the query as Jquery.(3 marks)
   4.                        
      1. Create a tabular report showing the StudNo, Studentname, Dormname, Patronname, Gamename and grouped by Gamename. Save the report as reportgame.(8 marks)
      2. Format the report created in (i) as follows:
         1. Replace the report title with the text "players for each game"(1 mark)
         2. Enter your name and index as a report footer.(2 marks)
         3. Bold the dormitory names in the report.(2 marks)
   5. Print out each of the following:
      1. Student, Patron, Game and Dormitory tables
      2. Jquery and orange
      3. reportgame (7 marks)
2.                      
   1.                        
      1. Open a word processing program and key in the following text as it appears. Save the documents as socialnetwork.(11 marks)
         SOCIAL NETWORKING
         Social networking platforms are used by organisation to improve communication and productivity by disseminating information among different groups of employees in a more efficient manner. The advantages and disadvantages of social media are as follows.
         • Advantages
           • Facilities open communication.
           • Allows employees to discuss ideas.
           • Provides an opportunity to widen business contracts.
           • Targets a wide audience.
           • Improves business reputation and client base.
           • Expands market research.
         • Disadvantages
           • Susceptible to fraud
           • Potentially results to hate speech
           • Destructs normal business operations
             Employers do have the right to ban computer activity that is not work related, this approach may not yield optimal results. If employees are to be allowed access to social networking platforms then a comprehensive and well defined policy should be established to prevent abuses.
      2. Format the document as follows:
         1. Title: Font size 18pts, font colour red, font type Tahoma. (3 marks)
         2. Apply double line spacing for the text under the sub title "Advantages".(2 marks)
         3. Apply a 4 lined drop cap on the first letter of first paragraph. (3 marks)
         4. Apply a two-columns format with a line between for the text with the two subtitles such that "Advantages are to the left column and "Disadvantages are in the right column.(4 marks)
         5. Apply bold, italic and underline to subtitles "Advantages" and "Disadvantages".
      3. Apply the following format to the document: (3 marks)
         1. Insert a water mark with the text social media" on the document of a font size of 20 and running diagonally from left to right. (4 marks)
         2. Insert page numbers at the bottom centre of every page. (2 marks)
         3. Insert the text social networks" as a header aligned to the right. Apply italies to the header.(3 marks)
   2. The following is a letter from a Principal of Malimali school to other Principals inviting them for a seminar at the country education offices.
      1. Open a new document and create the following as it appears. Save the document as Malimali(2¹/₂ marks)
         
         The Principal
         <<School>>
         
         Dear Sir
         
         RE: SEMINAR MEETING
         You are invited to attend the Principal's seminar which is scheduled to be at the county education office on the 2nd of June 2015. You are booked to be in <<Room>>
         
         We are looking forward to a successful event.
         
         Yours Faithfully
         
         Lilango Jotema
         Malimali School Principal
      2. Use a mail merge feature to generate customised mails for the addresses shown in the following table. Save the mail merged document as Aletters. (9¹/₂ marks)
         

         School	Room
         Ginga school	Room 6
         Lubi school	Room 8
         Trans school	Room 10

   3. Print out each of the following:
      1. socialnetwork
      2. Malimali
      3. Aletters (3 marks)

MARKING SCHEME

1.                            
   1.                          
      1. Creating the database file @1
      2. Creating of tables (at least 3) @¹/₂
         Student table
         ✓4 Fields each @¹/₂=2
         Patron table
         ✓2 Fields each @¹/₂=1
         Dormitory table
         ✓3 Fields each @ ¹/₂ =1¹/₂
         Games table
         ✓ 2 Fields each @ ¹/₂=1
      3. Relationship at least 3 each @ 1
   2.                  
      1. 4 forms for each table each @¹/₂=2
      2. Entering data into the tables
         Student table
         ✓ 8 records each @¹/₂ =4
         Patron table
         ✓3 records each @ ¹/₂ -1¹/₂
         Dormitory table
         ✓ 3 records each @ ¹/₂ =1¹/₂
         Games table
         ✓ 4 records each @ ¹/₂ =2
   3.                      
      1. Creating the orangeq query
         ✓ Invoking the use of query@ 1
         ✓ selecting the fields @1
         ✓Criteria applied to the fields @2
         ✓ Saving the query @ 1
      2. Creating the jquery query
         ✓ Invoking the use of query @ 1
         ✓ Criteria (letter j) @ 1
         ✓ Saving the query @ 1
   4.                      
      1. Creating the report
         ✓ Using the report feature @1
         ✓ selecting the report fields @ 1
         ✓ selecting the 4 fields each @ 1=4
         ✓Grouping @1
         ✓ Saving the query @ 1 
      2.                
         1. Replacing the report title @ 1
         2. Entering name and index as report footer
            ✓ Name and index @ 1
            ✓ Position the items in the footer @1
         3. Bolding the text
            ✓ Selecting the text @1
            ✓ applying bold format @ 1
   5. Printing 
      1. 4 Tables each @ 1-4 
      2. 2 queris each @ 1=2 
      3. the report @1
2.      
   1.                                        
      1. Typing the story
         ✓ Title @ ¹/₂
         ✓Centering the title @ ¹/₂
         ✓ First paragraph @2
         ✓ Paragraph under advantages @ 2
         ✓ Paragraph under disadvantages @ 2
         ✓ Last paragraph @2
         ✓ Bullets used in the advantages @¹/₂
         ✓ Bullets used in the disadvantages @¹/₂
         ✓ Saving @1 
      2.                  
         1. Formatting the title
            ✓ Font size 18 @1
            ✓ Font colour=red @1
            ✓ Font type tahoma @1 
         2. Double underline
            ✓ Selection of text under advantages @1
            ✓ Applying double space @1 
         3. Drop cap
            ✓ Selection the first letter @1
            ✓ Using drop cap feature @1
            ✓ Dropping through 4 lines @1 
         4. Two columns
            ✓ Selection of text @ 1
            ✓ Using the column feature @1
            ✓ applying a line between the columns @1
            ✓ Advantages to the left @ ¹/₂
            ✓ Disadvantages to the right @ ¹/₂
         5. Formats applied on subtitles
            ✓ Bold@1
            ✓ Italics @1
            ✓ Underline @ 1 
      3.                        
         1. Water marks
            ✓ Using the watermark feature @1
            ✓ Typing the text social media in the watermark field @1
            ✓ Font size=20 @1
            ✓ Direction (Diagonal left to right) @ 1
         2. Page numbering
            ✓ Using page numbering feature @ ¹/₂
            ✓ Inserting page numbers @ 1
            ✓ Centering the pages horizontally @¹/₂ 
         3. Header
            ✓ Using the header field @ ¹/₂
            ✓ Typing the text in the header field @ 1
            ✓ Alignment at the right @ ¹/₂
            ✓ Applying italics @1
   2.                      
      1. Main document
         ✓ Typing text @ 1
         ✓ Applying formats @ ¹/₂
         ✓ Saving the document @1
      2. Main document
         ✓ Creation of datasource @3
         ✓ Saving the datasource @ 1
         ✓ Using the mail merge feature @4
         ✓ Inserting the 2 fields at each @1 =2
         ✓ Generating the merged document 2
         ✓ Saving the merged document @ 1
   3. Printing the word documents
      ✓ Social network@1
      ✓ mail merge @1
      ✓ counsel letter @1