- 2018 Computer Studies – Paper1
1 (a)(i) Creating the database file @ 1 ½
(ii) Creating of tables (at least 3) @1 ½
Student table
✔ 4 Fields each @ ½ =2
Patron table
✔ 2 Fields each @ ½ =1
Dormitory table
✔ 3 Fields each @ ½ =1½
Games table
✔ 2 Fields each @ ½ =1
(iii) Relationship at least 3 each @ 1 =
(b) (i) 4 forms for each table each @½ =2 = 2
(ii) 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
(c) (i) Creating the orangeq query
- Invoking the use of query@ 1
- selecting the fields @ 1
- Criteria applied to the fields @ 2✔ Saving the query @ 1
(ii) Creating the j query query
- Invoking the use of query@ 1
- Criteria (letter j) @✔ 1 Saving the query @ 1
(d) (i) 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(ii) I. Replacing the report title @l
✔ H. Entering name and index as report footer
✔Name and index @ l
✔Position the items in the footer @ 1
HI. Bolding the text
✔Selecting the text @ 1
✔ applying bold format @l
(e) Printing
(i) 4 Tables each @ 1
(ii) 2 queris each @ 1 =2
(iii) The report @ 1
2 (a) (i) 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(ii) I Formatting the title,p>
- Font size 18 @l
- Font colored @l
- Font typemahoma @lH Double underline
- Selection of text under advantages @l
- Applying double space @lIH Drop cap
- Selection the first letter @l
- Using drop cap feature @l
- Dropping through 4 lines @ 1IV Two columns
- Selection of text @l
- Using the column feature @l
- Applying a line between the columns @ 1
- Advantages to the left @ /z 4
- Formats applied on subtitles
- Bold@1
- Italics @l
- Underline @ 1(iii) I Water marks
- Using the watermark feature @ 1
- Typing the text social media in the watermark field @l
- Font size=20 @l
- Direction (Diagonal left to right) @lH Page numbering
- Using page numbering feature @½
- Inserting page numbers @ 1
- Centering the pages horizontally @/ 2III Header
- Using the header field @ /
- Typing the text in the header field @ 1
- Alignment at the right @½
- Applying italics @ 1(b)(i) Main document
- Typing text @l
- Applying formats ½
- Saving the document @ 1(ii) Main document
- Creation of datasource @3
- Saving the datasource @l
- Using the mail merge feature @½
- Inserting the 2 fields at each @l =2
- Generating the merged document 2
- Saving the merged document @ 1(c) Printing the word documents
- Social network@I
- mail merge @l
- counsel letter @l
