Introduction to Pandas : Class 12 IP Revision Notes

Introduction to Pandas – Class 12 IP Revision Notes

  • Pandas stand for (PANel DAta System)
  • It was developed by Wes McKinney
  • It is open-source python library that makes data science or data analysis easy and effective
  • It provides the flexible and powerful functions and properties for 1D and 2D data structure
  • It provides high-performance data analysis tools
  • It is used in major fields like academic, commercial such as finance, economics, statistics and analytics etc.

Difference between NumPy and Pandas –  Class 12 IP Revision Notes

Key Point NumPy Pandas
Data Requires homogeneous data Can have heterogeneous data
Effectiveness NumPy is very effective for same kind of collection provides a simple interface for operations like select, access, plot, join and group by function
Kind of data It is a handy tool for numeric data It is a handy tool for data processing in the tabular form of data
Memory Consumes less memory Consumes more memory
Indexing Indexing is very quick Indexing is slow compared to NumPy

Features of Pandas – Class 12 IP Revision Notes

  • Efficient to read different types of data like integer, float, double etc.
  • In a data frame rows and columns can be added, deleted or modified anytime
  • Support group by, aggregate functions, joining, merging
  • Capable to pull data from MySQL database and CSV files and vice-versa
  • Can extract data from large data set and combine multiple tabular data structures in a single unit
  • Can find and fill missing data
  • Reshaping and re-indexing can be done in various forms
  • Can be used for future prediction from received data
  • Provides functions for data visualization using matplotlib

Installing Pandas – Class 12 IP Revision Notes

  • The installation can be done in pandas using pip command.
  • Open cmd prompt to use pip commands
  • Installing pandas – pip install pandas
  • To uninstall pandas – pip uninstall pandas

Importing Pandas for a program

To import pandas follow this command

import pandas as pd

Data Structures in Pandas – Class 12 IP Revision Notes

  • The way of storing, organizing, and maintaining data for appropriate applications is known as a data structure
  • Can help in extracting information easily
  • Pandas provide the following data structures:
    • Series:
      • It is a 1-dimensional data structure
      • Stores homogeneous data
      • It is data mutable and sizes immutable data structure
    • DataFrame:
      • It is 2 dimensional data structure
      • Stores heterogeneous data
      • It is data mutable as well as size mutable
    • Panel
      • It is a 3-dimensional data structure

Class 10 IT Concepts of Database Management System MCQ Question Answer

Class 10 IT Concepts of Database Management System MCQ Question Answer

Q1. A database is an organized collection of ______________.

a. data

b. Attributes

c. Record

d. None of the above

Show Answer a. data
 

Q2. Which of the following software is appropriate to store data about school students?

a. MS-Access

b. Writer

c. Calc

d. Impress

Show Answer Ans- a. MS-Access
 

Q3. Which of the following is not a database programs?

a. MySQL

b. Oracle

c. Writer

d. OObase

Show Answer Ans- c. Writer
 

Q4. __________ store data in Single table.

a. Flat File

b. Relational

c. Single File

d. One File

Show Answer Ans- a. Flat File
 

Q5. ___________ are dedicated computers that hold the actual databases and run only DBMS and related Software.

a. Main Server

b. Web Server

c. Database Server

d. Non Database Server

Show Answer Ans- c. Database Server
 

Q6. GUI act as front end and database server act as _____

a. Container

b. Back End

c. End

d. None of the above

Show Answer Ans- b. Back End
 

Q7. Duplication of data is called _________.

a. Inconsistency

b. Consistency

c. Redundancy

d. Foreign Key

Show Answer Ans- c. Redundancy
 

Q8. Which of the following is not the advantage of database?

a. Sharing of Data

b. Reduce Data Redundancy

c. Increase Data Inconsistency

d. Data Security

Show Answer Ans- c. Increase Data Inconsistency
 

Q9. Which of the following will help to maintain unique record in the table?

a. Foreign Key

b. Primary Key

c. Composite Key

d. Alternate Key

Show Answer Ans- b. Primary Key
 

Q10. Which of the following field of table “Book” can act as primary key?

a. Book_number

b. Subject

c. price

d. Author_name

Show Answer Ans- a. Book_number
 

Q11. When primary key is made up of two or more columns then it is called _______primary key.

a. Mixed

b. Reference

c. Composite

d. Compost

Show Answer Ans- c. Composite
 

Q12. A key which is referring to the primary key of another table is called _______

a. Alternate Key

b. Primary Key

c. First Primary Key

d. Foreign Key

Show Answer Ans- d. Foreign Key
 

Q13. A field which is_______for each and every record is called Primary key.

a. Common

b. Same

c. Unique

d. None of the above

Show Answer Ans- c. Unique
 

Q14. When data is stored, maintained and retrieved from multiple tables then special database software are required called ______

a. DBMS

b. RDBMS

c. Special DBMS

d. All of the above

Show Answer Ans- b. RDBMS
 

Q15. Identify the Foreign Key from table “Subject”

Table STU:

Stu_ID (primary Key)

Stu_Name

Stu_Phone


Table : Subject

Sub_ID (Primary Key)

Stu_ID

Marks


a. Sub_ID

b. Marks

c. Stu_phone

d. Stu_ID

Show Answer Ans- d. Stu_ID
 

Q16. Which of the following is not valid field of table “Student”

a. admno

b. name

c. fees

d. salary

Show Answer Ans- d. salary
 

Q17. In RDBMS, data is organized in the form of __________________

a. Table

b. Record

c. Field

d. None of the above

Show Answer Ans- a. Table
 

Q18. SQL stands for _________________

a. Structured Queue Language

b. Structured Query Language

c. Structured Query Lang

d. None of the above

Show Answer Ans- b. Structured Query Language
 

Q19. All the values in ________ are of same type.

a. Records

b. Table

c. Database

d. Fields

Show Answer Ans- d. Fields
 

Q20. ___________ represent a single data item in a table.

a. Tuples

b. Attributes

c. Relation

d. All of the above

Show Answer Ans- a. Tuples
 

Q21. _______________ are the basic building blocks of a database.

a. Tables

b. Record

c. Fields

d. All of the above

Show Answer Ans- a. Tables
 

Q22. We can create table :

a. in design view

b. use Wizard

c. Both of the above

d. None of the above

Show Answer Ans- c. Both of the above
 

Q23. By default data type of fields is.

a. Text[Varchar]

b. Text[Char]

c. Int

d. Long

Show Answer Ans- a. Text[Varchar]
 

Q24. By default the length of Varchar data type is __

a. 20

b. 30

c. 40

d. 50

Show Answer Ans- d. 50
 

Q25. By default the name of the table is ______

a. Tab 1

b. Table 1

c. First Table

d. Untitled 1

Show Answer Ans- b. Table 1
 

Q26. __________ are used to identify which type of data we are going to store in the database.

a. Datatype

b. Record

c. Table

d. Attributes

Show Answer Ans- a. Datatype
 

Q27. Which data type will be appropriate to store information as Salary, Fees, Price etc

a. Numeric Data type

b. Alphanumeric Data types

c. Binary Data types

d. Date Time

Show Answer Ans- a. Numeric Data type
 

Q28. Which of the following is not a numeric data type?

a. Tinyint

b. Smallint

c. Boolean

d. Date

Show Answer Ans- d. Date
 

Q29. Which of the following data types can not store decimal values?

a. Decimal

b. Real

c. Numeric

d. Boolean

Show Answer Ans- d. Boolean
 

Q30. Which of the following will occupy more space in computer memory?

a. Bigint

b. Integer

c. Smallint

d. Boolean

Show Answer Ans- a. Bigint
 

Q31. _______ data types are used for storing photos, music files etc

a. Binary

b. Alphanumeric

c. Numeric

d. Special

Show Answer Ans- a. Binary
 

Q32. Char is a ______ length data type and varchar is a ______ length data type.

a. Fixed, Variable

b. Variable, Fixed

c. Variable, Variable

d. Fixed, Fixed

Show Answer Ans- a. Fixed, Variable
 

Q33. Which field is suitable for storing records of employees?

a. EmpNo

b. Empname

c. Salary

d. All of the above

Show Answer Ans- d. All of the above
 

Q34. Auto Value is a property of __ data type .

a. Numeric

b. Character

c. Binary

d. Date

Show Answer Ans- a. Numeric
 

Q35. Which of the following property help to set the number of characters in Varchar type.

a. Auto value

b. Required

c. Default Value

d. Length

Show Answer Ans- d. Length
 

Q36. Which property ensures that field can not be left blank?

a. Entry required

b. Format

c. Required Entry

d. Required

Show Answer Ans- a. Entry required
 

Q37. By default the length of the Integer data type is ______________

a. 10

b. 15

c. 20

d. 25

Show Answer Ans- a. 10
 

Q38. Which of the following property to be turned “yes” so that value will be auto incremented?

a. Default

b. Format

c. Auto value

d. Length

Show Answer Ans- c. Auto value
 

Q39. Which of the following is not the binary data types?

a. Longvarbinary

b. Varbinary

c. Binary

d. Charbinary

Show Answer Ans- d. Charbinary
 

Q40. Which of the following is not the date time data types?

a. Date

b. Time

c. Datestamp

d. Timestamp

Show Answer Ans- c. Datestamp
 

Q41. Which data type is used to store value of fields like “Date of Birth”?

a. Date Time

b. Varchar

c. Integer

d. Other

Show Answer Ans- a. Date Time
 

Q42. We can ____________________ data in table.

a. modify

b. insert

c. delete

d. all of the above

Show Answer Ans- d. all of the above
 

Q43. In which view data can be entered in table?

a. Datasheet view

b. Design view

c. Both of the above

d. None of the above

Show Answer Ans- a. Datasheet view
 

Q44. In which mode we can change the structure of table?

a. Datasheet view

b. Design view

c. Structure view

d. All of the above

Show Answer Ans- b. Design view
 

Q45. Sorting means to arrange data in _______________ order.

a. increasing

b. decreasing

c. increasing or decreasing

d. None of the above

Show Answer Ans- c. increasing or decreasing
 

Q46. In Base data can be linked between two or more tables with the help of _________________

a. primary key

b. foreign key

c. primary and foreign key

d. None of the above

Show Answer Ans- c. primary and foreign key
 

Q47. Relationship can be created between

a. two tables only

b. one table only

c. two or more tables

d. none of the above

Show Answer Ans- c. two or more tables
 

Q48. Relationship between tables can be created from _____________________ menu.

a. View

b. Insert

c. Windows

d. Tools

Show Answer Ans- d. Tools
 

Q49. There are __________________ types of relationship which can be created between tables.

a. three

b. two

c. four

d. infinite

Show Answer Ans- a. three
 

Class 10 IT Concepts of Database Management System Notes

Database Management System Class 10 Notes by J.D Sir


What is Database?

Ans : An organised group of data that is kept and accessible electronically is referred to as a database. It is a digital repository that enables the effective management, storage, and retrieval of both organised and unorganised data. Information like client records, financial data, inventory listings, and much more can be stored in databases. Example of database are –  Microsoft Access, OpenOffice Base, Oracle, MySQL and PostgreSQL etc.

What is a Database Management System?

Ans: Data is stored, retrieved, and analyzed using software called database management systems (DBMS). Users can create, read, update, and remove data in databases using a Database Management System, which acts as an interface between them and the databases. Example of database Management System are – Microsoft Access, OpenOffice Base, Oracle, MySQL and PostgreSQL etc.

Data can be organized into two types:

  • Flat File: Data is stored in a single table. Usually suitable for less amount of data. basically for small-scale organization where data does not need to be strucutred in a complex way. Example of database software are Microsoft Excel or Google Sheets.
  • Relational: Data is stored in multiple tables and the tables are linked using a common field. Relational is suitable for medium to large amount of data. Example of database software are MySQL, Microsoft SQL Server, and Oracle Database..

What is Database Server? 

Database servers are dedicated computers that are designed to store data and provide database services to other computers. We use a database to store, organize, manage and retrieve data efficiently and effectively. The database servers run only database and database related software.

Advantages of Database

  • Reduces Data Redundancy

  • Data redundancy means when same data is stored more than one places, which increased complexity and wasted of storage space, so, database helps to reduce data redundacy.

  • Sharing of Data

  • A database allows its users to exchange data among themselves. The data can only be shared with users who have received the appropriate degrees of authorization because there are different levels of access to the data.

  • Data Integrity

  • Data integrity refers to the accuracy and consistency of data stored in a database management system (DBMS). Database ensures that the data is reliable and can be trusted for decision making and other critical business processes.

  • Data Security

  • A database’s concept of data security is important. The database should only be accessible to authorised users, whose identities must be verified using a username and password. 

  • Privacy

  • The privacy rule in a database ensures that only authorized users can access the database and view data according to the specific privacy constraints. To maintain data security, access levels are set in the database so that a user can only view data that they are not allowed to modify if the permission is not given.

    For example, in social networking sites, different accounts have different access constraints, and users are only allowed to view the other account data that is permitted for their specific account.

  • Backup and Recovery

  • Database Management System automaticlly take backup and recovery processes to ensure the protection and availability of data. This means that the DBMS automatically creates and manages backups of the database at regular intervals, and also provides tools to recover data in the event of a failure or data loss.

  • Data Consistency

  • Data consistency refers to the accuracy and reliability of data stored in a database or other data storage system. It means that the data is consistent and valid across all instances where it is stored or accessed.

    For example, if a customer’s name and address are stored in multiple tables within a database, the data must be consistent across all table.

Database Management System Class 10 Notes by J.D Sir


Features of Database

There are some key features of a database:

  1. One or more tables can be added in the database.
  2. Decreased storage costs and space requirements
  3. Users can use query languages in a database.
  4. Multiple users can access the data from the database .
  5. Unique keys aid in preventing errors caused by human or technological mishaps.

Primary Key, Composite Primary  Key and Foreign Key in a Database

In the RDBMS data can be integrated using keys. These are Primary Key, Composite Primary Key, and Foreign Key, Key are used to make the relationship between the tables. 

  • Primary Key

    This unique field is called the Primary Key (PK). primary key is a field or a set of fields that uniquely identify each record in a table. A primary key must be unique and cannot contain null values.
  • Composite Primary Key

    A composite primary key is a primary key that consists of two or more fields that together uniquely identify each record in a table.
  • Foreign Key

     A composite primary key is a primary key that consists of two or more fields that together uniquely identify each record in a table.

What is RDBMS?

A database management system that is based on the relational model is called an RDBMS (Relation Database Management System). Tables are used to organise data in relational databases. A relational database management system (RDBMS) is used to store, manage, query, and retrieve data.

Database Objects

  • Tables:

  • Data is arranged into rows and columns in a table, which is a type of data structure. It can be applied to both the storage and presentation of structured data.

  • Columns or Fields or Attributes:

  • Data is arranged vertically from top to bottom in columns. Each row of the table has one column, which is a collection of data values of a specific basic type. The structure by which the rows are put together is provided by the columns.

  • Rows or Records or Tuples:

  • A row, also known as a Record or Tuple, in a table represents a single data item. A database table can be represented graphically as being made up of rows and columns, or fields. Every row in a table has the same structure and represents a group of connected data.

Database Management System Class 10 Notes by J.D Sir


Difference between DBMS and RDBMS


AspectDBMSRDBMS
Data structureData is stored in various formats such as flat files or hierarchical structures.Data is stored in tables that are related to each other using a relational model.
Data integrityDBMS systems may or may not enforce strict data integrity rules.RDBMS systems enforce strict data integrity rules that ensure data consistency and accuracy.
Data normalizationDBMS systems may or may not follow normalization rules.RDBMS systems follow normalization rules to minimize data redundancy and improve data integrity.
Query languageTypically, DBMS systems use proprietary query languages.RDBMS systems use standard query language like SQL.
ScalabilityDBMS systems may not be scalable to handle large amounts of data.RDBMS systems are highly scalable to handle large amounts of data.
CostDBMS systems are generally less expensive than RDBMS systems.RDBMS systems are generally more expensive than DBMS systems.

Class 10 Creating and Using Tables in Open Office Base Notes

Class 10 Creating and Using Tables in Open Office Base Notes by J.D Sir


How to create a database using Open Office

  • Step 1 : Click on Start > Programs > OpenOffice > OpenOffice Base
  • Step 2 : Click on Create a new database
  • Step 3 : In the Database Wizard, Click on Finish
  • Step 4 : Specify a the Name of database and click on Save

How to create a table in Database

The database’s tables are used to store data. In the database, In OpenOffice Base the tables can be created in two different ways.

  1. Create Table in Design View
  2. Use Wizard to Create Table
  1. Create Table in Design View

    • Step 1 : Click on Create Table in Design View
    • Step 2 : Select Field name and suitable datatype
    • Step 3 : Set the Primary Key
    • Step 4 : Change the table name
    • Step 5 : Save the table
  2. Use Wizard to Create Table

    • Step 1 : Click on Table > Use Wizard to Create table 
    • Step 2 : Click the Select Fields > Choose Category > Select the table > Click on Next Button
    • Step 3 : Select data types from the given field
    • Step 4 : Set the Primary Key 
    • Step 5 : Rename the table and Click on Finish

Class 10 Creating and Using Tables in Open Office Base Notes by J.D Sir


Data Types

The type of data (value) that will be stored in the database is defined by its datatype. Important to know the different types of data helps to ensure that each property’s value is as expected and that data is collected in the correct format.

Data types in OpenOffice base are broadly classified into five categories listed below.

  1. Numbers – It stores numeric values having integers and fractional numbers.
  2. Alphanumeric Types (Text) – It holds the textual data with the combination of numbers and digits and special characters.
  3. Date-Time – The date-time data type is used to save the dates into a database field.
  4. Binary – Binary types stores large types of data such as images, audio or video files.
  5. Other Variable – Other variable types can have data of other remaining objects.

In the next section of Data types in Base Class 10 IT 402 let’s talk about details about above numeric types.

Numbers

Open Office Base Provides following different types of Numeric data types:

  1. BOOLEAN: Boolean is a data type which can store Yes/No type values in the form of 0 or 1 in OO base table. You can also represent values such as True or False using this data type.
  2. TINYINT: It is used to store the numbers ranging from 0 to 255
  3. SMALLINT: It is used to store the number ranging from -32768 to 32767
  4. INTEGER: It is used to store the number ranging from -2147483648 to 2147483647
  5. BIGINT: It is used to store the number ranging from -9223372036854780000 to 922337203685479999
  6. NUMERIC: It stores a number with maximum precision of e(+/)-231
  7. DECIMAL: Its stores a decimal number with maximum precision of e(+/)-231
  8. REAL, FLOAT, DOUBLE: It is used to store a number from 2-1074 to (2-2-52*21023)

Class 10 Creating and Using Tables in Open Office Base Notes by J.D Sir


Text

Open Office Base provides following types of Text data types:

  1. LONGVARCHAR: It is a memo data type that allows long text into a field. It accepts UTF 8 pattern characters and the maximum length of the text is 2,14,74,83,647 characters.
  2. CHAR: It allows fixed-length character text into a column. It accepts UTF-8 pattern characters having 17 characters length by default. It pads with trailing spaces for short strings.
  3. VARCHAR: It stores text up to a specified length of characters. It doesn’t allow any type of padding. OO base accepts 20 characters length by default.
  4. VARCHAR_IGNORECASE: It little bit similar to varchar with one difference that it will ignore a specific case like capital or small as you type.

Binary Types:

Open Office Base provides following types of binary data types:

  1. LONGVARBINARY: This type will store a specific image with array of bytes i.e. images, sound files etc. without validation.
  2. BINARY(fix)/Binary: This is also used to store data into binary form.

Date/Time

Sometimes you need to store dates like date of admission, date of joining, date of birth, date of event, date of transaction with a specific time or without time. The date/time data types is used to store such dates in Open Office base tables.

Open Office Base provides following types of Date/Time data types:

  1. DATE: It stores a date in common format like month, day and year i.e. 1/1/99. The date ranges are 1/1/99 to 1/1/9999
  2. TIME: It stores a particular time in hour, minute and seconds format. The seconds since 1/1/1970.
  3. TIMESTAMP: It stores the value with and time together in the table field.

Class 10 Creating and Using Tables in Open Office Base Notes by J.D Sir


Other Data Types

In these types of data type, you can store any serialized objects of java like connector or specific script through objects. It is mostly used for the coding purpose only.

So here we have covered Data types in Base Class 10 IT 402. I hope you enjoyed this article.

Class 10 IT Perform Operations on Table in Open Office Base Notes

Perform Operations on Table in Open Office Base

In Base, data is kept in tables that may be added to, changed, or deleted by using the proper options.

Insert Data in the Table

  • Step 1 : Select the table > Double click on it
  • Step 2 : The table will open in Datasheet View
  • Step 3 : Now you can Insert Number of records in Datasheet View

Editing Records in the Table

  • Step 1 : Select the table > Double click on it.
  • Step 2 : The table will open in Datasheet View
  • Step 3 : Edit the record as per the requirement

Deleting Record From the Table

  • Step 1 : Select the table > Double click on it.
  • Step 2 : The table will open in Datasheet View
  • Step 3 : Right click on data and select delete option

Field Properties

To modify the field’s attributes It is necessary to modify the table structure in design view. The following actions will be taken to set the field’s properties:

Select the table > Right click > Select the option Edit > the table Design View window will open

Following are some properties of data of the numeric type:

  1. AutoValue – if set to yes then field will get the auto numeric values.
  2. Length – By default length of the field is 10 but the size of the field can be set to maximum length.
  3. Default Value– A default value can be set for a field if user don’t provide any value while entering the values in the table.
  4. Format example – This property helps to set the format of the data entered in the field such as 91-222-333.

Following are some properties of data of the character type:

  1. Entry Required – if set to yes then it will be must to insert the value in the field which means that field cannot be left blank.
  2. Length – By default length of the field is 10 but the size of the field can be set to maximum length.
  3. Default Value – A default value can be set for a field if user don’t provide any value while entering the values in the table.
  4. Format example – This property helps to set the format of the data entered in the field such as 91-222-333.

Sorting Data

Sorting means to arrange the data in either ascending order of descending order. Sorting is the process of putting data into a meaningful order so you can evaluate it more efficiently.

Referential Integrity

The relationship between tables is referred to as referential integrity. Referential integrity is used to maintain accuracy and consistency of data in a relationship. In Base, data can be linked between two or more tables with the help of primary key and foreign key constraints.

Referential integrity helps to avoid:

1. Adding records to a related table if there is no associated record available in the primary key table.
2. Changing values in a primary if any dependent records are present in associated table(s).
3. Deleting records from a primary key table if there are any matching related records available in associated table(s).

Creating and Editing Relationships between Tables

An association or link between two or more tables is referred to as a relationship. You don’t have to enter the same data again in different tables when you relate two tables.

Relationships between tables helps to :

  1. Save time as there is no need to enter the same data in separate tables.
  2. Reduce data-entry errors.
  3. Summarize data from related tables.

Type of Relationships in Database

There are three types of relationships which can be created in tables:

1. ONE to ONE
2. ONE to MANY OR MANY to ONE
3. MANY to MANY

ONE to ONE

In this relationship, both the tables must have primary key columns.

ONE to MANY OR MANY to ONE

In this relationship, one of the table must have primary key column. It signifies that one column of primary key table is associated with all the columns of associated table.

MANY to MANY

In this relationship, no table has the primary key column. It signifies that all the columns of primary key table are associated with all the columns of associated table.

Note :

Removing the Relationships : With the use of the Delete option, the relationships that have been applied to the tables can also be deleted. When you right-click a relationship thread, the Delete option will appear.

Class 10 IT Retrieve Data using Query in Open Office Base Notes

Retrieve Data using Query

In order to describe the data structure and to modify the data in the database, queries are used as instructions. A query enables the joining and filtering of data from various tables.

Database Languages having two type:

  1. DDL (Data Definition Language)
  2. DML (Data Manipulation Language)

DDL Statements:

  • Create: Using this statement, a database or set of tables can be created.
  • Alter: This statement is used to change the table’s structure.
  • Drop: This statement is used to remove database objects from the system.

DML statements:

  • SELECT: The statement “SELECT” is used to get data from the database.
  • INSERT: The statement “INSERT” is used to add a new record to the database.
  • DELETE: The database can be cleaned out by using the statement DELETE.
  • UPDATE:This statement is used to modify the database’s information.

Database Query

Query is a computer languages. In order to describe the data structure and to modify the data in the database, queries are used as instructions. Query can extract particular data from a database. We can filter and join data from various tables with the help of a query. By using the criteria you supply query will filter the data.

Select Statement

A select query is a language in a database that displays data in Datasheet view. Data from tables is displayed by a query rather than being stored by it. A query may display data from one or more tables, from other queries, or from both of these sources simultaneously.

The SELECT statement has many optional clauses:

  • WHERE specifies which rows to retrieve.
  • ORDER BY specifies an order in which to return the rows.

Syntax of Select Statement is – 

SELECT * FROM <TABLENAME>;

Query related to Simple Select Statement –


Table Name : Product

Product_No Product_Name Price Quantity
29 Mouse 140 60
51 Keyboard 700 50
15 Monitor 3500 15
42 CPU 12000 100

Question : Write a Query to display all record from the table.


Solution : Select * from product;

Output:

Product_No Product_Name Price Quantity
29 Mouse 140 60
51 Keyboard 700 50
15 Monitor 3500 15
42 CPU 12000 100

Question : Write a Query to display product name from the table.

Solution : Select Product_Name from product;

Output:

Product_Name
Soap
Powder
Shampoo
Soap Box

Question : Write a Query to display Product_Name and Price from the table.

Solution : Select Product_Name, Price from product;

Output:

Product_NamePrice
Soap40
Powder80
Shampoo300
Soap Box120

Query related to Select Statement with Mathematical function:


Table Name : Product

Product_No Product_Name Price Quantity
29 Mouse 140 60
51 Keyboard 700 50
15 Monitor 3500 15
42 CPU 12000 100

Question : Write a Query to find the total no of quantity available in table.

Solution : Select sum(quantity) from product;

Output:

sum(quantity)
225

Question : Display the total amount of each item. The amount must be calculated as the price multiplied by quantity for each item.

Solution : Select Product_No, Product_Name, Price * Quantity from product;

Output:

Product_NoProduct_NamePrice*Quantity
29Mouse8400
51Keyboard35000
15Monitor52500
42CPU120000

Question : Write a query to find the average price of the total product;

Solution : Select avg(price) from product;

Output:

avg(price)
4085

Query related to Select Statement with Where clause.


Table Name : Product

Product_No Product_Name Price Quantity
29 Mouse 140 60
51 Keyboard 700 50
15 Monitor 3500 15
42 CPU 12000 100

Question : Write a Query to display the product whose price is less than 90.

Solution : Select * from product where price > 750;

Output:

Product_NoProduct_NamPriceQuantity
15 Monitor 3500 15
42 CPU 12000 100

Question : Write a Query to find the total amount of the Mouse product;

Solution : Select Price*Quantity from product where Product_Name = ‘Mouse’;

Output:

Price*Quantity
8400

Question : Write a Query to display the data whose quantity is equal to 50.

Solution : Select * from product where quantity = 50;

Output:

Product_NoProduct_NamPriceQuantity
51 Keyboard 700 50

Question : Write a Query to display a list of Products whose Price between 150 to 850.

Solution : Select * from product where Price >= 150 and Price <= 850;

Output:

Product_NoProduct_NamPriceQuantity
51 Keyboard 700 50

Query related to Select Statement with Order by:

Table Name : Product

Product_No Product_Name Price Quantity
29 Mouse 140 60
51 Keyboard 700 50
15 Monitor 3500 15
42 CPU 12000 100

Question : Write a Query to display the list of Product_Name in alphabetical order/ascending order.

Solution : Select * from product order by Product_Name ASC;

Or

Solution : Select * from product order by Product_Name;

Output:

Product_NoProduct_NamPriceQuantity
42 CPU 12000 100
51 Keyboard 700 50
15 Monitor 3500 15
29 Mouse 140 60

Note : For Descending order use Desc. Example: Select * from product order by Product_Name Desc; This query will show Product_Name in Descending order


Question – Write a Query to display the list of Price in descending order.
Select * from product order by Price DESC;

Output – 

Product_NoProduct_NamPriceQuantity
45Shampoo25025
52Soap Box120100
31Powder8030
25Soap4080

UPDATE statement 

To edit or update already-existing records in a table, use the UPDATE statement. Using the WHERE clause, you can either define a specific subset of entries to edit or use it to update everything at once. 

Syntax of Update Statement –

UPDATE <table name> SET = value [, column_name = value ...] [WHERE ];

Table Name – product 

Product_NoProduct_NamePriceQuantity
25Soap4080
31Powder8030
45Shampoo25025
52Soap Box120100
Database Management System Class 10 Notes

Question – Write a Query to update the price of Shampoo in the product table.

Update product Set Price = 300 where Price = 250;

Output – 

Product_NoProduct_NamePriceQuantity
25Soap4080
31Powder8030
45Shampoo30025
52Soap Box120100

Question – Write a Query to update the Quantity of Powder in the product table.

Update product Set Quantity = 50 where Product_Name = ‘Powder’;

Output – 

Product_NoProduct_NamePriceQuantity
25Soap4080
31Powder8050
45Shampoo25025
52Soap Box120100
Database Management System Class 10 Notes

Create Table 

To create a new table in the database you can use Create Table Command.

Syntax of Create Table –

CREATE TABLE table_name column1 datatypecolumn2 datatypecolumn3 datatype);

Question – Write a Query to create the following table in the database;

Table Name – product

FieldDataType
Product_NoInteger
Product_NameVarchar(20)
PriceInteger
QuantityInteger
Database Management System Class 10 Notes
Create table product ( Product_No Int, Product_Name Varchar(20), Price Int, Quantity Int);

Output – 

Product_NoProduct_NamePriceQuantity
Database Management System Class 10 Notes

Insert Table

Insert statement is primarily used to add a single or more rows to the target table.

Syntax of Insert Table –

INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);

Or 

INSERT INTO table_name VALUES (value1, value2, value3, ...);

Table Name – product 

Product_NoProduct_NamePriceQuantity
25Soap4080
31Powder8030
45Shampoo25025
52Soap Box120100

Question – Write a Query to add a new row with the following details 

(72, “Hair Conditioner‟, 350, 60)

Insert into product (Product_No, Product_Name, Price, Quantity) values(72, “Hair Conditioner‟, 350, 60);

Or

Insert into product values(72, “Hair Conditioner‟, 350, 60);

Output –  

Product_NoProduct_NamePriceQuantity
25Soap4080
31Powder8030
45Shampoo30025
52Soap Box120100
72Hair Conditioner35060

Class 11 IP Chapter 1 Computer System Question Answer

In Class 11 IP, students can access a variety of question-answer formats, including multiple-choice questions (MCQs), tailored to the CBSE syllabus. These MCQs cover all chapters of Informatics Practices and are designed to aid students in their preparation. Here studetns will get different types of questions like Theory based question answer, Assertion and Reason Based, Case Study Based, Find The Output Based and Concept Based, offering comprehensive practice for CBSE IP Class 11.

  1. Multiple-choice questions (MCQs)
  2. Theory Question Answer

Class 11 IP Chapter 1 Computer System Notes

Class 11 IP Chapter 1 Computer System Notes : CBSE Class 11 is crucial for students as it sets the groundwork for Class 12. Our Class 11 Revision Notes are here to ease the stress and help students excel. These notes are crafted by J.D Sir, align with the latest CBSE syllabus of Informatics Practices, covering all subjects concisely for effective learning.

Important Short Notes on Computer System : Code with J.D Sir


What is Computer System?

Combination of Software and Hardware together is called Computer System. A computer is a device (hardware) that can perform operations in accordance with a set of instructions called program (software).


Component of Computer System

Since a computer follows Input-Process-Output cycle, thus components of computer are categorized in three parts:

  1. Input Devices
  2. Central Processing Unit
  3. Output Devices

The basic component structure of computer is as shown below:

As shown in diagram various part of computer interact together to make the computer work, you input data to computer by using input devices and the CPU acts upon this data and provide output which is made available to user by using output device.


Input devices

Input device is responsible for taking input from user and provide to computer. Some most commonly used input devices are :

  • Keyboard
  • Mouse
  • Microphone
  • Webcam
  • Scanner
  • Bar code reader
  • Light pen
  • Joystick

Output devices

Output device is responsible for providing and displaying output to user. Some most commonly used output devices are:

  • Monitor- LED Monitor, LCD Monitor, CRT Monitor
  • Printer- Impact Printer (Inkjet, Dot-Matrix), Non-Impact Printer (Laser, Inkjet)
  • Plotter
  • Speaker

CPU (Central Processing Unit)

CPU is control center of computer. It understands the instructions and carries out operations on the computer accordingly. It is the brain of computer and controls the activity performed by the computer.

The CPU has three components:

  • ALU (Arithmetic and Logical Unit)
  • MU (Memory Unit)
  • CU (Control Unit)

ALU (Arithmetic and Logical Unit)

ALU is component which is responsible for all the arithmetic or logical operation done on the data. Arithmetic operations are the basic mathematical calculations. Logical operations are basically comparison operation involves comparing data and determine different action to be performed PROCESSOR.

CU (Control Unit)

The control unit is a component which controls the flow of data and operations in a computer. It acts as a manager and instructs and coordinates all the components of CPU to perform their respective task.

MU (Memory Unit)

Memory unit is a component which is responsible for storing all data and information and instructions.


Memory

Memory of computer is more like a predefined working space where it temporary keep information and data to facilitate its performance. When the task is performed, it clears it’s memory and memory space is then available for the next task to be performed. This memory is often called main memory. There are two types of memory:

Primary Memory

Primary memory also known as Volatile memory that is temporary as it loses its contents when the computer’s power is turned off. It is internal memory that is accessed directly by the processor. Following are the Primary memory:

  1. RAM: Random Access Memory is the memory that the computer uses for storing the programs and their data while working on them. We can either read data from the RAM or write onto it. Hence it is called read/write memory.
  2. ROM: Read Only Memory is used to store the data about the hardware which does not required frequent updates, for example startup programs that loads Operating System into RAM. ROM is non-volatile memory. We can only read data from the ROM and hence called read only memory.
  3. Cache Memory:  Catch memory is very high speed memory which is placed between processor and RAM to speed up the operations of CPU. Generally it stores the copies of data frequently accessed from RAM.

Secondary Memory

Secondary memory also known as non-volatile memory stores data and instructions permanently for future use. It is slower than primary memory but cannot be accessed by processor directly. Example of Secondary Memory are :

  • Hard Disk
  • CD/DVD
  • USB Flash Drive
  • Memory Card

Memory Unit

‘Byte’ is unit of memory used to measure amount of space consumed by data or instructions in memory.

Memory size conventions

1 Kilobyte = 1024 Bytes

1 Megabyte = 1024 KB

1 Gigabyte = 1024 MB

1 Terabyte = 1024GB

1 Petabyte = 1024TB

1 Exabyte = 1024 PB


Data Capturing

Data capturing refers to process of collecting or inputting data from different sources. To input data different input devices can be used such as keyboard, scanner, camera, bar code reader etc. data capturing might be a complex process due to nonuniformity in data. 


Data Storage

Data storage refers to process of storing captured data for future use. There are many different types of storage device are available which can be used to store data. Now a day due to rise in computers, Internet and Technology large volume of data being produced and hence the storage device should be of large capacity and updated regularly. to store large amount of data, Server can be deployed or Cloud computing can also be used.


Data Retrieval

Data Retrieval refers to accessing or fetching data from storage device as per requirement. Due to large volume of data now a day, system must have good quality and effective programs in order to access data at minimum time.


Data Deletion and Recovery

Deleting data refers to erasing data from storage device. There can be many reasons for deleting data such as system crash, accidental deletion, and illegal deletion by hackers/mischief mongers. When data is deleted from storage media, only the status (address entry) of data is changed and that space is shown empty to user without deleting data actually.

Data recovery is process of accessing deleted, lost or corrupted data from storage device. Deleted data can only be recovered when memory space of deleted data have not been overwritten with new data.


Software

Software is set of programs that instruct hardware to what to and how to do. It makes hardware functional to achieve a common objective. Some example of software is Window10, Macintosh, MySQL, MS Word, Excel, Games etc.

Types of software

There are two types of software:

  • System software
  • Application software

System Software

System software manages computer system. It is software that control and coordinate all internal activities of a computer system.

System software can be categorized as

  • Operating System
  • Utility Software
  • Device Driver

Operating System

Operating System acts as an interface between user and machine. It is set of programs that –

  • Manages hardware resources
  • Manage memory
  • Display result in monitor
  • Control all hardware component attached to computer system
  • Read data through input devices

Examples of Operating System are Window10, Window8, Macintosh, Ubuntu, DOS etc.

Utility software

It is system software that helps you to configure and optimize and maintain a computer. Examples of utility software are- Disk Cleaner, File Backup Utility, Antivirus, Firewall, Disk Defragmenter etc.

Device Driver

Device driver is software which controls a particular type of hardware attached with a computer. It acts as an interpreter between particular hardware and computer system.


Realted Queries : Class 11 IP Computer System Short Notes, Information Practices Short Notes, CBSE Class 11 Information Practices Important Notes for Exam

Class 11 IP Chapter 1 Computer System MCQ Set 1

Class 11 IP Chapter 1 Computer System MCQ Set 1

Q1. Arrange memory units in ascending order as per their capacity.

a. TB<GB<MB<KB

b. GB<TB<KB<MB

c. MB<KB<GB<TB

d. KB<MB<GB<TB

Show Answer d. KB<MB<GB<TB
 

Q2.ASCII stands for:

a. American Standard Code for International Information

b. American Standard Code for Information Interchange

c. American Standard Code for International Interchange

d. American Standard Code for Internet Information

Show Answer b. American Standard Code for Information Interchange
 

Q3._________ is a component of the processor that performs arithmetic, comparision and logical operations

a. ALU

b. MU

c. CPU

d. CU

Show Answer a. ALU
 

Q4. Hari bought a new laptop, he noticed that there was a flat surface to control the pointer instead of a mouse. What is the flat surface called?

a. Mousepad

b. Touchpad

c. Keypad

d. Touch Screen

Show Answer b. Touchpad
 

Q5.________ is usually used with handheld devices, such as digital cameras, camcorders and other equipments used for photography.

a. Flash Drive

b. USB Drive

c. Memory card

d. Floppy Drive

Show Answer c. Memory card
 

Q6.Pen drive is known as:

a. Flash Drive

b. PD

c. Scan Drive

d. Short Drive

Show Answer a. Flash Drive
 

Q7.Device driver handles all the operation except :

a. System booting

b. System call from user process

c. User level request

d. Memory management

Show Answer a. System booting
 

Q8.In Information Technology, Information means :

a. Output returned by computer after processing data

b. Any report generated by computer

c. Plural of data

d. Collection of raw facts and figures

Show Answer a. Output returned by computer after processing data
 

Q9.The central processing unit

a. Is operated from control panel

b. Is managed by input device

c. Controls all input, output and processing

d. Controls memory and data transfer.

Show Answer c. Controls all input, output and processing
 

Q10._________ = 1024x1024x1024Bytes

a. 1KB

b. 1MB

c. 1GB

d. 1TB

Show Answer c. 1GB
 

Q11.A computer is an ______________ device.

a. Electronic

b. Electrical

c. Mechanical

d. None of the above

Show Answer a. Electronic
 

Q12.A computer takes ________________ , ________________ it and gives __________________.

a. process, input, output

b. input, output, process

c. input, process, output

d. None of the above

Show Answer c. input, process, output
 

Q13.CPU stands for ___________________ .

a. Central Processor Unit

b. Central Processing Unit

c. Control Processing Unit

d. None of the above

Show Answer b. Central Processing Unit
 

Q14.CPU is called _____________ of computer.

a. Heart

b. Brain

c. Eyes

d. None of the above

Show Answer b. Brain
 

Q15.CPU can be placed on one or more microchips called IC. Here IC stands for ___________ .

a. Integrated Circuit

b. Internal Circuit

c. Interesting Circuit

d. None of the above

Show Answer a. Integrated Circuit
 

Q16.The ICs are made up of _______________ materials.

a. Conductor

b. Insulator

c. Resistor

d. Semiconductor

Show Answer d. Semiconductor
 

Q17.ALU stands for __________ .

a. Arithmetic Logic Unit

b. Arithmetic Logic Universe

c. Arithmetic Logic gates Unit

d. None of the above

Show Answer a. Arithmetic Logic Unit
 

Q18.CPU has two main components _________ and _________ .

a. ALU and Memory Unit

b. CU and ALU

c. Input and Output Unit

d. None of the above

Show Answer b. CU and ALU
 

Q19. Data entered through input device is temporarily stored in _________ .

a. RAM

b. ROM

c. Hard disk

d. All of the above

Show Answer a. RAM
 

Q20. Which of the following is a type of printer?

a. ink jet

b. laser jet

c. Dot Matrix

d. All of the above

Show Answer d. All of the above
 

Class 11 IP Chapter 1 Computer System Very Short answer Type Question Answer

Q.1 What is volatile memory?

Ans: RAM is known as Volatile Memory because when we switch off the computer its data is vanished.

Q.2 Define each of the following:

(a) byte (b) kilobyte (c) megabyte (d) gigabyte (e) terabyte

Ans: (a) byte: This is the unit of memory in computer. 1 byte = 8 bits
(b) kilobyte: This is the unit of memory in computer. 1 kilobyte = 1024 bytes
(c) megabyte: This is the unit of memory in computer. 1 megabyte = 1024 kilobytes
(d) gigabyte: This is the unit of memory in computer. 1 gigabyte = 1024 megabytes
(e) terabyte: This is the unit of memory in computer. 1 terabyte = 1024 gigabytes.

Class 11 IP Chapter 1 Computer System Short Type Question Answer

Short Answer Type Questions

Q.1 State the basic units of computer. Name the subunits that make up the CPU, and give the function of each of the unit.

Ans: Basic units of computer are Input Unit, Central Processing Unit and Output Unit. Sub unites of CPU are Arithmetical Logical Unit(ALU), Control Unit (CU) and Memory Unit(MU).

Q.2 What is the function of memory? What are its measuring units?

Ans: The computer memory is a temporary storage area. It holds the data and instructions that the Central Processing Unit (CPU) needs. Before a program can run, the program is loaded from some storage medium into the memory. This allows the CPU direct access to the program. Its measuring units are byte, kilobyte, megabyte, gigabyte, terabyte etc.

Q.3 What is the role of CPU of a mobile system? 

Ans: A mobile processor is found in mobile computers and cellphones. A CPU chip is designed for portable computers, it is typically housed in a smaller chip package, but more importantly, in order to run cooler, it uses lower voltages than its desktop counterpart and has more sleep mode capability. A mobile processor can be throttled down to different power levels or sections of the chip can be turned off entirely when not in use. Further, the clock frequency may be stepped down under low processor loads. This stepping down conserves power and prolongs battery life.

Q.4 What are various categories of software?

Ans: Software are classified into following categories –
(i) System Software
     a. Operating System
     b. Language Processor
(ii) Application Software
     a. Packages
     b. Utilities
     c. Customized software
     d. Developer Tools

Q.5 What is the difference between an interpreter and a compiler?

Ans: Interpreter: Interpreter is a type of system software that translates and executes instructions written in a computer program lini-by-line, unit by unit etc. It is slower in execution because each time when you run the program translation is required.

Compiler: Compiler is another type of system software that translates and executes instructions written in a computer program in one go. Once compiled program need not to translate again so it works faster.

Q.6 What is application software? Why it is required?

Ans: Application software is the set of programs necessary to carry out operations for a specific task. Such as for word processing there are many application software like MS-Word, Wordpad etc. These software are required to perform special task using the computer like painting, recording, typing, data handling etc.

Q7. Briefly explain the basic architecture of a computer.

Ans: Computer organization refers to logical structure of a computer describing how its components are connected to one another, how they affect one another's functioning and contributes to overall performance of computer.
Computers follow the 'IPO' principal i.e.
Input >Process >Output
(That means a certain input is processed to Generate specific output)



Q.8 What do you understand by input unit? What is its significance? What does computer system consist of?

Ans: Input unit is formed by the input devices(Keyboard, mouse, MICR, OBCR etc.) attached to the computer. Input unit is responsible for taking input and converting it into computer understandable form(the binary code). Some common input devices are:
(i) Keyboard
(ii) Mouse
(iii) Microphone
(iv) Scanner
(v) Webcam
(vi) Optical Bar Code Reader
(vii) Optical Mark Reader
(viii) Magnetic Ink Character Reader
(ix) Touch Pad
(x) Track Ball
(xi) Joy stick
(xii) Touch Screen
(xiii) Biometric Sensors. Etc.

Q.9 What is the function of CPU in a computer system? What are its sub units?

Ans: The central processing unit (CPU) of a computer is a piece of hardware that carries out the instructions of a computer program. It performs the basic arithmetical, logical, and input/output operations of a computer system. The CPU is like the brains of the computer - every instruction,no matter how simple, has to go through the CPU. So let's say you press the letter 'k' on your keyboard and it appears on the screen - the CPU of your computer is what makes this possible. The CPU is sometimes also referred to as the central processor unit, or processor for short. So when you are looking at the specifications of a computer at your local electronics store, it typically refers to the CPU as the processor. Its sub units are:
(i) Control Unit       (ii) Arithmetical and Logical Unit (ALU)           (iii) Memory Unit

Q.10 What functions are performed by the control unit?

Ans: The CU controls and guides the interpretation, flow and manipulation of all data and information. CU sends control signals until the required operations are done properly by ALU and memory. Another function of CU is the program execution. It means carrying out all the instructions stored in the program. CU gets program instruction from the memory and executes them one after the other. CU acts as a supervisor by controlling and guiding the operation taking place.

Q.11 Distinguish between CPU and ALU?

Ans: Difference Between ALU and CPU is that arithmetic logic unit (ALU), another component of the processor, performs arithmetic, comparison, and other operations. While Processor also central processing unit (CPU), interprets and carries out the basic instructions that operate a computer.
The main difference between CPU and ALU is that the CPU is an electronic circuit that handles instructions to operate the computer while the ALU is a subsystem of the CPU that performs arithmetic and logical operations.

Q.12 What is the function of output unit in a computer system?

Ans: Input devices are the hardware that give computers instructions. Output devices relay the response from the computer in the form of a visual response (monitor), sound (speakers) or media devices (CD or DVD drives). The purpose of these devices is to translate the machine's response to a usable form for the computer user.

Q.13 Distinguish between internal and external memory.

Ans: Internal memory is usually chips or modules that you attach directly to the motherboard. Internal Memory is a circular disc that continuously rotates as the computer accesses its data. External memory often comes in the form of USB flash drives; CD, DVD, and other optical discs; and portable hard drives.


Class 10 Self Management skills Question Answer

Class : X
Information Technology (402)
PART A – EMPLOYABILITY SKILLS
Self-Management Skills II – Important Questions & Answers
By : JD Sir (PGT Computer)

Q 1. What do you mean by Self management?

Ans. Self-management, also referred to as ‘self-control,’ is the ability to control one’s emotions, thoughts and behavior effectively in different situations.

Q2. What is Stress?

Ans. Stress can be defined as our emotional, mental, physical and social reaction to any perceived demands or threats.

Q3. Give any two examples where small amount of stress is helpful.

Ans. Two examples where small amount of stress is helpful are :
        1. A fire alarm is intended to cause stress that alerts you to avoid danger.
        2. The stress created by a deadline to finish a paper can motivate you to finish it on time.

Q4. Write the effects of stress on our life.

Ans. It can harm our emotional and physical health, and limit our ability to function well at home, in school and within our relationships.

Q5. What is Stress management?

Ans. Stress management is managing stress by making a plan to be able to cope effectively with  daily pressures.

Q6. What are the benefits of Stress management?

Ans. Benefits of Stress management are :
        1. We have a joyful life.
        2. We will be more energetic and spend quality time with our friends and family.
        3. We can complete our task on time

Q7. Write four sign/symptoms of stress.

Ans. Four Symptoms of stress management are :
        1. Headache
        2. Sleeplessness
        3. Sadness
        4. Excessive worrying
        5. Nervousness

Q8. Name any four stress management techniques.

Ans. Four stress management techniques are :
        1. Time management
        2. Physical exercise and fresh air.
        3. Healthy diet
        4. Holidays with family and friends

Q9. Write four qualities of those person who work independently.

Ans. Four qualities are:
        1. They are self-aware, self-monitored and self-correcting.
        2. They take the initiative rather than being told what to do.
        3. They have the ability to learn continuously.
        4. They recognize their own mistakes.

Q10. Explain self-regulation.

Ans: Self-regulation refers to self-action or self-operation. It is one's ability to control and manage emotions, thoughts, behaviour and energy levels so that one can produce results which have positive effects on life. People who are good at self-regulation can cope well with changes and adjust to different situations easily. They consider changes to be positive experiences and see them as exciting opportunities for self-development.

Q11. Write three steps to manage emotional intelligence.

Ans. Three steps to manage emotional intelligence are :
  1. Understand your emotions: Observe your behavior and then work on the things you need to improve.
  2. Rationalize: Do not take decisions abruptly; be rational in your thinking.
  3. Practice: Do meditation and yoga to keep yourself calm.

Q12. What is self-awareness? List the types of self-awareness.

Ans. Self-awareness refers to gaining knowledge and a better understanding of ourselves. It enables us to experience ourselves as unique and separate individuals. It is about being honest with oneself
Self-awareness is of two main types:
  • Internal self-awareness
  • External self-awareness.

Q13. What do you mean by Self motivation?

Ans. Self-motivation is an internal force that pushes us to achieve our goals, feel happy and improve our quality of life.

Q14. Write four Qualities of Self-motivated people.

Ans. Four Qualities of Self-motivated People are:
  1. They know what they want from life.
  2. They are focused.
  3. They know what is important for them.
  4. They are dedicated to fulfill their dreams.

Q15. Write four steps of Self motivation.

Ans. Four steps of Self motivation are :
  1. Find out your strengths.
  2. Focus on your goals.
  3. Develop a plan to achieve your goals.
  4. Stay loyal to your goals.

Q16. What do you mean by Goal and Goal Setting?

Ans. Goals : They are a set of dreams with a deadline to get them, for example, saving pocket
money to buy a favorite mobile phone by a particular date.
Goal setting : It is all about finding and listing your goals and then planning on how to achieve them.

Q17. Arun is using SMART method to set goals. What is SMART stands for?

Ans. SMART stands for :
  • Specific
  • Measurable
  • Achievable
  • Realistic
  • Time bound

Q18. What do you mean by Time management?

Ans. Time management is the ability to plan and control how you spend your day well and do all that you want to do.

Q19. Write the four steps for effective Time management.

Ans. Four Steps for Effective Time Management are :
  1. Organise : We should plan our day-to-day activities.
  2. Prioritise : We should make our to-do-list
  3. Control : We should have a control over our activities and time.
  4. Track : We should identify and note where we have spent our time.

Q20. What are the different practices of self management skills?

Ans: Self – management skills are –
  1. Self – awareness : Ability to control your values, likes, strengths, dislikes and weaknesses, etc.
  2. Self – control : Holding the ability to control your behavior, discipline, and so on.
  3. Self – confidence : Believe in yourself and don’t be scared to take risks.
  4. Problem solving : Understanding a problem and finding the solution.
  5. Self motivation : Try to complete your tasks without any external help.
  6. Personal hygiene : Be healthy, clean and smart
  7. Positive thinking : Expressing certainty or affirmation even in tough situations
  8. Teamwork : Work in team to complete the goals
  9. Time management : According to your plan, achieve the task on time.
  10. Goal setting Plan and accomplish the goals within a timeframe.

Q21. Write a short note on the factors influencing self – management.

Ans: Factors influencing the self – management are patients, cognitive, mental, and behavioral
ability to identify disease – related symptoms, seek treatment, and to identify physical, psychological and social changes.

Q22. Write Self – management skills strengths and weaknesses?

Ans: Self – management skills strengths and weaknesses –
Strengths –
  1. Think that you are always good at
  2. Think about what you do well
  3. Think about what others appreciate about you
Weaknesses –
  1. Identify the areas where you struggle and what you find difficult to do
  2. Accept the feedback you receive from others
  3. Be positive with feedback and try to improve yourself.

Q23. What are the factors that decrease self – confidence?

Ans: Some of the factors which decrease self – confidence
  1. When we think we are unable to complete a task.
  2. When you feel bad from the past mistakes, and unmotivated.
  3. After failure in the first attempt, do not try again to achieve the goal.
  4. When we are surrounded by people who have negative thoughts.