Worksheet on Database Management Systems - Class 10 / Class 11/Class 12 - Information Technology /Computer Science / Informatics Practices

Worksheet on Database Management Systems

Class 10 - Information Technology  

Class 11/Class 12 - Computer Science / Informatics Practices 

Directions: Fill in the blanks with suitable words.

1 _______ is a collection of related information.

2 _______ are the basic building blocks of a database. 

3 Table is also known as ________

4 In a table, columns are also called ________ and rows are called _________.

Class 11 - Informatics Practices / Computer Science - Computer System Overview (Part-2) Questions and Answers (#eduvictors)(#class11InformaticsPractices)

Computer System Overview 

(Part-2) 

Questions and Answers 

Class 11 - Informatics Practices / Computer Science

Q1: What is an input device?

Answer: A device through which data and programs from the outside world enter the computer system is called an input device. It  converts the input data into a digital form that is acceptable by the computer system.


Q2: Identify the input device from the picture given below. Write one line description about each item .

Class 11 - Informatics Practices / Computer Science - Computer System Overview (Part-1) Questions and Answers (#eduvictors)(#class11InformaticsPractices)

Computer System Overview 

(Part-1) 

Questions and Answers 

Class 11 - Informatics Practices / Computer Science

Q1: What is a computer?

Answer: A computer is an electronic device, under the control of instructions stored in its memory that can accept data (input), process the data according to specified rules(Program), produce information (output), and store the information for future use.

The word 'computer' comes from the word 'compute' which means to calculate.  Therefore, a computer is an electronic device that can perform arithmetic operations at high speed.


Q2: Why a computer is also called a data processor?

Answer: A computer is also called a data processor because it can store, process and retrieve data whenever desired.

CBSE Class 11 - Informatics Practices - Python Basics - Numpy Arrays (Part-2) - Question and Answers (#CBSEclass11Python)(#cbse)(#eduvictors)

Numpy Arrays (Part-1) - Question and Answers

CBSE Class 11 - Informatics Practices - Python Basics

Q1: The following statement has an error. Write the correct statement.
>>> import numpy as np
>>> a = np.array(1,2,3,4)

Answer: The second statement should be a = np.array([1,2,3,4]) to create an ndarray.


Q2: What is the output of the following program?

        import numpy as np
        list1 = [1,2,3,4,5]
        np1 = np.array(list1)
        print(type(np))
        print(type(np1))
        print(np1[2])
        print(np1.shape)


Answer:
<class 'module'>
<class 'numpy.ndarray'>
3
(5,)

CBSE Class 11 - Informatics Practices - Python Basics - Numpy Arrays (Part-1) - Question and Answers (#CBSEclass11Python)(#cbse)(#eduvictors)

Python Basics - Numpy Arrays 

(Part-1) - Question and Answers

CBSE Class 11 - Informatics Practices

Q1: What is NumPy?

Answer: 

1. NumPy stands for Numerical Python.

2. It is the core library for scientific computing in Python.

3. A NumPy array (also called ndarray) is a homogeneous multidimensional array of data objects.

4. A NumPy array is a table of elements (usually numbers), all of the same type, indexed by a tuple of positive integers.

5. Numpy module provides a set of methods and tools for working with these arrays.

6. In Numpy dimensions are called axes. The number of axes is rank.

Q2: What is the command line option to install NumPy module?

Answer: Run the following command at the command prompt. 

pip install numpy

Q3: What is one dimensional (1D) array?

Answer: A one-dimensional array or 1D array is a named group of a contiguous set of elements having the same data type. 1D arrays are also called vectors.

Q4: What is a multi-dimensional array?

Answer: A multidimensional array is an array of arrays. Multi-dimensional arrays are also known as matrices. For example, a two-dimensional array (2D array) has two axes i.e. rows and columns.

CBSE Class 11 - Informatics Practices - Python Basics - List Manipulation (Part-2) - Question and Answers (#eduvictors)(#class11Python)

Python Basics - List Manipulation (Part-2) - Question and Answers

CBSE Class 11 - Informatics Practices

Based on syllabus of Class 11 Informatics Practices, here are important Questions and Answers covered for the chapter List Manipulation.

The questions and answers will familiarise you with basics concepts of Python Lists and provide a framework for understanding the programming concepts.Software development isn’t any one thing, but a myriad of practices that coalesce into software in the end. Python has been a versatile language and is used by companies to write all sorts of applications.

List is an important data structure, part of a core Python. Lists have a variety of uses including data science, statistics and scientific computing. List is considered as a collection of objects and is ordered and changeable(mutable). It allows duplicate members.

Q1: What is the output of the following code?

list =['I','N','D','I','A']

print(list[0:3])

print(list[3:])

print(list[:])

Answer:

['I', 'N', 'D']

['I', 'A']

['I','N','D','I','A']

Display Lists

Q2: What is the output of the following code? What does the '+' operator' do in the code snippet?

CBSE Class 11 - Informatics Practices - Python Basics - List Manipulation (Part-1) - Question and Answers(#class11InformaticsPractices)(#eduvictors)

Python Basics - List Manipulation (Part-1)

Question and Answers

CBSE Class 11 - Informatics Practices & Computer Science

Q1: What is a list in Python?

Answer: List is a collections of items and each item has its own index value. It is the most versatile datatype available in core Python which can be written as a list of comma-separated values (items) between square brackets.

e.g.
[] # empty list
[1,2,3,4] #list of integers
[2.0, 4.56, 8.91, ] #list of floats
['Sunday', 'Monday', 'Tuesday'] #list of floats
['Nikita', 16, 'Class 11', True, 86.7] # list of mixed values

CBSE Class 11 - Informatics Practices - Python - String Manipulation (Part-2) - Question and Answers(#class11Python)(#eduvictors)

Python - String Manipulation (Part-2)

Question and Answers

CBSE Class 11 - Informatics Practices

Q1: What are membership operators for strings?

Answer: Two membership operators are:
in Returns True if a substring exists in the given string otherwise returns false.
             e.g. "xy" in "xyz"  #returns True
                    "ab" in "xyz"  #returns False

not in Returns True is a substring does not exist in the given string;
e.g. "ab" not in "xyz"   #returns True
       "xy"  not in "xyz"   #returns False


Q2: What is the output of the following?
str1 = "Hello World!"
str2 = "he"
str3 = "He"
str2 in str1
str3 in str1

CBSE Class 11 - Informatics Practices - Python - Type Conversion and Type Casting - Question and Answers(#class11Python)(#eduvictors)

Python Basics - Type Conversion and Type Casting 

Question and Answers

CBSE Class 11 - Informatics Practices

Question 1: What is Type Conversion?

Answer: Type conversion means converting one data type to another data type. Python supports two types of type conversion:

1. Implicity Type Conversion
2. Explicit Type Conversion (also called Type Casting)


Question 2: What is implicit type conversion? Give an example.

CBSE Class 11 - Informatics Practices - Python - String Manipulation (Part-1) - Question and Answers(#eduvictors)(#cbseClass11Python)

Python - String Manipulation (Part-1)

Question and Answers

CBSE Class 11 - Informatics Practices

Q1: What is a string in Python?

Answer: String is a sequence of characters, which is enclosed between either single(' ') quotes or double quotes(" "), python treats both single and double quotes same.

e.g. 

      str1 = "Welcome to the Python World."

Q2: Can a double-quoted string contain single quotes? If yes, give an example.

Answer: Yes. 

Example:

str1 = "Nitika's Fashions" 

print(str1)

Similarly, A single-quoted string can also contain double quotes:

Example:

str2 = '"Help!", he exclaimed.'

print(str2)

CBSE Class 11 - Informatics Practices - Python - Augmented Assignment Operators (#eduvictors)(#cbseclass11Python)

Python - Augmented Assignment Operators

CBSE Class 11 - Informatics Practices

Python provides augmented assignment operators, which combine the impact of an arithmetic operator with an assignment operator.

e.g. If you want to add value of b to a and then assign the result to a i.e.  a = a + b can be written as
a += b

Various augmented operators are:

Operation	Description
x += y	x = x + y
x -= y	x = x - y
x *= y	x = x * y
x /= y	x = x / y
x //= y	x = x // y
x **= y	x = x ** y
x %= y	x = x % y
x &= y	x = x & y
x |= y	x = x | y
x ^= y	x = x ^ y
x >>= y	x = x >> y
x <<= y	x = x << y

CBSE Class 11 - Informatics Practices - Python Literals - Question and Answers (#eduvictors)(#cbsecClass11Python)

Python Basics - Literals

CBSE Class 11 - Informatics Practices 

Questions and Answers

Question: What is a character set? What is Python Character Set?

Answer: A set of valid characters recognized by python constitutes character set.

Python (from version 3.x onwards) supports the Unicode text. It has the following character set:
Letters: A-Z,a-z
Digits:  0-9
Special symbols: Special symbol available over a keyboard
White spaces: blank space,tab, carriage return, newline, form feed
Other characters: Unicode


Question: Can I type in Hindi in Python 3?

Answer: Yes, Python supports Unicode text, hence one can use multiple languages including Hindi.


Question: What is a token?

Answer: Smallest individual unit in a program is known as a token. It can be:
1. Keywords
2. Identifiers
3. Literals
4. Operators
5. Punctuators

CBSE Class 11 - Informatics Practices - Python - Variables (Questions and Answers)(#class11Python)(#eduvictors)

Class 11 - Informatics Practices - Python - Variables 

Q1: What are variables?

Answer: A variable is a name that is used to store data. It can be used to store different kinds of data. 

e.g. age = 16

It defines a variable named 'age' and stores integer value as '16'. Thus 'age' is an integer data type variable.

Every variable in Python is 'dynamic type' i.e. you need not declare data type of a variable or declare a variable before using it. Every variable in Python is an object.

Q2: What are the rules to define a valid variable?

CBSE Class 11 - Informatics Practices - Python Basics Questions and Answers (Part-2) (#eduvictors)(#cbsenotes)

Python Basics  Q & A (Part-2)

CBSE Class 11 - Informatics Practices

Q1: What are the different modes that can be used to test Python Program?  

Answer: In Python, programs can be written in two ways namely Interactive mode and Script mode.
Interactive mode or Interpreter mode allows us to write codes in Python command prompt  (  >>> ).
Script mode is used to create and edit python source file with the extension .py


Q2: Write the command to leave python shell or interpreter.

Answer: ^D (Ctrl+D) or quit () is used to leave the interpreter.


Q3: What is the advantage of interpreter mode?

Answer:  Working in interactive mode is convenient for beginners and for testing small pieces of code, as we can test them immediately.

CBSE Class 11 - Informatics Practices - Chapter Python Basics (Q and A) (#eduvictors)(#cbsenotes)

Python Basics 

(Q and A)

CBSE Class 11 - Informatics Practices

Q1: Who developed Python languages? Name the languages Python is based on.

Answer: Python programming language was developed by Guido Van Rossum in February 1991 python is based on or influenced with two programming language

- Abc language, a teaching language created as a replacement of BASIC, and

- Modula-3

Q2: Is Python a high level language or not?

Answer: Yes, is a very high level programming language like C or Pascal.

CBSE Class 11 - Informatics Practices - Python Snippets -1 (Arithmetic Operators) (#cbsenotes)(#eduvictors)

Python Snippets - 1(Arithmetic Operators)

Arithmetic operators are used with numeric values to perform mathematical operations. Python supports the following arithmetic operators

⑴ +   Addition: To add two numbers i.e. a + b
⑵ -   Subtraction: To find difference of two numbers i.e. a - b
⑶ *   Multiplication: Product of two numbers e.g. 2 × 3 = 6
⑷ /   Division: To find quotient in division i.e. returning the floating-point result of the computation
⑸ %   Modulus: To remainder in division method
⑹ //  Floor Division or Intger Division i.e. rounds the result down to the nearest whole number
⑺ **  Exponentiation e.g. find 12² = 144

The above said are also called binary arithmetic operator because it requires two operands.

CBSE Class 11 - Informatics Practices (with Python) - New Syllabus (2019-20) (#eduvictors)(#cbsenotes)

Informatics Practices (with Python)
Class 11 - New Syllabus (2019-20)

Code No. 065
Optional for the academic year 2018-19 and mandatory for the academic year 2019-20 onwards

1. Prerequisites

Since a lot of students join CBSE schools from schools run by a state board, we are not assuming any pre-requisites for this course other than basic mathematical skills. However, it will be helpful if the student has a basic knowledge of Computer Applications 1 and 2.

2. Learning Outcomes

1. Basic computational thinking. Learn how to reason with variables, state transitions, conditionals, and iteration.

2. Notion of data types, and higher order data structures such as lists, and dictionaries.

3. Concepts of data handling: creating, managing and working with Data Frames using Python Pandas.

4. Structure of simple SQL queries.

5. Cyber safety.

CBSE Class 11 - Informatics Practices Unit-I Sample Question Paper (2019-20) (#cbsepapers)(#eduvictors)

CBSE Class 11 - Informatics Practices
 Unit-I Sample Question Paper
 (2019-20) 

Getting good marks is very important for students of class 11. For this one must practice and attempt sample question papers within time limits.

Here follows a sample question paper on Informatics Practices subject to assess your knowledge about the subject.

For studying you may refer following help guides:

1. Class 11 Informatics Practices (Python) Text Book
2. Class 11 Informatics Practices with Python

Entrance Exam/BCA/BBA/Class 11/Class 12 - Computer Awareness Quizzes (#eduvictors)(#cbsenotes)(#bcaentrance)

Computer Awareness Quizzes

Computer Awareness MCQs are available at eduvictors.com that may help you prepare for BCA/BBA entrance tests and Computer Science related examinations.

CBSE Class 12/ 11 - Informatics Practices - Java Practical Snippet-1 - Leap Year Testing (#cbseNotes)

Java Practical Snippet-1
Leap Year Testing  

Question: Input a year and check if the year is leap year or not.

Answer: