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 |
|
