Explicit Instruction & Cognitive Load Lesson Planning Tracker| Google Sheets

Optimise your literacy block, streamline explicit teaching cycles, and manage student working memory with this Explicit Instruction & Cognitive Load Lesson Planning Tracker for Google Sheets! Designed specifically for primary and secondary teachers, literacy leads, and instructional coaches, this tool helps you design high-impact 2-hour instructional blocks grounded in Cognitive Load Theory and Science of Reading/Learning principles.

Whether you are mapping out daily phonemic awareness warm-ups, explicit phonics modelling ('I Do'), guided practice ('We Do'), or independent fluency tasks ('You Do'), this tracker keeps your lesson pacing tight, evidence-based, and manageable.

📥 WHAT’S INCLUDED?

• 📊 Master 2-Hour Block Schedule Planner:

  • 🕒 Time & Duration Pacing: Track time slots and lesson durations with automatic minute tallying to prevent lesson overruns.

  • 🎯 Instructional Pillar Selection: Custom dropdowns for core literacy pillars (e.g., Phonemic Awareness, Phonics, Vocabulary, Fluency, Comprehension, Syntax/Spelling).

  • 🧠 Cognitive Load Strategy Focus: Plan explicit working-memory supports such as Chunked Instruction, Low-Stakes Retrieval Practice, Dual Coding (Visual + Verbal), Worked Examples, Choral Responding, Interleaved Review, and Scaffolded Practice.

  • 📝 Teacher & Student Action Mapping: Clearly delineate explicit teacher modeling ('I Do'), co-construction ('We Do'), and independent student execution ('You Do').

  • 🛠️ Resources & Tech Needed: Dedicated columns to list slide decks, decodable readers, mini whiteboards, visualisers, and timers.

• 📖 How to Use & Implementation Guide: Quick setup instructions and evidence-based tips for managing cognitive load during whole-class explicit instruction.

✨ KEY FEATURES & BENEFITS

• 🧠 Grounded in Cognitive Load Theory: Built-in strategy options help reduce extraneous cognitive load and maximise retention during high-density instructional blocks.

• ⚡ Tight Lesson Pacing: Track planned minutes versus remaining time automatically to keep structured literacy and numeracy blocks moving smoothly.

• 🔬 Science of Reading & Learning Aligned: Structured specifically for explicit, systematic teaching routines and low-stakes retrieval drills.

• 📱 Multi-Device Ready: Accessible on laptop, desktop, or iPad for real-time lesson execution and co-planning meetings.

• ♾️ 100% Customisable & Reusable: Adapt time slots, instructional pillars, and strategy dropdowns for any learning area or year level.

📂 FILE FORMAT

• Google Sheets (Instant copy link; fully editable, customisable & print-ready)

💡 PLEASE NOTE

• This product is a digital download designed for use with Google Sheets.

• Sample lesson data shown in preview graphics are for illustrative purposes only.