Secondary Transition Year

Digital Spreadsheets

Survey your school, analyse the answers and present findings someone can act on.

  • 10 lessons
  • About 10 hours
  • Mapped to the NCCA curriculum

The sample is the whole first lesson, in a new tab. No sign-in needed.

What your school gets

10 lessons you teach from the board, with the same lesson open on each student's device

Every lesson is planned step by step and ready to teach, with 3 interactive activities across the course, including:

  • Step-by-Step Tutorial
  • and 2 more
Open a sample lesson: Ask a Question Worth Answering
Teacher Resource Book Digital Spreadsheets

Teacher Resource Book

The whole course laid out for the teacher, lesson by lesson.

Teachers in your school download the whole book. Sign in

Quizzes and assessments

A short quiz with every lesson.

Progress and results

See what each student has completed and how they did, lesson by lesson.

Student certificates

For portfolios, open days and reports home.

Curriculum mapping

Mapped outcome by outcome to the NCCA Transition Year Programme Statement (2025).

About this course

Students run their own anonymous survey of school life and analyse the answers across ten 60-minute lessons: a survey linked to a spreadsheet, data cleaning with a cleaning log, COUNTIF and AVERAGEIF summaries with absolute references, percentages and colour scales, IF and IFS bands, an XLOOKUP explorer with a drop-down list, pivot tables, honest fully labelled charts and a protected one-screen dashboard. In Lesson 10 students write a findings note with a recommendation and present it in groups of four. Every lesson includes sample data on screen, so no student is held up by too few answers. Every step-by-step covers Excel for the web with Microsoft Forms, and Google Sheets with Google Forms, on Windows, Mac and Chromebook.

The course, module by module

10 lessons in 3 modules. The lesson marked Sample opens in full.

1 Collect and Clean 2 lessons · about 2 hours
  1. Survey Design and Data Collection
  2. 1 Ask a Question Worth Answering Sample lesson Quiz
  3. Data Cleaning
  4. 2 Clean It Before You Trust It Quiz
2 Analyse 5 lessons · about 5 hours
  1. Counting and Comparing
  2. 3 Count What Matters Quiz
  3. 4 Percentages and Comparisons Quiz
  4. Bands, Lookups and Pivot Tables
  5. 5 Formulas That Decide Quiz
  6. 6 Look It Up Quiz
  7. 7 Pivot Tables: Summaries in Seconds Quiz
3 Show and Tell 3 lessons · about 3 hours
  1. Honest Charts and Dashboards
  2. 8 Charts That Tell the Truth Quiz
  3. 9 A Dashboard on One Screen Quiz
  4. Findings and Presentation
  5. 10 Findings Day Quiz

Curriculum mapping

Tap any outcome to read it. The coloured ones are taught in this course.

See every outcome
Curriculum Area
Outcomes
Personal Growth
P.1 P.2 P.3 P.4 P.5 P.6 P.7 P.8 P.9 P.10 P.11
Being a Learner
B.1 B.2 B.3 B.4 B.5 B.6 B.7 B.8 B.9 B.10 B.11 B.12
Civic and Community Engagement
C.1 C.2 C.3 C.4 C.5 C.6 C.7 C.8 C.9 C.10 C.11
Career Exploration
CE.1 CE.2 CE.3 CE.4 CE.5 CE.6 CE.7 CE.8

The curriculum does not include official reference codes for individual learning outcomes, so we have assigned a code scheme to make it easier to identify and track coverage.

What students will learn

Learning goals

  1. Design an anonymous survey with answers that can be counted, linked to a spreadsheet.
  2. Clean real data and record every change.
  3. Summarise and compare groups with COUNTIF, percentages, bands, lookups and pivot tables.
  4. Present data honestly with labelled charts and a one-screen dashboard.
  5. Write findings that say how sure the data lets you be, with a recommendation.

Build a full TY year around Digital Spreadsheets

This module is one of 10 Transition Year modules you can combine into a complete Year-Long TY Digital Skills Programme, shaped around your timetable and the students in front of you.

Run the same pathway for every student, or set different pathways for different groups. Students also get access to the modules they're not doing in class, which is ideal for the keen ones who finish early or want to explore further on their own time.

Prefer a deeper tech focus? Swap in Advanced Coding or Robotics and Automation. Each module is 10 to 15 lessons of 40-60 minutes, leaving room for school events, mid-terms and everything else TY throws at you.

Why TY coordinators choose it
One decision, a year's content
No more stitching resources together every term.
Flexible per class, per student
Run different pathways side by side.
Certificates after each module
Great for TY portfolios, open days and reports home.
Sets students up for Senior Cycle
Broad exposure so they choose subjects with confidence.
Sample Year Plan
ICT + Coding focus
  • Computer Skills
    Gets everyone on a level footing
  • Introduction to Coding
    Real, working projects from week one
  • Exploring Digital Media
    Video, design and storytelling
  • Exploring Artificial Intelligence
    The topic your students keep asking about
  • Enterprise and Business Basics
    A pitch-and-launch project to close out the year

Ready to bring this course to your school?

Get in touch to discuss pricing and ordering for your school.

Back to Transition Year courses
Ready to get started?
Pricing & Ordering Contact Us
🍪 Our website uses cookies to make your browsing experience better. By using our website you agree to our use of cookies. Learn more