DATA ENTRY OPERATIONS
(336)
TUTOR MARKED ASSIGNMENT
1- Answer any one of the following questions in about 40 to 60 words.
a- Check your computer and write down the details using the table below :
Parts of a computer system Description of configuration
1. CPU(make and Model)
2. Processor Speed
3. RAM (GB)
4. Storage capacity of Hard disk drive (GB)
(See Lesson- 1)
b- Rita is a group coordinator, she has written comments about each group member in a file
created in MS Word. She wants to protect the document from unauthorized access. She
wants to use password to protect the file. Write the steps which Rita should follow to set the
password for the document. (See Lesson- 3)
2- Answer any one of the following questions in about 40 to 60 words.
a- Anu has written one paragraph about the meeting held in her center, but she knew that her
senior does not have much time to read through it. So she decided to format the paragraph
using bulleted and numbered lists. Write the steps for the above text formatting.
(See Lesson- 4)
b- Swati is planning a party, she wants to use mail merge feature for writing invitation letter to her
8 friends. Write the types of documents mail merge requires. (See Lesson- 5)
3- Answer any one out of the following questions in about 40 to 60 words.
a- Attempt any 1 ( 2marks each)
For the given link "http://www.iitb.ac.in/courses/syllabus/url.htu"
(i) What is the Domain name
(ii) Write the name of the host computer
(iii) Write the type of organization.
(iv) Why http is used in URL (See Lesson- 10)
b- Label the parts of an excel window given below:
4- Answer any one of out of the following questions in about 100 to 150 words.
a- Aditi wants to write an article on MS Word. Write down the steps for the following tasks:
i-She wants to use new words to make it more impressive. Help her in replacing the
words with the suitable synonym.
ii-She found Red and Green wavy lines under some of the words in a text. What is this
problem and how will it be resolved? (See Lesson- 4)
b- One cultural program is planned on 15 August 2014 in Ayushi´s apartment. Ayushi is an incharge
for sending personalized invitation to the families of the apartment.
Create a data source with the following information.
(i) Name of the Person, (ii) Address1
(iii) Address2 (iv) Phone number
(v) Venue (vi) Time
(vii) Date
5- Answer any one out of the following questions in about 100 to 150 words.
a- On the occasion of Independence Day celebrations the RWA of a locality organized some
events. On this organization Rs. 2000 were spent on Talent Rewards Program, Rs. 2500 on
social work awards for children, Rs. 3000 on cultural programs, Rs. 1500 on gifts for sweepers
and watchmen of the society, and Rs. 2800 on refreshments.
Enter this information in an Excel sheet and insert an appropriate chart to represent this data.
(See Lesson- 6, 8)
b- Sumedha created a PowerPoint presentation on how citizens can mend their behavior for
betterment of the society. She included the concepts like using dustbins and not littering the
roads, obeying traffic signals, not indulging into road rage etc. All these slides contain images
and text. Now she wants to make some changes in the presentation. You have to help her by
writing the steps to do the following:
(i) Insert videos in certain slides.
(ii) Set timings for slides so that slide show continues automatically.
(iii) Apply a theme to the presentation.
(iv) Print the slides ( 4 slides per page). (See Lesson- 9)
6- Prepare any one project out of the given below:
a- You are required to create similar worksheet with charts for some other company.
(See Lesson- 7, 8)
Quality Computer Accessories
S.
No.
Description Cost
Price
Selling
Price
Profit
%
Qty
Sold
Sale
Amount
Profit
1 CD 5 8 60.00 12 96 36
2 DVD 10 15 50.00 20 300 100
3 Pen Drive 300 330 10.00 5 1650 150
4 Mouse 120 140 16.67 8 1120 160
5 Keyboard 180 210 16.67 12 2520 360
Total 5686 806
b- Gather information about NIOS from its website and prepare a document of at least 4 pages
on NIOS. The document must contain the following information:
• What is NIOS
• Whats does NIOS do
• What is OBE programme
You should also download at least 4 images (NIOS Title + NIOS
Logo + 2 more images) from NIOS website and use these images appropriately in your
document.
(See Lesson- 10)