KCSE 2011 Computer Studies Paper 2 Questions with Marking Scheme

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 ¹/₂ 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:
      
   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