1What Is It?
A Content Calendar Is Your Posting Plan
Open with the daily "what do I post?" struggle, then define the calendar simply
Raise your hand if this has ever happened to you. It is 8pm. You suddenly remember you have not posted anything today. You open Instagram, stare at the screen, post something quickly, and feel it was not your best. Tomorrow, the same thing happens again.
A content calendar fixes that. A content calendar is simply a plan of what you will post, when, and where. That is all. It can be a Google Sheet, a notebook, or a table in Google Docs. You decide your posts once, ahead of time, so you are never scrambling.
In this lesson, every post on your calendar will have 5 parts: a topic, a hook, a caption, a format, and a call to action. Once you understand these 5 parts, you can plan content for yourself, for a business, or for a client.
A content calendar fixes that. A content calendar is simply a plan of what you will post, when, and where. That is all. It can be a Google Sheet, a notebook, or a table in Google Docs. You decide your posts once, ahead of time, so you are never scrambling.
In this lesson, every post on your calendar will have 5 parts: a topic, a hook, a caption, a format, and a call to action. Once you understand these 5 parts, you can plan content for yourself, for a business, or for a client.
2Why Do I Need It?
Consistency Beats Last-Minute Brilliance
Connect the calendar to real benefits for personal brands, businesses and clients
Here is something people do not tell you about social media: the people who grow are usually not the most talented. They are the most consistent. And consistency is almost impossible without a plan.
A content calendar helps you in four ways. It saves time, because you can create several posts in one sitting instead of thinking from scratch every day. It reduces stress, because you always know what is next. It keeps your content balanced, so you are not only selling or only posting random things. And it makes you look professional, because businesses and clients love seeing a clear plan.
If you ever support a business with their social media, the content calendar is often the very first thing they will ask you for. It is one of the most useful practical skills in this whole course.
A content calendar helps you in four ways. It saves time, because you can create several posts in one sitting instead of thinking from scratch every day. It reduces stress, because you always know what is next. It keeps your content balanced, so you are not only selling or only posting random things. And it makes you look professional, because businesses and clients love seeing a clear plan.
If you ever support a business with their social media, the content calendar is often the very first thing they will ask you for. It is one of the most useful practical skills in this whole course.
Plan once, post all week
Many content creators spend one or two hours on a weekend planning and preparing the whole week's content. During the week, they simply post and reply to comments.
3Show Me
The 5 Parts of Every Post
Walk through each part with one running example
Let us use one example throughout this lesson: Chop Chop Small Chops, a small chops business in Abuja that sells party packs for birthdays, office events and owambes. Here are the 5 parts of one post for this business.
1
Topic
What is this post about?
How to order the right quantity of small chops for your party
2
Hook
What stops the scroll?
"Ordering 50 packs for 80 guests? Here is the mistake that ruins parties."
3
Caption
What do you want to say?
A short guide: guest count, 1 pack per guest, add 10% extra, order 3 days ahead.
4
Format
How will it look?
Carousel of 5 slides designed in Canva
5
Call to Action
What should people do next?
"Save this for your next party, and send us a DM to book."
Before you plan: two quick decisions
Give a quick audience and pillars recap so students can plan with focus
Before you fill a calendar, decide two things. First, who is this content for? For Chop Chop, it is party planners, busy mums and office admins in Abuja. Second, what are your content pillars? Pillars are 3 to 5 repeating themes your content always comes back to. For Chop Chop, the pillars could be: party planning tips, behind the scenes in the kitchen, happy customer moments, and menu and offers.
With your audience and pillars clear, choosing topics becomes easy: every topic sits under one pillar and speaks to that audience.
With your audience and pillars clear, choosing topics becomes easy: every topic sits under one pillar and speaks to that audience.
Choosing your format
Carousel
Several slides people swipe through. Great for tips and step-by-step guides.
Best for: teaching, saving
Short video / Reel
15 to 60 seconds. Shows people, process and personality.
Best for: reach, trust
Single image
One strong photo or design with a clear message.
Best for: offers, quotes, announcements
Text post
Words only. Works especially well on LinkedIn and X.
Best for: stories, opinions
Story / WhatsApp Status
Disappears after 24 hours. Casual and quick.
Best for: daily updates, polls, reminders
Hook formulas you can reuse
- The mistake"The #1 mistake people make when [doing something]..."
- The question"Do you know why your [thing] keeps [problem]?"
- The number"3 things I wish I knew before [experience]."
- The before/after"From [problem] to [result] in [time]. Here is how."
- The secret"Nobody tells you this about [topic]..."
4Let's Do It
A Complete 7-Day Calendar, Step by Step
Show the content mix first, then the finished example calendar
If you only post "buy from me," people stop listening. If you never sell, you never make money. The solution is a content mix. For a 7-day week, here is a simple mix that works for most small businesses and personal brands.
Educate: tips, how-tos and answers to common questions.
Engage: polls, questions, and posts that start conversations.
Promote: your product, service, offer or testimonial.
Personal: behind the scenes, your story, your team.
Walk through the finished example row by row
Here is a full 7-day content calendar for Chop Chop Small Chops. Notice how every row has all 5 parts, and how the mix is balanced across the week. Scroll sideways on your phone to see every column.
| Day | Platform | Type | Topic | Hook | Format | Call to action |
|---|---|---|---|---|---|---|
| Mon | Educate | How many packs to order for your party | "Ordering 50 packs for 80 guests? Here is the mistake that ruins parties." | Carousel | Save this for your next party | |
| Tue | WhatsApp Status | Engage | Favourite small chop poll | "Puff-puff or samosa? Settle this once and for all." | Story poll | Vote and reply with your pick |
| Wed | Personal | Early morning in the kitchen | "5am in our kitchen looks like this." | Short video | Follow for more behind the scenes | |
| Thu | Educate | Keeping small chops fresh at events | "Why your small chops go soggy before guests arrive." | Single image + tips | Share with someone planning a party | |
| Fri | Promote | Weekend party pack offer | "Planning something this weekend? We have you covered." | Single image | DM "PACK" to order before Friday 6pm | |
| Sat | WhatsApp Status | Engage | Customer party photos | "Tag us in your party pictures. We love seeing them!" | Story repost | Send us your photos |
| Sun | Educate | Planning the week's events | "3 questions to ask before booking any caterer." | Text post | Comment with your own tip |
The caption column is left out here to keep the table readable. In your own Google Sheet, add a Caption column and write the full caption for each day.
Use AI for the first draft, your judgement for the final
ChatGPT or Claude can draft a full 7-day calendar in seconds (Prompt 1). But AI does not know your customers, your prices or what is happening in your city this week. Always check facts, adjust the tone, and remove anything that does not sound like the brand.
5Now You Try
Plan a Week for a Business You Choose
Have students pick a business and plan their own week
Now it is your turn. Choose one business to plan for. It can be your own business, your personal brand, a friend's business, or a fictional one. Some ideas: a hair salon, a fashion brand, a church media team, a real estate agent, a tutor, a skincare brand, or a phone accessories shop.
Then follow these steps. First, write down your audience and 3 to 4 content pillars. Second, decide which platforms you will post on. Third, plan your 7 days using the 3-2-1-1 mix. Fourth, give each day all 5 parts: topic, hook, caption, format and call to action. Fifth, use AI to help with ideas and captions, then edit everything so it sounds human.
Then follow these steps. First, write down your audience and 3 to 4 content pillars. Second, decide which platforms you will post on. Third, plan your 7 days using the 3-2-1-1 mix. Fourth, give each day all 5 parts: topic, hook, caption, format and call to action. Fifth, use AI to help with ideas and captions, then edit everything so it sounds human.
This counts towards your final project
Your course final project includes a 7-day content calendar. If you choose the same business you will use for your final project, the calendar you build today is already done.
6Your Task
Lesson 19 Assignment
This lesson's assignment
Create a complete 7-day content calendar in Google Sheets for one business, with all 5 parts for every day and a balanced content mix.
- 1
Choose your business: Fill in Part A of the workbook with the business, audience and pillars.
- 2
Set up your sheet: Create a Google Sheet called "7-Day Content Calendar: [Business Name]" with these columns: Day, Date, Platform, Type, Pillar, Topic, Hook, Caption, Format, Call to Action, Status.
- 3
Draft with AI: Use Prompt 1 to generate a first draft, and Prompt 2 to improve your hooks.
- 4
Edit and check: Review every row with the checklist in the Practical Task tab. Make sure the mix is 3 educate, 2 engage, 1 promote, 1 personal.
- 5
Create one post: Turn one day from your calendar into a finished post (design or video plus caption) and save it in your Content folder in Google Drive.
7What Did You Create?
A Week of Content, Planned and Ready
Close by naming the output and linking to Lesson 20
Look at what you have now: a full week of content, planned in advance, with a clear topic, hook, caption, format and call to action for every single day. No more 8pm panic. And you have a skill you can use for yourself, for a business, or for anyone who needs help with their social media.
Keep your Google Sheet. Each week, duplicate the tab and plan the next 7 days. After a month, look at which posts got the most likes, comments, saves and messages, and plan more of those.
In Lesson 20, we go one step further with an introduction to digital marketing. You will learn how content moves people from first noticing you to trusting you and taking action.
Keep your Google Sheet. Each week, duplicate the tab and plan the next 7 days. After a month, look at which posts got the most likes, comments, saves and messages, and plan more of those.
In Lesson 20, we go one step further with an introduction to digital marketing. You will learn how content moves people from first noticing you to trusting you and taking action.
- Business, audience and 3 to 4 content pillars written down
- Google Sheet set up with all calendar columns
- 7 days planned with topic, hook, caption, format and call to action
- Content mix checked: 3 educate, 2 engage, 1 promote, 1 personal
- One post created and saved in Google Drive
WWorkbook
Lesson 19 Student Workbook
Instructions
Plan on paper first, then move your plan into Google Sheets. Thinking on paper often produces clearer ideas than typing straight into a spreadsheet.
🎯 Part A: My Business and Audience
Business name:
What it sells:
Who it is for:
Platforms:
My 3 to 4 content pillars:
Pillar 1:
Pillar 2:
Pillar 3:
Pillar 4:
📅 Part B: My 7-Day Plan
For each day, write the type (Educate, Engage, Promote, Personal), the topic, and the format.
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
🪝 Part C: My Best Hooks and Calls to Action
Write 3 hooks using the hook formulas:
Hook 1:
Hook 2:
Hook 3:
Write 3 different calls to action:
CTA 1:
CTA 2:
CTA 3:
TTask
Build Your 7-Day Content Calendar
Time: about 60 to 90 minutes
Output: a completed 7-day content calendar in Google Sheets and one finished post saved in your Google Drive Content folder.
Part 1: Set Up Your Sheet (15 minutes)
- 1
Open Google Drive, go to your Content folder, and click New, then Google Sheets. Name it "7-Day Content Calendar: [Business Name]."
- 2
In row 1, type the column headings: Day, Date, Platform, Type, Pillar, Topic, Hook, Caption, Format, Call to Action, Status.
- 3
Make row 1 bold, click View, then Freeze, then 1 row, so your headings stay visible as you scroll.
- 4
For the Status column, select the cells, click Insert, then Dropdown, and add three options: Planned, Created, Posted.
Part 2: Draft and Edit with AI (45 minutes)
- 1
Open ChatGPT or Claude and run Prompt 1 with your business details. Ask for the result as a table.
- 2
Copy the table into your Google Sheet. Run Prompt 2 on any hooks that feel weak, and Prompt 3 to write fuller captions.
- 3
Go through every row and check it against the list below. Edit anything that does not pass.
- Every day has all 5 parts: topic, hook, caption, format, call to action
- The week follows the 3-2-1-1 mix
- Every topic fits one of my content pillars
- Facts, prices and details are correct (AI did not invent anything)
- Captions sound like a real person, not a robot
Part 3: Create One Post (30 minutes)
- 1
Pick one day from your calendar. Create the design in Canva or record the short video.
- 2
Add the final caption and call to action. Save the design and caption together in your Content folder.
- 3
Optional: schedule it using Meta Business Suite (free for Facebook and Instagram), and change its Status to "Posted" once it goes live.
📅
Lesson 19 Complete!
Your 7-day content calendar is ready. In Lesson 20, you will learn how content fits into digital marketing.
AIPrompts
Lesson 19 Prompt Library
Add to your Prompt Library Google Doc
Open your "My AI Prompt Library" document, add the heading "Lesson 19: Content Calendar," and paste all five prompts below.
Content Calendar Prompts
Prompt 1: Draft a 7-day content calendar
"Act as a social media manager. Create a 7-day content calendar for [business name], a [type of business] in [city] that serves [audience]. My content pillars are: [list pillars]. I post on [platforms]. Use this weekly mix: 3 educate, 2 engage, 1 promote, 1 personal. Present it as a table with these columns: Day, Platform, Type, Pillar, Topic, Hook, Caption (under 80 words), Format, Call to Action. Keep the language simple and friendly for a Nigerian audience."
Ask for a table so you can copy it straight into Google Sheets.
Prompt 2: Improve my hooks
"Here are 7 hooks for my social media posts: [paste hooks]. My audience is [audience]. For each one, write 3 stronger alternatives using these formulas: the mistake, the question, the number, the before/after, and the secret. Keep each hook under 15 words. Then tell me which option you think is strongest for each and why."
The hook decides whether anyone reads the rest. Spend extra time here.
Prompt 3: Write a full caption
"Write a [platform] caption for [business name]. Topic: [topic]. Hook: [hook]. Audience: [audience]. Tone: [friendly / professional / playful]. Structure: start with the hook, give [3 tips / a short story / the key details], then end with this call to action: [CTA]. Keep it under [number] words, use short paragraphs, and add 3 to 5 relevant hashtags."
Read it out loud. If it does not sound like something the business owner would say, edit it.
Prompt 4: Repurpose one idea into many
"I have one content idea: [idea]. Turn it into 4 pieces of content for [business name]: (1) an Instagram carousel outline with 5 slides, (2) a 30-second short video script, (3) a WhatsApp Status sequence of 3 frames, and (4) a LinkedIn or Facebook text post. Keep the message consistent but adapt the style to each format."
One good idea can fill several days of your calendar.
Prompt 5: Review my content calendar
"Review this 7-day content calendar for [business name]: [paste calendar]. My audience is [audience] and my goal is [more enquiries / more followers / more engagement]. Check: (1) Is the content mix balanced? (2) Are the hooks strong? (3) Is every call to action clear? (4) Is anything repetitive? Give me 5 specific improvements."
Use AI as a second pair of eyes, then decide for yourself which suggestions to keep.