Hangarau

ripanga

spreadsheet

tūingoa

WHAKAMĀRAMA

He momo pātengi raraunga, he tūtohi, he rite ki te tukutuku te āhua, arā, he kapa ōna, he pou hoki ōna. Ka tuhia he raraunga ki ia wāhanga motuhake o te ripanga (ka kīia ēnei he pūtau), ā, e taea ana ngā pūtau te honohono ki te whārite, ki te waehere rānei. Ko ngā momo hōtaka rorohiko pērā i te Excel te ara matua e hangaia ai he ripanga, ā, he ngāwari noa iho te whakaatu i ngā raraunga hei kauwhata.

A type of database or chart that appears in grid format, with rows and columns. Data is entered into each individual part of the spreadsheet (called cells), and the cells can be linked by an equation or coding. Usually a spreadsheet is generated by a computer program such as Excel, making it easy to show the data as a graph.

Tauira KŌrero

Tuhia ngā raraunga ki te ripanga.

Whakaurua he whārite ki te ripanga hei tāpiri i ngā tau katoa o te pou ‘A’.

E hia ngā kapa o te ripanga?

WhakamĀrama Āpitihanga

Koinei te āhua o tētahi ripanga. Ka whakaingoatia ngā pou ki ngā reta o te wakapū, ā, ka tauria ngā kapa. Kua kaurukutia te pou ‘C’ me te kapa tuarua:

I konei, kua whakaurua ngā raraunga 4, 5, 8, 3, 9, 5 ki ngā pūtau A1, B1, C1, A2, B2, C2 o te ripanga. Mēnā karekau he raraunga o tētahi pūtau, ka kīia he pūtau kore. He pūtau kore te pūtau D1 i konei:

I konei, kua whakaurua he kīanga ki te pae tātai o te ripanga. He ture tātai tēnei, arā, he tohutohu kia tātaihia e te rorohiko te tapeke o ngā tau kei te Kapa 1, mai i te A1 ki te C1, arā, 4 + 5 + 8. Ka puta te otinga ki te pūtau D1. Ka kīia te tohutohu SUM he tātai ripanga. He maha ngā momo tātai ripanga, pērā i te AVERAGE mō te toharite me te COUNT mō te tatau:

I tēnei ripanga rorohiko kua whakaurua he raraunga, ā, kua tohua te rorohiko kia whakaaturia aua raraunga hei kauwhata pou

He hononga tēnei ki ētahi akoranga ripanga rorohiko: https://nzmaths.co.nz/tihei-p-ngarau-te-tauanga-taumata-3

Takenga Mai

ripa - row, rank, line

Tauira KŌrero

Tuhia ngā raraunga ki te ripanga.

Whakaurua he whārite ki te ripanga hei tāpiri i ngā tau katoa o te pou ‘A’.

E hia ngā kapa o te ripanga?

WhakamĀrama Āpitihanga