L-7 Scratch/ Class-6 computer

 

Class – VI

Subject : Computer Science

L-7 Introduction to Scratch Programing

Paste and Label  components of Scratch Window

A)    Multiple Choice Questions

1)     Scratch program begins with which block?

a)     Ask block     

b)     Say block 

c)     Wait block 

d)     Event block

Ans: d) Event block

2)     What is this cat a type of?

a)     Animal 

b)     Cat species

c)     Pet

d)     Sprite

Ans: d) Sprite

3)     What kind of block do you use for moving sprite?

a)     Motion

b)     Sound

c)     Sensing

d)     Control

Ans: a) Motion

4)     What is the backdrop of project called?

a)     Stage

b)     Sprite

c)     Scratch

d)     Script

Ans: a) Stage

5)     A collection or stack of blocks that all interconnect with one another is called?

a)     Scratch

b)     Sprite

c)     Stage

d)     Script

Ans: d) Script

B)    Fill in the blanks:

1)     You can view thumbnail of stage and sprites in Sprite List area.

2)     The Shrink  button allows you to decrease the size of the sprite.

3)     The duplicate  tool is used to create a copy of an object.

4)     In scratch, the Sprite moves on the stage  when you run a program.

 

C)      State “T for True or “F” for False:

1)     You can change the background of the stage . TRUE

2)     The duplicate button allows you to move an object. FALSE

3)     You cannot insert more than two sprites on the stage. FALSE

4)     Scratch allows you to add sound in your project. TRUE

5)     The Centre of the stage is at x-y coordinate (0,0). TRUE

 

 D)     Short answer type questions:

1)     Who is the developer of Scratch?

Ans: The developer of Scratch is the Lifelong Kindergarten Group at the MIT Media Lab.

 

2)     What do you mean by programming?

Ans: Programming is the process of designing and building an executable computer program to accomplish a specific task or solve a particular problem. It involves writing a set of instructions in a programming language that a computer can understand and execute.

 

3)     Write the steps to move a sprite in Scratch?

Ans: Steps to move a sprite in Scratch:

 

·        Select the sprite you want to move.

·        Go to the "Motion" category in the blocks palette.

·        Drag the "Move" block and snap it into the scripting area.

·        Input the number of steps or use other motion blocks to control the movement.

 

4)     How to add sound in scratch program?

Ans: To add sound in Scratch program:

 

·        Go to the "Sound" category in the blocks palette.

·        Drag the desired sound block (e.g., "Play Sound," "Play Drum," etc.) into the scripting area.

·        Configure any parameters associated with the sound block.

 

5)     Write the steps to save a project in Scratch?

Ans: Steps to save a project in Scratch:

 

·        Click on the file menu in the top-left corner.

·        Select "Save Now" to save the project immediately.

·        Alternatively, select "Save now as" to choose a new location or rename the project.

·        Provide a name for the project and click "Save."

A)    

L-6 Block in Scratch / Class 7th Computer

 Class- VII

Subject: Computer 

L-6  Introduction to Blocks in Scratch

Answer the following questions:

A) Multiple choice questions:

1) What is the function of 'when green flag clicked' command block?

a) Points sprite in specified direction.

b) If condition is true, runs the block inside.

c) Runs the script.

Ans:  c) Runs the script

2) What will happen if we place the blocks in the scratch at wrong order?

a) The program will start working slowly.

b) The program will terminate.

c) The program will not work well.

Ans:c) The program will not work well.

3) What is the name of code blocks rounded or curved top and bump at the bottom?

a) Reporter Block

b) Stack Block

c) Hat Block

Ans: c) Hat Block 

4) Name the code block that controls sprite placement, direction, rotation, and movement.

a) Looks

b) Motion

c) Control

Ans: b) Motion

5) Identify the block given below.

a) Hat Block

b) Cap Block

c) C Block

Ans: c) C Block

B) Fill in the blanks using the words from the help box:

[ HAT, C, Stage, Boolean, Elongated ]

1) In Scratch, the sprite moves on the Stage when you run a program.

2) C blocks used for conditions and loops in script.

3) Boolean blocks are shaped like an  elongated hexagon.

4) These blocks are shaped like a  hat with a rounded top and a bump on the bottom.

5) Reporter blocks are used to report numeric, string, or Boolean values in your scripts.

C) State 'T' for True or 'F' False:

1) C blocks are used to stop script.                                 FALSE                                               

2) Reporter Blocks are rounded at the both end.            FALSE    

3)  You can turn the Sprite only in clockwise direction. FALSE

4) Hat Blocks are used to start script.                            TRUE

5) A sprite can move only in forward direction.           FALSE

                               

EXERCISE 

A) Multiple Choice Questions:

 1) Which block will perform arithmetical operations on numbers and / or variables.

a) Looks Block

b) Operator Block

c) Sensing Block

Ans: b) Operator Block

2) What block will be used to change the costume of a sprite?

a) Data Block

b) Looks Block

c) Operator Block

Ans:b) Looks Block

3) Which block used for logical test?

a) 

b)  

c)  

Ans: 

a) 

4) Name the thinking based on true / false conditions in script programming _________ .

a) Logical

b) Mathematics Based

c) Philosophical

Ans: a) Logical

5) Identify the block given below.

a) Data Block

b) Event Block

c) Control Block

Ans: c) Control Block

B) Fill in the blanks using the words from the help box:

[Block, Background, Script, Logical, Stage]

1) The  stage is 480 units wide and 360 units tall.

2) A programming language that uses code blocks to create directions for a compute is  Scratch. 

3) The  bakground image for a canvas is called a stage.

4) A  block is a specific instruction you use to create a program in scratch.

5) A hexagon shaped operator that returns a TRUE or FALSE condition is called  logical operator.

C) State "T" for True or " F" for False:

1) The Centre of the stage is at x-y coordinate (0, 0)         TRUE

2) Scratch is not able to use webcam.                                TRUE

3) To control the flow or timing of other code blocks, you will use control blocks.                                                                    TRUE

4) Boolean data will contain "True" or "False" vales.       TRUE

5) Clone block will creates a copy of sprite.                      TRUE

L-6 Forms/ Query Class 8th

 

Class- VIII

Subject: Computer

L-6 Forms and query

A)  Fill in the blanks:

 

1)    Ms-Access is a relational management system.

2)    A database stores vast amount of data.

3)    Reports collect the summarized data from one or more tables.

4)    All the columns in a table are called fields.

5)    It has a field name ‘ID’, which is considered the primary key.

 

B)  Write short notes on :

1)    Forms:

Ans: Forms in Microsoft Access provide a user-friendly interface for interacting with the data in a database. They allow users to view, enter, and edit data in a structured manner.

Forms are designed to present the data in a visually appealing and organized way, often resembling paper forms. They can include text boxes, buttons, drop-down menus, and other controls for data input.

Forms can also include features like validation rules, which help ensure that data entered meets certain criteria. They can be customized to control the flow of information and automate tasks within the database.

2)    Report:

Ans: Reports in Microsoft Access are used to present data in a structured and organized format for printing or viewing on the screen. They are often used to create professional-looking documents based on the information stored in the database.

Reports allow for the inclusion of headers, footers, page numbers, and other elements to enhance the presentation. They can include data from one or more tables and can be customized to display specific information in a desired format.

Reports are particularly useful for summarizing and analyzing data, as well as for generating documents like invoices, statements, or any other form of printed output.

3)    Query:

Ans: Queries in Microsoft Access are used to retrieve, manipulate, and analyze data from one or more tables. They allow users to ask specific questions or perform operations on the data stored in the database.

Queries can be simple, such as retrieving all records that meet certain criteria, or they can be complex, involving multiple tables and various operations like joins, calculations, and aggregations.

They can also be used to update, delete, or append records in a database. Queries provide a powerful tool for extracting meaningful information from a large dataset without the need to manually search through it.

 

C)  Short answer type questions:

 

1)    What is database management system.

Ans: A Database Management System (DBMS) is a software application that enables users to interact with a database. It facilitates the creation, storage, retrieval, and manipulation of data in a structured and organized manner. DBMS provides tools for managing the data, ensuring its integrity, and allowing multiple users to access and work with the database simultaneously.

 

2)    Difference between the relationship and design view.

Ans: Relationship View: In Microsoft Access, Relationship View is used to establish and manage relationships between tables in a database. It visually represents the connections between tables, showing how they are linked based on common fields.

Design View: Design View is where users can define the structure of a table or modify its properties. It allows for the addition of fields, setting data types, specifying primary keys, defining validation rules, and other design-related tasks.

 

3)    Can you create more than one table in the same database? Explain.

Ans: Yes, you can create more than one table in the same database. In fact, it's common to have multiple tables within a single database. Each table can represent a different category of information, and they can be related to one another through common fields. This allows for efficient organization and management of data, enabling users to perform complex queries and generate meaningful reports.

D)   Practical

Create report of General data ( information of students) of your class.

To create a report of general data (information of students) of your class in Microsoft Access, follow these steps:

1.     Open Microsoft Access and select the database in which you want to create the report.

2.     Go to the "Create" tab in the ribbon at the top of the screen.

3.     Click on "Report Design" to open the Report Design view.

4.     In the "Add Existing Fields" section, select the table that contains the general data of students.

5.     Drag and drop the fields (such as name, age, address, etc.) from the table onto the report design surface to include them in the report.

6.     Arrange and format the fields as desired on the report.

7.     Add any headers, footers, and additional elements you want to include in the report.

8.     Save the report by giving it a name.

9.     Close the Report Design view and return to the main database window.

10.  To view or print the report, select it from the list of objects in the database and click "Open".

You have now created a report displaying the general data of students in your class.

 

L-5 HTML and CSS / Class 7th

 Class - 7th 

Subject : Computer

L-5 HTML and CSS

A) Tick the correct option:

1) Which tag is used for ordered list?

a) <li>

b) <ol>

c) <ul>

d) <dl>

Ans: b) <ol>

2) Which of the following can't be the value of list-style-type?

a)  square

b)  circle

c)  ellipse

d)  disc

Ans: c)  ellipse

3) Which element contains definition?

a)  <dl>

b)  <dd>

c)  <dt>

d)  <ul>

Ans: c)    <dt>

4) Which attribute is only used with <ol>?

a)  value

b)  type

c)  compact

d)  start

Ans: b)    type

5) Identify tag which is used for unordered list?

a)  <li>

b)  <ol>

c)  <ul>

d)  <dl>

Ans: c)    <ul>

6) Which type of CSS is used in the below code?

<p style="border:px solid red;">

a)  Inline CSS

b)  Internal CSS

c)  External CSS

d)  None of the above

Ans: a)    Inline CSS

B) Fill in the blanks:

1) By default, ordered list starts with 1.

2) The <li> tag is used to define list item.

3) A list within another list is called nested list.

4) The src stands for source in image tag.

5) Alt  attribute of an image is used, when image is not displayed.

6) 'Background-color' property in CSS used to change the background color of an element in HTML.

C) State 'T' for True or 'F' for False.

1) <IMG> tag is used to insert an image in a web page           TRUE

2) Src attribute specify the source of an image.                       TRUE 

3) By default, unordered list starts with disc.                           TRUE

4) There are two types of images: Inline and External images. FALSE

5) The HTML attribute used to define the inline styles is style. TRUE

6) JPG, PNG, and JPEG are image formats.                               TRUE

D) Short answer type questions:

1) Define a list.

Ans: A list is an HTML element used to group together related items in a specific order or hierarchy.

2) What is the use of Description List?

Ans: A Description List in HTML (<dl>) is used to define terms and provide a description or definition for each term.

3) How we can insert image in a table? give example

Ans: To insert an image in a table, you can use the <img> tag within a <td> (table data) element. Here's an example:

<Table>

<TR>

<TD><img src="image.jpg" alt="description of the image"> </td>

<td> other content</td>

</TR>

</Table>

4) What do you understand by CSS.

Ans: CSS stands for Cascading Style Sheets. It's a stylesheet language used to control the presentation and layout of a web page written in HTML or XML. CSS allows you to apply styles (such as colors, fonts, spacing, etc.) to elements on a webpage, making it visually appealing and user-friendly.

E) Long answer type questions:

1) Differentiate between ordered and unordered list?

Ans: Ordered List vs Unordered List:

• Ordered List: The items in an ordered list are marked with numbers or letters by default. It is created using the <ol> tag.
• Unordered List: The items in an unordered list are marked with bullets (discs, squares, etc.) by default. It is created using the <ul> tag.
• 
  

2) What are the different attributes of an image tag. (list any three)?

Ans: Attributes of an Image Tag:

• src: Specifies the source (URL) of the image.
• alt: Provides alternative text for the image, which is displayed if the image cannot be loaded.
• width and height: Set the dimensions of the image.
• 
  

3) Write any one difference between internal & external style sheet?

Ans: Difference between Internal & External Style Sheet:

• Internal Style Sheet: It is defined within the HTML document using the <style> tag in the head section. It applies styles only to the current document.

• External Style Sheet: It is a separate file with a .css extension that contains all the styles. It is linked to the HTML document using the <link> tag. It can be used to style multiple HTML documents.

F) Application based   questions:

1) Aditi wants to celebrate her birthday. So she is interested to make a list of guests. Suggest her which tag she will use to make list?

Ans: Aditi can use the <ul> (unordered list) or <ol> (ordered list) tags to make a list of guests.

2) Mehul is interested to create a list of state and capitals of India. Which tag you will suggest him to make a list?

Ans: Mehul can use the <dl> (definition list) tag to create a list of states and their capitals in India.

.