Aims & Objectives: The main aim of the syllabus is to develop the students’s competence for higher studies in colleges and universities. Hence, basic knowledge of the subject, related to theory and applied aspects, should be imparted to the students.

For economics, following aspects have been covered :-
(1) Comparative study of Indian and Western economic thinking and basic economic features of India & Madhya Pradesh.
(2) Consumer’s behavior, production process, laws of production, capital formation.
(3) Economic development, basic infrastructure, planning in India, and challenges like-poverty, un-employment, inflation, human capital are to be covered.
(4) Concepts relating to Micro and Macro economics, consumer’s demand, elasticity of demand, producer’s supply, elasticity of supply, consumer’s and producer’s equilibrium should be cleried.
(5) Types of market and determination of price, theory of employment, monetary system are to be explained.
(6) Knowledge related to public finance, balance of payment, budget, national income etc. should be imparted.
(7) To introduce statistical methods and their use in economics & project work.

Unit-1 Evolution of Science of Economics :-
(i) Indian Economic Thinking (Perspective)
(ii) Western Economic Thinking (Perspective)
(iii) Distinction between Indian and Western Economic Thinking Perspective and definitions
(iv) Contribution of eminent Indian Economists – Koutilya, Dada Bhai Noroji, M.K.Gandhi, Pt. Jawahar Lal Nehru, Dindayal Upadhyaya, Ram Manohar Lohiya, J.K. Mehta, Dr.V.K. R.V. Rao, C.N. Vakil, Dr. M.G. Bhokare, etc.

Unit-2 Consumption and Production -
(i) Consumption – Meaning, Types and Importance.
(ii) Utility – Meaning, Types, Law of Diminishing Marginal Utility, explanation with the help of diagram, Assumptions and Importance. Exceptions and Criticism. Consumer’s Equilibrium.
(iii) Consumer’s Surplus – Meaning, explanation with the help of charts and graphs Importance and Criticism.

(iv) Laws of Returns and Returns to Scale (More than one input) – Law of Diminishing Returns, Law of Increasing Returns, Law of Constant Returns explaination with the help of charts and graps, assumptions-Increasing, Constant and Decreasing Returns to scale, explaination with the help of charts and graphs.
(v) Capital Formation and Savings – Meaning, causes of low rate of capital formation and measures to increase it in India. Meaning and sources of Savings causes of low rate of saving and measures to increase it in India.

Unit-3 Economic Growth and Development :-
(i) Concept of Growth and Development.
(ii) Sustainable Deveopment and Quality of Life
(iii) Indicators of Development – Concept ; National and Per Capita Income, Selection of Indicators, Human Development Index and Components of the construction of Index Numbers. Human Development Index in India and Madhya
Pradesh.

Unit-4 Economic Planning -
(i) Economic Planning in India – Major aims and objectives of Economic Development under different Five -year Plans. (In brief)
(ii) Economic Reforms Since 1991 – Introduction,Need and Basic features; Liberalisation, Privatisation and Globalisation-meaning. An appraisal of Libralisation, Privatisation and Globlisation policies.

• General Instructions
• All the questions are compulsory.

Section ‘A’

1. Explain with reference to context any four of the following passages (out of six) Each question 2 marks.
(i) Sharda Devi felt faint. Her mind went back to the days of hectic political movement. She heard shouts of Vande Mataram. Suddenly the police opened fire.
(ii) Here he was not enunciating any new proposition. He was merely declaring some fundamental truths which have come down to us from the environment which nourished him.
(iii) “We are not armed and there is no necessity for arms either. We have a strong weapon, a political weapon, in boycott. The whole of the administration,
which is conducted by a handful of Englishmen, is carried on with our assistance.”
(iv) Always have something to say. The man who has something to say and who is known never to speak unless he has, is sure to be listened to especially
in a deliberative assembly or wherever there is business to be done, while no one pays attention to the man of mere words.
(v) “Do not tell a lie to another, say what you know to be true.” This is a principle. Its usefulness becomes apparent at every step in life. We appreciate a
truthful person. If we tell a lie, we ourselves feel unhappy, life cannot go on ; there will be great confusion.
(vi) For men to come near to one another and yet to continue to ignore the claims of humanity is a sure process of suicide. We are waiting for the time when the Spirit of the age will be incarnated in a complete human truth and the meeting of men will be translated into the Unity of men. 4×2=8

Section ‘B’

Question 2. Answer any two of the following questions (out of three) in not more than 10 to 15 words. (Prose) Each question carries 1 mark

(i) Where was Arun sent for education when he was thirteen year old ?
(ii) Why did Curzon resign as Governor General of India ?
(iii) What is more important than materialistic progress ? 2×1=2

Question 3. Answer any three of the following questions (out of five) in not more than 10 to 15 words. (Fiction) Each question carries 1 mark

(i) What is the profession of Jagan ?
(ii) What are the basic principles on which Jagan’s business is based ?
(iii) Why does Jagan plies the Charka everyday even when he is past sixty ?
(iv) Name the book written by Jagan which is in the Press and is taking a long time to come.
(v) Where does Jagan go in the end ? 3×1=3

Question 4. Answer any four of the following questions (out of six) in not more than 20 to 30 words. (Prose) Each question carries 3 marks

(i) What incident was Sharda Devi reminded of when Arun told her about Dick ?
(ii) What were the several ways in which Mahatma Gandhi worked for the country and the world ?
(iii) Why is it necessary for you to put your ideas in some sort of order ?
(iv) In the lesson “Mathematics in Ancient India” what is the main aim of the author Jawaharlal Nehru ?
(v) How can we solve the present problems ?
(vi) How did Mrs. Clifford earn her living ? 4×3=12

Question 5. Answer any five of the following questions (out of seven) in 20 to 30 words. (Fiction) Each question carries 2 marks

(i) What remedy does Jagan Suggest for the problem of Vagrants ?
(ii) What does Jagan say about Kalidas ?
(iii) What steps did Jagan take after he got inspired from Gandhiji ?
(iv) Why did Jagan feel that he needed an escape ?
(v) What is the technique used by the novelist in this novel ?
(vi) Why is Jagan disturbed when he comes to know the truth about Grace ?
(vii) What shock does Jagan get when the Mali returns from America ? 5×2=10

Question 6. Answer any two of the following questions (out of four) in not more than 60 to 80 words. (Prose) Each question carries 5 marks

(i) Describe how the people were highly appreciative of Arun’s heroic deed.
(ii) What was bad about the educational policy of the Government of India and what did Tilak do to oppose it ?
(iii) In what terms has Dantzig established the superiority of Indian the Mathematical genius over that of Europe ?
(iv) What is Tagore’s message to the world in his essay ‘The Voice of Humanity’. 2×5=10

Question 7. Answer any two of the following questions (out of four) in not more than 60 to 80 words. Each question carries 5 marks

(i) Do you think that Jagan is a typical Indian ? Explain.
(ii) ‘Mali is a spoiled child of westernization’ Discuss.
(iii) Jagan is a true patriot. Give instances to prove this.
(iv) Do you think that the novelist has conveyed a deep message through his ‘Vendor of Sweets’ Throw a light on the message and critically appreciate it. 2×5=10

Section ‘C’

Question 8.Write a critical appreciation of the following passage :

• Time allowed : 3 hours
• Maximum Marks: 70

General Instructions:

(i) All questions are compulsory. Marks are indicated against each question.
(ii) Answers to questions carrying 2 marks (Part A – Questions no. 1 to 5) should not exceed 30 words each.
(iii) Answers to questions carrying 5 marks (Part B – Section I, II, III – Questions no. 6 to 16) should not exceed 100 words each.
(iv) Answers to questions carrying 8 marks (Part C – Questions no. 17 to 18) should not exceed 250 words each.
(v) Part D has questions based on three sources.
(vi) Attach the maps with the answer scripts (Part E).

Answer all the questions given below.

1. Mention one of the most challenging episodes in the Mahabharata.
2. Mention any two features about the location of the city of Vijayanagar.
3. What was Jati Panchayat? State any two of its function.
4. Why was the Permanent Settlement of land revenue rarely extended to any region beyond Bengal? Give two reasons.
5. State two reasons of migration of working class to the big cities.

SECTION – 1

Answer any three of the following questions.

6. Describe how artefacts help in identifying social differences during the Harappan period.
7. Describe how Magadha become the most powerful mahajanapada.
8. “The Dharma sutras and Dharama shastras also contained rules about the ideal occupation of the four categories of Varnas.” Critically examine the statement.
9. Describe briefly the teaching of Mahatma Buddha.

SECTION II

Answer any two of the following questions.

10. According to Bernier, “Crown ownership of land had disastrous consequences for the state and the society.” Justify the statement.
11. Describe briefly the relationship between the Mughals and the Ottomans.
12. “ The keeping of exact and detailed records was a major concern of the Mughal administration.” Critically examine the statement.

SECTION – III

13. Explain two strategies devised by the Zamindars of Bengal to survive the Pressures of high revenue demand and auction of their lands.
14. “The dispossession of taluqdars meant the breakdown of an entire social order.” Critically examine the statement.
15. Why did the Congress reject the offer of the Muslim League to form a joint Government? Explain.
16. Explain the ideals introduced by Jawahar Lal Nehru in the ‘Objectives Resolution’ that were to be kept in mind framing the Constitution of India.

17. Explain the significance of Kabir’s poems and the traditions he drew to describe the ultimate reality.

OR

Explain Chisti devotionalism with special reference to ziarat and qawwali.

18. Explain how Gandhiji’s mass appeal was undoubtedly genuine in the context of Indian polities and how it contributed to his success in broadening the basis of nationalism.

History

Aims and Objective:
1. To apprise the students of the complex procedure of construction of History, as knowledge of History is pre-requisite for better future
2. To encourage the students to explore various methods of under standing History.
3. To inform the students of historical facts and related areas and periods.
4. To encourage the student to study the past.
5. To apprise the student of the main incidents, of development works and their nature which have made the contemporary world.
6. To educate the students about the glorious past of India.
7. To point out the mistakes made in those periods so that they can he avoided in the future.
8. Through the study of independence movement the students should he encouraged to respect and preserve our independence.
9. To apprise the students about the historical heritage of M.P.
10. To apprise the students of the historical places with the help of maps and project work.

History (World History)

Unit-1 Introduction to World History
(i) Pre History of the World
(ii) Early Important river bank cultures of the world
a) Saraswati-Indus (Harappa) Civilization
b) Egyptain Civilization
c) Mesopotamian Civilization
d) Chinese Civilization

Unit-2
a) Important Empires and ancient cities.
(i) Mauryan
(ii) Chinese
(iii) Greeco Roman
b) Important ancient cities of the world – Taxila, Patliputra, Cairo, Alexandria, Babylonia.

Unit-3 Changing traditions
i. Feundalism in Europe up to 14th century.
ii. Formation of States after fourteenth century in Europe.
iii. Church and Society.

Unit- 4 Cultural changes in Europe up to 17th century
i. Renaissance.
ii. New geographical discoveries.
iii. New Scientific discoveries.

Unit – 5 Modernization of World
i. Agricultural Revolution.
ii. Industrial Revolution.
iii. Emergence of new classes in society.

Unit – 6 Colonialism
i. Rise of colonialism and imperialism.
ii. Early Settlements in America and their problems.
iii. Early Settlements in Australia and their problems.

Unit – 7 Resistance to colonialism in Asia
i. China – Opium wars and Boxer revolt.
ii. Japan – Economic growth and militarization.
iii. Peoples revolts against Britishers in India before 1857.

Unit – 8 Important Political revolution of the world.
i. Glorious revolution of England – 1688
ii. French revolutions of 1789, 1830 and 1848.
iii. Russian revolutions of 1905 and 1917.

Unit – 9 The two great wars and the world (Part 1)
i. World war – I
ii. Leage of Nations.
iii. Economic depression of 1929
iv. Fascism in Italy

Unit – 10 The two great wars and the world (Part 2)
i. Nazism in Germany
ii. World War – II
iii. United Nations

OBJECTIVES
1. The Course in geography will help learners familiarize themselves with the terms, key concepts and basic principles of geography.
2. Search for recognize and understand the process and patterns of the special arrangement of the natwap as well as human features and phenomena on the earth’s surface.
3. Understand and analyse the inter-relationship between physical and human environments and their impact.
4. Apply geographical knowledge and methods of ingiving to new situations or problems at different levels local/regional, national and global.
5. Develop geographical skills, relating to collection, processing and analysis of data/information and preparation of report including graphics and use of computers wherever possible and.
6. Clarify their personal values towards issues concerning the community and become responsible as well as effective members of the country.

Part – A Fundamentals of Physcial Geography
1. Geography :As a Disciplene 03 06
2. Earth 05 10
3. Landform’s Formation 08 16
4. Climate 12 24
5. Hydrosphere 08 16
6. Life of the earth 06 12
Part – B India : Physical Invironment
7. Physiography 10 20
8. Climate 10 20
9. Natural Vegetation and soil 08 16
10. Natural Hazards and disasters 05 10
75 150
Part – C Practical Geography
11. Fundamentals of Maps 08 16
12. Topographic and weather maps 07 14
(Record) – 05
(Viva) – 05
25 30
Grand Total: 100 180

Part – (A) Fundamentals of Physcial Geography :
Unit I. Geography as a discipline : An interoduction.
1. Geography as an integrating discipline. As a science of special attributes.
2. Meaning, Scope, branches, importance and relationship with other subjects.

Learning Objective:
1. To understand the application development environment.
2. To gain programming Skills in Visual Basic and Database Creation in ORACLE.
3. To design, program and develop database application using Visual Basic and RACAL.
4. To learn database connectivity using Visual Basic as Front-end tool.

Competencies:
1. Student will become familiar with Application Development.
2. Student will be able to develop & debug programs independently.
3. Student can use SQL for storing and retrieving data from the RDBMS.
4. Ability to arrive at a normalized design of tables and other database objects in RDBMS. Also student will acquire programming skills in PL/SQL.
5. Student will be able to develop a Client Server Application using Visual Basic as Front end and oracle as Back end.

Unit No. Unit Name Marks

1. COMPUTER SYSTEM AND BUSINESS APPLICATIONS 15
2. INTRODUCTION TO PROGRAMMING 30
3. RELATIONAL DATABASE MANAGEMENT SYSTEM 30

Evolution of computers; Basics of computer and its operation: Functional Components
and their interconnections, Concept of Booting;

Hardware concepts:
Diagram illustrating main parts of computers;

Central Processing Unit (CPU): Arithmetic & Logic Unit (ALUM), Control Unit, Memory Unit (RAM – Random Access Memory & ROM – Read Only Memory) Role of Input, Processing and Output Devices in a computer system Input Devices: Keyboard, Mouse, Light Pen, Touch Screens, Graphics Tablets, Joystick, Mike, MICRO, OCR, Scanner, Smart Card reader, Barcode reader, Biometric sensor, Web camera, Digital camera;

Output Devices: Monitor/Visual Display Unit (VDU), Printer (Dot Matrix Printer, Desk jet/ Ink jet/ Bubble jet Printer, Laser Printer), Plotter, Speaker,

Secondary Storage Devices: Floppy Disk, Hard Disk, Compact Disk, Magnetic Tape, Digital Video Disk (DVD), Zip Drive;
Units of Memory: Bit (Binary Digit), Byte, Kilobyte, Megabyte, Gigabyte.

Software Concepts:
Types of Software: System Software, Utility Software and Application Software.
System Software: Operating System, Language Compilers, Interpreters and Assembler;
Operating System: Need of Operating systems, Functions of Operating System, Types of Operating system.

Utility Software: Compression tools, Anti Virus, File Management tools and Disk Management tools; Application Software as a tool: Word Processor, Presentation Tool, Spreadsheet Package, Database Management System; Business software (for example: Inventory Management System, Payroll System, Financial Accounting, Hotel Management, and Reservation
System);

Development of Programming Languages – Machine Language, Assembly Language, High Level Language (BASIC, COBOL, FORTRAN, PASCAL, C++);

GUI based languages – Visual Basic, Visual C++; C+, Java, bonnet.

GUI Operating System
Important: Students/Teachers can also perform similar operation on any operating system.
It is advised that the teacher while using any one operating system, give a demonstration of equivalent features for the other operating system.

Microsoft Windows: General features, Elements of Desktop – Taskbar, Icon, Start button, Shortcuts, Folder, Recycle Bin, My Computer;

Start Menu: Program, Documents, Settings, Find/Search, Help, Run, Shut Down/Logoff; Customization of Taskbar, Start menu, Display properties (Wallpaper, Font Settings, Color Settings, Screen Savers);
Program Menu: Accessories – Calculator, Notepad, MS Paint, Word pad, Entertainments (CD Player, Sound Recorder, Windows Media Player, Volume Controller); Window Explorer and Internet Explorer;

Control Panel: Add new hardware; Add new Software, Printer Installation, Date/Time, Mouse and Regional Settings;
Documentation using MS Word Purpose of using Word processing software, opening a new/existing document, closing a
document, typing in a document, saving a document, print preview, printing a document, setting up of page as per the specifications, selecting a portion of document, copying selected text, cutting selected text, pasting selected text; changing font size, style, color of text; Inserting symbol; Formatting: Alignment-Left, Right, Center; Justification;

Industries and Business Computing: Types of Industries (Production, Shipping, Travel, Hotel, Insurance, Construction, Automobile), Application of Business Computing in Industries.

Programming Methodology:
General Concepts; Modular approach; Stylistic Guidelines: Clarity and Simplicity of Expressions, Names, Comments, Indentation; Documentation and Program Maintenance; Running and Debugging programs, Syntax Errors, Run-Time errors, Logical Errors; Problem Solving Methodology and Techniques: Understanding of the problem, Identifying minimum number of inputs required for output, Step by step solution for the problem, Breaking down solution into simple steps, Identification of Arithmetic and Logical operations required for solution, Using Control Structure: Conditional control and looping (finite and infinite);

Programming Tool: Visual Basic

Introduction to Programming – Modular Programming, Object Oriented Programming, Event Driven Programming; About Visual Basic (Object Based Programming Language), Rapid Application Development using Visual Basic; Concept of Project in Visual Basic, VB Project Options – Standard EXE, ActiveX DLL, Active X EXE, Active X Control, ActiveX Document DLL, ActiveX Document EXE, Adding, VB Application Wizard, IBIS Application, DATUM Application; Getting Familiar with Visual Basic, User Interface – Pull-Down menus, Toolbar, Toolbox, Project Explorer, Properties Window, Form Layout window, Form, Immediate window; Opening and Closing windows, Resizing and moving windows, Docking windows; Quitting Visual Basic; Visual Basic Tool Box (Standard Window Controls) – Pointer, Picture Box, Label, Text Box, Frame, Command Button, Check Box, Option Button, Combo Box, List Box, Horizontal Scrollbar, Vertical Scrollbar, Timer, Drive List Box, Directory List Box, File List box, Shape, Line, Image, Data OLE; Object, Naming Conventions, Event Procedures.

Programming Fundamentals:

• Data Type: Integer, Long, Single, Double, Currency, String, Byte, Boolean, Date, Object, Variant;
• Variables: Need to use variable, Declaring Variables, Variable Naming Convention, Assigning value to Variables, Data Types of Variable, Scope and lifetime of Variables (Public and Private);
• Menu Editor: Concept of Menus, Shortcut menus and Popup menus Designing Menu System, Menu Editor Dialog Box Options (Name, Index, Shortcut, HelpContextID, NegotiablePosition, Checked, Enabled, Visible, Window List, Right Arrow, Left Arrow, Up Arrow, Down Arrow, Menu List, Next, Insert, Delete, OK, Cancel), To Create Menu Controls in the Menu Editor, Menu Naming Conventions, Setting the Name Property, Creating a Menu Control Array, Creating Sub Menus, Separating Menu Controls, Assigning Access Keys and Shortcut Keys, Controlling Menus at Runtime-Enabling and Disabling Menu Commands, Displaying a Checkmark on a Menu Control, Making a Menu Control Invisible, Adding Menu Control at Runtime, Displaying Pop-Up Menu;
• General Controls (Advance): Image List, Common Dialog Box, ADO DC, DB Combo, Media Player Control, DB Grid;
• Adding a Toolbar: Creating an Image List, Adding Images to the Toolbar, To Add Code for the Toolbar Buttons;
• Adding Status Bar: Adding Status Bar panels, Adding Time on the panel.
• Dialog Boxes: Pre-defined dialog box, Custom dialog box;

Database Management System
Introduction to Database concepts: Relation/Table, attribute, Topple/Rows, field, Data, Concept of String, Number and Date values, Data type and Data Integrity (Domain and Referential Integrity). Candidate key, Alternate key, Primary Key, Foreign Keys; Data Normalization-first, second, third, BANFF normal form; Examples of Commercially available Database Management System’s (Back-End) – Oracle, MS-SQL Server, DB2, Myself, Sybase, INGRESS.
Examples of Front End Software’s: Oracle Developer, Visual Basic, Visual C++, Power Builder, Delphi;

RDBMS Tool : Oracle
ORACLE : Introduction, Version, Two Tier and Three Tier support; Interface with Oracle, Login Screen, Entering Name and Password;
Classification of SQL Statements: DSL (SELECT, INSERT, UPDATE, DELETE), DSL (CREATE, DROP, ALTER, RENAME, TRUNCATE), DSL (GRANT, REVOKE), TELL (COMMIT, ROLLBACK);
SQL SELECT Statement: SQL SELECT statement, Selecting All the Columns, Selecting Specific Column, Column Heading Default, Using Arithmetic Operators, Operator Precedence, Significance of NULL value, NULL values in Arithmetic Expressions, Defining and using Column Alias, Concatenation Operator , Duplicate rows and their Elimination (DISTINCT keyword), Role of SQL and SQL Plus in interacting with RDBMS, Displaying Table Structure (DESK command);

SELECT Statement Continued: Limiting Rows during selection (using WHERE clause), Working with Character Strings and Dates, Using Comparison operators, BETWEEN Operator , IN Operator, LIKE Operator, IS NULL Comparison, Logical Operators, Use of Logical Operators (AND/OR/NOT Operators), Logical Operator Precedence, ORDER BY Clause, Sorting in Ascending/Descending Order, Sorting By Column Alias Name, Sorting on Multiple Columns;
Functions: SQL functions, Types of SQL Function (Single Row/Multiple Row), Single Row SQL Functions, Character Functions (Case Conversion/Character Manipulation), Case Conversion Functions (Lower , Initial , UPPER ) Character Manipulation Function (CONCERT, INKSTER, LENGTH, TRIM, SUBSET, LAD), Number Functions (ROUND, TRUNK, MOD), Working with Dates (LAST DAY, MONTHS BETWEEN, NEXT DAY, ADD MONTHS, ROUND, TRUNK), Arithmetic Operation on Dates, Date Functions and their Usage, Date type Conversion Functions, Implicit and Explicit Conversion, TO CHAR Function with Dates, TO CHAR Functions For Numbers, TO NUMBER and TO DATE Functions, NIL Function and its Usage, DECODE Function and its Usage;
Grouping Records: Concept of Grouping Records and Nested Grouping, Nested Grouping, Nested Grouping of records, Group Functions, Types of Group functions (MAX, MIN, AVGAS, SUM, COUNT), Using AVGAS and SUM Functions, Using MIN and MAX Functions, Using the COUNT Function, using COUNT, DISTINCT clause with COUNT, Group Functions and NULL values, Using NIL Function with Group Function, Grouping Records: Group By Clause, Grouping By more than One Column, Illegal Queries with Group By Clause, Excluding Group Results: Having Clause, Nesting Group Functions,
Sub Queries: Concept of Sub-Query, Sub Query to Solve a Problem, Guidelines for Using Sub Queries, Types of Sub-Queries (Single Row and Multiple Row) and (Single Column and Multiple Column); Single Row Sub- Query and its Execution;

Displaying Data From Multiple Tables: Concpet of Join, Result of Join, Cartesian Product and Generating Cartesian Product example using Mathematical Set), Types of Join (EQUI, SELF, NON-EQUI, OUTER) (LEFT and RIGHT), Equi-join: Retrieving Records with Equi-join, Additional Search Condition using. AND operator, Short Naming Convention for Tables (Table Aliases), Non-Equi join and its Implementation, Outer-Join and Its Usage, Self-Join (Joining a table to Itself); Manipulating Data of a Table/
Relation: Concept of DSL (Data Manipulation Language), INSERT Statement, Inserting New Rows with Null Values, Inserting Data Values, Use of Substitution Variable to Insert Values, Copying Rows From Another Table, Update Statement to Change Existing Data of a Table, Updating Rows in a Table, Updating Rows Based on Another Table, Delete statement/
Removing Row/Rows from a Table, Deleting Rows Based on condition from another Table Making Data manipulation Permanent (COMMIT). Undo Data Manipulation Changes (ROLLBACK)
Database Object: View, Table, Sequence, Index, and Synonyms, DSL (Data Definition Language), Naming Convention, Creating Views, Creating Synonysms, Simple Views and Complex Views, Retrieving Data from a View, Quering a View, Modifying a View,
Including Constraints: Constrainsts, Concept of using Constraints, Constraint Guidelines, Defining Constraints, NOT NULL, UNIQUE KEY, PRIMARY KEY, FOREIGN KEY, FOREIGH KEY Constraint Keywords CHECK, Adding a Constraint, Dropping a
Constraint, Disabling Constraints, Enabling Constraints, Viewing Constraints, Viewing the Columns, Associated with Constraints;

Creation of a Table/Relation: CREATE TABLE Statement, Data types, The DEFAULT option, Creating Tables, Referencing Another User’s Tables, Quering the Database Dictionary to view all tables in the Oracle Database, Creating a Table by Using a Sub-query;
Managing Existing Tables and other Databse Object: The ALTER TABLE Statement, Adding a New Column in a Table, Modifying Existing Column, Dropping a Column, Renaming an Object, Truncating a Table, Adding Comments to a Table, Dropping Views, Dropping Synonyms, Dropping Tables; giving permission to other users to work on Created Tables
and Revoking it (GRANT and REVOKE statement).

1. Hands of Experience
A problem should be given covering the following
– Table definition (The table must include constraints)
– A form with Lable, Text, Command Button control, List Box, Drive List Box, Directory List Box, File List Box, Tool and Menu Bar (Any 4)
– DSN to access table in the databse.
– For data connectivity (Activex Database Control)
– Change of Text box Control Properties to view Databse fields.

2. Practical File
The practical file should contain print outs from each of the following topics.
1. Create an application using Visual Basic with a Text Box control to accept a name from the user and print "Hello <Name>" in a message box. E.g. when user types his name as "Kamala Kant" in the text box and clicks OK button, a message "Hello Kant should be displayed and if he clicks on Cancel button a messages as "Bye Kamala Kant" should appear.
2. Create an Application having two Text Boxes on the Window. Get Title, First Name and Last Name in it. On clicking OK button a message should appear by joining Title+FirstName+Last Name e.g. if user Prof. in Title, Rajyash in First Name, and Swami as Last Name then the message to be printed should be "Happy Deepawli Prof. Rajyash Swami".
3. Creating an applicatin to let user guess any number and click a Play button given on the form. On clicking the Play button the application will generate a random number. If the generated number is same as guessed by the user then display a message "You Win"otherwise display a message "You Lose".
4. Create an application to Display Image files kept in different folders in the system. The application should allow the user to navigate in the folders and list all Image Files (.BMP,. JPG) when ever a image file is selected it should get that picture displayed in an Image control.
5. Create an application having menu bar and tool bar to create a text file, navigate and open text files, edit text file and save changes made by the user.
6. Create a small application working as a general expose Calculator (+, -, , ÷)
7. Sale Assignment (based on Demo Table present in the ORACLE databse for example Emp table, Dept table and Sal Grade table):

• Display all the records (all columns) from table Emp.
• Display Emp.No and Emp Name of all employees from the table Emp.
• Display Ename, Sal and Sal added with Comm from table Emp.
• Display EName joined with Job with heading "Employee", Sal 12 as "Total Salary" from table Emp.
• Display distinct Sal of employees from table Emp.
• Show the Structure of table Dept.
• Write a query to display EName and Sal of Employees whose salary is greater than or equal to 3000 from table Emp.
• Write a Query to display employee name, salary and department number who are not getting commission from table Emp.
• Write a Query to display employee Number, name, sal and sal12 as Annual Salary whose commiossion is not NULL from table Emp.
• Write a Query to display employee name and salary of those employee who don’t have their salary in the range of 1500 to 2000.
• Write a Query to display name, job, salary, and HireDate of employees who are hired between February 20, 1981, and May 1, 1981. Order the query in ascending order of HireDate.
• Write a Query to display the name and hire date of all employees who were hired in 1982.
• Write a Query to display the name, job title and salary of employee who do not have manager.
• Write a Query to display the name of employee whose name contain "A" as third alphabet.
• Write a Query to display the name of employee whose name contains "T"as the last alphabet.
• Write a Query to display the name of employee whose name contains "M" as first alphabet "L" as third alphabet.
• Write a Query to display the name of employee who is having "L"as any alphabet of the name.
• Write a query to display the current system date.
• Write a Query to display employee number, name, salary, salary increase by 15% expressed as a whole number. Lable the column as New Salary.
• Write a Query to display the employee’s name and salary review date, which is the date after six months of HireDate.
• Write a Query to display the employee’s name and salary review date, which is the date after six months of HireDate in format of "Sunday, 7 SEP, 1981.’
• For each employee display employee name and total number of weeks lapsed between HireDate and Today.
• For each employee display employee name and total number of days lapsed between Hire Date and Today.
• Create a query that produces display in the following format.
  <employee name> Earn $<salary> Monthly and working as <Job>
• Write a query which displays the employee name with the first letter capitalized and all other letters lower case and length of there name strings.
• Write a Query to display the employee name and commission amount. If the employee does not earn commission, put "No Commission".
• Write a query to display the grade of all employees base on the value of the column job as per following scheme:

• Write a query to display the EName and DeptNo and DName for all employees using table Emp and Dept.
• Write a Query to display employee name,department name and location of all employees who have manager number between 7500 and 7900.
• Write a Query to display the employee name, department number and all the employees that worked in the same department as a given employee.
• Write a Query to display employee name and HireDate of employees who are employed after Employee ‘BLAKE’.
• Write a Query to display employee number, name and manager’s name with thier manager number.
• Write a Query to Display the Sum, Average, Highest and Lowest salary of the employees.
• Write a Query to Display the Sum, Average, Highest and Lowest salary of the employees grouped by department number.
• Write a Query to Display the Sum, Average, Highest and Lowest salary of the employees grouped by department number and sub-grouped by job.
• Write a query to display the number of employee with same job.
• Write a query to display the Average of Highest and Lowest salary of each department.
• Write a quey to display the difference of Highest and Lowest salary of each department having maximum salary > 4000.
• Write a query to display the employee name and job for all employee in the same department as ‘ALEN’
• Write a query to display employee name and salary of those who either work in department 10 of have salary greater than employee 7521.
  Before the following excrcise please ensure that you are provided with a table Employee with following description.

Table : Employee

Use DESCRIBE command to ensure the table structute.
Add the following data in the above Table as instructed.

• Populate table with first record mentioning the column list in the insert clause.
• Populate table with next two records without mentioning the column list in the insert clause.
• Populate table with 4th record and enter only ID and First_Name.
• Populate table with 5th record and enter ID, User_ID and Last_Name only.
• For record with ID=4 update record with Last_Name User_ID and Salary.
• For record with ID=5 update record with First_Name and Salary.
• Make the changes permanent.
• Modify the Last_Name, of the employee 3, to Gautam.
• Modifiy the Salary and increase it by 1000, for all who get salary less then 5000.
• Delete the employe record having First_Name as Siddharth.
• Make the changes permanent.
• Remove the entire contents of the table.
• Undo the above step.
• Create a table Employeel with columns ID, First_Name and Dept_ID from the table Employee and also confirm the existence of table Employeel.
• Create a view VU_Empl which should include column EmpNo. EName and DeptNo from the table Emp.
• Create a view VU_Emp2 which should include column Emp No, EName and DeptNo from the table Emp and change the column headings as EmpNumber,
• Employee, Department.
• Select VIEW_NAME and TEXT from the data dictionary USER_VIEWS.
• Create the table Department table based on the following table instance chart.

Populate the table Department with data from table dept. Including only required columns.
Create the table Employee based on the following table instance chart.

Rename table Employee1 to Employee 2.
Drop table Employee 2.
Drop table Employee and Department.
Create table Customer as per following Table Instance Chart.

Add one column Email of data type VARCHAR2 size 30 to the table Customer.
Change the data type of column pincode to VARCHAR2 (10) in the table Customer.
Add one more column Customer Income Group of datatype VARCHAR2 (10).
Insert few record with relevant information, in the table.
Drop the column Customer Income Group from table Customer.
Create table Department as per following Table Instnace Chart.

Create table Employee as per following Table Instance Chart.

• Time allowed : 3 hours
• Maximum marks: 100

General Instructions:

(i) All questions are compulsory.
(ii) The question paper consists of 29 questions divided into three Sections A, B and C. Section A comprises of 10 questions of one marks each, Section B comprises of 12 questions of four marks each and Section C comprises of 7 questions of six marks each.
(iii) All questions in Section A are to be answered in one word, one sentence or as per the exact requirement of the question.
(iv) There is no overall choice. However, internal choice has been provided in 4 questions of four marks each and 2 questions of six marks each. You have to attempt only one of the alternatives in all such questions.
(v) Use of calculators is not permitted.

Question number 1 to 10 carry one mark each.

4. If matrix A = (1 2 3), write AA’, where A’ is the transpose of matrix A.

6. Using principal value, evaluate the following: sin^-1(sin 3π/5)
7. Evaluate : ∫ [sec²x/(3 + tanx) ]dx

9. If the binary operation * on the set of integers Z, is defined by a * b = a + 3b2, then find the value of 2 * 4.
10. If A is an invertible matrix of order 3 and |A| = 5, then find |adj A|.

12. Prove that sin^-1(4/5) + sin^-1(5/13) + sin^-1(16/65) = π/2

OR

Solve for x : tan^-13x + tan^-12x = π/4

13. Find the value of λ so that the lines (1 – x)/3 = (7y – 14)/2λ = (5z – 10)/11 and (7 – 7x)/3λ = (y – 5)/1 = (6 – z)/5 are perpendicular to each other.
14. Solve the following differential equation: dy/dx + y = cos x – sin x.
15. Find the particular solution, satisfying the given condition, for the following differential equation:

dy/dx – y/x + coses (y/x) = 0; y = 0 when x = 1.

17. A die is thrown again and again until three sixes are obtained. Find the probability of obtaining the third six in the sixth throw of the die.
18. Differentiate the following function w.r.t. x: x^{sin x} + (sin x)^{cos x} .
19. Evaluate : ∫ [ex/√(5 – 4 e^x – e^2x)]dx

OR

Evaluate : ∫ [{(x - 4)e^x}/(x - 2)³]dx.

20. Prove that the relation R in the set A = {1, 2, 3, 4, 5} given by = {(a, b): |a – b| is even}, is an equivalence relation.
21. Find dy/dx if (x² + y²)² = xy

OR

If y = 3 cos(log x) + 4 sin (log x), then show that x².d²y/dx + x.dy/dx + y = 0

22. Find the equation of the tangent to the curve y = √(3x-2) which is parallel to the line 4x – 2y + 5 = 0.

OR

Find the intervals in which the function f given by f(x) = x3 + 1/x3, x ≠ 0 is (i) increasing (ii) decreasing.

23. Find the volume of the largest cylinder that can be inscribed in a sphere of redius r.

(Candidates are allowed additional 15 minutes for only reading the paper. They must not start writing during this time)

RATIONALE
Sociology is introduced as an elective subject at the higher secondary stage. It helps learners to understand the nature and character of the Society in which they live. It helps to acquire those life skills that will enable them to develop positive attitude towards the changing society. Hence the study of sociology becomes useful at the higher secondary stage. The syllabi at this stage should enable the individual to understand human behaviors in all its complexities and manifestations. The learners of today need answers and explanations to satisfy the questions that arise in their minds while trying to understand social change. Therefore, here is need to develop an analytical approach to the study of social change. The perspective of national integration is the guiding force in the formulation of this syllabi. In today’s fast changing world, the study of sociology will prepare the students to familiarize themselves with the processes of liberalization, globalization and their impact on Indian society. This will enable them to relate and interpret the challenges of the new social order.

OBJECTIVES
• To enable learners to look at social reality objectively.
• To inculcate among the learners scientific temper and ability to perceptive reality free from the shackles of obscurantism and prejudices.
• To introduce the basic concepts of Sociology to the students.
• To exemplify these concepts with reference to empirical situations in India.
• To make the learners familiar with the contemporary processes of development and change.

S. No. Unit Marks Periods

Political Science

Aims and Objectives: We are living in the era of Democracy and today’s youth/students are the citizens of tomorrow. Hence the students must be aware of the basic principles of democracy and process of its implementation on the basis of Constitution.

RATIONALE:

In the new curriculum framework (2000) work experience has been termed as work education and thus makes it an integral component of education. As such it would provide both knowledge and skills through wellstructured and graded programmes, which would help them on their entry into the  world of work. Work education is a distinct curricular area for providing children with opportunities for participation of social and economic activities inside and outside the classroom, which would enable them to understand scientific principles and procedures involved in different tyeps of work.  The productive manual work situations were to be drawn from the area of health and hygiene, food, shelter, clothing, recreation and community service. The competencies to be developed in this field should include knowldege, understanding, practical skills and values through need based life activities.  Prevocational courses should get a prominent place at this stage.  Work edcucation aims at restoring dignity and respect to  all types of manual work, promoting selfreliance in meeting one’s daily needs and those of one’s family and community, increasing productivity through the development of proper work skills and values, and promoting commitment to  the welfare of the society through suitable programme of social work or community service.

Objectives: The major objectives of work education at the Secondary stages are:

To help the pupils to develop essential knowledge and understanding in terms of :

• identifying needs of the self, family and community in respect of food, helath and hygiene, clothing, shelter, recreation and social service.
• acquainting themselves with productive activities in the community;
• understanding facts and scientific principles involved in various forms of work;
• knowing the sources of raw materials and understand the use of tools and equipment in the production of goods and services; understanding the utility of productive work and services to the community;
• understanding the needs of a technologically advancing society in terms of productive processes and skills;
• understanding the processes of planning and organization of productive work;
• conceptualizing their role in productive situations;
• developing abilities for selfevaluation of performance and for entrepreneurship.

To help the pupils to develop skills:

•  for the selection, procurement, arrangement and use of tools and materials for different forms of productive work;
•  to observe, manipulate and participate in work practice;
•  for the application of problemsolving methods in productive work and social service situtions;
•  for greater productive efficiency.
•  to enhance their working competence sufficiently so as to enable them to earn while they learn;
•  to use their creative faculties for devising innovative methods and materials.

To help the pupils to develop proper attitude and values in terms of: