Programme Code : BCA
Course Code : bcsl-013
| More

Year : 2013 Views: 1252 Submitted By : madhu On 18th March, 2013

Do you have solution for this Question. If yes    I aslo want solution.

Q.


Course Code : BCSL-013

Course Title : Computer Basics and PC Software Lab

Assignment Number : BCA (I)-013/Assignment/2012

Maximum Marks : 100

Last Date of Submission : 15th October, 2012/15th April, 2013

Note: This assignment has ten questions of 80 marks. Answer all the questions. Rest 20 marks are for viva voce. You may use illustrations and diagrams, printouts of the solutions to enhance explanations. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation.

Section 1: PowerPoint Assignment

Question 1:

Make a presentation for ‘favorite sports person’ (e.g. Sachin Tendulkar)) which includes following details:

(a) Introduction

(b) Family background

(c) Achievements

(d) Current Status

(e) His/Her inspiration

(f) Pictures

(g) Videos

(10 Marks)

Question 2:

Give presentation on ‘Project’ developed by you to your class. (e.g.) Project on Library System.

(10 Marks)

Section II: Outlook

Question 3:

Imagine that you are a Patient. Initiative a meeting between you and your Doctor to discuss the current health status (operation)

(a) How will your doctor respond to you to accept or reject the meeting (operation)?

(b) Also look the room and reserve other resources required for the meeting/operation.

(c) Write all the options available in outlook to fulfill the scenario?

(5 Marks)

Question 4:

In the above scenario, assuming that one of the doctor from the panel is on leave on that particular day of the meeting/operation and wants to reschedule the meeting/operation. Is it possible to do this? If yes, how will this be done?

Write all the options available in the outlook to fulfill the scenario?

(5 Marks)

9

Section III: Browsing and Discussion Forum

Question 5:

(a) Open Internet Explore (IE) add www.iplt20.com to your favorites under two different folders. Now open Mozila Firefox and import your favorities from IE.

(b) Set firefox to always show bookmark bar. Note down the steps you followed.

(c) Change the default location (Downloads). Where the browser downloads all the down loadable files. Set the browser to always ask where to save each file before downloading.

(5 Marks)

Question 6:

Go to www.google.com. Select ‘Advanced Search’ option.

(a) Search for ‘soccer/football’. After initial search include ‘Nation’ (e.g. Brazil) of ‘player’

(like. Messi) to the search criteria.

(b) Search for ‘Top Scorrer in Cricket’ in T20, ODI’s and in test matches. Search for country (playing nation) like India.

(5 Marks)

Question 7:

Collaborate online (in a group) on Google docs to create a presentation on ‘Effect of IT on environment’. All the group should work on the presentation simultaneously from their respective machines. Use speaker notes for any online discussion. (10 Marks)

Section IV: Word Processor

Question 8:

Create a word document and type the text given below. The headings, footer, formatting and layout should be as given in the following sample:

TITTLE

Footer

(Page nos.)

(10 Marks)

Image

Table

10

Question 9:

Assume you are creating invitation for yours Parent’s Silver Jubilee Anniversary. You need to send out invitations to your relatives with date of celebration, venue, their name on invitation.

Create a single invitation and use mail merge to customize it with relative name on it.

(5 Marks)

Section V: Spread Sheet

Question 10:

(15 Marks)

Create a new workbook with worksheets named as

(a) Car details (b) Car sales (monthly)

(c) Monthly Report

The following are the details of each workbook.

(i) Create table in ‘Car details” worksheet with following information: Car Name Engine Capacity Insurance Fuel (Diesel, CNG, LPG, Petrol) Model Manufacturing Name Price Tax

e.g. Swift, Maruti Suzuki, 1248, 6.50, VDi, Insurance, Tax, Diesel.

(ii) Create table in ‘Carsales’ worksheet with following information: Date Car Name Manufacturing name Owner name Owner Address Model Mode Installment Downpayment

(iii) Create ‘Monthly report’. You are required to use ‘carsales’ for the following operations to be performed: Draw the pie chart for same.

(iv) Show ‘Total Car Sales’ model wise.

(v) Show car details where price of car is between 3, 00, 000 and 4, 00, 000


No Answer Found