13 marksGanita Prakash Cl-8 Part 2, Section 5.1, pages 111-112 — 'Spreadsheets'
In Sudhakar's spreadsheet the columns are A (Name), B (Odia), C (Telugu), D (English), E (Maths), F (Social Science), G (Science), and row 1 holds the headings, so Ratna is in row 2, Nagesh in row 3, and so on. (i) Which cell holds Farooq's Mathematics marks? (ii) What data is in cell B7? (iii) In which subjects did Ashwin score more than 30?
Hint. A cell is named by its column letter followed by its row number — find the column of the subject and the row of the student.
How a cell is named. Columns carry letters A, B, C, … across the top and rows carry numbers 1, 2, 3, … down the side. A cell's name is its column letter followed by its row number, so the cell where column E meets row 5 is called E5.
(i) Farooq's Mathematics marks. Mathematics is the 4th subject column, and the columns run A = Name, B = Odia, C = Telugu, D = English, E = Maths, F = Social Science, G = Science. Farooq is the 4th student, and since row 1 is the heading row the students start at row 2 — Ratna 2, Nagesh 3, Ashwin 4, Farooq 5. So the cell is E5, holding 42.
(ii) The data in cell B7. Column B is Odia and row 7 is the 6th student, Gowri. So B7 holds Gowri's Odia mark, 27.
(iii) Ashwin's subjects above 30. Ashwin's row reads Odia 29, Telugu 31, English 33, Maths 34, Social Science 30, Science 28. Comparing each with 30 (and remembering that 30 itself is not more than 30):
· Odia 29 ✗ · Telugu 31 ✓ · English 33 ✓ · Maths 34 ✓ · Social Science 30 ✗ · Science 28 ✗
✦ (i) E5 (Farooq's Maths mark, 42). (ii) Gowri's Odia mark, 27. (iii) Ashwin scored more than 30 in Telugu (31), English (33) and Mathematics (34) — Social Science is exactly 30, so it does not count.
24 marksGanita Prakash Cl-8 Part 2, Section 5.1, pages 112-113
Write the spreadsheet formulae needed for: (i) Nagesh's total across all six subjects, (ii) Gowri's average across Odia, Telugu and English, (iii) the class average in Science, (iv) deciding whether the class average in Odia beats the class average in Telugu. The class has 21 students, so the data occupies rows 2 to 22.
Hint. A block of cells is written Start:End, and =SUM(...) and =AVERAGE(...) work on such a block.
Describing a block of cells. A run of cells is written Start:End. Along a row, Nagesh's six marks are B3:G3; down a column, the Science marks of all 21 students are G2:G22. The colon means 'everything from here to there'.
(i) Nagesh's total. His marks lie in row 3 from column B to column G, so
=SUM(B3:G3)
This adds 41 + 43 + 48 + 39 + 40 + 39 = 250.
(ii) Gowri's average in Odia, Telugu and English. Gowri is in row 7 and those three subjects are columns B, C and D, so
=AVERAGE(B7:D7)
which gives (27 + 29 + 34)/3 = 90/3 = 30.
(iii) Class average in Science. Science is column G and the 21 students fill rows 2 to 22, so
=AVERAGE(G2:G22)
Typing this in the cell just under the last row (G23) prints the class average in Science. Dragging that one cell sideways across B23:G23 produces the average for every subject at once — that is what the book means by showing the averages after the last row.
(iv) Odia versus Telugu. Put =AVERAGE(B2:B22) in B23 and =AVERAGE(C2:C22) in C23 and compare them; a single formula that answers it outright is
=AVERAGE(B2:B22) > AVERAGE(C2:C22)
which prints TRUE or FALSE. Working the two averages out by hand from the table: Odia totals 683 over 21 students → 32.52, Telugu totals 715 → 34.05. So the answer is FALSE — Telugu has the higher class average.
Why a spreadsheet is worth the trouble. There are 21 × 6 = 126 marks here. By hand that is 21 totals and 6 averages, each a chance to slip; the spreadsheet does all 27 calculations from a couple of formulae, and if one mark is corrected every affected total and average updates by itself.
✦ (i) =SUM(B3:G3) → 250. (ii) =AVERAGE(B7:D7) → 30. (iii) =AVERAGE(G2:G22). (iv) Compare =AVERAGE(B2:B22) with =AVERAGE(C2:C22): Odia averages 32.52 and Telugu 34.05, so the Odia average is not greater.
Solutions written by the tuition.in editorial team and checked against NCERT Ganita Prakash Grade 8 Part 2 (hegp205.pdf), Chapter 5 'Tales by Dots and Lines', pages 103-133. HAND-WRITTEN throughout. Part 2 books carry NO printed answer key, so every numeric answer was derived from first principles and independently recomputed in Python. MEASURED OFF THE PRINTED FIGURES at 300-1200 dpi: the page-113 dot plot reads 4, 7, 8, 8, 9, 9, 9, 9, 9, 11 (ten dots, so the missing eleventh is 16); the three page-114 album dot plots read A = 5, 5, 5.25, 5.5, 5.75, 6, 6.5 (mean 39/7 = 5.5714), B = 0.5, 0.75, 1.5, 1.5, 2, 3.75, 4.25, 5 (mean 2.406) and C = 3.5, 3.5, 3.5, 4, 4, 4, 4.25, 4.5 (mean 3.906), so A is the 5.57 album; the page-115 cycle dot plot reads 0:3, 1:1, 2:4, 3:7, 4:7, 5:5, 6:4, 7:6, 8:3, 9:0, 10:2 (N = 42, sum 193, mean 4.595, median 4 — and the book's own hint that four students rode twice confirms the reading); the page-128 dot plot reads 14:2, 15:2, 16:3, 17:5, 18:4, 19:4, 20:3, 21:1, 22:0, 23:1 (N = 25, sum 443, mean 17.72); the page-122 New Delhi rainfall line reads 1.3, 1.5, 1.5, 1.1, 1.5, 3.8, 9.7, 9.7, 4.0, 1.0, 0.4, 1.0 days, total about 37, which makes New Delhi the least-rainy of the four cities and Port Blair the most at 125.8; the page-123 births line graph was found to span April 2017 to March 2020 (36 monthly points) with July 2017 about 1.77 M, January 1.67/1.75/1.77 M in 2018/19/20 and a 2019 total of about 21.4 M; the page-124 Wheat-vs-Rice infographic was read state by state and Karnataka's hidden shade was matched against the colour bar (calibrated exactly on Kerala +79 and Chhattisgarh +80) to about +68; the page-125 activity strips were decoded box by box across all 48 boxes of all three strips, giving Friday/Saturday/Sunday and an identical 10.5 hours of sleep and 1.5 hours of eating on each day; the page-130 hobbies line graph gives urban age 10 about 2 h 06 min and rural 1.5 h at age about 14.3, so option (d); the page-132 sunrise/sunset charts give Kibithu the earliest January sunrise (05:57, day length 10 h 31 min) and Srinagar the longest day of the year (14 h 25 min in June); and the page-132 moon chart gives purnima about the 14th and amavasya about the 28th-29th with a measured daily lag of 49 minutes. TWO SLIPS IN THE PRINTED BOOK ARE FLAGGED: page 125 says Manoj recorded 'five types of activities' and then lists six (the strips do use six colours), and the page-122 Figure it Out numbers two different questions as '2'.. Questions are referenced from the NCERT textbook for identification.
