Sample Paper
Practical Examination(2024-25)
Section A
Q.1 Open OpenOffice writer and create table of contents as follows: 5M
Q.2 Create a new file in spreadsheet software. Follow these instructions. 5M
1. Create following spreadsheet and follow the instructions:
For above spreadsheet consider the formula for profit as =B1/B2
Create following scenarios in spreadsheet:
Scenario Name Runs Overs Colour Tab
TW20 195 20 Red
TH30 235 30 Black
FR40 341 40 Blue
FF50 445 50 Green
Delete the scenario TH30
Rename scenario FR40 to O40
Page 1 of 3
Q.3 a)Create following table empl in OO Base and perform below given queries: 5M
EMPNO NAME DOJ SALARY CITY
5001 BIJAL PATEL 2019-05-12 55000 AHEMDABAD
5002 MEHUL SOLANKI 2020-10-11 65000 SURAT
5003 ASHOK CHAUHAN 2018-09-07 80000 AHEMDABAD
5004 VIJAY CHANDERA 2017-08-02 60000 BHARUCH
5005 RAKESH SHAH 2016-05-23 72000 AHEMDABAD
1. Create above table using SQL command.
2. Write Queries for the following:
a. Display the details of employee whose salary ranges from 60000 to 75000.
b. Display empno, ename, doj and salary of employees belongs to Ahmedabad and
Surat.
c. Display ename and salary of employees except 5001.
Q.3 b) Create a form using wizard enter, delete and show data of employee. 3M
Q.3 c) Create a report showing data department wise. 2M
OR
Q. 4 Create a new file in spreadsheet software. Follow these instructions. 5M
1. Create following spreadsheet and follow the instructions:
- For above spreadsheet consider the formula for profit as =B4-B2-B3
- Obtain the solution for Cost price so that profit will be 10000.
Q.5 Open OO writer and create a template. Follow the below given instructions 5M
Part I – Create and use template
1. Create a style “Pl_Heading” as shown in the paragraph. Consider the following
formatting:
o Font – Arial Black o Colour - Blue
o Size – 24 o Alignment - Center
Page 2 of 3
2. Insert a shape and keep as place holder for image.
3. Type the text as displayed below with body text style to give introduction of player.
4. Insert table as given below and apply the formatting.
5. Create template using above formatting and set it as detault.
Player Profile
Write a brief introduction about player. Introduction includes what the player
Player
Photo is , which country he is representing, for which teams he played. Some of
his personal traits etc. Write about his personal life in short in this section of
profile page. This is profile template.
Personal Information
Born Date of Birth
NickName Text
Height Text
Expertise Text
Page 3 of 3
