Color Psychology Teacher GuideThe Psychology of Color Unit 2: The Identity Studio | Lesson 11 Standard "I can design brand identities using design principles." Pacing The Hook 7m Mini-Lesson 8m Canva Activity 20m Exit Ticket 5m Key Learning Objectives Identify the emotional associations of primary brand colors (Red, Blue, Yellow). Define Hex Codes and explain their importance in brand consistency. Curate a 3-color palette that aligns with a specific product's "mood." Facilitation Guide I. The Hook: The Gray-Scale Challenge 7 MINUTES Show Slide 3: Famous logos in gray (McDonald's, Starbucks, Facebook, Nickelodeon, UPS). Discussion Questions Does the logo feel the same? How does the "Red" in McDonald's affect your hunger compared to this gray version? Why do banks never use Nickelodeon Orange? The Point Colors aren't just decorations; they are emotional triggers designed to make us feel—and buy. II. Mini-Lesson: Color Theory & Hex Codes 8 MINUTES The Color Psychology Trio: Red: Hunger & Passion Blue: Trust & Intelligence Yellow: Energy & Attention SOFTWARE SKILL: HEX CODES Explain that in business, "Blue" isn't specific enough. Introduce Hex Codes (e.g., #0000FF) as the digital "Social Security Number" for a specific color. Consistency is key across all screens. III. Activity: The Brand Mood Board 20 MINUTES Steps for Students: Open Canva and search "Mood Board" template. Choose 3 colors that match your product's "vibe." Find 3 images that reflect those colors/feelings. Identify and list the 3 Hex Codes for your palette. Teacher Tip Walk around and ask: "Why did you pick that specific shade of green?" vs "Why green?" Encourage technical language. IV. Exit Ticket: The Color Defense 5 MINUTES "What is your primary brand color, and what 'feeling' are you trying to give your customer when they see it?" Submission: Caption on the Canva design.
Color Meaning Cheat SheetThe Color Code Psychology & Marketing Reference Guide Identity Studio Name: 01. The Big Three #FF0000 Red: Action Creates urgency and hunger. High-impact energy. Netflix • Coca-Cola #0047AB Blue: Trust Signals security and calm. Reliable and smart. Facebook • Chase • Intel #FFFF00 Yellow: Energy Radiates optimism and fun. High visibility. IKEA • Nikon • Snapchat 02. Other Moods GREEN: Nature, Growth, Health. PURPLE: Luxury, Royalty, Mystery. ORANGE: Playful, Friendly, Bold. BLACK: Power, Elegance, Modern. Hex Codes: Digital DNA The 6-character code used to define a specific shade. #RRGGBB My Brand Brainstorm 1. Desired Brand "Vibe": 2. Colors & Hex Codes: # ____________ # ____________ Exit Ticket Draft: Color + Feeling choice defense: Designer Rule Don't say "just blue." Say "Navy #000080." Precision is professional. The Identity Studio Lesson 11: Psychology of Color Ref-01
Color Psychology SlidesUnit 2: The Identity Studio The Psychology of Color Lesson 11: Designing Brand Emotions Mission Control Learning Goal "I can design brand identities using design principles." 01 Decode the emotions of color. 02 Master Hex Codes for precision. 03 Build a Brand Mood Board. The Gray-Scale Challenge M Golden Arches f NICK UPS "Does it feel the same? Does it taste the same?" RED #FF0000 Hunger. Urgency. Action. Red is a high-energy trigger. It raises heart rates and stimulates appetite. It's the "Buy Now" color. 🍔 ⚡ 🚀 🚨 BLUE #0047AB Trust. Security. Smart. Blue signals safety and reliability. It's why banks, insurance companies, and big tech brands use it. 🛡️ 🏦 🎓 ☁️ YELLOW #FFFF00 Optimism. Energy. Fun. Yellow is the color of attention and happiness. It’s hard to ignore and creates a cheerful vibe. 💡 ✨ 🧸 😊 Digital Precision Hex Codes Designers never say "just blue." They use Hex Codes—the digital ID for a specific shade. #FF5733 Brand Consistency "Look the same on every screen." The Brand Mood Board 1 Open Canva & search "Mood Board" 2 Pick 3 colors for your Product 3 Find 3 images with that Vibe 4 Find and list your 3 Hex Codes Reference Palette #E11D48 #4F46E5 #0F172A The Color Defense "What is your primary brand color, and what 'feeling' are you trying to give your customer?" Post your answer on your mood board
Typography Teacher GuideTypography & Brand Voice Unit 2: Lesson 12 Standard "I can design brand identities using design principles." Timeline The Hook: Font Swap 7m Mini-Lesson: Type 8m Canva Test 20m Exit Ticket 5m Essential Question "If your brand could talk without using words, what would its voice sound like?" I. The Hook: The Font Swap 7 MIN Display Slide 2: The font mismatch challenge. "The words are correct, but the voice is lying. If you use a horror font for a daycare, parents won't trust you. Typography is the tone of voice for your brand." II. Mini-Lesson: Font Families 8 MIN T Serif: Tradition & Trust "The Feet." Think Banks or Universities. H Sans Serif: Modern & Clean "No Feet." Think Tech or Startups. Design Rule: Two Fonts Max Headline + Body text. Overcrowding fonts creates visual noise and confuses customers. III. Activity: Font Personality Test 20 MIN Students create a "Typeface Sheet" in Canva. They test their brand name in Serif, Sans Serif, and Display styles. Software Skill: Tracking "Show students how to adjust letter spacing. Wide spacing = Luxury; Tight spacing = High Energy." A Note on Standards By the end of this lesson, students should transition from "picking fonts I like" to "making intentional design choices." Focus on the alignment between font voice and color personality.
Typography Cheat SheetThe Font Voice Typography & Brand Personality Identity Studio Designer Name 01. The Three Styles Ab Serif: Traditional Has "feet" at the ends of letters. Established and trustworthy. Ab Sans Serif: Modern "No feet." Clean, geometric, and modern. High-tech vibe. Ab Display: Creative Unique or decorative. Use only for headlines, not body text. The Rule of Two Never use more than two fonts. One for Headline, one for Body. Headline Bold Voice Body Quiet Voice 02. The Vibe Test Tracking (Letter Spacing) PREMIUM Wide: Luxury & Airy INTENSE Tight: Fast & Aggressive Selection Plan: Headline Font: Body Font: Final Defense (Exit Ticket): "Why does this font match the feeling of your colors?" Designer Secret: "A font is like an outfit. It must match the setting of your business." Identity Studio | Lesson 12 © 2026 THE IDENTITY STUDIO Ref-02
Typography SlidesLesson 12: Identity Studio Typography & Voice If your brand could talk, what would it sound like? The Font Swap Challenge Case Study A BABY BOUTIQUE "Would you shop here?" Case Study B slayer "Does this sound loud?" Serif The Traditional Voice "The Feet" Tradition. Authority. Respect. Serif fonts have strokes at the ends of letters. They feel like an established institution, a bank, or a university. Oxford Vogue Sans Serif The Modern Voice "No Feet" Modern. Clean. High-Tech. Sans Serif fonts are geometric and simple. They feel like a modern tech brand, a startup, or a minimalist gym. GOOGLE NIKE The Rule of Two Design is about focus. Limit your brand identity to exactly two fonts. Headline Font BOLD VOICE Body Font Readable Voice Tracking PREMIUM Wide Spacing = Luxury & Airy INTENSE Tight Spacing = High Energy Personality Test 1 Open Canva & create a Typeface Sheet. 2 Type your Brand Name in 3 Styles. 3 Adjust Tracking to find the right vibe. "Does your font sound like your color feels?" The Final Vote "Which font won? Why does it match your color palette's personality?" Bold the winner & delete the losers.
Vector Vision Teacher GuideVector Vision: Shapes & Grouping Unit 2: The Identity Studio | Lesson 13 Standard "I can design brand identities using design principles." Pacing The Hook: Tangram Challenge 6m Mini-Lesson: Tool Basics 9m Logo Re-Construction 20m Exit Ticket: Layers Check 5m The Big Idea "Professional logos aren't 'drawn' with a pencil; they are 'built' with geometry. Vector art ensures clarity at any scale." Vector Art Grouping Layer Order I. The Hook: The Tangram Challenge 6 MIN Action: Display the cat silhouette on Slide 2. Ask: "If you could only use triangles, squares, and circles, how would you build this?" Vectors must be clean. Using geometry ensures perfect scalability from business cards to billboards. II. Mini-Lesson: Google Drawing Basics 9 MIN 01 Transparency: Explain why the checkered background is essential for logo export. 02 Shift Key: Hold Shift to lock aspect ratios for perfect geometry. The "Arrange" Menu Grouping: Ctrl + Alt + G. Locks shapes to move as one unit. Order: "Send to Back" vs "Bring to Front" to manage the stack of shapes. III. Activity: Logo Re-Construction 20 MIN Task: Build Target, Adidas, or Olympic Rings logo using only Shape tools. Target (Circles) Adidas (Bars) Olympics (Rings) Constraint: No "Image Search." Build from scratch. IV. Exit Ticket: The Drag Test "Move your logo across the canvas. Did any piece stay behind? Submit a layer map: which color is in front and which is in back?"
Vector Building Cheat SheetThe Vector Vision Geometry-Based Brand Design Identity Studio Architect: 01. Vector vs. Raster Vectors are built from math. They never get blurry. Raster (Pixels) Vector (Math) 02. Keys & Layers Shift Create Perfect Shapes CTRL+G GROUP: Lock shapes together The Layer Order Shapes are stacked papers. Use Arrange > Order to move them. 03. The Logo Build Selection & Planning 1. Brand to Build: Target, Adidas, Olympics... 2. Shape Inventory: SHAPE: SHAPE: SHAPE: Exit Ticket Draft: Explain the layer order (which is in front?). Pro Tip: "If you click and pieces stay behind, you forgot to GROUP." The Identity Studio Lesson 13: Vector Vision Ref-03
Vector Vision SlidesLesson 13: Identity Studio Vector Vision Design isn't drawing. Design is building. The Tangram Challenge How would you build this? If you could only use Triangles, Squares, and Circles... "Vector art is finding complex meaning in simple geometry." The Vector Rule We don't DRAW We BUILD Using shapes makes your brand Scaleable—perfect at any size. 01. The Canvas LOGO The "Checkered" Background means Transparency. This allows your logo to sit on top of photos or colored websites without a "white box" around it. Always keep it transparent The SHIFT Key Hold Shift while drawing to lock your aspect ratio. Without Shift "Squashed & Stretched" With Shift "Perfect Geometry" 02. Arrange & Order Grouping (Ctrl + Alt + G) Locks your shapes together so they move as One Unit. Order (Back & Front) Geometry is a stack of paper. You can Bring to Front. Logo Re-Construction 1 Open Google Drawing & name it "Logo Build." 2 Pick: Target, Adidas, or Olympics. 3 Build it from scratch using only Shapes. 🚫 NO IMAGE SEARCH Build it. Don't copy it. The Drag Test "Drag your logo across the screen. Did any shapes stay behind?" Explain your layers (Back to Front) in the submission box.
Custom Shapes Teacher GuideLines, Curves & Custom Shapes Unit 2: The Identity Studio | Lesson 14 Standard Vector Creation Pacing Hook: Zoom Challenge 7m Mini-Lesson: Custom Paths 8m Abstract Icon Sprint 20m Exit Ticket: Download 5m Objective "I can design original icons using the Polyline and Curve tools, applying line weight for emphasis and exporting for transparency." Polyline Line Weight PNG vs JPG I. The Hook: Zoom Challenge 7 MIN Show Slide 2: Compare a Raster Star vs. a Vector Star zoomed 500%. "Why do we build logos as vectors? Because they must look perfect on a business card AND a billboard. Pixels die when stretched; math is forever." II. Mini-Lesson: Polyline & Weight 8 MIN Path Tools Polyline: Click points to create jagged edges. Curve: Place anchors for organic flow. Close the loop to fill. Emphasis Change Line Weight to 4px+ for impact. Use Dash styles for extra detail. III. Activity: Icon Sprint 20 MIN Students must create an Original Icon representing their product idea using a custom Polyline shape and Hex codes. Focus on the 'Icon'—a single representative symbol. This isn't the final logo with text yet; it's the brand symbol. IV. Exit Ticket: PNG Rule "Download as PNG. Why? JPEGs force a white background. PNGs keep our icons floating and transparent. Every pro logo is a PNG."
Custom Shapes Cheat SheetThe Custom Path Beyond Circles & Squares Ref-04 Drafted By: 01. Tool Mastery The Polyline Tool Create jagged, geometric, or sharp-edged shapes. Great for: Lightning, Mountains, Diamonds. Pro Tip "Close the loop" to fill. The Curve Tool Create fluid, organic, and flowing paths. Great for: Waves, Smoke, Clouds, Liquid. Pro Tip Click points to flow. 02. Line Weight (Emphasis) 1px 4px 8px "Changing line weight changes the 'shout' of the shape." 03. Abstract Icon Sprint Icon Concept Brainstorm My Product Idea: Name your brand's product here... Sketch Your Concept: Rough sketch of icon symbol Technical Checklist: Polyline Shape Weight >= 4px L11 Palette Grouped File Format Comparison: JPEG Solid BG PNG Transparent Identity Studio | Lesson 14 © 2026 THE IDENTITY STUDIO Ref-04
Custom Shapes SlidesLesson 14: Identity Studio Custom Shapes Creating the icons that tell your story. The Zoom Challenge RASTER (Pixels) "Blurry & Blocky" VECTOR (Math) "Perfectly Sharp" "Zoom in 500%—Which one would you put on a billboard?" The Polyline For Custom Jagged Shapes. Click to place points. The tool draws a straight line between every click. Close the path to fill it with color. Perfect for: Lightning bolts, mountains, jagged crowns, and geometric logos. The Curve Tool For Organic Flowing Shapes. Click to place 'anchors.' The computer calculates a smooth path through them. Perfect for liquid or natural looks. Perfect for: Waves, clouds, hair, fire, and smooth brand symbols. Line Weight Weight = Emphasis. It's how your brand speaks. 1px Whisper 4px Clear 12px Shout Abstract Icon Sprint 1 Build an original Icon that represents your product idea. 2 Requirement: Use the Polyline Tool for 1 custom shape. 3 Requirement: Set a 4px+ Border on one shape. 🎨 Palette Check Use your Hex Codes from Lesson 11! The Transparency Rule File > Download > PNG Image "Why did we choose PNG instead of JPEG? What did you notice about the background?"
Logo Construction Teacher GuideLogo Construction: The Draft Unit 2: The Identity Studio | Lesson 15 Standard Focus "I can design brand identities using design principles." Timeline The Hook: 60s Sketch 6m Mini-Lesson: Anatomy 9m Building the Draft 20m Exit Ticket: Squint Test 5m Lesson Goal "Combine your custom icon and brand typography into a single, balanced logo draft that feels like a cohesive brand identity." Alignment Logotype Balance I. THE HOOK: 60-Second Sketch 6 MIN Action: Students have 60 seconds to draw 3 thumbnails. Don't think, just move the hand. Speed prevents the "Inner Critic" from stopping the best ideas before they are born. II. MINI-LESSON: Logo Anatomy & Balance 9 MIN The Symbol: The icon from Lesson 14. The Logotype: The brand name in the font from Lesson 12. Balance: Explain Centered vs. Side-by-Side. Ensure the symbol and text feel unified. Software Skill: Alignment Guides Demonstrate the Red "Snap-To" Lines in Google Drawing. "Alignment is the difference between a professional brand and a mess." III. ACTIVITY: Building the Master Draft 20 MIN Requirements: Import Icon + Choose Brand Font. Apply Unit 2 Palette Hex Codes. Align Perfectly Using Arrange > Align. IV. EXIT TICKET: The Squint Test 5 MIN "Squint until everything is blurry. Is the logo still distinct? If not, simplify. High complexity equals low memorability."
Logo Construction Cheat SheetLogo Construction Asset Integration & Alignment Ref-05 Designer: 01. 60-Second Challenge Don't think. Draw 3 variations NOW. Idea 01 Idea 02 Idea 03 02. Design Principles Symbol + Logotype Combine your Icon (L14) and your Brand Font (L12). Master Skill: Alignment Use the Red Guide Lines to center your icon over your text. The Squint Test If the shape disappears when you squint, it's too complex. "My logo shape looks like..." Pro Tip: Keep it simple. Scalability is the key to a professional brand asset. Identity Studio | Lesson 15 Ref-05
Logo Construction SlidesLesson 15: Identity Studio Logo Drafting Bringing the brand pieces together. The 60-Second Sketch 00:60 Idea 01 Idea 02 Idea 03 "Don't stop at your first thought. The fourth idea is usually the winner." The Anatomy of a Logo 01. The Symbol The icon that makes the brand recognizable without text. Aa 02. The Logotype The brand name in a specific, chosen typeface. BRAND Cohesive Identity The Red Guides Snap-Centered Trust the Snap. Use red lines to center your icon over your text. Symmetry signals professionalism. Quality Control The Squint Test "Squint until the screen is a blur. Is your logo still recognizable?" Distinct shape = Memorability. Draft v1 Complete Final Step Ref-05 Import Icon + Chosen Font Align Center Perfectly Name: Logo_Draft_v1
Logo Refinement Teacher GuideLogo Refinement & Iteration Unit 2: The Identity Studio | Lesson 16 Lesson Phase Polishing & Export Timeline Hook: Simple Apple 6m Mini-Lesson: Negative Space 9m Final Polish Activity 20m Exit Ticket: Export 5m Focus Standard "Refine a design through iteration, focusing on simplicity, contrast, and technical requirements for print and digital media." Negative Space Drop Shadow Contrast I. HOOK: The Power of Simple 6 MIN Display Slide 2: Apple Logo Evolution. Isaac Newton in a woodcut (1976) vs. The Silhouette (Today). Discussion: "Which one looks better on a billboard? Which one works on a tiny iPhone screen?" Simplification is professionalization. II. MINI-LESSON: Space & Formatting 9 MIN Negative Space: Ensure the icon has "breathing room." It shouldn't feel crowded by the edge of the canvas or the text. High Contrast: Create a Solid Black version. If the logo doesn't work in one color, the geometry isn't strong enough. Software Skill: Format Options Demonstrate Drop Shadows for depth and Reflection for a glossy feel. "Design is 90% subtraction. Remove the clutter." III. ACTIVITY: The Final Polish 20 MIN Canvas Setup Shrink the canvas size (Page Setup) to fit the logo tightly. No wasted space. Double Testing Verify all elements are Grouped. Create a black/white alternative version. IV. EXIT TICKET: Pro Export "Download as PNG for web and PDF for print. Explain: Why does a t-shirt printer need the PDF instead of the PNG?"
Logo Refinement Cheat SheetThe Final Polish Refinement, Contrast & Export Final Step Ref-06 Brand Lead: 01. Iteration Checklist Simplify the Shape Remove unnecessary details. Can it work as a tiny app icon? Negative Space Check Does the logo have "breathing room"? Is it crowded? Grouping Test Drag the logo. Does every piece stay together? 02. Software Power-Ups Drop Shadow Adds depth Reflection Tech / Modern Page Setup Trim the fat 03. The Export Rule Format Defense The PNG File Used for: Websites, Instagram, Apps. Advantage: Transparency. The PDF File Used for: T-Shirts, Billboards, Business Cards. Advantage: Scaleable Printing. Exit Ticket Self-Check: Why did you use contrast in your final design? "Your brand is now official. A great logo doesn't just look cool; it functions as a technical asset ready for the real world." Identity Studio | Final Refinement © 2026 THE IDENTITY STUDIO Ref-06
Logo Refinement SlidesLesson 16: Identity Studio Refinement & Iteration Professional design is never finished on the first try. The Power of Simple 1976 (The Original) Isaac Newton Under an Apple Tree Too Complex Today (The Icon) Perfectly Simple "Which one fits on a tiny iPhone app button?" Negative Space Room to Breathe. Negative space is the area around your logo. It shouldn't feel accidental. Great logos use empty space to guide the eye. "The silence between the notes is part of the music." The Power-Ups Drop Shadow Add Depth and Emphasis. It makes the logo pop off the page. Reflection Creates a high-end, Glossy, or Modern Tech feel. Use sparingly. The Export Rule .PNG The Web King For Apps, Social Media, and Websites. (Supports Transparency) .PDF The Print King For T-Shirts, Posters, and Billboards. (Highest Resolution) The Final Polish 1 Create a Solid Black version to test contrast. 2 Resize your Canvas to fit the logo perfectly. 3 Download as PNG and PDF. Mission Complete Unit 2 Brand Identity Prototype Finished.
Canva Assembly Teacher GuideCanva: The Assembly Line Unit 2: The Identity Studio | Lesson 17 Standard Focus "I can use digital tools to design marketing campaigns." Pacing Hook: Template vs Original 6m Mini-Lesson: The Interface 9m Mood Board Assembly 20m Exit Ticket: Alignment 5m The Big Shift "Google Drawing is for building components. Canva is for assembling the message. Today, we break the template to build the brand." Asset Management Layout Design Unity I. The Hook: Template vs. Originality 6 MIN Show Slide 2: Generic vs. Custom design comparison. Discussion: "Templates are a starting line. If you don't change the colors and images, your business looks like everyone else. How do we make it ours?" II. Mini-Lesson: The Assembly Tools 9 MIN The Sidebar: Differentiate Elements (graphics) vs. Uploads (custom artwork). Frames: Containers that clip images into shapes (circles, letters). Locking: Fix background elements so they don't shift during design. Tool Focus: Position "Precision over Guesswork." Demonstrate the Position > Align menu to find the mathematical center of the page. III. Activity: The Mood Board Assembly 20 MIN Workflow: 01. Purge Delete all default photos and generic template colors. 02. Match Upload logo. Use the Eye Dropper to grab hex codes. 03. Vibe Find 3 "Aesthetic Photos" that represent your product vibe. IV. Exit Ticket: Alignment Check 5 MIN "Does it feel unified? What one element ties the whole board together?" Students submit their 'View Only' link to the LMS.
Canva Assembly Cheat SheetThe Assembly Line Intro to Canva: Layout & Unity Ref-07 Brand Manager: 01. Interface Tour Upload Tool Bring in your Google Drawing PNGs. Frames Drag photos into these to auto-clip. Locking Freeze your background so it stays put. The Eye Dropper Rule Consistency = Professionalism. Never guess your colors. Select an object > Click Color Box > Click "+" > Use Eyedropper on your Logo. Principle: Unity Unity is the design principle that makes all parts of a layout feel like they belong together. If your logo is "Modern/Tech," don't use photos of "Vintage/Rustic" woods. 02. Mood Board Blueprint Assembly Checklist Search "Brand Board" Purge all default photos Upload official logo PNG Match 3 Color Swatches Find 3 "Vibe" Photos Alignment Check (Exit Ticket): What is one element that ties your logo and images together? "The common element is..." Pro Tip: Template images are boring. Use your own "Aesthetic" search terms in Canva to find better photos. Identity Studio | Lesson 17 Ref-07
Canva Assembly SlidesLesson 17: Identity Studio Canva Assembly Moving from components to layout. The Template Trap Used by 5,000+ Stores Generic Template Boring & Forgettable 100% Unique Custom Brand The "Real" Business "Templates are a starting line, not a finish line." The Assembler's Toolbox Upload Bring your Google Drawing PNG icons and logos into the mix. Frames Containers that clip photos into circles, letters, or custom shapes. Locking Freeze elements so they don't move while you're adjusting details. Precision Alignment Canva Menu Position Never "eyeball" the center. Use the align tools to make it perfect. Top Middle CENTER The Build 1 Select a "Brand Board" template. 2 The Purge: Delete every photo and generic color. 3 The Assembly: Upload logo and pick your palette. Find the Vibe Search for 3 "Aesthetic Photos" that tell your brand's story. Alignment Check "Does it look like the same company? What ties the board and logo together?" Submit your "View Only" Link
Style Guide Teacher GuideThe Brand Style Guide: Layout Unit 2: The Identity Studio | Lesson 18 Standard Design & Documentation Pacing Hook: Brand Police 6m Mini-Lesson: Anatomy 9m Framework Activity 20m Exit Ticket: Consistency 5m The Mission "A brand is only as strong as its rulebook. Today, you create the document that ensures your brand always looks professional, no matter who is using it." Consistency Documentation Clear Space I. THE HOOK: The Brand Police 6 MIN Action: Show the Distorted Coca-Cola slide (Slide 2). Discussion: "Is this still the same company? Why do we lose trust when a logo is stretched or changed? Companies employ 'Brand Police' to ensure their identity is never disrespected. Professionalism is about consistency." II. MINI-LESSON: Anatomy of a Guide 9 MIN Clear Space: The "No-Go Zone." Explain that logos need breathing room to stand out. Don't crowd it with text. Color Hierarchy: Documenting Primary vs. Secondary Hex Codes. No guessing allowed. Typography Pairing: Formalizing which font is for big headlines and which is for easy-to-read body text. Canva Skill: Rulers & Guides "Alignment is invisible architecture." Show Shift+R to reveal rulers. Drag lines from the sidebar to create custom alignment grids. This ensures text boxes align perfectly across the document. III. ACTIVITY: Style Guide Framework 20 MIN Framework Requirements: Logo: Placed at the top with "Clear Space" margin. Palette: 3 squares filled with brand colors + typed Hex Codes. Type: Headline (Brand Font) + Paragraph (Body Font) sample. Alignment: Use Rulers (Shift+R) to align text labels. IV. EXIT TICKET: The Consistency Check 5 MIN "Look at your Logo file and your Style Guide side-by-side. If you gave this rulebook to a stranger in another country, could they build an ad that looks exactly like your brand?"
Style Guide Cheat SheetBrand Rulebook Documentation & Style Standards Ref-08 Drafted By: _________________________ 01. Elements of a Guide Clear Space The "No-Go Zone" around your logo. It ensures the brand has room to breathe and stand out. Rule: Never crowd the logo. The Palette Specify the exact Hex codes from Lesson 11. Consistency across digital and print is non-negotiable. Type Standards Identify your Headline font (Big/Bold) and Body font (Readable). Limit yourself to two max. Canva Skill: Shift + R Hold Shift+R to show rulers. Drag guide lines from the side to align your content perfectly. Professionalism is in the pixels. 02. Assembly Checklist Style Guide Requirements Logo Centered at Top 3 Color Swatches + Hex Codes Heading Sample (Brand Font) Body Sample (Simple Font) Consistency Check (Exit Ticket): If a stranger followed this guide, would they recreate your brand exactly? Why? The Brand Police: "A style guide isn't just a document; it's a defensive weapon. It protects your brand from looking cheap or messy." Identity Studio | Lesson 18 © 2026 THE IDENTITY STUDIO Ref-08
Style Guide SlidesLesson 18: Identity Studio The Style Guide Creating the rules for your brand. The Brand Police CRIME SCENE Illegal Usage Coca-Cola Distorted & Wrong AUTHORIZED Professional Standards Coca-Cola Balanced & Trustworthy "If you change the rules, you lose the trust." The Rulebook Components Aa Typography Defining the Headline vs. Body font pairing. Colors Documenting the exact Hex codes. No guessing. Clear Space Establishing the "Breathing Room" around the logo. Software Skill: Precision Canva Shortcut Shift + R "Rulers and guides ensure your rulebook looks as professional as your brand." 0 100 0 100 The Framework Build 1 Logo: Place at the very top (Centered). 2 Palette: 3 squares with exact Hex Codes. 3 Typography: Sample Headline + Body text. Professional Grade Use Shift+R to ensure every box is perfectly aligned. The Rule Test "If I gave this Style Guide to a stranger, could they recreate your brand exactly?" Save as: Style_Guide_Draft
Visual Voice Teacher GuideVisual Voice & Tone Unit 2: The Identity Studio | Lesson 19 Phase Final Documentation Pacing Hook: Brand Talk 6m Mini-Lesson: Imagery 9m Activity: Final Page 20m Exit Ticket: Export 5m Key Objective "Identify a target audience and define a brand voice through curated, filtered imagery that communicates personality before words." Tone of Voice Repetition Unity I. THE HOOK: If This Brand Could Talk 6 MIN Action: Show Disney vs. Tesla (Slide 2). Disney Persona: Magic, kindness, childlike wonder. They speak with exclamation marks and warm colors. Tesla Persona: Futuristic, genius, serious. They speak with silence, sharp lines, and cold metallics. "Every image you pick is a word in your brand's sentence." II. MINI-LESSON: Imagery & Filtering 9 MIN Photography Style: Discuss "Mood." Is it Bright/Sunny (Happy/Open) or Moody/Shadowy (Luxury/Mystery)? Repetition: Using the same colors or styles over and over builds Brand Equity. It makes the brand recognizable instantly. Canva Skill: Image Filtering Show Edit Image > Adjust. "Select one photo, set the brightness and tint, then copy those numbers to the other 3 photos so they look like a matching set." III. ACTIVITY: Completing the Guide 20 MIN Page 2 Requirements: Title: "Brand Mood & Imagery" Curation: 4 high-quality photos from Canva library. Consistency: Apply the same filters/tint to all 4. Voice: List 3 "Brand Keywords" (e.g., Bold, Friendly, High-Tech). IV. EXIT TICKET: The Export 5 MIN Students export the full 2-page guide as PDF Standard. Prompt: "Which of your 4 photos is the absolute HERO image for your brand? Why?"
Visual Voice Cheat SheetVisual Voice Imagery Standards & Brand Personality Ref-09 Creative Director: _________________________ 01. Defining the Tone Brand Adjectives Circle 3 words that describe how your brand "speaks" to customers: Bold Playful Serious Kind Calm Elite Fast Natural Genius Canva Skill: Consistency To make your photos look like a set, use Adjust settings. Apply the same Brightness, Contrast, and Saturation to every image. OK 02. Page 2 Blueprint Imagery Requirements Title: Brand Mood & Imagery 4 Photos (Matching Set) 3 Brand Keywords documented The Hero Image (Exit Ticket): Which photo best represents your customer's needs? Why? Final Export: "Download your full Style Guide as a PDF Standard. This is your brand's formal identity document." Identity Studio | Final Component © 2026 THE IDENTITY STUDIO Ref-09
Visual Voice SlidesLesson 19: Identity Studio Visual Voice "It's not what you say, it's how you look saying it." Brand Personas Disney "Magical, Kind, Playful" Bright colors, warm lighting, round fonts. Tesla "Genius, Future, Serious" Deep shadows, sharp metal, simple lines. "If your brand was a person, how would they speak?" Imagery & Mood ☀️ Sunny/Warm Optimism & Health 🌑 Moody/Cold Luxury & Mystery 🌓 High Contrast Drama & Power Minimalist Efficiency & Calm Mood is intentional. Consistency in photography creates a rhythm. It makes your brand feel reliable and "premium." Rule: Don't just pick 'nice' photos. Pick 'ON-BRAND' photos. Skill: The Matching Set Canva Step Filters "Apply the same Tint or Filter to all your photos so they look like they belong to the same world." 🌲 Tint: Indigo 40% ⛰️ Tint: Indigo 40% Completing the Guide 1 Add Page 2: Title it "Brand Mood & Imagery." 2 Curation: Find 4 photos that match your vibe. 3 Keywords: List 3 adjectives that describe your voice. The Last Step Export your full Style Guide as a PDF Standard. The Hero Shot "Which photo on your page is the most 'on-brand'? How does it meet your customer's needs?" Submit your PDF to the class folder.
Visual Hierarchy Teacher GuideVisual Hierarchy: Leading the Eye Unit 2: The Identity Studio | Lesson 20 Design Principle Hierarchy & Contrast Pacing Hook: Read This First 6m Mini-Lesson: Hierarchy 9m Brand One-Pager 20m Exit Ticket: 3s Rule 5m The Mission "Visual hierarchy is the map you give a customer’s eyes. If everything is loud, nothing is heard. Learn to lead the eye to your most important message." The Rule of Three Color Contrast Hero Imagery I. THE HOOK: Read This First 6 MIN Action: Show Slide 2. A design with four sentences of varying sizes. Discussion: "Did you have a choice in which one you read first? No. The design forced you. That force is Hierarchy. In business, you must force the customer to look at your brand name before they look at the fine print." II. MINI-LESSON: Size & Contrast 9 MIN The Rule of Three: Title (Dominant), Subtitle (Support), Body (Detail). Use font size to create a 1, 2, 3 path for the eye. Emphasis: Use Weight (Bold) and Color to highlight the Call to Action (the button or brand name). Canva Skill: Tidy Up "Rhythm is repetition with spacing." Demonstrate the Position > Tidy Up feature. This mathematically spaces a group of objects so the "Negative Space" between them is perfectly equal. III. ACTIVITY: The Brand One-Pager 20 MIN Snapshot Requirements: Logo Positioning: Place in a "Power Position" (Top Center or Top Left). Hero Image: Use your best photo from L19. It should cover 40%+ of the page. Color Contrast: Use your primary brand color to highlight the product name. Typography: Headline (Brand Font) vs Paragraph (Body Font). IV. EXIT TICKET: The 3-Second Rule 5 MIN "Show your design to a neighbor for 3 seconds, then hide it. Ask: 'What was the company name?' If they can't answer, your hierarchy is broken. Fix it before submitting."
Visual Hierarchy Cheat SheetThe Visual Map Hierarchy, Size & Eye Movement Ref-10 Layout Specialist: _________________________ 01. The Levels of Attention The Rule of Three 01 Primary: The Brand Largest Size / Highest Contrast 02 Secondary: The Headline Medium Size / Supporting Font 03 Tertiary: The Details Smallest Size / Body Text Emphasis Tools Use Scale (Bigger), Color (Brighter), and Position (Higher) to signal importance. If everything is the same size, the customer is confused. Canva Skill: Tidy Up Select a group of icons or text boxes. Click Position > Tidy Up. Canva will automatically create equal spacing between them. 02. Brand One-Pager Blueprint Layout Checklist Position of Power: Where is your logo sitting? (Top Left / Top Center) The Hero Shot: Describe the image taking up 40% of your page: The 3-Second Rule (Exit Ticket): When you show a neighbor for 3 seconds, what is the first thing they said they saw? "Visual hierarchy is respect. You are respecting the customer's time by telling them exactly what is most important to look at." Identity Studio | Lesson 20 Ref-10
Visual Hierarchy SlidesLesson 20: Identity Studio Visual Hierarchy "Design is the silent director of the eye." The Eye Magnet You are probably reading this last. Then you read this one. Read this first! Then this. "Hierarchy isn't random. It is calculated force." Hierarchy is a Map It tells the customer where to go, what to think, and where to click. If everything is loud, nothing is heard. The Rule of Three 01. DOMINANT The Title. The Logo. The biggest contrast. 02. Supporting The Headline. The Vibe. Medium weight. 03. Details The Fine Print. Descriptions. Smallest size. #01 #02 #03 Skill: Perfect Spacing Canva Step Tidy Up "Don't guess the distance. Let the software do the math." Position > Tidy Up Mathematically Perfect Rhythm. The Brand One-Pager 1 Place Logo in a position of power. 2 Insert Hero Image (covers 40%+ of page). 3 Write Headline in Brand Font. Focus on Order Make the Brand Name the most visible text on the whole page. The 3-Second Rule "Show a neighbor your screen for exactly 3 seconds. Ask: 'What was the company name?'" If they don't know, your hierarchy needs work.
Identity Gallery Teacher GuideThe Identity Gallery: Critique Unit 2: The Identity Studio | Lesson 21 Unit Finale Critique & Refinement Pacing Hook: Professional Review 5m Mini-Lesson: Glows & Grows 5m Digital Gallery Walk 25m Exit Ticket: The Pivot 5m Standard Alignment "I can critique and refine my work based on design principles and professional feedback, demonstrating effective communication and digital citizenship." I. THE HOOK: The Boardroom 5 MIN Explain that at companies like Apple or Nike, nothing is ever released without a "Review Board." Designers must defend their choices to directors before a single penny is spent on marketing. "Critique isn't about hurting feelings; it's about polishing the brand until it shines. We are checking for Unity and Hierarchy today." II. MINI-LESSON: Glows & Grows 5 MIN Teach the Feedback Language: The Glow (What works) "The contrast between your logo and the hero image is very strong; it grabs my eye instantly." The Grow (Improvement) "The font in your body text is a bit hard to read at this size. Maybe try a simpler Sans Serif?" III. ACTIVITY: Digital Gallery Walk 25 MIN The Walk (15m) Students leave L19 (Style Guide) and L20 (One-Pager) open. Rotate to 5 stations (3 mins each). Leave one Glow and one Grow for each peer. The Refinement (10m) Return to your own seat. Read your peer feedback. Make one specific change to your design based on a suggestion. IV. EXIT TICKET: The Final Pivot 5 MIN "What was the most helpful piece of feedback you received today? How did you change your design to fix it?" Next Unit: Unit 3 - Target Audience Numbers & Spreadsheets!
Critique Feedback FormCritique Card The Identity Studio | Gallery Walk Reviewer ID Name: Station #1 (Peer Name): ___________________ GLOW GROW One thing that is working... One specific change to try... Station #2 (Peer Name): ___________________ GLOW GROW Placeholder Placeholder Station #3 (Peer Name): ___________________ GLOW GROW Placeholder Placeholder Station #4 (Peer Name): ___________________ GLOW GROW Placeholder Placeholder Station #5 (Peer Name): ___________________ GLOW GROW Placeholder Placeholder The Final Pivot (Self-Reflection) Which piece of feedback did you apply? How did it improve your brand? Identity Studio | Final Assessment Ref-11
Identity Gallery SlidesLesson 21: Identity Studio The Identity Gallery "Design is a conversation, not a monologue." The Boardroom Review Industry Standard No brand is launched in a bubble. At companies like Apple or Nike, designers present their work to a board of directors for feedback before a single t-shirt is printed. The Gallery Walk YOU ARE THE BOARD TODAY Constructive Language The GLOW "I love how your primary color creates high contrast with your background." The GROW "Your font size is a bit small. Could you increase it to 14px to lead the eye better?" Gallery Protocol 1 Leave your Style Guide & One-Pager open. 2 Rotate to 5 different stations when the bell rings. 3 Provide 1 Glow and 1 Grow for each peer. Focus Standards Color Font Hierarchy The Final Pivot "Return to your seat. Read your feedback. Make ONE specific change to your design." Iteration is the heart of design. Unit 2 Complete Finalize your Portfolio Folder. Next Up: Unit 3 - Target Numbers
Market Analyst Teacher Guide 22Lesson 22: Demographic vs. Psychographic Unit 3: The Market Analyst Standard Target Audience & Marketing Influence Pacing Hook: Tale of Two Shoes 7m Mini-Lesson: The Pillars 8m User Persona Activity 20m Exit Ticket: Anti-Customer 5m Analyst Objective "Shift from the 'art' of branding to the 'science' of data. Define who your customer is on the outside (facts) and who they are on the inside (values)." I. THE HOOK: The Tale of Two Shoes 7 MIN Action: Show the Neon Runner vs. Leather Loafer (Slide 3). Discussion: "Both shoes solve the same problem: protection for your feet. Do the same people buy them? Why does a 70-year-old CEO buy the loafer while a 19-year-old athlete buys the neon runner?" The Point: To sell, you must know what people ARE (facts) and what they FEEL (values). II. MINI-LESSON: The Two Pillars 8 MIN 1. Demographics (The Outside) Facts you can see or measure: Age, Gender, Location, Income. 2. Psychographics (The Inside) Internal traits: Habits, Hobbies, Values, and Fears. Business Logic Case Study "A high-end yoga mat targets women ages 25-45 (Demo) who value sustainability and stress-relief (Psycho)." III. ACTIVITY: User Persona Builder 20 MIN Task: Create a "Target Profile" in a Word Doc. Demos: List 3 quantifiable facts about the ideal customer. Psychos: List 3 interests or "pain points." The Match: Write 2 sentences explaining why the Unit 2 Colors/Fonts appeal to this specific person. IV. EXIT TICKET: The Anti-Customer "Who is one person who would NEVER buy your product? Why? (e.g. Someone who hates technology, someone who lives in a cold climate, etc.)"
User Persona Builder SheetFile No. 22-A Target Persona Market Analysis Profile Confidential Analyst Name: 01. Demographics (External) List 3 measurable facts about your ideal customer (Age, Income, Location, etc.) A. B. C. 02. Psychographics (Internal) List 3 interests, habits, values, or "pain points" (fears/needs). A. B. C. 03. Brand Match Defense Explain why your Brand Colors & Fonts appeal to this person: Sentence 1 (Color)... Sentence 2 (Typography)... 04. The Anti-Customer Who would NEVER buy this? Why? Analyst Rule "Marketing isn't guessing. It is looking at the internal and external data of a human being to find the exact point of influence." Unit 3: The Market Analyst © 2026 THE IDENTITY STUDIO Dossier-01
Market Analyst Slides 22Unit 3: The Market Analyst Who Is Listening? Lesson 22: Demographic vs. Psychographic The Tale of Two Shoes 🏃♂️ Neon Runner Built for speed, sweat, and street style. 👞 Leather Loafer Built for meetings, dinner, and tradition. "Both solve the problem of walking. But do the same people buy them?" The Big Secret To sell a product, you have to know more than what people ARE. You have to know what they FEEL. 01. Demographics The Outside Measurable facts you can see or record in a spreadsheet. Age Location Gender Income 02. Psychographics The Inside The mental traits, values, and lifestyle choices of your audience. Habits Hobbies Values Fears Persona Builder 1 List 3 measurable Demographics. 2 List 3 internal Psychographics. 3 Defend: Explain why your colors/fonts appeal to them. User Dossier Create a "Target Profile" for your product. Software: Word Processor The Anti-Customer "Who is one person who would NEVER buy your product? Why?" Document this at the bottom of your Persona Doc.
Spreadsheet Basics Teacher Guide 23Lesson 23: Spreadsheet Basics Unit 3: The Market Analyst Lesson Type Software Literacy: Data Entry Pacing Hook: Jellybean Challenge 6m Mini-Lesson: Navigation 9m Activity: Market Survey 20m Exit Ticket: Address Test 5m Focus Standard "I can use digital tools (spreadsheets) to organize and compare market data, ensuring brand consistency in technical documents." I. THE HOOK: The Jellybean Challenge 6 MIN Action: Show the massive jellybean jar (Slide 2). Discussion Question: "How long would it take you to count these, categorize them by color, and find the average per color by hand? Would you make a mistake?" The Point: Humans are slow and error-prone with large numbers. Spreadsheets are perfect. Data is just "Business Jellybeans." II. MINI-LESSON: Anatomy of the Grid 9 MIN The Address: Every cell has a unique name (e.g., B4). Use the Battleship analogy: Column Letter first, then Row Number. Columns vs. Rows: Columns are vertical (Skyline); Rows are horizontal (Horizon). Analyst Skill: Formatting Auto-fit: Double-click the line between Column A and B to fit text. Fill Color: Match header background to Unit 2 Brand Colors. III. ACTIVITY: Classroom Market Survey 20 MIN Setup a "Sentiment Table" in Google Sheets: Column A 5 Classmate Names Column B Rating (1-10) Column C Buy? (Yes/No) Constraint: Headers (A1:C1) must use your Brand Colors and be BOLD. IV. EXIT TICKET: The Address Test "What is the cell address of the very last piece of data you entered? Why is it important to keep data in specific cells?"
Spreadsheet Basics Cheat Sheet 23Technical Training The Data Grid Spreadsheet Navigation & Formatting Software: Sheets / Excel Analyst: 01. Anatomy A B C 1 2 B2 The Address Column Letter + Row Number. Like Battleship. Columns (Letters) Vertical Pillars of data. Rows (Numbers) Horizontal slices. Software Power-Ups Auto-Fit Content DOUBLE-CLICK EDGE Highlight Rows CLICK ROW NUMBER Force Line Break ALT + ENTER 02. Lab Activity Sentiment Table Checklist 1. Setup Rows Name Rating Buy? 2. Styling Standards Bold Header (Row 1). Set Fill Color to Brand Primary. Use High Contrast text colors. Exit Ticket Check: What is the address of your last entered cell? Why is location important in spreadsheets? "Precision data leads to smart marketing. Be specific with your cells." Market Analyst | Lesson 23 © 2026 THE IDENTITY STUDIO Ref-12
Market Analyst Slides 23Unit 3: The Market Analyst The Data Grid Lesson 23: Spreadsheet Basics The Jellybean Challenge 🫙 Could you count these by hand? Categorize by color? Find the average weight? How long would it take before you made a mistake? In marketing, data is our "Jellybeans." 01. The Address Battleship Logic Every single cell in a spreadsheet has a name. You must know the Address to find the data. B4 COLUMN + ROW The Perfect Intersection A B C 1 Columns & Rows Columns Vertical (Up & Down). Labeled with LETTERS. The Skyline Pillars Rows Horizontal (Side to Side). Labeled with NUMBERS. The Horizon Lines Skill: Professional Prep Pro Step Auto-Fit "Don't let your data be cut off. Double-click the line between columns." Classmate Name... Double Click Here Resize for Readability. Classroom Market Survey 1 Column A: List 5 classmate names. 2 Column B: Ask them to rate your product (1-10). 3 Column C: "Yes/No" if they would buy it. Brand Consistency Make your Header Row match your Unit 2 Colors! The Cell Test What is the address of the very last piece of data you entered? Why is precise location important in spreadsheets?
Survey Design Teacher Guide 24Lesson 24: Professional Survey Design Unit 3: The Market Analyst Analyst Goal Gathering "Clean" Intelligence Pacing Hook: The Biased Question 6m Mini-Lesson: Data Types 9m Market Research Activity 20m Exit Ticket: Link Share 5m Standard Focus "I can identify a target audience and design neutral research tools to gather actionable market intelligence." I. THE HOOK: The Biased Question 6 MIN Action: Ask the class a "Leading" question. Prompt: "Don't you think my new super-awesome sneakers are better than those boring ones over there?" The Point: Biased questions make people tell you what you WANT to hear, not what is TRUE. Analysts need "Clean Data." II. MINI-LESSON: Quant vs. Qual 9 MIN Quantitative (Numbers): Facts that are easy to graph (scales, checkboxes). Use for "The How Many." Qualitative (Stories): Quotes and descriptions (short answers). Use for "The Why." Software Skill: Form Logic Show how to toggle Required. "Required questions ensure your data grid doesn't have holes in it tomorrow." III. ACTIVITY: Market Research Form 20 MIN The 5-Question Blueprint: Demographics: Identifies the user group (e.g., Grade level). Pain Point: Scale 1-5 (How much does this specific problem bother you?). Solution Check: MC (Would you actually use a product that solved this?). Pricing: MC (Specific dollar amount options). Qualitative: Open paragraph (What is one thing that would make this perfect?). IV. EXIT TICKET: Deployment 5 MIN "Shorten your link and share it. Which of your questions will give you a **Number** for the spreadsheet tomorrow?"
Survey Design Cheat Sheet 24Market Intelligence Survey Blueprint Gathering Clean Data Dossier-24 Researcher: 01. Data Types Quantitative (Quantity) Numbers, scales, or multiple choice. These are measurable hard facts. Qualitative (Quality) Words, stories, and feelings. These provide the "Why." Analyst Rule: NO BIAS Never use "Loaded" words to force an answer. "Is our cool product better?" ← BIAS "How would you rate this product?" ← CLEAN 02. Checklist 5-Question Framework 01. Demographic 02. The Pain Point (Scale) 03. The Solution (Yes/No) 04. The Price Range 05. Open Feedback Exit Ticket: Which question gives you numbers? Question # ___ is quantitative. Make every question Required. Incomplete data is useless intelligence. Market Analyst | Lesson 24 Ref-13
Survey Design Slides 24Unit 3: The Market Analyst Clean Intelligence Lesson 24: Professional Survey Design The Loaded Question POISONED DATA 🗣️ "Don't you think my super-cool sneakers are better than those boring ones?" This is a LEADING question. Why does it matter? Biased questions lead to fake data. Fake data leads to business failure. Analysts need CLEAN intelligence. Clean data = Smart decisions. Data Types Quantitative Numbers, Scales, Categories. "How Many?" Easy to graph in a spreadsheet Qualitative Stories, Quotes, Paragraphs. "Why?" Great for marketing & emotional ads Software Skill: The Form Master Tool Required "Don't leave success to chance. Make every question mandatory." Question 01 Required The 5 - Question Build 1 Who: Demographic Info 2 The Pain: 1 - 5 Scale 3 The Check: Solution Interest 4 The Price: Choose a Range 5 The Why: Open Paragraph Neutral Tone Remove all biased adjectives. Use pure research language. Deployment Which of your questions will give you a number tomorrow? Shorten your link & share it to the class folder.
Data Sync Teacher Guide 25Lesson 25: Data Collection & The Sync Unit 3: The Market Analyst Process Phase Automation & Syncing Pacing Hook: Speed of Light 6m Mini-Lesson: The Sync 9m Activity: Data Sprint 20m Exit Ticket: Data Check 5m Focus Standard "I can use digital tools to automate data collection and organize live datasets, ensuring technical accuracy in market analysis." Live Syncing Frozen Rows Database Flow I. THE HOOK: The Speed of Light 6 MIN The Question: "If you surveyed 1,000 people on paper, how long would it take you to count the answers? What if you had to make a pie chart by hand?" The Action: Show the 'Responses' tab of a Google Form. Point out the charts that are automatically generated the moment someone clicks 'Submit'. The Point: Technology isn't just about 'digital paper'. It is about instantaneous organization. II. MINI-LESSON: The Spreadsheet Link 9 MIN The Sync: Demonstrate the "Link to Sheets" button. Explain that as people take the survey, new rows appear in the spreadsheet automatically. This is how Amazon and Netflix track your clicks! The Clean Up: Why naming files is critical. Analysts handle dozens of sheets; "Untitled Spreadsheet" is a liability. Analyst Skill: Freezing Rows Go to View > Freeze > 1 Row. "If you have 500 rows of data, you'll forget what Column E means by the time you scroll down. Freezing keeps the 'Address Label' in sight at all times." III. ACTIVITY: The Data Sprint 20 MIN Task 1: The Collection (10m) Students must find the class link list and complete at least 5 surveys for their peers. This provides everyone with actual data to analyze. Task 2: The Connection (10m) Link Form to a new Sheet. Rename to Product_Survey_Data. Freeze Row 1 (Headers). IV. EXIT TICKET: Real-Time Audit "Count your responses. How many people answered? Which specific column contains the most 'surprising' or 'interesting' data for your brand?"
Data Sync Cheat Sheet 25Database Protocol The Sync Forms to Sheets: Automation Logic Analyst Level 02 ID: 01. Live Data Flow Instant Connection When a customer clicks Submit, their data travels at the speed of light to your spreadsheet. No manual typing required. The Database Chain THE FORM: The frontend collector. THE SYNC: Connecting the two apps. THE SHEET: The backend storage vault. Software Skill: Freezing "Freeze the Header Row so your column titles never disappear." View > Freeze > 1 Row 02. Data Sprint Checklist Sync Operations Submit 5 peer surveys Click "Link to Sheets" Rename: Product_Survey_Data Freeze the Top Row Real-Time Audit (Exit Ticket): Total Responses Recorded: Surprising Data Column: Column ___ was interesting because... "Naming files isn't optional. In the data world, an 'Untitled' sheet is a lost opportunity. Organization is power." Market Analyst | Lesson 25 © 2026 THE IDENTITY STUDIO Ref-14
Data Sync Slides 25Unit 3: The Market Analyst The Data Sync Lesson 25: Automated Collection The Speed of Light 📝 Paper Survey Hours of counting, manual math, and potential mistakes. 🔗 Automated Sync Instant charts, perfect accuracy, zero counting. "Modern business is about moving faster than the competition." The Sync Chain The Form Real-Time Sync Live Data Flow As people submit, your spreadsheet grows. The Sheet Skill: Freezing Rows Utility Freeze "Keep your labels visible even when you have 1,000 responses." Header stays fixed at the top. The Data Sprint 1 Collect: Take at least 5 classmate surveys. 2 Link: Click the Sheet icon in responses. 3 Organize: Rename file and Freeze Row. Live Updates Watch your rows grow in real-time as people finish your survey! The Audit "Look at your spreadsheet. How many responses did you get?" Which question had the most surprising answer?
Spreadsheet Formulas Teacher Guide 26Lesson 26: Spreadsheet Formulas Unit 3: The Market Analyst Software Proficiency Level 2: Data Calculation Pacing Hook: Human vs Machine 6m Mini-Lesson: Formulas 9m Market Score Activity 20m Exit Ticket: What-If 5m Standard Focus "I can apply mathematical functions within digital tools to automate calculations, ensuring speed, accuracy, and brand-consistent documentation." I. THE HOOK: Human vs. Machine 6 MIN Action: Invite a "Human Calculator" volunteer. Give them a phone or handheld calculator. Read off 10 random prices (e.g., $12.50, $4.99, $120.00...). Comparison: While they type, you type the numbers into a Sheet and use =SUM(A1:A10). You will win every time. The Point: In marketing, speed and accuracy equal profit. Spreadsheets never make typos. II. MINI-LESSON: The Magic Wand (=) 9 MIN The Equals Sign (=): The "Switch." Without it, the cell just shows text. With it, the cell becomes a calculator. Cell Referencing: Never type =10+15. Type =B2+C2. This creates a LIVE document. If the data in B2 changes, the answer changes instantly. The Analyst's Trio =SUM: Find the total of a range. =AVERAGE: Find the mean score. =COUNT: Count how many responses exist. III. ACTIVITY: Market Magic Math 20 MIN Open "Product_Survey_Data" and add two new sections: 1. Market Score Use =AVERAGE on your rating column and =COUNT to find the total responses. 2. Launch Budget List 3 expenses (e.g., Marketing, Materials, Shipping). Use =SUM to find the total launch cost. IV. EXIT TICKET: The What-If Test "Change the cost of your Materials in your budget table. What happened to the total cost? Write your old and new total in the submission box."
Spreadsheet Formulas Cheat Sheet 26Reference Ref-15 Magic Math The Analyst's Formula Guide Level 2 Tech Analyst Name: _________________________ 01. The Formula Bar = The Power Button Every formula MUST start with an equals sign. It tells the software to calculate. Cell Referencing (The Secret) Don't type numbers. Type Locations. Wrong =10 + 5 Analyst Way =B2 + C2 "If you change B2, the answer updates automatically!" The Fill Handle Don't type the same formula 100 times. Click the Small Blue Square in the bottom-right of your cell and drag it down. 02. Function Library SUM Adds it all up Perfect for: Budget Totals AVERAGE Finds the mean Perfect for: Survey Scores COUNT Tally responses Perfect for: "How Many?" The "What-If" Analysis If you increase your marketing budget by $500, what is the new total? Prove your formula works. Old Total: $ ________ New Total: $ ________ "The goal isn't just to do math; it's to build a System that does math for you while you sleep." The Market Analyst | Lesson 26 © 2026 THE IDENTITY STUDIO Ref-15
Market Analyst Slides 26Unit 3: The Market Analyst Magic Math Lesson 26: Spreadsheet Formulas Speed vs. Accuracy 🧔 Human Brain Can make typos. Gets tired. Needs to recount manually. VS The Spreadsheet Never blinks. Never makes a typo. Updates in 0.01 seconds. "In business, accuracy isn't a goal—it's the bare minimum." = The Secret Wand The Equals Sign tells the cell: "Stop displaying text and start doing math." Without the =, it's just a digital post-it note. Don't Type Numbers Link the Grid. If you type =10+5, the answer is stuck. If you type =B2+C2, the answer is ALIVE. Static =10 + 5 Dynamic =B2 + C2 The Analyst's Trio SUM The Total Finds the final amount of a whole column. AVERAGE The Middle Finds the "Mood" or mean of survey scores. COUNT The Tally Finds exactly how many responses you got. Automating Success 1 Use =AVERAGE to find your product score. 2 Use =COUNT to find total responses. 3 Build a Budget Table with a =SUM total. Live Test Change one budget number—watch the total move on its own!
Sorting Filtering Teacher Guide 27Lesson 27: Sorting, Filtering & Trends Unit 3: The Market Analyst Intelligence Tool X-Ray Vision for Data Pacing Hook: Finding the Needle 6m Mini-Lesson: Chaos Control 9m Target Segment Activity 20m Exit Ticket: Discovery 5m Focus Standard "I can identify target audience segments and analyze trends by manipulating large datasets using sorting and filtering tools." I. THE HOOK: Finding the Needle 6 MIN Action: Show Slide 2. A spreadsheet with 200 messy rows. Question: "Who can tell me the name of the 45th person who liked the color Blue? How much time will you waste looking?" The Point: Raw data is a mess. Sorting and Filtering are your "X-Ray Vision" to find the hidden truth. II. MINI-LESSON: Organizing Chaos 9 MIN Sorting (A-Z): Organizing data numerically or alphabetically. Use this to find your highest scores instantly. Filtering: Hiding what you don't need. "Only show me the people who said YES." Visual Logic: Conditional Formatting Tell the software to change color automatically. "If cell > 10, turn GREEN." This makes trends jump off the screen. III. ACTIVITY: The Target Segment Search 20 MIN Analysis Workflow: Sort: Use the "Rating" column to sort Highest to Lowest. Filter: Apply a filter to show only "Yes" buyers. Format: Apply Conditional Formatting to the "Price" column (Over $10 = GREEN). Identify: Find 1 common trait among your top-rated responses. IV. EXIT TICKET: The Market Trend "After filtering, what is one thing your customers have in common? (e.g., 'They all chose the same favorite feature'). Submit this as a comment in your sheet."
Sorting and Filtering Cheat Sheet 27Reference Ref-16 Data Vision Sorting, Filtering & Conditional Logic Market Analyst Specialist: _________________________ 01. Organizing the Noise Sorting (A to Z) Rearranges the whole spreadsheet. Use to find your best results at the top. Filtering Hides rows you don't need. Only show what matters. Conditional Formatting Automation for your eyes. Tell the software: "IF the score is 10, turn the cell GREEN." 1 5 10 02. The Segment Search Trend Identification Step 1: The High Score Sort Data > Sort Sheet by Rating (Z → A). Who is at the top? Step 2: The Buyer Filter Apply Filter. Deselect "No." Only "Yes" buyers should remain visible. The Market Discovery (Exit Ticket): Describe one trend or pattern found in your top customers... "Analysts don't read every row. They use tools to make the important rows stand out. Master the filter." Market Analyst | Lesson 27 © 2026 THE IDENTITY STUDIO Ref-16
Market Analyst Slides 27Unit 3: The Market Analyst Organized Chaos Lesson 27: Sorting & Filtering The Needle Test Find the pattern. In 500 rows of data, looking line-by-line is impossible. You need X-Ray Vision. Sorting and Filtering are your Analyst Superpowers. Chaos Control Sorting Organizing the pile. Put the best stuff at the TOP. Numerical or Alphabetical Filtering Removing the noise. Only see what MATTERS. Hiding the distractions Visual Logic Conditional Formatting Teach the spreadsheet to Change Color automatically when it sees a specific value. 1 5 10 "Good data should jump off the screen." The Segment Search 1 Sort by Rating (Highest to Lowest). 2 Filter for only "Yes" buyers. 3 Format Price column (>$10 = Green). Find the Trend What is the one thing your top customers have in common? The Discovery "After filtering, what pattern did you discover about your audience?" Document your finding as a comment in your sheet.
