Teacher Resources
Backward Design Framework
Understanding by Design approach for each unit: Start with clear objectives, design authentic assessments, then plan learning experiences.
The Three Stages of Backward Design
- • Essential Questions that drive authentic inquiry
- • Enduring Understandings that transfer beyond the unit
- • Specific Knowledge and Skills needed for proficiency
- • Performance Tasks that mirror real-world applications
- • Authentic Assessments that allow students to demonstrate understanding
- • Success Criteria and Rubrics that define proficiency
- • Knowledge Building activities that provide foundation
- • Skill Development through guided and independent practice
- • Application Opportunities in authentic contexts
Unit-by-Unit Backward Design Analysis
Stage 1: Desired Results
How can we design a self-auditing ledger that would convince a potential angel investor we keep "clean books" from day 1?
• Accurate financial records are the foundation of business credibility
• The accounting equation (Assets = Liabilities + Equity) governs all business transactions
• Self-auditing systems prevent errors and build stakeholder trust
• Professional presentation of financial data communicates competence
Content Knowledge:
- • Apply the accounting equation to real business transactions
- • Record debits and credits accurately for common business activities
- • Generate and interpret a trial balance for error detection
Excel Skills:
- • Create Excel Tables with structured references for dynamic data
- • Use SUMIF functions to aggregate financial data by category
- • Implement conditional formatting for visual error detection
- • Build error-checking formulas for data validation
Stage 2: Assessment Evidence
• Present self-auditing ledger to panel of finance professionals
• Demonstrate error-checking features in real-time
• Explain how the system builds investor confidence
• Answer questions about accuracy and reliability
Milestone 1: Prototype ledger with 10 correctly recorded transactions
Milestone 2: Integrated "red-flag" conditional formatting rules
Milestone 3: Trial balance auto-check formula passes 100% validation
| Criteria | Weight | Proficient Performance |
|---|---|---|
| Accuracy | 45% | All transactions correctly posted; trial balance reconciles perfectly |
| Functionality | 25% | SUMIF formulas and error-checks work reliably on full dataset |
| User Documentation | 15% | Clear instructions enable independent use by non-experts |
| Investor Pitch | 15% | Compelling narrative addresses real investor concerns about financial controls |
Stage 3: Learning Plan
Hook: Founder Q&A about bookkeeping disasters and investor requirements
Foundation: Accounting equation mini-lesson with real business examples
Practice: Journal entry practice with immediate feedback and peer checking
Excel Tables: Guided practice converting CSV data to structured references
SUMIF Functions: Step-by-step building of aggregation formulas
Conditional Formatting: Visual error detection rule creation
Error Checking: Building trial balance validation formulas
Integration: Combining all elements into complete self-auditing system
Testing: Validating system with real transaction data
Presentation: Preparing and delivering investor pitch
Reflection: Analyzing learning and planning next steps
Stage 1: Desired Results
What automation can cut our month-end closing time from two days to two hours without sacrificing GAAP accuracy?
• Automation reduces errors and saves time when properly implemented
• GAAP compliance requires systematic adjusting entries
• Month-end closing follows predictable patterns that can be automated
• User-friendly systems enable adoption by non-technical users
Content Knowledge:
- • Record accruals and deferrals according to GAAP standards
- • Calculate straight-line depreciation for fixed assets
- • Prepare closing entries to zero temporary accounts
Excel Skills:
- • Create and use named ranges for dynamic references
- • Record and edit macros using macro recorder
- • Design user-friendly button controls for automation
- • Write basic VBA procedures (optional extension)
Stage 2: Assessment Evidence
• Demonstrate Month-End Wizard to Innovation Fair visitors
• Complete month-end close in under 2 hours using automation
• Explain efficiency gains and accuracy improvements
• Collect user feedback and implement improvements
Milestone 1: Four adjusting entry scenarios correctly mapped and automated
Milestone 2: Macro successfully inserts closing entries
Milestone 3: Complete system closes books in under 2 hours with UI button
| Criteria | Weight | Proficient Performance |
|---|---|---|
| GAAP Compliance | 40% | All adjusting and closing entries follow GAAP standards |
| Automation Efficiency | 25% | System reduces close time to under 2 hours reliably |
| User Experience | 20% | Interface is intuitive; non-experts can use successfully |
| Innovation & Improvement | 15% | Incorporates user feedback; demonstrates continuous improvement |
Stage 1: Desired Results
How do today's journal entries flow into a narrative of profit, solvency, and cash health that investors can trust?
• Financial statements tell a coherent story about business performance
• Each statement provides a different lens on business health
• Interconnected statements provide validation and deeper insight
• Professional presentation builds stakeholder confidence
Content Knowledge:
- • Construct Income Statement from journal entry data
- • Build linked Balance Sheet with retained earnings reconciliation
- • Prepare Indirect Cash Flow Statement
- • Calculate and interpret key financial ratios
Excel Skills:
- • Cross-sheet linking with INDEX/MATCH functions
- • Dynamic dashboard creation with charts and KPIs
- • Interactive data visualization with sparklines
- • Professional formatting for investor presentation
Stage 2: Assessment Evidence
• Present investor one-pager with integrated financial statements
• Demonstrate interactive Excel workbook with live data connections
• Explain financial story using professional business language
• Answer investor questions about financial health and projections
Milestone 1: Income Statement built with 100% correct formulas
Milestone 2: Balance Sheet linked with retained earnings reconciled
Milestone 3: Cash Flow Statement completed with proper indirect method
Each remaining unit (4-8) follows the same backward design structure:
- Unit 4: Data analysis and forecasting with statistical tools
- Unit 5: Payroll systems and cash flow management
- Unit 6: Pricing optimization and break-even analysis
- Unit 7: Asset management and depreciation systems
- Unit 8: Integrated business model preparation
Curriculum Alignment Check
Each unit builds systematically toward the Semester 2 capstone project:
- Units 1-2: Foundation systems (ledger, automation)
- Units 3-4: Analysis and communication (statements, data analysis)
- Units 5-6: Operations management (payroll, pricing)
- Units 7-8: Strategic planning (assets, integration)
- Semester 2: Independent application in authentic capstone project
Assessment Alignment Matrix
| Unit | Key Assessment | Excel Skills | Business Skills | Capstone Connection |
|---|---|---|---|---|
| 1 | Self-auditing ledger demo | Tables, SUMIF, conditional formatting | Recording transactions, error checking | Foundation for all financial tracking |
| 2 | Month-end automation | Macros, named ranges, UI design | GAAP compliance, process efficiency | Automated systems for capstone model |
| 3 | Investor presentation | Cross-sheet linking, dashboards | Financial statements, ratio analysis | Integrated model for investor pitch |
| 4 | Data-driven recommendations | Statistical analysis, forecasting | Market research, demand planning | Market analysis for business plan |
| 5 | Payroll cash flow model | XLOOKUP, complex calculations | Employment costs, cash timing | Staffing plan and payroll projections |
Implementation Guide for Teachers
- 1. Start with Stage 1: Clarify what students must know and be able to do
- 2. Design Stage 2: Create authentic assessments that mirror real-world applications
- 3. Plan Stage 3: Sequence learning experiences to build toward proficiency
- 4. Check Alignment: Ensure activities directly support assessment success
- 5. Plan Differentiation: Provide multiple pathways to demonstrate understanding
Common Planning Questions
- Knowledge: What facts, concepts, and principles must students learn?
- Skills: What must students be able to do with their knowledge?
- Understanding: What enduring insights should students gain?
- Assessment: How will students demonstrate their learning authentically?
- Instruction: What experiences will prepare students for success?
- • Teaching activities without clear connection to assessments
- • Assessing knowledge without requiring application
- • Focusing on coverage rather than understanding
- • Creating assessments that don't match real-world applications
- • Skipping the reflection and revision cycle