SHADAN

College of Engineering & Technology

(An ISO 9001:2015 Certified Institution)

Estd: 1995 |Approved By AICTE | Affiliated to JNTUH | Permitted by Govt of T.S | I S O Certified Institution| Registered with NSS| Member of National Digital Library| Institutional Member of Oracle Academy | Member of NPTEL(SWAYAM), MHRD | Enrolled in J-HUB |Applied for 2f(UGC)|Participated in N I R F, MHRD | Enrolled in Unnat Bharat Abhiyan.
Master of Business Administration
Infrastructure Facilities

Sl. No.

Name of the Laboratory

1

BUSINESS COMMUNICATION LAB

2

STATISTICAL DATA ANALYSIS LAB

EQUIPMENT DETAILS

NOS.

LIST OF EXPERIMENTS

COMPUTERS  WITH MS OFFICE INSTALLED

30

UNIT I

·         Communication Barriers.

·         Inter cultural and Team Communication, Interpersonal Communication.

·         Networking and Socializing professionally

·         Non-Verbal Communication, Listening, Communication through Social Media

·         Business Meetings

UNIT II

·         Process of Writing, Drafting, revising Visuals, Editing,

·         Proof reading and formatting, Writing positive and Neutral Messages, Persuasive Messages, Bad News Messages.

·         Business Letter Writing, Kinds of Business Letters, Communicating with e-mail and memos.

UNIT III

·         Business Reports and Proposals

UNIT IV

·         Oral and Employment Communication.

·         Planning and organizing presentations.

·         Preparing Resume, Resume Formats, Writing Covering Letters, and Enquiry mails,

·         Preparing for the job interview.

UNIT V

·         Contemporary Aspects in Communication.

·         Cross Cultural and Global Communication.

·         Communication in Information Technology.

·         e-Business related operations.

COMPUTER WITH MS OFFICE AND STATISTICAL PACKAGES LIKE SPSS

30

Unit – I:

·         Introduction, uses, functions and features of Statistical Packages.

·         Highlights and main functions: Home, Insert, page layout, formulas, Data, review, view, add-inns in excel/SPSS.

·         Using help function, customizing the Quick Access Toolbar.

Unit – II:

·         Creating and Using Templates: Working with Data: Entering, Editing, Copy, Cut, Paste, Paste Special, Formatting Data and Using the Right Mouse Click, Saving, Page Setup, and Printing,

·         Using Headers and Footers, Manipulating Data, using Data Names and Ranges, Filters and Sort and Validation Lists.

Unit – III:

·         Data from External Sources: Using and Formatting Tables, Basic Formulas and Use of Functions

·         Data Analysis Using Charts and Graphs, Managing, Inserting, and Copying Worksheets.

·         Securing the Document, Advanced Formulas and Functions, Worksheet Features,

·         Data Analysis using Pivot Tables and Pivot Charts.

Unit – IV:

·         Data Analysis – I: Tabulation, bar diagram, Multiple Bar diagram, Pie diagram.

·         Measure of central tendency: mean, median, mode.

·         Measure of dispersion: variance, standard deviation.

·         Coefficient of variation.

·         Correlation.

·         Regression lines.

Unit – V:

Data Analysis – II:

·         t-test

·         F-test

·         ANOVA one-way classification

·         Chi square test,

·         Independence of attributes.

·         Time series: forecasting Method of least squares, moving average method. Inference and discussion of results.