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