Computer Studies Paper 2 Questions and Answers - KCSE 2021 Past Papers

1.  
   1. Open a word processing program and type the following passage as it appears. Save the document as GIS1. (20 marks)
      PURPOSE OF GEOGRAPHICAL INFORMATION SYSTEMS
      People want to understand their own individual environment. By environment, we mean the geographical space of their study area and the events that take place.
      For example:
      1. an urban planner may want to know about city population, traffic etc.
      2. a biologist may want to understand the population of animal species.
      3. a geologist may want to study about building site areas, minerals deposits etc.
      4. a hydrologist may be interested in water quality, land physiographic features, runoff generation etc.
         All these professionals require data that relates to space and typically involving positional data. Positional data determines where things are, where they were or will be in future.
         

         QUESTIONS A GIS CAN ANSWER
         A	Location	What is at a given location?
         B	Condition	What are the locations where certain conditions are met?
         C	Trends	What are the differences within an area over time?

         
         A location may be described using place name, postcode, or geographic reference such as latitude/longitude, or x and y coordinates and may include:
         
         • Location where certain conditions are satisfied are such as:
           • Un-forested section measured in square units of area.
           • Distance from the roads.
         • With soils suitable for supporting buildings.
           Trends seek to find the differences for example in land use or elevations within an area over a period of time.
           
   2. Create a copy of the passage into a new blank document and save it as GIS2. (2 marks)
   3. Perform each of the following on the document:
      1. Format the passage title as follows:
         1. Font size 20      (1⁄2 mark)
         2. Apply an outline effect   (1⁄2 mark)
      2. Apply a two lines drop cap to the first two characters of the first paragraph.   (2 marks)
      3. Apply indent format to the listed numbered and bulleted lists of size 3 cm from the left and 1.5 cm from the right. (4 marks)
      4. Apply each of the following to the bulleted and numbered lists:
         1. Line spacing of 1.5 (2 marks)
         2. Justified alignment (2 marks)
      5. Apply two columns layout with line between. The first column should contain the information between the table structure and the sub-heading "Functional components of GIS". The second column should contain the rest of the information from the "Functional Component of a GIS". (3 marks)
   4.  
      1. Convert the table structure to text separated by tab characters. (2 marks)
      2. Apply each of the following to the structure chart drawn:
         1. Group to all the objects of the drawing. (1 mark)
         2. Shadow effect to the grouped object.  (1 mark)
         3. An automatically numbered caption with text "Components of GIS".  (2 marks)
   5.  
      1. Enter your name and your index number at the page footer aligned to the right. (2 marks)
      2. Apply a page border line of width 3pt. (2 marks)
      3. Apply automatic upper case roman page numbering at the top centre of the page
   6.  Save the changes and print out later each of the following documents:  (2 marks)
      1. GISI
      2. GIS2      (2 marks)
2. A group of youths decided to invest together. They intend to use a database management system to manage their shares.
   1. Open a database program and create a database named Pamoja.  (1 mark)
   2.  
      1. Create a table named Membership in the database created in 2(a). The table should have the following fields and respective specifications.   (8 marks)
         

         Field Name	Data Type	Properties
         MemNum	Text	Size 4 (primary key)
         FirstName	Text	Size 10
         LastName	Text	Size 10
         DateofBirth	Date/Time	Short date
         Gender	Text	Look up from a listbox with values "Male", "Female"

      2. Create a second table named Contributions having the following fields and respective specifications. (10 marks)
         

         Field Name	Data Type	Properties
         RefNumber	Text	Size 4 (primary key)
         MemNum	Text	Lookup from membership table
         Amount paid	Currency
         DatePaid	DatePaid
         PaymentMode Text	Text	Lookup from a list box with values "Cash", "Cheque", "Mobile Money"

      3. Create a relationship between the tables and enforce referential integrity constraints to the relationship. (2 marks) 
   3.  
      1. Create a form for each of the table created. Savehe forms as MForm and Contriform respectively.(2 mark
      2. Enter the following data into their respective tables. (8 marks)
         Member ship table
         

         MemNum	FirstName	LastName	DateofBirth Gender	Gender
         SHI	Maureen	Antonio	31/12/2001	Female
         SH2	Jacob	Andela	24/09/2001	Male
         SH3	Charles	Zablon	01/09/2001	Male
         SH4	Judy	Alexander	14/02/2002	Female
         SH5	Isaac	Marion	04/08/2001	Male

         
         Contributions Table
         

         RefNumber	MemNum	Amount Paid	DatePaid	PaymentMode
         1	SH1	10,000	27/04/2018	CASH
         2	SH2	8,000	28/04/2018	MOBILE
         3	SH3	9,000	30/04/2018	CASH
         4	SH4	12,000	27/04/2018	CASH
         5	SH5	11,000	28/04/2018	MOBILE
         6	SH1	15,000	28/05/2018	CHEQUE
         7	SH2	11,000	29/05/2018	MOBILE
         8	SH3	9,500	30/05/2018	CHEQUE
         9	SH4	7,500	28/05/2018	CASH
         10	SH5	11,000	27/05/2018	CHEQUE
         11	SH1	7,000	29/06/2018	CASH

   4. Create a query that would display the following fields:
      1. MemNum, FirstName, Last Name, Gender and a calculated field named Umri to display the age of each member. Save the query as AgeQ.  (4 marks)
      2. MemNum, LastName, Amount Paid and a calculated field named Dividends which would display 14% for each Amount Paid. Save the query as DividendsQ.  (4 marks)
   5.  
      1. Create a report based on the query DividendsQ showing all the fields in the query and the following:
         1. Total AmountPaid by each member.
         2. Total Dividends payable to each member.
         3. Grand Totals of AmountPaid and dividends payable.    (6 ½ marks)
      2. Modify the report to appear as follows:
         1. To have a report title "DIVIDENDS FOR THE YEAR ENDED 31 DECEMBER 2018". (1 mark)
         2. Underline the report title. (1⁄2 mark)
         3. Save the report as "Year EndRPT"   (1⁄2 mark)
   6. Print out later each of the following:
      1. The two tables   (1 mark)
      2. The two queries  (1 mark)
      3. The report.   (1⁄2 mark)

MARKING SCHEME