(XII) Marking Scheme NEB 2080 Computer

NEB – GRADE XII 2080(2023) New Course Computer Science (4281) Marking Schema
Full Marks: 50
Group A
(Multiple Choice Questions) 9×1=9
Correct option of Multiple-choice questions (1 Marks for correct option) Q.N. 1 (c) the $ sign Q.N. 2 (b) select Q.N. 3 (c) www Q.N. 4 (a) 192.168.1.1 Q.N. 5 (a) hide ( ) Q.N. 6 (b) mysqli_connect() Q.N. 7 (d) FILE is a structure and fpt is a pointer to the structure of FILE type Q.N. 8 (c) Testing Q.N. 9 (d) Guided Transmission Media
Group B
(Short Answer Questions) 5 × 5 = 25
Q.N.10 Explain the Relational database model with an example. (5) - Definition of relational data model – 1 mark - Use of explanation of any three terminologies; such as relation, tuple, field , primary key, domain and integrity constraints – 3 marks - Diagram for relational data model- 1 mark Based on the above partial points and concepts will be scored partial marks Q. No. 10 : OR Write SQL DDL command to execute the following task with reference to the schema given below: student_info(regno as integer, name as character(25), class integer,gender character(1), address character(25)). [5 marks] Here's a suggested marking scheme for the given task: (1) Correct syntax and table creation (2 marks) - Allot 2 marks if the CREATE TABLE statement is correct and creates a table with the specified table name, columns and data types. (2) If column names and data types match the provided schema. (1 mark) (3) If column lengths are according to the provided schema. (1 mark) (4) Overall structure and readability (1 mark) - Allot 1 mark for correctly aligning and formatting with proper indentation and spacing to the SQL statement. - An indentation is the space at the beginning of a line of writing when it starts further away from the edge of the paper than all the other lines. Note : Data type can be integer or int and character or char. Q. No. 11: Define syntax for database connectivity. Write a server side scripting code to insert data into a table student having fields (first name, last name, mark and email). Assume that server name= “localhost”, username= “root”, password="", database name= "studentDB". [5] Give any one syntax for database connection:- 1 mark Syntax: $con=new mysqli($servername,$username,$password,$database); OR $con=mysqli_connect($servername,$username,$password,$database); <?php // step 1: Database configuration. :- 1 marks for steps 1 and 2. e.g. : $servername= “localhost”; $username= “root”; $password= " "; $database= “studentDB”; // step 2: Establish a connection to the database e.g. $con=new mysqli($servername,$username,$password,$database); Note: Above steps 1 and 2 can be in a single line. //Step 3: Check if the connection was successful:- 1 mark e.g. if($con->connect_error) { die(“Connection failed:”.$con->connect_error); } //Step 4: Prepare the SQL statement for insertion:- 1 mark e.g.: $sql= "INSERT INTO student (first_name,last_name,mark,email) VALUES ("Ram", "Sah",45, "ramsah@gmail.com")"; //Step 5: Execute the SQL statement:- 1 mark for steps 5 and 6 e.g.: if($con->query($sql) = = = true) { echo "Data inserted successfully"; } else { echo “Error:”.$sql. “<br>”.$con->error; } //step 6: close the database connection e.g. : $con->close(); ?> Above partial points and concepts will be scored partial marks Q. No. 11: OR
Write a JavaScript code to calculate the factorial of a given number. [5]
1. Correct syntax and its structure – 1 mark Award 1 mark if the JavaScript code has the correct syntax and structure, including proper indentation and formatting. 2. Proper variable declaration and assignment- 1 mark Allot 1 mark if the code declares a variable to store the factorial result and assigns an initial value to it. 3. Handling of input and error conditions- 1 mark Allot 1 mark if the code correctly handles input validation and error conditions, such as checking if the input is a positive integer. 4. Looping and factorial calculation with proper display of the output- 2 marks Allot 1 mark if the code uses a loop (such as for loop or while loop) to calculate the factorial of the given number and displays the result accurately. Note: The marking scheme provided is subjective and may vary depending on the specific requirements provided by your instructor. Q. No. 12: How is an event-driven program (or OOP) differing from procedural oriented programming language? Explain. Full Marks(5) 1. Code in the module/function VS class/object – 1 mark 2. The OOPs features VS procedural language features – 2 marks 3. Code reusability/ flexibility/modification concept, data security etc. – 1 mark 4. Example of both programming languages – 1 mark Above partial points will be scored partial marks. Q. No. 13: Explain the importance of the system testing of the system development life cycle (SDLC). Full Marks(5) 1. Define the system testing – 1 mark 2. Explain the importance of system testing – 4 marks (At least four points or keywords can be included like validation and verification, Error Detection and correction, reliability and Quality Assurance, and cost and risk reduction). Above partial points will be scored partial marks. Q. No. 14: What is cloud computing? Point out the advantage and disadvantage of cloud computing Full Marks(5) 1. Definition of cloud computing and example. – 2 marks 2. List of the advantages and disadvantages of cloud computing – 3 marks Above partial points will be scored partial marks. Group C: Long Answer Questions (2×8=16) Contents Area and Marks Schema: Q. No. 15 : What is network topology? Differentiate between guided (wire media) and unguided (wireless media) with example. Full Marks(4+4) 1. Define network topology with an example. – 2 marks 2. Six differences between guided and unguided with an example – 6 marks Above partial points will be scored partial marks. Q. No. 16: Write the advantage of pointer? Write a C program to enter the radius of a football and find the area of football by using user defined function Full Marks (8) 1. Define the pointer with syntax – 1 mark NEB XII computer Marking Scheme 2080 Page 3 2. Write the four advantages of the pointer – 2 marks 3. Declaration and preparation of a user defined function to calculate area on the basis of radius input – 3 marks 4. Execution of function with the proper display of output – 2 marks The above partial concept of a calling function, declaration of a function, and function definition in C will be scored partial marks. Q. No. 16 : OR Define structure. Write a C program using structure to input staff id, name and the salary of 50 staffs. Display staff id, name and salary of those staff whose salary range from 25 thousand to 40 thousand. Full Marks(8) 1. Define the structure Definition (2 marks) Provide a concise definition of a structure in C. For example: “In C, a structure is a user-defined data type that allows grouping together related variables of different types. It is defined using the ‘struct’ keyword followed by the structure name and a set of curly braces.” The definition is expected with either an example or key features or purpose as well. 2. Marking scheme for program preparation (6 marks)  Proper structure definition (1 mark) o Proper structure definition and member variables: Award 1 mark if the program includes a structure definition for storing staff information, including member variables for staff if, name and salary.  Input of staff information (1 mark) o Allot 1 mark if the program correctly prompts the user to input the staff id, name and salary for each of the 50 staff members o The program should store the inputted information in an array or any suitable data structure.  Display of staff information within salary range with proper filtering verification ( 3 mark) o Allot 1 mark for the proper loop setting to select each staff‟s data o Allot 1 mark for the proper condition setting for selection of the salary range between 25,000 and 40,000. o Allot 1 mark for the display of staff records matching the criteria  Overall clarity and coherence (1 mark) o The program should be well-organized, logically presented, and easy to understand. The above partial concept of array of structure and use logic in C will be scored partial marks