BCSL013 Solved Assignment with solved question paper

BCSL-013

1.         Make a power point presentation on infrastructure support and activities at your program centre (minimum 10 slides) which should include the following details:

            Responsibilities of a program centre

·         Location of the program centre (insert a map and a picture of your study centre)

·         Library support( Number of books, journals, e-books , borrowing facility)

·         Lab facility( internet connectivity, numbers of computers, its configurations, printers)

·         Activities at the centre: counseling, practical classes( insert pictures)

·         Create animation on the picture of the study centre.

·         All the slides should follow the common design : same title style, color background, page numbers

·         All slides should have slide notes

·         Write speaker notes for each slide

Section-II (Outlook)

2.        

·         Make a contact list of 10 persons. Just enter name and email address.

·         Create a new appointment to your calendar

·         Meeting between 10 AM- 11AM in the conference room of Hotel XYZ

·         Invite the contact from the contact list

Section-III (Spreadsheet)

3. (a)   Sales Analysis The following is the sales report (in thousand dollar) of different regions in the first quarter and the second quarter Region First Second Quarter

Region	First Quarter	Second Quarter
East North East South North South East	20 10 60 80 40	30 15 70 72 80

            Create a sales chart of the above report. (10 marks)

(b)       Prepare a worksheet for the following problem: (20 marks)

You are looking to buy a car. You are considering two options: to buy a second hand car and keep it for ten years or to buy a new car and keep it for four years. The depreciation per year is simply the difference between the purchase price and the resale price divided by the numbers of years. The total running cost per year is the sum of service/repair cost, the fuel cost per year (miles per year multiplied by fuel cost per mile) , the tax and the insurance. The total cost per year is the sum of the depreciation and the running costs. You are supposed to calculate average depreciation per year, fuel cost per year, total running cost per year and total cost per year for both the options. Type in labels: car purchase option, initial cost, resale, years ,average depreciation per year, running cost, services/repairs per year, miles per year, fuel cost per mile, fuel cost per year, tax, insurance, total running cost and total cost per year. Prepare the worksheet having all the details as given below:

	A	B	C
1.	Car Purchase option
2.		Option 1	Option 2
3.	Initial cost	€ 10,000	€ 17,000
4.	Resale	€ 1,000	€ 12,000
5.	Years	10	4
6.	Average depreciation per year
7.
8.	Running cost
9.	Services / repairs per year	€ 350	€ 250
10.
11.	Miles per year	5000	5000
12.	Fuel cost per mile	€ 0.20	€ 0.17
13.	Fuel cost per year
14.	Tax	€ 450	€ 450
15.	Insurance	€ 800	€ 800
16.	Total running cost
17.	Total cost per year

Section-IV (Word Processor)

4.(a)    Design a flyer for birthday party using different styles, fonts and effects. (10 marks)

(b)       You have been asked by the management of the company to organize a get-together party for the newly recruited staff in the company. Create a standard cover letter to inform all the new member s using mail-merge facility. You need to create a database of all the members whom you wish to inform. Watermark the letter as official. (10marks)

Section-V (Browsing and Discussion Forum)

5.         Locate, download and analyze information online on advancement in smart phone technology through advance search option of Google and prepare a 3-4 page report for submission. You are required to do the following in order to prepare the report.

·         Review at least 10 articles to find out the advanced features.

·         Search for keyword advanced mobile technology in smart phone technology.

·         Review the result of search and consider the similarities and differences between different articles.

·         While preparing the report, also capture some screens of smart phones and include in the report.

****************************************************************

Note: Answer with Dotcom Books

www.dotcombooks4u.com

(Last 5 year solved question paper with Assignment solutions)

9825183881

 ***************************************************************