* Class - 10th A Roll no. - 321. Practical Question 1 Create a nev database in LibreOffice Base named School DB... 2. Practical Question 2 ~ Create a table named Student with fields: RellNo, Name, Class, Marks. 43, Practical Question 3 ~Enter at least 5 records in the Student table, 4 Practical Question 4 ~ Sort the Student table (a) ascending by RolINo &(b) descending by Marks. 5. Practical Question 5 ~ Create a form for entering data into the Student table using Form Wizard. 6. Practical Question 6 ~ Greate queries: (a) students with marks 275 & (b) RoNo, Name, Marks sorted by Marks (descending). 7. Practical Question 7 ~ Use Data Consolidation to merge two sheets of monthly sales into one summary sheet. 8, Practical Question 8 ~ Apply Subtotals toa table with item, Category, Price based on Category. 9, Practical Question 9- Use Goal Seek to find marks needed ina inal exam to achieve a total of 80. 10, Practical Question 10~ Create two scenarios with Scenario Manager Beat Case (high mark) & Worst Case (low marks). © scanned with OKEN ScannerACKNOWLEDGEMENT Respected Ms. Yamini Mam, ‘am Sakshi Daber, pleased to submit my IT practical file, which contains all the practical exercises and projects completed as per the course requirements. | would like to express my sincere gratitude forthe guidance, support, and encouragement provided by the you throughout the T course. Your valuable feedback and suggestions have helped me to improve my skills and understanding of the subject. appreciate the effort you put in te make the practical sessions engaging and informative. Your expertise and! teaching style have made a significant impact on my learning experience, ‘Thank you once again for your unwavering support and guidance, 4 uJ Sincerely, 4 1 ‘Sakshi Daber © scanned with OKEN Scanner\ + “This is to certify that Sakshi Daber, a student of Class 10th, : has successfully completed the practical project for the Academic Session 2025-26. This project was completed under the guidance and supervision of Ms. Yamini Mam.” Student's sign Teacher's sign *:\' > © scanned with OKEN ScannerPractical Question 1 Create a new database in LibreOffice Base named School DB. Steps: 1. Click on the Start Menu of the computer. Select LibreOffice from the list of applications. The LibreOffice Welcome window appears on the screen. Click on Base to open LibreOffice Base. The Database Wizard dialog box opens automatically. Select the option Create a new database. Click on the Next button at the bottom. Choose Yes, register the database for me so that the database is available to other LibreOffice components. 9. Select Open the database for editing. [Link] on Finish. ‘[Link] Save As dialog box appears. [Link] the database name as School DB. 13 Select the desired location to save the file. [Link] on the Save button. [Link] database file School [Link] is created successfully. SPN aM awy 3[Page © scanned with OKEN Scanner— Puomssed yum anes (-) séumas som up3 ne _(990%) (sea s24H0914F) #a0] adh se anes ps] sweu apy it 80 ows f seeqeep ain uodo 104 9p RIO) wm ifn swuaun2ea (2) | sapjoj uy anes | Sunjpa 40) aseqeinp aya uado ©) 32 404 aseqerep ay) Lado Oo: | ape ; sf T aseqeiep aun Jo1si601 104 op ‘on C) | | ‘oyO91qYT Ut pasarsiBar aq yw aseqerep au, “AunyssaDans paieas> uaaq sey aseqerep ays, posroid pue anes i¢ Jo ¢ dais - prezim aseqeieg (] ssid >1e> Jam il wy © scanned with OKEN ScannerPractical Question 2 Create a table named Student using Design View with the given fields. 1. Open School DB by double-clicking on it. 2. The LibreOffice Base window opens. 3. Inthe left-side Database pane, click on Tables. 4. Click on Create Table in Design View. 5. The Table Design View window appears. 6. In the first row under Field Name, type RolINo. 7. From the Data Type dropdown, select Integer. 8. Inthe Description box, type: Student Roll Number. 9. Inthe second row, type Name. [Link] Text (VARCHAR) as the Data Type. [Link] the Description box, type: Student Name. [Link] the third row, type Class. [Link] Text (VARCHAR) as the Data Type. [Link] the Description box, type: Student Class. [Link] the fourth row, type Marks. [Link] Integer as the Data Type. [Link] the Description box, type: Marks Obtained. [Link]-click on the RollNo field. [Link] Primary Key from the context menu. 20.A key symbol appears next to RollNo. [Link] on the Save icon. [Link] the table name as Student. [Link] OK to save the table. 4|Page © scanned with OKEN Scanner9 sé) a-OL umosg plAaeg S 88 Dol, sineg Ama BL V-OL, uosuYof jseyr1W| € 26 a-0L, yys auel Zz 80g WYof L - awen ONION % quapms PY suodsy JP suuos so1and By mala area “alge areas 01 piezim asm, ES] uBiseq waiqeL area: [3] quapms EB saiger EY © scanned with OKEN ScannerPractical Question 3 Enter at least five records in the Student table. Steps: In the Database pane, click on Tables. Double-click on the Student table. The table opens in Datasheet View. Click in the first cell under RolINo. Enter RollNo, Name, Class, and Marks for the first student. Press the Enter key to move to the next record. Continue entering data for at least five students. Ensure that RollNo values are unique. .. After entering data, click on the Close (X) button. [Link] is saved automatically in LibreOffice Base. PONAMVEeNE S[Page © scanned with OKEN Scanner= anjenineyaq, Es ee ot) adi, pioia Soa SaA y bas Au a snerceen ct >| ee — aradoid pjaid | | (re) cates E — sanreauneyea || yy8ua1 waoiny || i sy ones & | (aweN Pia alae gS « suodey suuos souiond By main ayeas> (E] “ajqe. a¥e219 03 puezim as. GE] ‘ayy ub}saq Ul aiqeL aye) © scanned with OKEN ScannerPractical Question 4 Sort the Student table (a) Ascending order of RollNo (b) Descending order of Marks Steps: 1 NOUAwWN Open the Student table in Datasheet View. . Click once on any value in the RollNo column. . From the toolbar, click on the Sort Ascending (A-Z) button. . The records are rearranged in ascending order of RollNo. .. Now click on any value in the Marks column. Click on the Sort Descending (Z->A) button from the toolbar. . The records are sorted in descending order of Marks. 6|Page © scanned with OKEN Scannerpads eed (sseutp) $0 5 pioren | | : i g $8 7 se 90g uyof| 7 v : f 88 >01 sineg Aya |e E ig =f eae IHORqN - gq 1OOUDS EY S 2 ONJ10y JO 4apso s 6ulpussse ul re] swopms pavos (e) | aopms <3 sulioy 6 |awVU-8-AA aya eipy -aseq aayyoaian - aq 1ooy>s =I | © scanned with OKEN ScannerCreate a Form for the Student table using Form Wizard. Steps: 1. Open School DB. Click on Forms from the Database pane. Click on Use Wizard to Create Form. The Form Wizard dialog box appears. Under Tables or Queries, select Student. Select each field and click on >> to move all fields to Selected Fields. Click Next. Choose Arrange controls in columns. . Click Next. [Link] the default form style. [Link] Next. [Link] the form name as Student Form. [Link] Work with the form. [Link] Finish. [Link] form opens and is ready to enter records. PEN anEwn 7[Page © scanned with OKEN Scannersuen, ewen ONION suo} By UI SPIALS {UOJ INOK UI asn 0} UM NO Op splay Y>IYM —__WUOJaNs e dh yas d > :Kiand / a1d2L splay wojans ppv t, seuend EE] aa uuog yeo1y | uHOd aVeID Z sown gy | (EE ‘aseg 824j02NGN1 - ]OOUDS | OMEdey | 1 WHOS ‘9 Aland ‘L alge, samedoug EE] vedo [) suonay EF] saris Addy b Aaa evep 195 b een Sue sjonuo> abueny | b | or prezimasn 23) owen | ONION | splay pauiof yo (+) quapms | 914eL, uonsaI@5 pia! suuos (i) E oy area Joys, “Sire | U' (G6 djaf] mopulfK sjool yeuuoy vasul ma pF aiid ‘aseg 221)j021q17 - 100N>S © scanned with OKEN ScannerPractical Question 6 Create Queries {a) Display students who scored more than 75 marks (b) Display RolINo, Name, Marks sorted by Marks (Descending) Steps: 1. Click on Queries in the Database pane. Click on Create Query in Design View. . The Add Tables dialog box appears. Select the Student table. . Click Add and then Close. wen Query (a): Marks more than 75 6. Double-click RolINo, Name, and Marks to add them to the grid. 7. In the Criteria row under Marks, type >75. 8, Click on Run Query (green tick icon). 9. The result shows students scoring more than 75 marks. 10. Save the query as Students Above 75. Query (b): Marks Descending 11. Create a new query in Design View. 12. Add RollNo, Name, and Marks fields. 13. In the Sort row under Marks, select Descending. 14. Click Run Query. 15, Save the query as Marks Descending. B|Page © scanned with OKEN ScannerKoo ee ) [ Apeey 280g a2yjoaiqn - o0ups - Aen suey WOH | 0 Ai0dey “| uH04 ian + aigeL sowadoid EE) “main $e 81289 EE] synsas aun 29s 01 Avan ayy uny vedo (= suopoy suew) awe qwapmis) oNtiod| Auand yea! Ss We Saas IN 85 sey aigel pr ov piezim asm 23) = <= | ~-maiy uB50q ur fuand ayeaiy G] oven oven i awen ONION quapms EE] Aron Gupuaasea sew [EE] Aran sew ub EE] | «Blam als djaF MOpUIA sjoOL esul Mam ypF oy x) x - ‘Aran SHEN UBIH “GiGi Ohi * |S a x dia mopuyR sjool yewos yasut maim aseg aa4joaiqny - joou>: xo = 4 B2OBAN - oouDs © scanned with OKEN ScannerPractical Question 7 Given data in two different sheets showing monthly sales, consolidate them into. single summary sheet. Write the steps for Data > Consolidate. Steps: Open LibreOffice Cale. Enter monthly sales data in Sheet1 and Sheet2. Click on the cell where consolidated result is required. . Go to Data -> Consolidate. . The Consolidate dialog box opens. . Select Sum from the Function list. Select the data range in Sheet! and click Add. Select the data range in Sheet? and click Add. Choose the destination cell [Link] OK to consolidate data. PON anewn 9] Page © scanned with OKEN Scanner3———— a= + = Gi S-E | ozs’ ans | OZS'L swing Keununs saes Ayiuon e12045 ava TE Runwon fiunon [eras] ames [190s | — = 3 | uwinjos ye] >] uuinjoo yay | | = moidol — :sfeqel as | Be i -ssuondg! | Z a Tyo _ =a S$2$:1$a$".z188Us, l | seueueg “ppv sebueig. ‘abues eyep a2in0s i sajddy a J TL uns | suonsun4 7 | qunowy) | wey Aveuiuuns sajes Ajyyuoyy eater 5u09 tr} es pra = % : we ap 8 er8ys a ales O-G ‘Fieea diel mopun uuoz yays ere sjool reUuoy yasuT mam apy a esa. — 2929 a2yjOONq- BIBOUS shee s9peS - AveUHUUNS SaIeS ANNUOW = 3405 © scanned with OKEN ScannerPractical Question 9 Use Goal Seek to find what marks are needed in the final exam to ac! total of 80. Write the steps. thieve a Steps: 41. Enter marks of all exams in separate cells. 2. Use a formula to calculate total marks. 3. Select the total marks cell. 4. Go to Tools -> Goal Seek 5. In Formula Cell, select the total cell. 6. Enter 80 in Target Value. 7. Select the final exam marks cell as Variable Cell. 8. Click OK. 9. LibreOffice calculates the required marks. 11| Page © scanned with OKEN Scanner%OOL ——————— 1 = = = EF) +6) fal. | ozs’ suns AGvad —Aavae eat eayus | zeus [seus | a tL | oL (ia : punoy uonnyos ssmeys | |O0°OES a 7 —— —— : 00'sS$ 12301 | - apoameuen | loose fuoyea| jeoury ts | Ce +e ronjeayabier | |o0'sz$ synd seueueg| p \ ~ s}99 ejnuog | [C0°O7S sun 7end] €_ | 1 7 00'0L$ synig) IOMAWIOH Z a Peg 99g 1209 [I] quauodwio3 wex3) tc — ; co Ss Ee v | zs02 |= L322us 7 =| Be ue She sane "*- Aaa dja moX afew wuoJ ways ee SJ] rewWHOF wasuy maIA pz | sye> aoynon - sieeys «a1 ees - AlewUNS sajes AUNUOW - 3129 2240207 GI © scanned with OKEN ScannerPractical Question 10 Create two scenarios: a) Best Case (high marks) b) Wor Write Steps: - en auawn 10. rst Case (low marks) the steps to create and view scenarios. Open LibreOffice Cale and enter base marks. . Select all changing cells. Go to Tools -> Scenarios. . Click Add. . Enter scenario name Best Case. . Enter high values for marks and click OK. . Again go to Tools -> Scenarios > Add. . Enter scenario name Worst Case, . Enter low values for marks and click OK. Use Tools -> Scenarios to switch between scenarios. [Page © scanned with OKEN ScannerO4s'L suns sas‘pas‘esas SaS‘pas'esas 359g | :soUeUEDS SED 3SIOM | soureuans | |- \[-Pew } AQVRE | Agvay aieeys | 19904s = “eased” aa cel z | tt | OL 6 008$ a) og | 1EIOL) Ss 00'0E$ suni4 wexg jeuly| > 00's L$ sung) znd € } oo'oz$ SUMIy, jomaWoH) Z | 2109S quauodwo > wexg L ae [ass ee ez 2a aga Lieays, Ba aee 7 =] A-Sigqg dja mopum wos 2129 aaysoa: weys eled Soo] yeuuos yasut maq ypz apd S1@AUS + LIN eves - ArewuUNs sales AUOW - 2129 aa2yoaqn FC] © scanned with OKEN Scanner