the city school · 2018-02-07 · the city school /paf chapter / prep section / worksheet for...

The City School

PAF Chapter

Prep Section

ICT

Class – 6

2nd

Term

The City School /PAF Chapter / Prep Section / Worksheet for Intervention Class /ICT /Class – 6 of 16

TOPIC: WORKING WITH NUMBERS (MS EXCEL 2010)

1. Put a if the sentence is correct

1. Spreadsheets help us analyze information and produce graphs and pie-charts. 2. Each column has a number (1, 2,…) on the top. These numbers are the names of

the columns.

3. The only way to add text to a cell is to double-click it and then to start typing. 4. When you use the AutoFit Column width operation, the column automatically

adjusts to the width of the text in the cell.

5. You cannot change the height of more than one row at the same time. 6. To insert more than one column to your worksheet, you have to insert one

column each time. 7. When we use the Wrap text operation, the width of the column remains the

same.

8. Wrapped text automatically adjusts the row height of the cell.

2. Match the selected cells with the corresponding written cells

A3;B4;A5,

B3

B2:B7

A2:C5


3. Match the icons in the left column with the corresponding formatting actions

Change the type of content

Turn the content of the cell

into a percentage

Align the text to the left, center or right of the cell


into currency

Decrease the digits after the

decimal point

Increase the digits after the

decimal point


into a decimal

Align the text to the top, center or bottom of the cell



9. We use currency formats for general monetary values.

10. Accounting aligns the values at the decimal points.

11. All countries use the same date format.

12. When a date is applied to a table, it is always placed in the first row of the table. 13. When you apply borders to the Outline or the Inside of a table you cannot

choose a different style for each side of the table.

14. The only way to insert an image to a particular cell in the table is from Clip Art.

15. Date formats display date and time serial number as date values.

16. Date formats that begin with an asterisk (*) are specified by the user.

4. Match the icons in the left column with the corresponding alignment actions

Combine two or more cells and make a longer cell

Change the orientation of the text

Change the indentation of the text

2. Select what must be written in the cells in order to get the correct content in the spreadsheet below


1. D2

=B2-B2*C2% =B2*C2%

=B2+B2*C2% =C2-B2*C2%

2. D4

=D4*C4 - C4% =B4-B4*C4%

=D4*C4 + C4% =B4*C4-B4%

3. F5

=B5 - E5 =D5 * E5

=B5 + E5 =E5 * B5 –C5%

4. D3

=45-45*C3% =B3+C3%

=45*(45+C3%) =D3-C3%


17. The correct sequence of calculations is first addition and subtraction and then multiplication and division.

18. If there are parentheses in an equation, first we do the calculations inside the parentheses and then the rest.

19. The Sum function gives us the result of the addition of the numbers you´ve selected.

20. The Average function calculates the largest number of a selected area. 21. The AutoFill tool duplicates the formula that you´ve typed in the first cell, but

makes the appropriate changes each time.

22. The AutoFill tool copies the formula but not the formatting of the cell.

23. Microsoft Excel only understands Latin characters in formulas.



24. The “IF” logical function returns a value if the condition is true.

25. The “IF” function can return another function as a result.

26. The returned value from a logical function cannot be text.

27. The only way to use a Logical function is to insert it from the Function Library.

28. The value that is returned if a Logical_test is true is always text. 29. The value that is returned if a Logical_test is false can be the addition of two

numbers. 30. The criteria you type in a Logical_testmust always contain comparison

operators.

2. Match what we have to write in the cells in order to have the correct content on the spreadsheet below. Note that if a student’s average grade is higher than 80, then give them an “A” otherwise give them “B”. Furthermore, if a test’s average is higher than 78 show the message “Easy”, if not show the message “Difficult”.

E2 IF(AVERAGE(B2:B4)>78,"Easy test","Difficult test")

E3 IF(AVERAGE(D2:D4)>78,"Easy test","Difficult test")

B5 =IF(AVERAGE(B3:D3)>80,"A","B")

D5 =IF(AVERAGE(B2:D2)>80,"A","B")


MS Excel 2010 PRACTICAL

Create the following table in MS Excel 2010 and complte all the tasks shown in the picture below:


TOPIC: PRESENTING YOUR IDEAS (MS POWERPOINT 2010)

1. Select the files that are PowerPoint Presentations.

⃝

⃝

⃝

⃝

⃝

⃝


2. Put a in the correct description of each type of slide.

We

use

d t

his

typ

e o

f sl

ide

to

pre

sen

t:

Title, text and picture Picture and subtitle Two pictures

Text Picture, title and text Text and title

Picture and text A title A picture

Picture and subtitle Text Title, text and pictures

Title Title and picture Title and subtitle

Text and Title Picture Subtitle

Two pictures Anything Text

Title and text Title and picture Title and subtitle

Title and two pictures Title and text Pictures



31. You apply a transition effect to a picture or a slide.

32. A transition effect can be applied to all slides.

33. There are nine different transition effects.

34. It is recommended to set a sound effect every time the slide changes.

35. A presentation can be fully automated.

36. You can define the duration of a transition.

37. Only in Slide Sorter view can you see information about the transition effects and the time you have set in a presentation.

38. In order to make a picture move up or down on a slide, you can apply an animation effect.

39. The applied animation effects on a slide appear simultaneously.

40. You can set the Duration but not the Delay of an animation effect.

41. With the effect options, you can apply a new animation effect.


1. An animation effect is

a motion effect that occurs when text boxes or

pictures appear on a slide during a presentation.

the same as a transition effect.

a motion effect that occurs when you move from one

slide to the next during a presentation.

2. If you select a transition effect, this will be applied

between the previous slide and the slide you have

chosen.

between the slide you have chosen and the next slide.

to all slides.

3. Every transition effect has a default duration that

you are not able to change.

you can change.

is always 3’.40.

4. An animation effect doesn’t define

the way a picture appears or disappears gradually.

the way a text box becomes smaller or bigger in size.

the motion effect that occurs from one slide to the

next.

5. The Delay defines the time that

the animation will last.

the next animation will start.

the animation will start after the slide appears.

6. With the effect options button you can

view more options about a specific effect.

view more cool animations.

define when an animation will start.

Select the correct answer


1. Select the correct answer

7. You can insert sound or video

only in the first slide.

only in the last slide.

in the first or last slide.

in any slide.

8. In the first slide of a presentation you

must insert a sound first and then a video.

must insert a video first and then a sound.

can’t insert video or sound.

can insert many sounds and videos in any order.

9. Onto a slide, you can’t paste

text.

clipart.

sound.

images.

10. The settings for a video’s duration are

in the Playback Tab and in the group

Preview.

Bookmarks.

Editing.

Audio Options.

11. Onto a slide, you can’t insert a video

from the computer’s files.

by copying and pasting it from the desktop.

from the Web.

from the Clip Art Library.



42. There are six types of SmartArt Graphics.

43. If you don’t know which SmartArt is most suitable for the information you want to present, you can look at the detailed description below the graph.

44. You can use any SmartArt for any type of information you want to present.

45. You are not able to customize a SmartArt or a Chart.

46. A Chart is a presentation of numbers.

47. With SmartArt we take a table with numbers and convert it to an image.

48. You can add data to an existing chart.

49. You change the type of chart according to the information you want to include.

50. You can convert a SmartArt Graph to a database table.

51. You can change the style of a chart but not the color.

52. You can change the scale of the numbers in an Axis of a chart.

53. A database table can be presented as a SmartArt or a Chart.


2. Match each icon with its name and the correct description.

List

Show steps as a process or

timeline.

Process

Illustrate connections.

Cycle

Show nonsequential information.

Hierarchy

Show proportional relationships

with the largest component on

the top or bottom.

Picture

Use pictures prominently to

convey or accent content.

Relationship

Show a continual process.

Matrix

Show a decision tree.

Pyramid

Show how parts relate to a

whole.

POWERPOINT PRACTICAL:

Search the web and find information about your favourite animals. Use smart Art and present their hierarchy. Use

charts to show information about their population, life expectance etc. Do the following tasks:

a) Add different slides.

b) Insert images and graphics

c) Use slide transition

d) Use animations

e) Set the timings


TOPIC: PROGRAM INTERACTIVE STORIES- SCRATCH

Q1: Fill in the blanks.

1. Scratch is a .

2. Scratch projects are made up of objects called _ _.

3. You can change how a sprite looks by giving it a different .

4. The is where you see your stories, games, and animations come to life.

5. You can create your own in Scratch.

Q.2 Write short definitions of the following terms used in Scratch:

Green Flag:

Rotation Style:

Stage::

Costume:

Q.3. Write the Name of the tool and its description:

Tool Name Description

Q.4. Circle the correct answer:

1. To create a new sprite in your project

(a) Click on the stamp button (b) Click Get a surprise sprite (c ) click the Restore Up button

2. To see scratch projects at full-screen size

(a) Click the presentation mode (b) Click the green flag (c ) click the Restore Up button

2. To program a sprite

(a) Select a new sprite from list (b) Right click the Stage (c) drag out blocks from the block Palette


Q.5. Circle the correct answer: /10

1. We cannot change the stage. True/False 2. Text tool is used to draw rectangular lines. True/False

3. Multiple sprites can run together. True/False

SCRATCH - PRACTICAL

You are required to create a short story in Scratch on any one of the following topics:-

a) A dialogue between two students on preparation of exam

b) A car racing scene. At least two cars

c) A conversation between animals or or any fantasy characters

d) A fairy tale, historical event, scientific event/discovery

2. Perform the following skills while creating your short stories in Scratch:

a) move/walk sprites, smooth walking, or flapping wings,

b) present a talk between sprites using speech bubbles

c) change backgrounds / import backgrounds from the Scratch library

d) import Sprites from the Scratch library

e) change of costume of a sprite

f) Create your own sprite

3. Save your file in the students’ folder.

the city school · 2018-02-07 · the city school /paf chapter / prep section / worksheet for...

Documents