Question 2
- Launch a Desktop publishing software and set the measurements to centimeters, margins 2cm all round and paper size A4 potrait. (1½ marks)
- Design the publication above (in page 4) as it appears and save it as MOKASA_2. (30 marks)
- Format the Title “ Data Flow Diagram (DFD)” as follows: (6 marks)
Character spacing: 300%
Font style: Times New Roman
Font size: 5 - Modify the shape containing the title as follows:
Background : Gradient with 17% transparency, Shading style Horizontal
Border line : Double - Apply a first line indent to the first paragraph of the document. (2 marks)
- Proofread your publication. (½ mark)
- Insert your full index number as a watermark of your publication. (2 marks)
- Insert your full name as the header, Class and admissionnumber as the footer of your publication . (2 marks)
- Insert page number at the right bottom margin of your page. (2 marks)
- Insert the Date and time created for this document after the first paragraph. (2 marks)
- Print your publication (2 marks)
MARKING SCHEME
QN |
Section/Activity |
Marks |
Max mark |
Marks awarded |
|
1. |
a) |
(i) Creating the database ANTIGUA_ENT_LTD (ii) Creating the tables Commodity_Table, Suppliers_Table and Order_Table with correct fields and data. (iii) Appropriate assigned as primary key for each table Commodity_ID - Commodity_Table Supplier_ID - Suppliers_Table Order_ID - Order_Table (iv) Correct relationships and enforced referential integrity |
1 mark 14 marks 1 1/2 marks 3 marks |
19½ marks |
|
b) |
Capturing the number of units for the Commodities in Commodities_Table. |
3 marks |
3 marks |
||
c) |
CreatingRETAILCOST query - Correct fields - Calculating the total retail price for each Commodity |
2 marks 2 marks |
4marks |
||
d) |
CreatingCUSTOM_QR query - Correct fields - Suppliers name starting with letter “P” and Total Retail Price is between Ksh.4000 and less than Ksh.50,000 |
2 marks 3 marks |
5 marks |
||
e) |
Creating report SUPPLIERS_RPT - Correct fields - Group records per suppliers’ town - Title the report as “ANTIGUA SUPPLIERS DETAILS” - Show the Total Retail Prices per supplier. |
1 mars ½ mark ½ mark 1 mark 1 mark |
4 marks |
||
f) |
Creating report named ORDERS_2019 - Correct fields - Items ordered in the year 2018 only - Showing/counting and displaying the number of suppliers on the rpt. |
½ mark 2 marks 1 marks |
3 ½ marks |
||
g) |
Creating pie chart to display Total Retail Prices and their respective Commodities - Well labeled axes, title and legend o Appropriate chart title, o X-axis and Y-axis |
@½ mark |
2 marks |
||
h) |
Creating form namedCOMMODITIES_2018 - Correct fields as required Title Lables Textboxes |
1 marks 2marks 2marks |
5 marks |
||
i) |
Printing Tables:CommodityTable Queries:RETAIL_COST and CUSTOM_QR Reports: SUPPLIERS _RPT |
½ mark ½ mark 1mark 1mark |
3 marks |
||
|
TOTAL |
50 MARKS |
|
Qn 2 |
ACTIVITY/SECTION |
MARKS |
STUDENT SCORE |
a |
Setting units to centimeters |
½mrk |
|
|
Margins to 2cm all round |
½mrk |
|
|
Page to A4 potrait |
½mrk |
|
b |
Saving as MOKASA_2 |
1 mrk |
|
|
Whole document created |
2 mrks |
|
|
Page border |
1 mrk |
|
|
Word art drawn (I love ….) |
3 mrks |
|
|
DFD diagram correctly drawn |
5 mrks |
|
|
Columns |
2 mrks |
|
|
Column border line dotted |
2 mrks |
|
|
Line in between columns |
2 mks |
|
|
Auto shape at the bottom page |
2 mrks |
|
|
Outline dotted |
2 mrks |
|
|
Background pattern |
2 mrks |
|
|
Characters condensed |
2 mrks |
|
|
Drop cap inserted as it appears |
2 mrks |
|
|
Bolding and italicizing in publication |
2 mrks |
|
c |
(i) Formatting title |
||
|
Character spacing 300% |
1mrk |
|
|
Font style Times New Roman |
1mrk |
|
|
Font size 13.5 |
1mrk |
|
|
(ii) Background : gradient transparency 17%, 15% , shading styles Horizontal |
1 mrk |
|
|
Border line : Double |
1 mrk |
|
d |
Apply a first line indent |
2 mrks |
|
e |
Proofread your publication |
½mrk |
|
f |
Inserting watermark |
2 mrks |
|
g |
Header and footer |
2 mrks |
|
h |
Page number |
1 mrk |
|
i |
Date and time |
2 mrks |
|
j |
Printing |
2 mrks |
|
|
Total |
50 |
|