Computer Studies Paper 2 Revision Papers {Practical Exams Papers}

NAME: ________________________________________________________ADM NO: ___________

SCHOOL: ____________________________________________________SIGNATURE: _________

DATE: ______________________

451/2

COMPUTER STUDIES

PAPER 2 (PRACTICAL)

TIME: 2½ Hours

 

DIOCESE OF KAKAMEGA

MUKUMU DEANERY JOINT EXAMINATION

FORM THREE

JULY 2021

Term 3

 

INSTRUCTIONS TO CANDIDATES

  1. Create a folder on the desktop of the PC you are using and label it using your Name or Adm No.
  2. Save all your work in the folder created
  3. Answer ALL questions
  4. All questions carry equal marks
  5. DO NOT USE PASSWORDS

 

 

 

 

 

 

 

 

 

 

 

 

 

 

This paper consists of 4 printed pages. Pre-candidates should check the question paper to ascertain that all the pages are printed as indicated and that no questions are missing.

 

 

QUESTION ONE

  1. Using a word processing program reproduce the work below and save the document as Geometry One       [32 Marks]

History of Geometry

Egyptians c. 2000 – 500 B.C.

A

ncient Egyptians demonstrated a practical knowledge of geometry through surveying and construction projects. The Nile River overflowed its banks every year, and the river banks would have to be re-surveyed. See a PBS Nova unit on those big pointy buildings. In the Rhind Papyrus, pi is approximated.

 

Babylonians c. 2000 – 500 B.C.

Ancient clay tablets reveal that the Babylonians knew the Pythagorean relationships. One clay tablet reads“4 is the length and 5 the diagonal. What is the breadth? Its size is not known. 4 times 4 is 16. 5 times 5 is 25. You take 16 from 25 and there remains 9. What times shall I take in order to get 9? 3 times 3 is 9. 3 is the breadth”.

 

Greeks c. 750-250 B.C.

Ancient Greeks practiced centuries of experimental geometry like Egypt and Babylonia had, and they absorbed the experimental geometry of both of those cultures. Then they created the first formal mathematics of any kind by organizing geometry with rules of logic. Euclid’s (400BC) important geometry book The Elements formed the basis for most of the geometry studied in schools ever since.

 

The Fifth Postulate Controversy c. 400 B.C. – 1800 A. D.

 

There are two main types of mathematical (including geometric) rules: postulates (also called axioms), and theorems.Postulates are basic assumptions – rules that seem to be obvious and are therefore accepted without proof. Theorems are rules that must be proved.

Euclid gave five postulates. The fifth postulate reads: Given a line and a point not on the line, it is possible to draw exactly one line through the given point parallel to the line.

 

 

Geometry Today

Today geometry has a wide range of applications. Amongst the applications it is used for includes: Building and construction, Mechanical plant engineering, Art and design. For example, the drawings below have been reproduced using geometry.

 

 

 

 

  1. Change the top most title into size-20, colour – red, double underline, upper case and font type-Goudy Stout, shading colour-green       [3 Marks]
  2. Align the headings of the first three paragraphs and the last to the right       [2 Marks]
  3. Apply a border to each of the headings just aligned in (c) above       [2 Marks]
  4. Group the sets of objects used to create each of the shapes above [2 Marks]
  5. Save the document with the name Geometry Two [2 Marks]
  6. Indent the third paragraph from both left and right margins by 1” [2 Marks]
  7. Adjust the page margins of the document as instructed below [2 Marks]

Top – 0.7”             Bottom – 0.7”

Left – 0.8”            Right – 0.7”

  1. Insert a continuous page break between the third and the fourth paragraph [1 Marks]
  2. Save the document with the name Geometry Three [2 Marks]

 

 

QUESTION TWO

  1. Create a database with the name School Work [2 Marks]
  2. Create the table given below and assign the appropriate data types for the fields. Save the table with the name Students       [6 Marks]
Student NoFirst NameSurnameStream ID
1013AfafSalihLION
1030AlfredWambuiBUFFALO
1033AmosGichukiLION
1032AnthonyNgugiBUFFALO
1037BethuelObonyoLION
1014CharlesKariukiLION
1006CyrusWangilaBUFFALO
1039DavidNabwireLION
1005FrancisWamalwaBUFFALO
1025GeorgeKiberaBUFFALO

 

  1. Set the primary key of the table to be Student No field [1 Marks]
  2. Create a second table given below and assign appropriate data types for the fields. Save the table with the name Marks       [9 Marks]

 

RecNoStudent NoExam TypeENGKISWMATHBIO
11013E195957584
21013E259585935
31030E191653467
41030E258763585
51033E165658468
61033E259954859
71032E172955674
81032E278887649
91037E172895958
101037E266458575
111014E185758475
121014E275657548
131006E136452675
141006E284566995
151039E189837595
161039E284653564
171028E190906843
181028E257326886
191025E189456664
201025E275598559

 

  1. Create a relationship and enhance referential integrity between the two tables       [2 Marks]
  2. Create a form for the table Students and save it as frmStudents       [2 Marks]
  3. Use the form created in (f) above to enter records in the respective table [5 Marks]
  4. Create a second form and for the table Marks and save it as frmMarks       [2 Marks]
  5. Use the form created in (h) above to enter records in the respective table [10 Marks]
  6. (i) Create a query from the two tables above and add the fields Student No, First Name, Surname, Exam Type, ENG, KISW, MATH, BIO. Create a calculated field Total and accumulate the marks for the four subjects. Save the query with name qryResults                                          [6 Marks]
  7. Create a report from the query qryResults and from the report show the sums and averages of all the subjects and the Total.                               [5 Marks]