| NAME OF LEARNER: | ||||
| TOTAL QUESTION 1: | TOTAL QUESTION 2: | TOTAL QUESTION 3: | TOTAL QUESTION 4: | TOTAL |
| /40 | /40 | /38 | /32 | /150 |
| QUESTION 1: GENERAL PROGRAMMING SKILLS | MAX. MARKS | MARKS ACHIEVED | |
| 1.1 | Button [1.1]
| 3 | |
| 1.2 | Button [1.2 Process]
Else
Alternative solution:
Get inputs from spinedits | 11 | |
| 1.3 | Button [1.3 Find rainfall type] Alternative solution:
Get input from edtRain
| 13 | |
| 1.4 | Button [1.4 Display Rainfall]
Calculate total quantity using LstQuantity items convertedto integer | 13 | |
| TOTAL QUESTION 1 | 40 | ||
| QUESTION 2: DATABASE PROGRAMMING | MAX. MARKS | MARKS ACHIEVED | |
| 2.1.1 | Button: [2.1.1] | 3 | |
| SQL: 'select * from Status order by Statusname DESC' | |||
Concepts:
| |||
| 2.1.2 | Button: [2.1.2] | 3 | |
| SQL: 'Select Birdname from Bird where Sightings < 200' | |||
Concepts:
| |||
| 2.1.3 | Button: [2.1.3] | 4 | |
| SQL: 'Select Birdname, Lastsighted from Bird where Birdname like ' + quotedstr('%' + sline + '%') | |||
Concepts:
| |||
| 2.1.4 | Button: [2.1.4] | 4 | |
| SQL: 'Delete from Bird where (StatusID = 6) OR (StatusID = 5)' | |||
Concepts:
| |||
| 2.1.5 | Button: [2.1.5] | 3 | |
| SQL: 'select Statusname, Birdname from Bird, Status where Bird.StatusID = Status.StatusID' | |||
Concepts:
| |||
| 2.1.6 | Button: [2.1.6] | 8 | |
| 'Select StatusID,format(avg(Sightings),"fixed",1) as AverageSightings from Bird where year(Lastsighted) = 2007 group by StatusID' | |||
| |||
| 2.1 Subtotal: SQL | 25 | ||
| 2.2.1 | Button: [2.2.1] tblbird.First; while not tblbird.eof do if pos('EAGLE',uppercase(tblbird['Birdname'])) <> 0 then reddisplay.Lines.Add(tblbird['Birdname']); tblbird.Next; | 6 | |
| 2.2.2 | Button: [2.2.2] icount := 0; tblbird.First; while not tblbird.eof do begin if tblbird['StatusID'] = 3 then begin tblbird.Edit; tblbird['StatusID'] := 2; tblbird.Post; inc(icount) end; tblbird.Next; end;reddisplay.Lines.Add('Number of changes made = ' + inttostr(icount)); | 9 | |
| 2.2 Subtotal: Code constructs | 15 | ||
| TOTAL QUESTION 2 | 40 | ||
| QUESTION 3: OBJECT-ORIENTATED PROGRAMMING | MAX. MARKS | MARKS ACHIEVED | |
| 3.1.1 | Constructor Create:
| 4 | |
| 3.1.2 | function getsightings: integer;
| 2 | |
| 3.1.3 | procedure increasequantity(iqty: integer);
| 4 | |
| 3.1.4 | function sightinggap: string;
| 7 | |
| 3.1.5 | function tostring: string;
| 5 | |
| 3.1 Subtotal: Object class | 22 | ||
| 3.2.1 | Button [Q3.2.2]
| 11 | |
| 3.2.2 | Button [Q3.2.1]
| 5 | |
| 3.2 Subtotal: Form class | 16 | ||
| TOTAL QUESTION 3 | 38 | ||
| QUESTION 4: PROBLEM SOLVING | MAX. MARKS | MARKS ACHIEVED | |
| 4.1 |
| 19 | |
| 4.2 |
| 13 | |
| TOTAL QUESTION 4 | 32 | ||
SAMPLE SOLUTIONS








