KCSE 2011 Computer Studies Paper 2 Questions with Marking Scheme

Share via Whatsapp

Computer Studies Paper 2

  1. The data in the tables below was extrcted from a survey data on employment
    Table 1: Employee Table
    Name Year of
    Birth
    Employee
    ID No.
    Employer
    ID
    Job
    Category
    Eric
    Fred
    Jane
    Brian
    Anne
    Cate
    Ali
    Janet
    Peter
    Marv 
     1980
    1970
    1984
    1976
    1973
    1968
    1990
    1998
    1992
    1993
    13114
    11100
    14010
    12110
    11410
    10570
    11040
    15978
    17192
    18965 
     01
    04
    02
    05
    03
    04
    05
    03
    02
    05
    GK4
    GK3
    GK1
    GK1
    GK2
    GK3
    GK3
    GK2
    GK4
    GK4
    Table 2: EMPLOYEE TYPE
    JOB CATEGORY JOB DESCRIPTION
    GK1
    GK2
    GK3
    GK4
     CASUAL
    TEMPORARY
    CONTRACT
    PERMANENT

    Table 3: EMPLOYERS TABLE
    EMPLOYER ID EMPLOYER NAME
     01
    02
    03
    04
    05
     WASIKE
    MUMBUA
    OMWOYO
    OLOISHIRO
    MWANYUMBA

    1.        
      1. Create a database named "EMPLOYMENT to store the data above. (14 marks)
      2. Create relationships between the tables.(4) marks)
      3. Use forms to enter data into the tables. (10 1/2 marks)
    2.              
      1. Generate a report to display the Name, year of birth, age and employer's name for the employees who will be over 30 years old by the year 2012 (10 marks)
      2. Compute the mean age of employees on the report you created in b(i) above.(2 marks)
    3.        
      1. Create a query to display the employees and their job description. Save the query as "EMPTYPE".(3 marks)
      2. Create a pie chart based on the query in c(i) above to display the proportions of employees in various job descriptions. Save the report as CHART.(3 marks)
    4. Print the:
      1. three tables:
      2. two reports:
      3. output of query results for EMPTYPE.(3 marks)
  2.                  
    1. Create a folder. The name of the folder should be the last three digits of your index number. Type the document below exactly as it appears using a word processing package and save it as LANGUAGE in the folder created. (15 marks)

      DATABASE LANGUAGES

      In the early years of database usage, they were accessed by writing programs in a high level procedural language such as COBOL. This required the skills of an experienced programmer who had a thorough knowledge of database design as well as familiarity with a language. As a result, access to databases was limited to those with procedural language skills.

      Modern databases can be accessed through easy-to-use query languages. Query languages are similar to English and require little programming knowledge. Commands entered through a computer terminal direct the machine to:
      Search files
      Make comparison
      Generate reports
      The utility of databases has greatly expanded because of query languages, even the users can easily access complex databases, searching out specific pieces of data and generating reports quickly and easily. Databases can be configured as follows, as single user database, multi-user database and as distributed database.
      For example, a distributed configuration structure is shown below:
      CompCS2011p2q2a
    2. Save a copy of the document created above as "FINAL LANGUAGE" in the folder created in (a) above and use it to answer parts (c) and (d).(1 mark)
    3.            
      1. Format the heading "DATABASE LANGUAGES" as follows:(5 marks)
        Alignment:Centre
        Font style: Bold and underline
        Font size: 16
        Font type: Arial
      2. Drop the first letter of the paragraph starting with the word "Modern" by four lines.(3 marks)
      3. Apply bullets to the list starting with the statement "Search files".(2 marks)
      4. Convert the paragraph starting with the utility of..." to two columns. (2 marks)
      5. Set the page margins as follows:
        1. Top = 0.7" (1.78)cm
          Left = 0.9" (2.29cm)(2 marks)
      6. Set the paragraph starting with "In the early..." such that the text is evenly aligned along both left and right margins. (1 mark)
      7. Correct the spelling errors. (1 mark)
      8. Set the line spacing of the paragraph starting with the word "The utility..." to 1.5. (2 marks)
      9. Move the first paragraph to come after the drawing. (2 marks)
      10. insert the following in the footer:(4 marks)
        1. A line of length 6" (15.24cm) long.
        2. Your name and index number.
    4.                  
      1. Create a table at the end of the document created in (b) above and enter the following data:(3 marks)
        #         DBMS               APPLICATION AREAS                      ESTIMATE COST
        1        MSACCESS            Small Enterprises                                24,000
        2          Oracle                Corporate Enterprises                        1,000,000
        3           MySQL                Medium Enterprises                                500
      2. Enter the beading "EXAMPLES OF DATABASES" as the entire first row of the table, (3 marks)
      3. Use a formula to find the average estimate cost of the DBMS applications in the table
      4. Save the document.(2 marks)
    5. Print the documents:LANGUAGE and FINAL LANGUAGE. (2 marks)

MARKING SCHEME

  1.      
    1.            
      1. Database created and named.(2 marks)
        • Creating of 3 tables x 1 mark.
        • 9 correct fields x 1 mark.
      2. Relationships:
        • correct fields between 2 tables @ 1 mark x 2
        • type between 2 tables @ 1 mark x 2
        • enforcing referential integrity in any relationship.
      3.              
        • Form created @ 1 mark x 3
        • Data entry per column x 1/2 mark 
        • selection of the correct object per table @ 1 mark x 3
    2.                 
      1.           
        • Query created:
          • correct tables
          • naming of the query
          • correct fields
        • Age computation:
          • use of formulae
          • use of correct formulae
          • expression (label)
          • use of criteria
          • correct criteria
        • Report:
          • Existence
          • Correct fields
      2.            
        • labels:
          • correct expression “average"
    3.        
      1.          
        • Correct tables
          • Correct fields
          • Name/saving
      2. Selection of correct graph
        • Selection of correct fields
        • Saving
      3. Printing
        •  the three tables / x3
        • query output (EMPTYPE) 1 x 12
        • two reports 2 x 12
  2.             
    1.      
      • Folder created:
        • existence
        • renaming
      • Five paragraphs
      • Graphics:
        • cylinder
        • shaded cylinder
        • arrowed lines
        • thickness of arrowed line
        • correct label
        • copies of cylinders
        • copies of arrows
        • Saving
    2. Saving:
    3.              
      1. centre alignment
        • font style = bold
        • font style = underline
        • font size = 16
        • font type = Arial
      2. Drop cap:
        • correct paragraph
        • drop capping
        • prop cap size = 4 lines
      3.             
        • Bullet applied
        • Application in correct lines
      4.           
        • Column applied
        • Application on correct paragraph
      5.      
        • Top margin set to 0.7"
        • Left margin set to 0.9"
      6.     
        • Alignment set to justification
      7. Spelling correction
      8.      
        • Line spacing set to 1.5
        • Application on the correct paragraph
      9.      
        • Movement of paragraph
        • Application on the correct paragraph
      10. Footer:
        • a line existence
        • line dimension = 6"
        • name and index
        • objects placed in the footer area
    4.            
      1. Table creation
        • Data entry
      2. Insert blank row
        • Entering the title
        • Merging cells
      3.     
        • Label and positioning
        • Formula [= average(ABOVE)]
      4. Saving [already awarded at (b)]
        {Note: no mark for saving in 2 (d)(iv)}
    5. Printing
      • language
      • final language

Download KCSE 2011 Computer Studies Paper 2 Questions with Marking Scheme.


Tap Here to Download for 50/-




Why download?

  • ✔ To read offline at any time.
  • ✔ To Print at your convenience
  • ✔ Share Easily with Friends / Students


Join our whatsapp group for latest updates
Get on WhatsApp Download as PDF
.
Subscribe now

access all the content at an affordable rate
or
Buy any individual paper or notes as a pdf via MPESA
and get it sent to you via WhatsApp

 

What does our community say about us?

Join our community on:

  • easyelimu app
  • Telegram
  • facebook page
  • twitter page
  • Pinterest