Political Science Honors Programme: Exam Instructions and Marks Distribution, Exams of Political Theory

Download Political Science Honors Programme: Exam Instructions and Marks Distribution and more Exams Political Theory in PDF only on Docsity!

MODIFIED CBCS CURRICULUM OF

POLITICAL SCIENCE HONOURS PROGRAMME

SUBJECT CODE = 11

FOR UNDER GRADUATE COURSES UNDER RANCHI UNIVERSITY

Implemented from

Academic Session 2019-

i

Members of Board of Studies of CBCS Under- Graduate Syllabus as per

Guidelines of the Ranchi University, Ranchi.

Session 2019-22 onwards

iiiiii

GENERIC ELECTIVE FOR STUDENTS OF OTHER DISCIPLINE

37 Semester I - Generic Elective (GE 1) 35 38 Semester II - Generic Elective (GE 2) 36 39 Semester III - Generic Elective (GE 3) 37 40 Semester IV - Generic Elective (GE 4) 38

COURSES OF STUDY FOR ABILITY ENHANCEMENT

COMPULSORY COURSE “AECC”

41 English Communication [100 Marks] 39 42 Hindi Communication [100 Marks] 40 43 AECC Non-Hindi + Matri Bhasha [50 + 50 Marks] 41 ANNEXURE 44 Distribution of Credits Semester wise for Hons/ General Programme 43 45 Sample calculation for SGPA for B.Sc./B.A./B.Com Honors Programme 44 46 Sample calculation for CGPA for B.Sc./B.A./B.Com Honors Programme 44 MARKS DISTRIBUTION FOR EXAMINATIONS AND FORMAT OF QUESTION PAPERS 47 Marks Distribution of Mid & End Semester Theory Examinations 45 48 Marks Distribution of Practical Examinations 45

49 Format of Question Paper for Mid Sem Examination of 15 Marks 46

50 Format of Question Paper for Mid Sem Examination of 25 Marks 47

51 Format of Question Paper for End Sem Examination of AECC NH + MB

of 50 Marks

52 Format of Question Paper for End Sem Examination of 60 Marks 49

53 Format of Question Paper for End Sem Examination of 75 Marks 50

54 Format of Question Paper for End Sem Examination of GE, SEC, General

& AECC Hindi/ English Communication of 100 Marks

Session 2019-22 onwards

COURSE STUCTURE FOR UNDERGRADUATE ‘HONOURS’ PROGRAMME

Table AI-1: Distribution of 164 Credits [*wherever there is a Practical there will be no tutorial and vice –versa.]

Course Papers Credits Credits Theory + Practical Theory + Tutorial I. Core Course (CC 1 to 14) Theory 14 Papers 14X4=56 14X5= Practical/Tutorial* 14 Papers 14X2=28 14X1= II. Elective Course (EC) A. Discipline Specific Elective (DSE 1 to 4) Theory 4 Papers 4X4=16 4X5= Practical/ Tutorial* 4 Papers 4X2=8 4X1= B. Generic Elective/ Interdisciplinary (GE 1 to 4) Theory 4 Papers 4X4=16 4X5= Practical/ Tutorial* 4 papers 4X2=8 4X1= III. Ability Enhancement Compulsory Courses (AECC)

1. English/ Hindi Communication 1 Paper 1X2=2 1X2=
2. Environmental Science 1 Paper 1x2=2 1x2=
3. Skill Enhancement Course (SEC 1 & 2) of the Core Course opted 2 Papers 2X2=4 2X2= Total Credit = 140 + 24 =164 140 + 24 = 164 Note: In the Academic Council Meeting of Ranchi University, Ranchi, held on 29.06.2019, it is resolved that Students will be offered Two Generic Elective Subjects (GE-A & GE-B) in C.B.C.S. U.G. Honours Courses of all streams, so that their ‘Eligibility for Admission’ in P.G., Vocational & Technical Courses in various Institutions is not hampered.

Table AI-1.1: Course structure for B.Sc./ B.A./ B.Com./B.Voc. (Hons. Programme)

Semester Honours Allied Ability Enhancement Total Credits (Core Courses) (Elective Courses) (Compulsory Courses) 14 Papers 8 Papers 4 Papers Sem-I C-1, C-2 GE-1A, GE-1B English Comm./ Hindi Comm. (6+6=12 Credits) (6+6=12 Credits) (02 Credits) 26 Credits Sem-II C-3, C-4 GE-2A, GE-2B EVS (6+6=12 Credits) (06 Credits) (02 Credits) 26 Credits Sem-III C-5, C-6, C-7 GE-3A, GE-3B SEC- (6+6+6=18 Credits) (06 Credits) (02 Credits) 32 Credits Sem-IV C-8, C-9, C-10 GE-4A, GE-4B SEC- (6+6+6=18 Credits) (06 Credits) (02 Credits) 32 Credits Sem-V C-11, C-12 DSE-1, DSE- (6+6=12 Credits) (6+6=12 Credits) 24 Credits Sem-VI C-13, C-14 DSE-3, DSE- (6+6=12 Credits) (6+6=12 Credits) 24Credits Total = 164 Credits

Session 2019-22 onwards

Table AI-2.2: Subject Combinations allowed for B. A. Generic Subjects:

S.No. Note: Any Two Subjects may be opted as GE Subject but only One from S.No.1 and 10 will be allowed, if desired. (^1) Anthropology / 10 Bengali / Geography / Urdu / Psychology / Sanskrit / Home Science / Ho / (^2) History Kharia / 3 Political Science Khortha / 4 Sociology Kurmali / (^5) Economics Kurux / (^6) Philosophy Mundari / 7 Mathematics Nagpuri / 8 Hindi Panch Pargania / (^9) English Santhali

Table AI-2.3 Semester wise Structure for End Sem Examinations of Generic Elective in History:

Sem Core Honours, Allied DSE, Compulsory AECC Courses Examination Structure Code Papers Mid Semester Theory (F.M.) End Semester Theory (F.M.) End Semester Practical/ Viva (F.M.) I (^) GE1 An Introduction to Political Theory +T (^) --- 100 --- II GE2^ Indian Govt. and Politics +T ---^100 --- III GE3^ Comparative Govt. and Politics +T ---^100 --- IV GE4^ Public Administration +T ---^100 ---

Session 2019-22 onwards

Table AI-2.4 Generic Subject Papers for B. A. Hons. Programme (164 Credits);

All Four Papers of Any Two Allowed Subjects to be opted leaving aside the papers of

Hons. Subject:

Generic Elective Subject GE 4 Papers Generic Elective Courses for Arts Stream (GE will be other than Core Subject opted Semester I GE Semester II GE Semester III GE Semester IV GE Hindi dyk vkSj lkfgR; +T vuqokn +T lkfgR; vkSj i=dkfjrk +T jpukRed ys[ku dh fo/kk,¡ +T English Academic Writing +T Language & Linguistics +T^ Literature: Poems & Short Stories +T^ Language, Literature & Culture +T Bengali History of Bengali Literature^ +T^ Bengali Poetry, Novel, Short Stories +T Bengali Poetry, Drama, Short Stories +T Bengali Poetry, Short Stories, Bengali Essay+T Urdu Study of Poet Nazir Akbarabadi +T Study of Short Story Writer Prem Chand +T Mass Media: Principles and Practice +T Study of Short Story Writer +T Sanskrit संˋृतʩाकरणएवंʩाकरणशा˓काइितहास+T भारतीयसंˋृितएवंराजनीित+T आयुवőदकीपरɼरा+T भाषािवǒान+T Ho dyk] lkfgR; ,oa laLd`fr^ +T^ ikjEifjd ok| ;a=^ +T^

kj[k.Mh leqnk; dk lkaLdfrd dsUæ +T gks leqnk; dh uR; 'kSfy;k¡ +T Kharia dyk] lkfgR; ,oa laLdfr +T ikjEifjd ok| ;a= +T kj[k.Mh leqnk; dk lkaLdfrd dsUæ +T [kfM+;k leqnk; dh uR; 'kSfy;k¡ +T Khortha dyk] lkfgR; ,oa laLdfr +T ikjEifjd ok| ;a= +T kj[k.Mh leqnk; dk lkaLdfrd dsUæ +T [kksjBk leqnk; dh uR; 'kSfy;k¡ +T Kurmali dyk] lkfgR; ,oa laLdfr +T ikjEifjd ok| ;a= +T kj[k.Mh leqnk; dk lkaLdfrd dsUæ +T dqjekyh leqnk; dh uR; 'kSfy;k¡ +T Kurux dyk] lkfgR; ,oa laLdfr +T ikjEifjd ok| ;a= +T kj[k.Mh leqnk; dk lkaLdfrd dsUæ +T dq¡M+q[+k leqnk; dh uR; 'kSfy;k¡ +T Mundari dyk] lkfgR; ,oa laLdfr^ +T^ ikjEifjd ok| ;a=^ +T^ kj[k.Mh leqnk; dk lkaLdfrd dsUæ +T eq.Mk leqnk; dh uR; 'kSfy;k¡ +T Nagpuri dyk] lkfgR; ,oa laLdfr^ +T^ ikjEifjd ok| ;a=^ +T^ kj[k.Mh leqnk; dk lkaLdfrd dsUæ +T ukxiqjh leqnk; dh uR; 'kSfy;k¡ +T Panch Pargania dyk] lkfgR; ,oa laLdfr +T ikjEifjd ok| ;a= +T >kj[k.Mh leqnk; dk lkaLdfrd dsUæ +T iapijxfu;k leqnk; dh uR; 'kSfy;k¡ +T Santhali dyk] lkfgR; ,oa laLdfr +T ikjEifjd ok| ;a= +T kj[k.Mh leqnk; dk lkaLdfrd dsUæ +T larky leqnk; dh uR; 'kSfy;k¡ +T Geography Geomorphology +Lab Human Geography +Lab Climatology^ +Lab^ Economic Geography +Lab History Environmental Issues in India^ +T^ Making of Contemporary India +T History of West Asia +T India and her Neighbours +T Psychology Introduction of psychology^ +Lab^ Social psychology +Lab Psychopathology +Lab Psychological Statistics +Lab Sociology Indian Society and Culture +T Social Movement in India +T^ Sociology of Religion +T^ Indian Sociological Theories +T Economics Principals of Microeconomics +T Principals of Macroeconomics +T Indian Economy +T Money Banking& Public Finance +T Anthropology Economic Anthropology +T Political Anthropology +T^ Anthropology of Religion +T^ Linguistic Anthropology +T Philosophy Indian Philosophy-I +T Indian Philosophy-II +T Indian Ethics +T Western Ethics +T Home Science Human Nutrition +Lab Entrepreneurship for small Catering units +Lab Current concerns in Public Health Nutrition +Lab Care and Wellbeing in Human Development +Lab Mathematics Differential Calculus & Coordinate Geometry 2D +T Integral Calculus, Vector Calculus & Trigonometry +T Real Analysis-I, Group Theory & Differential Equations +T Real Anaysis-II, Complex Variable, Set Theory & Matrices +T

Session 2019-22 onwards

IV. CORE COURSE –C 1: (Credits: Theory-05, Tutorial-01)

Marks : 25 (MSE: 1Hr) + 75 (ESE: 3Hrs)=100 Pass Marks (MSE + ESE) = Instruction to Question Setter for Mid Semester Examination (MSE): There will be two group of questions. Group A is compulsory and will contain five questions of very short answer type consisting of 1 mark each. Group B will contain descriptive typesix questions of five marks each, out of which any four are to answer. End Semester Examination (ESE): There will be two group of questions. Group A is compulsory and will contain two questions. Question No.1 will be very short answer typeconsisting of ten questions of 1 mark each. Question No.2 will be short answer type of 5 marks. Group B will contain descriptive typesix questions of fifteen marks each, out of which any four are to answer. Note: There may be subdivisions in each question asked in Theory Examinations.

AN INTRODUCTION TO POLITICAL THEORY

Theory: 75 Lectures; Tutorial:15 Lectures

1. Nature and significance of political theory

2. Traditional theory – meaning, characteristics, importance and limitation.

3. Modern Theory – meaning, characteristics, importance and limitations.

4. Origin and development of state system

5. Power and authority.

6. Sovereignty – monist and pluralist.

7. Liberty and equality.

8. Justice and rights.

Books recommended

 Lkedkyhu jktuhfrd fl)kUr & vksih xkok

 jktuhfrd 'kkL= ds fl)kUr & MkW-bdcky ukjk;.k

 jktuhfrd 'kkL= ds fl)kUr & MkW-,-lh diwj

 Modern Political Theory – S.P. Verma  Political Theory – Sushil Kumar Swami Mac Millan  Modern Political Theory – M.G. Gandhi

Session 2019-22 onwards

V. CORE COURSE- C 2: (Credits: Theory-05, Tutorial-01)

Marks : 25 (MSE: 1Hr) + 75 (ESE: 3Hrs)=100 Pass Marks (MSE + ESE) = Instruction to Question Setter for Mid Semester Examination (MSE): There will be two group of questions. Group A is compulsory and will contain five questions of very short answer type consisting of 1 mark each. Group B will contain descriptive typesix questions of five marks each, out of which any four are to answer. End Semester Examination (ESE): There will be two group of questions. Group A is compulsory and will contain two questions. Question No.1 will be very short answer type consisting of ten questions of 1 mark each. Question No.2 will be short answer type of 5 marks. Group B will contain descriptive typesix questions of fifteen marks each, out of which any four are to answer. Note: There may be subdivisions in each question asked in Theory Examinations.

INDIAN POLITICAL THOUGHT Theory: 75 Lectures; Tutorial:15 Lectures

1. Sources of the Indian Political Thought

2. Kautilya – Saptang and Mandal theory

3. Raja Ram Mohan Roy

4. Swami Vivekananda and Bal Gangadhar Tilak

5. Mahatma Gandhi – Satyagrah and Gram Swaraj

6. M.N. Roy- Socialism and Radical Humanism

7. Dr. B.R. Ambedkar- Political and Social ideas.

8. Vinoba Bhave – Sarvodaya and Bhoodan.

Books recommended

 Hkkjrh; jktuhfrd fpard & iq[kjkt tSu

 Hkkjrh; jktuhfrd fopkjd & ts-ih-lq/k

 Hkkjrh; jktuhfrd fopkjd & MkW-bdcky ukjk;.k

 Hkkjrh; jktuhfrd fopkjd & ih-ds-R;kxh

 Indian Political Thought – Ram Ratan & Ruchi Tyagi  Modern Indian Political Thought – S.P.Verma  Indian Political Thought – R.C. Gupta

Session 2019-22 onwards

Ecosystem and biodiversity services: Ecological, economic, social, ethical, aesthetic

and Informational value.

(5 lectures)

Unit 5 : Environmental Pollution

Environmental pollution : types, causes, effects and controls; Air, water, soil and noise

pollution

Nuclear hazards and human health risks

Solid waste management : Control measures of urban and industrial waste.

Pollution case studies.

(5 lectures)

Unit 6 : Environmental Policies & Practices

Climate change, global warming, ozone layer depletion, acid rain and impacts on human

communities and agriculture

Environment Laws: Environment Protection Act; Air (Prevention & Control of Pollution)

Act; Water (Prevention and control of Pollution) Act; Wildlife Protection Act; Forest

Conservation Act. International agreements: Montreal and Kyoto protocols and Convention

on Biological Diversity (CBD).

Nature reserves, tribal populations and rights, and human wildlife conflicts in Indian context.

(4 lectures)

Unit 7 : Human Communities and the Environment

Human population growth: Impacts on environment, human health and welfare.

Resettlement and rehabilitation of project affected persons; case studies.

Disaster management : floods, earthquake, cyclones and landslides.

Environmental movements : Chipko, Silent valley, Bishnois of Rajasthan.

Environmental ethics: Role of Indian and other religions and cultures in environmental

conservation.

Environmental communication and public awareness, case studies (e.g., CNG vehicles

in Delhi).

(3 lectures)

Unit 8 : Field work

Visit to an area to document environmental assets: river/ forest/ flora/fauna, etc.

Visit to a local polluted site-‐Urban/Rural/Industrial/Agricultural.

Study of common plants, insects, birds and basic principles of identification.

Study of simple ecosystems-‐pond, river, Delhi Ridge, etc.

(Equal to 4 lectures)

Session 2019-22 onwards

Suggested Readings:

 Raziuddin, M.., Mishra P.K. 2014, A Handbook of Environmental Studies, Akanaksha Publications, Ranchi.  Mukherjee, B. 2011: Fundamentals of Environmental Biology.Silverline Publications, Allahabad.  Carson, R. 2002. Silent Spring. Houghton Mifflin Harcourt.  Gadgil, M., & Guha, R.1993. This Fissured Land: An Ecological History of India. Univ. of California Press.  Gleeson, B. and Low, N. (eds.) 1999.Global Ethics and Environment, London, Routledge.  Gleick, P. H. 1993. Water in Crisis. Pacific Institute for Studies in Dev., Environment &Security. Stockholm Env. Institute, Oxford Univ. Press.  Groom, Martha J., Gary K. Meffe, and Carl Ronald Carroll.Principles of Conservation Biology. Sunderland: Sinauer Associates, 2006.  Grumbine, R. Edward, and Pandit, M.K. 2013. Threats from India’s Himalaya dams. Science, 339: 36--‐37.  McCully, P. 1996. Rivers no more: the environmental effects of dams(pp. 29--‐64). Zed Books.  McNeill, John R. 2000. Something New Under the Sun: An Environmental History of the Twentieth Century.  Odum, E.P., Odum, H.T. & Andrews, J. 1971.Fundamentals of Ecology. Philadelphia: Saunders.  Pepper, I.L., Gerba, C.P. & Brusseau, M.L. 2011. Environmental and Pollution Science. Academic Press.  Rao, M.N. & Datta, A.K. 1987. Waste Water Treatment. Oxford and IBH Publishing Co. Pvt. Ltd.  Raven, P.H., Hassenzahl, D.M. & Berg, L.R. 2012.Environment. 8th edition. John Wiley & Sons.  Rosencranz, A., Divan, S., & Noble, M. L. 2001. Environmental law and policy in India. Tripathi 1992.  Sengupta, R. 2003. Ecology and economics: An approach to sustainable development. OUP.  Singh, J.S., Singh, S.P. and Gupta, S.R. 2014. Ecology, Environmental Science and Conservation. S. Chand Publishing, New Delhi.  Sodhi, N.S., Gibson, L. & Raven, P.H. (eds). 2013. Conservation Biology: Voices from the Tropics. John Wiley & Sons.  Thapar, V. 1998. Land of the Tiger: A Natural History of the Indian Subcontinent.  Warren, C. E. 1971. Biology and Water Pollution Control. WB Saunders.  Wilson, E. O. 2006.The Creation: An appeal to save life on earth. New York: Norton.  World Commission on Environment and Development. 1987.Our Common Future. Oxford University

II. GENERIC ELECTIVE (GE 2A): (Credits: 06)

GE2A paper of First subject selected in Sem-I to be studied. Refer Table AI 2.4 for name of

papers and for Content in detail refer the Syllabus of Opted Generic Elective Subject.

---

III. GENERIC ELECTIVE (GE 2B): (Credits: 06)

GE2B paper of Second subject selected in Sem-I to be studied. Refer Table AI 2.4 for name of

papers and for Content in detail refer the Syllabus of Opted Generic Elective Subject.

---

Session 2019-22 onwards

V. CORE COURSE -C 4: (Credits: Theory-05, Tutorial-01)

Marks : 25 (MSE: 1Hr) + 75 (ESE: 3Hrs)=100 Pass Marks (MSE + ESE) = Instruction to Question Setter for Mid Semester Examination (MSE): There will be two group of questions. Group A is compulsory and will contain five questions of very short answer type consisting of 1 mark each. Group B will contain descriptive typesix questions of five marks each, out of which any four are to answer. End Semester Examination (ESE): There will be two group of questions. Group A is compulsory and will contain two questions. Question No.1 will be very short answer typeconsisting of ten questions of 1 mark each. Question No.2 will be short answer type of 5 marks. Group B will contain descriptive typesix questions of fifteen marks each, out of which any four are to answer. Note: There may be subdivisions in each question asked in Theory Examinations.

INDIAN GOVT. AND POLITICS Theory: 75 Lectures; Tutorial:15 Lectures

1. Indian Constitution: Salient Features and the concept of Basic Structure.

2. Preamble

3. Fundamental Rights and Duties, Directive Principles of State Policy

4. Union Executive : President and Prime Minister

5. Union Legislature : Lok Sabha and Rajya Sabha

6. State Government : Governor and Chief Minister

7. Supreme Court and High Court.

8. Amendment process of Indian Constitution.

Books recommended

 Hkkjrh; 'kklu ,oa jktuhfr & iq[kjkt tSu

 Hkkjrh; 'kklu ,oa jktuhfr & vkj-Bkdqj

 Hkkjrh; 'kklu ,oa jktuhfr & ts-lh-tkSgjh

 gekjk lafo/kku & Hkkypanz xksLokeh] dkWyst cqd fMiks

 Hkkjrh; 'kklu ,oa jktuhfr & rk;y vkaun] fnYyh

 Hkkjrh; lafo/kku ,oa 'kkld & ,e-oh-ik;yh

Session 2019-22 onwards

SEMESTER III 6 Papers

Total 100 x 6 = 600 Marks

I. SKILL ENHANCEMENT COURSE SEC 1: (Credits: Theory-02)

Marks : 100 (ESE: 3Hrs)=100 Pass Marks Th ESE = 40 Instruction to Question Setter for End Semester Examination (ESE): There will be objective type test consisting of hundred questions of 1 mark each. Students are required to mark their answer on OMR Sheet provided by the University.

ELEMENTARY COMPUTER APPLICATION SOFTWARES:

A Common Syllabus Prescribed by Ranchi University Theory: 30 Lectures

Objective of the Course

The objective of the course is to generate qualified manpower in the area of Information Technology

(IT) and Graphic designing which will enable such person to work seamlessly at any Offices, whether

Govt. or Private or for future entrepreneurs in the field of IT.

A. INTRODUCTION TO COMPUTER SYSTEM

Basic Computer Concept

Computer Appreciation - Characteristics of Computers, Input, Output, Storage units,CPU, Computer

System. (1 Lecture)

Input and Output Devices

Input Devices - Keyboard, Mouse, joystick, Scanner, web cam,

Output Devices- Soft copy devices, monitors, projectors, speakers, Hard copy devices, Printers – Dot

matrix, inkjet, laser, Plotters. (4 lectures)

Computer Memory and Processors

Memory hierarchy, Processor registers, Cache memory, Primary memory- RAM, ROM, Secondary

storage devices, Magnetic tapes, Floppy disks, hard disks, Optical Drives- CD-ROM, DVD-ROM,

CD-R, CD-RW, USB Flash drive, Mass storage devices: USB thumb drive. Managing disk Partitions,

File System. Basic Processor Architecture, Processor speed, Types of processor.

(5 lectures)

Numbers Systems and Logic Gates

Decimal number system, Binary number system, Octal number system, Hexadecimal number system,

Inter-conversion between the number systems. Basic Logic gates-AND, OR, NOT, Universal logic

gates- NAND, NOR

(3 lectures)

Computer Software

Computer Software- Relationship between Hardware and Software, System Software, Application

Software, Compiler, Names of some high level languages, Free domain software.

(2 Lectures)

Session 2019-22 onwards

SKILL ENHANCEMENT LAB- SEC 1 LAB

A. MS-WORD LAB ASSIGNMENT

1. Write down the following Paragraph OR any one provided by your teacher;

Without a doubt, the Internet is one of the most important inventions of modern times. The

Internet is a global interconnected computer networks which allow each connected computer to share

and exchange information with each other. The origins of the Internet can be traced to the creation of

Advanced Research Projects Agency Network (ARPANET) as a network of computers under the

auspices of the U.S. Department of Defense in 1969.

Apply following effects on The paragraph:

i. Paragraph font-size and font-type must be 12 Verdana.

ii. Paragraph alignment must be justified and double line spacing.

iii. Highlight the “(ARPANET)” with green color.

iv. Make the “Internet” keywords Bold and Italic.

v. Insert any “WordArt” and a symbol to your document.

vi. Insert a clipart to your document.

vii. Add following lines to your document:

Internet, Intranet, Extranet, URL, WWW, Networking, Protocols, HTTP, TCP/IP

2. Create a Table of following fields:

Name, Surname, Age, Gender, Job and apply the following effects

i. Insert 10 records

ii. Font size should be 12

iii. Title size should be 14

iv. Font type should be Times new Roman

v. Title color should be blue

vi. Text color should be black

vii. Table border should be 2

3. Write a letter on ‘Road Safety’ and send to ‘Multiple Recipients’ using mail merge.

4. Type the paragraph given below:

Today, the Internet is a public, cooperative and self-sustaining facility accessible to hundreds

of millions of people worldwide. Physically, the Internet uses a portion of the total resources of the

currently existing public telecommunication networks. Technically, what distinguishes the Internet is

its use of a set of protocols called TCP/IP (for Transmission Control Protocol/Internet Protocol). Two

recent adaptations of Internet technology, the intranet and the extranet, also make use of the TCP/IP

protocol. Today, the Internet is a public, cooperative and self-sustaining facility accessible to hundreds

of millions of people worldwide. Physically, the Internet uses a portion of the total resources of the

currently existing public telecommunication networks. Technically, what distinguishes the Internet is

its use of a set of protocols called TCP/IP (for Transmission Control Protocol/Internet Protocol). Two

recent adaptations of Internet technology, the intranet and the extranet, also make use of the TCP/IP

protocol.

Session 2019-22 onwards

Apply the following:

i. Change Internet into Internets at a time

ii. Heilight TCP/IP in red color

iii. Replace protocol into protocols

iv. Find the word “Public”

B. MICROSOFT EXCEL LAB ASSİGNMENT

Basic Formatting and Spreadsheet Manipulation

1. Add rows and columns to an existing spreadsheet

2. Reformat data (center, comma and currency styles, bold, text color)

3. Work with a simple formula (product) and function (sum)

Assignment

1. Create a workbook as shown below.

2. To enter new rows or columns, simply click on the row or column header to select the whole row

or column. Then right click with the mouse and choose insert.

3. Add the new row for S Spade with the data that’s shown below (between the original rows 7 and

4. Add a column for gender and the data as shown below (between the original columns A and B).

Enter the appropriate gender for yourself in the last row.

A B C D

Name Male/Female Genre Number of Songs

J Smith F Blues 50 B Doe M Country 110 S Spade F Country 200 F Zappa M Blues 1400 F Zappa M Alternative 2300 J Smith F Alternative 150 S Spade F Blues 1000 B Doe M Blues 75 yourname M Blues 800

5. Center the data in columns B and C. Do this by selecting the whole column and click the center

icon on the ribbon.

6. Bold the data in row 1, the column headings (ensure that the data all remains visible within the

column boundaries).

7. Change the font color for row 1 to Blue.

8. Change the format of the data in column D to comma style (no decimal places showing).There is

an icon on the home tab that sets it to comma style easily.

9. Add two new column labels to the right of the current columns; Unit Price and Total Cost. (They

will be in columns E and F.) These two columns of data should be currency type so that the dollar

sign is shown. There is an icon to quickly format the selected column as currency type.

10. All tunes are $.99, so enter that value for all rows in Column E. You can copy quickly by using the

Auto Fill handle and drag that amount down. When you over your mouse over the tiny square in