CBSE Class 5 Computer Science Assignment

Name Date

Directions: Circle the letter of the choice that correctly completes the sentence or answers the question.

1. The Documents folder organizes folders and files in a(n) structure.

a. parallel c. DOS

b. top-down d. operating system

2. A computer’s hard drive is most commonly the drive.

a. A: c. C:

b. B: d. D:

3. In Windows, deleted items are sent to the .

a. desktop c. clipboard

b. trash can d. Recycle Bin

4. In the Documents folder, the opposite of expanding a folder is a folder.

a. Hiding c. Selecting

b. Collapsing d. Deleting

5. A(n) is a picture icon that is a direct link to a file or folder.

a. folder c. hyperlink

b. desktop button d. desktop shortcut

6. The tool is an excellent method for finding a file, program, or folder.

a. Find and Replace c. Restore

b. Search d. Seek

7. In the Documents folder, a computer’s drives are listed in the folder.

a. Computer c. Pictures

b. Documents d. Drives

8. Use the command to rename and copy a file to a new location at the same time.

a. Rename c. Save

b. Move d. Save As

9. A file’s summary, author, date created, and disk size are known as .

a. file properties c. file contents

b. file elements d. file statistics

10. The at the bottom of the screen displays the Start button, active applications, and the time.

a. task menu c. job bar

b. taskbar d. Start bar

Topic : Algorithm and Flowchart

New Words

PROCEDURE

AVERAGE

ALGORITHM

FLOWCHART

WORKBOOK

ANALYZING

COMPLEX

REPRESENTATION

ASSIST

DIRECTION

ANSWER THE FOLLOWING QUESTIONS:

Q1. What is a flowchart?
Answer : FLOWCHART:
A Flowchart is a pictorial representation of steps or an algorithm used for solving a particular problem. To create a flowchart, different boxes are used which are connected to each other with the help of flow lines.

Q2. - What is an algorithm?
Answer : Algorithm is a set of sequential steps to solve any logical or a mathematical
problem. Algorithm is always written in simple language and precise manner
so that every one can understand the steps.

Q3. What is the use of the Input/Output box?
Answer : Input / Output Box:
It is used for accepting inputs or giving output of the program.

Q4. When do we use the Process box?
Answer : Processing Box:
It is used for writing the processing instructions and doing calculations.

Q5. What is the use of the Decision box?
Answer : Decision /Condition Box
It is used for checking or applying any condition in the program.

Q6. Write the difference between Flowchart and Algorithm.
Answer : Algorithm
1. Algorithm is step by step procedure to solve the problem.
2. Algorithm is complex to understand.
3. In algorithm plain text are used
4. Algorithm is easy to debug.
5. Algorithm is difficult to construct.
6. Algorithm does not follow any rules.
7. Algorithm is the pseudo code for the program.
Flowchart
1. Flowchart is a diagram created by different shapes to show the flow of data.
2. Flowchart is easy to understand.
3. In flowchart, symbols/shapes are used.
4. Flowchart it is hard to debug.
5. Flowchart is simple to construct.
6. Flowchart follows rules to be constructed.
7. Flowchart is just graphical representation of that logic.

A G P S K A F M D F M L E O V I L C

P A N R O R P O F T E A S K L P I S

P N L I O F O P Q F M P U M G R C M

L G P X M C T W L V O T O L C R O M

I F G I L M E W T E R O M U E N T N

C U P S C F A S A E Y P I E I F W E

A D B U Y R L R S R N T N T O A R Q

T W K W H R V F G O E L O S A A P T

I D R A O B Y E K O R R O G W T U B

O T E N R E T N I S R R R D A P A A

N W N T Q U Q A M Q C P R G N M X D

S T U P T U O D Q I M A X I C X E J

T R G F R U O X M E H W V M C B M S

APPLICATIONS      APPLE                    CIRCUIT

DATA                      GAMES                    HARDWARE

INPUT                   INTERNET                KEYBOARD

LAPTOP                MEMORY                  MICROSOFT

MONITOR             MOUSE                     NETWORK

OUTPUT              PROCESSOR             PROGRAMMING

SCREEN              SOFTWARE

Topic : Windows 7

Difficult Words
1. Thumbnail
2. Interface
3. Attractive
4. Flexible
5. Bill Gates
6. Jump Lists
7. Explorer
8. Personalize
9. Cabinet
10. Context
11. Graphical
12. Accessories
13 Notification
14 Blackcomb
15 Gadgets

Define:

Desktop: Desktop is the opening screen in Windows.

Jump List: Jump list takes us straight to the documents, pictures songs or web sites that we recently visited.

File: It is the collection of related information stored together on some storage device such as hard disk, CD, DVD or Pen drive. Any information in a computer is saved in the form of a file.

Folder: A folder in a computer is like a cabinet where we keep relevant files. A folder can hold other folders as well.

Answer the following questions:

Q1: Mention any four features of Windows 7 that have made it so popular.
Ans: Four features of Windows 7 are:
(i) Maintains personalized work environment through multiple user support. (ii) Searching made easier: Using Windows 7, we can quickly search for more things in more places in our computer.
(iii) Windows 7 taskbar: The taskbar of Windows 7 is more flexible and application oriented. We can pin our favourite programs on the taskbar for easy access.
(iv) Windows 7 provides the Aero peek feature that makes our open windows transparent so we may see our desktop.

Q2: What is Windows Explorer?
Answer : Windows Explorer is an application that provides detailed information about files, folders and drives. We can use it to see how our files are organized and can copy, move, rename and search for files and folders.

Q3: How will you copy a file from C:drive to D: drive?
Answer : (i) Open the C: drive
(ii) Select the file
(iii) Press ctrl + c
(iv) Open the D:drive
(v) Select the folder, open it.
(vi) Press ctrl + v

Q4: What are Gadgets?
Answer : Windows contains mini programs called gadgets, which offer information at a glance and provide easy access to frequently used tools. Windows 7 gadgets are Calendar, Clock, CPU meter, Currency, weather, Feed, Headlines, Slide show, Picture Puzzle and Window Media Center, WinZip gadget.

Q.A- Fill in the blanks:

1. To copy multiple files and folders, press and hold down the ______ and click on the files to be copied.

2. To rename a file/folder, right click on it and select _______ option from the shortcut menu.

3. To select a consecutive group of files, click on the first file, ________ the Shift key and click on the last file.

4. L*.* will search all files whose names start with ______ followed by any number of characters and has any extension.

5. *.doc will search all the files whose extension is ____________.

6. ?.* ill search all files whose names contain only ____________.

7. MS Windows is an ___________ .

8. To customize the desktop, right click on the blank area and select the ______________ option.

9. A ____________ is like a container in which we can store similar types of files.

10. ____________________ are the graphical images that give a quick access to the related applications.

11. ________________ gives a complete view of the available drives and their contents.

12. We can restore deleted files from ____________ .

Q.B- Multiple Choice Questions:

1. _____________ icon allows you to access the shared files or drives on different computers in a Network environment.
(A) Computer
(B) Shortcut
(C) Network

2. Using Context menu you can save your time to access _____________ .
(A) Commands
(B) Object
(C) Properties

3. Linux is a/an __________ software.
(A) Application
(B) Utility
(C) Operating System

4. A folder within a folder is called _______ .
(A) File
(B) Sub-folder
(C) Cabinet

5. Windows 7 is a/an ________________ software.
a) Application
b) Utility
c) Operating system
d) None of these

6. Operating system acts as an interface between the user and the ___________.
a) Office
b) Machine
c) Computer
d) None of these

7. Windows contains the ________ programs called Gadgets.
a) Large
b) Mini
c) Busy
d) None of these

8. Name the application that provides detailed information about file, folder and drives.
a) Application 
b) Gadgets
c) Windows Explorer
d) None of these

Circle the letter of the choice that correctly completes the sentence or answers the question.

1. Formulas are calculations used to identify the between spreadsheet cells.

a. relationship c. similarities

b. distance d. function

2. In Excel, a built-in formula, such as AVERAGE, is known as a(n) .

a. operator c. range

b. AutoFormula d. function

3. A symbol that represents a specific mathematic function is a(n) .

a. icon c. pointer

b. arithmetic operator d. formula

4. Which of the following is not an Excel function?

a. sort c. Min

b. Average d. Sum

5. When a formula is copied from one cell to another, Excel adjusts the formula automatically. This is called .

a. cutting and pasting c. relative addressing

b. moving d. formula addressing

6. If C4 = $8.50 and E8 = $5.50, then what would be the result of the formula or function =C4-E8?

a. −$3.00 c. −$3.50

b. $3.00 d. $3.50

7. If A1 = 5, B1 = 10, and C1 = 15, what would be the result of the formula or function =AVG(A1:C1)?

a. 5 c. 10

b. 8 d. 12

8. If B1 = 75, B2 = 100, and B3 = 125, what would be the result of the formula or function =MAX(B1:B3)?

a. 75 c. 125

b. 100 d. 300

9. A group of cells is referred to as a(n) .

a. column c. range

b. row d. group

10. Formulas can either be entered into an individual cell or into the .

a. Address bar c. Tool bar

b. Formula Bar d. Arithmetic bar

Topic : Working with Tables

Difficult Words

1. Flexible

2. Tabular

3. Adjoining

4. Intersection

5. Accommodate

6. Modifying

7. Column

8. Consolidate

9. Resizing

10. Numerous

Answer the following questions:

Q1: How do you insert a table in your document? Explain any two methods briefly.
Answer : Method I:
Insert → Table → Draw Table.
Method II:
(i) Click on the Table button in the Tables group in Insert tab→ Insert Table
(ii) Specify the number of columns and rows→ ok

Q2: How will you insert a column in a table
Answer : Right click on the cell → Insert → choose Insert Columns to the left/right.

Q3: How will you delete row(s) and column(s) in a table?
Answer : Right click on the cell →Delete cells → Delete entire rows/ columns.

Q4: How will you calculate the sum in a table
Answer : (i) Select the Layout tab.
(ii) Click in the cell where the result is to be displayed. Click on Formula button in the Data group.
(iii) The Formula dialog box is displayed.
(iv) The Sum formula is already displayed. Click on OK button.

Q5.Hhat is the use of Split Cells option?
Answer : To divide a cell into many cells, we use the Split cells option.

Q6. How will you change the column width in a table?
Answer : (i) Click the Layout tab.
(ii) Click the Properties button in the Table group. The Table Properties dialog box is displayed.
(iii) Click on Column tab.
(iv) Change the values in Preferred width check box. Click on ok.

I. Fill in the blanks :

1. The shortcut key to move the pointer to the previous cell is …………………

2. …………… the cells provide a way to consolidate data in one cell.

3. The shortcut key to copy a selected portion of text is ……………………

4. A …………… is made up of rows and columns.

5. The Table button is present on the ........................ tab.

II. State True (T) or False ( F)

1. The Shift + Tab key combination is used to move to the next adjoining cell.

2. Clicking on the ‘Table Move Handle’ will select an entire table.

3. To type some text in a cell, we have to first place the mouse pointer in that cell.

4. We cannot increase or decrease the size of a cell.

5. To update the total sum in a cell, press the F9 key.

III. Answer the following

1. Which option combines a number of cells in a single cell?

2. How many Alignment buttons are present on the Layout tab?

3. What do we call the intersection of a row and a column?

4. Which key combination is used to move to the previous adjoining cell?

5. Which option is used to divide the cell into separate cells?

WORK SHEET OF COMPUTER SCIENCE

Q1.Make a presentation “SAVE ENVIRONMENT “using Slide layout as” TITLE and CONTENT” with Slide Design as “OCEAN”. PowerPoint Presentation must include the formatting Effects and any two Animation Effects.

Q2. Fill in the Blanks:

1.………………………………………………… is a structured process of information.

2.…………………………………………….. gives us the view of the whole presentation.

3.To End a slide show…………………………………. Key is used.

4.To insert a new slide……………………………………….. is used.

5.…………………………………………….. takes us to the End of the presentation.

Q3.Short Answer Questions:

Q1.What is MS-PowerPoint? What is it used for?

Q2.What is a Slide?

Q3.Name the three main views which are present in PowerPoint?

Topic : Windows 7

Difficult Words
1. Thumbnail
2. Interface
3. Attractive
4. Flexible
5. Bill Gates
6. Jump Lists
7. Explorer
8. Personalize
9. Cabinet
10. Context
11. Graphical
12. Accessories
13 Notification
14 Blackcomb
15 Gadgets

Define:

Desktop: Desktop is the opening screen in Windows.

Jump List: Jump list takes us straight to the documents, pictures songs or web sites that we recently visited.

File: It is the collection of related information stored together on some storage device such as hard disk, CD, DVD or Pen drive. Any information in a computer is saved in the form of a file.

Folder: A folder in a computer is like a cabinet where we keep relevant files. A folder can hold other folders as well.

Answer the following questions:

Q1: Mention any four features of Windows 7 that have made it so popular.
Answer : Four features of Windows 7 are:
(i) Maintains personalized work environment through multiple user support. (ii) Searching made easier: Using Windows 7, we can quickly search for more things in more places in our computer.
(iii) Windows 7 taskbar: The taskbar of Windows 7 is more flexible and application oriented. We can pin our favourite programs on the taskbar for easy access.
(iv) Windows 7 provides the Aero peek feature that makes our open windows transparent so we may see our desktop.

Q2: What is Windows Explorer?
Answer : Windows Explorer is an application that provides detailed information about files, folders and drives. We can use it to see how our files are organized and can copy, move, rename and search for files and folders.

Q3: How will you copy a file from C:drive to D: drive?
Answer : (i) Open the C: drive
(ii) Select the file
(iii) Press ctrl + c
(iv) Open the D:drive
(v) Select the folder, open it.
(vi) Press ctrl + v

Q4: What are Gadgets?
Answer : Windows contains mini programs called gadgets, which offer information at a glance and provide easy access to frequently used tools. Windows 7 gadgets are Calendar, Clock, CPU meter, Currency, weather, Feed, Headlines, Slide show, Picture Puzzle and Window Media Center, WinZip gadget.

Q1.Make a presentation “SAVE ENVIRONMENT “using Slide layout as” TITLE and CONTENT” with Slide Design as “OCEAN”. PowerPoint Presentation must include the formatting Effects and any two Animation Effects.

Q2. Fill in the Blanks:

1.………………………………………………… is a structured process of information.

2.…………………………………………….. gives us the view of the whole presentation.

3.To End a slide show…………………………………. Key is used.

4.To insert a new slide……………………………………….. is used.

5.…………………………………………….. takes us to the End of the presentation.

Q3.Short Answer Questions:

Q1.What is MS-PowerPoint? What is it used for?.

Q2.What is a Slide?..

Q3.Name the three main views which are present in PowerPoint?

Topic : Working With Styles and Objects

A. Check the Right Answer

1. Which style controls all aspects of paragraph's appearance, such as text alignment, tab stops, line spacing etc?
a. Character Style
b. Paragraph Style
c. Line Style
d. All Effects

2. Which tab contains the WordArt option?
a. View
b. Format
c. Edit
d. Insert

3. Which feature in Microsoft Word is used to give special effects to the written text?
a. WordArt
b. ClipArt
c. Chart
d. WordPad

4. Which option allows you to take an instant picture of all or a part of the windows open on your computer?
a. Theme
b. Clip Art
c. Screenshot
d. Word Art

5. What do we call the gallery of pre-designed pictures in Microsoft Word?
a. Art Gallery
b. Clip Art
c. WordArt
d. Clipboard

B. Fill in the blanks :

1. A set of formatting features that you can apply to the text in a document to quickly change its appearance is called a …………………

2. We can increase the size of a text box by ……………… the handles of an object.

3. Lines, Callouts, Basic Shapes, Block Arrows etc. are the sub options of the …………………… option.

4. The Style dialog box launcher is presesnt on the …….. tab.

5. Flowchart, Star and Banners, Callouts are the various options of …………………… feature.

6. …………… key is used while dragging to maintain an object’s height and width ratio.

7. The Artistic Effects option is present on the………………………… tab.

8. Besides Normal style, Word provides various……..styles.

9. The Screenshot button is present in the ………... Group on the,Insert tab.

10. Lines, Basic Shapes, Block Arrows are the options of,................ button.

C. State True (T) or False ( F)

1. Font Color option is used to fill colors inside an object.

2. WordArt feature helps to create special shape effects.

3. Cover Page option is present in the Insert tab. 

4. Symbols are signs and special characters that can be inserted from the Symbol dialog box.

5. The Shape Fill tool is used for colouring a drawing object

D. Application Based the following

1. Aarushi wants to write a poem on ‘Rain' in Word document. She wants to apply decorative text effect to every single line. Suggest her how can she apply the special text effect.

2. The teacher has asked Varun to make a banner for 'School Fete'. Which feature should he use to add ready-made pictures from the gallery?