Plus Two Computer Application Previous Year Question Papers and Answers PDF HSSlive: Complete Guide (2010-2024) – Hsslive | Hsslive.co.in | Hss Live

Are you searching for Kerala Plus Two Computer Application previous year question papers and answers in PDF format from HSSlive? You’ve come to the right place! As an experienced Computer Application teacher from Kerala, I’ve compiled this comprehensive resource to help you ace your Computer Application board exams.

Why HSSlive Plus Two Computer Application Previous Year Question Papers PDFs Are Essential

Computer Application requires both theoretical knowledge and practical skills. HSSlive.co.in offers the most reliable collection of Plus Two Computer Application question papers that:

Help you master the exact Kerala Higher Secondary Board examination pattern
Reveal frequently tested topics and concepts from past papers
Develop effective time management strategies
Build confidence through targeted practice
Identify your strengths and weak areas in different chapters

How to Download Plus Two Computer Application Previous Year Question Papers and Answers PDF from HSSlive

Quick Access Guide:

Visit the official HSSlive website: www.hsslive.co.in
Navigate to “Previous Question Papers” or “Question Bank” section
Select “Plus Two” from the class options
Choose “Computer Application” from the subject list
Download the PDF files for different years (2010-2024)

Pro Tip: Create a dedicated folder to organize your HSSlive Computer Application PDFs by year for structured revision.

Kerala Plus Two Computer Application Exam Pattern (Important for HSSlive PDF Users)

Understanding the exact question paper structure will help you extract maximum value from HSSlive PDFs:

Section	Question Type	Marks per Question	Number of Questions
Part A	Very Short Answer	1 mark	8 questions
Part B	Short Answer	2 marks	10 questions
Part C	Short Essay	3 marks	9 questions
Part D	Long Essay	5 marks	3 questions
Total		60 marks	30 questions

15 Plus Two Computer Application Previous Year Question Papers with Answers (HSSlive PDF Collection)

Plus Two Computer Application Previous Year Question Papers with Answers (2010-2024)

1. March 2024 Computer Application Question Paper with Answers

Question 1: What is the full form of HTML? (1 mark) Answer: Hypertext Markup Language

Question 2: Differentiate between compiler and interpreter. (3 marks) Answer:

Compiler: Translates the entire program at once into machine code before execution. Generates object code file. Execution is faster after compilation. Examples: C, C++, Java.
Interpreter: Translates and executes the program line by line. Does not generate separate object code. Execution is slower. Examples: Python, JavaScript, PHP.
Compiler shows all errors after compilation, while interpreter stops at the first error.

Question 3: Explain the different types of CSS with suitable examples. (5 marks) Answer: There are three types of CSS:

Inline CSS: Applied directly to HTML elements using the style attribute. Example: <p style="color: blue; font-size: 16px;">This is inline CSS</p>

Internal CSS: Defined within the <style> tag in the <head> section of an HTML document. Example:

<head>
  <style>
    p { 
      color: red;
      font-size: 18px;
    }
  </style>
</head>

External CSS: Defined in a separate .css file and linked to HTML using the <link> tag. Example:
```
<head>
  <link rel="stylesheet" href="styles.css">
</head>
```
styles.css file:
```
p {
  color: green;
  font-size: 20px;
}
```

Advantages of external CSS include reusability across multiple pages, reduced file size, and easier maintenance.

2. March 2023 Computer Application Question Paper with Answers

Question 1: What is the purpose of DOCTYPE declaration in HTML? (1 mark) Answer: The DOCTYPE declaration tells the web browser which version of HTML the page is written in, ensuring proper rendering of the web page.

Question 2: Explain the concept of normalization in database design. (3 marks) Answer: Normalization is a systematic approach to database design that reduces data redundancy and improves data integrity by:

Organizing data into tables
Establishing relationships between those tables
Eliminating inconsistencies

The three main normal forms are:

First Normal Form (1NF): Eliminate repeating groups and ensure atomic values
Second Normal Form (2NF): Meet 1NF requirements and remove partial dependencies
Third Normal Form (3NF): Meet 2NF requirements and remove transitive dependencies

Normalization helps prevent update, insertion, and deletion anomalies in databases.

Question 3: Write a Python program to find the factorial of a number using recursion. (5 marks) Answer:

def factorial(n):
    # Base case: factorial of 0 or 1 is 1
    if n == 0 or n == 1:
        return 1
    # Recursive case: n! = n * (n-1)!
    else:
        return n * factorial(n-1)

# Get input from user
num = int(input("Enter a number: "))

# Check if the number is negative
if num < 0:
    print("Factorial doesn't exist for negative numbers")
else:
    result = factorial(num)
    print(f"The factorial of {num} is {result}")

This program uses recursion to calculate factorial. The base case is when n equals 0 or 1, and the recursive case multiplies n by the factorial of (n-1).

3. March 2022 Computer Application Question Paper with Answers

Question 1: What is the significance of MySQL PRIMARY KEY constraint? (1 mark) Answer: PRIMARY KEY constraint uniquely identifies each record in a table, cannot contain NULL values, and ensures data integrity.

Question 2: Explain the working of HTTP protocol with its different methods. (3 marks) Answer: HTTP (Hypertext Transfer Protocol) is the foundation of data communication on the web, working as a request-response protocol:

Client (browser) sends an HTTP request to the server
Server processes the request and sends an HTTP response
Client displays the received content

Common HTTP methods:

GET: Retrieves data from the server (no changes to server data)
POST: Submits data to be processed (may result in changes)
PUT: Updates specified resource
DELETE: Removes specified resource
HEAD: Same as GET but returns only headers (no content)
OPTIONS: Returns supported HTTP methods for a URL

HTTP is stateless, meaning each request is independent of previous requests.

Question 3: Design a webpage for a travel agency with the following sections: Header, Navigation bar, Main content, and Footer. Use appropriate CSS for styling. (5 marks) Answer:

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Adventure Travel Agency</title>
    <style>
        body {
            font-family: Arial, sans-serif;
            margin: 0;
            padding: 0;
            background-color: #f4f4f4;
        }
        
        header {
            background-color: #2c3e50;
            color: white;
            text-align: center;
            padding: 20px;
        }
        
        nav {
            background-color: #34495e;
            padding: 10px;
        }
        
        nav ul {
            list-style-type: none;
            margin: 0;
            padding: 0;
            text-align: center;
        }
        
        nav li {
            display: inline;
            margin: 0 15px;
        }
        
        nav a {
            color: white;
            text-decoration: none;
        }
        
        nav a:hover {
            text-decoration: underline;
        }
        
        main {
            padding: 20px;
            max-width: 1000px;
            margin: 0 auto;
        }
        
        .destination {
            background-color: white;
            border-radius: 5px;
            padding: 15px;
            margin-bottom: 20px;
            box-shadow: 0 2px 5px rgba(0,0,0,0.1);
        }
        
        footer {
            background-color: #2c3e50;
            color: white;
            text-align: center;
            padding: 10px;
            position: fixed;
            bottom: 0;
            width: 100%;
        }
    </style>
</head>
<body>
    <header>
        <h1>Adventure Travel Agency</h1>
        <p>Discover the world's most exciting destinations</p>
    </header>
    
    <nav>
        <ul>
            <li><a href="#">Home</a></li>
            <li><a href="#">Destinations</a></li>
            <li><a href="#">Packages</a></li>
            <li><a href="#">About Us</a></li>
            <li><a href="#">Contact</a></li>
        </ul>
    </nav>
    
    <main>
        <h2>Popular Destinations</h2>
        
        <div class="destination">
            <h3>Bali, Indonesia</h3>
            <p>Experience the perfect blend of stunning beaches, vibrant culture, and lush landscapes in this tropical paradise.</p>
        </div>
        
        <div class="destination">
            <h3>Swiss Alps</h3>
            <p>Explore breathtaking mountain scenery, charming villages, and world-class skiing in Switzerland.</p>
        </div>
        
        <div class="destination">
            <h3>Kerala, India</h3>
            <p>Discover the serene backwaters, lush tea plantations, and rich cultural heritage of God's Own Country.</p>
        </div>
    </main>
    
    <footer>
        <p>&copy; 2022 Adventure Travel Agency. All rights reserved.</p>
    </footer>
</body>
</html>

This design includes all required sections with appropriate styling using internal CSS.

4. March 2021 Computer Application Question Paper with Answers

Question 1: Define E-commerce. (1 mark) Answer: E-commerce (Electronic Commerce) refers to buying and selling of goods and services over the internet, including electronic funds transfer, online marketing, and online transaction processing.

Question 2: Explain the different data types available in Python with suitable examples. (3 marks) Answer: Python has several built-in data types:

Numeric Types:
- int: Whole numbers (e.g., x = 5)
- float: Decimal numbers (e.g., y = 3.14)
- complex: Complex numbers (e.g., z = 2+3j)
Sequence Types:
- str: Text strings (e.g., name = "Python")
- list: Ordered, mutable collections (e.g., fruits = ["apple", "banana", "cherry"])
- tuple: Ordered, immutable collections (e.g., coordinates = (10, 20))
Mapping Type:
- dict: Key-value pairs (e.g., person = {"name": "John", "age": 30})
Set Types:
- set: Unordered collection of unique items (e.g., colors = {"red", "green", "blue"})
- frozenset: Immutable version of set
Boolean Type:
- bool: True or False values (e.g., is_active = True)
None Type:
- None: Represents absence of value (e.g., result = None)

Question 5: Write a Python program to create a simple calculator to perform basic arithmetic operations. (5 marks) Answer:

def add(x, y):
    return x + y

def subtract(x, y):
    return x - y

def multiply(x, y):
    return x * y

def divide(x, y):
    if y == 0:
        return "Error! Division by zero."
    return x / y

print("Select operation:")
print("1. Add")
print("2. Subtract")
print("3. Multiply")
print("4. Divide")

while True:
    # Take input from the user
    choice = input("Enter choice (1/2/3/4): ")
    
    # Check if choice is valid
    if choice in ('1', '2', '3', '4'):
        num1 = float(input("Enter first number: "))
        num2 = float(input("Enter second number: "))
        
        if choice == '1':
            print(f"{num1} + {num2} = {add(num1, num2)}")
            
        elif choice == '2':
            print(f"{num1} - {num2} = {subtract(num1, num2)}")
            
        elif choice == '3':
            print(f"{num1} * {num2} = {multiply(num1, num2)}")
            
        elif choice == '4':
            print(f"{num1} / {num2} = {divide(num1, num2)}")
        
        # Check if user wants another calculation
        next_calculation = input("Do you want to perform another calculation? (yes/no): ")
        if next_calculation.lower() != "yes":
            break
    else:
        print("Invalid Input")

This program provides a simple calculator that can perform addition, subtraction, multiplication, and division operations based on user input.

5. March 2020 Computer Application Question Paper with Answers

Question 1: What is the role of WHERE clause in SQL? (1 mark) Answer: The WHERE clause in SQL is used to filter records based on specific conditions, allowing you to extract only the records that fulfill a specified criterion.

Question 2: Explain the Box Model concept in CSS with a diagram. (3 marks) Answer: The CSS Box Model describes how HTML elements are rendered as rectangular boxes:

Content: The actual text, images, or other media
Padding: Clear space around the content (inside the border)
Border: A line that surrounds the padding
Margin: Clear space outside the border

Each box component can be adjusted using CSS properties:

content size: width, height
padding: padding-top, padding-right, padding-bottom, padding-left
border: border-width, border-style, border-color
margin: margin-top, margin-right, margin-bottom, margin-left

The total width of an element = width + left padding + right padding + left border + right border + left margin + right margin

The total height of an element = height + top padding + bottom padding + top border + bottom border + top margin + bottom margin

Question 3: Create a database schema for a library management system with tables for books, members, and borrowing transactions. Write SQL queries to create these tables with appropriate constraints. (5 marks) Answer:

-- Create Books table
CREATE TABLE Books (
    BookID INT PRIMARY KEY,
    Title VARCHAR(100) NOT NULL,
    Author VARCHAR(100),
    Publisher VARCHAR(100),
    ISBN VARCHAR(20) UNIQUE,
    Category VARCHAR(50),
    PublishedYear INT,
    AvailableQuantity INT DEFAULT 0
);

-- Create Members table
CREATE TABLE Members (
    MemberID INT PRIMARY KEY,
    Name VARCHAR(100) NOT NULL,
    Address VARCHAR(200),
    PhoneNumber VARCHAR(15),
    Email VARCHAR(100) UNIQUE,
    JoinDate DATE DEFAULT CURRENT_DATE,
    MembershipStatus VARCHAR(20) DEFAULT 'Active',
    MembershipExpiry DATE
);

-- Create Transactions table
CREATE TABLE Transactions (
    TransactionID INT PRIMARY KEY,
    BookID INT,
    MemberID INT,
    IssueDate DATE NOT NULL,
    DueDate DATE NOT NULL,
    ReturnDate DATE,
    FineAmount DECIMAL(10,2) DEFAULT 0.00,
    FOREIGN KEY (BookID) REFERENCES Books(BookID),
    FOREIGN KEY (MemberID) REFERENCES Members(MemberID)
);

-- Create index for faster searches
CREATE INDEX idx_book_title ON Books(Title);
CREATE INDEX idx_member_name ON Members(Name);
CREATE INDEX idx_transaction_dates ON Transactions(IssueDate, DueDate);

This schema includes three main tables with appropriate relationships:

Books table stores information about library books
Members table stores information about library members
Transactions table records book borrowing history

The schema includes primary keys, foreign keys, unique constraints, default values, and indexes for efficient database operations.

Additional Plus Two Computer Application Previous Year Question Papers with Answers (HSSlive PDF Collection)

6. March 2019 Computer Application Question Paper with Answers

Question 1: What is the difference between client-side and server-side scripting? (1 mark) Answer: Client-side scripting executes in the user’s browser (e.g., JavaScript), while server-side scripting executes on the web server (e.g., PHP, Python) before sending results to the browser.

Question 2: Explain the concept of inheritance in Object-Oriented Programming with an example. (3 marks) Answer: Inheritance is an OOP concept where a class (child/derived class) inherits properties and methods from another class (parent/base class). This promotes code reusability and establishes a hierarchical relationship between classes.

Example in Python:

# Parent class
class Vehicle:
    def __init__(self, brand, color):
        self.brand = brand
        self.color = color
        
    def display_info(self):
        print(f"Brand: {self.brand}, Color: {self.color}")
        
    def move(self):
        print("Vehicle is moving")

# Child class inheriting from Vehicle
class Car(Vehicle):
    def __init__(self, brand, color, model):
        # Call parent class constructor
        super().__init__(brand, color)
        self.model = model
        
    def display_info(self):
        # Override parent method
        super().display_info()
        print(f"Model: {self.model}")
        
    def honk(self):
        # New method specific to Car
        print("Car is honking")

# Create a Car object
my_car = Car("Toyota", "Blue", "Corolla")
my_car.display_info()  # Calls overridden method
my_car.move()          # Calls inherited method
my_car.honk()          # Calls child-specific method

Benefits of inheritance include:

Code reusability
Method overriding (runtime polymorphism)
Hierarchical classification
Reduced redundancy

Question 3: Create a dynamic web page using PHP to create a student registration form with validation. (5 marks) Answer:

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Student Registration Form</title>
    <style>
        body {
            font-family: Arial, sans-serif;
            margin: 0;
            padding: 20px;
            background-color: #f4f4f4;
        }
        .container {
            max-width: 600px;
            margin: 0 auto;
            background: white;
            padding: 20px;
            border-radius: 5px;
            box-shadow: 0 0 10px rgba(0,0,0,0.1);
        }
        .form-group {
            margin-bottom: 15px;
        }
        label {
            display: block;
            margin-bottom: 5px;
            font-weight: bold;
        }
        input, select {
            width: 100%;
            padding: 8px;
            border: 1px solid #ddd;
            border-radius: 4px;
            box-sizing: border-box;
        }
        .error {
            color: red;
            font-size: 14px;
        }
        button {
            background-color: #4CAF50;
            color: white;
            padding: 10px 15px;
            border: none;
            border-radius: 4px;
            cursor: pointer;
        }
        button:hover {
            background-color: #45a049;
        }
        .success {
            background-color: #dff0d8;
            color: #3c763d;
            padding: 10px;
            margin-bottom: 20px;
            border-radius: 4px;
        }
    </style>
</head>
<body>
    <div class="container">
        <h2>Student Registration Form</h2>
        
        <?php
        // Define variables and set to empty values
        $nameErr = $emailErr = $phoneErr = $courseErr = "";
        $name = $email = $phone = $course = $address = "";
        $success = "";
        $error = false;
        
        // Form processing
        if ($_SERVER["REQUEST_METHOD"] == "POST") {
            // Validate name
            if (empty($_POST["name"])) {
                $nameErr = "Name is required";
                $error = true;
            } else {
                $name = test_input($_POST["name"]);
                // Check if name only contains letters and whitespace
                if (!preg_match("/^[a-zA-Z ]*$/", $name)) {
                    $nameErr = "Only letters and white space allowed";
                    $error = true;
                }
            }
            
            // Validate email
            if (empty($_POST["email"])) {
                $emailErr = "Email is required";
                $error = true;
            } else {
                $email = test_input($_POST["email"]);
                // Check if e-mail address is well-formed
                if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
                    $emailErr = "Invalid email format";
                    $error = true;
                }
            }
            
            // Validate phone
            if (empty($_POST["phone"])) {
                $phoneErr = "Phone number is required";
                $error = true;
            } else {
                $phone = test_input($_POST["phone"]);
                // Check if phone number is valid (10 digits)
                if (!preg_match("/^[0-9]{10}$/", $phone)) {
                    $phoneErr = "Invalid phone number (must be 10 digits)";
                    $error = true;
                }
            }
            
            // Validate course
            if (empty($_POST["course"])) {
                $courseErr = "Course is required";
                $error = true;
            } else {
                $course = test_input($_POST["course"]);
            }
            
            // Get address
            $address = test_input($_POST["address"]);
            
            // If no errors, process the form
            if (!$error) {
                $success = "Registration successful! Thank you, $name.";
                // Clear form fields after successful submission
                $name = $email = $phone = $course = $address = "";
            }
        }
        
        // Function to sanitize input data
        function test_input($data) {
            $data = trim($data);
            $data = stripslashes($data);
            $data = htmlspecialchars($data);
            return $data;
        }
        ?>
        
        <?php if (!empty($success)): ?>
            <div class="success"><?php echo $success; ?></div>
        <?php endif; ?>
        
        <form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>">
            <div class="form-group">
                <label for="name">Name:</label>
                <input type="text" id="name" name="name" value="<?php echo $name; ?>">
                <span class="error"><?php echo $nameErr; ?></span>
            </div>
            
            <div class="form-group">
                <label for="email">Email:</label>
                <input type="text" id="email" name="email" value="<?php echo $email; ?>">
                <span class="error"><?php echo $emailErr; ?></span>
            </div>
            
            <div class="form-group">
                <label for="phone">Phone Number:</label>
                <input type="text" id="phone" name="phone" value="<?php echo $phone; ?>">
                <span class="error"><?php echo $phoneErr; ?></span>
            </div>
            
            <div class="form-group">
                <label for="course">Course:</label>
                <select id="course" name="course">
                    <option value="" <?php if ($course == "") echo "selected"; ?>>Select Course</option>
                    <option value="Computer Science" <?php if ($course == "Computer Science") echo "selected"; ?>>Computer Science</option>
                    <option value="Information Technology" <?php if ($course == "Information Technology") echo "selected"; ?>>Information Technology</option>
                    <option value="Computer Applications" <?php if ($course == "Computer Applications") echo "selected"; ?>>Computer Applications</option>
                    <option value="Data Science" <?php if ($course == "Data Science") echo "selected"; ?>>Data Science</option>
                </select>
                <span class="error"><?php echo $courseErr; ?></span>
            </div>
            
            <div class="form-group">
                <label for="address">Address:</label>
                <input type="text" id="address" name="address" value="<?php echo $address; ?>">
            </div>
            
            <button type="submit">Register</button>
        </form>
    </div>
</body>
</html>

This PHP script creates a student registration form with:

Form validation for name, email, phone, and course
Proper error messages
Success confirmation after valid submission
Data sanitization for security
Responsive CSS styling

7. March 2018 Computer Application Question Paper with Answers

Question 1: What is AJAX? (1 mark) Answer: AJAX (Asynchronous JavaScript and XML) is a technique that allows web pages to update asynchronously by exchanging data with a web server behind the scenes, enabling updates to parts of a web page without reloading the entire page.

Question 2: Explain different types of computer networks based on geographical area. (3 marks) Answer: Computer networks are classified based on geographical area coverage:

PAN (Personal Area Network):
- Covers smallest area (typically within reach of a person)
- Range: Up to 10 meters
- Technologies: Bluetooth, Infrared, NFC
- Examples: Connecting mobile phones, headsets, printers
LAN (Local Area Network):
- Covers limited area like home, school, or office building
- Range: Up to 1 kilometer
- Technologies: Ethernet, Wi-Fi
- Characterized by high data transfer rates and low error rates
MAN (Metropolitan Area Network):
- Spans a city or large campus
- Range: Up to 50 kilometers
- Often connects multiple LANs
- Example: Cable TV networks in cities
WAN (Wide Area Network):
- Spans large geographical areas (countries, continents)
- Uses public transmission systems or satellites
- Lower data transfer rates compared to LAN
- Example: Internet is the largest WAN

Each network type has different transmission media, protocols, and management requirements based on its coverage area.

Question 3: Write a Python program to implement a Stack data structure with push, pop, and display operations. (5 marks) Answer:

class Stack:
    def __init__(self):
        self.items = []
        self.max_size = 10  # Define maximum stack size
    
    def is_empty(self):
        return len(self.items) == 0
    
    def is_full(self):
        return len(self.items) >= self.max_size
    
    def push(self, item):
        if self.is_full():
            print("Stack Overflow: Cannot push item, stack is full")
        else:
            self.items.append(item)
            print(f"Pushed {item} to the stack")
    
    def pop(self):
        if self.is_empty():
            print("Stack Underflow: Cannot pop from an empty stack")
            return None
        else:
            popped_item = self.items.pop()
            print(f"Popped {popped_item} from the stack")
            return popped_item
    
    def peek(self):
        if self.is_empty():
            print("Stack is empty")
            return None
        else:
            return self.items[-1]
    
    def display(self):
        if self.is_empty():
            print("Stack is empty")
        else:
            print("Stack contents (top to bottom):")
            for item in reversed(self.items):
                print(f"| {item} |")
            print("-------")
    
    def size(self):
        return len(self.items)


# Menu-driven program to test Stack operations
def main():
    stack = Stack()
    
    while True:
        print("\nStack Operations:")
        print("1. Push")
        print("2. Pop")
        print("3. Peek (Top element)")
        print("4. Display stack")
        print("5. Check size")
        print("6. Exit")
        
        choice = input("Enter your choice (1-6): ")
        
        if choice == '1':
            if not stack.is_full():
                item = input("Enter item to push: ")
                stack.push(item)
            else:
                print("Stack is full")
        
        elif choice == '2':
            stack.pop()
        
        elif choice == '3':
            top = stack.peek()
            if top is not None:
                print(f"Top element: {top}")
        
        elif choice == '4':
            stack.display()
        
        elif choice == '5':
            print(f"Stack size: {stack.size()}")
        
        elif choice == '6':
            print("Exiting program...")
            break
        
        else:
            print("Invalid choice. Please enter a number between 1 and 6.")


if __name__ == "__main__":
    main()

This implementation includes:

A Stack class with basic operations (push, pop, peek, display)
Stack overflow and underflow handling
A menu-driven interface for testing
Various helper methods (is_empty, is_full, size)

8. March 2017 Computer Application Question Paper with Answers

Question 1: What is the purpose of JavaScript in web development? (1 mark) Answer: JavaScript is used to create interactive and dynamic web pages by manipulating the Document Object Model (DOM), handling events, validating forms, creating animations, and enabling asynchronous communication with servers.

Question 2: Write the syntax and explain the working of ‘for’ loop in Python with an example. (3 marks) Answer: The syntax of a ‘for’ loop in Python is:

for variable in sequence:
    # statements to be executed

Working of ‘for’ loop:

The loop iterates over each item in the given sequence (list, tuple, string, etc.)
For each iteration, the loop variable takes the value of the current item
The statements inside the loop are executed once for each item
After processing all items, the loop terminates

Example:

# Program to calculate sum of numbers in a list
numbers = [10, 20, 30, 40, 50]
sum = 0

for num in numbers:
    sum += num
    print(f"Current number: {num}, Running sum: {sum}")

print(f"Final sum: {sum}")

Output:

Current number: 10, Running sum: 10
Current number: 20, Running sum: 30
Current number: 30, Running sum: 60
Current number: 40, Running sum: 100
Current number: 50, Running sum: 150
Final sum: 150

The ‘for’ loop in Python is more versatile than in other languages as it can iterate over any sequence, including strings, lists, tuples, dictionaries, and files. It can also be combined with the range() function to iterate a specific number of times.

Question 3: Create a MySQL database to store student information. Write SQL queries to perform the following operations: (5 marks) a) Create a table to store student details b) Insert records of 5 students c) Update a student’s phone number d) List students in descending order of marks e) Find the average mark in each subject

Answer:

-- a) Create a table to store student details
CREATE TABLE Students (
    StudentID INT PRIMARY KEY AUTO_INCREMENT,
    Name VARCHAR(100) NOT NULL,
    DOB DATE,
    Gender CHAR(1),
    PhoneNumber VARCHAR(15),
    Address VARCHAR(200),
    Class VARCHAR(10)
);

CREATE TABLE Subjects (
    SubjectID INT PRIMARY KEY AUTO_INCREMENT,
    SubjectName VARCHAR(50) NOT NULL
);

CREATE TABLE Marks (
    MarkID INT PRIMARY KEY AUTO_INCREMENT,
    StudentID INT,
    SubjectID INT,
    Mark FLOAT,
    FOREIGN KEY (StudentID) REFERENCES Students(StudentID),
    FOREIGN KEY (SubjectID) REFERENCES Subjects(SubjectID)
);

-- b) Insert records of 5 students
INSERT INTO Students (Name, DOB, Gender, PhoneNumber, Address, Class) VALUES
('Arun Kumar', '2005-06-15', 'M', '9876543210', 'Trivandrum, Kerala', 'Plus Two'),
('Meera Nair', '2005-08-22', 'F', '8765432109', 'Kochi, Kerala', 'Plus Two'),
('Rahul Singh', '2005-03-10', 'M', '7654321098', 'Kozhikode, Kerala', 'Plus Two'),
('Anjali Menon', '2005-11-05', 'F', '6543210987', 'Thrissur, Kerala', 'Plus Two'),
('Mohammed Ali', '2005-01-25', 'M', '5432109876', 'Kollam, Kerala', 'Plus Two');

INSERT INTO Subjects (SubjectName) VALUES
('Computer Application'),
('Physics'),
('Chemistry'),
('Mathematics'),
('English');

-- Insert marks for students in various subjects
INSERT INTO Marks (StudentID, SubjectID, Mark) VALUES
(1, 1, 85), (1, 2, 78), (1, 3, 82), (1, 4, 90), (1, 5, 88),
(2, 1, 92), (2, 2, 85), (2, 3, 79), (2, 4, 94), (2, 5, 90),
(3, 1, 78), (3, 2, 72), (3, 3, 75), (3, 4, 80), (3, 5, 85),
(4, 1, 95), (4, 2, 88), (4, 3, 90), (4, 4, 92), (4, 5, 85),
(5, 1, 82), (5, 2, 75), (5, 3, 78), (5, 4, 86), (5, 5, 80);

-- c) Update a student's phone number
UPDATE Students 
SET PhoneNumber = '9898989898' 
WHERE StudentID = 3;

-- d) List students in descending order of marks (using average marks)
SELECT 
    s.StudentID, 
    s.Name, 
    AVG(m.Mark) AS AverageMark
FROM 
    Students s
JOIN 
    Marks m ON s.StudentID = m.StudentID
GROUP BY 
    s.StudentID, s.Name
ORDER BY 
    AverageMark DESC;

-- e) Find the average mark in each subject
SELECT 
    sub.SubjectName, 
    AVG(m.Mark) AS AverageMark
FROM 
    Subjects sub
JOIN 
    Marks m ON sub.SubjectID = m.SubjectID
GROUP BY 
    sub.SubjectID, sub.SubjectName
ORDER BY 
    AverageMark DESC;

This SQL script:

Creates a normalized database with Students, Subjects, and Marks tables
Inserts 5 student records and their marks in 5 subjects
Updates a student’s phone number
Lists students in descending order of their average marks
Finds the average mark for each subject

The design uses foreign key relationships to maintain data integrity.

9. March 2016 Computer Application Question Paper with Answers

Question 1: What is the difference between GET and POST methods in HTML forms? (1 mark) Answer: GET method appends form data to the URL (visible, limited data size, bookmarkable) while POST method sends data in the HTTP request body (invisible in URL, no size limitation, more secure, not bookmarkable).

Question 2: Explain the concept of functions in Python with suitable examples. (3 marks) Answer: Functions in Python are reusable blocks of code that perform specific tasks. They help in organizing code, improving readability, and enabling code reuse.

Syntax:

def function_name(parameters):
    """Docstring - describes function purpose"""
    # Function body
    # statements
    return value  # optional

Types of Functions:

Built-in functions (e.g., print(), len(), range())
User-defined functions

Example 1: Function without parameters and return value

def greet():
    """Displays a simple greeting message"""
    print("Hello, welcome to Python programming!")

# Function call
greet()

Example 2: Function with parameters and return value

def calculate_area(length, width):
    """
    Calculate area of a rectangle
    Args:
        length: Length of rectangle
        width: Width of rectangle
    Returns:
        Area of rectangle
    """
    area = length * width
    return area

# Function call
rectangle_area = calculate_area(5, 3)
print(f"Area of rectangle: {rectangle_area} square units")

Example 3: Function with default parameters

def power(base, exponent=2):
    """
    Calculate power of a number
    Args:
        base: The base number
        exponent: The exponent (default is 2)
    Returns:
        Result of base raised to exponent
    """
    return base ** exponent

# Function calls
square = power(5)  # Uses default exponent 2
cube = power(5, 3)  # Uses provided exponent 3
print(f"Square: {square}, Cube: {cube}")

Functions improve code organization, enable reusability, and follow the DRY (Don’t Repeat Yourself) principle.

Question 3: Create a simple website for a school with the following features: (5 marks) a) Home page with school details and navigation b) Faculty page listing teachers c) Contact page with a feedback form d) Use CSS for styling