~/

educational data interpretation exercises table graph handbook answer format

~/attachments/f37fea93-7639-42d9-96fd-2a201aa05a53

mkdir -p "/tmp/workspace/exercise_handbook/src" "/tmp/workspace/exercise_handbook/output" "/tmp/workspace/exercise_handbook/assets" && python -c "from pypdf import PdfReader; p='/tmp/workspace/attachments/f37fea93-7639-42d9-96fd-2a201aa05a53/DOC-20260925-WA0026.pdf'; r=PdfReader(p); print('pages',len(r.pages)); [print('PAGE',i+1,repr((x.extract_text() or '')[:3000])) for i,x in enumerate(r.pages)]"

python -c "import fitz; p='/tmp/workspace/attachments/f37fea93-7639-42d9-96fd-2a201aa05a53/DOC-20260925-WA0026.pdf'; d=fitz.open(p); pix=d[0].get_pixmap(matrix=fitz.Matrix(2.5,2.5), alpha=False); pix.save('/tmp/workspace/exercise_handbook/assets/source_page.png'); print(pix.width,pix.height)"

pip install --user PyMuPDF -q && python -c "import fitz; p='/tmp/workspace/attachments/f37fea93-7639-42d9-96fd-2a201aa05a53/DOC-20260925-WA0026.pdf'; d=fitz.open(p); pix=d[0].get_pixmap(matrix=fitz.Matrix(2.5,2.5), alpha=False); pix.save('/tmp/workspace/exercise_handbook/assets/source_page.png'); print(pix.width,pix.height)"

python -c "from PIL import Image; im=Image.open('/tmp/workspace/exercise_handbook/assets/source_page.png'); print(im.size); im.crop((0,1050,1489,2105)).save('/tmp/workspace/exercise_handbook/assets/lower.png')" && python -c "import pytesseract; from PIL import Image; print(pytesseract.image_to_string(Image.open('/tmp/workspace/exercise_handbook/assets/lower.png')))"

which tesseract || true; python - <<'PY' import pymupdf p='/tmp/workspace/attachments/f37fea93-7639-42d9-96fd-2a201aa05a53/DOC-20260925-WA0026.pdf' d=pymupdf.open(p); page=d[0] print(page.rect) for im in page.get_images(full=True): print(im) PY

python - <<'PY' import pymupdf p='/tmp/workspace/attachments/f37fea93-7639-42d9-96fd-2a201aa05a53/DOC-20260925-WA0026.pdf'; page=pymupdf.open(p)[0] for b in page.get_text('blocks'): print(tuple(round(x,1) if isinstance(x,float) else x for x in b[:4]),repr(b[4][:500])) PY

python - <<'PY' import pymupdf p='/tmp/workspace/attachments/f37fea93-7639-42d9-96fd-2a201aa05a53/DOC-20260925-WA0026.pdf'; pg=pymupdf.open(p)[0] for x in pg.get_drawings(): r=x['rect'] if 290<r.x0<570 and 290<r.y0<500: print('rect',tuple(round(z,1) for z in r),'color',x.get('color'),'fill',x.get('fill'),'width',x.get('width'),'items',x['items'][:4]) PY

cat > "/tmp/workspace/exercise_handbook/src/create_handbook.py" <<'PY' from reportlab.lib.pagesizes import A4 from reportlab.lib import colors from reportlab.lib.styles import getSampleStyleSheet, ParagraphStyle from reportlab.lib.enums import TA_CENTER from reportlab.lib.units import cm from reportlab.platypus import SimpleDocTemplate, Paragraph, Spacer, Table, TableStyle, PageBreak, Image, KeepTogether from reportlab.pdfbase.pdfmetrics import stringWidth out='/tmp/workspace/exercise_handbook/output/Exercises_8_9_Handbook.pdf' DARK=colors.HexColor('#183B56'); TEAL=colors.HexColor('#087E8B'); PALE=colors.HexColor('#E8F3F5'); GOLD=colors.HexColor('#C9932B'); GREY=colors.HexColor('#52616B') styles=getSampleStyleSheet() styles.add(ParagraphStyle(name='Title2', parent=styles['Title'], fontName='Helvetica-Bold', fontSize=25, leading=30, textColor=DARK, spaceAfter=8)) styles.add(ParagraphStyle(name='Sub', parent=styles['Normal'], fontSize=10.2, leading=14, textColor=GREY, spaceAfter=11)) styles.add(ParagraphStyle(name='H1x', parent=styles['Heading1'], fontName='Helvetica-Bold', fontSize=16, leading=20, textColor=DARK, spaceBefore=5, spaceAfter=8)) styles.add(ParagraphStyle(name='H2x', parent=styles['Heading2'], fontName='Helvetica-Bold', fontSize=11.5, leading=14, textColor=TEAL, spaceBefore=7, spaceAfter=4)) styles.add(ParagraphStyle(name='Bodyx', parent=styles['BodyText'], fontName='Helvetica', fontSize=9.5, leading=13.2, spaceAfter=5)) styles.add(ParagraphStyle(name='Smallx', parent=styles['BodyText'], fontName='Helvetica', fontSize=8.2, leading=10.4, textColor=GREY)) styles.add(ParagraphStyle(name='Answer', parent=styles['BodyText'], fontName='Helvetica', fontSize=9.8, leading=14, spaceAfter=5)) styles.add(ParagraphStyle(name='Sample', parent=styles['BodyText'], fontName='Helvetica', fontSize=10, leading=14.5, spaceAfter=6)) def P(t,style='Bodyx'): return Paragraph(t, styles[style]) def footer(canvas, doc): canvas.saveState(); canvas.setStrokeColor(colors.HexColor('#D6E3E8')); canvas.line(1.5*cm,1.25*cm,19.5*cm,1.25*cm) canvas.setFillColor(GREY); canvas.setFont('Helvetica',8); canvas.drawString(1.5*cm,.85*cm,'Exercises 8-9 | Data description handbook'); canvas.drawRightString(19.5*cm,.85*cm,f'{doc.page}'); canvas.restoreState() doc=SimpleDocTemplate(out,pagesize=A4,rightMargin=1.5*cm,leftMargin=1.5*cm,topMargin=1.4*cm,bottomMargin=1.6*cm) story=[] story += [P('DATA DESCRIPTION HANDBOOK','Title2'),P('Worked responses for Exercises 8 and 9: world population by education level and population aged under 15','Sub')] story.append(Table([[P('<b>What you will learn</b><br/>How to identify overall patterns, select supporting figures, distinguish facts from forecasts, and write a focused 150-200 word overview.','Bodyx'), P('<b>Source visuals</b><br/>Table: 2010-2040, in millions. Graph: 1970-2100, in billions. Years after 2020 on the graph are projections.','Bodyx')]],colWidths=[8.8*cm,8.8*cm],style=[('BACKGROUND',(0,0),(-1,-1),PALE),('BOX',(0,0),(-1,-1),.5,colors.HexColor('#B8D8DD')),('INNERGRID',(0,0),(-1,-1),.5,colors.white),('VALIGN',(0,0),(-1,-1),'TOP'),('LEFTPADDING',(0,0),(-1,-1),10),('RIGHTPADDING',(0,0),(-1,-1),10),('TOPPADDING',(0,0),(-1,-1),8),('BOTTOMPADDING',(0,0),(-1,-1),8)])) story += [Spacer(1,12),P('The source data at a glance','H1x')] data=[['Education level','2010','2020','2030','2040'],['Post-secondary','615','842','1,098','1,385'],['Upper secondary','1,269','1,599','1,967','2,330'],['Lower secondary','1,134','1,286','1,399','1,440'],['Primary','901','959','988','987'],['Incomplete primary','317','312','293','262'],['No education','791','735','659','568']] t=Table([[P('<b>'+x+'</b>','Smallx') if r==0 else P(x,'Smallx') for x in row] for r,row in enumerate(data)],colWidths=[6.4*cm,2.7*cm,2.7*cm,2.7*cm,2.7*cm]) t.setStyle(TableStyle([('BACKGROUND',(0,0),(-1,0),DARK),('TEXTCOLOR',(0,0),(-1,0),colors.white),('BACKGROUND',(0,1),(-1,-1),colors.white),('ROWBACKGROUNDS',(0,1),(-1,-1),[colors.white,colors.HexColor('#F2F7F8')]),('GRID',(0,0),(-1,-1),.35,colors.HexColor('#C9D9DE')),('VALIGN',(0,0),(-1,-1),'MIDDLE'),('ALIGN',(1,0),(-1,-1),'CENTER'),('LEFTPADDING',(0,0),(-1,-1),6),('RIGHTPADDING',(0,0),(-1,-1),6),('TOPPADDING',(0,0),(-1,-1),5),('BOTTOMPADDING',(0,0),(-1,-1),5)])) story += [t,Spacer(1,7),P('<b>Useful calculated changes, 2010-2040:</b> post-secondary +770 million (about 125%); upper secondary +1,061 million (about 84%); no education -223 million (about 28%). Primary education is broadly stable, rising to 988 million in 2030 before edging down to 987 million.','Smallx'),Spacer(1,8)] story += [P('Reading the graph carefully','H1x'),P('The line graph presents the number of people under 15 by world region. The world total rises from roughly 1.4 billion in 1970 to a peak of just under 1.9 billion around 2020, then is projected to decline to about 1.25 billion by 2100. The regional paths diverge: Africa is the notable upward exception, while Asia falls after its earlier high point and Europe, Northern America, Oceania, and Latin America and the Caribbean remain comparatively small or decline.','Bodyx')] story += [P('Exercise 8: model discussion answers','H1x')] qs=[('<b>1. What do the table and graph generally show?</b>','They show two related global demographic trends. The table gives the world population, in millions, at six education levels between 2010 and 2040. The graph shows the world population under 15, in billions, by region from 1970 to 2100.'),('<b>2. What are the main facts, trends and predictions?</b>','Educational attainment improves markedly: the post-secondary and upper-secondary groups grow, while incomplete primary education and no education shrink. In the graph, the global under-15 population reaches a high point around 2020 and is then expected to fall. Africa is forecast to increase strongly, unlike most other regions.'),('<b>3. What specific statistics illustrate the trend?</b>','Upper-secondary education rises from 1,269 million in 2010 to 2,330 million in 2040. Post-secondary education more than doubles, from 615 to 1,385 million. By contrast, the no-education group falls from 791 to 568 million. On the graph, the world total moves from about 1.4 billion in 1970 to nearly 1.9 billion in 2020, before falling to roughly 1.25 billion in 2100.'),('<b>4. Are there any other surprising aspects to highlight?</b>','Yes. Primary education changes very little: it peaks at 988 million in 2030 and is virtually unchanged at 987 million in 2040. Also, the worldwide decline in children is not shared by Africa, whose projected rise stands out against the downward movement in Asia and several smaller regions.')] for h,a in qs: story += [P(h,'H2x'),P(a,'Answer')] story.append(PageBreak()) story += [P('Exercise 9: complete model answer','H1x'),P('<b>Word count: 184 words</b>','Smallx')] answer='''The table and line graph illustrate changes in the world population by educational attainment and in the number of people aged under 15 by region. Overall, the figures suggest that global education levels will improve substantially by 2040, while the worldwide population of children will decline after reaching a peak around 2020. However, Africa is expected to follow a different pattern from most regions.<br/><br/>In the table, the largest growth is predicted at the higher education levels. The number of people with upper-secondary education is projected to rise from 1,269 million in 2010 to 2,330 million in 2040, an increase of just over one billion. Similarly, the post-secondary group will more than double, from 615 to 1,385 million. In contrast, the number with no education is forecast to fall by 223 million, from 791 to 568 million, while incomplete primary education will decrease from 317 to 262 million. Primary education will remain almost stable, at just under one billion.<br/><br/>The graph shows that the global under-15 population rose from about 1.4 billion in 1970 to almost 1.9 billion in 2020. It is then predicted to fall to roughly 1.25 billion by 2100. Africa is the main exception, with a steep projected increase, whereas Asia and the other regions decline or remain comparatively low.''' story.append(P(answer,'Sample')) story += [Spacer(1,5),P('Why this response works','H1x')] checks=[['1','Clear overview','It states the two main overall trends before giving detail.'],['2','Selective evidence','It gives key start and end values, not every number in the table.'],['3','Accurate comparison','It contrasts rising higher attainment with declining low attainment.'],['4','Forecast language','It uses “projected”, “expected”, and “predicted” for future data.'],['5','Linked visuals','It describes the table and graph together, then explains the African exception.']] ct=Table([[P('<b>'+c[0]+'</b>','Smallx'),P('<b>'+c[1]+'</b>','Smallx'),P(c[2],'Smallx')] for c in checks],colWidths=[1*cm,4.2*cm,12.6*cm]) ct.setStyle(TableStyle([('BACKGROUND',(0,0),(0,-1),TEAL),('TEXTCOLOR',(0,0),(0,-1),colors.white),('ROWBACKGROUNDS',(1,0),(-1,-1),[colors.HexColor('#F2F7F8'),colors.white]),('GRID',(0,0),(-1,-1),.35,colors.HexColor('#C9D9DE')),('VALIGN',(0,0),(-1,-1),'MIDDLE'),('ALIGN',(0,0),(0,-1),'CENTER'),('LEFTPADDING',(0,0),(-1,-1),7),('RIGHTPADDING',(0,0),(-1,-1),7),('TOPPADDING',(0,0),(-1,-1),6),('BOTTOMPADDING',(0,0),(-1,-1),6)])) story += [ct,Spacer(1,9),P('Language bank','H1x'),P('<b>Introducing:</b> The table/graph illustrates... &nbsp;&nbsp; <b>Describing change:</b> rose from... to..., fell by..., remained broadly stable. &nbsp;&nbsp; <b>Comparing:</b> By contrast..., whereas..., the main exception is... &nbsp;&nbsp; <b>Forecasting:</b> is projected/expected/predicted to...','Bodyx'),Spacer(1,6),P('Note: The graph values in this handbook are approximate because the source graph is scaled visually. The table values are reproduced exactly from the supplied exercise.','Smallx')] doc.build(story,onFirstPage=footer,onLaterPages=footer) print(out) PY python "/tmp/workspace/exercise_handbook/src/create_handbook.py" python - <<'PY' from pypdf import PdfReader p='/tmp/workspace/exercise_handbook/output/Exercises_8_9_Handbook.pdf'; r=PdfReader(p); print('pages',len(r.pages)); print('text',len(''.join(x.extract_text() or '' for x in r.pages))) PY

python - <<'PY' import pymupdf p='/tmp/workspace/exercise_handbook/output/Exercises_8_9_Handbook.pdf'; d=pymupdf.open(p) for i,page in enumerate(d): pix=page.get_pixmap(matrix=pymupdf.Matrix(1.3,1.3),alpha=False) pix.save(f'/tmp/workspace/exercise_handbook/assets/handbook_page_{i+1}.png') print(i+1, page.rect) PY