KENDRIYA VIDYALAYA SANGATHAN Class

KENDRIYA VIDYALAYA SANGATHAN Class- XI [INFORMATICS PRACTICES] ... Gross Pay = hours worked x hourly ... For writing the two uses of Menu Control Arra...

0 downloads 65 Views 1MB Size
KENDRIYA VIDYALAYA SANGATHAN Class- XI [INFORMATICS PRACTICES] Time Duration: 3 Hrs General instruction: All questions are compulsory

M. M. 70

SECTION A Q1. a) What are Header and Footer in MS word? b) List out Hardware and software from the following list Transistor, Joy Stick, Oracle, Linker, Complier, Plotter c) Explain the following terms in short i) Recycle Bin ii) MIS iii) Text alignment iv) Spell check

2 3 (1 mark each)

d) What is the difference between GUI and CUI?

1

SECTION B Q2 a) What do you mean by Event driven programming.

2

b) Write use of Control Array .

2

c) Differentiate between

4

i) ii)

SDI & MDI Picture control & Image control

d) Explain the following properties and Name of one control which has this property:(1 mark each) o MaxLength o List Item o Minvalue o Password Char Q3. Answer the following :i) What is Focus? Name any two controls, which don’t receive focus? ii) Define the term Event and Object iii) Write difference between : (a) Listbox and combo box (b) Val() and Str() function iv) Write the scope and lifetime of a variable explain briefly v) What do you mean by implicit and explicit variable declaration

4 2 4 2 2

vi) Find output of the following code blocks (2 marks each) (i) Name = “Ms Manasvi” Dept = “Marketing” Msg = Name & “ You are welcome to our “& dept & “ Department” (ii)

X=5 Y=2 Z= X + Y * 10/3 Print Y, Z

Q5 In accompany an employee is paid as following Salary <2000 >=2000 but <4000 >=4000 but <8000 >8000

DA 10% 25% 30% 40%

HRA 5% 15% 25% 30%

A) Code for reset button to clear all fields 2 B) Code for End button to end . 1 C) Write code so that the all the text box remain disable except the first one , when user Enter the salary they become active 3 D) Write code for Get Button so that all the other text boxes will displays calculated DA, HRA and Net Salary. Where Net Salary= Basic + DA + HRA 4

SECTION C Q6. (a) What do you understand by Primary Key. How is it different from candidate key?

2

(b) Consider the following tables Employee and salary. Write SQL commands for the statements (i) to (iv) and give outputs for SQL queries (v) to (viii) Table : Employee Eid Name Deptid Qualification Sex 1 Deepali Gupta 101 MCA F 2 Rajat Tyagi 101 BCA M 3 Hari Mohan 102 B.A M 4 Harry 102 M.A M 5 Sumit Mittal 103 B.Tech M 6 Jyoti 101 M.Tech F Table : Salary Eid Basic DA HRA Bonus 1 6000 2000 2300 200 2 2000 300 300 30 3 1000 300 300 40 4 1500 390 490 30 5 8000 900 900 80 6 10000 300 490 89

(i) (ii) (iii) (iv) (v) (vi) (vii)

Q.7

8

To Display The Total No. Of Employees Department Wise. To List The Names Of Those Employees Only Whose Name Starts With ‘H’ To Add A New Column In Salary Table. The Column Name Is Total_Sal. To Store The Corresponding Values In The Total_Sal Column.Where Tot_Sal=Basic+DA+HRA+Bonus Select Name From Employee Where Eid = ( Select Eid From Salary Where Basic= (Select Max(Basic) From Salary)); Select Max (Basic) From Salary Where Bonus >40; Select Count(*) From Employee Group By Sex; (viii) Select Distinct Deptid from Employee;

Answer the questions given below a) Differentiate between i. Front end and Back end ii. Two tier and three tier computing model b) Discuss classification of SQL statements c) What is natural join ? What is the need of it? *************************************************************

2 2 4 2

KENDRIYA VIDYALAYA SANGATHAN MARKING SCHEME Class- XI [Computer Science] Q1. a) b) c) d)

1 mark each for correct definition of Header and Footer ½ mark for each correct answer 1 mark for correct explanation of every topic 1 mark for any one difference

Q2. a) b) c) d)

Q3.

Q4.

Q5.

2 marks for correct definition 2 marks for mentioning correct uses 2 marks for any two correct differences ½ mark each for correct explanation of property and ½ for identification of correct control i) 2 mark for correct definition of Focus and 1 mark each for identification of correct control ii) 1 mark each for correct definition iii) 2 marks each for any two correct differences iv) 1 mark each for correct definition of Scope and Lifetime of variable v) 1 mark each for correct definition of implicit and Explicit declaration. vi) 2 marks each for correct output a. Ms. Manasvi you are welcome to our Marketing Department b. 11.66 A) ½ mark each for correct code of clearing each text box B) 1 mark for complete code of end button C) 3 marks for correct code D) 4 marks for correct code 1 mark each for writing correct solution for query (i) to (iv ) And 1 mark each for finding correct output of query no. (v) to (viii)

Session Ending Exam 2008-09 Class-XI Subject: Informatics Practices Time : 3 Hrs.

M.M. : 70 Section-A

Q.1) Answer the questions given below:a) Give example for each of System Software and Application software. b) What is the significance of My Computer. c) Differentiate between Compiler & Interpreter.

1 2 2

Q.2) Answer the questions given below:a) What are the three types of computer. How do they differ. b) What are the advantages of Find & Replace features of Ms-Word.

3 2

Section –B Q.3) Write a Visual Basic program which computes Gross Pay, Tax and Net Pay from an employees number of dependents, hourly rate and hours worked. Use the formulas below : Gross Pay = hours worked x hourly rate Tax = 0.2 x(Gross Pay – dependents x38.46) Net Pay = Gross Pay – Tax See the form below & answer the following questions :

a) Write command to disable the Gross Pay textbox , Tax textbox and Net Pay text box when the form loads and enable it when calculate command button clicks. b) Write code for end command button which terminates the program. c) Write code for Clear command button which clears all the text boxes. d) Write code for calculate command button to calculate the Net Pay. Q.4) Answer the questions given below:a) Give the syntax of declaring variable. b) What is the similarity & difference between Option button & Checkboxes. c) Discuss the role and significance of Data Control.

2 2 2 4 1 2 4

d) Define the use of ListBox in VB. e) What do you understand by data types in Visual Basic. Q.5 ) Answer the questions given below:a) What do you understand File System Files Controls. b) Discuss some basic properties of OLE Control. c) What will be the output of the following code : dim x as string dim y as string x = “Good Morning” y = “God Bless You” z = “and” Mesg = x & “ “ & z & “ “ & y MsgBox(Mesg) d) What is use of Menu Control Array.

1 2 2 3 3

2

Section-C Q.1) Answer the questions given below:a) Define the following with example :i) Primary Key ii) Foreign Key iii) Candidate Key iv) Alternate Key b) Discuss any four character function in SQL. c) Discuss the use of Order By clause in Select statement with example. Q.2) Answer the questions given below:a) Differentiate between DDL & DML commands. b) What is SQL ? What are the different categories of SQL statement. c) What is Join ? How is natural join different from equi-join. d) Give the definition & use of the following :(a) Commit (b) RollBack Q.3 ) Answers the following questions based on the table employee( EmpNo,Name,Salary,HireDate,MngNo,DeptNo) (1) Write a query to display the name of employee whose name contains ‘T’ as the last alphabet. (2) Modify the Salary and increase it by 1000 for all who get Salary less than 5000. (3) Write a query to display the name , salary and hiredate of employee whose salary is between 1000 and 5000. (4) Write a query to display the employee number , name and manager name with their manager number. (5) Find out who works in same department as that of employee ‘MILLER’.

4 4 2 2 4 2 2

2 2 2 2 2

MARKING SCHEME Session Ending Exam 2008-09 Class-XI Subject: Informatics Practices Time : 3 Hrs.

M.M. : 70 Section-A

Q.1) Answer the questions given below:a) For writing example for each of System S/W & Application S/W. b) For writing the significance of My Computer. c) Two mark for two difference between Compiler & Interpreter. Q.2) Answer the questions given below:a) For writing three types of computer.

½ +1/2=1 2 2 ½+1/2+1/2 = 1 1/2

For writing difference. b) For writing the advantages of Find & Replace features of Ms-Word.

1 +1/2 2

Section –B Q.3) a) Private sub Form_Load() textGrossPay.enabled=False textTax.enabled=False textNetPay.enabled=False End Sub

2

b) Private Sub End_Click() 2 End End Sub c) textGrossPay.text=”” 2 textNetPay.text=”” textTax.text=”” textHourlyrate.text=”” textHourworked.text=”” textDependents.text=”” d) Code for calculate command button to calculate the Net Pay. 4 Private Sub Calculate_click() textGross Pay = val(texthoursworked) * val(texthourlyrate) textTax = 0.2 * (val(textGrossPay.text) – (val(textdependents.text) * 38.46)) textNet Pay = val(textGrossPay.text) – val(textTax.text) End Sub Q.4) Answer the questions given below:a) For writing the syntax of declaring variable. b) For writing the similarity between Option button & Checkboxes. For writing difference between Option button & Checkboxes.

1 1 1

c) For writing the role and significance of Data Control. d) For writing the use of ListBox in VB. e) For writing the definition of data types in Visual Basic. Q.5 ) Answer the questions given below:a) For writing the File System Files Controls. b) For writing the three basic properties of OLE Control. c) Output is

4 1 2

1+1+1=

2 3 3

Good Morning and God Bless You d) For writing the two uses of Menu Control Array.

1+1= 2

Section-C Q.1) Answer the questions given below:a) ½ marks for definition & ½ mark for example :1x4=4 i) Primary Key ii) Foreign Key iii) Candidate Key iv) Alternate Key b) For writing the any four character function in SQL. 1x4= 4 c) For writing the use of Order By clause in Select statement with example. 2 Q.2) Answer the questions given below:a) For writing any two difference between DDL & DML commands. b) For writing the definition of SQL . For writing the different categories of SQL statement. c) For writing the definition of Join. Fro writing the difference between natural join & equi-join. d) For writing the definition & use of the following :-

2 1 3 1 1

(a) Commit (b) RollBack

1 1

Q.3 ) Table employee( EmpNo,Name,Salary,HireDate,MngNo,DeptNo) (1) SELECT NAME FROM EMPLOYEE WHERE NAME LIKE ’%T’. (2) UPDATE EMPLOYEE SET SALARY=SALRY + 1000 WHERE SALARY < 5000. (3) SELECT NAME , SALARY, HIREDATE FROM EMPLOYEE WHERE SALARY BETWEEN 1000 AND 5000. (4) SELECT E1.EMPNO,E1.NAME,E2.NAME,E2.EMPNO FROM EMPLOYEE E1,EMPLOYEE E2 WHERE E1.MGRNO=E2.EMPNO. (5)SELECT * FROM EMPLOYEE WHERE DEPTNO= (SELECT DEPTNO FROM EMPLOYEE WHERE NAME=’MILLER’)

2 2 2 2

2

Session Ending Exam.2008-2009 Class XI Subject : Informatics Practices Time: 3 Hrs.

MM:70 SECTION A

2. Answer the questions given below a) Define MIS and Business Computing. 2 b) What is Operating System? What are the functions of Operating System 3 3. Answer the questions given below a) Give classification of programming languages. 2 b) How will you change date and time on your system 1 c) ___________is a software that processes textual matter and creates organized documents. 1 d) Give example for each of System software and Application Software 1 SECTION B 4. Consider the form given below and answer the following question Security Check Enter Your Password:

OK

a) b) c) d)

Clear

Cancel

Disable

Write code for Clear command button which clears the text box. 2 Write command to disable text box when form loads 2 Write code for cancel command button which terminates the program. 2 Write code for command button OK. It should display message box “Password OK” if the password entered is correct otherwise the message box should display “”wrong password , try again” 4

5. Answer the questions given below a) What is variable ? What is the need of it?

2

b) What is the difference between numeric and non numeric data type? c) Explain got focus and lost focus events d) Name some common properties of following control i. Text box ii. Label iii. Option button iv. Checkbox

2 2 4

6. Answer the questions given below a) Differentiate between i. Image Box and Picture Box. 2 ii. List Box and Combo Box 2 b) What is OLE? 2 c) What will be the Output of the following code. 2 St1=”Mr.” St2=”Shobhit” St3=”Saxena” Msgbox(St1 & St2 & St3) d) Identify the implicit and explicit variable declaration in the following statement. 2 Dim V1 As Integer, V2 As Single, V3, V4 SECTION C 7. Answer the questions given below a) What is view ? b) Define constraints? c) What is schema ? d) What is dual ? e) Discuss any for character functions in SQL? f) What is the difference between having and where clause

1 1 1 1 4 2

8. Answer the questions given below a) Differentiate between i. Front end and Back end ii. Two tier and three tier computing model b) Discuss classification of SQL statements c) What is natural join ? What is the need of it?

2 2 4 2

9. Answer the following question based on following table. Table : CLUB SN 1

Column name Member_no

Data type NUMBER(4)

constructs Primary key

2 3 4 5 6

Member_name Address Age Type Fees

VARCHAR2(30) VARCHAR2(30) NUMBER)3) VARCHAR2(10) NUMBER(6)

Not null -

a) Write the SQL commands to create table CLUB including the constraints2 b) Write the SQL commands to insert following values in table club 123,Mr. Raman, MG road Mumbai,32,Permanent , 3000 2 c) Write the SQL commands to display the details of all the members whose type is ‘Permanent’ and Fees is more than 1000. 2 d) Write the SQL query to display Member_ name in ascending order 2 e) Write the SQL query to display unique Member_ name 2

SESSION ENDING EXAM -2008-09 CLASS-XI SUBJECT:- INFORMATICS AND PRACTICES Time:3 hrs

MM:70 SECTION A

Q.1:- Answer the questions given below: ( a) MIS :- A Management information system is an information system that generate accurate, timely and organized information to help managers make decision ,control process ,solve problems ,supervise activities and track progress. 1 Mark (b) Business Computing:- Computing applied to solve business related problem , is known as Business Computing. 1 Mark Function of operating system 1.Loads necessary programs into the computer memory. 2. Co-ordinate how program works with the CPU, Keyboard, mouse, printer. 3. Manages the way information is stored on and retrieved from disks. Any two -1 mark each * 2 2.Answer the question given below (a ) Classification of programming language 1GL :- First Generation language 2GL :- Second Generation language 3GL :- Third Generation language 4GL :- Fourth Generation language 5GL :- Fifth Generation language (b) control panel -> date and time-> date and time property dialog box->1 mark (c ) Word Processor : 1Mark ( d ) example of system software – OS ½ Marks Application Software—1/2 marks SECTION B 3. Consider the form given below and answer the question given below:( a) private sub cmdclear_click ( ) Txtpassword.text = “ “ End sub 2Marks ( b) private sub cmdclear_click ( ) Txtpassword.enable = false End sub 2Marks

c)Private sub cmdcancel-click() End End Sub

2 marks

d) Private sub Cmd OK_ click() If TxTPassword.Text=”Indian”Then MsgBox(“Password OK”) Else MsgBox(“Wrong Password, try again”) TxtPassword.Text=” “ End If End Sub 4marks 4. Answer the questions given below a) Variable:A name storage location whose contents can be varied is called variable Need :to hold data 1 mark each x 2 b) Numeric data type:consist of numbers and can be used for calculations Non numeric data type: can not participate in calculations.Eg. True and false(Boolean) 1mark each x 2 c) got focus: Occurs when control receives focus 1 mark lost focus: Occurs when previously active control lost focus 1 mark d) Some common properties of following control 1) Text box: enabled , visible 2) Label: enabled, visible 3) Option button: enabled, visible 4) Checkbox: enabled , visible 1 mark each x 4 5. Answer the questions given below a) Image box: Having stretch property,good for dis[laying graphics b) Picture box:- Having autosize property provides methos for drawing at run time. 1 mark each * 2 (ii) List box:- display a list of items for which user can select one or more can not enter information Combo Box:- Combines a feature of text box and the list box can enter information 1 marks each*2 b) OLE:- is the program integration technology that can be used to share inforation share between programs through objects. 2 mark each c) Output:- Mr. Shobit saxena – 2marks d) Explicit variable Declaration – 2Marks SECTION C 6. Answer the question given below a) View:- is a virtual table 1 mark b) Constraints :- is a collection or check applicable on a fields or a set of fields 1 marks

c)

Schema : collection of logical structure of data

1mark

d) Dual:is one row ,one column dummy table provided by oracle to perform calculation 1 mark e) Characters functions in sql Concat:concatenates two string Initcap : capitalizes the initial letters of a string Lower : converts a string into lower case Substr: extracts a substring from a given string 1mark each*4 f) having clause : places conditions on group where clause : places conditions on individual row 7 Answer the following questions a) i. font end: refers to the client side i.e. the end from which sequence is made back end : refers to the server side i.e. where the client request is processed 1mark each*2 ii. two tier computing model: consist of client & a database server three tier computing model : a middle tier exists between client & a database server 1markeach*2 b) classification of SQL statements DDL: allows to perform task related to data d4efinition DML: enables user to access or manipulate data TCL: to manage & control transactions Session & system control commands 1 mark each*4 c) Natural Join : join in which one of the identical column(coming from joined tables)exists is called natural table Need: one of the two identical column can be eliminated 1 mark each *2 8. answer the following question based on following table a) CREATE TABLE club(Member_no NUMBER (4) PRIMARY KEY, Member_no VARCHAR2(30) NOT NULL ,Address VARCHAR2(20),Age NUMBER(3) Type VARCHAR(10) ,fEESnumber(6)); 2marks b) INSERT INTO club (Member_ no, Member_name,address,age,fees ) VALUES(123,’Mr. Raman’ ,’MG Road’ ,32,’Permanent’,3000); 2marks c) SELECT*FROM club WHERE Type=’Permanent’ AND Fees>1000; 2 marks d) SELECT*FROM club ORDER BY Member_name; 2 marks e) SELECT DISTINCT(Member_name)FROM club; 2 marks