Wednesday 3 October 2012

Merge Same Value Cells of Excel

Steps to Merge Same Value Cells in Excel

Create an Excel Sheet

Month Salary Emp Name
January 1000 Gulab
January 5000 Chand
January 89900 Maurya
Feb 93829 Rohit
Feb 73827 Shivansh
March 798989 Maurya
March 232 Shiv


Create New Macro
to create new macro press alt+f8

view this video for help

macro code used in video is given below:-


Sub MergeSame()
Dim r As Range, c As Range
Dim i As Long, j As Long
Set r = Range("A1", Cells(Rows.Count, "A").End(xlUp))

Application.ScreenUpdating = False
Application.DisplayAlerts = False

For i = 1 To r.Count
Set c = r(i)
j = 0
Do Until c <> c.Offset(rowoffset:=1)
Set c = c(2)
j = j + 1
Loop
With Range(r(i), c)
.Merge
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
End With
i = i + j
Next i

Application.DisplayAlerts = True
Application.ScreenUpdating = True
DoEvents
End Sub

alfter running macro the result is show below


Month Salary Emp Name
January 1000 Gulab
5000 Chand
89900 Maurya
Feb 93829 Rohit
73827 Shivansh
March 798989 Maurya
232 Shiv

Regards
Ram Rati



Tuesday 2 October 2012

Form For Matriculation Examination Punjabi as Additional Subject October 2012

Dear Students


Punjab School Education Board Has Published Admission Form For Matriculation Punjabi Additional Examination Form For October 2012 Under Special Examination of Punjabi Students can Download From From the Given Below Link:

 Form For Matriculation Examination Punjabi as Additional Subject October 2012


Fee- Rs.3000/-
Instructions: -
Last date of submission of form 17/10/2012 (No form after the expiry of last date will be entertained).
Date of examination PB(A)- 30/10/2012, PB(B) 31/10/2012 and Time of Exam 11:00 AM to 2:00 PM.
Centre for this examination will be allotted in  Sahibzada Ajit Singh Nagar Only.
Fee can only be deposited at the Cash Counter, Head Office,Vidya Bhavan, Phase 8, Sahibzada Ajit Singh Nagar (Punjab).
Forms to be deposited at the concerned examination branch (Form Section).The candidate is advised to bring the original  pass  certificate of
matriculation level.
The Roll Numbers for this examination will be available after 25/10/2012 on  Board's Official Website-www.pseb.ac.in.The candidate  who  is
unable to get his/her roll number online can collect his/her roll number from the concerned examination branch by showing the fee receipt issued
by the Board, such candidates are advised to bring the original pass certificate of matriculation level and two passport size photographs.
Note: The Roll Numbers will not be dispatched through post. The candidate has to download his/her Roll Number from Website- www.pseb.ac.in
Attesting authorities: - School Headmasters/Principals/Board Members/Board Officers not below the Assistant Secretary and First Class Magistrate.

Regards
Ram Rati

Monday 1 October 2012

PSEB ECONOMICS (HUMANITIES GROUP)


ECONOMICS
(HUMANITIES GROUP)
Time : 3  Hours                                                                                   Theory: 70 Marks                                                                                                        CCE: 30 Marks
Total: 100 Marks
STRUCTURE OF QUESTION PAPER
1.       The Question Paper will cover whole of the prescribed syllabus.
2.       All Questions will be compulsory.
3.       The questions paper will comprise of 15 questions in total.
4.       The question paper will have 3 Sections A, B & C.
SECTION A
          This section will consist of Q. No. 1 which will be objective type consisting of 12 sub parts (i.e. 6 questions from Part A and 6 questions from Part B of syllabus). Each sub part carry 1 mark. Objective type questions may include questions with one word to one sentence answer/fill in the blank/true or false/multiple choice type questions.
SECTION B
          This section will consist of 10 short answer type questions (i.e. 4 questions from Part A and 6 questions from Part B of syllabus) carrying 3 marks each. Answer of each question should be given in 50-60 words. Out of 6 questions from Part-B one question will be numerical.
SECTION C
          This section will consist of 4 long answer type questions (i.e. 2 questions from Part A and 2 questions from Part B of syllabus) with internal choice carrying 7 marks each. Answer of each question should be given in 200-250 words. Out of 2 questions from Part-B one question will be numerical.

Syllabus
Units
Sec A
1 Mark Questions
Sec B
3 Mark Questions
Sec C
7 Mark Questions
Total
Marks
PART - A
Micro Economics

1
2
3
4
1
2
2
1
1
1
1
1
1 Q from Unit 1 & 2
1 Q from Unit 3 & 4

32



PART – B
Macro Economics
5
6
7
8
9
1
1
1
2
1
1
2
1
1
1
1 Q from Unit 5 & 6
1 Q from Unit 7,  8 & 9


38

Total
9
12
10
4
70




SYLLABUS
PART-A (INTRODUCTORY MICRO ECONOMICS)
Unit–1 INTRODUCTION
Micro Economics: Meaning; Difference between Micro and Macro Economics, Central Problems of an Economy, Production Possibility Curve and Opportunity Cost.
Unit-2 CONSUMER BEHAVIOUR AND DEMAND
i.         Consumer’s Equilibrium:- Meaning, Attainment of equilibrium through Utility Approach (one and two commodity case).
ii.       Theory of Demand: Meaning of Demand, Types of Demand: Individual and Market Demand, Determinants of Demand, Demand Schedule, Demand Curve, Movement along and shift in Demand Curve.
iii.      Price Elasticity of Demand: Measurement of Price Elasticity of Demand- Percentage, Total expenditure and Geometric method.

Unit-3 PRODUCER BEHAVIOUR AND SUPPLY
i.             Production-Meaning, Concept of Production, Function: Returns to Factor and Returns to Scale.
ii.           Theory of Supply: Meaning of Supply, Types of Supply: Individual and Market Supply, Determinants of Supply, Supply Schedule, Supply Curve, Law of Supply, Movement along and shifts in supply curve, Price Elasticity of Supply, Measurement of Price Elasticity of Supply; Percentage and geometric method.
iii.          Concepts of Costs: Short Run Cost Curves; Fixed and Variable Costs, Total, Average and Marginal Costs.
     Concepts of Revenue: Total, Average and Marginal Revenue and their relationship.
iv.          Producer’s Equilibrium with the help of MC and MR.

Unit-4 FORMS OF MARKET AND PRICE DETERMINATION
i.             Forms of Market: Perfect Competition, Monopoly, Monopolistic Competition-Their Meaning and Features.
ii.           Price Determination under Perfect Competition- Equilibrium Price, Effect of shifts in Demand and Supply.

PART-B (INTRODUCTORY MACRO ECONOMICS)
Unit-5 NATIONAL INCOME AND RELATED AGGREGATE
i.             Basic Concept and Measurement of National Income (introduction only)
ii.           Macro Economics: Meaning, Circular flow of Income,
Concepts of GDP, GNP, NDP, NNP (at market price and factor cost), National Disposable Income (Gross & Net); Private Income, Personal Income and Personal Disposable Income.
iii.          Measurement of National Income-Value Added Method, Income Method & Expenditure Method

Unit-6 DETERMINATION OF INCOME AND EMPLOYMENT.
i.             Aggregate Demand, Aggregate Supply and their Components.
ii.           Propensity to Consume and Propensity to Save (Average and marginal).
iii.          Meaning of Involuntary-Unemployment, Concept of Full Employment.
iv.          Determination of Equilibrium level of Income and Employment-Two sector model.
v.            Concept of Investment Multiplier and its working.
vi.          Problems of excess and deficient Demand. Measures to correct excess and deficient Demand, Availability of Credit, Change in Government Spending.

Unit-7 MONEY AND BANKING
i.         Money: Meaning, Evolution and Functions.
ii.       Central Bank: Meaning and Functions.
iii.      Commercial Banks: Meaning and Functions.
iv.      Recent significant reforms and issues in Indian Banking System; Privatisation and Modernization.

Unit-8 GOVERNMENT BUDGET AND THE ECONOMY
i.             Government Budget. Meaning and its Components, Objectives of Government Budget.
ii.           Budget Receipts – Revenue Receipts and Capital Receipts.
iii.          Budget Expenditure-Revenue and Ca pital Expenditure, Plan and Non-Plan Expenditure and Development and Non-Development Expenditure.
iv.          Balance Budget, Surplus Budget and Deficit Budget: Their Meaning and Implications; Types of Deficit Budget-Revenue Deficit, Fiscal Deficit and Primary Deficit(meaning and implications); Measures to contain different Deficits. Downsizing the role of Government: Meaning and Implications.

Unit-9 BALANCE OF TRADE AND BALANCE OF PAYMENTS.
i.             Foreign Exchange Rate: Meaning, Fixed and Flexible Exchange Rate System-Meaning, Merits and Demerits.
ii.           Determination of Flexible Exchange Rate System through Demand and Supply.
iii.          Balance of Payment Accounts; Meaning and Components.
iv.          A brief analysis about recent exchange rate issue.

PSEB 10+2 STRUCTURE OF QUESTION PAPER PUNJAB HISTORY AND CULTURE


3.  PUNJAB HISTORY AND CULTURE
Time: 3 hrs.                                                                                          Theory: 70 Marks
                                                                                                                  CCE: 30 Marks
                        Total: 100 Marks
STRUCTURE OF QUESTION PAPER
1.       There will be 22 questions in all. All questions will be compulsory.           
2.       Question No. 1 to 10 will carry 1 mark each. Answer to each question should be in about 1 - 15 words.                                                                               10 × 1 = 10                                       
3.       Question No. 11 to 15 will carry 3 marks each. Answer to each question should be in about 30- 35 words.                                                                                    5 × 3 = 15                            
4.    Question No. 16 to 20 will carry 5 marks each with 100% internal choice. Answer to each question should be in about 75-85 words.                                        5 × 5 = 25
5.       Question No. 21 & 22 will carry 10 marks each. Answer to each question should be in about 250 - 300 words. Three will be 100% internal choice in these questions. The paper setter should not set more than one such question from one chapter.       
                                                                                                                           2 × 10 = 20
TOPIC NO.
Questions carrying 1 mark
Questions carrying  3 marks
Questions carrying 5 marks
Questions carrying 10 marks
Total
1, 2, 3,4
4
2
2
1
30
5,6,7,8,9,
6
3
3
1
40
Total questions
10
5
5
2
22
Total marks
10
15
25
20
70

SYALLBUS
1.   The great Mughals and their legacy to the Punjab.
2.   Guru Nanak Dev Ji.
3.   Successors of Guru Nanak Dev Ji.
4.   Banda Singh Bahadur and his martyrdom.
5.   Sikhs became the Masters of the Punjab.
6.   The Punjab under Maharaja Ranjit Singh.
7.   The British occupation of the Punjab.
8.   Some famous Legends of the Punjab:-
a.   Puran Bhagat                    b.   Heer Ranjha
c.   Sohni Mahiwal
9.   Classical Literature of the Medieval period.

Syllabus 10+2 based on annual system for PSEB Students(GENERAL ENGLISH)

 1. GENERAL ENGLISH

                                                                                                      Theory: 50 marks
Time :- 3 hrs                                                                                       CCE: 25 marks
                                                                                                             Total: 75 marks
STRUCTURE OF QUESTION PAPER
Do all questions.
Part-A
1        Objective type question (13 questions) based on total syllabus.             13 marks

                                 Part-B (English Reader Book VI)                                 15 marks
2        a) Comprehension passage                                                                       8 marks
b) Essay type question (one out of two) from English Reader in about
   100 words.                                                                                             5 marks

 c) Translation from Vernacular into English.  (2 isolated sentences).         2 marks

Note:- A special question in lieu of translation for foreign students (To paraphrase a stanza in simple English.)

                     Part-C (Supplementary Reader)                                      17 marks
4        a) Short answer type questions (3 out of 5 questions)                        3x2= 6 marks
b) Essay type question (one out of two stanzas) from Supplementary
    Reader in about 100 words.                                                               4 marks

5        a) Reference to the context & explanation. (1 out of the 2 stanzas)          4 marks
b) Central Idea of a poem   (1 out of 2)                                                      3 marks

                                             Part – D                                                         5 marks
6             Do any one out of the following : Paragraph /application/ letter/Precis writing
Paragraph writing (descriptive only) (one)
Application/Letter (Personal/ (one)  
Precis writing (one)                                                                                         5 marks                                                                                 
                                 
MARKING SCHEME FOR COMPREHENSION

Sr.No.                   Questions                                                                     M.M. 8
           
1.                Name of the Writer and the Chapter                                         2 marks     
2.                Short Question                                                                         1 mark       
3.                 Short Question                                                                         1 mark       
4.                Match the two words with their meanings                               2 marks     
5.                Fill in the blank with a suitable word from the passage           1 mark       
6.                Give meanings in simple English (two)                                    1 mark       
                  








INSTRUCTIONS FOR OBJECTIVE TYPE QUESTION

Objective type question will cover the whole syllabus prescribed
Note :- All questions will be strictly based on the syllabus. 
All sub-questions are compulsory (marks-13)      
 
         Grammar: 7
          English Reader: 4        
       Supplementary Reader: 2

Q.1(a)   Do as Directed :
  • Change the Tense                                                                                          (1)
  • Change the Voice                                                                                           (1)
  • Change the Narration                                                                                     (1)
  • Use of same word as a Noun and as a Verb (only one)                                   (1)
  • Use of Prepositions and Determiners in sentences (two) from the text   (1+1=2)
  • Transformation of sentences                                                                          (1)
(b)  One line answer questions from English Reader-VI                                  4 marks
(c)  One line answer questions from Supplementary Reader-VI                      2 marks

General English
Syllabus

English Reader
1.       Monday Morning
2.       Swami and his Father
3.       All about a Dog
4.       Treasure from the Deep
5.       Maori Villages
6.       The Penguins
7.       Alfred Nobel
8.       The Easter Egg
9.       On Patrol
10.     Columbus Sails
11.     Fighting the Invisible
12.     Operation Indian Ocean
13.     Nehru's Will and Testament
14.     The Death of Socrates
Supplementary Reader
1.       The Diamond Necklace
2.       The Lost Child
3.       The Doctor's Word
4.       The School for Sympathy
5.       Tolstoy's Home
6.       On Saying ‘Please’
7.       Forgetting
8.       The Never-Never Nest
9.       Uncle Podger Hangs a Picture
10.     Reconciliation
11.     Fasting as Penance
12.     The Tank
13.     The Variety and Unity of India
Poems
i.        Where the Mind is Without Fear
ii.       Stopping by Woods on a Snowy Evening
iii.      Leisure
iv.      Say Not, the Struggle Naught Availeth
v.       The Daffodils
vi.      Indian Weavers
vii.     No Men are Foreign
Grammar
1.       Determiners and Prepositions
2.       Use of same words as a Noun and as a Verb
3.       Change the Tenses
4.       Voice
5.       Narration
6.       Transformation of Sentences
Composition
1.       Letter-Writing
2.       Paragraph-Writing
3.       Precis Writing