Ncert Q&a
Ncert Q&a
SHORT ANSWER:
1. Write advantages of using Style over manual formatting, for designing a document
ANS: Custom Styles means user defined styles. When existing styles specified by Writer do not
match our requirement, then user can create Custom Style. There are two ways to create custom
styles. They are
a) From Selection b) Drag & Drop
3. Give two examples, where instead of Style, using manual formatting will be beneficial
4. Give one situation in which you will prefer to use Fill Format for styling your document
ANS: a) Fill Format is useful when a same style is to be applied at many places scattered in the
document.
a) Fill Format can be used to style scattered –pages, frames, tables, list etc.
b) It is used to apply a style to many areas quickly without having to go back to the Styles
deck and double-click each time.
ANS: A picture is a digital image, which is representation of image infinite set of digital values 0
or 1.These are stored in various types of graphics files with the file extension, such as GIF JPG,
JPEG, PNG, BMP etc. Digital images can be created using a digital camera, scanner etc. For
example, you can take a photo with the digital camera, and transfer it in a computer to use an
image.
2. How is resizing of image different from cropping it?
ANS: Resizing is the process of reducing or enlarging the size of images while cropping cuts off
or remove the non-desirable part of the image.
3. What are the tools available in drawing tool bar? Describe any 5 tools.
ANS:
a) BASIC SHAPES: This tool helps us to draw the square, rectangle, triangle, etc
b) SYMBOL SHAPES: This tool helps us to draw cloud, moon of smiley face.
c) STARS & BANNERS: This tool help us to draw various types of stars, like four point star ,
five point stars etc.
ANS: Properties of the objects can be modified or edited, either at the time of its creation i.e.
before you start drawing them or after its creation.
5. How is linking of an image different from embedding? Give a situation in which you would
prefer to link an image.
ANS
LINKING EMBEDDING
The image isn’t actually included in the The image becomes a part of the document
document
Changes in the original image file will also Changes in the original image file do not affect
affect the linked image in the document. the embedded image in the document.
Does not increase the size of the document Increases the size of the document
We prefer to link an image when the size of the image is too large.
6. What are the benefits and drawbacks?
ANS: BENEFITS: Grouping allows multiple shapes to be treated as a single entity and making it
easier to move, resize or apply changes simultaneously.
ANS: LINE COLOR: This tool allows us to select the color of the line of selected drawing
object.
LINE THICKNESS: This tool allows us to select the thickness for the line of a selected drawing
object.
ANS: a) Place the cursor in the document where you want the drawing to be placed.
9.What will happen if the ‘Protected Against Manual Changes’ option is not selected in the Type
tab of Table of Contents, Index or Bibliography dialog box?
By default, the checkbox for Protected against Manual Changes option is selected. This
protects the ToC from any accidental change. If this box is unchecked, then the contents of ToC
can be changed directly on the document page, just like any other text on the document
In the Create Index or Table of Contents List box, the Entire Document option is selected in
the For list box. So the ToC will be automatically created from the headings and sub-headings of
entire document.
13. Give any one advantage of using a template for your document.
ANS: A template can contain all the features or objects that a regular document can contain –
text, graphics, and styles and can even use any language.
In a template we can create and save defined headings, text formats, styles, page numbers,
headers and footers.
16. What are the various buttons present on the Track Changes toolbar?
a) View Track Changes b) Record Track Changes c) Previous Track changes/ Next Track
changes d) Accept/Accept All Track Changes e) Reject/Reject All Track Changes f) Manage
Track Changes g) Insert Comment
SUBTOTAL-The Subtotal in Calc creates the group automatically and applies common
functions like Sum, Average on the grouped data.
WHAT-IF-SCENARIO: This refers to a set of values used to explore and compare various
alternatives based on changing condition. It allows you to create different scenarios on the same
sheet, each with some different values.
WHAT-IF-TOOL: This is a planning tool for what-if questions. In this, the output is not shown
in the same cells, whereas it uses a drop-down list to display the output depending upon the
input.
ANS: Data analysis is very useful in the beginning of any project to optimize the output.
Data analysis is used to predict the output while changing the inputs which reflects the output
and thus one can choose the best plan of action based on it.
ANS: Data types across all the sheets to be consolidated should be the same.
Label should match from all the sheets which are used for consolidating.
Designate the first column as the primary key column on the basis of which the data is to be
consolidated.
ANS: Group and outline in Calc is used to create an outline of the selected data.
1. What is a Macro? List any 2 real life situations where they can be used
a. Data Entry
b. Document Formatting
ANS:
Opening of windows
Actions carried out in another window than where the recording was started.
Window switching
Actions that are not related to the spreadsheet contents. For example, changes made in
the Options dialog, macro organizer, customizing.
Selections are recorded only if they are done by using the keyboard (cursor traveling),
but not when the mouse is used.
The macro recorder works only in Calc and Writer.
1. Define the terms a) Sharing Spreadsheet: Sharing a spreadsheet allows multiple users to open
the same file for editing at the same time.
b) Record Changes: This feature of LibreOffice Calc provides ways to record changes made by
one or other users in the spread sheet.
Reviewing changes means to go through all the changes made by the different users to decide
which changes should accept or reject to prepare the final spreadsheet.
The two ways to link the sheets in Libre Office Calc are
a) ACCURACY: Extracting data directly from a webpage, ensure that the information is
b) EFFICIENCY: Extracting data automates the process if gathering data from a webpage.
RDBMS
SESSION -1 - NCERT Q&A
1. Define the terms-a) Data base b) Data redundancy c) Report
ANS: a) A database is a collection of logically related data items stored in an organized manner.
b) Duplication of record is redundancy
c) A report is the formatted result of query which contains data required for decision
making and analysis.
2. Differentiate a) Data & Information b) From & Query c) Network & Hierarchal data model
ANS:
DATA INFORMATION
Raw facts and figure is called data Processed data is called information
FORM QUERY
A form is a feature of a database using which A Query is used to retrieve the desired
we can enter data in a table in an easy and user information from the database.
friendly manner.
NETWORK DATA MODEL HIERARCHIAL DATA MODEL
In the Network model, multiple records are The Relational data model is based on the
linked to same master file principle of setting relationships between two
or more tables of the same database
3. List out and explain the advantages of Database
a) ORGANISED STORAGE: The data in the database is stored in an organized manner, so that
retrieval of the required data is fast and accurate.
b) DATA ANALYSIS: A database helps in analysis of data based on certain criteria.
c) REDUCES DATA REDUDANCY: Database reduces duplication of data
d) SHARING OF DATA: In a database, the users of the database can share the data among
themselves.
e) DATA INTEGRITY: It means that the data is accurate and consistent in the database.
f) DATA SECURITY: Database provides data security as only the authorized users are allowed
to access the database and their identities are authenticated by using a user name and password.
g) PRIVACY: The privacy rule in a database states that only the authorized users can access a
database according to its privacy constraints.
h)BACK UP & RECOVERY: Database management System automatically takes care of backup
and recovery.
i) SECURITY: Unauthorised access can be controlled by assigning passwords to the users.
4.
a) Name the fields in the given table.
ANS: Book_Id, Book_name, Author Name, Price, Publisher
b) Which field should be made the primary key?
ANS: Book_Id
c) Is there any alternate key in the table?
Record Selector Box – This is the text box where the currently active record number is
displayed. We may enter the record number that we want to see in this text box.
Navigation Buttons – These are used to scroll vertically in the table.
4. Differentiate between one to one relationship and one to many relationship. Give suitable
examples to explain your answer.
ANS: One- to- one relationship: In this type of relationship, one specific record of a master table
has one and only one corresponding record in the transaction table.
One-to-many relationship: In this type of relationship, one specific record of the master table has
more than one corresponding records in the related transaction table. For example
5. Explain many to many relationships with an example.
ANS: Many-to-many relationship: In this type of relationship, there will be multiple records in
the master table that correspond to multiple records in the transaction table as well.
For example, a teacher in a school may hold multiple responsibilities such as class teacher, an
activity in charge or examination in-charge. For each responsibility the teacher might be attached
with multiple students.
3. What all information is seen in the overview (last step) of the Query wizard?
Ans: Last step of query wizard includes the following (query wizard overview)
The action to be performed after the wizard finishes – By default Display Query option will
be selected. Click and select the modify query radio button if the query has to be edited in the
Design View.
Complete detail of the query – This section contains a summary about the query that has been
created.
4. What is the use of Alias row in the Design grid of the Query Design window?
Ans : Sometimes field names are not user friendly so Alias can be used to display meaningful
names of the fields in the output.
5. Name any four mathematical functions that can be applied to numerical data in a query.
ANS: Four mathematical functions that can be applied to numerical data in a query are:
1. Sum
2. Average
3. Minimum
4. Maximum
3. Which tool on the Forms Record toolbar is used to insert text on the form?
ANS: Text box
Record Toolbar: The Records toolbar contains the navigation control buttons. With the help of
these buttons we can move from one record to another record.
WEB APPLICATIONS
1. Poor sitting postures or excessive duration of sitting in one position. These hazards may
result in pain and strain.
2. Making the same movement repetitively can also cause muscle fatigue.
1. Hazards using Computers:- Hazards while using computers include poor sitting postures
or excessive duration of sitting in one position. These hazards may result in pain and
strain.
2. Handling Office Equipment:- Improper handling of office equipment can result in
injuries. For example, sharp-edged equipment if not handled properly, can cause cuts.
3. Stress at work:- In an organizations, we may encounter various stress like long working
hours can be stressful and so can aggressive conflicts or arguments with colleague’s.
4. Working Environment:- Potential hazards may include poor ventilation, chairs and tables
of inappropriate height, hard furniture, poor lighting, staff unaware of emergency
procedures or poor housekeeping.
7. Describe information technology workplace hazards.
ANS: Some of the information technology workplace hazards are:
1. Poor sitting postures or excessive duration of sitting in one position. These hazards
may result in pain and strain.
2. Making the same movement repetitively can also cause muscle fatigue.
3. Glare from the computer screen can be harmful to the eyes.
8. What are the workplace safety rules?
ANS: Workplace safety rules are:
A) Basic Fire safety rules in an organization are:
1. Fire escape plans must be installed at proper levels
2. Conduct regular drills
3. Smoke alarms must be placed at proper intervals
4. Keep workplace a no-smoking zone
5. Maintenance of safety equipment must be taken care of regularly
B) Falls and Slips Safety rules
1. Keep the moving area clean and clutter free.
2. Workplace must be proper ventilated receive light.
3. Wear non slippery footwear.
4. Floors must be clean and dry.
5. Oil spills, dust must be immediately cleaned.
C) Electrical Safety rules
1. Electrical equipment used should be approved by a recognized organization.
2. Workers should be trained to handle the electric equipment safely.
3. Damaged and hazardous electrical should be immediately replaced.
4. Heat emanating equipment should be kept away from the electrical equipment.
9. List out different safety guidelines?
ANS: Safety Guidelines are:
1. Store all cleaning chemicals in tightly closed containers in separate cupboards.
2. Make sure all areas have proper lighting.
3. Do not wear loose clothing or jewelry when working with machines.
4. Never distract the attention of people who are working near a fire or with some
machinery.
5. Shut down all machines before leaving for the workplace.
6. Do not play with electrical controls or switches.
10. Describe type of emergency with example.
ANS : Various types of emergencies are there and there should be an emergency
management plan to handle the situation of emergency. Some of the types of emergencies
are as follows:
Session -2
1. What causes the water pollution?
ANS: Main causes of water pollution are:
1. Industrial waste
2. Sewage and waste water.
3. Oil leaks and spills
4. Fertilizers from agriculture field
5. Household waste
2. What is occupational overuse syndrome?
Occupational overuse syndrome, also known as repetition strain injury(RSI), is a
collective term for a range of conditions, characterized by discomfort or persistent
pain in muscles, tendons and other soft tissues. It is usually caused with repetitive
movement, sustained or constrained postures and/or forceful movements.
Psycho-social factors, including stress in the working environment, may be
important in the development of occupational overuse syndrome.
3. What are musculoskeletal problems?
ANS: This problem includes different areas of our body, such as neck, back, chests,
arms shoulders and feet. It occurs because of our wrong posture, uncomfortable chair for
sitting that is not ergonomically correct while working on the computer.
4. What cautions to be taken while working on the computer?
1. Keep your monitor at least 20 to 30 inch away from you.
2. Maximize contact of your back against the backrest of the chair.
3. Always take small breaks while working on the computer.
4. Wear anti-glare glasses to work on computer.
5. Why there is no right way to use a laptop?
ANS : There is really no right way to use a laptop because if you position the screen at
the right height for your back and neck, it will cause you to have to lift your arms and
shoulder too high to use it and vice versa.
6. What causes eye strain and how to avoid it?
ANS: Computer’s bright light, glare and flickering images can cause eye strain and visual
fatigue. It can be avoided by:
1. Adjusting the brightness of computer screen.
2. Keeping a proper vision distance from computer.
3. Blinking out eyes at regular interval.
4. Wearing anti-glare glasses while working in computer.
7. What type of display screen is suitable to work on computer?
ANS: We should use the modern LED monitors of legible size and with adequate spacing
between the characters and lines. The image on the screen should be stable, with no
flickering. The screen must be free of reflective glare.
8. What type of keyboard is suitable to work on computer?
ANS: The keyboard should tilt and separate from the screen so that we can find a
comfortable working position to avoid fatigue in the arms or hands. The keyboard should
have a matt surface to avoid reflective glare. The symbols on the keys must be adequately
contrasted.
Session – 3
1. What is a workplace emergency?
ANS: A workplace emergency refers to any unexpected situation that needs
immediate attention and action in workplace that may poses a risk to the safety and
security of employee’s.
2. How do you protect yourself, your employees, and your business?
ANS: The best way to protect yourself and your organization is to develop a well
thought-out emergency action plan to guide the employees in the event of an
emergency.
3. What is an emergency action plan?
ANS: An Emergency Action Plan (EAP) is a written document that states how to
react in different types of emergencies. Action plans of organizations should adhere
to safety standards set by the occupational safety and health administration (OSHA).
4. What should your emergency action plan include?
ANS: An Emergency action plan (EAP) should include the following:
1. Evacuation plans: It should have at least two escape routes from every area, and a
designated meeting place for employees to gather after evacuating.
2. Accounting for employees: Take a head count after an evacuation.
3. Reporting and alerting authorities.
4. Alerting staff and visitors about emergency
5. How do you develop an evacuation policy and procedures?
ANS: Steps to develop an evacuation policy and procedures are:
1. Evaluate the emergency.
2. Identify place where people can go in an emergency.
3. Identify the best ways to get out of the building.
4. Rehearse evacuation procedures.
5. Regularly review and update the plan as needed.
6. How do you establish evacuation routes and exits?
ANS: To establish evacuation routes and exits, you should
1. Know the nearest exit from your location and the route to get there.
2. Know the assembly point.
3. Know an alternate route in case your first route is blocked.
4. Know where to find first-aid supplies and fire extinguishers.
7. What are the various types of fire extinguisher and their extinguishing material?
ANS: Various types of fire extinguishers are:
1. Water : Water Fire Extinguishers are good for tackling fires involving burning
paper, wood and soft furnishing (Class A fires), as the water soaks into the
materials and cools them.
2. Foam: Foam fire extinguishers are suitable on Class A fires and fires involving
flammable liquids (Class B).
3. Dry powder: Dry powder fire extinguishers are incredibly versatile and can be
used for almost every kind of fire. (Class A, Class B and Class C).
4. CO2: CO2 fire extinguishers (also known as carbon dioxide fire extinguishers)
are mainly used for electrical fires.
5. Wet Chemical: Wet chemical fire extinguishers (also known as Class F fire
extinguishers) are the extinguisher that can safely be used for fires involving
cooking oil.
8. What are the steps for operating a fire extinguisher in case of a fire emergency?
1. Identify the safety pin of the fire extinguisher, present in its handle.
2. Break the seal and pull the safety pin from the handle.
3. Use the fire extinguisher by squeezing the lever.
4. Sweep it from side to side.
9. Compare the different type of fire extinguisher.
ANS: Different types of fire extinguishers are: