Exam Details
Subject | programming concepts and advanced excel | |
Paper | ||
Exam / Course | mba | |
Department | ||
Organization | solapur university | |
Position | ||
Exam Date | November, 2016 | |
City, State | maharashtra, solapur |
Question Paper
M.B.A. (Semester IV) Examination, 2016
PROGRAMMING CONCEPTS AND ADVANCED EXCEL
Group D System Management (Paper
Day and Date Thursday, 15-12-2016 Total Marks 70
Time 10.30 a.m. to 1.30 p.m.
Note Question No. 1 is compulsory.
Solve any two questions from 4 and any two from 7.
All questions carry equal marks (14 marks).
1. Write an algorithm and draw flowchart for declaring exam result of student as
distinction first class (between 60 and Second Class (Between
50 pass class (between 40 and fail Accept cumulative
marks scored and maximum marks to compute percent and proceed with result
declaration. 14
2. Answer any two of the following 14
Discuss basic data types in programming.
Differentiate between IF-ELSE and SWITCH-CASE constructs.
Discuss LOOKUP functions in Excel.
3. Write short notes on any two of the following 14
LOOP constructs in programming.
Arrays.
Data filter feature of Excel.
P.T.O.
Seat
No.
SLR-T 80
4. Answer in brief on any two of the following 14
Explain operator precedence with example.
Explain various levels of security in Excel.
Define function, discuss the purpose of function and use of RETURN statement
in a function.
5. Describe various types of functions viz. inbuilt, user defined, recursive, with
parameters, without parameters. Explain the difference between with parameter
and without parameter functions. 14
6. Discuss different operators and their precedence in programming. 14
7. Write a program to display multiplication table using parameterized function for a
number passed as parameter. 1
PROGRAMMING CONCEPTS AND ADVANCED EXCEL
Group D System Management (Paper
Day and Date Thursday, 15-12-2016 Total Marks 70
Time 10.30 a.m. to 1.30 p.m.
Note Question No. 1 is compulsory.
Solve any two questions from 4 and any two from 7.
All questions carry equal marks (14 marks).
1. Write an algorithm and draw flowchart for declaring exam result of student as
distinction first class (between 60 and Second Class (Between
50 pass class (between 40 and fail Accept cumulative
marks scored and maximum marks to compute percent and proceed with result
declaration. 14
2. Answer any two of the following 14
Discuss basic data types in programming.
Differentiate between IF-ELSE and SWITCH-CASE constructs.
Discuss LOOKUP functions in Excel.
3. Write short notes on any two of the following 14
LOOP constructs in programming.
Arrays.
Data filter feature of Excel.
P.T.O.
Seat
No.
SLR-T 80
4. Answer in brief on any two of the following 14
Explain operator precedence with example.
Explain various levels of security in Excel.
Define function, discuss the purpose of function and use of RETURN statement
in a function.
5. Describe various types of functions viz. inbuilt, user defined, recursive, with
parameters, without parameters. Explain the difference between with parameter
and without parameter functions. 14
6. Discuss different operators and their precedence in programming. 14
7. Write a program to display multiplication table using parameterized function for a
number passed as parameter. 1
Other Question Papers
Subjects
- (paper – x) financial management
- (paper – xi) human resource management
- accounting for management
- accounting for managers
- agricultural marketing
- agricultural production management
- agro-processing industries and rural industrialization
- banking and insurance (paper – xvi)
- brand management and social marketing
- busines ethics
- business ethics (new) (cbcs)
- business ethics (old)
- corporate planning and strategic management (old)
- corporate planning and strategic management(old cbcs)
- day and date : friday, 30-11-2018 total
- economic environment for business
- entrepreneurship development and project management
- excel
- excellence in management
- export policy, procedure and documents (paper – ii)
- financial decision analysis
- financial management
- fundamentals of agriculture and co-operative management
- fundamentals of agriculture and co-operative management (new cbcs)
- global human resource management
- group d – system management (paper – ii)
- human resource initiatives (paper – ii)
- human resource management
- indian financial system
- indian financial system (paper – xix)
- industrial engineering
- industrial relations and labour regulations
- integrated marketing communication and consumer behaviour
- international busines (paper – xiii)
- international business environment (old)
- international business environment (paper – i)
- international finance
- international financial system and markets
- international financial systems and markets
- international logistics
- international marketing
- international trade and agriculture
- international trade procedures and documentation
- international trade procedures and documentations
- investment management
- it for management
- legal aspects of busines
- legal aspects of business
- logistics and supply chain management
- logistics and supply chain management (paper – xx)
- management accounting
- management accounting (paper–xviii)
- management acounting
- management information system
- managerial communication – i
- managerial communication – ii
- managerial economics
- managerial excellence
- marketing management
- marketing management (cbcs)
- operations management
- organisational behaviour
- organizational behaviour
- paper – ix : marketing management
- paper – xii : production and materials management (old)
- paper – xiii : economic environment of busines
- paper – xiv : managerial comunication – ii
- paper – xv : research methodology
- paper – xvi : event management(new)
- paper – xvi : operations management
- paper – xvii : strategic management
- performance management and compensation
- perspectives of management
- principles of management
- product and brand management
- product and brand management (paper – i)
- production and materials management
- production management and operations research (paper – xii)
- programing concepts and advanced
- programming concepts and advanced excel
- project planning and working capital management
- purchasing and inventory management
- purchasing and inventory management (paper – xix)
- quality management
- relational database management system
- research methodology
- research methodology (paper – xv)
- retail and rural marketing
- sales and distribution management (new) paper – xx
- sales and strategic marketing
- sales and strategic marketing (new cbcs)
- sales and strategic marketing (old)
- security and control information system
- skill development (paper – xix)
- statistical methods
- statistics for management
- strategic financial management
- strategic financial management (paper – ii)
- strategic human resource management
- strategic human resource management (old)
- strategic human resource management (paper – xix)
- system management
- system management security and control information system
- systems management
- systems management (paper – i)
- systems management (paper – ii)
- taxation
- training and development
- training and development gr.c : human resource management
- world class manufacturing