Information and Communication Technology - 4IT1 PearsonEdexcel

Spreadsheet

Muhtasari

Spreadsheet software turns raw numbers into answers. Whether you are tracking a budget, analysing survey results, or modelling the growth of a population, the combination of formulae, functions, and charts gives you the power to process data quickly and present it clearly.

In this lesson you will learn how to format cells, write formulae with absolute and relative references, apply key functions such as SUM, IF, and VLOOKUP, choose the right chart type for your data, and print your work in both data view and formula view. These are core skills tested across Paper 2 of the Edexcel IGCSE ICT examination.

Malengo

Know data types: number, text
Format a worksheet: currency, percentage, decimal places, date, time, text wrap, row height, column width, gridlines, merge/split cells, cell borders, cell shading, hiding rows and columns
Use formulae: arithmetic operators, percentage, single and multiple operators, absolute and relative cell referencing, named cells/ranges; replicate effectively
Use functions: SUM, AVERAGE, IF, VLOOKUP/LOOKUP, MAXIMUM, MINIMUM, COUNT (COUNTA, COUNTIF), LENGTH, PRODUCT
Use other features: multiple worksheets, sorting, filtering
Add graphs and charts: pie chart, line chart, bar/column chart, scattergram
Select an appropriate graph/chart and format it effectively adding title, axis labels, legends, axis, scale, trend line as appropriate
Print selected columns/rows from a worksheet formula view or data view in landscape or portrait format, adding headers and footers, row and column headers

Maelezo ya Somo

A table of figures on its own says very little. Add a formula to calculate profit, a function to find the highest value, and a chart to reveal the trend, and the same figures begin to tell a story. Spreadsheet software is built for exactly this kind of work: organising numerical data, performing calculations automatically, and presenting results so that patterns jump off the page.

Inapatikana kwenye programu ya Green Bridge

Pakua programu ya Green Bridge CBT kwenye simu yako au kompyuta yako ili kupata maelezo kamili ya masomo, maswali ya mazoezi, na mengi zaidi.

Maelezo kamili ya masomo yenye michoro

Msaidizi wa kujifunza wa AI

Soma bila mtandao, wakati wowote, mahali popote

Pakua programu ya simu Pakua programu ya kompyuta

Inapatikana kwa Android, Windows, macOS, na Linux

Tathmini ya Somo

Hongera kwa kukamilisha somo la Spreadsheet. Sasa kwa kuwa umechunguza dhana na mawazo muhimu, ni wakati wa kuweka ujuzi wako kwa mtihani. Sehemu hii inatoa mazoezi mbalimbali maswali yaliyoundwa ili kuimarisha uelewaji wako na kukusaidia kupima ufahamu wako wa nyenzo.

Utakutana na mchanganyiko wa aina mbalimbali za maswali, ikiwemo maswali ya kuchagua jibu sahihi, maswali ya majibu mafupi, na maswali ya insha. Kila swali limebuniwa kwa umakini ili kupima vipengele tofauti vya maarifa yako na ujuzi wa kufikiri kwa makini.

Tumia sehemu hii ya tathmini kama fursa ya kuimarisha uelewa wako wa mada na kubaini maeneo yoyote ambapo unaweza kuhitaji kusoma zaidi. Usikatishwe tamaa na changamoto zozote utakazokutana nazo; badala yake, zitazame kama fursa za kukua na kuboresha.

What does the formula =SUM(A1:A10) do? A) Counts the number of cells in the range B) Finds the largest value in the range C) Adds all the values in the range D) Calculates the average of the range Answer: C
Which symbol makes a cell reference absolute in a formula? A) # B) $ C) & D) @ Answer: B
Which chart type is best for showing how a total is divided into proportions? A) Line chart B) Scattergram C) Bar chart D) Pie chart Answer: D
What does the function =COUNTIF(B2:B20,">50") return? A) The total of all values greater than 50 B) The number of cells containing values greater than 50 C) The average of values greater than 50 D) The largest value that is greater than 50 Answer: B
In formula view, a cell displays =B3*C3 instead of a number. What does this tell you? A) There is an error in the formula B) The spreadsheet is showing formulae instead of results C) The cell is formatted as text D) The formula has not been entered correctly Answer: B

Inapatikana kwenye programu ya Green Bridge

Pakua programu ya Green Bridge CBT kwenye simu yako au kompyuta yako ili kupata maelezo kamili ya masomo, maswali ya mazoezi, na mengi zaidi.

Maelezo kamili ya masomo yenye michoro

Msaidizi wa kujifunza wa AI

Soma bila mtandao, wakati wowote, mahali popote

Pakua programu ya simu Pakua programu ya kompyuta

Inapatikana kwa Android, Windows, macOS, na Linux

Inapatikana kwenye programu ya Green Bridge

Pakua programu ya Green Bridge CBT kwenye simu yako au kompyuta yako ili kupata maelezo kamili ya masomo, maswali ya mazoezi, na mengi zaidi.

Maelezo kamili ya masomo yenye michoro

Msaidizi wa kujifunza wa AI

Soma bila mtandao, wakati wowote, mahali popote

Pakua programu ya simu Pakua programu ya kompyuta

Inapatikana kwa Android, Windows, macOS, na Linux

Vitabu Vinavyopendekezwa

Pearson Edexcel International GCSE (9-1) ICT Student Book

Manukuu: First edition

Mchapishaji: Pearson Education

Mwaka: 2017

ISBN: 978-0-435-18866-9

Maelezo: Endorsed student book covering the full 4IT1 specification.

Fanya Mazoezi ya Maswali ya Majaribio

Ungependa kufanya mazoezi ya maswali ya majaribio kuhusu Spreadsheet? Pakua programu ya Green Bridge CBT ili kupata maswali ya majaribio na tathmini kamili za mazoezi kuhusu mada hii.

Pakua Programu Kwenye Google Playstore

Kila kitu unachohitaji ili kufaulu katika JAMB, WAEC & NECO.

Msaidizi wa Gumzo wa Kujifunza wa AI Uliobinafsishwa

Maelfu ya Maswali ya Zamani ya IGCSE, JAMB, WAEC & NECO

Zaidi ya Madaftari ya Masomo 1200

Msaada Nje ya Mtandao - Jifunze Wakati Wowote, Popote Pale

Ratiba ya Daraja la Kijani

Muhtasari wa Fasihi na Maswali Yanayoweza Kutokea

Fuata Utendaji na Maendeleo Yako

Maelezo ya Kina kwa Kujifunza kwa Kina