~/

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

~/

C1 English photo description useful vocabulary advanced proficiency

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

mkdir -p "/tmp/workspace/sports_photo_handbook/src" "/tmp/workspace/sports_photo_handbook/assets" "/tmp/workspace/sports_photo_handbook/output" && python - <<'PY' from pypdf import PdfReader p='/tmp/workspace/attachments/f37fea93-7639-42d9-96fd-2a201aa05a53/DOC-20260924-WA0002 (1).pdf' r=PdfReader(p); print('PAGES',len(r.pages)) for i,x in enumerate(r.pages): print('\nPAGE',i+1,'\n',x.extract_text() or '') PY python - <<'PY' import pymupdf p='/tmp/workspace/attachments/f37fea93-7639-42d9-96fd-2a201aa05a53/DOC-20260924-WA0002 (1).pdf'; d=pymupdf.open(p) for i,page in enumerate(d): pix=page.get_pixmap(matrix=pymupdf.Matrix(2.4,2.4), alpha=False); pix.save(f'/tmp/workspace/sports_photo_handbook/assets/source_{i+1}.png') print('rendered',i+1,pix.width,pix.height) PY

python - <<'PY' from pypdf import PdfReader from PIL import Image import io, os p='/tmp/workspace/attachments/f37fea93-7639-42d9-96fd-2a201aa05a53/DOC-20260924-WA0002 (1).pdf' r=PdfReader(p) for pi,page in enumerate(r.pages): print('page',pi+1,'images',len(page.images)) for j,im in enumerate(page.images): path=f'/tmp/workspace/sports_photo_handbook/assets/page{pi+1}_img{j}.{im.name.split(".")[-1]}' open(path,'wb').write(im.data) try: x=Image.open(io.BytesIO(im.data)); print(j,im.name,x.format,x.size); x.convert('RGB').save(f'/tmp/workspace/sports_photo_handbook/assets/page{pi+1}_img{j}.jpg') except Exception as e: print(j,im.name,'error',e) PY

cat > "/tmp/workspace/sports_photo_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, Image, PageBreak, KeepTogether from reportlab.lib.utils import ImageReader OUT='/tmp/workspace/sports_photo_handbook/output/C1_Sports_Photo_Description_Handbook.pdf' IMG='/tmp/workspace/sports_photo_handbook/assets/page1_img0.jpg' NAVY=colors.HexColor('#17324D'); BLUE=colors.HexColor('#177E89'); PALE=colors.HexColor('#EAF4F5'); GOLD=colors.HexColor('#D49A25'); GREY=colors.HexColor('#4D5D68') ss=getSampleStyleSheet() ss.add(ParagraphStyle(name='TitleX',parent=ss['Title'],fontName='Helvetica-Bold',fontSize=24,leading=29,textColor=NAVY,spaceAfter=7)) ss.add(ParagraphStyle(name='SubX',parent=ss['Normal'],fontName='Helvetica',fontSize=10,leading=14,textColor=GREY,spaceAfter=12)) ss.add(ParagraphStyle(name='H1X',parent=ss['Heading1'],fontName='Helvetica-Bold',fontSize=15,leading=19,textColor=NAVY,spaceBefore=5,spaceAfter=7)) ss.add(ParagraphStyle(name='H2X',parent=ss['Heading2'],fontName='Helvetica-Bold',fontSize=11,leading=14,textColor=BLUE,spaceBefore=5,spaceAfter=3)) ss.add(ParagraphStyle(name='BodyX',parent=ss['BodyText'],fontName='Helvetica',fontSize=9.6,leading=13.1,spaceAfter=5)) ss.add(ParagraphStyle(name='SmallX',parent=ss['BodyText'],fontName='Helvetica',fontSize=8.3,leading=10.7,textColor=GREY)) ss.add(ParagraphStyle(name='DescX',parent=ss['BodyText'],fontName='Helvetica',fontSize=11,leading=15.5,spaceAfter=6)) def P(x,s='BodyX'): return Paragraph(x,ss[s]) def footer(canvas,doc): canvas.saveState(); canvas.setStrokeColor(colors.HexColor('#CADCE0')); 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,'C1 Sports Photo Description Handbook'); canvas.drawRightString(19.5*cm,.85*cm,str(doc.page)); canvas.restoreState() doc=SimpleDocTemplate(OUT,pagesize=A4,leftMargin=1.5*cm,rightMargin=1.5*cm,topMargin=1.35*cm,bottomMargin=1.6*cm) story=[P('C1 SPORTS PHOTO DESCRIPTION','TitleX'),P('A concise, advanced-level description using relationship and sport vocabulary from the supplied lesson','SubX')] # fit image im=Image(IMG,width=17.2*cm,height=11.33*cm) story += [im,Spacer(1,7),P('<b>Image focus:</b> girls in sports uniforms, photographed as a team. The description below avoids inventing details that are not visibly certain.','SmallX'),Spacer(1,7)] story += [P('Vocabulary selected from the lesson','H1X')] rows=[ [P('<b>Team dynamics</b>','SmallX'),P('collaborate; pull their weight; be on speaking terms; see eye to eye; friction; at each other’s throats','SmallX')], [P('<b>Coach-athlete relationship</b>','SmallX'),P('coach-athlete; put people at ease; reassure; push somebody hard; single somebody out; slack; be dropped','SmallX')], [P('<b>Performance and support</b>','SmallX'),P('losing streak; lose one’s form; bounce back; spark an interest; compete for attention','SmallX')] ] t=Table(rows,colWidths=[4.4*cm,13.1*cm]) t.setStyle(TableStyle([('BACKGROUND',(0,0),(0,-1),BLUE),('TEXTCOLOR',(0,0),(0,-1),colors.white),('ROWBACKGROUNDS',(1,0),(1,-1),[PALE,colors.white]),('GRID',(0,0),(-1,-1),.35,colors.HexColor('#C4D9DD')),('VALIGN',(0,0),(-1,-1),'TOP'),('LEFTPADDING',(0,0),(-1,-1),8),('RIGHTPADDING',(0,0),(-1,-1),8),('TOPPADDING',(0,0),(-1,-1),7),('BOTTOMPADDING',(0,0),(-1,-1),7)])) story += [t,Spacer(1,8),P('<b>Good C1 practice:</b> describe what is clear in the photo, then use cautious inference such as <i>they appear to</i>, <i>the image suggests</i>, or <i>presumably</i>. Avoid claiming you know the players’ emotions or results.','BodyX')] story.append(PageBreak()) story += [P('Model description','H1X'),P('<b>Word count: 103 words</b>','SmallX')] desc='''The photograph depicts a group of girls in matching sports uniforms, apparently gathered as a team before or after a fixture. Their coordinated appearance and close formation suggest a disciplined coach-athlete environment in which each player is expected to pull her weight. Although a single image cannot reveal whether they always see eye to eye, the scene conveys a sense of shared purpose rather than friction or rivalry. They seem at ease with one another, which may reflect a coach who reassures the players while still pushing them hard to perform. Such an atmosphere can help athletes bounce back after losing their form or a disappointing losing streak.''' story += [P(desc,'DescX'),Spacer(1,8),P('Why it meets the task','H1X')] criteria=[['C1 feature','How it appears in the description'],['Precise vocabulary','“coordinated appearance”, “disciplined”, “shared purpose”, “atmosphere”'],['Lesson language','“coach-athlete”, “pull her weight”, “see eye to eye”, “friction”, “push them hard”, “bounce back”, “losing streak”'],['Careful inference','“apparently”, “suggest”, “seem”, “may reflect” prevent unsupported claims'],['Word control','103 words, so it stays below the 120-word limit']] t2=Table([[P('<b>'+a+'</b>' if i==0 else a,'SmallX'),P('<b>'+b+'</b>' if i==0 else b,'SmallX')] for i,(a,b) in enumerate(criteria)],colWidths=[5.1*cm,12.4*cm]) t2.setStyle(TableStyle([('BACKGROUND',(0,0),(-1,0),NAVY),('TEXTCOLOR',(0,0),(-1,0),colors.white),('ROWBACKGROUNDS',(0,1),(-1,-1),[colors.HexColor('#F3F7F8'),colors.white]),('GRID',(0,0),(-1,-1),.35,colors.HexColor('#C4D9DD')),('VALIGN',(0,0),(-1,-1),'TOP'),('LEFTPADDING',(0,0),(-1,-1),8),('RIGHTPADDING',(0,0),(-1,-1),8),('TOPPADDING',(0,0),(-1,-1),7),('BOTTOMPADDING',(0,0),(-1,-1),7)])) story += [t2,Spacer(1,10),P('Quick editing checklist','H1X'),P('1. Start with the people and setting. 2. Use two or three well-chosen phrases from the vocabulary bank. 3. Include only cautious interpretations. 4. Check that the description remains below 120 words.','BodyX')] doc.build(story,onFirstPage=footer,onLaterPages=footer) print(OUT) PY python "/tmp/workspace/sports_photo_handbook/src/create_handbook.py" python - <<'PY' from pypdf import PdfReader p='/tmp/workspace/sports_photo_handbook/output/C1_Sports_Photo_Description_Handbook.pdf'; r=PdfReader(p); text='\n'.join(x.extract_text() or '' for x in r.pages); print('pages=',len(r.pages),'chars=',len(text)); print('model?', 'Word count: 103 words' in text) PY

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

English coursebook audio transcript grammar vocabulary exercise answer reasoning guidance

mkdir -p "/tmp/workspace/two_files_handbook/src" "/tmp/workspace/two_files_handbook/assets" "/tmp/workspace/two_files_handbook/output" && python - <<'PY' from pypdf import PdfReader paths=['/tmp/workspace/attachments/f37fea93-7639-42d9-96fd-2a201aa05a53/DOC-20260926-WA0007.pdf','/tmp/workspace/attachments/f37fea93-7639-42d9-96fd-2a201aa05a53/DOC-20260926-WA0006 (1).pdf'] for p in paths: print('\n\n########',p.split('/')[-1]) r=PdfReader(p); print('pages=',len(r.pages)) for i,page in enumerate(r.pages): print('\n--- PAGE',i+1,'---\n'+(page.extract_text() or '')) PY

cat > "/tmp/workspace/two_files_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.units import cm from reportlab.platypus import SimpleDocTemplate, Paragraph, Spacer, Table, TableStyle, PageBreak, KeepTogether OUT='/tmp/workspace/two_files_handbook/output/Review_1_Video_Grammar_Vocabulary_Handbook.pdf' NAVY=colors.HexColor('#173B57'); TEAL=colors.HexColor('#087E8B'); PALE=colors.HexColor('#EAF5F5'); LINE=colors.HexColor('#C7DDE0'); GREY=colors.HexColor('#50616E'); GOLD=colors.HexColor('#B77D19') S=getSampleStyleSheet() for name,parent,size,leading,color in [('T',S['Title'],24,29,NAVY),('Sub',S['Normal'],9.8,13.2,GREY),('H1',S['Heading1'],15,19,NAVY),('H2',S['Heading2'],10.8,13.5,TEAL),('Body',S['BodyText'],9.25,12.7,colors.black),('Small',S['BodyText'],8.15,10.5,GREY),('Ans',S['BodyText'],9.15,12.8,colors.black)]: S.add(ParagraphStyle(name=name,parent=parent,fontName='Helvetica-Bold' if name in ['T','H1','H2'] else 'Helvetica',fontSize=size,leading=leading,textColor=color,spaceAfter=5,spaceBefore=2 if name in ['H1','H2'] else 0)) def P(text,st='Body'): return Paragraph(text,S[st]) def section(t): return [Spacer(1,5),P(t,'H1')] def footer(c,d): c.saveState(); c.setStrokeColor(LINE); c.line(1.45*cm,1.2*cm,19.55*cm,1.2*cm); c.setFillColor(GREY); c.setFont('Helvetica',7.8); c.drawString(1.45*cm,.8*cm,'Review 1: video, grammar and vocabulary answers'); c.drawRightString(19.55*cm,.8*cm,str(d.page)); c.restoreState() def answer_table(rows, widths=(2.0*cm,15.5*cm)): data=[[P('<b>'+a+'</b>','Small'),P(b,'Small')] for a,b in rows] t=Table(data,colWidths=widths,repeatRows=0) t.setStyle(TableStyle([('BACKGROUND',(0,0),(0,-1),TEAL),('TEXTCOLOR',(0,0),(0,-1),colors.white),('ROWBACKGROUNDS',(1,0),(1,-1),[PALE,colors.white]),('GRID',(0,0),(-1,-1),.3,LINE),('VALIGN',(0,0),(-1,-1),'TOP'),('LEFTPADDING',(0,0),(-1,-1),7),('RIGHTPADDING',(0,0),(-1,-1),7),('TOPPADDING',(0,0),(-1,-1),5),('BOTTOMPADDING',(0,0),(-1,-1),5)])) return t doc=SimpleDocTemplate(OUT,pagesize=A4,leftMargin=1.45*cm,rightMargin=1.45*cm,topMargin=1.35*cm,bottomMargin=1.55*cm) story=[P('REVIEW 1 ANSWER HANDBOOK','T'),P('Video, audio script, grammar and vocabulary | Based on the two supplied PDF files','Sub')] story.append(Table([[P('<b>What is included</b><br/>All answerable individual exercises from the two supplied pages, including video-script answers and complete grammar and vocabulary solutions.','Body'),P('<b>How to use it</b><br/>For discussion and role-play tasks without one fixed answer, model responses are supplied. Grammar and vocabulary answers include brief reasons in brackets.','Body')]],colWidths=[8.8*cm,8.8*cm],style=[('BACKGROUND',(0,0),(-1,-1),PALE),('BOX',(0,0),(-1,-1),.4,LINE),('VALIGN',(0,0),(-1,-1),'TOP'),('LEFTPADDING',(0,0),(-1,-1),9),('RIGHTPADDING',(0,0),(-1,-1),9),('TOPPADDING',(0,0),(-1,-1),8),('BOTTOMPADDING',(0,0),(-1,-1),8)])) story += section('A. Video: Out and about') story += [P('<b>Exercise 1 - model personal answers</b>','H2'),answer_table([('1','My example is Istanbul. It has become much more crowded and tourist-oriented, while traffic has become increasingly difficult.'),('2','This is mainly because the population has expanded and more people have moved there for work and study.'),('3','I appreciate the wider range of services, but I am concerned about congestion, pollution and the pressure on local residents.')])] story += [P('<b>Exercise 2 - answer</b>','H2'),P('The place most similar to a city experiencing rapid growth and overcrowding is <b>Istanbul</b>. Kemal says that its population has increased dramatically, traffic is terrible, and the growth helps tourism and Turkey generally but creates problems for local people.','Ans')] story += [P('<b>Exercise 3 - matching</b>','H2'),answer_table([('Milena (1)','Statement 4: tourists stay longer in Venice than they used to.'),('Luke (2)','Statement 7: the changes have become a major problem for local people.'),('Kat (3)','Statement 5: implementation was poor and there was insufficient consultation.'),('Kemal (4)','Statement 6: growth benefits Turkey, but not local residents.'),('Lucía (5)','Statement 8: there is a much wider range of restaurants.'),('Not used','Statements 1, 2 and 3.')])] story += [P('<b>Exercise 4 - model answers</b>','H2'),answer_table([('1','Venice in peak season was extremely overcrowded; the narrow streets were difficult to move through.'),('2','London is one of the most diverse places I have visited, with communities and cuisines from around the world.'),('3','A good example is a small Lebanese restaurant that serves fresh mezze and grilled dishes.'),('4','My city has introduced pedestrian zones and new cycle lanes to reduce traffic in the centre.'),('5','It is reasonably walkable, but safer crossings, shaded paths and continuous cycle lanes would improve it.')])] story.append(PageBreak()) story += section('B. Video: Developing conversations') story += [P('<b>Exercise 5 - viewing notes</b>','H2'),answer_table([('Speaker B','Has finally settled and unpacked in a new home. The area is pleasant and the neighbours seem friendly.'),('Jonathan','Lives two doors down. He introduced himself, offered help with the move and invited the new neighbours for dinner.'),('Speaker A','Has a great job, but finds the boss strict and difficult because the boss wants everything done his way.'),('Outcome','Speaker A hopes to establish a better relationship and a nicer working environment over time.')])] story += [P('<b>Exercise 6 - answer</b>','H2'),P('The key understanding is given in the notes for Exercise 5. The pair should compare these details and rewatch only to check any uncertain phrases. There is no separate fixed written answer.','Ans')] story += [P('<b>Exercise 7 - model discussion answers</b>','H2'),answer_table([('1','I know my neighbours fairly well. I get on best with the people next door because we help each other with small practical problems.'),('2','Common problems include noise, parking, pets, rubbish, boundaries and different expectations about shared spaces.'),('3','Someone could build a better relationship with a boss by clarifying expectations, meeting deadlines, asking for feedback and communicating respectfully.')])] story += [P('<b>Exercise 8 - complete sentences</b>','H2'),answer_table([('1','Are <b>you settling in</b>?'),('2','There’s some work <b>to be done</b>.'),('3','Jonathan, who <b>lives two doors down</b>, ...'),('4','Can I <b>give you guys a hand</b>?'),('5','He likes things <b>done his way</b>.'),('6','He seemed a little bit <b>more fun to be around</b>.'),('7','... and make <b>a nicer working environment</b>.'),('8','... you haven’t been there so long, <b>as you said</b>.')])] story += [P('<b>Exercise 9 - model conversation</b>','H2'),P('<b>A:</b> How are you settling into the new place?<br/><b>B:</b> It is getting there. There is still some work to be done, but a neighbour has been very welcoming and offered to give us a hand.<br/><b>A:</b> That is a lovely gesture. I hope you build a good relationship with him.<br/><b>B:</b> Thanks. How is work?<br/><b>A:</b> The job is great, although my boss likes things done his way. I am trying to understand his expectations and create a nicer working environment.','Ans')] story.append(PageBreak()) story += section('C. Grammar: complete answers with reasons') # grammar ex 1 story += [P('<b>Exercise 1 - choose the correct options</b>','H2')] g1=[('1','would <i>(“would consider” is the natural modal for a general, cautious present judgement)</i>.'),('2','absolutely <i>(an adverb is required to modify “huge”; “absolutely huge” is the fixed intensifier pattern)</i>.'),('3','utter <i>(“utter chaos” is a fixed adjective + noun collocation)</i>.'),('4','were only expected <i>(passive form is needed: things were expected to get worse)</i>.'),('5','would have imagined <i>(past modal perfect expresses a past expectation that did not occur)</i>.'),('6','brought it in <i>(the pronoun object goes between the verb and particle: bring it in)</i>.'),('7','have been <i>(“would not have been enough” refers to an unreal past condition)</i>.'),('8','sticking to it <i>(“stick to” is the correct phrasal verb, and “it” follows the preposition)</i>.'),('9','set to thrive <i>(“be set to + infinitive” means be expected or likely to do something)</i>.')] story.append(answer_table(g1)) story += [P('<b>Exercise 2 - sentence transformations</b>','H2')] g2=[('1','By and <b>large we would play</b> in the street. <i>(“by and large” means generally; “would” describes a past habit)</i>.'),('2','I think he <b>pushes the kids too much</b>. <i>(“push someone too much” means be too demanding of them)</i>.'),('3','The city has <b>gone through huge changes</b>. <i>(“go through changes” means experience them)</i>.'),('4','... so they <b>called it off</b>. <i>(“call off” means cancel; the object pronoun sits between verb and particle)</i>.'),('5','... if they <b>hadn’t pulled the slums</b> down. <i>(third conditional uses past perfect for the unreal past cause)</i>.'),('6','The whole thing was <b>really chaotic</b>. <i>(“really” modifies the adjective “chaotic”)</i>.')] story.append(answer_table(g2)) story.append(PageBreak()) story += section('D. Vocabulary: complete answers with reasons') story += [P('<b>Exercise 3 - word formation</b>','H2')] v3=[('1','gentrification <i>(the noun names the process of an area becoming wealthier)</i>.'),('2','arrogance <i>(a noun is required after “need”)</i>.'),('3','approachable <i>(an adjective describes the boss)</i>.'),('4','resilience <i>(the noun means the ability to recover from difficulty)</i>.'),('5','loner <i>(a person who prefers to be alone)</i>.'),('6','confrontations <i>(a plural countable noun fits “gets involved in”)</i>.'),('7','materialized <i>(past-tense verb: the plans did not become real)</i>.'),('8','upbringing <i>(the noun means childhood and the way someone was raised)</i>.')] story.append(answer_table(v3)) story += [P('<b>Exercise 4 - collocations</b>','H2')] v4=[('1 - e','cater for senior citizens / all abilities <i>(“cater for” means provide for a group’s needs)</i>.'),('2 - f','demolish a building / all their arguments <i>(“demolish” can mean destroy physically or defeat an argument)</i>.'),('3 - h','cling on to hope / his story <i>(“cling on to” means hold tightly to an idea or thing)</i>.'),('4 - a','harness expertise / the power of data <i>(“harness” means make practical use of a resource)</i>.'),('5 - d','impose restrictions / your ideas <i>(“impose” means force something on others)</i>.'),('6 - j','spark my interest / waves of protests <i>(“spark” means cause something to begin)</i>.'),('7 - c','sound their horns / the alarm bell <i>(both are conventional warning sounds)</i>.'),('8 - b','initiate the plan / legal proceedings <i>(“initiate” means formally start a process)</i>.'),('9 - g','collaborate closely / with him on a project <i>(“collaborate” means work jointly)</i>.')] story.append(answer_table(v4)) story += [P('<b>Exercise 5 - categories</b>','H2'),answer_table([('Character','conscientious; naïve; prickly; sheltered; streak <i>(these describe a person’s qualities, background or behavioural tendency)</i>.'),('Cities','congested; hustle and bustle; outskirts; sprawling; vibrant <i>(these describe urban space, activity or location)</i>.'),('Plans','from scratch; scale up; spiral; top-down; undertake <i>(these describe planning, growth, structure or action)</i>.')])] story.append(PageBreak()) story += section('D. Vocabulary continued') story += [P('<b>Exercise 6 - idioms, prepositions and model examples</b>','H2')] v6=[('1','in: She takes everything <b>in</b> her stride. <i>(fixed idiom meaning she deals with difficulties calmly)</i>. Example: She took the delayed flight in her stride.'),('2','to: They do not see eye <b>to</b> eye. <i>(fixed idiom meaning they disagree)</i>. Example: My parents do not see eye to eye on social media.'),('3','on: I choked <b>on</b> my coffee. <i>(we choke on food or drink)</i>. Example: He choked on a piece of bread.'),('4','at: They are <b>at</b> each other’s throats. <i>(fixed idiom for arguing intensely)</i>. Example: The two teams were at each other’s throats.'),('5','to: The project ground <b>to</b> a halt. <i>(fixed phrase for stopping gradually or completely)</i>. Example: Work ground to a halt during the strike.'),('6','about: There is a buzz <b>about</b> the place. <i>(“buzz about” means excited talk or energy)</i>. Example: There is a real buzz about the new café.'),('7','at: She puts people <b>at</b> their ease. <i>(fixed expression meaning makes them feel relaxed)</i>. Example: The host put everyone at their ease.'),('8','into: They are crammed <b>into</b> a tiny space. <i>(“cram into” means fit too many people or things in)</i>. Example: We were crammed into a small lift.'),('9','on: Her talent rubbed off <b>on</b> me. <i>(“rub off on” means be passed on through influence)</i>. Example: His enthusiasm rubbed off on the team.'),('10','for: The city is a beacon <b>for</b> inward investment. <i>(“a beacon for” identifies something as an attractive example or focus)</i>. Example: The region became a beacon for technology firms.')] story.append(answer_table(v6)) story += [P('<b>Exercise 7 - complete text</b>','H2')] v7=[('1','intense <i>(adjective describing Miguel’s serious personality)</i>.'),('2','laid-back <i>(compound adjective meaning relaxed and easy-going)</i>.'),('3','envisage <i>(verb meaning imagine or expect future problems)</i>.'),('4','friction <i>(noun for tension or disagreement between people)</i>.'),('5','trace <i>(“a trace of dirt” means a very small amount)</i>.'),('6','prone <i>(“prone to” means likely to do or suffer something)</i>.'),('7','here and there <i>(idiom for in various scattered places)</i>.'),('8','weight <i>(“pull my weight” means do my fair share)</i>.'),('9','lighten up <i>(phrasal verb meaning become less serious or strict)</i>.'),('10','spotless <i>(adjective meaning perfectly clean)</i>.'),('11','time <i>(“time and again” means repeatedly)</i>.'),('12','terms <i>(“on speaking terms” means willing to speak to each other)</i>.')] story.append(answer_table(v7)) story += [Spacer(1,8),P('Answer-source note','H2'),P('Fixed-answer solutions, video completions and matching are taken from the supplied teacher-material PDF. The open discussion, note-taking and role-play exercises have no single official answer, so this handbook provides appropriate model responses.','Small')] doc.build(story,onFirstPage=footer,onLaterPages=footer) print(OUT) PY python "/tmp/workspace/two_files_handbook/src/create_handbook.py" python - <<'PY' from pypdf import PdfReader p='/tmp/workspace/two_files_handbook/output/Review_1_Video_Grammar_Vocabulary_Handbook.pdf'; r=PdfReader(p); tx=''.join(x.extract_text() or '' for x in r.pages); print('pages',len(r.pages),'chars',len(tx)); print('all markers',all(s in tx for s in ['Exercise 8','Exercise 7','Answer-source note'])) PY

~/two_files_handbook/output

~/

CEFR C1 English vocabulary advanced discussion answers collocations relationships cities

python - <<'PY' p='/tmp/workspace/two_files_handbook/src/create_handbook.py' s=open(p).read() s=s.replace("OUT='/tmp/workspace/two_files_handbook/output/Review_1_Video_Grammar_Vocabulary_Handbook.pdf'", "OUT='/tmp/workspace/two_files_handbook/output/Review_1_C1_Enhanced_Handbook.pdf'") s=s.replace("Video, audio script, grammar and vocabulary | Based on the two supplied PDF files", "Video, audio script, grammar and vocabulary | C1-enhanced model answers based on the two supplied PDF files") s=s.replace("For discussion and role-play tasks without one fixed answer, model responses are supplied. Grammar and vocabulary answers include brief reasons in brackets.", "For open-ended tasks, the model responses deliberately recycle recent C1 vocabulary, collocations and idioms. Grammar and vocabulary answers include brief reasons in brackets.") s=s.replace("('1','My example is Istanbul. It has become much more crowded and tourist-oriented, while traffic has become increasingly difficult.'),('2','This is mainly because the population has expanded and more people have moved there for work and study.'),('3','I appreciate the wider range of services, but I am concerned about congestion, pollution and the pressure on local residents.')", "('1','My example is Istanbul. It has undergone dramatic expansion: its vibrant cultural life and tourist appeal have intensified, but the city is now severely congested.'),('2','The transformation stems from sustained population growth, inward migration for employment and the concentration of opportunities in the metropolis.'),('3','Although the expanded infrastructure and cultural diversity are beneficial, I am concerned about spiralling congestion, pollution and the strain placed on local residents.')") s=s.replace("('1','Venice in peak season was extremely overcrowded; the narrow streets were difficult to move through.'),('2','London is one of the most diverse places I have visited, with communities and cuisines from around the world.'),('3','A good example is a small Lebanese restaurant that serves fresh mezze and grilled dishes.'),('4','My city has introduced pedestrian zones and new cycle lanes to reduce traffic in the centre.'),('5','It is reasonably walkable, but safer crossings, shaded paths and continuous cycle lanes would improve it.')", "('1','Venice during peak season was unbearably congested. Its narrow thoroughfares were crammed with visitors, which undermined the atmosphere for residents.'),('2','London is arguably the most diverse city I have visited, as its neighbourhoods bring together communities, languages and cuisines from across the globe.'),('3','A memorable example is a Lebanese restaurant whose carefully prepared mezze and charcoal-grilled dishes are both authentic and reasonably priced.'),('4','My city has introduced pedestrianised zones and segregated cycle lanes in an attempt to curb traffic and make the centre more accessible.'),('5','It is relatively walkable; nevertheless, safer crossings, uninterrupted cycle routes and more shade would make it considerably more inclusive.')") s=s.replace("('Speaker B','Has finally settled and unpacked in a new home. The area is pleasant and the neighbours seem friendly.'),('Jonathan','Lives two doors down. He introduced himself, offered help with the move and invited the new neighbours for dinner.'),('Speaker A','Has a great job, but finds the boss strict and difficult because the boss wants everything done his way.'),('Outcome','Speaker A hopes to establish a better relationship and a nicer working environment over time.')", "('Speaker B','Has finally settled into a new home. The neighbourhood appears pleasant, and the neighbours have made an exceptionally welcoming first impression.'),('Jonathan','Lives two doors down. He introduced himself, offered to give the newcomers a hand and invited them to dinner, an unexpectedly generous gesture.'),('Speaker A','Values the job but finds the boss exacting, as he insists that everything be done his way and expects staff to meet stringent standards.'),('Outcome','Speaker A hopes to forge a constructive rapport and cultivate a more congenial working environment over time.')") s=s.replace("('1','I know my neighbours fairly well. I get on best with the people next door because we help each other with small practical problems.'),('2','Common problems include noise, parking, pets, rubbish, boundaries and different expectations about shared spaces.'),('3','Someone could build a better relationship with a boss by clarifying expectations, meeting deadlines, asking for feedback and communicating respectfully.')", "('1','I know my neighbours reasonably well. I get on particularly well with the couple next door because we have established a reciprocal, supportive relationship.'),('2','Neighbourly friction often arises from excessive noise, parking disputes, poorly managed waste, pets or incompatible expectations about communal space.'),('3','To improve relations with a boss, I would clarify priorities, meet deadlines consistently, invite constructive feedback and communicate concerns tactfully.')") s=s.replace("<b>A:</b> How are you settling into the new place?<br/><b>B:</b> It is getting there. There is still some work to be done, but a neighbour has been very welcoming and offered to give us a hand.<br/><b>A:</b> That is a lovely gesture. I hope you build a good relationship with him.<br/><b>B:</b> Thanks. How is work?<br/><b>A:</b> The job is great, although my boss likes things done his way. I am trying to understand his expectations and create a nicer working environment.", "<b>A:</b> How are you settling into the new place?<br/><b>B:</b> It is gradually taking shape. There is still some work to be done, but a neighbour has been remarkably welcoming and offered to give us a hand.<br/><b>A:</b> That is an exceptionally thoughtful gesture. It sounds as though you may forge a genuine rapport with him.<br/><b>B:</b> I hope so. How is work?<br/><b>A:</b> The role is stimulating, although my boss is rather exacting and likes things done his way. I am trying to anticipate his expectations and cultivate a more constructive working environment.") s=s.replace("The open discussion, note-taking and role-play exercises have no single official answer, so this handbook provides appropriate model responses.", "The open discussion, note-taking and role-play exercises have no single official answer, so this handbook provides C1-level model responses that recycle the recent vocabulary set.") open('/tmp/workspace/two_files_handbook/src/create_c1_handbook.py','w').write(s) PY python "/tmp/workspace/two_files_handbook/src/create_c1_handbook.py" python - <<'PY' from pypdf import PdfReader p='/tmp/workspace/two_files_handbook/output/Review_1_C1_Enhanced_Handbook.pdf' r=PdfReader(p); t='\n'.join(x.extract_text() or '' for x in r.pages) print('pages:',len(r.pages),'chars:',len(t)) for marker in ['dramatic expansion','forge a constructive rapport','segregated cycle lanes','stringent standards','C1-enhanced']: print(marker,marker in t) PY

~/two_files_handbook/output