[go: up one dir, main page]
Scribd
Upload
189 views4 pages

Lesson 2: Digital Technology: Ict Revision Sheet-Term 2

The document provides a revision sheet for Grade 5 students covering lessons on digital technology and the introduction to spreadsheets. In the digital technology section, students are asked to fill in blanks about concepts related to planning a film, such as different shots, storyboards, and editing tools. They are also asked to identify different shots from an image cloud. The spreadsheet lesson covers parts of the Excel screen, functions like SUM and formatting. Students are given questions to fill in blanks about file extensions, cell addresses, operators, and financial calculations. They also label the different parts of an Excel spreadsheet.

Uploaded by

Abid Ali
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
189 views4 pages

Lesson 2: Digital Technology: Ict Revision Sheet-Term 2

The document provides a revision sheet for Grade 5 students covering lessons on digital technology and the introduction to spreadsheets. In the digital technology section, students are asked to fill in blanks about concepts related to planning a film, such as different shots, storyboards, and editing tools. They are also asked to identify different shots from an image cloud. The spreadsheet lesson covers parts of the Excel screen, functions like SUM and formatting. Students are given questions to fill in blanks about file extensions, cell addresses, operators, and financial calculations. They also label the different parts of an Excel spreadsheet.

Uploaded by

Abid Ali
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 4

BRITISH INTERNATIONAL SCHOOL

ICT REVISION SHEET-TERM 2 GRADE 5

Lesson 2: DIGITAL TECHNOLOGY


LO: To revise the basic concepts in planning a film.

I FILL IN THE BLANKS


1. A ……….is a single scene or shot recorded while ………… is a recording of several scenes.
2. The………….screen shows the clips or image you have selected in movie maker.
3. ………… is a written guide describing a film, including all dialogues.
4. Directors use………… to plan the shots they need to tell the story in the script.
5. To insert new clips/image into storyboard, click on …….option in the toolbar.
6. …………..tool helps to set start point and end point of your clip.
7. To give sound & music to your clip, click on ……… option in home tab.
8. I can make a cut between two clips look smoother by using a …………..
9. A………… is made up of clips that are joined together.
10. A ………..is at the beginning whereas …………is at the end of a film.
ANSWERS
1. Clip, film
2. Preview
3. Script
4. Storyboard
5. Add videos & photos
6. Trim
7. Add music
8. Transition
9. Movie/film
10. Title, Credit

II Identify 4 different shots in a film from the cloud.

ANSWERS
1. Wide shot,
Wide shot, Script, Close ups, 2. Close ups,
Transition, Cutaways, Clip, 3. Cutaways,
Trim, Point of view, Split 4. Point of view
Lesson 3: INTRODUCTION TO SPREADSHEET
LO: To revise the parts of excel screen, functions & formatting in excel.

I SHORT ANSWER TYPE QUESTIONS


1. How do you change the value to a currency format?
2. How is profit of a business calculated?
3. What are operators?
4. How to insert a new sheet?
5. Identify difference between
i. Cell & cell address
ii. Worksheet & workbook
iii. Values & labels
ANSWERS
1. Select a cell, pick a currency format from the toolbar. The value is shown with a $ symbol.
2. Profit is calculated by taking cost away from income. i.e, profit=selling price- cost price.
3. Operators are signs used in mathematical calculation. Four operators are +,-,*,/
4. To insert new sheet, right click sheet tab, click on insert option.
5.
i. Cell is an intersection of row & column
Cell address is the name of a cell.
ii. Worksheet is a single page created in excel.
Workbook is a collection of worksheets.
iii. Values are numbers and labels are text entered in excel.

II FILL IN THE BLANKS


1. …………is the extension for saving the an excel file
2. Active cell is indicated by a ……….border
3. ……… is an intersection of row and column
4. ……… is a combination of row number and column letter
5. In cell ………., row number is 25 and column letter is M
6. In excel,……..are numbers and ……… are text entered.
7. Four mathematical operators are ………
8. Profit= …………... - cost
9. Formula always starts with equal ……sign
10. …………function is used to add up a column of figures
11. …………..will automatically add up the sum of values
12. Currency format is shown using ……symbol
13. Format option is used to change ………….. of a worksheet
14. To………. a worksheet, right click the sheet, click on rename option.
15. Background color of a cell can be changed using ………….option in home tab
16. ……….formatting options like font size, style color is available in formatting toolbar
17. Formatting toolbar is available in ……….. tab

ANSWERS
1. .xlsx
2. Thick
3. Cell
4. Cell address
5. M25
6. Values, labels
7. + - * /
8. Income
9. =(equal)
10. SUM ( )
11. Autosum
12. $
13. Appearance
14. Rename
15. Fill color
16. Font
17. Home
III CHOOSE THE CORRECT NAME OF THE TOOLBAR FROM THE BRACKET GIVEN
BELOW.
(Font size, bold-italic-underline, fill color, Autosum, border)
ANSWERS:
a) Autosum
b) Bold-italic-underline
c) Border
a) d) Font size
b) e) Fill color

c)

d)

e)

IV. LABEL THE PARTS OF AN EXCEL SPREADSHEET.


ANSWERS:
1. File tab,
2. Name box,
3. Formula bar,
4. Row header,
5. Column header,
6. Active cell,
7. Sheet tab,
8. Title bar,
9. Worksheet area

You might also like