Instructions for Assignments:
Prepare your assignment on only A4 Sheet Paper.
Write only one side on the A4 Sheet Page.
Use Only Blue and Black Pen.
Draw blocks diagram/picture/image/graph (if possible) with pencil.
Index page and Front Cover page is necessary.
Submit each paper individual with in mention date in your respective institute
COPA/ADCA/DCA/PDCA (NCVT-ITI)
(Assignment-1)
Q1. What is Computer? Define its characteristics & limitation.
Q2. Define each generation of Computer?
Q3. What is Operating System? Define its feature and type of OS.
Q4. What is MS-Office ? Define Mail Merge with leave application to any organization.
Q5. What is MS-Excel? Prepare a result sheet with 15 students & find Total Marks, Percentage, &
Division. Also calculate the Grade of Each Students with Math Subject (>=80”A”, <80
&>=70”B”, <70 &>=60 ”C” , <60 &>=50”D” otherwise FAIL).
Q6. What is DOS? Define 5 Internal & 5 External Commands in DOS.
Q7. Define following:
a) Computer Language
b) Assembler, Translator, & Interpreter
c) Cache Memory
d) Internet Banking
e) Netiquette
Q8. Define Following:
(a) Describe the AutoCorrect Feature with example.
(b) What is the difference between primary memory and secondary memory? Briefly explain
various types of primary and secondary storage devices.
(c) Write a short note on slide Handout Master.
Q9. Define Following:
(a) Explain in detail the Bookmark and Hyperlinks feature.
(b) What are the advantages of presentation package? Give example of one such package. How
can we create a transition and animation in a presentation?
Q10. What is Printer? How many type of printer, define each in details.
Q.11 Explain briefly “Intellectual Property Rights”. ?
Q.12 What is a clipboard? In Word, what are the shortcut menu commands and how are they invoked
for using clipboard? Draw a block diagram depicting the four functional units of a computer
system.
Q.13 Give the utility of presentation package. Name one such package. How can we create a hyperlink
and animation in a presentation?
Q.14 (a) Briefly explain the different types of instant messaging services available.
(b)Define following function using MS-Excel with example---
1) round() & trunc() 2) sln() & pmt() 3) ceiling() & floor() 4) log() & log10()
Q.15 What is internet? Define each type of Network.
Q. 16 What do you understand by Network Topology?
Q. 17 What is Transmission medium? Define each type of transmission medium.
Q. 18 What is Network Device? Define each type of network device.
Q.19 Define OSI Reference model with each layer?
Q. 20 Define TCP/IP Reference model with each layer.
Q. 21. Differentiate IPV4 & IPV6?
Q.22 What is e-Governance Services? Define all e-Governance Initiatives in India.
Q.23 What is e-Commerce? Define all type of e-Commerce.
(Submit before 20-12-2024)
