☰ خطة العام · تكنولوجيا المعلومات والاتصالات (بالإنجليزية)

Finding, judging and recording

الأسبوع 25 · المحور الرابع، الدرس ٤ «التطبيقات الرقمية» · 3 دروس
3

A spreadsheet and a word processor at work

ICT P4 Term 2, Theme 4: pp. 58–61
GoalUse a spreadsheet for numbers and a word processor for writing and sharing.
New words
spreadsheet · a grid of rows and columns that adds numbers for yourow · a line of boxes going acrosscolumn · a line of boxes going downtotal · the answer when numbers are added
Explanation

A spreadsheet is a grid of rows and columns, a bit like a school timetable. Rows go across and columns go down. You write names and numbers in the boxes, and the spreadsheet can add the numbers for you, which is why it is often used for numbers. A word processor is for writing: you write your ideas, change how they look, add pictures and join your report to other information. They make a team: collect your data in the spreadsheet first, then explain it in the word processor. If you have no computer, draw the grid on squared paper and add the numbers yourself.

B5fx=SUM(B2:B4)
AB
1PlantNumber
2Palms3
3Lemons2
4Jasmine4
5Total9
Worked examples
B5fx=SUM(B2:B4)
AB
1DayBirds
2Sun4
3Mon7
4Tue5
5Total16
Habiba counts the birds at the school pond for three days: 4, then 7, then 5. The spreadsheet adds them for her: 4 + 7 + 5 = 16.
titleshort paragrapha picture
Then Habiba uses a word processor to write a title and a short paragraph saying: “We saw the most birds on Monday.” She adds a picture.
ABCD
1NameLives inDangerHow to help
2Pigeoncities and farmslitterkeep streets clean
3Palm treeoases and farmstoo little wateruse water wisely
A research spreadsheet about a plant and an animal: one column for each piece of information.
Class activity

A paper spreadsheet. On squared paper, draw a table with two columns (name and number) and five rows. Count something in your classroom, such as the pencils on each row of desks. Add the numbers at the bottom. Then write two sentences about your numbers, as you would in a word processor. Which job did the table do best? Which job did the writing do best?

Practice
1
In a spreadsheet, which go across: rows or columns?
2
Read the spreadsheet. What is the total number of plants?
AB
1PlantNumber
2Palms3
3Lemons5
4Jasmine2
5Total?
3
Which program is better for writing a paragraph that explains the numbers?
4
Why is a spreadsheet useful for numbers?