CLASS - VI | CHAPTER -Loops using block coding ( SOLVED WORKSHEET)

CLASS - VI

CHAPTER - Loops using block coding

Worksheets

Objective Type Questions

Question 1 The if the statement is used to execute some code if a statement is

true.

Option 1 True

Option 2 False

Answer: Option 1

Question 2 An else statement should always be after an if statement which

executes when the code is false.

Option 1 True

Option 2 False

Answer: Option 1

Question 3 A while loop statement repeatedly executes a statement as long as

the condition remains true

Option 1 True

Option 2 False

Answer: Option 1

Question 4 Without a statement that eventually evaluates the while loop

condition to false, the loop will continue indefinitely

Option 1 True

Option 2 False

Answer: Option 1

Question 5 A for loop executes for a specific number of times

Option 1 True

Option 2 False

Answer: Option 1

Question 6 A continue statement is used to skip all the remaining statements in

the loop and moves the control back to the top of the loop.

Option 1 True

Option 2 False

Answer: Option 1

Question 7 When a break statement is encountered inside a loop, the loop is

immediately terminated, and the program execution moves on to the

next statement in the loop.

Option 1 True

Option 2 False

Answer: Option 1

Loops using block coding

72 | P a g e

Question 8 Doing something over and over again or repeating code is called as

Option 1 Code

Option 2 loop

Option 3 Program

Option 4 Bug

Answer: Option 2

Question 9 Which is the correct operator for equality testing?

Option 1 ==

Option 2 =

Option 3 !=

Option 4 +=

Answer: Option 1

Question 10 What is the output of the below pseudocode?

Option 1 5

Option 2 10

Option 3 15

Option 4 0

count = 0;

sum = 0;

while (count < 5)

{

 sum = sum + count;

 count = count + 1;

}

print sum;

Answer: Option 1

Question 11 Which letter won’t print while running the below pseudocode?

Option 1 ‘d’

Option 2 ‘c’

Option 3 ‘n’

Option 4 ‘o’

for letter in "coding":

 if letter == "i":

 break

 print(letter)

print("End")

Answer: Option 3

Question 12 Which letter won’t print while running the below pseudocode?

Option 1 ‘g’

Option 2 ‘o’

Option 3 ‘d’

Option 4 ‘i’

for letter in "coding":

 if letter == "i":

 continue

 print(letter)

print("End")

Answer: Option 4

CLASS - VII | CHAPTER -7 ( Understanding Arrays and Collections ) SOLVED WORKSHEET

CLASS - VII
CHAPTER - 7 ( Understanding Arrays and Collections )
Worksheets

Objective Type Questions

Question 1 What is the starting index of an array?
Option 1 -1

Option 2- 1

Option 3- 2

Option 4- 0

Answer: Option 4

 

Question 2 Which one is an incorrect array?

Option 1 Arr[] = [‘a’ , ‘b’ ,’c’ ,’d’]

Option 2 Arr[] = [1 , 2 ,3 ,4]

Option 3 Arr[] = [1, ‘a’, ‘b’, 2]

Option 4 Arr[] = [2.0 , 9.4, 5.6 , 6.7]

Answer: Option 3

 

Question 3 An array is

Option 1 A group of elements of same data type

Option 2 A type of collection that contains more than one element

Option 3 A type of collection in which elements are stored in memory in continuous or contiguous locations

Option 4 All of the above
Answer: Option 4

 

Question 4 Select a correct statement about Arrays

Option 1 An array address is the address of first element of array itself

Option 2 An array size must be declared if not initialized immediately

Option 3 Array size is the sum of sizes of all elements of the array

Option 4 All of the above

Answer: Option 4

 

Standard Questions

 1. What are collections?

Answer: A collection is nothing but a container that groups multiple items into a single object. Collections are used to store data. We can also retrieve and manipulate data that is stored in the Collections.

 

2. How can we iterate over collections?

Answer: The iterators are used to provide users a uniform way of accessing collections in a sequential manner. Whatever type of collection we are using, we always need to traverse through the elements of these collections to fetch the data or make any modifications to that data

3. What are the different types of modifications that we can perform on collections?

Answer: Modification operations (such as add, remove and clear)

 

CLASS - VII | CHAPTER -6 ( FUN WITH FUNCTIONS ) SOLVED WORKSHEET

CLASS - VII
CHAPTER - 6 ( FUN WITH FUNCTIONS )
Worksheets

 

Objective Type Questions 

Question 1 Function in a program decreases readability
                    Option 1 True
                    Option 2 False

Answer: Option 2 

Question 2 Function in a program increases code reusability 

                    Option 1 True 

                    Option 2 False 

Answer: Option 1 

Question 3 Functions in programming help in reducing code redundancy 

                    Option 1 True 

                    Option 2 False 

Answer: Option 1

Question 4 A function can return a value 

Option 1 True 

Option 2 False 

Answer: Option 1 

Question 5 What do we call the variables found in the definition of the function on which further operations may be performed? 

Option 1 Return value 

Option 2 Parameter(s) 

Option 3 Data types 

Option 4 None of the above 

Answer: Option 2

Standard Questions 

1. Explain  advantages of using functions. 

ANSWER: Few of the advantages of using functions are: 

                    Increases readability makes code organized and easy to understand. 

                    Reduces code length: redundant code is removed and replaced by functions. 

                    Reusability: Code reusability increases.

2. What are function parameters? 

ANSWER: The variables accepted by a function to perform the set of tasks defined in its body are called function parameters.

3. Explain how functions help in reducing redundancy of code. 

ANSWER: The main idea behind using a function in your code is to keep the code DRY (Don’t Repeat Yourself). Cutting  out repeated commands helps to minimize errors, keeps code short, and saves programming time.

4. Can functions return a value? 

ANSWER:  Yes functions can return a value.

5. Explain what the output of below program will be:

            def test(x, y):

             if x > y: 

             return y 

             def test1(x, y, z): 

             return test(x, test(y, z)) 

             print(test1(2, 7, -1)) 

ANSWER : 1

6. Find an error in the below program:

        def sum(numbers): 

        total = 0

        for x in number: 

        total += x 

        return total 

        print ( sum ( ( 1 , 2 , 3 , 4 , 5 ) ) )

ANSWER: Variable “number” is not defined anywhere in the program.

CLASS - VII | CHAPTER - 5 ( SEQUENCING WITH BLOCK CODING ) (Worksheet)

CLASS - VII
CHAPTER - 5  (SEQUENCING WITH BLOCK CODING )
Worksheets

Objective Type Questions

Question 1 What is a bug in programming? 

A. A feature in a program that causes it to run correctly 

B. A feature in a program that can predict output. 

C. A feature in a program that generates incorrect output. 

D. All the above 

Answer:  A feature in a program that generates incorrect output. 

Question 2 What is sequencing in programming? 

A. A programming structure, where steps are performed in an order. 

B. A programming structure, that repeats itself until a condition is met. 

C. A feature in a program that generates incorrect output. 

D. All the above 

Answer: A programming structure, where steps are performed in an order. 

Question 3 What is looping in programming?
A. A programming structure, where steps are performed in an order. 

B. A programming structure that repeats itself until a condition is met. 

C. A feature in a program that generates incorrect output. 

D. All the above 

Answer: A programming structure that repeats itself until a condition is met. 

Question 4 What is selection in programming? 

A. A list of instructions which are followed in a set order 

B. A list of instructions where there is a choice based on a condition 

C. A list of instructions which will loop based on a condition 

D. A list of instructions that will loop forever 

Answer: A list of instructions where there is a choice based on a condition 

Question 5 What is iteration in programming? 

A. A list of instructions which are followed in a set order 

B. A list of instructions where there is a choice based on a condition 

C. A list of instructions which will loop based on a condition 

D. A list of instructions that will loop forever 

Answer:  A list of instructions which will loop based on a condition 

Question / Answers

Question 1. Explain what an algorithm is with the help of an example.

Answer : An algorithm is a detailed step-by-step process that needs to be followed in order to complete a task or to solve a problem.

Example : add two number

• Program Start
• a=5
• b=10
• c=0
• c= a + b
• print a
• Program End

Question 2. What is a Bug? 

Answer : A bug is a terminology used to describe any unexpected problem in your program. Just like we learnt in the past topics, we follow a sequence of activities to complete a program. This program is expected to return a specific output. Any deviation in the expected and actual output of the program is known as a bug. 

Question 3. Create a pseudocode to check if age entered by the user is of a senior citizen or not. Consider that person is named as a senior citizen if his age is above 60 years old.

Answer :  int age = 61; 

                if (age>=60) 

                    print(“Person is a senior citizen”); 

                else 

                    print(“Person is not a senior citizen”);

                Endif

CLASS - VII | CHAPTER - 5 ( SEQUENCING WITH BLOCK CODING )

 

CLASS - VII | CHAPTER - 4 ( Variable in Real Life ) (Worksheet)

CHAPTER-4
Variable in Real Life
Worksheets

Objective Type Questions

1. Process of assigning value to a variable before it is being used is called: 

a. Initialization 

b. Operation 

c. Realization 

 Answer: Initialization 

2.  int k1, k2 = 23 is an example of: 

a. Variable declaration 

b. Adding values in a function 

c. None of them 

 Answer: Variable declaration 

3.  Which of the following is NOT a correct variable name? 

a.  2bad 

b.  Zero 

c.  the Last Value But One 

d.  Year2000

Answer: 2bad

4 Which of the following declarations is NOT correct?
a. Double duty; 

b. Float loan = 12.3; 

c. Boolean value = 21; 

d. Int start = 45, end = 99; 

 Answer: Boolean value = 21; 

5. Which of the following shows the syntax of an assignment statement? 

a. VariableName = expression; 

b. Expression = expression; 

c. Expression = VariableName; 

d. datatype = VariableName; 

 Answer: VariableName = expression;

6. What is an expression? 

a. The same thing as a statement 

b. An expression is a list of statements that make up a program 

c. An expression is a combination of literals, operators, variables, and parentheses used to calculate a value 

d. An expression is a number expressed in digits. 

 Answer: c. An expression is a combination of literals, operators, variables, and parentheses used to calculate a value 

7. What is the value of the following expression? (2 - 6) / 2 + 9 

a.  7 

b.  8 

c.  9 

d.  10 

 Answer: 7

Question / Answers

1. What is variable initialization?

Answer: A variable that is not initialized ever has an undefined value. Such a variable cannot be used until it is assigned with a certain value. In a case where a variable is declared (read – created) but it is not initialized, we can assign it a value in later steps using assignment operators. In programming, a variable can be initialized using the below 

syntax: Datatype VariableName = Value;

Example of declaring variables in python 

a = 5 

b = “Hello”

2. What is the syntax to initialize a variable in programming?

Answer: Syntax: Datatype VariableName = Value;

Example of declaring variables in python 

a = 5 

b = “Hello”

3. Why do you think validating user input is important in programming?

Answer: * An important part of making sure that your program works fine is to validate that the user enters valid values in the places where you are expecting an input from the user.

*Similarly, in programming, whenever you create a variable with a specific data type, and you are expecting a user to enter a certain value in that data type, you should make sure that the user enters the right type of value, which won’t cause any error during program execution.

*Any deviation of data type in the user's input will result in an error by program.

*A very common way of validating user input in flagging out the wrong input.

CLASS - VII | CHAPTER - 4 ( Variable in Real Life )

CLASS - VII | CHAPTER-3 (Charts in Excel) (Worksheet)

CHAPTER-3

Chart in Excel

    Worksheets

Worksheet 1  Multiple Choice Question (MCQs).

1. Which Axis is also known as Category axis?

1. Y-axis

2. X-axis

3. Z-axis

4. Circular axis
   
   

2. Which charts are useful for showing data changes over a period of time or for illustrating comparisons among items?

1. Pie Chart

2. Area chart

3. Column Chart

4. Scatter chart

3. Which option from the drop down menu will first resize the chart and then as a title above the chart area?

1. None

2. Centered overlay title

3. Above Chart

4. Below Chart

4. Which chart show trend in data at equal intervals?

1. None

2. Line Chart

3. Pie Char

4. Column Chart

5. What is used to represent Data series ?

1. Chart Title

2. Legends

3. X-axis

4. Y-axis

Worksheet 2  Write (T) for True and (F) for False against the statements. 

1. Y-axis is also called the Category axis.  FALSE

2. A category axis become a time scale axis when the Axis Type is set is set to Data axis. TRUE

3. The Y-axis shows the values of the plotted Data points. TRUE

4. Legends are used to represent the Data series. TRUE

5. A Spark line is a large chart in a worksheet cell. FALSE

Worksheet 3  Select the suitable words and fill in the blanks.

Chart title     Line Pie X-axis Y-axis Column

1. __COLUMN______ charts are useful for showing data changes over a period of time or for illustrating comparisons among items.

2. A____LINE_______ chart shows trend in data at equal intervals.

3. A_____Pie______ chart shows the proportional size of items included in single data series.

4. The ____X-axis______is also called the Category axis.

5. The ____Y-axis________is also called the Value axis.

6. The ____Chart title_____give you an idea about the topic of chart.

Worksheet 4  Match the following:

Answer:

Column A	Column B
Charts                                    -->	Represents data graphically.
Data Series                          -->	Gives us an idea about of related values, like all data values in a row or a column of the data sheet.
Legends                             -->	A name for a group of related values, like all data value in a row or a column of the data sheet.
Line Chart                        -->	Shows a trend in data at equal intervals.
Pie Chart                           -->	Shows the proportional size of the items included in a single data series.
Bar Chart                         -->	The best chart types for comparing multiple sets of value.
Chart Title                         -->	Used to represent the data series.

Worksheet 4  Answer the following:

1. Explain about the various chart types.

Answer: Column Charts -  In column charts, categories are typically organized along the horizontal axis (x-axis) and value along the vertical axis (y-axis).

Line Charts -  A Line charts shows a trend in data at equal intervals. Line charts are useful for depicting the change in a value over a period of time.

Pie Charts -  A pie chart shows the proportional size of the items included in a single data series.

Bar Charts -  Bar Charts are very similar to Column charts, the only difference is that bars are horizontal.

2. Write about the axis of chart.

Answer: Y-axis -  The Y-axis shows the value of plotted Data points. This is also called the Value axis.

X-axis -  The X-axis generally shows the category of plotted Data points. This is also called the category axis. A category axis becomes a time scale axis when the Axis Type is set to Date or Time axis.

3. What are Data series and Legends in a chart?

Answer: Data Series -  The Data series is a group of related values, like all Data values in a Row or a Column of the Data sheet.

Legends -  Legends are used to represent the Data series. These Legends are associated with a pattern or colour, which is associated with the series and placed on the Chart.

4. What will happen if you change a value in the data from where you have created the charts?Answer:  chart is also change according to the change the values in the data.

5. What do you know about Spark lines?

Answer: A sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. Position a sparkline near its data for greatest impact.

CLASS - 7 | CHAPTER-3 (Charts in Excel)

 SUBJECT: COMPUTER

CHAPTER-3

Chart in Excel

Understanding Charts

A chart is a graphical representation of data. Charts make it a lot more easier for us to analyze and interpret data. 

Elements of a Chart

Data Series -  The Data series is a group of related values, like all Data values in a Row or a Column of the Data sheet.

Chart Title -  The Chart Title, as the name suggests, gives you an idea about the topic of the chart.

Y-axis -  The Y-axis shows the value of plotted Data points. This is also called the Value axis.

X-axis -  The X-axis generally shows the category of plotted Data points. This is also called the category axis. A category axis becomes a time scale axis when the Axis Type is set to Date or Time axis.

Legends -  Legends are used to represent the Data series. These Legends are associated with a pattern or colour, which is associated with the series and placed on the Chart.

Various Chart Types

Column Charts -  In column charts, categories are typically organized along the horizontal axis (x-axis) and value along the vertical axis (y-axis).

Line Charts -  A Line charts shows a trend in data at equal intervals. Line charts are useful for depicting the change in a value over a period of time.

Pie Charts -  A pie chart shows the proportional size of the items included in a single data series.

Bar Charts -  Bar Charts are very similar to Column charts, the only difference is that bars are horizontal.

Steps to Create Charts

To create a chart is very easy task in Excel. You just need to click on the Insert tab and then select the chart type and sub type.

• Select the data from which you want to create the chart.

• Click on the Insert tab.

• Click on the Chart type button. A list of chart subtypes will be displayed.

• Click on the chart subtype.

Editing of Charts

You can also edit the chart to change the type or format the chart according to your requirements.

• Click anywhere in the chart.

• Click on the Chart Tools contextual tab.

• Click on the Change Chart Type button.

• The Change Chart Type dialog opens.

• In the left pane, select the chart type and in the right pane select the chart subtype.

• Click on the OK button

Changing the Chart Layout

The same chart can be presented in various layouts like Legend on the left, or at the bottom, with or without titles, etc.

• Click anywhere in the chart. You will see the Chart Tools contextual tab.

• Click on the chart Tools contextual tab.

• In the chart layout group, click on the More button. The various layouts will be displayed. Select the required layout.

• Select the chart style from the chart Styles gallery.

Adding the Chart Title

A chart title gives an idea about the topic of the chart. You can add the title to your excel chart to make it more meaningful.

• Click on empty are of the chart to which you want to add the chart title.

• Click on the layout tab.

• Click on the Chart Title button. A drop-down menu appears displaying option which specify how the chart title will be displayed on the chart.

• A text box containing the text “Chart Title” will be added to the chart. Replace the text in the text box with the text of the chart title.

    Worksheets

Worksheet 1  Multiple Choice Question (MCQs).

1. Which Axis is also known as Category axis?

1. Y-axis

2. X-axis

3. Z-axis

4. Circular axis
   
   

2. Which charts are useful for showing data changes over a period of time or for illustrating comparisons among items?

1. Pie Chart

2. Area chart

3. Column Chart

4. Scatter chart

3. Which option from the drop down menu will first resize the chart and then as a title above the chart area?

1. None

2. Centered overlay title

3. Above Chart

4. Below Chart

4. Which chart show trend in data at equal intervals?

1. None

2. Pie Char

3. Pie Char

4. Column Chart

5. What is used to represent Data series ?

1. Chart Title

2. Legends

3. X-axis

4. Y-axis

Worksheet 2  Write (T) for True and (F) for False against the statements. 

1. Y-axis is also called the Category axis. 

2. A category axis become a time scale axis when the Axis Type is set is set to Data axis.

3. The Y-axis shows the values of the plotted Data points.

4. Legends are used to represent the Data series.

5. A Spark line is a large chart in a worksheet cell.

Worksheet 3  Select the suitable words and fill in the blanks.

Chart title     Line Pie X-axis Y-axis Column

1. ________ charts are useful for showing data changes over a period of time or for illustrating comparisons among items.

2. A__________ chart shows trend in data at equal intervals.

3. A__________ chart shows the proportional size of items included in single data series.

4. The __________is also called the Category axis.

5. The ____________is also called the Value axis.

6. The ________give you an idea about the topic of chart.

Worksheet 4  Match the following:

Column A	Column B
Charts	Shows a trend in data at equal intervals.
Data Series	The best chart types for comparing multiple sets of value.
Legends	Used to represent the data series.
Line Chart	Shows the proportional size of the items included in a single data series.
Pie Chart	Represents data graphically.
Bar Chart	Gives us an idea about of related values, like all data values in a row or a column of the data sheet.
Chart Title	A name for a group of related values, like all data value in a row or a column of the data sheet.

Worksheet 4  Answer the following:

1. Explain about the various chart types.

2. Write about the axis of chart.

3. What are Data series and Legends in a chart?

4. What will happen if you change a value in the data from where you have created the charts?

5. What do you know about Spark lines?