NIOS Class 12 October 2024 Question Paper Computer and Office Applications

This Question Paper consists of 07 questions and 5 printed pages.
ß‚ ¬˝‡Ÿ-¬òÊ ◊¥ 07 ¬˝‡Ÿ ÃÕÊ 5 ◊ÈÁŒ˝Ã ¬Îc∆U „Ò¥–
Roll No. Code No.
•ŸÈ∑˝§◊Ê¥∑§ ∑§Ê«U Ÿ¥.
68/ACV/O
SET/‚ ≈ A
COMPUTER AND OFFICE APPLICATIONS
∑¥§åÿÍ≈U⁄U •ÊÒ⁄U ∑§Êÿʸ‹ÿ •ŸÈ¬ÿÊª
(631)
Day and Date of Examination :
(¬⁄UˡÊÊ ∑§Ê ÁŒŸ fl ÁŒŸÊ¥∑§)
Signature of Invigilators :
(ÁŸ⁄UˡÊ∑§Ê¥ ∑§ „SÃÊˇÊ⁄U) 1.

2.

General Instructions :
1. Candidate must write his/her Roll Number on the first page of the Question Paper.
2. Please check the Question Paper to verify that the total pages and total number of questions
contained in the Question Paper are the same as those printed on the top of the first page. Also
check to see that the questions are in sequential order.
3. For the Objective type questions, you have to choose any one of the four alternatives given in the
question, i.e. (A), (B), (C) and (D) and indicate your correct answer in the Answer-Book given to you.
4. Making any identification mark in the Answer-Book or writing Roll Number anywhere other than
the specified places will lead to disqualification of the candidate.
5. Answers for all questions, including Matching, True or False, Fill in the blanks, etc., are to be given
in the Answer-Book only.
6. Write your Question Paper Code No. 68/ACV/O-A on the Answer-Book.
7. In case of any doubt or confusion in the question paper, the English Version will prevail.
‚Ê◊Êãÿ •ŸÈŒ‡Ê —
1. ¬⁄UˡÊÊÕ˸ ¬˝‡Ÿ-¬òÊ ∑§ §¬„‹ ¬Îc∆U ¬⁄U •¬ŸÊ •ŸÈ∑˝§◊Ê¥∑§ •fl‡ÿU Á‹π¥–
2. ∑Χ¬ÿÊ ¬˝‡Ÿ-¬òÊ ∑§Ê ¡ÊÚ°ø ‹¥ Á∑§ ¬˝‡Ÿ-¬òÊ ∑§ ∑ȧ‹ ¬Îc∆UÊ¥ ÃÕÊ ¬˝‡ŸÊ¥ ∑§Ë ©ÃŸË „Ë ‚¥ÅUÿÊ „Ò Á¡ÃŸË ¬˝Õ◊ ¬Îc∆ ∑ §‚’‚ ™§¬⁄U
¿U¬Ë „Ò– ß‚ ’Êà ∑§Ë ¡ÊÚ°ø ÷Ë ∑§⁄U ‹¥ Á∑§ ¬˝‡Ÿ ∑˝ Á◊∑§ UM§¬ ◊¥ „Ò¥–
3. § flSÃÈÁŸc∆U ¬˝‡ŸÊ¥ ◊¥ •Ê¬∑§Ê øÊ⁄U Áfl∑§À¬Ê¥ (A), (B), (C) ÃÕÊ (D) ◊¥ ‚ ∑§Ê߸ ∞∑§ ©ûÊ⁄U øÈŸŸÊ „Ò ÃÕÊ ŒË ªß¸ ©ûÊ⁄U-¬ÈÁSÃ∑§Ê ◊¥
•Ê¬ ‚„Ë ©ûÊ⁄U Á‹Áπ∞–
4. § ©ûÊ⁄U-¬ÈÁSUÃ∑§Ê ◊¥ ¬„øÊŸ-Áøq ’ŸÊŸ •ÕflÊ ÁŸÁŒ¸c≈U SÕÊŸÊ¥ ∑§§•ÁÃÁ⁄UÄà ∑§„Ë¥ ÷Ë •ŸÈ∑˝§◊Ê¥∑§ Á‹πŸ ¬⁄U ¬⁄UˡÊÊÕ˸ ∑§Ê •ÿÊÇÿ
∆U„⁄UÊÿÊ ¡ÊÿªÊ–
5. Á◊‹ÊŸ ∑§⁄UŸÊ, ‚„Ë •ÕflÊ $ª‹Ã, Á⁄UÄà SÕÊŸ ÷⁄UŸÊ, •ÊÁŒ ‚Á„à ‚÷Ë ¬˝‡ŸÊ¥ ∑§ ©ûÊ⁄U, ©ûÊ⁄U-¬ÈÁSÃ∑§Ê ◊¥ „Ë Á‹π¥–
6. •¬ŸË ©ûÊ⁄U-¬ÈÁSUÃ∑§Ê ¬⁄U ¬˝‡Ÿ-¬òÊ ∑§Ê ∑§Ê«U Ÿ¥. 68/ACV/O-A Á‹π¥–
7. ¬˝‡Ÿ¬òÊ ◊¥ Á∑§‚Ë ÷Ë ¬˝∑§Ê⁄U ∑§ ‚¥Œ„ •ÕflÊ ŒÈÁflœÊ ∑§Ë ÁSÕÁà ◊¥ •¥ª˝¡Ë •ŸÈflÊŒ „Ë ◊Êãÿ „ÊªÊ–
68/ACV/O-631-A ] 1 [ Contd...

COMPUTER AND OFFICE APPLICATIONS
∑¥§åÿÍ≈U⁄U •ÊÒ⁄U ∑§Êÿʸ‹ÿ •ŸÈ¬ÿÊª
(631)
Time : 2 Hours ] [ Maximum Marks : 40
‚◊ÿ — 2 ÉÊá≈U ] [ ¬ÍáÊÊZ∑§ — 40
Note / ÁŸŒ¸‡Ê — All questions are compulsory.
‚÷Ë ¬˝‡Ÿ •ÁŸflÊÿ¸ „Ò¥–

(1) Answers of all questions are to be given in the Answer-Book given to you.
‚÷Ë ¬˝‡ŸÊ¥ ∑§ ©ûÊ⁄U •Ê¬∑§Ê ŒË ªß¸ ©ûÊ⁄U-¬ÈÁSÃ∑§Ê ◊¥ „Ë Á‹π¥–
(2) 15 minutes time has been allotted to read this question paper. The question paper will be
distributed at 2:15 p.m. From 2:15 p.m. to 2:30 p.m., the students will read the question paper
only and will not write any answer on the Answer-Book during this period.
ß‚ ¬˝‡Ÿ-¬òÊ ∑§Ê ¬…∏Ÿ ∑§ Á‹∞ 15 Á◊Ÿ≈U ∑§Ê ‚◊ÿ ÁŒÿÊ ªÿÊ „Ò– ¬˝‡Ÿ-¬òÊ ∑§Ê ÁflÃ⁄UáÊ ŒÊ¬„⁄U ◊¥ 2:15 ’¡ Á∑§ÿÊ ¡Ê∞ªÊ–
2:15 ’¡ ‚ 2:30 ’¡ Ã∑§ ¿UÊòÊ ∑§fl‹ ¬˝‡Ÿ-¬òÊ ∑§Ê ¬…∏¥ª •ÊÒ⁄U ß‚ •flÁœ ∑§ ŒÊÒ⁄UÊŸ fl ©ûÊ⁄U-¬ÈÁSÃ∑§Ê ¬⁄U ∑§Ê߸ ©ûÊ⁄U Ÿ„Ë¥
Á‹π¥ª–

1. Fill in the blanks : ½x12=6
Á⁄UÄà SÕÊŸÊ¥ ∑§Ë ¬ÍÁø ∑§ËÁ¡∞ —
(a) Primary storage device __________ is volatile in nature since its contents are accessible
only as long as the computer is on.
¬˝ÊÕÁ◊∑§ ÷¥«UÊ⁄UáÊ ©¬∑§⁄UáÊ __________ •ÁSÕ⁄U ¬˝∑ΧÁà ∑§Ê „ÊÃÊ „Ò ÄÿÊ¥Á∑§ ß‚∑§Ë ‚Ê◊ª˝Ë ∑§fl‹ Ã’ Ã∑§ „Ë
‚È‹÷ „ÊÃË „Ò ¡’ Ã∑§ ∑¥§åÿÍ≈U⁄U øÊ‹Í ⁄U„ÃÊ „Ò–
(b) The function of the __________ is to perform all calculations and comparisions based
on the instruction provided.
__________ ∑§Ê ∑§Êÿ¸ ÁŒ∞ ª∞ ÁŸŒ¸‡ÊÊ¥ ∑§ •ÊœÊ⁄U ¬⁄U ‚÷Ë ªáÊŸÊ∞° •ÊÒ⁄U ÃÈ‹ŸÊ∞° ∑§⁄UŸÊ „Ò–
(c) The main purpose of an __________ system is to manage computer hardware and
provide a user Interface.
∞∑§ __________ Á‚S≈U◊ ∑§Ê ◊ÈÅÿ ©g‡ÿ ∑¥§åÿÍ≈U⁄U „Ê«¸Uflÿ⁄U ∑§Ê ¬˝’¥œŸ ∑§⁄UŸÊ •ÊÒ⁄U ©¬ÿÊª∑§Ãʸ ߥ≈U⁄U»§‚
¬˝ŒÊŸ ∑§⁄UŸÊ „Ò–
(d) Shortcut key used for the Paste command is __________.
¬S≈U ∑§◊Ê¥«U ∑§ Á‹∞ ¬˝ÿÈÄà ‡ÊÊ≈¸U∑§≈U ∑È¥§¡Ë __________ „Ò–
(e) By default a workbook opens with 3 worksheets and it can contain maximum upto
__________ number of worksheets.
Á«U$»§ÊÚÀ≈U M§¬ ‚ ∞∑§ ∑§Êÿ¸¬ÈÁSÃ∑§Ê ÃËŸ ∑§Êÿ¸¬òÊ∑§Ê¥ ∑§ ‚ÊÕ πÈ‹ÃË „Ò •ÊÒ⁄U ß‚◊¥ •Áœ∑§Ã◊ __________
Ã∑§ ∑§Êÿ¸¬òÊ∑§ „Ê ‚∑§Ã „Ò¥–

68/ACV/O-631-A ] 2 [ Contd...

(f) FTP or File Transfer Protocol is an __________ utility software used to upload and
download files.
∞»§ ≈UË ¬Ë ÿÊ »§Êß‹ ≈˛UÊ¥‚»§⁄U ¬˝Ê≈UÊ∑§ÊÚ‹ ∞∑§ __________ ©¬ÿÊªË ‚ÊÚç≈flÿ⁄U „Ò Á¡‚∑§Ê ©¬ÿÊª »§Êß‹Ê¥ ∑§Ê
•¬‹Ê«U •ÊÒ⁄U «UÊ©Ÿ‹Ê«U ∑§⁄UŸ ∑§ Á‹∞ Á∑§ÿÊ ¡ÊÃÊ „Ò–
(g) __________ refers to a program which disrupts normal functioning of your computer.
__________ ∞∑§ ¬˝Êª˝Ê◊ ∑§Ê ‚¥ŒÁ÷¸Ã ∑§⁄UÃÊ „Ò ¡Ê •Ê¬∑§ ∑¥§åÿÍ≈U⁄U ∑§ ‚Ê◊Êãÿ ∑§Ê◊∑§Ê¡ ∑§Ê ’ÊÁœÃ ∑§⁄UÃÊ „Ò–
(h) The E-mail address provides all the information required to get a message to the
__________ from anywhere in the world.
߸-◊‹ ¬ÃÊ ŒÈÁŸÿÊ ◊¥ ∑§„Ë¥ ‚ ÷Ë __________ Ã∑§ ‚¥Œ‡Ê ¬„È°øÊŸ ∑§ Á‹∞ •Êfl‡ÿ∑§ ‚÷Ë ¡ÊŸ∑§Ê⁄UË ¬˝ŒÊŸ
∑§⁄UÃÊ „Ò–
(i) __________ is the service that allows individuals and organisations to make their website
accessible via the Internet.
__________ fl„ ‚flÊ „Ò ¡Ê √ÿÁÄÃÿÊ¥ •ÊÒ⁄U ‚¥ª∆UŸÊ¥ ∑§Ê ߥ≈U⁄UŸ≈U ∑§ ◊Êäÿ◊ ‚ •¬ŸË fl’‚Êß≈U ∑§Ê ‚È‹÷
’ŸÊŸ ∑§Ë •ŸÈ◊Áà ŒÃË „Ò–
(j) __________ registration is done to protect a company name or trade mark.
__________ ¬¥¡Ë∑§⁄UáÊ Á∑§‚Ë ∑¥§¬ŸË ∑§ ŸÊ◊ ÿÊ ≈˛U«U◊Ê∑¸§ ∑§Ë ‚È⁄UˇÊÊ ∑§ Á‹∞ Á∑§ÿÊ ¡ÊÃÊ „Ò–
(k) For printing a presentation, select Office button → __________ command on the menu
bar.
¬˝¡¥≈U‡ÊŸ Á¬˝¥≈U ∑§⁄UŸ ∑§ Á‹∞ ◊ŸÍ ’Ê⁄U ¬⁄U Office ’≈UŸ → __________ ∑§◊Ê¥«U ∑§Ê øÿŸ ∑§⁄¥U–
(l) In MS Access, a __________ serves as a container for objects like tables, forms, queries
and reports, facilitating efficient data management.
∞◊ ∞‚ ∞Ä‚‚ ◊¥, ∞∑§ __________ ≈U’‹, »§ÊÚ◊¸, Äfl⁄UË$¡ •ÊÒ⁄U Á⁄U¬Ê≈¸U ¡Ò‚ •ÊÚé¡Ä≈˜U‚ ∑§ Á‹∞ ∞∑§ ∑¥§≈UŸ⁄U
∑§ M§¬ ◊¥ ∑§Êÿ¸ ∑§⁄UÃÊ „Ò ¡Ê ∑ȧ‡Ê‹ «UÊ≈UÊ ¬˝’¥œŸ ∑§Ë ‚ÈÁflœÊ ¬˝ŒÊŸ ∑§⁄UÃÊ „Ò–

2. State True or False : ½x12=6
‚„Ë/ª‹Ã ’ÃÊß∞ —
(a) An operating system acts as an Interface between users or application programs and
the computer hardware.
•ÊÚ¬⁄Á≈U¥ª Á‚S≈U◊ ©¬ÿÊª∑§Ãʸ•Ê¥ ÿÊ ∞Áå‹∑§‡ÊŸ ¬˝Êª˝Ê◊ •ÊÒ⁄U ∑¥§åÿÍ≈U⁄U „Ê«¸Uflÿ⁄U ∑§ ’Ëø ∞∑§ ߥ≈U⁄U»§‚ ∑§ M§¬
◊¥ ∑§Êÿ¸ ∑§⁄UÃÊ „Ò–
(b) ROM stands for Read Only Memory and it stores an initial program called Bootstrap
loader.
•Ê⁄U-•Ê-∞◊ (ROM) ∑§Ê ◊Ë’ ⁄UË«U •ÊŸ‹Ë ◊◊Ê⁄UË „Ò •ÊÒ⁄U ÿ„ ’Í≈US≈˛ÒU¬ ‹Ê«U⁄U ŸÊ◊∑§ ¬˝Ê⁄¥UÁ÷∑§ ¬˝Êª˝Ê◊ ∑§Ê
S≈UÊ⁄U ∑§⁄UÃÊ „Ò–
(c) Hard Disk Drive is an example of secondary storage devices.
„Ê«¸U Á«US∑§ «˛UÊßfl ÁmÃËÿ∑§ ÷¥«UÊ⁄UáÊ ©¬∑§⁄UáÊÊ¥ ∑§ ©ŒÊ„⁄UáÊ ∑§ M§¬ ◊¥ „Ò–
(d) WAN stands for Wireless Area Network.
«Ué‹Í ∞ ∞Ÿ (WAN) ∑§Ê ◊Ë’ flÊÿ⁄U‹‚ ∞Á⁄UÿÊ Ÿ≈Ufl∑¸§ „Ò–
(e) Fibre Optic Cables are not affected by electromagnetic radiations.
»§Êß’⁄U •ÊÚÁå≈U∑§ ∑§’‹ ÁfllÈà øÈê’∑§Ëÿ ÁflÁ∑§⁄UáÊÊ¥ ‚ ¬˝÷ÊÁflà Ÿ„Ë¥ „ÊÃ–

68/ACV/O-631-A ] 3 [ Contd...

(f) Excel offers various types of charts, including Pie charts, Bar charts and Scatter charts
to visually represent data.
∞Ä‚‹ ÁflÁ÷㟠¬˝∑§Ê⁄U ∑§ øÊ≈¸U ¬˝ŒÊŸ ∑§⁄UÃÊ „Ò, Á¡‚◊¥ «UÊ≈UÊ ∑§Ê ŒÎ‡ÿ M§¬ ‚ ¬˝SÃÈà ∑§⁄UŸ ∑§ Á‹∞ ¬Ê߸ øÊ≈¸U,
’Ê⁄U øÊ≈¸U •ÊÒ⁄U S∑Ò§≈U⁄U øÊ≈¸U ‡ÊÊÁ◊‹ „Ò–
(g) The ‘Memo’ data type in Access is suitable for storing large text or memo data.
∞Ä‚‚ ◊¥ ◊◊Ê «UÊ≈UÊ ¬˝∑§Ê⁄U, ’«∏ ≈UÄS≈U ÿÊ ◊◊Ê «UÊ≈UÊ ∑§Ê ‚¥ª˝„Ëà ∑§⁄UŸ ∑§ Á‹∞ ©¬ÿÈÄà „Ò–
(h) DSL, Leased line and Dialup are types of Viruses.
«UË ∞‚ ∞‹, ‹Ë$¡ ‹Êߟ •ÊÒ⁄U «UÊÿ‹ •¬ flÊÿ⁄U‚ ∑§ ¬˝∑§Ê⁄U „Ò¥–
(i) Website planning is the least important part for building a website.
fl’‚Êß≈U ’ŸÊŸ ∑§ Á‹∞ fl’‚Êß≈U ∑§Ë ÿÊ¡ŸÊ ’ŸÊŸÊ ‚’‚ ∑§◊ ◊„àfl¬Íáʸ Á„S‚Ê „Ò–
(j) Website is a collection of documents written in HTML.
fl’‚Êß≈U ∞ø ≈UË ∞◊ ∞‹ (HTML) ◊¥ Á‹π ª∞ ŒSÃÊfl¡Ê¥ ∑§Ê ∞∑§ ‚¥ª˝„ „Ò–
(k) You get a domain name from a Domain Name Registrar.
•Ê¬∑§Ê «UÊ◊Ÿ ŸÊ◊ ⁄UÁ¡S≈˛UÊ⁄U ‚ «UÊ◊Ÿ ŸÊ◊ Á◊‹ÃÊ „Ò–
(l) UTP stands for Unshielded Twisted Pair.
ÿÍ ≈UË ¬Ë ∑§Ê ◊Ë’ „Ò - •Ÿ‡ÊËÀ«U«U Á≈˜flS≈U«U ¬ÿ⁄U–

3. Define the following : 1x4=4
ÁŸêŸÁ‹Áπà ∑§Ê ¬Á⁄U÷ÊÁ·Ã ∑§ËÁ¡∞ —
(a) Plotter
å‹ÊÚ≈U⁄U
(b) Copying Text
¬Ê∆U ∑§Ë ¬˝ÁÃÁ‹Á¬ ’ŸÊŸÊ
(c) Wide Area Network
flÊß«U ∞Á⁄UÿÊ Ÿ≈Ufl∑¸§
(d) Components of Website
flÊ’‚Êß≈U ∑§ ÉÊ≈U∑§

4. Write short notes on any three of the following : 2x3=6
ÁŸêŸÁ‹Áπà ◊¥ ‚ Á∑§ã„Ë¥ ÃËŸ ¬⁄U ‚¥ÁˇÊåà Á≈Uå¬ÁáÊÿÊ° Á‹π¥ —
(a) Advantages of Internet
ßã≈⁄UŸ≈U ∑§ ‹Ê÷
(b) Benefits for Domain Name Registration
«UÊ◊Ÿ ŸÊ◊ ¬¥¡Ë∑§⁄UáÊ ∑§ ‹Ê÷
(c) Logical operators in MS Access
∞◊ ∞‚ ∞Ä‚‚ ◊¥ ÃÊÁ∑¸§∑§ •ÊÚ¬⁄U≈U⁄U
(d) Open Source Software
•Ê¬Ÿ dÊà ‚ÊÚç≈Uflÿ⁄U
(e) Slide Layout
S‹Êß«U ‹•Ê©≈U

68/ACV/O-631-A ] 4 [ Contd...

5. Differentiate between the following : 1+1=2
ÁŸêŸÁ‹Áπà ◊¥ •¥Ã⁄U S¬C ∑§ËÁ¡∞ —
(a) Twisted Pair cable and Optical Fibre cable
Á≈˜flS≈U«U ¬ÿ⁄U ∑§’‹ •ÊÒ⁄U •ÊÚÁå≈U∑§‹ »§Êß’⁄U ∑§’‹
(b) Header and Footer
‡ÊË·¸∑§ •ÊÒ⁄U ¬Îc∆UÊ¥∑§

6. Answer the following questions : 2x5=10
ŸËø Á‹π ¬˝‡ŸÊ¥ ∑§ ©ûÊ⁄U ŒËÁ¡∞ —
(a) What factors influence the efficiency and reliability of data communication ?
«UÊ≈UÊ ‚¥øÊ⁄U ∑§Ë ŒˇÊÃÊ •ÊÒ⁄U Áfl‡fl‚ŸËÿÃÊ ∑§Ê ∑§ÊÒŸ ‚ ∑§Ê⁄U∑§ ¬˝÷ÊÁflà ∑§⁄UÃÊ „Ò?
(b) Explain Transmitter and Receiver used in Data Communication.
«UÊ≈UÊ ‚¥øÊ⁄U ◊¥ ¬˝ÿÈÄà ≈˛UÊ¥‚◊Ë≈U⁄U •ÊÒ⁄U Á⁄U‚Ëfl⁄U ∑§Ë √ÿÊÅÿÊ ∑§ËÁ¡∞–
(c) Write the steps to create a Bulleted list.
’È‹≈U«U ‚ÍøË ’ŸÊŸ ∑§ ø⁄UáÊ Á‹Áπ∞–
(d) What are the various types of Web Hosting Services ?
fl’ „ÊÁS≈¥Uª ‚flÊ•Ê¥ ∑§ ÁflÁ÷㟠¬˝∑§Ê⁄U ÄÿÊ „Ò¥?
(e) Compute the result for the following :
ÁŸêŸÁ‹Áπà ∑§ Á‹∞ ¬Á⁄UáÊÊ◊ ∑§Ë ªáÊŸÊ ∑§ËÁ¡∞ —
(i) If cell A9 contains the value 50 and cell B9 contains the value 10, what is the
result of the formula ?
=(A9*2)+(B9/2)
ÿÁŒ ‚‹ A9 ◊¥ ◊ÊŸ 50 „Ò •ÊÒ⁄U ‚‹ B9 ◊¥ ◊ÊŸ 10 „Ò ÃÊ ‚ÍòÊ ∑§Ê ¬Á⁄UáÊÊ◊ ÄÿÊ „Ò?
=(A9*2)+(B9/2)
(ii) Cell A10 contains the value 120 and cell B10 contains the value 3, what is the
result of the formula ?
=A10/(B10−1)
‚‹ A10 ◊¥ ◊ÊŸ 120 „Ò •ÊÒ⁄U ‚‹ B10 ◊¥ ◊ÊŸ 3 „Ò– ß‚ ‚ÍòÊ ∑§Ê ¬Á⁄UáÊÊ◊ ÄÿÊ „Ò?
=A10/(B10−1)

7. Answer the following questions in detail : 3x2=6
ÁŸêŸÁ‹Áπà ¬˝‡ŸÊ¥ ∑§ ©ûÊ⁄U ÁflSÃÊ⁄U ‚ ŒËÁ¡∞ —
(a) Describe the key properties and benefits of Computer Network.
∑¥§åÿÍ≈U⁄U Ÿ≈Ufl∑¸§ ∑§ ¬˝◊Èπ ªÈáÊÊ¥ •ÊÒ⁄U ‹Ê÷Ê¥ ∑§Ê fláʸŸ ∑§⁄¥U–
(b) Describe various slide views.
ÁflÁ÷㟠S‹Êß«U ŒÎ‡ÿÊ¥ ∑§Ê fláʸŸ ∑§⁄¥U–

-oOo-

68/ACV/O-631-A ] 5 [ Contd...