Beginner
60 mins
Teacher/Student led
+70 XP

Ka1 Workshop Part 3 — Evidence Check & Unit 1 Recap

Teacher Class Feed

Load previous activity

    1 - Welcome & Warm-up

    Warm-up (30 seconds): Open your Digital Portfolio folder. Find your Lesson 6 Numbers Sheet and Lesson 7 chart. What decision did the chart help you make about your Something Real project?

    By the end of this lesson, you will be able to:

    • Check that your spreadsheet meets all SEC requirements for KA1
    • Finalise and export your spreadsheet evidence as PDF
    • Complete your Unit 1 reflection connecting spreadsheets to your project
    • Organise complete KA1 evidence for submission

    This is the final workshop to polish your ICT2 KA1 evidence. You'll check your spreadsheet against SEC criteria, export it as PDF, write your Unit 1 reflection, and organise everything for submission.

    2 - Key Concepts

    SEC Spreadsheet Learning Outcomes (KA1 Guidance)

    Example elements that help demonstrate the LCA ICT module learning outcomes (per curriculumonline.ie):

    • Data Entry: Structured table with column headings and multiple rows of data
    • Formulas: Functions like SUM, AVERAGE, COUNT, MIN, or MAX
    • Formatting: Number formats (€ currency, decimals), bold headers, borders, cell alignment
    • Chart: Visual representation of your data with title, labels, legend
    • Decision: Sentence showing how the chart/data changed a project decision

    Portfolio Evidence Checklist

    • ☐ Lesson 6 Numbers Sheet (.xlsx/.gsheet)
    • ☐ Lesson 7 Chart & Decision sentence (.xlsx/.gsheet or .docx)
    • ☐ Exported PDF versions of both files
    • ☐ Unit 1 Reflection (this lesson)

    3 - Step-by-step: Ka1 Evidence Checklist

    Follow these instructions to check your spreadsheet against SEC KA1 requirements and export PDF evidence. Work through each platform's tab.

    Common Issues

    • Issue: Can't find my spreadsheet files
      Solution: Look in your Digital Portfolio folder from Lessons 6-7
    • Issue: PDF export looks wrong
      Solution: Check print settings show 'Fit to page' and landscape orientation for wide tables
    • Issue: Chart disappeared in PDF
      Solution: Make sure chart is selected/not overlapping data when exporting

    4 - Step-by-step: Unit 1 Reflection & Evidence Organisation

    Write your complete Unit 1 Reflection connecting spreadsheets to your Something Real project (answer ALL 5 questions below), then export as PDF evidence.

    123learn · Online learning platform

    Unlock the full learning experience

    You're previewing this lesson. Get full access to this lesson and hundreds more — each one ready to teach, with interactive activities, printable resources and pupil progress tracking built in.

    Hundreds of curriculum-aligned lessons
    Interactive activities in every lesson
    Printable resources & progress tracking
    Copyright Notice
    This lesson is copyright of Coding Ireland 2017 - 2026. Unauthorised use, copying or distribution is not allowed.
    🍪 Our website uses cookies to make your browsing experience better. By using our website you agree to our use of cookies. Learn more