Computer LAB Sample Question Paper for Barathiar University MBA

 Hi Readers, you might have stumbled on this page after searching for Computer Lab exam question papers. here are some  question papers i prepared4 years ago ,Cheers.

Ms-Word

Mail merge the following document with the data file given below.

XYZ Industries

To                                                                                                                    10-03-2012

 

<Name>

<Address>

 

Dear <Candidate Name>,

 

This is to inform you that an Interview has been Scheduled for the post of <position> on  <Date>. For further clarifications contact the undersigned person.

 

Thaning You,

 

Yours faithfully,

 

R. Anand

(Manager- HR)

Data File

Assistant Manager                           Sales officer                         Accounts Assistant

27-04-2016                                           26-04-2016                           28-04-2016

 

Sreedar.K                                             Madhavan.K                       Kripa Anand

34, D.B. Road                                      “Mangal Nivas”                75,Rose Villa Avenue,

Racecourse                                          72/3-A, G.B.Road             Adayar,

Coimbatore                                         Palakkad                              Chennai.

 

Krishna.M                                           Aarthi.L                                Mathew.A

32,Sundaram Layout                       Bishop college rd.,            543,Nehru street,

Trichy Road                                        4th Cross main,                 Ramnagar

Coimbatore-18                                   Trichy -8                              Coimbatore -9   

 

MS EXCEL

 

Create a payroll for a small organization of 15 members using the following data, DA= 25% of basic, HRA = 15% of basic, PF= 10% of basic. Find gross and net salary. And create individual pay-slips in next worksheet.

 

 

Perform all the Tasks

Ms-Word

Mail merge the following document with the data file given below.

ABC UNIVERSITY

To                                                                                                                    10-03-2012

 

<Name>

<Address>

 

Dear <Student Name>,

 

This is to inform you that your <Course> practical exam has been postponed  to  <Date>. For further clarifications contact the undersigned person.

Thaning You,

 

Yours faithfully,

R.K. Dhawan

(Controller of Examination)

Data File

MBA                                                      MCA                                      MSc.

27-04-2016                                           26-04-2016                           28-04-2016

 

Sreedar.K                                             Madhavan.K                       Kripa Anand

34, D.B. Road                                      “Mangal Nivas”                75,Rose Villa Avenue,

Racecourse                                          72/3-A, G.B.Road             Adayar,

Coimbatore                                         Palakkad                              Chennai.

 

Krishna.M                                           Aarthi.L                                Mathew.A

32,Sundaram Layout                       Bishop college rd.,            543,Nehru street,

Trichy Road                                        4th Cross main,                 Ramnagar

Coimbatore-18                                   Trichy -8                              Coimbatore -9   

Ms-Excel

ODI scores of a cricket match played between Australia and India is given below

Overs à County↓	5	10	15	20	25	30	35	40	45	50
Australia	28	58	90	119	147	177	202	242	287	337
India	24	50	75	102	150	170	192	212	272	339

Analyse the performance of the teams by producing

Ø  Bar chart

Ø  Cloumn chart

Ø  Line Chart

Perform all the Tasks

Ms Word

A computer is a device that accepts information (in the form of digitalized data) and manipulates it for some result based on a program or sequence of instructions on how the data is to be processed. Complex computers also include the means for storing data (including the program, which is also a form of data) for some necessary duration. A program may be invariable and built into the computer (and called logic circuitry as it is on microprocessors) or different pro grams may be provided to the computer (loaded into its storage and then started b y an administrator or user). Today's computers have both kinds of programming.

Follow the instructions below:

1.         Open a blank MS Word document and type the above text.

2.         Copy the last sentence Today's computers have both kinds of programming.

to the beginning of the first paragraph.

3.         Change the typeface of the entire document to 11 point Book Antiqua.

4.         Change all the word occurrences of computer to workstation.

5.         Change the spacing of the entire document from single spacing to 1.5.

6.         Change the alignment of the entire document to Justify.

7.         Set the phrases logic circuitry and microprocessors in Italic.

8.         Set the footer as CAM, GIM in 10 point Tahoma.

9.         Save the document as: (‘Yr Reg no’.CAM) on the desktop.

 

MS Excel

Prepare Students Mark statement for the following details for 20 students. And display the result in a chart

Rl.No.	Name	Mark1	Mark2	Mark3	Total	Average	Result

Perform all the Tasks

Ms-Word

ABC Ltd,. wants to send the following  letter to some of its customers. The letter as well as the customer list is given below.  Prepare the letters using mail-merge.

 

Main Document

 

ABC Enterprises

II Floor,  Gateway Towers

Seshadri Nagar, Adayar

Chennai – 600 002

 

Date :

 

To

 

Dear  <<Customer Name>>

 

We would like to inform you that the sales bills submitted to you in Jan 2016 remains unpaid till date and the total amount due in this regard is Rs<<Due>> We shall appreciate if the same amount is cleared immediately in order that we may carry out our business smoothly and so that we may continue to serve you as promptly and effectively as we have done in the past.

 

For ABC Enterprises

Ramkumar .S

(Manager – Sales)

 

Customer List

Mani Maran	11,NSR Road, Saibaba colony	Coimbatore -44	12,500/-
Monica Francis	123, Bharathiar Park Road	Coimbatore – 43	15,500/-
Mujib Ahmed	67,LakeView apartments, Velachery	Chennai – 105	75,000/-
Sheela  Gaur	345-347, Pinnacle Tower, MG Road,	Chandighar – 03	1,50,000/-
Samuelson.A	1784, Karunya Aptmnts, Giri Nagar,	Cochin – 19	57,000/-

 

MS-Excel

 

Region	Sales	Expenses
North
East
South
West

 

Compare the performances of the four regions by producing ‘Column Chart’ for sales and expenditure for 12 months.  Your chart should contain the following features.

 

Chart Title : ‘Regional Sales & Expenses’

X-axis Title : Region

Y-axis Title : Sales in Lakhs

Legends

Data label values Also compare sales and expenses of the four  regions by producing pie-chart

 

Duration: 3 Hour                                                                                                              Maximum Marks: 60

 

Perform all the Tasks

Ms Word

Prepare a project proposal front page and Index page for Metro project in Coimbatore, and a covering letter, accompanying the project proposal. Use smart art , text box and background formatting appropriately to prepare an attractive page

 

 

 

 

 

 

Ms Power Point

 

Prepare a power point presentation for a quiz competition it should contain the following

 

Ø  Question slide for 5 rounds

Ø  Each round should have 8 questions

Ø  Hyperlink at the end of each round for the main page

Ø  Animations and slide transitions

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Perform all the Tasks

 

Ms-Excel

 

ODI scores of a cricket match played between Australia and India is given below

 

Overs à County↓	5	10	15	20	25	30	35	40	45	50
Australia	28	58	90	119	147	177	202	242	287	337
India	24	50	75	102	150	170	192	212	272	339

 

Analyze the performance of the teams by producing

Ø  Bar chart

Ø  Column chart

Ø  Line chart

 

 

 

 

 

Ms-Word

 

Draw an organisation chart of a typical manufacturing organisation covering every functional areas and department.

 

 

 

Perform all the Tasks

MS- Power Point

 

Create a power point presentation about the new product /services to be launched by your company. It should include a brief introduction about the company and the salient features of the new product or the service that you are planning to launch. The slides should include the following features

ü  Title Slide

ü  Bulleted list

ü  Text and clipart

ü  Chart

ü  An organizational chart

ü  Footer

Apply suitable design templates, animation and transition to enhance the presentation of your slide.

 

Ms Excel

Create a mark list for 20 students studying 12^th in MNC high school, they have 6 subjects. After creating do the following operations

Ø  Find the total, average

Ø  Using sort arrange in ascending order based on total marks

Ø  Add background picture

Ø  Change the theme to civic

 

 

 

 

 

 

 

 

 

Perform all the Tasks

MS Excel

1.       Create a worksheet containing a student database for the academic year 2015-2016, in a new sheet create a database for the 2016-2017. In the third worksheet create a cumulative mark sheet for both the years.

a.       The mark sheet should contain,  reg-no, name, marks for 5 subjects and 20 students

b.       The students percentage for each year and cumulative percentage should be calculated

c.        While creating cumulative mark sheet, the data should be pasted using paste special option.

 

 

MS Word

2.       Prepare a one page report on Computers, insert endnote and footnote wherever possible. Convert the prepared report into two column report and watermark the report as “confidential”. Use “drop cap” to highlight the beginning of the report.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Perform all the Tasks

 

MS-Excel

Ranks  of a college by each department is given below

Ranksà Departments↓	2010	2011	2012	2013	2014	2015
MBA	8	7	9	2	1	2
MCA	2	3	4	8	12	8
MSC CS	6	8	2	5	14	10
Mcom	6	2	4	9	7	3

 

Analyze the performance of the departments by producing

Ø  Bar chart

Ø  Column chart

Ø  Line chart

 

 

 

Ms Word

Write the following Formulae using MS Word Equation Editor

a)       Binomial Theorem

 

b)      Correlation Coefficient

Perform all the Tasks

Ms Word

A computer is a device that accepts information (in the form of digitalized data) and manipulates it for some result based on a program or sequence of instructions on how the data is to be processed. Complex computers also include the means for storing data (including the program, which is also a form of data) for some necessary duration. A program may be invariable and built into the computer (and called logic circuitry as it is on microprocessors) or different pro grams may be provided to the computer (loaded into its storage and then started b y an administrator or user). Today's computers have both kinds of programming.

Follow the instructions below:

10.       Open a blank MS Word document and type the above text.

11.       Copy the last sentence Today's computers have both kinds of programming.

to the beginning of the first paragraph.

12.       Change the typeface of the entire document to 11 point Verdana.

13.       Change all the word occurrences of computer to workstation.

14.       Change the spacing of the entire document from single spacing to 1.5.

15.       Change the alignment of the entire document to Justify.

16.       Set the phrases logic circuitry and microprocessors in Italic.

17.       Insert a text box and move the whole paragraph into the text box.

18.       Fill the text box with Blue color.

19.       Align your name to the bottom right of the cover page in 12 point Tahoma.

20.       Save the document as: (‘Yr Reg no’.CAM) on the desktop.

Ms Excel

1.       Prepare a worksheet for pay-bill calculation with the following details for 20 persons.

Basic                -

DA                  -           200% of the Basic

HRA               -           10% of the Basic pay

CCA                -           8% of the Basic pay

MA                  -           a fixed amount of Rs.250/-

PF                    -           Deduction @ 12% of Basic

Compute the Gross and Net salary.

Perform all the Tasks

 

Ms-Excel

Prepare a worksheet with following specifications for 20 students

Name	FM	OM	RMM	HRM	QT	MM	Total	Average

·         Create individual charts for each student

·         Arrange the list in descending order based on marks scored in OM

·         Insert header and footer

 

Ms-PowerPoint

Create a power point presentation about the new product /services to be launched by your company. It should include a brief introduction about the company and the salient features of the new product or the service that you are planning to launch. The slides should include the following features

ü  Title Slide

ü  Bulleted list

ü  Text and clipart

ü  Chart

ü  An organizational chart

ü  Footer

Apply suitable design templates, animation and transition to enhance the presentation of your slide.

 

 

 

 

Perform all the Tasks

 

Ms-Word

CYBER INFOTECH

1234, II Cross Chaithanya Nagar, Krishnarajpura

Bangalore – 90

 

CIT/A30/Jan                                                                                                 23-03-2016

 

To

******,

Dear **** ,

 

With reference to your application for the post of ****, you are required to meet the undersigned for a personal interview on 24-04-2016 with all your testimonials and this call letter at **** in our corporate office.

 

With warm regards,

 

V.K. Thomas

(Manager – HRD)

Note:  ***** Fields to be inserted

Mail merge the following records with the main document.

Records

Name	Address	City	Pincode	Post	Time
Akilesh.E	“Aaradhana”, Sai Nagar, Kalpathi	Palakkad	678 015	Assistant Manager – P&A	10:30 a.m.
Archana.T	18-A, Surabhi Apts. R.A. Puram	Chennai	600 015	Management Trainee	11:00 a.m.
Dhinesh.K	“Swagath”, Krishna Colony,  Paalarivattam	Cochin	686 045	Marketing Manager	3:00 p.m.
Midhun.S	10, R.A. Layout, Ramanathapuram	Coimbatore	641 045	Senior Sales Executive	11:30 a.m.
Nandan.D	12-B, Defence Colony, Avadi	Chennai	600 108	Programmer	2:00 p.m.
Shekar	15,G.D.Nagar, Avinashi Road,	Coimbatore	641 018	Design Engineer	3:30 p.m.

 

Ms- power point

 

Create a presentation, for a inauguration session for a dance festival, use

ü  Tables, shapes appropriately

ü  Animations

ü  Custom slideshow

Perform all the Tasks

 

Ms-Word

 

Create a Word Document about the role of computers in management with the following features.  Your document should contain at least three paragraphs.

 

Top Margin 1.25 inches

Bottom Margin 1.25 inches

Right Margin 1 Inch

Left Margin 1 inch

Line space 1.5

 

Header : “Formatting the Document”

Footer : Page No, Date

 

Add a suitable Picture

 

 

Ms-power point

 

Create a power point presentation for a business plan presentation, it should contain the following

ü  Title slide

ü  Introduction of company

ü  Product profile

ü  Special features

ü  Timed slide change after 30 seconds

ü  Use hyper links to navigate

 

 

 

 

 

 

Perform all the Tasks

Ms Word

Create a new MS Word document and enter the following text.         

Importance of organization or advantages of organization

Organization creates the relationship between top level executives and lower level staff members. The top level executives perform the functions, like planning, organizing, staff directing, controlling the lower level people. The actual work is completed at lower level organization. In this way organization maintains the relationship with each other in an enterprise.

Perform the following formats on the above paragraph.

1. Insert today’s date on the top right corner of the page.
2. Enter your full name below the paragraph and right justify.
3. Change the line spacing 1 – 1.5”
4. Insert a comment on the first appearing organization word in the paragraph.
5. Insert a drop cap for the first three lines of the paragraph.
6. Justify the Paragraph
7. Change all the “organization” word in the paragraph to italics in a single step.
8. Give 3-d border to the page with a width of 1pt.
9. Change the all margins to .75” and orientation to portrait.
10. Change the font Arial Narrow with a size of 15.

Ms Excel

 

Create an attendance register for MBA classroom for the month of  march 2016 for 10students, each day consists of 5 sessions, mark the present as 1 and absent as 0. Calculate the total no of hours attended by each student and their attendance percentage. Saturday and Sunday are holidays. Use calendar for reference.

 

Perform all the Tasks

Ms Excel

Open a new Excel workbook and enter the following data.                             

#	Region	Books	Sales (2004)	Sales (2005)	Sales (2006)
1	Tamil Nadu	Science	5000	2500	2700
2	Kerala	Science	4000	3900	4500
3	Karnataka	Science	2000	2100	2150
4	Andhra Pradesh	Science	6000	3200	2500
5	Tamil Nadu	Arts	5000	6800	7200
6	Kerala	Arts	5000	6100	6000
7	Andhra Pradesh	Arts	7500	9500	9950
8	Karnataka	Arts	4000	4050	4900
9	Tamil Nadu	Computer	7000	7000	8500
10	Kerala	Computer	9000	8000	9750
11	Karnataka	Computer	3350	2900	6000
12	Andhra Pradesh	Computer	9500	7900	8000

 

1.        Find the sum of sales done region wise.

2.        Find the total sales done.

3.        Draw Pie Chart the data Region wise sales for 2006.

4.        Draw Bar Chart the data Region wise sales for 2005.

5.        Calculate Correlation Coefficient for the years 2004 and 2005

 

Ms Word

Write the following Formulae using MS Word Equation Editor

c)       Binomial Theorem

 

d)      Correlation Coefficient

 

 

Ms Word

1.       Prepare a timetable for an MBA institution which has two sections and five subjects. The sessions are 50 min each and the working hours are from 10am. Also prepare the academic calendar for the month of July.

 

 

 

 

 

Ms PowerPoint

2.       Create a presentation for a business plan. It should not be more than 8 slides and it should be timed to run on its own after mouse click. Use animations and transition effects as much as possible. Use any modern theme for better vivibility.