B.Sc. DEGREE EXAMINATION, NOVEMBER 2017
Fashion Design
COMPUTER BASICS PRACTICAL
(Upto 2015 Batch)
Time 3 Hours Maximum 60 Marks
The candidate should answer and do practical for each
question and b).
The Examiner should cut and give ONE question to each
candidate from lot system. Each question carry equal marks.
1. How will you classify the computers? Explain.
Create a worksheet consists of the fields Employee
Name, Basic Pay Dearness Allowance
House Rent Allowance Medical Allowance
Provident Fund Insurance and
Income Tax
Monthly Salary is calculated as follows
Dearness Allowance 60% of BP
House Rent Allowance 10 of BP
Medical Allowance of BP
Provident Fund 12 of BP
LIC of BP.
Gross Salary BP DA HRA MA
Deductions PF LIC
Net salary Gross Salary Deductions
IT 10% of Annual Income if AI
3,00,000
20% of Annual Income if 3,00,000
AI 5,00,000
30% of Annul Income if AI> 5,00,000.
Enter 10 records and compute Income Tax for
all the employees.
Draw bar chart for Employee Name and
Income tax fields.
Sub. Code
34
CP-8046
2
sp3
2. What are the components of a computer? Explain
their functions with neat diagram.
Design a farewell day invitation in an institution
using MS-WORD and save in farewel. DOC. It is
required to send this invitation to different
addresses using Mail Merge Concept.
3. What are the input devices used in Computer based
Data processing systems? Explain.
Prepare a powerpoint slide show with a text and
picture expressing the courses offered in your
institution with animation effects, Slide number
and proper headings. Also set timings to view it.
4. Explain various types of computer networks and
their advantages.
Create a MS-EXCEL worksheet with the following
data for 10 students.
Regno, Name, Five subjects Marks, total and
average Do the following
Find the total and average of each student.
Find the highest and lowest scores in each
subject.
Draw Bar chart for average mark.
Declare the result as "PASS" if he secure
greater than or equal to 50 in each subject
otherwise "FAIL".
CP-8046
3
sp3
5. What is network topology? Explain various network
topologies and their advantages and disadvantages.
Prepare five slides about the fashion design course
and its scope with the following features and
present.
Slide Number, Current date and time
Headings should be in bold and centered
Sound effects should also be generated.
6. What are the input devices used in Computer based
Data processing systems? Explain.
Prepare a powerpoint slide show with a text and
picture expressing the courses offered in your
institution with animation effects, Slide number
and proper headings. Also set timings to view it.
7. What are the output devices? Explain.
Prepare a document showing the profile of a
company in MS-WORD with a heading. Do the
following
The heading should be centered, bold faced,
underlined and green coloured.
Set margins for left, right, top bottom as 1"
and first line indent as 1.5".
The contents should be in 1.5 line spaces.
Insert the Heading in every page and footer
consists of page number and address of the
company.
Take the print out with page number, header
and footer.
CP-8046
4
sp3
8. Explain different network communication media
available.
Create a worksheet in MS-EXCEL, in the following
format.
STUDENT ATTENDANCE REPORT
Course Name B.Sc. Fashion Design Year First
Total Number of working days 85
RegNo. Name No. of days
Present
No. of days
Absent
Percentage of
Attendance


Type 10 set of data in the worksheet.
Use suitable formula to calculate percentage of
attendance.
Sort worksheet table namewise in alphabetical
order.
Draw Line and Bar charts for percentage
column.
Convert the attendance report into MS-WORD
using OLE concept.
9. What is a computer network? Describe its
architectures with example.
Prepare an interview letter document for the
applicants to attend the interview on the given date
at the specified venue. Create an address document
to store the addresses and using mail merge facility
send the letters to all the applicants.
10. Describe the structure a computer with neat block
diagram.
Prepare a document with minimum of 3 paragraphs
in a page with various page and text formatting
features in MS-Word.
———————