2024 SSLC IT Model Practical Examination PDF

2024 SSLC IT MODEL PRACTICAL EXAMINATION QUESTIONS WITH ANSWERS QGIS (Model) A resource map named LocalMap.qgs is given in the QGIS_Projects folder in Exam_documents in Home. Open this file in QGIS Desktop software and do the following activities. Open the Attribute table of the House layer in...

2024 SSLC IT MODEL PRACTICAL EXAMINATION QUESTIONS WITH ANSWERS QGIS (Model) A resource map named LocalMap.qgs is given in the QGIS_Projects folder in Exam_documents in Home. Open this file in QGIS Desktop software and do the following activities. Open the Attribute table of the House layer in the resource map and display the details of houses it contains. Take a screenshot and save it in Exam10 folder in Home with your RegisterNumber_Question Number as the filename. Hint:- Press the Print Screen key on the keyboard to take a screenshot. Then copy the Screenshot file from the Pictures folder and paste it into the Exam10 folder in Home. Rename the file as instructed. * Application – Education – QGIS Desktop – Ok * Project – Open – Home – Exam documents – Qgis project – LocalMap.qgs * Right click on the House layer –Open Attribute table –Place it nearest to the Map * Take Screenshot (PrtSc Key) - Home – Pictures – Right Click on screenshot– Copy – Home –Exam 10 – Right click Paste - Right on the Screenshot – Rename A resource map named LocalMap.qgs is given in the QGIS_Projects folder in Exam_documents in Home. Open this file in QGIS Desktop software and do the following activities. Create a layer named School. (Layer Type: Point, Attributes: Name, Code) Select this layer and mark a school on the map. (id 1, Name - GLPS, Code - 98765) Save the resource map using the option Project → Save As.. in the Exam10 folder in Home with your Register Number_ Question Number as the filename. * Application – Education – QGIS Desktop – Ok * Project – Open – Home – Exam documents – Qgis project – LocalMap.qgs * Layer – Create layer – New Shapefile Layer – Click on Point – Type the New Attribute name = Name and Type = Text Data – Click on Add to attributes * Type the New Attribute name = Code and Type = Whole number – Click on Add to attributes – Ok * Save as Layer – Type the file name = School * Click on Toggle editing tool – Clock on Add features – Click on Map- Type ID = 1, Name = GLPS , Code = 98765 * Project – Save as layer – Home – Exam 10 - Type the File name (Register Number_Question No) – Save A resource map named LocalMap.qgs is given in the QGIS_Projects folder in Exam_documents in Home. Open this file in QGIS Desktop software and do the following activities. Show the layer MainRoad in the resource map. Change the River colour to blue. Save the resource map as an image file in the Exam10 folder in Home with your Register Number_QuestionNumber as the filename. Hint:- To save as an image file, use the option Project - Save as Image from the menu bar in the QGIS software. * Application – Education – QGIS Desktop – Ok * Project – Open – Home – Exam documents – Qgis project – LocalMap.qgs * Click on Main Road layer for show the Main road layer * Double Click on River layer – Change the Colour (Blue) * Project – Save as image - Home – Exam 10 - Type the File name (Register Number_Question No) – Sav SUNCLOCK (Model) Open the SunClock software and do the following activities. Display the time zone map on the Sunclock software. Show the longitudinal line and the main latitudinal lines. Remove the separation of day and night completely. Take a screenshot of it and save it in the Exam10 folder in Home with your RegisterNumber_Question Number as the filename. (Press the Print Screen key on the keyboard to take a screenshot. Copy the screenshot file from the Pictures folder and paste it into the Exam10 folder in Home. Rename the file as instructed.) * Application – Education – Sunclock – Maximise the window – Click on Window and get a tool Bar * Click on “!” for Display the time line map * Click on “M” for display the longitude * Click on “T” for display the Latitude * Click on “N” for Removing the separation of day and night * Take Screenshot (PrtSc Key) - Home – Pictures – Right Click – Copy – Home – Exam 10 – Right click Paste - Right Click on the Screenshot – Rename Display the position of the sun and moon from any city in India on 21st December 2024 with the help of SunClock software. Take a screenshot and save it in the Exam10 folder in Home with your RegisterNumber_QuestionNumber as the filename. Hint: Display the time zone map on the Sunclock software and select any Indian city. Make suitable changes in the progress value and adjust the date. Show the sun and moon on the map. Display the main latitudinal lines. (Press the Print Screen key on the keyboard to take a screenshot. Copy the screenshot file from the Pictures folder and paste it into the Exam10 folder in Home. Rename the file as instructed.) * Application – Education – Sunclock – Maximise the window – Click on Window and get a tool Bar * Click on “!” for Display the time line map * Click on “U” for display the Cities – Click on an Indian City * Click on “T” for display the Latitude * Click on “Y” for display the Son and Moon * Click on “G” and progress value = 30 days - Click on “A” for forward - Click on “B” for backward for December * Click on “G” and progress value = a day - Click on “A” for forward - Click on “B” for backward for 21 * Take Screenshot (PrtSc Key) - Home – Pictures – Right Click – Copy – Home – Exam 10 – Right click Paste - Right Click on the Screenshot – Rename GROUP -II STYLES (Model) An article on schoolwiki is given in Exam_documents folder in Home with the file name Wiki.ott. Open this file in LibreOffice Writer and create a new heading style with name Schoolwiki for all subheadings with the following attributes. The new style Schoolwiki is to be created n the Heading 2 of the Heading section Font family : Ubuntu Style : Bold Font size : 110% Font color : Red Apply this new style for all subheadings. (All subheadings are green in colour.) Save this modified file in Exam10 folder in Home with your Register Number_QuestionNumber as its filename. * Home – Exam documents -Wiki.ott – Open Side bar setting ( Right side of the window)– Styles – Right Click on Heading 2 – New * Click on Organizer – Type the style name (Schoolwiki) * Click on Font - Font family = Ubuntu , Size = 110%, Style =Bold * Click on Font effect- Font colour = Red – Apply – Ok * Select All subheadings Using Control key - Click on the left side of Heading 2(►) - Double Click on New style (School wiki) * File – Save as - Home – Exam 10 - Type the File name (Register Number_Question No) – Save An article on Linux operating system is given in Exam_documents folder in Home with the file name Linux.ott. Open this file in LibreOffice Writer and create a new heading style Linux for all subheadings with the following attributes The new style Linux is to be created n the Heading 1 of the Heading section Font family : Ubuntu Style : Bold Font size : 120% Font color : Red Apply the new style for all subheadings. (Subheadings are blue in colour) Save the modified file in Exam10 folder in Home with Register Number_QuestionNumber as its filename. your * Home – Exam documents -Linux.ott – Open * Side bar setting ( Right side of the window) – Styles – Right Click on Heading 1 – New * Click on Organizer – Type the style name (Linux) * Click on Font - Font family = Ubuntu , Size = 120%, Style =Bold * Click on Font effect- Font colour = Red – Apply – Ok * Select All subheadings Using Control key - Click on the left side of Heading 1(►) - Double Click on New style (Linux) * File – Save as - Home – Exam 10 - Type the File name (Register Number_Question No) – Save An article on famous scientists is given in the file Scientist.ott in Exam_documents folder in Home. Two styles with names Scientist, Style_24 are included in file, where the Scientist is in the Heading 1 style section and the Style_24 is in the Default style section. Open this file in LibreOffice Writer and do the following activities. Apply the style Scientist to all subheadings (Subheadings are blue in colour), and the style Style_24 to all paragraphs. Save this modified file in Exam10 folder in Home with your Register Number_QuestionNumber as its filename. * Home – Exam documents -Scientist.ott – Open * Select the all Subheadings - Side bar setting ( Right side of the window) – Styles – Click on the icon of (►) heading 1 - Double click on Scientist * Select the all paragraphs – Styles – Double click on Style_24 * File – Save as - Home – Exam 10 - Type the File name (Register Number_Question No) – Save An article on Theyyam, a ritual art of Kerala, is given in Exam_documents folder in Home with the file name Theyyam.ott. Open this file in LibreOffice Writer and apply the style Heading 2 for all sub headings. (Sub headings are red in colour.) Then modify the style Heading 2 according to the given instructions. Font Family : Nimbus Sans L Font Size : 140% Font Color : Teal Underline : Single Save this modified file in Exam10 folder in Home with your Register Number_Question Number as its filename. * Home – Exam documents -Theyyam.ott – Open * Side bar setting ( Right side of the window) – Styles – Right Click on Heading 1 – Modify * Click on Font - Font family = Nimbus Sans L , Size = 140%, Style =Bold * Click on Font effect- Font colour = Teal, Underlining = Single – Apply – Ok * Select All subheadings Using Control key - Double Click on Heading 2 * File – Save as - Home – Exam 10 - Type the File name (Register Number_Question No) – Save INDEX AND TABLE (Model) An article on inert gases is given in the Exam_documents folder in Home with the file name Noble_gases.ott. Open this file in LibreOffice Writer and create a table of contents for the article using the Table of Contents and Index technique. Hints:- Apply the style Heading 1 for the main heading The noble gases. Apply the style Heading 2 for subheadings(Subheadings are red in colour). Include the table of contents in the first page itself. * Home – Exam documents -Open_source.ott – Open * Select the Main headings - Side bar setting ( Right side of the window) – Styles – Double Click on Heading 1 * Select all Subheadings - Side bar setting ( Right side of the window) – Styles – Double Click on Heading 2 * Click on the left side of first letter of the file – Insert – Page break – Click on new page – insert –Table of Content and index – Table of Content, index or bibliography - ok * File – Save as - Home – Exam 10 - Type the File name (Register Number_Question No) – Save An article on Wikipedia is given in the Exam_documents folder in Home with the file name Wikipedia.ott. Open this file in LibreOffice Writer and create a table of contents for the article using the Table of Contents and Index technique. Hints:- Apply the style Heading 1 for the main heading Wikipedia Apply the style Heading 2 for subheadings.(Subheadings are red in colour) Create the Table of Contents on the first page of the article. Save the modified article in Exam10 folder in Home with Register Number_QuestionNumber as the filename. your * Home – Exam documents -Wikipedia.ott – Open * Select the Main headings - Side bar setting ( Right side of the window) – Styles – Double Click on Heading 1 * Select all Subheadings - Side bar setting ( Right side of the window) – Styles – Double Click on Heading 2 * Click on the left side of first letter of the file – Insert – Page break – Click on new page – insert –Table of Content and index – Table of Content, index or bibliography - ok * File – Save as - Home – Exam 10 - Type the File name (Register Number_Question No) – Save An article about Indian mathematicians are given in the Exam_documents folder in Home with the file name Mathematicians.ott. Create a table of contents for the article using the Table of Contents and Index technique in LibreOffice Writer. Create the Table of Contents on the first page of the article. Hints:- Give style Heading 1 for subheadings. (Subheadings are red in colour) Save the modified article in Exam10 folder in Home giving your Register Number_QuestionNumber as the filename. * Home – Exam documents -Mathematicians.ott – Open * Select all Subheadings - Side bar setting ( Right side of the window) – Styles – Double Click on Heading 1 * Click on the left side of first letter of the file – Insert – Page break – Click on new page – insert –Table of Content and index – Table of Content, index or bibliography - ok * File – Save as - Home – Exam 10 - Type the File name (Register Number_Question No) – Save MAIL MERGE (Model) Prepare an invitation letter to invite parents for the an awareness program conducted at the school using the mail merge technique in LibreOffice Writer. The details of the parents are given in Exam_documents folder in Home with the file name Guardian.ods and the sample invitation Letter with the file name Awareness.ott in the same folder. Save the invitation letters as a single file in Exam10 folder in Home giving your Register Number_QuestionNumber as the filename. * Home - Exam documents -Awareness.ott - Open * Insert - Field - More field - Data base -Mail Merge * Browse - Home - Exam documents - Guardian.ods -Open * Click on left side Triangle of Guardian - Click on left side ide Triangle of Sheet 1 - * Drag the Name, House Name, Pin code – Close malasse * File - Print - Yes - File - Ok - Click on Home - - Exam 10 - Type the File name (Register Number_Question No) - Save - Close the Window - Don't Save * Home - Exam 10 - Open the newly saved file Prepare an invitation letter to invite parents for a cyber security awareness class organized by the school's Little Kites Club using mail merge technique in LibreOffice Writer. The details of the parents are given in the Exam_documents folder in Home with the file name Parents_Details.ods and the sample invitation letter in the same folder with the file name Notice.ott. Save the invitation letters as a single file in Exam10 folder in Home with your Register Number_QuestionNumber as its filename. * Home - Exam documents - Notice.ott - Open * Insert - Field - More field - Data base -Mail Merge * Browse - Home - Exam documents - Parents_Details.ods -Open * Click on left side Triangle of Parents_Details - Click on left side Triangle of Sheet 1 * Drag the Name, Name of Parent, Student Name, Address, Pin - Close * File - Print - Yes - File - OK - Click on Home - Exam 10 - Type the File name (Register Number_Question No) - Save - Close the Window - Don't Save * Home - Exam 10 - Open the newly saved file Prepare ID cards for the students of School Little Kites using mail merge technique in LibreOffice Writer. The details of club members are given in the Exam_documents folder in Home with the file name Card.ods and the sample ID Card with the file name LK_card.ott in the same folder. Save the ID Cards as a single file in Exam10 folder in Home with your Register Number_QuestionNumber as its filename. Prepare an invitation letter to invite parents for a cyber security awareness class organized by the school's Little Kites Club using mail merge technique in LibreOffice Writer. The details of the parents are given in the Exam_documents folder in Home with the file name Parents_Details.ods and the sample invitation letter in the same folder with the file name Notice.ott. Save the invitation letters as a single file in Exam10 folder in Home with your RegisterNumber_QuestionNumber as its filename. * Home - Exam documents - LK_card.ott - Open * Insert - Field - More field - Data base -Mail Merge * Browse - Home - Exam documents - Card.ods -Open * Click on left side Triangle of Card - Click on left side Triangle of Sheet 1 * Drag the Name, Admission No, Class & Div, LK Batch - Close * File - Print - Yes File OK - Click on Home - Exam 10 - Type the File name (Register Number_Question No) - Save - Close the Window - Don't Save * Home Exam 10 - Open the newly saved file Prepare identity cards for students who are participating in the state school Youth festival using mail merge technique in LibreOffice Writer. The details of the students are given in Exam_documents folder in Home with the file name Participants.ods and the sample ID Card in the same folder with the file name ID_Card.ott. Save the ID Cards as a single file in Exam10 folder in Home giving your RegisterNumber_QuestionNumber as the filename. * Home – Exam documents - ID_Card.ott – Open * Insert – Field – More field – Data base -Mail Merge * Browse – Home – Exam documents -.Participants.ods –Open * Click on left side Triangle of Participants - Click on left side Triangle of Sheet 1 * Drag the Name of participant, Name of Competing Item, Admission No, Standard , Name of School – Close * File – Print – Yes – File – OK - Click on Home – Exam 10 - Type the File name (Register Number_Question No) – Save – Close the Window – Don’t Save * Home - Exam 10 - Open the newly saved file DATA BASE (Model) The details of various players are given in Exam_documents folder in Home with the file name Sports.odb. Prepare a query using the Queries technique in the LibreOffice Base to get only the names of players and the number of wickets taken by them (Total Wickets) who come under BOWLER category, from the Cricketmen table. Hints:- To prepare the query use the Use Wizard to Create Query technique in Queries. Fields to include: Player_Name, Total_Wickets in the query, Player_Category. Search Condition: Player_Category is equal to BOWLER Save this modified file (File Save As..) in Exam10 folder in Home with your Register Number_Question Number as its filename. * Home – Exam documents -Sports.odb – Open Queries – Use wizard to create Query * Available fields (Player_Name , Total_Wickets , Player_Category) transferred to Fields in the Query – Next – Next – Select the field = Player_Category is equal to BOWLER – Finish – Close the Query * File – Save as - Home – Exam 10 - Type the File name (Register Number_Question No) – Save The details of various athletes are given in the file Sports.odb in Exam documents folder in Home. Create a query using the Queries function in the LibreOffice Base to get the names of players who have scored more than 100 goals and the number of goals scored from the Footballers table. Hints:- Use the Use Wizard to Create Query method in Queries to prepare the query. Fields to include: Player_Name, No_of_Goals. Search Condition: No_of_Goals is equal or greater than 100. Save the modified file (File Save As) in Exam10 folder in Home with your Register Number_QuestionNumber as its filename. * Home – Exam documents -Sports.odb – Open * Queries – Use wizard to create Query * Available fields (Player_Name, No_of_Goals) transferred to Fields in the Query – Next – Next – Select the field = No_of_Goals is equal or greater than 100 - Finish – Close the Query * File – Save as - Home – Exam 10 - Type the File name (Register Number_Question No) – Save The details of various players are given in the Exam_documents folder of Home with the file name Sports.odb. Prepare a report as per the instructions given below using Reports tool in the LibreOffice base. Use Query_ MidFielders given in the database file to generate the report. (Select Query_MidFielders from "Tables or queries" in Field selection in Report Wizard). Fields to include in the report: Player_Name, No_of_Matches and No_of_Goals. Save the report (File → Save As) in Exam10 folder in Home with your Register Number_QuestionNumber as its filename. * Home – Exam documents -Sports.odb – Open * Reports – Use wizard to create Report – Tables or Queries change to Query_MidFielders * Available fields (Player_Name ,No_of_Matches, No_of_Goals) transferred to Fields in the Report - Finish * File – Save as - Home – Exam 10 - Type the File name (Register Number_Question No) – Save The details of various players are given in Exam_documents folder of Home with the file name Sports.odb. Prepare a report as per the instructions given below using Reports tool in the LibreOffice Base. Use the query Query _ Topscorers provided in the database file to generate the report. (Select Query_Topscorers from "Tables or queries" from Field selection in Report Wizard) Fields to include in the report: Player_Name, Player_Category and Total_Runs. Save this file (File Save As..) in Exam10 folder in Home with your RegisterNumber_QuestionNumber as its filename. * Home – Exam documents -Sports.odb – Open * Reports – Use wizard to create Report – Tables or Queries change to Query_TopScorers * Available fields (Player_Name ,Player_Category, Total Runs) transferred to Fields in the Report - Finish * File – Save as - Home – Exam 10 - Type the File name (Register Number_Question No) – Sav The details of various athletes are given in the file Sports.odb in Exam_documents folder in Home. Prepare a report using the instructions given below using Reports tool in the LibreOffice Base. Hints:- Use the query Query_Karnataka given in the database file to generate the report. (Select Query_Karnataka from Tables or queries in Field selection in Report Wizard) Fields to include in the report: Player_Category, Total_Runs, Total_Wickets. Save the report (File Save As) in Exam10 folder in Home with your Register Number_Question Number as the filename. * Home – Exam documents -Sports.odb – Open * Reports – Use wizard to create Report – Tables or Queries change to Query_Karnataka * Available fields (Player_Category ,Total_Runs, Total_Wickets) transferred to Fields in the Report - Finish * File – Save as - Home – Exam 10 - Type the File name (Register Number_Question No) – Save