Computing skills - Part - I

 Please refer this Computing skills stuff shared by TISS  Support Material

PPT  

FG Based PPT

Practice Exercise

Improve your typing speed at https://monkeytype.com/

wonderful stuff to go through for Computer basics

Q 1. Write 50 application areas where computer is used.

Q 2. Enlist (images only) input , output and storage devices .

Q 3. Make a list of computer devices that remain connected to the CPU box all the time.

Q 4. Make a list of computer devices that do not necessarily remain connected to the CPU box all the time.

Q 5. Collect some pictures of monitor, CPU, keyboard, CD, DVD drive and printers from newspaper or magazines and paste them in your MS-word file with their name.

Q 6. Make a list of application software that you use in your institute computer lab?

Q 7.Change the desktop background / wallpaper of your computer?

Qs 8. Write sequential steps to start use and shutdown the computer

Q 9. Open Notepad and type the keyboard manners?

*** keyboard manners ***

•       Use the keyboard with clean hands.

•       Never touch the keyboard with the wet hands.

•       Do not press the keys of the keyboard forcibly.

•       Don to pull the wires attached to the keyboard.

•       Do not crack the keyboard.

      Do not eat or drink near it

Qs 10. Write a leave application to your TISS batch coordinator by specifying the reason of leave?

Qs 11. Create a poster for computer lab

Do And Don’t For Computer Lab (Insert a suitable or relevant Image also)

•       Sit and wait for the teacher’s instructions

•       Keep silence

•       Keep the lab clean

•       Handle the devices gently

•       Don’t bring any pen drive to the lab.

•       Don’t disconnect any cable for anything from the computer.

•       Don’t disturb others.

Qs 12 : Explore different storage devices along with features?

Qs 13: Why computer is so famous nowadays?

 Qs 14. What is desktop, icons and taskbar properties?

Qs 15.How to create folder / delete folder / rename folder and restore deleted folder.

Qs 16. How to move file / folder and even applications in a folder?

Qs 17. How to create a shortcut.

Qs 18. How to change wallpaper of your system

Qs 19. How to bring clock and calendar at your desktop.

Qs 20.Create a backup process as discussed

Qs 21 Create PDF for the same

Qs 22 Reset your password

Qs 23 Change profile picture of your machine  or laptop

Qs 24  Explore

1. Window defender
2. User accounts
3. Windows firewall

Qs 25. Convert PDF to word file using online converter [https://www.ilovepdf.com/]

Qs 26.Pin / unpin any application on taskbar

Qs 27. Add files or folder in your favourite folder

Qs 28. Check the IP address of your machine

Qs 29.Check the computer name of your machine

Qs 30.Check the domain name of your machine (if any)

•       https://www.myntra.com/

•       https://www.shadi.com/

•       https://www.hindustantimes.com/

•       https://timesofindia.com/

•       https://www.shopify.com/

•       https://www.amazon.in/

•       https://www.quora.com/

•       https://stackoverflow.com/

•       https://www.geeksforgeeks.org/

•       https://www.learnvern.com/

 

Qs 31 Explore 10 key points about Delhi through Google only.

Qs 32. Find out 5 features of Mainframe and Supercomputer.

Qs 33. Download 3 images of Mr.  Ramnath Kovind save it in a folder namely Project.

Qs 34. Search an essay on topic “ Top 10 Advantages Of Internet For Students”

Qs 35. Ensure your search should reflect only videos.

Qs 36. Ensure your search should reflect only images.

Qs 37. Ensure your search should reflect only ppt or pdf through advance search option.

Qs  38 How to delete history of searches in your machine.

Qs 39 Bookmark the favorite link.

Qs 40 What is keywords?

Qs 42.  Explore : https://www.wisegeek.com/

•       https://www.similarweb.com/top-websites/category/travel-and-tourism/

•       https://freekaamaal.com/travel/top-hotel-booking-sites-in-indi

 Qs 43. Create your own bullets of your choice

 Qs 44.Apply format painter

Qs 45. Create a shortcut key chart also [ctrl + N ctrl +Z , Ctrl +Y, ctrl + A, winword]

Qs 46. Display your name in 10 professional fonts

Qs 47. Write a poem of your choice and change its font to be comic sans.

Qs 48. Type a page on topic “My mother”

Qs 49. Create an ordered –(friend list) / unordered list (enemies)

Qs 50.Your document should center aligned

Qs 51.  Line spacing should be 1.5

Qs 52. Apply case [Toggle, upper/ lower ...]

Qs 53. WYSIWYG è What you see is What you Get

Qs 54.Type this content first

Qs 55.What is Wireless networking ?

Wireless networking which is often just known as Wi-Fi is a way of getting broadband internet without wires. Wi-Fi allows you to connect several computers at once, anywhere in the house or even if you have laptop , to even use your computer in the garden. You don’t need to install extra phone lines or cables.

Qs 56. Type the given content first , this content should be in justified alignment

Qs 57.Give this work a suitable title

Qs 58. changes font to be Cambria and point size as 14 points

Qs 59.Type it :

· H20

· Z3+2X-7Y=4

· Sale Sale Sale!!!............

Qs 60. Replace Wi-Fi word with Wireless networking using shortcut key Ctrl + H

Qs 61 Find “phone” word in this document using shortcut key Ctrl + F

Qs 62 update shortcut key chart

Qs 63 Display your best friend name in all different cases

1. Chandan

2. chandan

3. CHANDAN

4. cHANDAN

5. Chandan

Qs 64.  Draw different types of line also

Qs 65. Change the page colour to orange

Qs 66. Insert “Practice Exercise - Computing Skills ” word in the header and page no in the footer

Qs 67. Insert a hyperlink https://tiss.edu/ under the label “ Welcome to TISS”

Qs 68. use Smart art feature to express 10 features of MS word

Qs 69. Display “Happy Diwali” 5 times using wordart feature of MS-Word.

Qs 70. Create a cover page of your choice and reflect the same. 

Qs 71. Apply drop cap effect create and Insert a speed chart table in your document. 

Qs 72. Insert a blank page in the beginning of your document Use Ctrl + G [update shortcut key chart] 

Qs 73. Apply page break
Qs  74. Apply below listed task (a) Crop the image  (b) Change border color

Qs  75. Add Effects- compress, change picture Remove background Changes size of the picture in terms of height and width 

Qs. 76. Apply Wrap text Compress picture and change picture
Qs 77. Insert 5 different shapes Insert readymade table formats 

Qs 78. Create a table to reflect the scoreboard of Indian cricket team.

Qs 79 Insert “ OM “ symbol in your document. 

Qs 80. Type a mathematical equation using MS-word feature

Qs 81. User smart art feature to reflect your hobbies

Qs 82.Use custom margin to change the margin

Qs 83 Change orientation of your document to be landscape

Qs 84.Convert the normal text into 3 columns.

Qs 85.      Insert water (text and Picture)

Qs 86. Apply border to your page

Qs 87. Change page colour as per your choice

Qs 88. Apply wrap text

Qs 89. Bring and move picture

Qs 90. Change theme of your document

Qs 91 Apply Group option on two or three images 

Qs 92  How to make a professional level document?

• Apply spell checker or  F7
• Insert relevant image
• Align the text
• Insert header and footer also
• Ensure the font size and type
• Change page color
• Insert border
• Insert watermark
• Insert title or heading of the document  (What)
• Insert shapes and hyperlink

Qs 93. Create macro or create shortcut key of your choice and assign an action on to it

Qs 94. Insert ruler and grid lines into your document

Qs 95. View your document in two pages
Qs 96. Apply split in a table
Qs 97. Activate navigation pane

Qs 98. Apply mail merge and make a process for the same in the form of a PDF.

Qs 99. Explore  http://www.maabharatikesapoot.mod.gov.in/

Qs 100. Insert 2 comments in your document.

Practice typing at https://www.typing.com/  or  online software

Hands on AI Tools

1. https://www.descript.com/ ==> For Text to voice conversion
2. https://www.d-id.com/==> For Image to video conversion
3. https://voice.ai/ ==> You can change the audio style
4. https://www.remove.bg/b/remove-video-backgrounds-100-automatically-with-unscreen            for removing the background of video.
5. https://podcast.adobe.com/ ==> use it to remove the ECO from the video
6. https://cleanup.pictures/ ==> to eliminate anything from the picture
7. https://runwayml.com/ ==> AI image generator
8.  https://runwayml.com/  ==> a text-to-image AI where your imagination is the only limit.
9. https://docs.midjourney.com/docs/en/image-prompts ==> create anything 
10. https://pictory.ai/ ==> text to Video creation  

Class PPT ==> PDF

Download MS Excel Chart PDF

MS-Excel Practice Exercise 

Qs 1. Why MS Excel is so popular

Qs 2. What we can do using MS-Excel

Qs 3. Define each component of this image

  

Qs 4. Create this worksheet 

Qs 5. Create Student Details sheet with below fileds 

Qs 6. Create pocket money calculator ?

Qs 7. Create a salary sheet for DPS school

Qs 8. Make your worksheet to be password protected 

Qs 9. Hide / unhide your Excel sheet

Qs 10. Use Excel funtions  a) Sum b) Product c) Month d)year e) day f) Minute g) Hour h) second

Qs 11. Write the shortcut keys that you have used in Ms-Excel 

Qs 12 Calculate the percentage of marks 

Qs 13. Create a Datasheet in Excel for HDFC bank with 25 records (assume field names as per your choice)

Qs 14. Create a worksheet for City Hospital with 25 records (assume field names as per your choice)

QS 15. Apply below functionalities

1)  Add / Remove filter from the sheet.

2) Remove all the duplicate values from your sheet. 

3) Arrange your data in ascending or  descending order.

Sample Question Paper

TOTAL TIME: 2 HOURS TOTAL MARKS: 100

(Answer all the questions; each question carries ONE mark)

Answer the following multiple choice questions (1 to 100) 1x100=100

Note: For each question, four options are given, Choose the most appropriate option.

1. In Which Generation Time sharing, Real time Network and Distributed Operating Systems were used?

(A) 1st

(B) 4th

(C) 2nd

(D) 5th

2. The Arithmetic and Logic Unit of computer respond to command coming from_

(A) Primary memory

(B) Control unit

(C) Cache memory

(D) External memory

3. Which of the following storage devices can store maximum amount of data?

(A) Floppy Disk

(B) Compact Disk

(C) Hard Disk

(D) Magneto Optic Disk

4. The saving of data and instruction to make them available for later use is a job of:

(A) Cache unit

(B) Input unit

(C) Output unit

(D) Storage unit

5. What is another name for application software?

(A) End-user software

(B) Utility software

(C) Specific software

(D) All of these

6. Operating System of a computer serves as a software interface between the user and_

(A) Memory

(B) Hardware

(C) Peripheral

(D) Screen

7. What is the shortcut key to snap app to right?

(A) Window icon + right arrow

(B) Window icon + up arrow

(C) Window icon + left arrow

(D) Window icon + down arrow

8. Which component gives you access to all of your computer setting and enable you to install

and remove program?

(A) Start menu

(B) File explorer

(C) Control panel

(D) Default programs

9. A new printer can be added by the printer and scanner option in_

(A) control panel

(B) Dynamic data exchange

(C) File manager

(D) None of the above

10. What is the shortcut key for taking screenshot of entire display and save?

(A) Window key + PrtScr

(B) Window key + L

(C) Window key + D

(D) Window key + M

11. Which option help us to send same letter to different persons

(A) Mail Merge

(B) Macros

(C) Multiple Letter

(D) Template

12. What is the Short cut key for Superscript?

(A) Ctrl+Shift+P

(B) Ctrl+Shift+D

(C) Ctrl+P

(D) Shift+P

13. Which option is selected for case sensitive matching?

(A) Match only

(B) Case match

(C) Match case

(D) Case only

14. What is the maximum zoom in of libre Writer?

(A) 500

(B) 600

(C) 550

(D) 700

15. What is the shortcut key of Ruler in libre writer?

(A) Ctrl+Shift+R

(B) CTRL+S

(C) CTRL+SHIFT+N

(D) Alt+R

16. Default text in LibreOffice Writer is

(A) Amiri

(B) Linex biolinum G

(C) Calibri

(D) Liberation Serif

17. Which of the following option is not a part of comment pop up

(A) Reply comment

(B) Delete Comment

(C) Delete All Comments

(D) Reply and delete comment

18. In Libre, writer by default Highlighter color

(A) Red

(B) Green

(C) Blue

(D) Yellow

19. Which bar is located just below the title bar

(A) Status bar

(B) Menu bar

(C) Tool bar

(D) Formatting bar

20. What is the shortcut key of LibreOffice_Help

(A) F11

(B) F12

(C) F1

(D) F7

21. What is the shortcut key of Save As option in Libre Office?

(A) CTRL+SHIFT+S

(B) CTRL+S

(C) CTRL+SHIFT+N

(D) SHIFT+S

22. Template option is available under which menu

(A) Edit

(B) Insert

(C) File

(D) View

23. Which of the following feature is not available in Export As option

(A) Export As PDF

(B) Export As EPUB

(C) Export As Image

(D) Export Directly As PDF

24. What is the File Extension for Libre office Writer?

(A) .oft

(B) .odt

(C) .oot

(D) .obd

25. What is the Default view in LibreOffice writer?

(A) Normal view

(B) Web view

(C) Slide view

(D) Print Layout view

26. Rulers option is available in which menu

(A) File

(B) Insert

(C) Table

(D) View

27. In hyperlink dialog box which option is not available

(A) Internet

(B) Mail

(C) Document

(D) File Attachment

28. By default, the page size of Libre office writer is _____

(A) A4

(B) A5

(C) Legal

(D) Letter

29. What is the default alignment in libre writer?

(A) Right

(B) Left

(C) Center

(D) Justify

30. Watermark option is available in which menu?

(A) File

(B) Tools

(C) Insert

(D) Format

31. What is the shortcut to paste special in calc?

(A)Ctrl+Shift+V

(B) Ctrl+V

(C)Ctrl+C

(D)Strl+Shift+S

32. What is the use of filter in Calc?

(A)See Only Specific Data

(B) Arrange data

(C)Copy Data

(D)Making Chart

33. Which of these is a correct formula?

(A)=SUM(J14:J16)

(B) =SUM(J14?J16)

(C) SUM(J14:J16)

(D)J14+J15+J16

34. What is the default alignment of Numeric Cell data?

(A)Left

(B) Right

(C)Center

(D)Justified

35. What is the shortcut key to open format cell option dialogue box?

(A)Ctrl+f

(B) Ctrl+D

(C)Ctrl+L

(D)Ctrl+1

36. In Libre Spreadsheet, Rows are labelled as ____?

(A)A,B,C,....

(B) 1,2,3....

(C) A1, B1, C1...

(D)1A, 1B, 1C...

37. What is shortcut key to enter current date in a cell in Libre Spreadsheet?

(A)Ctrl + ]

(B) Alt +D

(C) Ctrl + ;

(D)Shift + K

38. How do you change column width to fit the contents?

(A)Single-click the boundary to the left to the column heading

(B) Double click the boundary to the right of the column heading

(C) Press Alt and single click anywhere in the column

(D)Press CTRL and double click anywhere in the column

39. Maximum number of rows in a Libre Spreadsheet is__?

(A)1048576

(B) 16348

(C) 1084576

(D)1024598

40. The CALC __________ function counts matching records in a database using criteria and an

optional field

(A)DCOUNT

(B) DCOUNTA

(C) DSUM

(D)SUM

41. Which option is used to restrict scrolling of row and column?

(A)Pause

(B) Stop

(C) Freeze

(D)Scroll Off

42. __________uses filter criteria from specified cells?

(A)AutoFilter

(B) Advanced

(C) Standard

(D)Sorting

43. The DSUM function is a built-in function in Calc that is categorized as a _____Function?

(A)Logical

(B) Database

(C) Statistical

(D)Financial

44. Which shortcut is used for printing the sheet?

(A)CTRL+P

(B) CTRL+Shift+P

(C) Alt+P

(D)CTRL+Alt+P

45. What is the file extension of Libre Spreadsheet document?

(A).ODF

(B) .ODT

(C) .ODS

(D).OBT

46. What is the intersection of a column and a row on a worksheet called?

(A)Column

(B) Value

(C) Address

(D)Cell

47. If we want to arrange data in ascending or descending order which option should be chosen?

(A)Filter

(B) Sort

(C) List

(D)Arrange

48. One cell format can be copied to another cell by using?

(A)Format Setting

(B) Format Checking

(C)Clone Formatting

(D)Cloning

49. The short cut key Ctrl + H is used to________?

(A)Open Find dialog box

(B) Open Find & Replace dialog box

(C) Font dialog box

(D)Format dialog box

50. The cell reference for a range of cells that starts in cell C1 and goes over to column H and

down to row 10 is?

(A)C1:10H

(B) C1:H10

(C)C1:H-10

(D)C1:H:10

51. Which type of program is Libreoffice impress?

(A) Presentation

(B) Word Processing

(C) Spreadsheet

(D) Draw

52. In LibreOffice impress, by default the presentation is saved as

(A) Show1

(B) Presentation1

(C) Untitled1

(D) Slide1

53. In LibreOffice impress which view contains only Text?

(A) Normal view

(B) Outline view

(C) Notes view

(D) Slide shorter view

54. In Libre Office Impress the shortcut key to insert a text box is

(A) F5

(B) F8

(C) F3

(D) F2

55. Which of the following shortcut key can be used to close the libre office window-

(A) Ctrl+N

(B) Ctrl+M

(C) Ctrl+W

(D) Ctrl+P

56. Which of the following menu is used to change the layout of a slide?

(A) Format

(B) Slide Show

(C) Slide

(D) Tools

57. What is the shortcut key to insert a hyperlink in the slide?

(A) Ctrl + H

(B) Ctrl + K

(C) Ctrl + A

(D) Ctrl + M

58. In Libre Office Impress slide sorter is found in which menu?

(A) Insert

(B) Format

(C) Slide show

(D) View

59. What is the minimum Zoom size in Libre Office impress?

(A) 5%

(B) 10%

(C) 20%

(D) 15%

60. What is default orientation of slide in Libre Office Impress?

(A) Landscape

(B) Portrait

(C) Horizontal

(D) Vertical

61. Which Objects can be added into the presentation?

(A) Picture, Not Movie

(B) Both Movie and Picture

(C) Movie but not Picture

(D) Only JPG images

62. Which of the following is the shortcut key for checking the spelling in PowerPoint?

(A) F5

(B) F7

(C) F6

(D) F3

63. Which shortcut key is used to add a new slide in Libre office Impress?

(A) Ctrl + N

(B) Ctrl + M

(C) Ctrl + S

(D) Ctrl + T

64. Which shortcut key is used to jump at the first slide?

(A) Home

(B) Pageup

(C) Page down

(D) End

65. What is the slide transition in LibreOffice Impress?

(A) Letter

(B) A special effect used to show a slideshow

(C) Overhead

(D) A type of slide

66. Which Shortcut key is used to start Slide Show from first slide?

(A) F3

(B) F4

(C) F5

(D) F7

67. LibreOffice Impress file is saved in which of the following extension.

(A) .ods

(B) .odp

(C) .ppt

(D) .odt

68. Which of the following is a slide that is used as a starting point for other slides?

(A) First Slide

(B) Master Slide

(C) Minor Slide

(D) Last Slide

69. Which of the following shortcut key is used to stop the slide show?

(A) Esc key

(B) Ctrl + O

(C) Ctrl + N

(D) Ctrl + K

70. Which of the following shortcut is used to print impress presentation?

(A) Ctrl+T

(B) Ctrl+E

(C) Ctrl+S

(D)Ctrl+P

71. ARPANET Stands for

(A) Advanced Research Project Agency Network

(B) Advanced Research Programmed Auto Network

(C) Advanced Research Project Automatic Network

(D) Advanced Research Project Authorized Network

72. Which of the following icon is used to add an attachment to an email?

(A) Stationary Icon

(B) Paper Clip icon

(C) GIF Icon

(D) Emoji Icon

73. _____ option helps you to save an unfinished email without sending it.

(A) Trash

(B) Inbox

(C) Sent Items

(D) Save as Draft

74. Which network topology requires a central controller or hub?

(A) Star

(B) Mesh

(C) Ring

(D) Bus

75. The dedicated connection that establishes a permanent switched circuit that is always ready to

carry network traffic is

(A) Wireless Local Loop

(B) TDM

(C) Leased Line

(D) Digital Subscriber Line

76. How many bits are in Version 6 of IP address?

(A) 64 Bits

(B) 32 Bits

(C) 128 Bits

(D) 256 Bits

77. Which is the transmission media that can carry huge data to large distances with less delay or

latency?

(A) Wireless or RF or Microwave Frequency

(B) Coaxial Cables

(C) Optical Fiber Cables

(D) Twisted Pair Cables

78. How many bit is the first octet of the ‘Class C’ IP address?

(A) 4 Bits

(B) 8 Bits

(C) 32 Bits

(D) 128 Bits

79. MAC Address is of how many bits?

(A) 48 Bits

(B) 32 Bits

(C) 64 Bits

(D) 8 Bits

80. An internet service that allows the user to move a file.

(A) SMTP

(B) DHCP

(C) FTP

(D) IP Address

81. Which social network is considered the most popular for business to business marketing?

(A) Facebook

(B) Orkut

(C) Instagram

(D) LinkedIn

82. Which term is mostly used by Twitter users.

(A) Posts

(B) Tweets

(C) Twinks

(D) Tweats

83. Web Pages are uniquely identified by using

(A) IP Address

(B) Domain

(C) URL

(D) File Name

84. An Email Message that has failed to reach its destination is called

(A) Junk Email

(B) Trash

(C) Spam

(D) Bounced Mail

85. E-commerce involves buying and selling of:

(A) International Goods

(B) Electronic Goods

(C) Computer Products

(D) Product and Services over internet

86. Which description is appropriate among the following for ‘E-Governance’?

(A) To engage enable and empower citizens

(B) To Provide fair and unbiased to citizens

(C) To provide technology driven governance

(D) to ensure people’s faith in E-Commerce

87. What services are available on the UMANG?

(A) EPFO/Pension/CBSE

(B) Ticket Booking

(C) PNR Status

(D) Maps

88. Mail Access starts with the client when user needs to download Email from the

(A) Mail Host

(B) Mail Server

(C) Content Mixing System

(D) Email Server

89. To join the internet, the computer has to be connected to a ______.

(A) Internet architecture board

(B) Internet society

(C) Internet service provider

(D) Different computer

90. An endpoint of an inter-process communication flow across a computer network is

(A) Socket

(B) Pipe

(C) Port

(D) Machine

91. What does BHIM stand for?

(A)Bharat Interface for Money

(B) Bharat Interface to Money

(C)Bharat Internet for Money

(D) Bharat Interaction for Money

92. Startup is started for whom?

(A)Doctors

(B) Entrepreneurs

(C) Students

(D)Youngsters

93. Who was the first to use the term Big Data?

(A)Steve Jobs

(B) Bill Gates

(C)John Mashey 1990

(D)John Bredi

94. Who invented the term Internet of Things?

(A)Bill Gates

(B) Kevin Ashton

(C) Steve Jobs

(D)McDonald

95. What is the meaning of UPI?

(A)Unified Payment Interface

(B) Unfind Pay Interface

(C) Immediate Payment Interface

(D)None of these

96. What is the name of the first recognized IoT device?

(A)Smart Watch

(B) ATM

(C)Radio

(D)Video Game

97. Artificial Intelligence is about_____.

(A)Playing a game on Computer.

(B) Making a machine Intelligent.

(C) Programming on Machine with your Own Intelligence.

(D)Putting your intelligence in Machine.

98. Who is known as the -Father of AI"?

(A)Fisher Ada

(B) Alan Turing

(C)John McCarthy

(D)Allen Newell

99. Which of the following is defined as an attempt to steal, spy, damage or destroy computer

systems, networks, or their associated information?

(A)Cyber attack

(B) Computer security

(C)Cryptography

(D)Digital hacking

100.Which of the following is not an objective of network security?

(A)Confidentiality

(B) Integrity

(C) Availability

(D)Hacking

PRACTICE Exercise

Practical Assignments

Qs 1.i. Do the following settings

a. Display pointer trails

b. Change the normal pointer of a mouse to another pointer

c. Set the date advanced by 2 months

d. Reset the system date & time

e. Set the system time late by 2 hrs: 40 minutes.

f. Set the Yesterday date and time in your Operating System.

ii. Do the followings

a. Interchange the functions of left and right mouse buttons.

b. Change the wallpaper of your computer and set it to a paint brush file made by you.

c. Change the screen saver of your computer and change it to ‘marquee’

d. Set your name as the text and wait time should be 2 minutes.

iii. Create the following folders under the specified locations using windows.

a. NIELIT on desktop

b. R1 on the c: i.e. root

c. D2 on desktop

d. R2 on the c:

e. Create a folder NIELIT-1 under the D1 folder

f. Create a folder D2-1 under the D2 folder

g. Copy this D2-1 folder and paste it under R1 folder.

h. Delete the folder D2-1 from R1 folder

i. Create the folder R1-1 under R1 folder

j. Copy R1-1 folder under the R2 folder

k. Rename folder R1-1 under R2 folder as ‘subfolder of R2’

l. From the c: copy all files to folder R2

m. Delete all the files from the folder R2

n. Recover all the deleted files

iv. Create a document in Word on a topic of your choice. Format the document with various

fonts (minimum 10, maximum 12) and margins (minimum 1.5, maximum 3). The

document should include

a. A bulleted or numbered list

b. A table containing name, address, basic pay, department as column heading

c. A picture of lion using clip art gallery

d. An example of word art

e. A header with student name & date

f. A footer with pagination

v. Create a document with the text given below and save it as First

A Read only Memory is a memory unit that performs the read operation only, it does not

have a write capability. This implies that binary information stored in a ROM is made

permanent during the hardware production of the unit and cannot be altered by writing

different words into it. Whereas a RAM is a general-purpose device whose contents can be

altered during the computational process, a ROM is restricted to reading words that are

permanently stored within the unit. The binary information to be stored specified by the

designer, is then embedded in the unit to form the required interconnection pattern.

Do the following

a. Count the occurrences of the word “ROM” in the above document.

b. Replace ROM with Read Only Memory in the entire document

c. Underline the text Read Only Memory

d. Make an auto correct entry for ROM and it should be replaced by Read Only

e. Memory

vi. Use the file First to perform the following operations

a. Make the first line of document bold.

b. Make the second line italic.

c. Underline the third line.

d. Align the fourth line to center.

e. Make the font color of first line as red.

f. Change the font style of fifth line to Arial.

g. Change the second line to 18 points.

h. Insert the date & time at the start of document.

vii. Use the document saved earlier and perform the page setting as follows.

a. Top Margin 1.3”

b. Bottom margin 1.4”

c. Left margin 1.30”

d. Right margin 1.30”

e. Gutter margin 1.2”

f. Header 0.7”

g. Footer 0.7”

h. Paper size executive

i. Orientation landscape

viii. Create a table in word as shown below with following fields.

Roll No Name Marks Total

Physics Chemistry Marks

1. Ritu 78 88 166

2. Amit 90 92 182

3. Rakesh 67 78 145

4. Rohit 50 50 100

5. Niti 60 65 125

6. Garima 89 67 156

ix. Do the followings.

a. In the total marks column, entries should be calculated using formulas and it is the

sum of marks in physics and marks in chemistry.

b. Insert a new row at the end of the table and also find grand total using formula.

c. Sort the table based on total marks

d. The date and heading should be center aligned

e. Heading should be in bold and underlined

x. Below is given a letter and some addresses. This letter is to be sent to all these addresses.

User mail merge

Addresses are:

1) Amit, H No 424 sector 8D, Lajpat Nagar, New Delhi

2) Rohit, H No 444, Sector 125C, Chandigarh

3) Jyoti,H NO 550, Sector 16A, Gomti Nagar,Lucknow

The Letter is

To

<<Name>>

<<Address>>

Dear <<Name>>

You are advised to appear for an interview on the <<Date>>at 9:00 A.M with your

original documents.

Yours Sincerely

ABC Limited,

Industrial Phase –7, New Delhi.

xi. Make a template for the bio-data with the following format

Bio-Data

Name :

Father’s Name :

Date of Birth :

Age :

Address :

Educational Qualification

Sr No Qualification Board Percentage

Work Experience:

xii. Type the following data using spreadsheet tool and save the file as First

A B C D E

513

501

504

513

511

516

532

504

432

501

510

517

479

494

498

Do the following

(a) Highlight column A and copy it to column C

(b) Sort the data in column C in ascending order

(c) What is the lowest number in the list (use a function)

(d) Copy the data in column A to column E and sort it in descending order

(e) What is the highest number in the list (use a function)

(f) How many numbers in this list are bigger than 500 (use a database function)

(g) How many numbers in column A are between 520 and 540 inclusive

(use a database function),

xiii. Type the following data in spreadsheet and save it as Second.

A B C D

370 70.5

61166 53.5

684 65

449 76.5

643 70

1551 71

616 60.5

403 51.5

Do the following

(a) Complete column C for finding product x * y

(b) Find sum of x column at the end of data

(c) Find sum of y column at the end of data

(d) Find sum of x * y column at the end of data

(e) Find sum of x^2

(f) Find sum of y^2

xiv. Enter the following data using spreadsheet tool and save it in Grade

Name Marks1 Marks2 Marks3 Total Percentage

Amit 80 70 80

Renu 70 60 90

Rajeev 87 89 65

Munish 76 67 44

Sanjeev 98 76 78

Anita 65 76 87

Do the following.

(a) Compute the total marks and percentage of each student by entering appropriate

formula.

(b) Compute the grades based on following criteria

If percentage >= 90 then grade = A

If percentage >= 80 and <90 then grade = B

If percentage >= 70 and <80 then grade = C

If percentage >= 60 and <70 then grade = D

If percentage < 60 then grade = E

(c) Draw a border around the worksheet

(d) Change the font size of heading to 14 points and underline it and hide column c

(e) Increase the width of column A to 15 characters

(f) Right Align the values in column B, C, F

xv. A university maintains a year wise result for four courses and then generates an average

report as given below.

Sr. No. Year Course1 Course2 Course3 Course4 Average

1 2013 650 675 666 456

2 2014 600 700 656 765

3 2015 677 655 765 400

4 2017 400 400 400 400

5 2018 560 760 467 737

Total

(a) Complete the report to calculate the course wise average in row 6

(b) Provide formula to calculate year wise average in column G

(c) Generate a column chart to compare data.

xvi. A person wants to start a business and he has four schemes to invest money according to

profit and years. Find out which scheme is the most profitable using scenario manager.

Investment Amount Percentage for profit No. of years

20000 10 6

40000 20 5

14000 30 4

xvii. A company records the details of total sales (in Rs.) Item and month wise in the following

format

Sector Jan Feb March April

PCs 12000 17000 15000 20000

Laptops 14000 18000 15000 16000

Printers 15000 18000 13000 12000

Scanners 16000 15000 14000 23000

(a) Enter the data using spreadsheet and save it as sector

(b) Using appropriate formula, calculate total sale for each sector

(c) Create a 3-D column chart to show sector wise data for all four months

(d) Create a 3-D pie chart to show sales in Jan in all sectors

xviii. Type the following data and save it in employee file using spreadsheet tool.

Name Department Designation Salary Address

Anju TRG MD 100000 CHD

Amit TRG AD 200000 MOHALI

Renu BILL MD 300000 CHD

Anita BILL AD 20000 MOHALI

Shivani S/W MD 10000 CHD

Do the following

a) Count the total no. of employees department wise

b) List the name of employees whose designation is ‘MD’

c) List the name and department of employees whose address is Chandigarh

d) List the name of employees whose salary is greater than 5000

e) List the Address of employees whose department is ‘TRG’

xix. Set up a new presentation of three slides.

1. On the master slide:

a) Apply a theme of your choice to the master slide.

b) Include an automated page number in the bottom left of the footer

c) Place a clipart image of a pen or pencil as a logo in the top right corner.

2. Add the following text in slide 1

Heading: Hothouse Design (Red, 25 point, Arial font, Left Aligned)

3. On the second slide type the following text where font="Arial" size="20"

Earlier in the year we started to analyze the sales profile for the stationery business stream

within Hothouse. The areas of initial investigation were selected as the management of

our sales team, our customer base, website effectiveness, and an analysis of our most

successful product lines.

4. On the third slide where font="Arial” size="20"

Possible timings for these bonuses include:

• Weekly

• Monthly

• Quarterly

• Annually.

xx. Set up a new presentation consisting of 3 slides

1. On the first slide

a) Type Telephone Analysis for the title, using any word Art option.

b) Insert any appropriate image below the title and apply an Animation effect to the

image.

c) Insert a Sound from the Clip Organizer.

2. On the second slide:

a) create a pie chart using the following data:

Call type Minutes

International 1640

Peak Rate 7842

Cheap Rate 1543

Internal 16805

b) Insert the chart title “Telephone Analysis”.

3. On the third slide:

Enter the following text: (font style="Times new roman", font size= "24")

As you can see that our vast majority of calls are internal. These figures are the average

values per day for all departments, using a monitoring period of 2 weeks.

4. Use the same transitional effect between each slide.

5. Play a slide show.

xxi. Set up a new presentation consisting of 4 slides

1. On the first slide

d) Include an automated slide number left aligned.

e) Enter the heading New Website.

f) Enter the sub heading Proposed Web Pages.

g) Insert any appropriate image below the sub heading and apply an Animation effect

to the image.

h) Create the following hyperlink http://www.google.com on the image

i) Insert a Sound from the Clip Organizer.

2. On the second slide:

c) create a pie chart using the following data:

Type of Trip 2008 Dives

Go deep 2512

Wreck Week 12680

Shark Experience 940

Cave Dives 353

3. On the third slide:

Enter the following text: (font style=Times New Roman, font size= 24)

During the development of this new website, we have realized that the proposed design

brief may need to be amended.

4. On the fourth slide:

Insert a Movie from a File on Your Computer

5. Use a picture as background in all your slides.

6. Use the same transitional effect between each slide.

7. Play a slide show.

xxii. Write a paragraph on each of followings.

a) List five popular Browser Names.

b) What are Cookies, and Why Should I Enable Them?

c) How to delete History in Web Browser?

xxiii. Write a paragraph on each of followings.

a) What is difference between IPv4 and IPv6 Address?

b) How to set IP IPv4 address in your computer?

c) What is gateway?

xxiv. Write a paragraph on each of followings.

a) What is MPIN?

b) What are the requirements for using UPI App?

c) Explain the Work of BHIM App. How to install in Mobile.

d) What is the difference between RTGS and IMPS Service?

xxv. Write a paragraph on each of followings.

a) What is IOT; List the name of some IOT related device which we use in our daily

life.

b) What is Big Data Analytics? Where it is used.

c) What is Robotics; 

Thanks for your patience!!..