Bhagya

Secretary 11th Secretarial Practice Chapter 1 Solutions Maharashtra Board

Balbharti Maharashtra State Board Class 11 Secretarial Practice Solutions Chapter 1 Secretary Textbook Exercise Questions and Answers.

Class 11 Secretarial Practice Chapter 1 Exercise Solutions

1A. Select the correct answer from the options given below and rewrite the statements.

Question 1.
The word Secretary is derived from the Latin word ____________ which means a confidential writer.
(a) Amatya
(b) Scribae
(c) Secretarius
Answer:
(c) Secretarius

Question 2.
Only ____________ can be appointed as a Secretary.
(a) an Individual
(b) a Partnership firm
(c) a Joint-stock company
Answer:
(a) an individual

Question 3.
A Secretary is a custodian of ____________ information.
(a) confidential
(b) individual
(c) investigative
Answer:
(a) confidential

Question 4.
The Secretary of a Joint-stock company should be a member of ____________
(a) IPS
(b) ICSI
(c) IAS
Answer:
(b) ICSI

Question 5.
____________ is the oldest type of Secretary.
(a) Company Secretary
(b) Personal Secretary
(c) Secretary of Government Department
Answer:
(b) Personal Secretary

Question 6.
The main objective of a co-operative society is to ____________ the interest of its members.
(a) neglect
(b) takeover
(c) protect
Answer:
(c) protect

Question 7.
Secretary of Government department must be a member of the ____________
(a) ICSI
(b) IAS
(c) ICWA
Answer:
(b) IAS

Question 8.
____________ means correctness in doing a work.
(a) Accuracy
(b) Loyalty
(c) Courteous
Answer:
(a) Accuracy

1B. Match the pairs.

Question 1.

Group ‘A’	Group ‘B’
(a) Amatya	(1) Government department
(b) Ministry of Finance	(2) Paid employee
(c) Personal Secretary	(3) Appointed by busy persons
(d) Loyalty	(4) Roman Empire
(e) Financial duties	(5) Maintenance of books of accounts
(f) Secretary	(6) Faithfulness
	(7) Reveals information
	(8) Appointed by Co-operative societies
	(9) Ancient Indian history
	(10) Correspondence
	(11) Free service
	(12) Joint Stock company

Answer:

Group ‘A’	Group ‘B’
(a) Amatya	(9) Ancient Indian history
(b) Ministry of Finance	(1) Government department
(c) Personal Secretary	(3) Appointed by busy persons
(d) Loyalty	(6) Faithfulness
(e) Financial duties	(5) Maintenance of books of accounts
(f) Secretary	(2) Paid employee

1C. Write a word or a term or a phrase that can substitute each of the following statements.

Question 1.
The term was used in the Roman empire was for a person who was a professional letter writer.
Answer:
Scribae

Question 2.
The sports club is an example of this type of organization.
Answer:
Non-profit association

Question 3.
A Secretary appointed by an individual.
Answer:
Personal Secretary

Question 4.
The quality that a Secretary should possess is to be faithful to his organization.
Answer:
Loyalty

Question 5.
The Latin word for a Secretary.
Answer:
Secretarius

Question 6.
The Company Secretary must be a member of this organization.
Answer:
ICSI

Question 7.
The Secretary of a Co-operative organization in Maharashtra must have knowledge of this Act.
Answer:
Maharashtra State Co-operative Societies Act, 1960

Question 8.
An association that aims to protect the interest of its members.
Answer:
Co-operative society

1D. State whether the following statements are True or False.

Question 1.
A Secretary is responsible only for typing letters.
Answer:
False

Question 2.
The Secretary of a Government department is the oldest type of Secretary.
Answer:
False

Question 3.
The Secretary should remain confidential about his organization.
Answer:
True

Question 4.
A Secretary also looks after routine and administrative duties.
Answer:
True

Question 5.
A Secretary is a paid employee.
Answer:
True

Question 6.
Chitnis is a term used in the ancient Roman period.
Answer:
False

Question 7.
A Secretary need not have knowledge of computers.
Answer:
False

Question 8.
Cultural Association is an example of a Government department.
Answer:
False

1E. Find the odd one.

Question 1.
Secretarius, Scribae, ICSI, Chitnis
Answer:
ICSI

Question 2.
Leadership, IAS, Tactfulness
Answer:
IAS

1F. Complete the sentences.

Question 1.
In Latin language, a confidential writer was called as ____________
Answer:
Secretarius

Question 2.
The oldest type of Secretary is ____________ secretary.
Answer:
Personal Secretary/Personal Assistant

Question 3.
A company secretary must be a member of ____________
Answer:
ICSI (Institute of Company Secretaries of India)

1G. Select the correct option from the bracket.

Question 1.

Group ‘A’	Group ‘B’
(1) …………………	Personal Secretary
(2) Secretary of Government Department	………………………….
(3) ICSI	………………………….
(4) …………………	Scribae
(5) Custodian of secret	…………………….

(IAS, Appointed by busy individuals, Secretary, Roman Empire, Company Secretary)
Answer:

Group ‘A’	Group ‘B’
(1) Appointed by busy individuals	Personal Secretary
(2) Secretary of Government Department	IAS
(3) ICSI	Company Secretary
(4) Roman Empire	Scribae
(5) Custodian of secret	Secretary

1H. Answer in one sentence.

Question 1.
Who can appoint a personal secretary?
Answer:
Personal Secretary can be appointed by busy individuals, eg. Doctors, Lawyers, Engineers, Chartered Accountants, Actors, Politicians, Leaders, Ministers, etc.

Question 2.
Which company should appoint a full-time company secretary?
Answer:
Listed companies and all other companies with a paid-up share capital of five crores or more should appoint a full-time company secretary.

Question 3.
A Cultural Club is an example of which type of organization?
Answer:
A Cultural Club is an example of a Non-profit association.

Question 4.
The knowledge of which Act is a must for a secretary of Co-operative Society?
Answer:
A secretary of a co-operative society should have a good knowledge of the Co-operative Societies Act.

1I. Correct the underlined word and rewrite the following sentences.

Question 1.
Personal Secretary is appointed by a Joint Stock Company.
Answer:
Personal Secretary is appointed by a busy individual.

Question 2.
Busy individuals appoint Company Secretary.
Answer:
Busy individuals appoint Personal Secretary.

Question 3.
The Secretary of a Government Department must be a member of ICSI.
Answer:
The Secretary of a Government Department must be a member of IAS.

Question 4.
The term Chitnis was used in Roman Empire.
Answer:
The term Chitnis was used in Ancient Indian history.

2. Explain the following terms/concepts.

Question 1.
Secretary
Answer:
An individual employed to handle general administration, office management, correspondence, and confidential information of an organization.

Question 2.
Confidential officer
Answer:
Secretary is entrusted with the secret and confidential information of his employer and of the business itself.

Question 3.
Compliance officer
Answer:
A secretary must stick to or comply with various sets and its provisions that are applicable to the business like maintaining books, filing returns, etc.

Question 4.
Tactfulness
Answer:
An ability of a person to handle a situation in the right manner. Secretary must handle the different situations and people insensible way.

Question 5.
Loyalty
Answer:
Loyalty means faithfulness. As a confidential officer, a secretary should not share secret matters with anyone.

3. Study the following case/situation and express your opinion.

1. Rajiv and Sanjiv have applied for the post of Company Secretary at Pharma India Pvt. Ltd. Rajiv has experience of 10 years as a Personal Secretary. He later worked as a Secretary at Venus Co-operative Bank for 2 years. Sanjiv has passed his CS examination and is a member of ICSI. He has no working experience. Rajiv is only a commerce graduate.

Question (a).
Who is better suited for the above post? Justify your answer.
Answer:
Sanjiv is suited for the post as he has passed his CS exams and is a member of ICSI which is the basic qualification for a company secretary according to the Companies Act, 2013.

Question (b).
Can Rajiv be selected as a Personal Assistant for one of the Directors?
Answer:
Yes, Rajiv has experience of 10 years as a personal secretary, hence he can be able to assist the director.

Question (c).
Can Rajiv be appointed as Secretary to Pharma India Pvt Ltd.?
Answer:
No, Pharma India Pvt. Ltd. is a private company that can appoint a Company Secretary for its work. Rajiv has experience as a personal secretary so he cannot be appointed as a secretary to Pharma India Pvt. Ltd.

2. Harshada has cleared her CS examination and intends to make her career as a Secretary at the Government department.

Question (a).
Can she apply for the post of Secretary at Government Department?
Answer:
No, a secretary of the Government department must have a clear Civil Services Examination and must be in Indian Administrative Services.

Question (b).
Can she be appointed as the Secretary of ABC Ltd.?
Answer:
Yes, she can be appointed as the secretary of ABC Ltd which is a company, and shehasclearedherCS examination.

Question (c).
As a Company Secretary will Harshada be considered as an employee?
Answer:
Yes, a company secretary is a full-time employee and gets a salary as determined by the Board of Directors.

4. Distinguish between the following.

Question 1.
Personal Secretary and Company Secretary
Answer:

Basis	Personal Secretary	Company Secretary
1. Meaning	An individual appointed by a busy person to assist him.	An individual appointed by the Board of directors to carry out various duties in a Joint Stock Company.
2. Appointment	Personal Secretary is appointed by a busy person or professionals.	Company Secretary is appointed by the Board of Directors.
3. Qualification	There is no prescribed qualification for a personal secretary.	The company secretary must be a member of ICSI.
4. Legal Status	A personal secretary has no legal status.	The company secretary possesses legal status.
5. Powers	The personal secretary has limited powers as given by the employer.	The company secretary has statutory and managerial powers.
6. Purpose	To assist a busy person in his day-to-day work.	To assist the Board of directors in taking decisions and executive functions.
7. Position	The personal secretary is an assistant of the employer.	The company secretary is one of the members of Key Managerial Personnel.

Question 2.
Secretary of Co-operative Society and Secretary of Government Department
Answer:

Basis	Secretary of Co-operative Society	Secretary of Government Department
1. Meaning	Secretary of Co-operative Society is one of the members of the managing committee appointed to carry out the working of the society.	An officer who works under the guidance of the minister or the department.
2. Appointment	He is appointed by the managing committee.	He is appointed by the State or Central government.
3. Qualification	There is no prescribed qualification.	He must have passed an IAS exam.
4. Position	The secretary is a member of society.	The secretary is the administrative head of his department.
5. Purpose	He has to protect the interest of his members.	He has to carry out administrative work under the control of the minister.
6. Remuneration	He is a member of the managing committee and gets an honorarium.	He gets salary and perks as per the Government rules.

Question 3.
Company Secretary and Secretary of a Government Department
Answer:

Basis	Company Secretary	Secretary of Government Department
1. Meaning	Secretary appointed by the Board of Directors to carry out statutory and managerial duties.	Secretary appointed by State or Central government to handle the work of different government departments.
2. Qualification	He must be a member of ICSI.	He must have passed an IAS exam.
3. Appointment	He is appointed by the Board of directors.	He is appointed by the Central or State government.
4. Powers	He has administrative and managerial powers.	He has statutory powers as per the ministry.
5. Purpose	He has to assist the Board of directors in taking decisions.	He has to assist the ministers in carrying out administrative work.
6. Remuneration	He is paid a salary as decided by the Board of Directors.	He is paid salary and perks as per government rules.

Question 4.
Secretary of Non-profit Association and Secretary of Co-operative Society.
Answer:

Basis	Secretary of Non-profit Association	Secretary of Co-operative Society
1. Meaning	A person appointed to look after the working of the association.	Secretary is one of the members of the managing committee appointed to look after the working of the society.
2. Appointment	Secretary is appointed by the managing committee of the association.	Secretary is appointed by the managing committee of the society.
3. Legal Status	The secretary has no legal status.	Secretary has legal status as per the Co-operative Societies Act.
4. Power	He has limited powers.	He has power as per the Co-operative Societies Act.
5. Compulsory	It is not compulsory. It is optional to appoint a secretary.	The appointment of a secretary is compulsory as per the Act.
6. Object	The main objective is to promote social, cultural, and sports activities.	The main objective is to protect the interest of its members.

5. Answer in brief.

Question 1.
Describe any four qualities of a Secretary.
Answer:
Qualities of a Secretary are as follows:

1. Accuracy: A secretary must be accurate in his work like accuracy in office work, record keeping, drafting letters, reports, etc.
2. Loyalty: A secretary should be loyal. He is a custodian of secret information about his business. He should not disclose the secret of the business to outsiders.
3. Adaptability: There are many changes that take place within the business and outside the business. A secretary must adapt himself to every situation and should be ready for every challenge.
4. Leadership: As a leader, a secretary should be able to guide, advise and direct the subordinates. He should create team spirit among his subordinates.

Question 2.
State any four functions of a Secretary.
Answer:
The functions of a Secretary are as follows:

1. Correspondence: It is a basic function of the secretary. He drafts letters, handles inward and outward mails, types letters, files important correspondence. He must handle correspondence well so as to maintain the goodwill of the business.
2. Reception functions: A secretary courteously attends to the visitors, telephone calls, arrange meetings, fix appointments, etc.
3. Financial functions: Secretary handles the financial transactions and maintains proper books of accounts. He handles banking transactions like depositing money, withdrawing money from the bank, issuing cheques and demand drafts, etc.
4. Administrative functions: Secretary performs administrative functions like supervising and controlling the activities of the business, effective coordination, training, orientation, promotion of employees.

Question 3.
Mention any four features of a Secretary.
Answer:
Features of a Secretary are as follows:

1. Individual: Only an individual can be appointed as a secretary. A partnership firm, corporate body, or institution cannot be appointed as a secretary.
2. Employee: Secretary is a paid employee of the business. He is given a salary or honorarium for the work or task done by him.
3. Confidential officer: A secretary is the custodian of the secret or confidential information of his employer and business.
4. Appointment: A secretary can be appointed by a busy person, Co-operative society, Non-profit association, Government, Joint Stock company, etc.

6. Justify the following statements.

Question 1.
A secretary should be courteous and have a pleasing personality.
Answer:

1. A secretary should be courteous as he deals with people within and outside the organization.
2. As he gets the plans executed in the business he must be kind and polite with fellow workers.
3. As a secretary represents the business to outsiders and as a leader within the business, he must have a pleasing personality with confidence and the ability to tackle challenging situations.
4. Thus, a secretary should be courteous and have a pleasing personality.

Question 2.
A secretary is considered a paid employee.
Answer:

1. A secretary is a paid employee of the business.
2. He works as a secretary and receives a salary or honorarium in return.
3. He is not the owner but works for them.
4. Thus, a secretary is considered a paid employee.

Question 3.
Only individuals can be secretaries.
Answer:

1. A secretary is always an individual.
2. Only a person can perform the work of a secretary.
3. A corporate body, institution, or partnership firm cannot be appointed as a secretary.
4. Thus, only individuals can be secretaries.

Question 4.
A secretary is a link between the staff and members.
Answer:

1. With the help of effective communication, the secretary strikes a balance between the staff and members.
2. The plans, policies, and decisions made by the top-level are communicated to the staff, which helps inefficient working of the business.
3. Thus, a secretary is a link between the staff and members.

Question 5.
A personal secretary is appointed by busy individuals.
Answer:

1. A personal secretary is appointed by busy persons to handle their day-to-day work.
2. Professionals and busy persons appoint a secretary so that routine work is handled by the secretary and they can focus on other important work.
3. Thus, a personal secretary is appointed by busy individuals.

7. Answer the following questions.

Question 1.
Define a Secretary and explain the importance of a secretary.
Answer:
According to Oxford Dictionary “A person whose work is to write for others, especially one who is employed to conduct correspondence, keep records and to transact various other business for another person or for a society or corporation or public body.”

The importance of a secretary are:
(i) Provide guidance and advice:
The secretary provides guidance to the management for efficient working and achieving goals. He also gives advice to the superior on important matters and helps them to take the correct decision.

(ii) Custodian of secret information:
The secretary is closely connected with top management and has access to all the secret and confidential information about the business. He safeguards confidential documents and decisions of the business.

(iii) Correspondent:
Secretary handles all the inward and outward mails of the business. He conducts correspondence with members, directors, registrar, bank, government authorities, etc.

(iv) Conducting meetings:
Secretary carries out all formalities before, during, and after the meeting. He prepares notice, agenda, minutes, etc., and makes all the arrangements for the meetings.

(v) Administrator:
Secretary handles office administration and routine management work efficiently. On behalf of the employer, he looks after the working of day to day work of the business.

(vi) Legal officer:
Secretary performs various statutory duties. He prepares books, reports, registers, documents as prescribed by the Companies Act, 2013.

(vii) Link between management and staff:
The secretary is a link between management and staff. He maintains a balance between management and staff through effective communication and proper coordination.

Question 2.
Explain the features of a secretary.
Answer:
The features of a secretary are as follows:

1. Individual: Only an individual can be appointed as a secretary. An organization, firm, society, or corporate body cannot be appointed as a secretary.
2. Employee: Secretary is not the owner of the business. He is a paid employee. Secretary works in the business and expects salary or honorarium for the work done by him.
3. Custodian of secret information: The secretary has custody of all the secret information of the business as he is closely connected with the top-level management.
4. Appointment: Secretary can be appointed by busy persons, professionals, non-profit associations, co-operative society, or Joint Stock companies.
5. Qualities: In order to perform his duties efficiently a secretary must possess qualities like intelligence, accuracy, loyalty, Courtesy, etc.

Question 3.
Describe the qualities of a secretary.
Answer:
The qualities of a secretary are as follows:

1. Accuracy: It means correctness. While corresponding, preparing reports and records, books of accounts, and register the secretary must be accurate in his work.
2. Adaptability: Secretary must have the ability to adjust with the change within and outside the business like change in management rules and policies, change in government policies, etc.
3. Loyalty: Secretary has access to all the secret information of the business. He must be faithful and not disclose the information to anyone.
4. Cooperative: Secretary works with the people and through the people. He should instill the feeling of team spirit and oneness.
5. Punctuality: Secretary must have a sense of time. He must complete the work on time. If the work is delayed it would affect the growth of the business.
6. Piteasing personality: Secretary must have an impressive and confident personality. With decent behaviour, a good temper, and a positive approach, he can gain respect from others.
7. Tactful: A secretary handles different people and situations. He should be able to handle situations wisely and deal with people in a sensible way.

Question 4.
Explain briefly the various types of Institutional secretaries.
Answer:
Types of Institutional secretaries:
(i) Secretary of a Non-profit Association:
The non-profit association is formed to provide service and not to earn profits. The managing committee looks, after the working of Non-profit association. The Secretary of a Non-profit association is appointed by the managing committee on a salary or honorarium basis. There is no prescribed qualifications of the secretary of the Non-profit association however, knowledge of correspondence, banking transactions, knowledge of computers are expected in these associations.

(ii) Secretary of a Co-operative Society:
It is a voluntary organization formed for the welfare of its members. Managing committee handles or manage the working of the society. One of the members of the managing committee is appointed as a secretary. Secretary of Co-operative society can be appointed as a full-time employee. Secretary must have full knowledge of all the provisions of the Co-operative Societies Act.

(iii) Secretary of a Government Department:
The Secretary of a Government department is appointed by the Central or State Government. Secretary handles the work of various government departments on behalf of the ministers and act as an administrative head of the department. The secretary of the government department should be a graduate and be in Indian Administrative Services [IAS].

(iv) Secretary of a Joint Stock Company:
The Secretary of a Joint Stock company holds a key managerial position and handles the business on behalf of the members. Secretary of a Joint Stock Company is appointed by the Board of Directors. According to the Companies Act, 2013 the Companies Secretary must be a member of the Institute of Company Secretaries of India (ICSI). Joint Stock Company works on a large scale, hence, full-time secretary handles day-to-day work on behalf of the Board of directors.

Activity 1. (Textbook Page No. 9)

Find out the following:

1. Company Secretary of Mahindra and Mahindra Ltd.
2. Principal Secretary of Prime Minister of India.
3. Chief Secretary, Maharashtra State.
4. Secretary, School Education Department, Government of Maharashtra.

Answer:

1. Narayan Shankar
2. Pramod Kumar Mishra
3. Sitaram Kunte
4. Vishal Solanki (IAS)

Activity 2. (Textbook Page No. 9)

Atmaram Bendre is a Secretary of Gokulghar Housing Society, Enlist his duties.
Answer:
Duties of a Secretary performed by Atmaram Bendre residing at Gokulghar Housing Society, Malad (W), Mumbai are as follows:

1. To hold a monthly meeting of Managing Committee.
2. To prepare notice along with agenda and issue to members of the managing committee.
3. To record and maintain minutes book of the managing committee.
4. To assist the chairman before, during, and after the meeting.
5. To issue a Share certificate to members of the Co-operative Housing Society.
6. To transfer Share certificate within a given period of time.
7. To maintain books relating to the resignation and transfer of members of society.
8. To examine the documents related to transferring flats.
9. To take appropriate actions against default members by giving legal notice, if any.
10. To maintain accounting records required for auditing.
11. To finalize the audit report.
12. To utilize the sinking fund of the society with prior approval of members of society for repair, maintenance internal leakage problem, etc.
13. To give No Objection Certificate for flat agreement of sale or any kind of loans on flat.
14. To abide bye-laws as guided by Co-operative Housing Society Act, 1960.
15. To maintain all correspondence records, files, documents, etc.
16. To issue notice to the member who breaches the bye-laws of the society.
17. To maintain records for the societies such as account records, statutory records, and membership records.
18. To produce records as and when required by the government authorities with the consent of members.
19. To issue allotment or cancellation letter as required by the members of the society.
20. To take contingency meetings as and when required in the event of an emergency.

Maharashtra State Board 11th Std Secretarial Practice Textbook Solutions Digest

• 11th Secretarial Practice Chapter 1 Practical Problems
• 11th Secretarial Practice Chapter 2 Practical Problems
• 11th Secretarial Practice Chapter 3 Practical Problems
• 11th Secretarial Practice Chapter 4 Practical Problems
• 11th Secretarial Practice Chapter 5 Practical Problems
• 11th Secretarial Practice Chapter 6 Practical Problems
• 11th Secretarial Practice Chapter 7 Practical Problems
• 11th Secretarial Practice Chapter 8 Practical Problems
• 11th Secretarial Practice Chapter 9 Practical Problems
• 11th Secretarial Practice Chapter 10 Practical Problems
• 11th Secretarial Practice Chapter 11 Practical Problems
• 11th Secretarial Practice Chapter 12 Practical Problems

DBMS (PostgreSQL) 11th Information Technology Practicals Skill Set 6 Solutions Maharashtra Board

Balbharati Maharashtra State Board Class 11 Information Technology Solutions Practicals Skill Set 6 DBMS (PostgreSQL) Textbook Exercise Questions and Answers.

Class 11 Information Technology Practicals Skill Set 6 Exercise Solutions

SOP 1: Create a database, using Postgres SQL named hospital.

• In this database, create a table of patients with the following fields
  Patient_ID, Patients_Name, Address, Room_number and Doctor’s_name.
• Give appropriate data type for each field.
  

Answer:
Step 1: Open Command Terminal. Switch over to the Postgres account on your server by typing.
$ sudo -i -u Postgres

Step 2: You can now access a Postgres prompt immediately by typing.
$ psql

Step 3: To create a database hospital;
create database hospital;

Step 4: Connect to Database using \c
\c hospital;

Step 5: Create a table in the database. Create Table Command is used.
create table patients(patients_Id Integer,patients_name text,Address text,Room_number integer,Doctor_name text);

Step 6: Let’s see the result of the patient’s table.
select * from patients;
or
\d patients;

SOP 2: Create a database using PostgreSQL named Schoolmaster.

• In this database create a table of students with the following fields
  student_ID, student_name, Address, Phone_number, Date_of_Birth.
• Give appropriate data types for each field. Enter at least 5 records.

Answer:
Step 1: Create a database School-Master.
create database school_master;

Step 2: Now To connect the database use \c Command.
\c database school_master;

Step 3: Create a table of students with the following fields.Give appropriate data type for each Field.
student_ID, student_name, Address. Phone_number, Date_of_Birth.
create table students(student_ID integer, student_name text,Address_text,Phone_number integer,Date_of_Birth date);

Step 4: Enter at least 5 records.
Insert into students values(001,’ZAHRA LALANIVMAZGAON’,123456789,’20-08-2000’);
Insert into students values(002,’MUHAMMAD LALANI’/BYCULLA’, 987654210,’30-01-2000’);
Insert into students values(003,’KUNAL KAPOOR’,’WALKESHWAR’, 987224210,T5-7-2000’);
Insert into students values(004,’AKSHAY SINGH’,’CHARNI ROAD’. 937224210,’19-6-2000’);
Insert into students values(005,’RUKHSHAR BANU ’,’DIWANPARA’, 937226210,’18-8-2000’);

Step 5: Show all records using select command
seleet*from students:

SOP 3: Given the list of fields: Empld, EmpName, EmpDepartment, Salaryld, Salary Amount, Bonus in the tables Employee and Salary respectively. Define primary key, foreign key and segregate for above fields into employee and salary table. Also create a one-to-one relationship between Employee and Salary Table.
Answer:
Step 1: Create a school database
Create database school;

Step 2: connect to database \c databasename;
\c school;

Step 3: In this database create two tables Employee and Salary with the following fields. Define primary key, foreign key and segregate for above fields into employee and salary table. Empld, EmpName, EmpDepartment, Salaryld, SalaryAmount, Bonus.
Create table salary(salaryld Integer PRIMARY KEY,Salaryamount integer,Bonus integer);
Create table employeefEmpId integer PRIMARY KEY,EmpName text,EmpDept text,Salaryld integer,FOREIGN KEY(salary ID)”REFERENCES Salaryfsalary id));

Step 4: See both tables
select*from salary;
select*from employee;

Information Technology 11th Std Skill Oriented Practicals (SOP)

• 11th Information Technology Practicals Skill Set 1 Practical Problems
• 11th Information Technology Practicals Skill Set 2 Practical Problems
• 11th Information Technology Practicals Skill Set 3 Practical Problems
• 11th Information Technology Practicals Skill Set 4 Practical Problems
• 11th Information Technology Practicals Skill Set 5 Practical Problems
• 11th Information Technology Practicals Skill Set 6 Practical Problems

Digital Content Creation (GIMP, Inkscape) 11th Information Technology Practicals Skill Set 5 Solutions Maharashtra Board

Balbharati Maharashtra State Board Class 11 Information Technology Solutions Practicals Skill Set 5 Digital Content Creation (GIMP, Inkscape) Textbook Exercise Questions and Answers.

Class 11 Information Technology Practicals Skill Set 5 Exercise Solutions

SOP 1: Use of Toolbox and editing an image using GIMP.

• Create an image by using Toolbox controls from GIMP.
• Insert the image in an already created image.

Answer:
Step 1: Click GIMP Image Editor

Step 2: Create a blank New image
File → New (Ctrl + N)

Step 3: Change the foreground and background colour uses the Blend Tool.

Step 4: We will create a kid’s cap using toolbox controls.

Step 5: Draw colour oval (Ellipse). Change the background colour and foreground colours with three different Ellipse(oval) . Create a layer for each and every Ellipse.

Step 6: To add text, you’ll need to access your “Text Tool”. You can find your Text Tool in your Toolbox window.

Step 7: To make this image visible to people larger, select your “Scale Tool” from your Toolbox window.

Step 8: To save your image select Export as, select proper type, and click on export.

Step 9: Insert the image in an already created image.
Click on File → Open → Image → As Layer.
Move the image to the desired location and merge to the original image.

SOP 2: Use GIMP for the following.

• Create a new image
• Put your name using the text tool.
• Use various filters to make a logo of your name.
• Auto crop image to text size.

Answer:
Use of Toolbox and editing an image using GIMP.
Create an image by using Toolbox controls from GIMP.

Step 1: click on the GIMP image Editor icon

Step 2: Create blank image File → Text document (Ctrl+N)

Step 3: Creates balloon image having very attractive colours using toolbox controls.

Step 4: Now change the foreground and background colour using the Blend tool (shot cut L). Drag the mouse from left to right on your canvas after release the mouse canvas will be filled by the gradient of foreground and background colour.

Step 5: Next click on the Text Tool (Short cut T)

Step 6: Using the Move tool, we can move the text roughly to the center of the image but instead we prefer to put it precisely in the center using the Align tool. Click on align tool (Short cut Q) and then select the text Layer and text.

Step 7: Drawing coloured oval (Ellipse). Change the background and foreground colours again with two different colours. We have to choose red and yellow colour respectively.

Step 8: Using the move tool place these ovals near the text. Select the layers one by one and merge them.
Layer → Merge Down. Now we have colourful single layer. Let us create a ballon from the canvas.

Step 9: Do Filters → Map → Map Object. Check ‘Update preview live’ and uncheck the ‘Transparent Background’.

Step 10: We will tweak the balloon further and give it a more realistic shape. Apply the Distort Filter with curve Bend option, i.e, Filter → Distort → Curve Bend. In the resulting dialog choose automatic preview and Lower curve border. Then drag the Mid Point of the Curve Indicator line using the mouse.

SOP 3: Use Inkscape for the following.

• Draw a simple landscape using basic geometric shapes.
• Use gradient tool for the same.

Answer:
Step 1: Select the tool button from the left toolbar showing the circle icon.

Step 2: Drag it with the mouse to any place in the client area. You will get an ellipse. To get the exact shape, press the CTRL key while dragging.

Step 3: After the ellipse is complete choose the selection tool from the left toolbar, then click on the ellipse, it will show 8 size handles. You can resize it by dragging those handles.

Step 4: To fill the ellipse with color, just click on any color given in the bottom color palette. Also, you can click on Menu object → Fill and stroke. It will give RGB color options, you can use any combinations from it.

SOP 4: Use Inkscape for the following.

• Load an Id size image,
• Make 12 copies of it.
• Arrange in 4 rows × 3 columns on an A4 size page.

Answer:
Step 1: Open Inkscape Vector Graphics Editor.

Step 2: File → New (Ctrl +N). Now Click on Document properties and select paper size A4.

Step 3: Import a bitmap or Svg Image into this document (Ctrl+l)

Step 4: Create 12 copies of it (4 rows and 3 columns) Create duplicate (Ctrl + D) images and set them in the proper grid.

Step 5. Arrange in 4 rows and 3 columns on an A4 size page.

SOP 5: Use Inkscape for the following.

• You are starting a new business.
• Create an advertisement to be published in a local newspaper promoting your product or services.
• Size should be 210 × 210 mm.
• Create your own visiting card using Inkscape.

Answer:
Steps to create advertisement:

Step 1: Choose a distinctive font and type some articles.

Step 2: Resize the text and press the long CTRL key to preserve the aspect ratio.

Step 3: Then outset it (Path → Outset)

Step 4: Change the color and resize down to the size.

Step 5: Now duplicate the text for the border.

Step 6: Color the duplicate temporarily in any random, non-white color (we need to see it over the white background) and move it under the initial text.

Step 7: Apply the outset effect (no need to resize this time, we are working on a rough border) and make it white.

Step 8: Duplicate the white border and make the duplicate black.

Step 9: Move the black duplicate at the bottom of the stack and shift it one or two pixels down and to the left for a drop shadow effect.

Step 10: Open the “Fill and Stroke” dialog and add a bit of Gaussian Blur and decrease the opacity.

Step 11: Post your finished work.

Steps to Create Visiting Card:

Step 1: To create a new empty document, use File → New → Default or press Ctrl+N.
To use File → New → Templates… or press Ctrl+Alt+N

Step 2: To click on document properties (Shift+Ctrl=D) and select Business card paper size.

Step 3: Click on the text menu and select Align and Distribute to align the card.

Step 4: Use the snap to the page border tool and Drag the Rectangles on the card.

Step 5: Specify the Height and width in inches. Width=3.75 Height=2.25

Step 6: Select the rectangle → Open Fill and stroke Toolbar → select linear gradient tool to show a border. Align the content.

Step 7: Set the ruler position.

Step 8: Create Layers. Now Draw the Circle on the card and set the fill and stroke properties.

Step 9: Change the object colour and create a duplicate object (ctrl+D)

Step 10: Select both objects → to go to the path menu → select difference. Now Select the Second object → to create duplicated object → change the object colour.

Step 11: Select Second duplicate Object → path → select difference → select flip selected object.
Select Edit Text Object Control → Type your Name, your website, Email ID, Phone in one, and Insert Logo.

SOP 6: Using Inkscape make the following picture.

Answer:
Step 1: Open Inkscape Vector Graphics Editor File → New

Step 2: Select Circles, Ellipses to create circles.

Step 3: Change the colours of the object. Use Draw freehand line tool.

Step 4: For the middle body, again click on the ellipse, select white color and click and drag on the place you want.

Step 5: For Head again choose ellipse tool ALT + CTRL to create a perfect circle, resize it and drag it on the proper place.

Step 6: For eyes, zoom in and choose the circle tool, select the proper color, press ALT+CTRL to resize it, and choose another circle, set black color, and draw a circle inside it.

Step 7: Press CTRL+D to make a duplicate and place it on another side.

Step 8: Create Hands. Create duplicate images → path → differences.

Step 9: Create legs using star tools → merge all starts → path → union.

Information Technology 11th Std Skill Oriented Practicals (SOP)

• 11th Information Technology Practicals Skill Set 1 Practical Problems
• 11th Information Technology Practicals Skill Set 2 Practical Problems
• 11th Information Technology Practicals Skill Set 3 Practical Problems
• 11th Information Technology Practicals Skill Set 4 Practical Problems
• 11th Information Technology Practicals Skill Set 5 Practical Problems
• 11th Information Technology Practicals Skill Set 6 Practical Problems

Accounting Package (GNUKhata) 11th Information Technology Practicals Skill Set 4 Solutions Maharashtra Board

Balbharati Maharashtra State Board Class 11 Information Technology Solutions Practicals Skill Set 4 Accounting Package (GNUKhata) Textbook Exercise Questions and Answers.

Class 11 Information Technology Practicals Skill Set 4 Exercise Solutions

SOP 1: Use of Accounting Package to create a company.
Create a company with the following particulars.
Company Name: B.B Enterprises
Case: Upper Case
Company Type: Profit Making
Financial Year: 01-04-2019 to 31-03-2020
Use GNUKhata for: Accounting Only
Create a profile with relevant data for any company. Create an Admin account for the company.
Answer:
Step 1: Open GNUKhata Application. Click on ‘company Setup Wizard’ or (press shift + control + C)

Step 2: While creating a company the following details are to be given.
Company Name: B.B Enterprises
Case: Upper Case
Company Type: Profit Making
Financial Year: 01/04/2019 to 31/03/2020
Use GNUKhata for: Accounting Only
Fill in all the required details and click on proceed button on the right button corner.

Step 3: Enter Appropriate Company Information in the Given Field.
Company Profile window appears, in that window fill in the details and click on proceed button on the right bottom corner.

Step 4: Create Admin Next step is the ‘create Admin’ which is mandatory with proper user name and password. Fill in the fields and click on ‘Create & Login button, the company will be created.
Now your Company is ready.

Step 5: Admin Dashboard After login, the following admin dashboard, appears.

SOP 2: Create ledger accounts using the accounting Package.
Create ledger accounts for the following and allocate proper groups.

1. Import duty
2. Insurance
3. Machinery
4. Audit Fee
5. Purchase
6. Sales
7. Telephone charges
8. Interest Received
9. Salary
10. Professional fees

Answer:
Step 1: You Can select an already created company using the ‘Select Existing Company ’ Option on Opening Screen.

Step 2: Log in with User Name and Password

Step 3: To create an account (ledger account) click on the Hamburger Menu available at the left top corner of the dashboard.
Click on the Master Account → It allows you to create an account.
The following table shows the group name, sub-group name, and account name which are to be created.

Group Name	Sub Group Name	Account / Ledger Name
Direct Expenses	None	Import Duty
Indirect Expenses	None	Insurance
Fixed Assets	Plant & Machinery	Machinery
Indirect Expenses	None	Audit fee
Direct Expense	None	Purchase
Direct Income	None	Sales
Indirect Expense	None	Telephone charges
Indirect Income	None	Interest received
Indirect Expense	None	Salary
Direct Income	None	Professional Fees

Information Technology 11th Std Skill Oriented Practicals (SOP)

• 11th Information Technology Practicals Skill Set 1 Practical Problems
• 11th Information Technology Practicals Skill Set 2 Practical Problems
• 11th Information Technology Practicals Skill Set 3 Practical Problems
• 11th Information Technology Practicals Skill Set 4 Practical Problems
• 11th Information Technology Practicals Skill Set 5 Practical Problems
• 11th Information Technology Practicals Skill Set 6 Practical Problems

Client Side Scripting (JavaScript) 11th Information Technology Practicals Skill Set 3 Solutions Maharashtra Board

Balbharati Maharashtra State Board Class 11 Information Technology Solutions Practicals Skill Set 3 Client Side Scripting (JavaScript) Textbook Exercise Questions and Answers.

Class 11 Information Technology Practicals Skill Set 3 Exercise Solutions

SOP 1: Create a JavaScript program for the following using appropriate variables, JavaScript inbuilt functions, and control structures.

• To accept an integer and display the result by multiplying it with 3.
• To accept two integers and display a larger number of them.
• To check whether the user entered number is positive or negative.

Answer:
To accept integer and display the result by multiplying it with 3.
<!DOCTYPE html>
<head>
<title>To accept integer and display the result by multiplying it with 3.</title>
</head>
<body>
<script language=”javascript”> var a,no,ans;
a=prompt(Enter any value’);
no=parseInt(a);
ans=no*3;
document.
write(“The answer is :”+ans);
</script>
</body>
</html>

To accept two integers and display larger number of them.
<!DOCTYPE html>
<head>
<title>To accept two integers and display larger number of them.</title>
</head>
<body>
<script language=”javascript”>
var a,b;
a=prompt(‘Enter first value’);
b=prompt(‘Enter second value’);
if(a>b)
document.write(“a is large number than b “);
else
document. write(“b is large number than a”);
</script>
</body>
</html>

To check whether, user entered number is positive or negative.
<!DOCTYPE html>
<head>
<title>To check whether, user entered number is positive or negative</title>
</head>
<body>
<script language=”javascript”>
var a,no;
a=prompt(‘Enter any number’);
no=parseInt(a);
if(no>0)
document.write(“Number is Positive”);
else
document.write(“Number is Negative”);
</script>
</body>
</html>

SOP 2: Create a JavaScript program for the following using appropriate variables, JavaScript inbuilt functions, and control structures.

• To accept two positive or negative numbers and check whether they are equal or not.
• To accept a number and display the square of it.
• To check whether the accepted integer is multiple of 3 or multiple of 7.

Answer:
To accept two positive or negative numbers and check whether they are equal or not.
<!DOCTYPE html>
<head>
<title>program3</title>
</head>
<body>
<script language=”javascript”> var no1,no2;
no1=prompt(‘Enter first number’);
no2=prompt(‘Enter Second number’);
if(no1==no2)
document.write(“Both are equal”);
else
document.write(“Given numbers are not equal”);
</script>
</body>
</html>

To accept number and display square of it.
<!DOCTYPE html>
<head>
<title>To accept number and display square of it</title>
</head>
<body>
<script language-’j avascript”>
var no,sqr;
no=prompt(‘Enter Any number’);
sqr=no*no;
document, write (“The Square is=”+sqr);
</script>
</body>
</html>

To check whether the accepted integer is multiple of 3 or multiple of 7.
<!DOCTYPE html>
<html>
<head>
<title>To check whether the accepted integer is multiple of 3 or multiple of 7.</title>
</head>
<body>
<script language=JavaScript>
var a;
a=prompt(“Enter your first interger / number”);
if(a%3==0 | | a%7==0)
alert(“multiple of 3 or 7”);
else
alert(“not a multiple of 3 or 7”);
</script>
</body>
</html>

SOP 3: Create a JavaScript program for the following using appropriate variables, JavaScript inbuilt string functions, and control structures.

• To accept a string and calculate its length.
• To accept a string and display it in lowercase and uppercase.
• To check whether the length of the string is 4 or greater.

Answer:
To accept a string and calculate its length.
<!DOCTYPE html>
<head>
<title>program8</title>
</head>
<body>
<script language=”javascript”>
var a;
a=prompt(‘Enter string’);
document.write(“The length is=”+a.length);
</script>
</body>
</html>

To accept string and display it into lowercase and uppercase.
<!DOCTYPE html>
<head>
<title> To accept string and display it into lowercase and uppercase</title>
</head>
<body>
<script language=”javascript”>
var a;
a=prompt(‘Enter any string’);
document.write(“<br>Entering Strings “+a);
document.write(“<br>Lowercase=”+a.toLowerCase());
document.writeln(“<br>Uppercase=”+a.toUpperCase());
</script>
</body>
</html>

To check whether the length of string is 4 or greater.
<!DOCTYPE html>
<html>
<head>
<title> JavaScript</title>
</head>
<body>
<script language=JavaScript>
var a,b;
a=prompt(“Enter your text”);
b=a.length;
if(b=4 || b>=4)
alert(‘‘your length is 4 or greater”);
else
alert(“your text length is below 4”);
</script>
</body>
</html>

SOP 4: Create event-driven JavaScript programs for the following using appropriate variables, JavaScript inbuilt functions, and control structures.
To accept numbers and validate if the given value is a number or not by clicking on the button.

To calculate the addition and division of two numbers.

Answer:
To accept number and validate if the given value is a number or not by click
<!DOCTYPE html>
<html>
<head>
<title> To accept number and validate if the given value is a number or not by clicking on the button.
</title>
</head>
<script language-’JavaScript”>
function display()
{
var a,b;
a=form1.t1;value;
if(a>=0)
alert(“Value is a number”+” “+a);
else
alert(“Value is a string”+” “+a);
}
</script>
</head>
</body>
<form name=form1>
Enter Value: <Input type=text name=t1><br><br>
<Input type=button value=Check onClick=”display()”>
</form>
</body>
</html>

To calculate addition and division of two numbers.
<!DOCTYPE html>
<head>
<title>To calculate addition and division of two numbers.</title>
<script langauge=”javascript”>
function add()
{
var a,b,result;
a=f1.t1.value;
b=f1.t2.value;
result=parselnt(a)+parselnt(b);
document.write(“The Addition is =”+result);
}
function div()
{
var a,b,d;
a=f1.t1.value;
b=f1.t2.value;
d=parselnt(a)/parselnt(b);
document.write(“The Divide is =”+d);
}
</script>
</head>
<body>
<form name=”f1”>
1st Number : <input type=”text” name=”t1”><br>
2nd Number : <input type=”text” name=”t2”><br>
<input type=”button” value=”Addition” name=”b1” onClick=”add()”>
<input type=”button” value=”Division” name=”b2” onClick=”div()”>
</form>
</body>
</html>

Information Technology 11th Std Skill Oriented Practicals (SOP)

• 11th Information Technology Practicals Skill Set 1 Practical Problems
• 11th Information Technology Practicals Skill Set 2 Practical Problems
• 11th Information Technology Practicals Skill Set 3 Practical Problems
• 11th Information Technology Practicals Skill Set 4 Practical Problems
• 11th Information Technology Practicals Skill Set 5 Practical Problems
• 11th Information Technology Practicals Skill Set 6 Practical Problems

Web Designing (HTML – 5) 11th Information Technology Practicals Skill Set 2 Solutions Maharashtra Board

Balbharati Maharashtra State Board Class 11 Information Technology Solutions Practicals Skill Set 2 Web Designing (HTML – 5) Textbook Exercise Questions and Answers.

Class 11 Information Technology Practicals Skill Set 2 Exercise Solutions

SOP 1: Write a program using HTML with the following specifications.

• The background colour should be green.
• The text colour should be red.
• The heading should be as large in size as ‘My First Web Page’.
• Display a horizontal line after the heading.
• Display your name in Bold, address in Italics, and standard as 11th.

Answer:
<!DOCTYPE html>
<html>
<head>
<title>sop1</title>
</head>
<body bgcolor=green text= red>
<h1> My First Web Page </h1>
<hr>
<b> Reliable Publications</b>
<br>
<i> Chira bazar,Charni road,Mumbai</i>
<br>
Standard 11th.
</body>
</html>

SOP 2: Create a web page with, following specifications.

• Image of any scientist with an alternate text as his name.
• Create a paragraph related to the information of that scientist.
• Create a table of his/her inventions.

Answer:
<!DOCTYPE html>
<html>
<head>
<title>sop2</title>
</head>
<body>
<img src=”Albert Einstein.jpg” alt=”Albert Einstein”>
<br>
<p>
Albert Einstein was a German-born theoretical physicist who developed the theory of relativity,<br> one of the two pillars of modern physics.His work is also known for its influence on the philosophy of science.
</p>
<table border=5 bordercolor=pink>
<tr>
<th> Sr no.</th>
<th> Invention </th>
<th> Year</th>
</tr>
<tr>
<td>1</td>
<td>Quantum Theory of Light </td>
<td>1905</td>
</tr>
<tr>
<td>2</td>
<td>Theory of Relativity</td>
<td>1907</td>
</tr>
</table>
</body>
</html>

SOP 3: Create a webpage with the following specifications.

• Display heading ‘Application Form’ in the highest heading with center alignment.
• Accept name, standard 11th or 12th with only one selection choice.
• Submit the form.

Answer:
<! DOCTYPE html>
<html>
<head> <title> sop3</title>
</head>
<body>
<h1 align=center> Application Form </h1>
<form>
Enter Name:<input type=text name=t1>
<br><br>
Standard:<br>
<input type=”radio” name=r1>11th<br>
<input type=”radio” name=r1>12th<br>
<br><br>
<input type=”submit” value=”Submit”>
</form>
</body>
</html>

SOP 4: Write a program using HTML with the following specification.
A webpage with details about a class with a total number of students-100, (Boys – 50), Girls – 50 in tabular form.
e.g.

Link this page to another page as follows.

Demo.html
Answer:
<!DOCTYPE html>
<html>
<head>
<title>New Page 1</title>
</head>
<body>
<center>
<table border=”1” width=”69%” >
<tr bgcolor=pink>
<td>Number of Students</td>
<td>Boy</td>
<td>Girls</td>
</tr>
<tr bgcolor=”lightgreen”>
<td>100</td>
<td>50</td>
<td>50</td>
</tr>
</table>
</body>
</html>

Demo
<!DOCTYPE html>
<html>
<head>
<title>the heading</title>
</head>
<BODY>
<header>
<center>
<table border=”1” align=center>
<tr align=center>
<td><a href=”sop4.html”>STD – XI</a>
<br>Stream – Science<br>
Div – A<br></td>
</tr>
</table>
</body>
</html>

Information Technology 11th Std Skill Oriented Practicals (SOP)

• 11th Information Technology Practicals Skill Set 1 Practical Problems
• 11th Information Technology Practicals Skill Set 2 Practical Problems
• 11th Information Technology Practicals Skill Set 3 Practical Problems
• 11th Information Technology Practicals Skill Set 4 Practical Problems
• 11th Information Technology Practicals Skill Set 5 Practical Problems
• 11th Information Technology Practicals Skill Set 6 Practical Problems

Daily Computing (Libre Office) 11th Information Technology Practicals Skill Set 1 Solutions Maharashtra Board

Balbharati Maharashtra State Board Class 11 Information Technology Solutions Practicals Skill Set 1 Daily Computing (Libre Office) Textbook Exercise Questions and Answers.

Class 11 Information Technology Practicals Skill Set 1 Exercise Solutions

SOP 1: Create a Resume

• The resume should contain the following:
• Title at the center with applicable font and size.
• It should contain points such as Name, Address, Mobile Number, Date of Birth, Nationality, Caste, Category, Hobbies, etc. Add some extra points.
• For educational qualifications, a student should insert a table.
• In the end, students should write a few lines about their aim.

Answer:
Step 1: Click on the LibreOffice Writer icon.

Step 2: Create a New File.
File Menu → New → Text Document

Step 3: Write Title at the center with applicable font size. (Resume).

Step 4: Type Name, Address, Mobile Number, Date of Birth, Nationality, Caste, Category, Hobbies, etc.

Step 5: Write Student educational qualifications (Insert Table).
Choose Table Menu → Insert Table → Select number of rows and columns → Insert.

Step 6: Write some lines about the aim, select the text and make it bold by clicking on the bold option from the formatting toolbar.

After Completing this practical students will learn how to create resumes using LibreOffice, also tab setting and table creation.

SOP 2: By using Mail Merge send an invitation for your birthday party.

• Use the mail merge feature.
• Send an invitation to at least 5 friends.

Answer:
Choose Tools – Mail Merge Wizard.
Step 1: Select Start from a template, and click the Browse button. You see the New dialog.

Step 2: Select five friends Details in the left list, and then the Invitation letter in the right list.
Click OK to close the Templates dialog, and click Next in the wizard.

Step 3: Select Letter and click Next.

Step 4: On the next step of the wizard, click the Select Address List button to check that you are using the correct address list. If you want to use an address block, select an address block type, match the data fields if necessary, and click Next.

Step 5: Next follows the Create a salutation step. Deselect the Insert personalized salutation box. Under General salutation, select the salutation that you want on top of all letters.

Step 6: If you want to place mail merge fields anywhere else in the Invitation document select the corresponding column in your address data source and then drag and drop the column header into the invitation document where you would like the field to be. Be sure to select the entire column.

Step 7: Click Next and finally Finish creating the mail merge.

SOP 3: Create a mark list. The mark list should display:

• Fields as Name, Math, Physics, Chemistry, Biology, Total, Percentage.
• Below each subject find out the lowest marks and highest marks.
• Enter a minimum of 10 records.
• Declare the first three ranker students.
• Create a chart based on the above data.

Answer:
Step 1: Open LibreOffice Calc and add fields like Name, Math, Physics, Chemistry, Biology, Total, Percentage.

Step 2: Enter 10 records in it.

Step 3: To Calculate Total
Click inside the cell where the total has to be calculated.
(Use =SUM(A2:D2) formula) – Type the range of cell.

Step 4: Now click inside the cell where the percentage has to be calculated.
Calculate Percentage using formula = E2* 100/400, drag the formula for remaining cells.

Step 5: Enter a minimum of 10 records. And calculate the result.

Step 6: Find out the Lowest Marks
Calculate Lowest marks using formula = min(A2:A11), drag formula for remaining cells.

Step 7: Find out the Highest Marks
Calculate Highest marks using formula =max(A2:A11), drag formula for remaining cells.

Step 8: Now Show the first three ranker students. Use Sort Option for sorting and auto filter.

Step 9: To find the first ranker use formula =large(F2:F11,1)

Step 10: To find the second ranker use formula =large(F2:F11,2)

Step 11: To find the third ranker use formula =large(F2:F11,3)

Step 12: To create a chart Select Complete Table → Click on Insert Menu → Click on Chart Option.
A window will appear, which starts with the chart wizard → Select Chart type.

SOP 4: Create an Informative presentation on your college.

• The presentation should contain a minimum of 8 slides.
• One slide should contain a chart.
• One slide with an image.
• Each slide should contain custom animation & slide transition effect.

Answer:
Step 1: Preparing an Eight slide for an Informative presentation of your college.
Press the Ctrl + N Keys. OR choose Slide → New Slide from Menu bar.
OR
Click on the New Slide icon on the Standard Toolbar.

Step 2: Specify the background image. OR background colour.
Now First Choose Slide Menu → Click on Insert Menu → Click on Image Submenu (inserting college Image with information )

Step 3: Click on Insert Menu → Click on Chart Option.

Step 4: Click on object presentation → from slide bar select Custom Animation each object → Choose category, effect, duration, direction, etc.

Step 5: Click on Press F5 function key for slide show
OR
Select slide menu → Start from the first Slide from the menu bar.
OR
Click on the start from the first slide Icon on the standard Conclusion: After Completing this practical students will be known how to create an informative presentation, custom animation & slide transition effect using Libre Office Impress.

Information Technology 11th Std Skill Oriented Practicals (SOP)

• 11th Information Technology Practicals Skill Set 1 Practical Problems
• 11th Information Technology Practicals Skill Set 2 Practical Problems
• 11th Information Technology Practicals Skill Set 3 Practical Problems
• 11th Information Technology Practicals Skill Set 4 Practical Problems
• 11th Information Technology Practicals Skill Set 5 Practical Problems
• 11th Information Technology Practicals Skill Set 6 Practical Problems

Cyber Law 11th Information Technology Chapter 4 Solutions Maharashtra Board

Balbharati Maharashtra State Board Class 11 Information Technology Solutions Chapter 4 Cyber Law Textbook Exercise Questions and Answers.

Class 11 Information Technology Chapter 4 Exercise Solutions

1. Complete the following web.

Question 1.

Answer:

1. Use the Internet for the knowledge base.
2. Use the Internet to communicate messages.
3. Respect the privacy of other users on the Internet.
4. Download legitimate and authentic programs from the Internet.
5. Use licensed software on your computer.
6. Check to see if the web address begins with https:// whenever you sign in.
7. Report and flag content that is abusive or illegal.

2. Complete the following chart.

Question 1.

Answer:

3. Fill the following boxes with the appropriate cybercrime name.

Question 1.
Copyright violation of software created originally by an individual.

Answer:
Software Piracy

Question 2.
Gaining access without the user’s permission.

Answer:
Unauthorized Access

Question 3.
Extracting confidential information by email.

Answer:
Phishing

4. Read the following and answer the question.

Rahul lost his pen drive in his college computer lab. His classmate Madhav finds it. He carries it home to return it to him the next day. When Madhav opens it he finds his favourite game. He thinks of making a duplicate copy of the game software.

Question I.
Does Madhav think ethically?
Answer:
No

Question II.
What do you think should Madhav do?
Answer:
Madhav should return back the pen drive. He has done unauthorized access.

Question III.
If he makes a duplicate copy then which cybercrime will he commit?
Answer:
Software Piracy

5. Answer in brief.

Question 1.
What care should be taken by the user while doing online activities?
Answer:

1. Stick to copyright restrictions when downloading anything from the internet.
2. Use strong passwords with combinations of numbers. Uppercase and lowercase letters and special characters.
3. Always scan files before opening them.
4. Don’t talk to strangers.
5. Think before posting something on social media related to any sensitive topic like politics, religion, etc.
6. Report to the service provider if the account is hacked; if possible deactivate your account.
7. Whenever you sign in online check if the web address begins with https: //

Question 2.
Define the terms (1) Ethics (2) Moral
Answer:
Ethics:
Ethics also called moral philosophy is the discipline concerned with what is morally good and bad, right or wrong.

Moral:
The standards of behaviour; principles of right and wrong behaviour. Thus morals are dictated by society, culture, or religion while ethics are chosen by the person himself which governs his life.

Question 3.
Explain three examples related to unauthorized access?
Answer:

1. Hacking financial/bank account-related information.
2. Stealing organizational/intellectual information.
3. Illegal monitoring of information owned by other users.
4. Illegal use/break of login and password of other users.
5. Causing intentional irritation to other users by means of damaging software and important information.

Question 4.
Explain software piracy and Hacking.
Answer:
Software piracy:
Software piracy is the illegal copying, distribution, or use of the software. It 15 such a profitable “business” that it has caught the attention of organized crime groups in a number of countries. According to the Business Software Alliance (BSA), about 36% of all software in current use is stolen.

Hacking:
Hacking refers to unauthorized intrusion into a computer or a network. Hacker is a person intensely interested in the deep and hidden or concealed working of any computer operating system and programming language. They might discover loopholes within systems and reasons for such loopholes.

6. State true or false.

Question 1.
A firewall is used to encrypt the transmission of data.
Answer:
True

Question 2.
The standards of behaviour; the principle of right or wrong are referred to as moral.
Answer:
True

Question 3.
Hacking bank account-related information is an example of software piracy.
Answer:
False

Question 4.
Phishing is representing someone else’s work as own without permission.
Answer:
True

7. Match the following.

Question 1.

(A)	(B)
(1) Copying a game file	(a) Firewall
(2) Law related to internet	(b) Cyberthreat
(3) Network security	(c) Software piracy
(4) System crashes suddenly	(d) Cyber Law

Answer:

(A)	(B)
(1) Copying a game file	(c) Software piracy
(2) Law related to internet	(d) Cyber Law
(3) Network security	(a) Firewall
(4) System crashes suddenly	(b) Cyberthreat

8. Observe the following picture and give your opinion about it by responding to the following questions.

Question 1.
Is ‘B’s response correct or not?
Answer:
No B’s response is not correct.

Question 2.
What will be the consequences of ‘B’s reply?
Answer:
With all such crucial information like OTP in hand, the fraudster can easily carry out illegal financial transactions using B’s identity.

Question 3.
Which type of cybercrime does the picture depict?
Answer:
Fake Call Frauds

Information Technology 11th Std Commerce 

• 11th Information Technology Chapter 1 Practical Problems
• 11th Information Technology Chapter 2 Practical Problems
• 11th Information Technology Chapter 3 Practical Problems
• 11th Information Technology Chapter 4 Practical Problems

Impressive Web Designing 11th Information Technology Chapter 3 Solutions Maharashtra Board

Balbharati Maharashtra State Board Class 11 Information Technology Solutions Chapter 3 Impressive Web Designing Textbook Exercise Questions and Answers.

Class 11 Information Technology Chapter 3 Exercise Solutions

1. Answer the Following:

Question 1.
The data entry operator wants to insert.
1. Photograph
2. Write remarks about the photograph
3. Underline the heading.
He will use:
1. <Image>
2. <Text>
3. <TextArea>
4. <Img>
5. <UL>
6. <U>
Select the correct tags from the above and arrange them in the sequence.
Answer:
1. Photograph – <Img>
2. Write remarks about the photograph – <TextArea>
3. Underline the heading – <U>

Question 2.
Identify the logical operators in JavaScript.
1. OR
2. AND
3. ||
4. &
5. &&
6. ++
Answer:
| |, &&

2. Complete the following Activity:

Question 1.
State at least three attributes of <Input>

Answer:

Question 2.

Answer:

Question 3.
Group the Following.

Answer:

Question 4.
Write operator names with symbols in boxes.

Answer:

Question 5.
Complete following program to display multiplication of 6.40 and 300.
<!DOCTYPE html>
<html>
<head><title> Series </title></head>
<body>

</html>
Answer:
<!DOCTYPE html>
<html>
<head><title> Series </title></head>
<body>

</html>

3. Find out errors if any in the following javascript code.

Question 1.
var length, breadth;
length=4.5;
breadth=6;
area=1/2*length*breadth;
document.write(“Area of triangle is”area);
Answer:
Concatenate Operator ‘+’ is missing
document. write(“Area of triangle is” [+] area);

4. Solve the following puzzles.

Question A.
Fill the blocks

1) Across
2. The tag is used to create a table row.
4. Tag to create a form

2) Down
1. The attribute is used to specify the path of a linked document.
3. The tag used to display horizontal ruled line
Answer:

Across
2. <tr>
4. <form>
Down
1. href
3. <hr>

Question B.
Solve the puzzle by finding words with the help of the hint given below.

1. Boolean value.
2. Keyword used in conditional if statement.
3. Built-In function in JavaScript
4. Function to check given value is number or not
5. Keyword used to declare a variable
6. Function used to evaluate given expression
Answer:

1. False
2. if
3. confirm
4. nan
5. var
6. False

5. Trace the output of the following Html code.

Question 1.
<!DOCTYPE html>
<html>
<head>
<title>Heading tags</title></head>
<body>
<h1 align=left>Information Technology</h1>
<hr>
<h2 align=center>XI Standard</h2>
<h3 align=right>Division</h3>
</body>
</html>
Answer:

6. Discuss the following and answer the questions.

Question 1.
A Jr. web designer wants to design a webpage to enter the employee’s name, address. He needs a button to clear the form content and submit the data.
Write the different controls he will use to create the web page.
State the tags to be used for the controls.
Answer:
A Junior Web designer will use the following controls to design web as follows:
1. Text – to create a single-line textbox for employee name
2. Text or Textarea – If he wants to create a single-line address the text control is used otherwise to create a multiline address textarea is used.
3. Submit – It is used to submit form data to the server.
4. Reset – It is used to clear form data.

Tags used for the controls are-
1. Employee Name :<Input type-”text”>
2. Address :<Input type=”text”> or
Address: <textarea rows=”4” cols-”30”><textarea>
3. <Input type=”submit” value=”submit”>
4. <Input type-”reset” value=”reset”>

Question 2.
A teacher has asked a student to create a web page to accept numbers and check whether it is between 50 to 100.
List the variable, operators to be used.
Specify the built-in function used and structure used.
Answer:
Program:
<!DOCTYPE html>
<head>
</head>
<body>
<script language =”Javascript”>
//To check whether the given no is between 50 to 100
var n;
n=prompt(“Enter any number”);
if(n<50 | | n>100)
{
alert(“it is less than 50, Please Re-Enter”);
}
else
{
alert(“it is greater than 50. Please Re-Enter”);
}
</script>
</body>
</html>

Variables used ‘n’
Operators used Not is equals | | less then < grater then > etc
Function is Prompt(), Alert() if then Else

7. Create web pages for the following.

Question 1.
Write a program using HTML to design your class Time Table.
Answer:
Program <!Doctype Html>
<html>
<head><title> Time Table of Class XI</title>
</head>
<body bgcolor=yellow>
<h2>Time Table of Class XI</h2>
<table border=”2” bgcolor=skyblue>
<tr>
<th>Period No</th>
<th>Monday</th>
<th>Tuesday</th>
<th>Wednesday</th>
<th>Thursday</th>
<th>Friday</th>
<th>Saturday</th>
</tr>
<tr>
<td>1</td>
<td>Book Keeping</td>
<td>Economics</td>
<td>Maths</td>
<td>Maths</td>
<td>English</td>
<td>English</td>
</tr>
<tr>
<td>2</td>
<td>Maths</td>
<td>Maths</td>
<td>Book Keeping</td>
<td>Economics</td>
<td>English</td>
<td>IT</td>
</tr>
<tr>
<td>3</td>
<td>Maths</td>
<td>Maths</td>
<td>Book Keeping</td>
<td>Economics</td>
<td>IT</td>
<td>IT</td>
</tr>
<tr>
<th colspan=”7”>”L U N C H_B R E A K”</th>
</tr>
<tr>
<td>4</td>
<td>Organization of Commerce</td>
<td>Secretarial Practice</td>
<td>EVS</td>
<td>IT</td>
<td>Economics</td>
<td>English</td>
</tr>
<tr>
<td>5</td>
<td>Secretarial Practice</td>
<td>EVS</td>
<td>EVS</td>
<td>IT</td>
<td>Economics</td>
<td>English</td>
<tr>
<th colspan=”7”>”S H O R T_B R E A K”</th>
</tr>
<tr>
<td>6</td>
<td>Organization of Commerce</td>
<td>Secretarial Practice</td>
<td>Maths</td>
<td>Maths</td>
<td>English</td>
<td>English</td>
</tr>
<tr>
<td>7</td>
<td>Economics</td>
<td>Maths</td>
<td>Book Keeping</td>
<td>Book Keeping</td>
<td>English</td>
<td>IT</td>
</tr>
</table>
</body>
</html>

Question 2.
Write a program using HTML to create a form and submit it with personal data like name, address, and standard.
Answer:
Program:
<!DOCTYPE html>
<head>
<title> Form</title>
</head>
<body bgcolor=”#FF0100”>
<h1>Personal Data</h1><br><br><br>
Name :<input type=text name=t1><br><br>
Address:<Textarea> Address Here </textarea><p><br>
Class XI <input type=radio name=c1 value=xi>
Class XII <input type=radio name=c1 value=xii><br>
<input type=Submit name=b1 value=Submit>
<input type=reset name=b2 value=Reset>
</body>
</html>

Output:

Question 3.
Write a javascript program to accept two numbers and perform the addition of two numbers by using the mouseover event.
Answer:
<html>
<head>
<title> JavaScript Program </title>
<script language = “JavaScript”>
function iload()
{
var c=0
a=parseInt(prompt(“Enter 1st no.”));
b=parseInt(prompt(“Enter 2nd no.”));
c=a+b
document.write(“Addition is”+c);
}
</script>
</head>
<body><center><br><br><br><br><br>
<a onMouseover=”iload();”>Addition</a></center>
</body>
</html>

8. Complete the following.

Question 1.

Answer:

9. Write HTML Code for the following table.

Question 1.

Answer:
<!DOCTYPE html>
<head>
<title>Html Program </title>
</head>
<BODY>
<table border=”1”>
<tr bgcolor=pink>
<th>Place</th>
<th>State</td>
<th>Max <br>Temperature <br>in C</th>
</tr>
<tr align=center bgcolor=skyblue>
<td>Wardha</td>
<th rowspan=”2”>Maharashtra</th>
<td>47.5</td>
</tr>
<tr align=center bgcolor=skyblue>
<td>Akola</td><td>46.4</td>
</tr>
<tr align=center bgcolor=skyblue>
<td>Khajuraho</td>
<th rowspan=”2”>Madhya Pradesh</th>
<td>46.4</td>
</tr>
<tr align=center bgcolor=skyblue>
<td>Sagar</td><td>46.2</td>
</tr>
</table>
</body>
</html>

10. Multiple choice one correct answer.

Question 1.
The default method of submitting form data is __________
(a) Post
(b) Get
(c) Submit
(d) Reset
Answer:
(b) Get

Question 2.
In JavaScript the post increment operator is __________
(a) x++
(b) x–
(c) –x
(d) ++x
Answer:
(a) x++

Information Technology 11th Std Commerce 

• 11th Information Technology Chapter 1 Practical Problems
• 11th Information Technology Chapter 2 Practical Problems
• 11th Information Technology Chapter 3 Practical Problems
• 11th Information Technology Chapter 4 Practical Problems

Introduction to DBMS 11th Information Technology Chapter 2 Solutions Maharashtra Board

Balbharati Maharashtra State Board Class 11 Information Technology Solutions Chapter 2 Introduction to DBMS Textbook Exercise Questions and Answers.

Class 11 Information Technology Chapter 2 Exercise Solutions

1. Complete the following activity.

Question 1.
Tick whichever box is not valid.

Answer:

Question 2.
The student wants to create a field Pincode in a table, which data type he will choose?

Answer:
Int

Question 3.
Tick the appropriate box.

Answer:
Uniquely identifies a record

Question 4.
Tick the appropriate circle.

Answer:
One or Many Tables

2. Observe the field names of a database given below in ‘Column A’ related to Bus reservation. Write suitable data types for each field in front of the respective field in ‘Column B’.

Question 1.

Answer:

Column A (Field Name)	Column B (DataType)
Passenger Name	Varchar
Age	Int
Gender	Char
Mobile Number	Int

3. Write the use of the following SQL command.

Question 1.

Answer:

4. Create a table for the information given below by choosing appropriate data types. Specify proper primary key for the table (1) Movie (2) Actor

Question 1.
Movie (Registeration_no, movie_name, Realease_Date)
Answer:
CREATE TABLE Movie (Registeration_no int(20) PRIMARY KEY, movie_name VARCHAR(20), Realease_Date DATE);

Question 2.
Actor (actor_id, Actor_name, birth_date )
Answer:
CREATE TABLE Actor (actor_id int(20) PRIMARY KEY, Actor_name VARCHAR(20), Birth_Date DATE);

5. Consider the following table Stationary. Write SQL commands for the following statements.

Table: Stationary

Question 1.
Write SQL command to create above Table.
Answer:
CREATE TABLE Stationary (S_ID int(20) PRIMARY KEY, S_Name VARCHAR(20), C_Name VARCHAR(20), Price int(20), Quantity int(20));

Question 2.
Write SQL command to insert the above-mentioned record in the table.
Answer:
INSERT INTO Stationary Values (001, ‘Note Book’, ‘ABC’, 20,50);
INSERT INTO Stationary Values (002, ‘Note Book’, ‘XYZ’, 10,80);
INSERT INTO Stationary Values (003, ‘Note Book’, ‘PQR’, 600,02);

Question 3.
To delete the above table.
Answer:
DROP TABLE Stationery;

6. Answer the following questions.

Question 1.
What is a database?
Answer:
A DBMS is a collection of programs (computer-based system) that enables the user to create and maintain a database it is used to define, construct and manipulate the data in the database for various applications. It provides information storage, organization, and retrieval capabilities. The DBMS also enforces necessary access restrictions and security measures in order to protect the database.

Various types of control systems within the DBMS make sure that the database continues to function properly. They Include Integrity system Security system Concurrency control system Recovery control system Some DBMS enables us to define “views” of the database. A view is how the database appears to the user. This enables us to show only the relevant information to different types of users and it increases security, as certain users will not be able to see data which they are not meant to see.

Question 2.
What are the advantages of a DBMS?
Answer:
Advantages of a DBMS:
1. Redundancy is controlled: In File Processing System, duplicate data is created in many places because all the programs have their own files. This creates data redundancy which in turn wastes labor and space. ‘In Database Management System, all the files are integrated into a single database. The whole data is stored only once in a single place so there is no chance of duplicate data.

2. Sharing of Data: In a database, the users of the database can share the data among themselves. There are various levels of authorization to access the data. And consequently, the data can only be shared based on the correct authorization protocols being followed.

3. Data Security: Data Security is a vital concept in a database. Only authorized users should be allowed to access the database and their identity should be authenticated using a username and password. Unauthorized users should not be allowed to access the database under any circumstances as it violates the integrity constraints.

4. Enforces integrity constraints: Constraints are used to store accurate data because there are many users who feed data in the database. Data stored in the database should always be correct and accurate. DBMS provides the capability to enforce these constraints on the database.

5. Provides backup and recovery of data: Data loss is a very big problem for all organizations. In a traditional tile processing system, a user needs to back up the database after a regular interval of time that wastes lots of time and resources. If the volume of data is large then this process may take a very long time.

Question 3.
What do you understand by Data Model?
Answer:
A Database model defines the logical design and structure of a database and defines how data will be stored, accessed, and updated in a database management system. While the Relational Model is the most widely used database model.

Relational Model:
It is the most popular data model in DBMS. The relational model is the primary data model. Which is widely used for data processing. This model has all properties required to Process data with storage efficiency.

Question 4.
What is a primary key?
Answer:
Primary Key: A column in the table that uniquely identifies each row in that table is called a primary key.

Question 5.
What is DDL (Data Definition Language)
Answer:
DDL statements or commands are used to define and modify the database structure of your tables or schema. When you execute a DDL statement, it takes effect immediately.
Some examples of DDL commands are CREATE, ALTER, and DROP.

7. In a company the data is stored in a table under the following fields Employee number, Last name, Date of birth, Address. Which data type will you use for the above field?

Question 1.

Answer:

Field Name	Data Type
Employee Name	Char
Last Name	Char
Address	Varchar
Date of Birth	Date

8. Multiple choice select three correct answers.

Question 1.
Valid relationships in RDBMS are
(a) one to one
(b) one to two
(c) one to many
(d) many to two
(e) many to many
(f) one to three
Answer:
(a) one to one, (c) one to many, (e) many to many

9. Complete the following.

Question 1.

Answer:

Use	Command
To remove access rights or privileges from the database	Revoke
Extracts data from a table	Insert into Select

Information Technology 11th Std Commerce 

• 11th Information Technology Chapter 1 Practical Problems
• 11th Information Technology Chapter 2 Practical Problems
• 11th Information Technology Chapter 3 Practical Problems
• 11th Information Technology Chapter 4 Practical Problems