TalentJR apps
Textbook: Information Technology – Class 11 (Balbharati, official free PDF) · pages 72–83
Resumes, invitation letters, mark lists and college presentations — this skill set teaches the free LibreOffice suite you will use for all of them. Learn the five main applications and their file types, the Writer screen, text and paragraph formatting, tables, mail merge, Calc formulas, AutoFill, sorting, charts and filters, and Impress slides, transitions and animations, then work through all four practicals (SOP 1–4) step by step.
LibreOffice is a free, open-source office suite. Writer is the word processor (.odt), Calc the spreadsheet (.ods), Impress the presentation program (.odp), Draw the vector drawing and diagram tool, which can also edit PDFs (.odg), and Base the database program with tables, queries, forms and reports (.odb). Writer can export directly to PDF.
The Writer window has a title bar (app icon, file name, minimise/maximise/close), a menu bar (File, Edit, View, Insert, Format, Styles, Table, Form, Tools, Window, Help), the standard toolbar (new, open, save, print, cut, copy, paste), the formatting toolbar (font, size, colour, bold, italic, underline), the Sidebar on the right (Properties, Page, Styles, Gallery, Navigator) and the status bar at the bottom.
Common operations in all three main apps use the File menu (New, Save, Open, Print) and the Edit menu (Cut Ctrl+X, Copy Ctrl+C, Paste Ctrl+V, Find & Replace). In Writer you format characters (font, size, bold, colour, superscript, subscript, strikethrough, shadow) and paragraphs (alignment, spacing, indents, bullets), insert tables, check spelling and use Mail Merge to make personalised letters from one main letter plus an address list.
Calc works with cells and formulas that start with =, such as =SUM(B2:D2) or =B2+C2, and built-in functions like COUNT, AVERAGE, MIN, MAX and MODE. AutoFill makes number, weekday and month series; Sort arranges records ascending or descending; Insert → Chart draws pie, bar, line or column charts; AutoFilter and Standard Filter show only the records that meet a condition.
Impress builds slides: add a new slide, set a background, add slide transitions (effects between whole slides) and custom animations (effects on objects on a slide), then press F5 to run the slide show. The practicals are a resume in Writer, a birthday invitation by mail merge, a mark list with chart in Calc and an 8-slide college presentation in Impress.
Get a ✓ Verified tutor for “Skill Set 1 – Daily Computing (Libre Office)” — live online or at home. We aim to suggest up to 3 tutors within 24 hours.
You invite 5 friends. Which parts of the letter are fixed and which are fields?
Answer: Fixed: 'You are invited to my birthday party on Sunday 14 December at 5 pm at our home...' and your signature. Fields: First Name, Last Name, Address (and perhaps City). With 5 records in the address list, mail merge produces 5 letters, each starting 'Dear [First Name]'.
Marks of 10 students are in rows 2–11: Maths B, Physics C, Chemistry D, Biology E (each out of 100). Write formulas for total, percentage, highest and lowest Maths marks, and rank.
Answer: F2: =SUM(B2:E2) G2: =F2/400*100 (or =F2/4) B12: =MAX(B2:B11) B13: =MIN(B2:B11) H2: =RANK(F2;$F$2:$F$11). Drag F2, G2 and H2 down to row 11 and B12, B13 across to E. Ranks 1, 2 and 3 are the toppers.
| Command / formula | What it does | Example |
|---|---|---|
| File → Save (Ctrl+S) | Saves the file in ODF format | marks.ods |
| Ctrl+X / Ctrl+C / Ctrl+V | Cut / copy / paste | Move a paragraph to page 2 |
| Edit → Find & Replace | Finds and replaces text | Replace 'Collage' with 'College' everywhere |
| Tools → Mail Merge Wizard | Makes personalised letters from a list | 5 birthday invitations |
| =SUM(B2:E2) | Adds a range | Total of four subjects |
| =AVERAGE(B2:B11) | Mean of a range | Class average in Maths |
| =MAX(B2:B11) / =MIN(B2:B11) | Highest / lowest value | Top and bottom Maths marks |
| =RANK(F2;$F$2:$F$11) | Position of a value in a list | 1 = topper |
| Insert → Chart | Draws a chart from selected data | Column chart of totals |
| F5 | Starts the slide show from slide 1 | Present your college slides |
Solve each one in your notebook first. Then open the solution and compare every step.
1. SOP 1: Create a resume in Writer — centred title in a suitable font and size; name, address, mobile number, date of birth, nationality, category, hobbies and a few extra points; a table for educational qualifications; a few lines about your aim at the end.
Answer: Sample: (1) Open Writer → type 'RESUME' → select it → Align Center, font Liberation Serif, size 20, Bold. (2) Type Name, Address, Mobile, Date of Birth, Nationality, Category, Hobbies, Languages known, Computer skills — make each heading Bold. (3) Table → Insert Table → 4 columns, 3 rows → headings Exam | Board | Year | Percentage → fill SSC and other rows. (4) Add a heading 'Career Aim' and two or three lines, e.g. 'To become a software engineer who builds apps for farmers.' (5) Tools → Spelling to correct mistakes. (6) File → Save As → resume.odt; File → Export as PDF for sharing.
2. SOP 2: Use mail merge to send a birthday party invitation to at least 5 friends.
Answer: Sample: (1) New Writer document → Tools → Mail Merge Wizard → Use the current document → Next → Letter → Next. (2) Select Different Address List → Create → Customize: delete fields you do not need (Company, etc.), keep First Name, Last Name, Address Line 1, City → OK. (3) Type friend 1, click New, type friend 2 … up to 5 → OK → save the list as friends.csv → Next → Next. (4) Choose a general salutation such as 'Dear …' → Next → Next → Finish. (5) Type the invitation: date, time, place, 'Please come!'. (6) Format → Page Style → Area → choose a colour, gradient or pattern; Insert → Image for a cake picture. (7) On the Mail Merge toolbar → Save Merged Documents → name it invitations → Save. Opening it shows 5 letters, one per friend.
3. SOP 3: Create a mark list in Calc with Name, Maths, Physics, Chemistry, Biology, Total, Percentage for at least 10 students; show highest and lowest marks under each subject; declare the first three rankers; make a chart.
Answer: Sample: Row 1 headings in A–G. Rows 2–11: names and marks. F2: =SUM(B2:E2); G2: =F2/4 (percentage, since 4 subjects × 100); copy down to row 11. A12 'Highest', B12: =MAX(B2:B11); A13 'Lowest', B13: =MIN(B2:B11); copy B12:B13 across to E. H1 'Rank', H2: =RANK(F2;$F$2:$F$11), copy down; ranks 1, 2, 3 are the toppers (or Data → Sort by Total descending and read the top three). Chart: select A1:A11 and F1:F11 (hold Ctrl) → Insert → Chart → Column → title 'Total marks', X axis 'Students', Y axis 'Marks' → Finish.
4. SOP 4: Create an informative presentation on your college with at least 8 slides, one slide with a chart, one with an image, and custom animation and a slide transition on every slide.
Answer: Sample plan: 1 Title (college name, logo), 2 History, 3 Courses offered, 4 Faculty and labs, 5 Results — Insert → Chart, column chart of pass % for last 3 years, 6 Campus photo — Insert → Image, 7 Sports and cultural activities, 8 Thank you / contact. For each slide: select a text box or picture → Sidebar → Animation → Add (e.g. Entrance: Fly In, direction From Left, duration 1 s). Slide → Slide Transition → choose e.g. Wipe for each slide (or Apply to All Slides). Set a background from Slide → Slide Properties. Save as college.odp and press F5 to run.
5. Give the LibreOffice application and file extension used for: (a) a project report, (b) a fees register with totals, (c) a flowchart, (d) a library database, (e) a seminar slide show.
Answer: (a) Writer — .odt; (b) Calc — .ods; (c) Draw — .odg; (d) Base — .odb; (e) Impress — .odp.
6. Distinguish between: (a) slide transition and custom animation; (b) Sort and Filter in Calc; (c) the standard toolbar and the formatting toolbar.
Answer: (a) A slide transition is the effect seen when the whole slide changes to the next (Slide → Slide Transition); a custom animation is an effect on one object on a slide, like a picture flying in (Sidebar → Animation). (b) Sort rearranges all records in ascending or descending order; Filter keeps the order but hides records that do not meet a condition. (c) The standard toolbar has icons for routine file and edit jobs — new, open, save, print, cut, copy, paste; the formatting toolbar has icons that change the look of selected text — font, size, bold, italic, colour, alignment.
Read the question, answer it in your head, then tap the card to check. 20 cards.
15 questions. Tap an option — you will see at once if it is right and why.
1. Which LibreOffice application is a spreadsheet?
Answer: B. Calc saves .ods files.
2. A file named report.odt was made in…
Answer: A. .odt = OpenDocument Text.
3. Which LibreOffice app can open and edit a PDF?
Answer: C. Writer can export PDFs; Draw can edit them.
4. The bar showing the file name at the top of the window is the…
Answer: C. It also has minimise and close buttons.
5. Which is NOT a default Sidebar deck?
Answer: D. Mail merge is a wizard in the Tools menu.
6. Ctrl+C is used to…
Answer: C. Ctrl+X cuts, Ctrl+V pastes.
7. Mail merge is useful for…
Answer: C. One letter per record.
8. Which menu has the Mail Merge Wizard?
Answer: C. Tools → Mail Merge Wizard.
9. A Calc formula must begin with…
Answer: D. e.g. =SUM(B2:B5).
10. B2:B11 in a formula is called a…
Answer: B. First cell : last cell.
11. Which function finds the lowest value?
Answer: B. MAX finds the highest.
12. Weekdays or month names can be filled quickly using…
Answer: D. Drag the fill handle.
13. Showing only students with more than 80% uses…
Answer: B. Standard Filter with condition > 80.
14. An effect applied to one picture on a slide is a…
Answer: A. Transitions affect whole slides.
15. Which key starts a slide show from the first slide?
Answer: C. Esc ends it.
Get a ✓ Verified tutor for “Skill Set 1 – Daily Computing (Libre Office)” — live online or at home. We aim to suggest up to 3 tutors within 24 hours.
Done with the notes? Revise Skill Set 1 – Daily Computing (Libre Office) the fun way: match key terms, beat the 60-second lightning round and spot true or false facts. Every game uses only this lesson, so each round is real exam revision.
⭐ 0 XP⏱ About 40 minutes (plus lab time)
Get a ✓ Verified tutor for “Skill Set 1 – Daily Computing (Libre Office)” — live online or at home. We aim to suggest up to 3 tutors within 24 hours.
Sign in free to see the answers to the textbook exercise of Skill Set 1 – Daily Computing (Libre Office).
Sign in to see solutionsStuck on a question? Type it, 🎤 speak it or 📷 snap a photo of it and get simple, step-by-step help with “Skill Set 1 Daily Computing (Libre Office)” — important questions, a quick quiz, revision notes — in English, मराठी or हिंदी.
Sign in with Google to ask the AI tutor. It's free — 20 questions a day, one TalentJR account.
Sign in to askPrefer a real teacher? TalentJR teachers take live online classes anywhere in India. Tell us what you need and our team will call you with timings and fees.