Page 28 - IP

CBSE AISSCE 2018 Marking Scheme for Informatics Practices
(​Sub Code: 065 Paper Code 90​)

(iii) To increase the cost of those tests in the table “​TEST​” by ​₹ 50.00 that have cost below 2
₹ ​200.00

Ans UPDATE TEST
SET COST = COST+50.00
WHERE COST <200.00;
(1 mark for ​UPDATE​)
(½ mark for ​SET​)
(½ mark for​ WHERE​ clause)
7 (a) How does e-governance help in building trust between the Government and citizens? 2

Ans ● Transparency of Government processes, policies and decisions
● Awareness about new policies and facilities being offered by the Government.
● Enabling citizen engagement in the policy processes
● Reduces the waiting time
● Practices like influences and bribing are reduced
( 2 marks for correct answer)

(b) How can e-learning help students learn at their own pace? 1
● Students can go through the learning material any number of times as per his/her
Ans learning abilities
● Students can study at their own convenient time anywhere/anytime.
( 1 mark for any relevant point)
(c) Ms. Cathy is creating a form for Vidya University Sports Council application. Help her to 2
choose the most appropriate controls from ListBox, ComboBox, TextField, TextArea,

RadioButton, CheckBox, Label and Command Button for the following entries:
S.No. Function

1. To let the user enter ​NAME
2. To let the user enter ​MOBILE NUMBER
3. To let the user choose one ​PROFESSION​ out of the categories :
Teaching/Non-Teaching/Research Scholar
4. To let the user select facilities out of Gym, Yoga, Table Tennis, Badminton
and Aerobics. More than one facility may be chosen.

Ans
S.No. Function
1 To let the user enter ​NAME TextField

2 To let the user enter​ ​MOBILE NUMBER TextField
3 To let the user choose one ​PROFESSION RadioButton/
out of the categories : Teaching/Non Combobox
Teaching/ Research Scholar
4 To let the user select facilities out of Gym, Checkbox/Listbox
Yoga, Table Tennis, Badminton and Aerobics.
More than one facility may be chosen.

( ½ mark for each correct answer)

Page 13 of 13