In this section I covered all the important question from Nsqf Class 10th: Part B: Vocational Skill Important Questions answers for students reference.
Click Here to Download Notes in Punjabi Language
Unit 1: Digital Documentation (Advanced)
Q1. What are Styles ? What are the advantages of using styles?
Ans. A style is a set of formats that you can apply to selected pages, text, frames, and other elements in your document to quickly change their appearance.
Advantages of using styles are :
1. Styles help us to apply consistent formatting to the documents.
2. Using styles we can easily change the existing format. 3. Styles makes major formatting changes simple.
Q2. Give any four styles supported by OpenOffice.org
Ans. Four Styles supported by OpenOffice.org are.
1. Page styles include margins, headers and footers, borders and backgrounds.
2. Paragraph styles control all aspects of a paragraph’s appearance, such as text alignment, tab stops, line spacing, and borders.
3. Character styles affect selected text within a paragraph, such as the font and size of text, or bold and italic formats.
4. Numbering styles apply similar alignment, numbering or bullet.
Q3. How can we create our own styles?
Ans. We can create new styles by following two ways :
1. Creating new styles from selection.
2. Dragging And Dropping To Create A Style.
Q4. Explain any four Graphic filters.
Ans. Four graphic filters are :
1.Invert : Inverts the color values of a color image or the brightness values of a grayscale image.
2.Smooth : Softens the contrast of an image.
3.Sharpen : Increases the contrast of an image.
4.Posterize : Makes a picture appear like a painting.
Q5. Explain Image Cropping.
Ans. When you are interested in a section of the image for the purpose of your document, you may wish to crop (cut off) parts of it. Right click on image and select Picture from the pop-up menu. In the Picture dialog box, select the Crop page and select the part from left, right, top and bottom which you want to remove.
Q6. List any three methods of inserting images in a text document.
Ans. Three methods of inserting images in a text document are :
a. Drag and Drop
b. Inserting An Image From The Clipboard
c. Inserting An Image Using A Scanner
Q7. What do you understand by the terms:
a. Text Wrapping
b. Anchoring
https://saddapunjab.info/vocational-skill-part-b-for-10th-class-mcqs/
Text wrapping-refers to the relation of graphics to the surrounding text, which may wrap around the graphic on one or both sides, be overprinted behind or in front of the graphic.
Anchoring-It refers to the reference point for the graphics. This point could be the page, or frame where the object is. An image always has an anchor point.
Q8. What are templates? What are the advantages of using templates?
Ans. A template is a model that you use to create other documents. For example, you can create a template for business reports that has your company’s logo on the first page. When you create a new documents from this template will all have your company’s logo on the first page.
One of the major advantages of using templates is the ease of updating styles in more than one document. Another advantage is that it also saves your time.
Q9. What is the difference between styles and templates?
Ans. A template is a model that you use to create other documents.
1.A style is a set of formats that you can apply to selected pages, text, frames, and other elements in your document to quickly change their appearance.
2.Styles help to keep formatting consistent in the entire document.
3.Templates help to keep formatting consistent across multiple documents.
Q10. Explain Mail Merge.
Ans. A mail merge is a way to take a letter you’ve written and send it to a whole bunch of people, personalizing it with information about them so they might think that you typed that letter personally for them. In short, it’s a way to be personal, yet efficient.
Q11. What are advantages of Mail Merge?
Ans. Advantages of mail merge are :
1. It saves our time and efforts.
2. It helps to create multiple personalized letters in a very less time. 3. It also help to keep the formatting consistent in all the letters.
Unit 2: Electronic Spreadsheet (Advanced)
Q1. How can we rename a worksheet?
Ans. There are three ways you can rename a worksheet
a. Double-click on one of the existing worksheet names.
b. Right-click on an existing worksheet name, then choose Rename from the resulting Context menu.
c. Select the worksheet you want to rename (click on the worksheet tab) and then select the Sheet option from the Format menu. This displays a submenu from which you should select the Rename option.
Q2. What are the two ways of referencing cells in other worksheets?
Ans. Two ways to reference cells in other sheets:
1) By entering the formula directly using the keyboard
2) By using the mouse.
Q3. Differentiate between Relative and absolute hyperlinks.
Ans. Hyperlinks can be used in Calc to jump to a different location from within a spreadsheet. An absolute link will stop working only if the target is moved. A relative link will stop working only if the start and target locations change relative to each other.
For instance, if you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new location, a relative hyperlink will not break.
Q4. What is the purpose of adding comments?
Ans. Comments are mostly used in shared Calc sheet which is used to explain the changes made in the sheet to the author of the sheet.
Q5. How can we add comments to the changes made?
Ans. Comments can be added as follows:
1. Make the change to the spreadsheet.
2. Select the cell with the change.
3. Choose Edit > Changes > Comments. The automatically-added comment provided by Calc appears in the title bar of this dialog and cannot be edited.
4. Type your own comment and click OK.
After you have added a comment to a changed cell, you can see it by hovering the mouse pointer over the cell.
Q6. What are Macros?
Ans. A macro is a saved sequence of commands or keystrokes that are stored for later use. Macros are especially useful to repeat a task the same way over and over again.
Q7. How can we record a Macro?
Ans. Steps to record macro are as follows
a. Use Tools > Macros > Record Macro to start the macro recorder. The Record Macro dialog is displayed with a stop recording button.
b. Perform the actions you want to be recorded in the document.
c. Click Stop Recording.
d. The Macro dialog appears, in which you can save and run the macro.
Q8. Define consolidating data. Write steps to consolidate data in an electronic spreadsheet.
Ans. Data Consolidation allows you to gather together your data from separate worksheets into a master worksheet. In other words, the Data Consolidation function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily.
It is available under Data menu->Consolidate option
Unit 3: Database Management System
Fill in the Blanks
1. A database is an organized collection of data.
2. A DBMS is a software package that can be used for creating and managing databases.
3. A RDBMS is a database management system that is based on the relational model.
4. Three popular DBMS software are Microsoft Access, Open Office Base & MySQL.
5. A Primary Key is a unique value that identifies a row in a table.
6. Composite Key is a combination of one or more columns.
7. A table is a set of data elements that is organized using a model of vertical columns and horizontal rows.
8. A column is a set of data values of a particular type, one for each row of the table.
9. A row represents a single, data item in a table.
10. Datatypes are used to identify which type of data we are going to store in the database.
11. Create table DDL command is used to create a table.
12. Common DDL statements are create, alter and drop.
13. The types of languages used for creating and manipulating the data in the Database are DDL & DML.
14. A DDL is a standard for commands that define the different structures in a database.
15. A DML is a language that enables users to access and manipulate data in a database.
16. A Select is a part of DML involving information retrieval only.
17. A popular data manipulation language is SQL.
18. Tables are the basic building blocks of a database.
19. There are three types of Relationships in a table.
20. A form helps the user to systematically store information in the database.
Question and Answer
Q1. In how many ways tables can be created in Base? Ans. Tables can be created in two ways.
1. In Design view
2. Using Wizard
Q2. List datatypes available in Numeric Datatype?
Ans. The different types of numeric data types are:
1.Boolean Tinyint Smallint Integer Bigint
2.Numeric Decimal Real
3.Float
4.Double
Q3. List datatypes available in Alphanumeric Data Type?
Ans. The different types of Alphanumeric Data Type are:
1.Longvarchar
2.Char
3.Varchar
4.Varchar_Ignore Case
Q4. Define the structure of a table.
Ans. A table is a set of data elements (values) that is organized in vertical columns and horizontal rows. A table has a defined number of columns, but can have any number of rows.
Q5. Differentiate between Tuples and Attributes of a table
Ans. A row also called a Record or Tuple represents a single, data item in a table. Whereas A column is a set of data values of a particular simple type, one for each row of the table.
Q6. Name different Binary data types.
Ans. The different Binary data types are:
1.Longvarbinary
2.Binary
3.Varbinary
Q7. How many types of relationships can be created in Base? Explain each of them.
Ans. There are three types of relationship in OpenOffice Base.
1.ONE to ONE : In this relationship, both the tables must have primary key columns. Example: In the given tables EMP and DEPT, EMP_ID in EMP table and DEPT_ID in DEPT table are the primary keys.
2.ONE to MANY : In this relationship, one of the table must have primary key column. It signifies that one column of primary key table is associated with all the columns of associated table.
3.MANY to MANY : In this relationship, no table has the primary key column. It signifies that all the columns of primary key table are associated with all the columns of associated table.
Q8. What do you mean by Sorting? In how many ways it can be done?
Ans. Sorting means arranging elements in particular sequence. It can be done in two ways.
1. Increasing order
2. Decreasing Order
Unit 4: Maintain Health, Safety and Secure Working Environment
Q1. What do you mean by Hazard?
Ans. A hazard is anything that is the source of any potential harm, damage or any kind of potential loss of health or life.
Q2. Name four types of Hazards.
Ans. The different types of hazards are:
● Physical
● Chemical
● Biological
● Mechanical
Q3. Give a checklist for workstations to minimize the hazards.
Ans. The workstation should:
1. Provide sufficient space for the user to alter position comfortably
2. Provide adequate lighting
3. Have windows fitted with adjustable coverings to alter the sunlight level
4. Be spacious enough when a workstation is shared by more than one person
Q4. Give a checklist for display screen to minimize the health hazards.
Ans. The display screen should:
1. Display well-defined characters of adequate size and spacing
2. Have a stable image
3 Have easily adjustable brightness and contrast
4. Tilt and swivel easily to suit the user
5. Be free from glare and reflections
Q5. What do you mean by Evacuation?
Ans. Evacuation is the process of emptying a place in case of an emergency, disaster.
Q6. What do you mean by Buddy System?
Ans. A ‘buddy system’ for individuals with special needs or disabilities must be designated. This system ensures that differently-abled are assisted and guided out of the premises or the impacted area properly. If you are a buddy to someone, ensure that your buddy is safe at the assembly point with you.
Q7. What do you mean by Healthy Living?
Ans. A healthy living has a lasting impact on an individual which ultimately yields a healthy environment at home as well as at work place. A happy and healthy worker will always perform best to his ability.
Protect Health and Safety at Work Class 10 IT 402
Q8. List any six points of healthy life style.
Ans. A healthy lifestyle includes :
1. Healthy eating habits
2. Physical activities
3. Stress management
4. Healthy mind
5. Sound sleep
6. Goal setting
Q9. Write one advantage of healthy life style.
Ans. Advantage of healthy life style is :
1. A healthy lifestyle helps to keep and improve people’s health and well being.
Q10. Give a checklist for keyboard to minimize the health hazards.
Ans. The keyboard should:
1. be able to tilt easily and should be able to separate from the screen to allow the user to adopt a comfortable working position
2. have space in front to provide support for the hands or arms of the user.
3. have a matt surface.
4. have clearly legible symbols on the keys.