Paper 1 (Basic Level)

Section A – LibreOffice Writer (35 Marks)

Create a document titled “Digital India Mission” and perform the following:

1. Type the given text (provided in the question).
2. Format the title:
   • Font: Liberation Serif
   • Size: 20 pt
   • Bold
   • Blue
   • Center aligned
3. Apply:
   • Line spacing: 1.5
   • Justified alignment
4. Insert a 5 × 4 table.
5. Merge the first row.
6. Apply table borders and background color.
7. Insert page number.
8. Insert header containing your name.
9. Insert footer containing today’s date.
10. Save as P1_Writer.odt and export as PDF.

Marks: 35

Section B – LibreOffice Calc (35 Marks)

Prepare the following marksheet.

Roll	Name	English	Maths	Computer
101	Amit	76	81	92
102	Neha	64	72	75
103	Rahul	89	91	87
104	Riya	58	66	71
105	Mohit	83	79	90

Calculate:

• Total
• Average
• Percentage
• Result (Pass/Fail using IF)
• Grade (A/B/C/F)

Apply:

• Currency and Percentage formats where appropriate
• Conditional Formatting (Percentage < 40)
• Sort by Percentage (Descending)
• Create a Column Chart

Save as P1_Calc.ods.

Marks: 35

Section C – LibreOffice Impress (15 Marks)

Create a 5-slide presentation on “Cyber Security Awareness”.

Include:

• Title slide
• Types of cyber threats
• Safety tips
• One image
• Thank You slide

Apply:

• One slide transition
• Two custom animations

Save as P1_Impress.odp.

Marks: 15

Section D – File Management (10 Marks)

1. Create folder OLEVEL_P1.
2. Create subfolders:
   • Writer
   • Calc
   • Impress
3. Copy your practical files into the respective folders.
4. Compress the folder into a ZIP archive.
5. Rename the ZIP file to OLEVEL_P1.zip.

Marks: 10

Section E – Viva (5 Marks)

Answer any five:

1. What is the default extension of Writer?
2. Difference between Save and Save As.
3. What is a Style in Writer?
4. What is the purpose of the IF() function?
5. Difference between Relative and Absolute cell references.
6. What is a slide transition?
7. What is PDF Export?
8. What is Conditional Formatting?

 

 

 

 

 

 

 

PRACTICAL (Basic level 2)

Time: 3 Hours
Maximum Marks: 100

Section A – LibreOffice Writer (35 Marks)

Create a document titled “Digital Banking in India”.

Perform the following:

1. Type the given text (approximately 350 words).
2. Title: 20 pt, Bold, Dark Blue, Center.
3. Divide the document into two columns.
4. Insert two relevant images.
5. Wrap text around the images.
6. Add a page border.
7. Create a bulleted list of Digital Banking Services.
8. Insert a footer with your registration number.
9. Insert page numbers.
10. Save as Paper2_Writer.odt and export as PDF.

Section B – LibreOffice Calc (35 Marks)

Prepare the following sales report.

Product	Jan	Feb	Mar
Laptop	45000	48000	52000
Printer	15000	16000	17000
Scanner	12000	13500	14500
Monitor	18000	19000	21000
UPS	9000	9500	11000

Calculate:

• Total Sales (SUM)
• Average Sales (AVERAGE)
• Highest Sale (MAX)
• Lowest Sale (MIN)

Apply:

• Currency format
• Cell borders
• Background color
• AutoFill
• Create a Pie Chart showing total sales by product.

Save as Paper2_Calc.ods

Section C – LibreOffice Impress (15 Marks)

Create a 6-slide presentation on “Green Energy”.

Include:

• Title slide
• Solar Energy
• Wind Energy
• Hydro Energy
• Benefits
• Thank You

Apply:

• One theme
• Slide transitions
• Object animations

Section D – File Management (10 Marks)

1. Create folder Paper2
2. Create subfolders:
   • Writer
   • Calc
   • Impress
3. Move respective files into folders.
4. Compress the folder.
5. Rename ZIP file as Paper2.zip

Section E – Viva (5 Marks)

1. What is a column layout?
2. Difference between Copy and Move.
3. What is SUM()?
4. What is MAX()?
5. What is a Theme in Impress?

BASIC LEVEL 3

Time: 3 Hours
Maximum Marks: 100

Section A – LibreOffice Writer (35 Marks)

Prepare a professional Resume containing:

• Personal Details
• Career Objective
• Educational Qualification (Table)
• Technical Skills
• Work Experience
• Declaration
• Date and Signature

Formatting:

• Page border
• Header
• Footer
• Bullets
• Bold headings

Save as Resume.odt

Section B – LibreOffice Calc (35 Marks)

Prepare the following salary sheet.

Employee	Basic
Amit	22000
Neha	28000
Rahul	32000
Riya	26000
Mohit	24000

Calculate:

• HRA = 20%
• DA = 10%
• Gross Salary
• PF = 12%
• Net Salary

Create a Column Chart showing Net Salary.

Save as Salary.ods

Section C – LibreOffice Impress (15 Marks)

Prepare a Company Profile presentation (6 slides).

Include:

• Company Introduction
• Vision & Mission
• Products
• Services
• Achievements
• Contact Details

Apply:

• Theme
• Images
• Animation
• Transition

Section D – File Management (10 Marks)

• Create folder CompanyProject
• Copy all practical files
• Compress into ZIP
• Rename to CompanyProject.zip

Section E – Viva (5 Marks)

1. What is a Resume?
2. Difference between Gross Salary and Net Salary.
3. What is HRA?
4. What is a Header?
5. What is Animation?

BASIC LEVEL 4

Time: 3 Hours
Maximum Marks: 100

Section A – LibreOffice Writer (35 Marks)

Prepare a report on “Artificial Intelligence in Education”.

Requirements:

1. Cover Page
2. Table of Contents
3. Heading Styles
4. Page Break
5. Header & Footer
6. Insert one table
7. Insert one image with caption
8. Hyperlink to an official website
9. Export as PDF

Save as AI_Report.odt

Section B – LibreOffice Calc (35 Marks)

Prepare the attendance sheet.

Roll	Name	Present Days

Calculate:

• Attendance %
• Result (Present/Shortage using IF)
• Number of students having attendance ≥ 75% using COUNTIF

Apply:

• Data Validation (attendance between 0–100)
• Conditional Formatting
• Auto Filter
• Create a Bar Chart

Save as Attendance.ods

Section C – LibreOffice Impress (15 Marks)

Prepare a 7-slide presentation on Cloud Computing.

Include:

• Smart layout
• Images
• Slide transitions
• Animations

Section D – File Management (10 Marks)

• Create project folder
• Organize files
• Compress into ZIP
• Rename archive

Section E – Viva (5 Marks)

1. What is a Style?
2. What is a Table of Contents?
3. Explain COUNTIF().
4. What is Data Validation?
5. What is Conditional Formatting?

BASIC LEVEL 5

Time: 3 Hours
Maximum Marks: 100

Section A – LibreOffice Writer (35 Marks)

Using Mail Merge, prepare appointment letters for 10 employees.

Requirements:

1. Create data source.
2. Create main document.
3. Merge records.
4. Insert company logo.
5. Insert date.
6. Save merged letters.

Section B – LibreOffice Calc (35 Marks)

Prepare the following attendance register.

Employee	Total Days	Present	Leave

Calculate:

• Attendance %
• Leave %
• Status (IF)
• Apply Conditional Formatting.
• Sort by Attendance %.
• Create:
  • Bar Chart
  • Pie Chart

Save as AttendanceRegister.ods

Section C – LibreOffice Impress (15 Marks)

Create an 8-slide presentation on Digital India Programme.

Include:

• Theme
• Images
• Tables
• Transition
• Animation
• Hyperlink

Section D – File Management (10 Marks)

1. Create folder OfficeProject.
2. Organize all files into appropriate subfolders.
3. Compress into ZIP.
4. Rename as OfficeProject.zip.

Section E – Viva (5 Marks)

1. What is Mail Merge?
2. Difference between Sort and Filter.
3. What is a Data Source?
4. What is a Hyperlink?
5. Difference between Transition and Animation.

These papers follow the current LibreOffice-based NIELIT O Level M1-R5.1 practical pattern