Maharashtra Board Class 11 Information Technology Set 1 Daily Computing Libre Office Solutions

Question. SOP 1: Create a Resume
The resume should contain the following:
(i) Title at the center with applicable font and size.
Answer:
1. Open LibreOffice Writer on your computer.
2. Type the title "RESUME" at the very top of the document.
3. Select the typed title text, then click on the "Align Center" icon on the formatting toolbar (or press Ctrl + E) to center it.
4. Change the font size to 16pt or 18pt and click the "Bold" icon to make the title stand out professionally.
In simple words: To start your resume, open the word processor, type "RESUME" at the top, and use the center alignment tool to place it in the middle of the page with a large, bold font.

🎯 Exam Tip: Always use the built-in alignment tools (Center Align) instead of pressing the spacebar to position your title, as this ensures perfect centering on any screen or paper size.

Question. Create a resume with the following specifications:
• It should contain points such as Name, Address, Mobile Number, Date of Birth, Nationality, Caste, Category, Hobbies, etc. Add some extra points.
• For educational qualifications, a student should insert a table.
• In the end, students should write a few lines about their aim.
Answer:
Step 1: Click on the LibreOffice Writer icon.
Step 2: Create a New File.
File Menu → New → Text Document
Step 3: Write Title at the center with applicable font size. (Resume).
Step 4: Type Name, Address, Mobile Number, Date of Birth, Nationality, Caste, Category, Hobbies, etc.
Step 5: Write Student educational qualifications (Insert Table).
Choose Table Menu → Insert Table → Select number of rows and columns → Insert.
Step 6: Write some lines about the aim, select the text and make it bold by clicking on the bold option from the formatting toolbar.
After Completing this practical students will learn how to create resumes using LibreOffice, also tab setting and table creation.
In simple words: To make a resume, open LibreOffice Writer, type your personal details, insert a table for your marks, and write your career goal in bold letters.

🎯 Exam Tip: When creating a resume, always use a professional font size (like 12pt for body text and 14pt for headings) and ensure the table columns are aligned properly.

SOP 2: By using Mail Merge send an invitation for your birthday party.
• Use the mail merge feature.
• Send an invitation to at least 5 friends.
Answer:
Choose Tools - Mail Merge Wizard.
Step 1: Select Start from a template, and click the Browse button. You see the New dialog.
In simple words: Mail Merge lets you create a single invitation letter and automatically customize it with different friends' names and addresses.

🎯 Exam Tip: Make sure to prepare your recipient list (address list) beforehand to smoothly complete the Mail Merge steps during your practical exam.

Question. SOP 2 (Continued)
Answer:
Step 2: Select five friends Details in the left list, and then the Invitation letter in the right list.
Click OK to close the Templates dialog, and click Next in the wizard.

Step 3: Select Letter and click Next.

Step 4: On the next step of the wizard, click the Select Address List button to check that you are using the correct address list. If you want to use an address block, select an address block type, match the data fields if necessary, and click Next.

Step 5: Next follows the Create a salutation step. Deselect the Insert personalized salutation box. Under General salutation, select the salutation that you want on top of all letters.

Step 6: If you want to place mail merge fields anywhere else in the Invitation document select the corresponding column in your address data source and then drag and drop the column header into the invitation document where you would like the field to be. Be sure to select the entire column.

Step 7: Click Next and finally Finish creating the mail merge.
In simple words: These steps complete the mail merge process by selecting your friends' details, setting up the letter template, adding the address list, and placing the fields where you want them before finishing.

🎯 Exam Tip: Remember to select the entire column when dragging mail merge fields to ensure the data maps correctly in your document.

Question. SOP 3: Create a mark list. The mark list should display:
• Fields as Name, Math, Physics, Chemistry, Biology, Total, Percentage.
• Below each subject find out the lowest marks and highest marks.
• Enter a minimum of 10 records.
• Declare the first three ranker students.
• Create a chart based on the above data.
Answer:
Step 1: Open LibreOffice Calc and add fields like Name, Math, Physics, Chemistry, Biology, Total, Percentage.

Step 2: Enter 10 records in it.

Step 3: To Calculate Total
Click inside the cell where the total has to be calculated.
(Use =SUM(A2:D2) formula) - Type the range of cell.
In simple words: To create a mark list, open LibreOffice Calc, enter the student details and marks, and then use the SUM formula to calculate the total marks for each student.

🎯 Exam Tip: Always double-check your cell ranges in formulas like SUM to ensure you are calculating the correct values for your mark list.

Question. [Spreadsheet Practical Steps Continued]
Answer:
Step 4: Now click inside the cell where the percentage has to be calculated. Calculate Percentage using formula = E2* 100/400, drag the formula for remaining cells.
Step 5: Enter a minimum of 10 records. And calculate the result.
Step 6: Find out the Lowest Marks. Calculate Lowest marks using formula = min(A2:A11), drag formula for remaining cells.
Step 7: Find out the Highest Marks. Calculate Highest marks using formula =max(A2:A11), drag formula for remaining cells.
Step 8: Now Show the first three ranker students. Use Sort Option for sorting and auto filter.
Step 9: To find the first ranker use formula =large(F2:F11,1)
Step 10: To find the second ranker use formula =large(F2:F11,2)
Step 11: To find the third ranker use formula =large(F2:F11,3)
Step 12: To create a chart Select Complete Table → Click on Insert Menu → Click on Chart Option. A window will appear, which starts with the chart wizard → Select Chart type.
In simple words: These steps show how to calculate percentages, find the lowest and highest marks, rank the top three students, and insert a chart in a spreadsheet.

🎯 Exam Tip: Remember to use the correct syntax for formulas like min, max, and large, and ensure your cell ranges are accurate to avoid formula errors.

Question. SOP 4: Create an Informative presentation on your college.
• The presentation should contain a minimum of 8 slides.
• One slide should contain a chart.
• One slide with an image.
• Each slide should contain custom animation & slide transition effect.
Answer:
Step 1: Preparing an Eight slide for an Informative presentation of your college.
In simple words: To create a college presentation, you need to make at least 8 slides, include a chart and an image, and add animations and transitions to make it look professional.

🎯 Exam Tip: When creating presentations, always ensure that slide transitions and animations are consistent and not overly distracting to the audience.

Practical Procedure (Continued)

Step 1: Press the Ctrl + N Keys. OR choose Slide → New Slide from Menu bar. OR Click on the New Slide icon on the Standard Toolbar.

Step 2: Specify the background image. OR background colour. Now First Choose Slide Menu → Click on Insert Menu → Click on Image Submenu (inserting college Image with information).

Step 3: Click on Insert Menu → Click on Chart Option.

Step 4: Click on object presentation → from slide bar select Custom Animation each object → Choose category, effect, duration, direction, etc.

Step 5: Click on Press F5 function key for slide show OR Select slide menu → Start from the first Slide from the menu bar. OR Click on the start from the first slide Icon on the standard.

Conclusion: After Completing this practical students will be known how to create an informative presentation, custom animation & slide transition effect using Libre Office Impress.

🎯 Exam Tip: For practical exams, always remember that F5 is the shortcut key to start a slide show from the first slide, and Shift + F5 is used to start from the current slide.