PART-I 33% PORTION EXAMINATION (2023-24)
GRADE: X INFORMATION TECHNOLOGY - ANSWER KEY
Q1. ANSWER ANY 4 OUT OF 6 QUESTIONS
i) d. all of the above
ii) b.wage employed
iii) c. patient
iv) d. all the above
v) a.makes decisions
vi) a.self employed
Q2. ANSWER ANY 5 OUT OF 6 QUESTIONS
i) d. macro
ii) a. 3
iii) b. =
iv) a. merge tab
v) b. To determine the value of cell for given result
vi) a. $C7
Q3. ANSWER ANY 5 OUT OF 6 QUESTIONS
i) c. assistive technology
ii) c. both of the above
iii) c. sticky keys
iv) c. LAN
v) d. MODEM
vi) a. Instant messaging
Q4. ANSWER ANY 5 OUT OF 6 QUESTIONS
i) a. blog
ii)d.all the above
iii)a.WiMax
iv)b. evacuation
v)a. email addresses
vi)c. Psychosocial hazards
Q5. ANSWER ANY 5 OUT OF 6 QUESTIONS
i)d.microsoft windows
ii)b.auditory
iii)c.all of the above
iv)a.web browser, active internet
v)c.solver
vi) b) Absolute Referencing
SECTION – B SUBJECTIVE TYPE QUESTIONS
ANSWER ANY 3 OUT OF THE GIVEN 5 QUESTIONS
Q6. Create Jobs
With the growth of a business, entrepreneurs look for more people to help them. They buy more
material, and from more people. They also hire more people to work for them. In this way, more
people have jobs.
Sharing of Wealth
Wealth means having enough money to live a comfortable life. As entrepreneurs grow their
business, the people working for them and in related businesses also grow. Hey have more
money to live a better quality life.
Lower Price of Products
As more entrepreneurs sell the same product, the price of the product goes down.
Q7. Making Decisions: An entrepreneur makes decisions everyday. This includes what to
produce or sell, how much and where to sell.
Managing the Business: An entrepreneur plans the future of his or her business. He/she
arranges for raw material, hires people for work and tells everyone what to do. They also check
if the plan is being followed.
Divide Income: The entrepreneur divides the business money into many groups. He/she
spends money to buy material, pays rent of the building and salaries to people.
Taking Risk: Risk is the chance of something going wrong. An entrepreneur takes risks against
fires, lost items and theft.
Create a new Method, Idea or Product: An entrepreneur is always trying new things. He/she
does this to increase their importance and income.
Q8. What is the difference between a misconception and reality? Give an example.
The difference between misconception and reality are:
Misconception: A myth, or a misconception, is a false belief or opinion about something. For
example, if we think tall people run faster than short people, we have a misconception. It is not
true. The truth is that short people can also run fast.
Reality: Reality is the state of things as they actually exist, rather than as they may appear or
might be imagined. In other words reality includes everything that is and has been, whether or
not it is observable or comprehensible.
Q9. Difference between Self employment & Wage employment?
Self Employment – An entrepreneur is a self-employed individual who runs a business to meet
a need by experimenting with new ideas.
i. Enter – When an entrepreneur first starts business, they are simply getting their feet
wet in the business world.
ii. Survive – There are a lot of entrepreneurs around nowadays. In a competitive market,
the entrepreneur must remain competitive.
iii. Grow – An entrepreneur considers growing his or her business once it has reached
a certain level of stability.
Wage Employment – Wage management is based on work grades and performance parameters.
Wage management’s goal is to take reward and give high performance standards in the
business.
Q10.
Story Misconception
Ramu owns a large clothes shop. Shamu has a small (c) A person needs to have a
store selling handmade sarees. Shamu does not call big business to be called an
himself an entrepreneur. entrepreneur.
Anna has a great idea for a website. She has 5,000.
(b) Entrepreneurs are born,
She is waiting for 20,000 more, so that she can start
not made.
it.
In a city of thousands of tailoring shops, Gauri is a
(a) Every business idea needs
tailor who stitches good quality clothes and has a
to be unique or special.
very successful business.
ANSWEWR ANY 4 OUT OF ANY GIVEN 6 QUESTIONS
Q11. Hyperlinks can be used in Calc to jump to a different location from within a spreadsheet
and can lead to other parts of the current file, to different files or even to web sites.
Relative And Absolute Hyperlinks
Hyperlinks can be stored within your file as either relative or absolute. 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.
Q12. Creating The Reference With The Keyboard
Typing the reference is simple once you know the format the reference takes. The reference has
three parts to it: Path and file name . Sheet name . Cell name
With Mouse
1) Go to sheet 2 and select the cell where we want to create reference.
2) Type equal (=) to sign.
3) Go to sheet 1 where we want to set reference.
4) Select the cell and click green accept button.
Q13. 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.
Q14.
1. Keep the length of the password at least 12-14 characters if permitted.
2. Avoid keeping passwords based on repetition, dictionary words, letter or number
sequences, usernames, relative or pet names, etc.
3. Including numbers, and symbols in passwords if allowed.
4. Use capital and lower-case letters.
5. Avoid using the same password for multiple sites or purposes.
6. Avoid using something that the public or workmates know you strongly like or dislike.
Q15. The main purpose of Internet security is to protect your devices from malware and other
malicious software that can cause harm to your devices. Internet security is the protection of
information and resources from any kind of damage caused by unauthorized use of a computer
or network resources. This includes viruses, malware, phishing, and other cyber threats.The
purpose of Internet security is to protect the integrity, confidentiality, and availability of data,
infrastructure, and applications. Internet security is the practice of protecting your network,
data and personal information from harmful threats.
Q16. Filter Keys is an accessibility function that tells the keyboard to ignore brief or repeated
keystrokes, making typing easier for people with hand tremors.
ToggleKeys is an accessibility function which is designed for people who have vision
impairment or cognitive disabilities. When ToggleKeys is turned on, computer emits sound cues
when the locking keys (Caps Lock, Num Lock, or Scroll Lock) are pressed.
ANSWEWR ANY 3 OUT OF ANY GIVEN 5 QUESTIONS
Q.17 Linking To External Data :
You can insert tables from HTML documents, and data located within named ranges from an
OpenOffice.org Calc or Microsoft Excel spreadsheet, into a Calc spreadsheet You can do this in
two ways: using the External Data dialog or using the Navigator
Using the External Data dialog : Steps are
1. Open the Calc worksheet where the external data is to be inserted. This is the target
worksheet.
2. Select the cell where the upper left-hand cell of the external data is to be inserted.
3. Choose Insert -> Link to External Data.
4. On the External Data dialog, type the URL of the source worksheet
5. In the Available tables/range list, select the named ranges or tables you want to insert.
6. Click OK to close this dialog and insert the linked data.
Linking To Registered Data Sources :
You can access a variety of databases and other data sources and link them into Calc worksheets.
First you need to register the data source with OpenOffice.org. To register a data source that is
in *.odb format:
1. Choose Tools -> Options -> OpenOffice.org Base -> Databases.
2. Click the New button to open the Create Database Link dialog.
3. Enter the location of the database file, or click Browse to open a file browser and select
the database file.
4. Type a name to use as the registered name for the database and click OK.
Q.18 (a) He need to ensure that website URL must have lock icon at the beginning and starts
with https
(b) He can use a good antivirus software
(c) Phishing refers to the internet represents an insecure channel for exchanging information
leading to a high risk of intrusion or fraud.
(d)Cookies are programs that are created on your local computer when you visit websites.
Cookies are meant for storing data based on activity performed during earlier visits. Cookies
stores logon details, details of a shopping cart, visited pages in a website etc. They could be also
tracked by unauthorized users and possibly gain access to personal information.
Q.19 (a) World Wide Web (abbreviated as WWW or W3, commonly known as the Web), is a
system of interlinked hypertext documents accessed via the Internet. Two popular web
browsers are: Google Chrome and Mozilla Firefox
(b) The data transfer on the internet is done through the following steps:
1. Information on internet is divided into small packets. Each packet is sent from computer to
computer until its find its destination. Each computer on the way decides where the next packet
to be sent. All packets may have their different routes.
2. Once the packet reaches to its destination, packet will be examined. If any packets are missing
or damaged, a message for sending it again will be sent. This process continues till all packets
have beed received.
3. Finally all the packets reassembled into the original form.
Q.20. a) Networks in which all computers have an equal status are called peer to peer networks
whereas in which certain computers have special dedicated tasks, providing services to
other computers (in the network) are called client server networks.
b) Expand the following terms: i. Wireless Access Point ii. WWW (World Wide Web)
c) Advantages of Networking are:
• Data Sharing: One of the most important uses of networking is to allow the sharing of
data.
• Files Transfer : Users can send text files, spread sheets, documents, presentations,
audio files, video files, etc. to other users.
• Hardware Sharing: Hardware components such as printers, scanners, etc. can also be
shared. For example, instead of purchasing 10 printers for each user, one printer can be
purchased and shared among multiple users thus saving cost.
• Internet Access Sharing: You can purchase a single Internet connection and share it among
other computers in a network instead of purchasing multiple Internet connection for each
computer. This is very commonly found in Internet café (browsing centres), schools, colleges,
companies, etc.
• Usage of network based applications: Such as web browsers, email clients,
chat application, audio & video calling, etc. is another advantage.
d) A blog is a discussion style site used by nontechnical or technical users for creating personal
web pages. Blogs are similar to an online personal diary and simple to use. The advantage
of offline blog is, it can be created first and later publish the content when an
active internet connection is available.
Q.21 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.
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.
1. Open a new spreadsheet.
2. Enter numbers into a sheet. Enter numbers.
3. Select cell A3, which contains the number 3, and copy the value to the clipboard.
4. Select the range A1:C3.
5. Use Tools ->Macros ->; Record Macro to start the macro recorder. The Record
Macro dialog is displayed with a stop recording button.
6. Use Edit -> Paste Special to open the Paste Special dialog.
7. Set the operation to Multiply and click OK. The cells are now multiplied by 3.
8. Click Stop Recording to stop the macro recorder. The OpenOffice.org Basic
Macros dialog opens.
9. Select the current worksheet. For this example, the current Calc worksheet is Untitled 1.
Existing worksheets show a library named Standard. This library is not created until the
worksheet is saved, or the library is needed, so at this point your new worksheet does not
contain a library. You can create a new library to contain the macro, but this is not necessary
10.Click New Module. If no libraries exist, then the Standard library is automatically created
and used. In the New Module dialog, type a name for the new module or leave the name as
Module1.
11.Click OK to create a module named Module1. Select the newly created Module1, enter the
macro name PasteMultiply and click Save.
12.The created macro is saved in Module1 of the Standard library in the Untitled 1worksheet
