This guide walks you through it in 6 steps, with a real example and ready-to-use templates. In a hurry? Describe your project out loud and Doku builds the schedule for you in 2 minutes.
What is an activity schedule?
It's a visual calendar that answers three questions: what will be done, who does it, and when it needs to be ready. It lays a project's activities out over time, with start and end dates, owners, and the order things must happen in. It works the same for a marketing campaign, an event, a construction job, or a product launch.
The 4 elements of every good schedule
Activities and deliverables
The full task list, grouped by phase, and what gets delivered at the end of each one. If it doesn't produce a deliverable, ask yourself whether it's an activity or just a meeting.
Dates and durations
Realistic start and end dates per activity. Optimistic estimates are the #1 cause of broken schedules — pad anything that depends on third parties.
Owners
One person per activity — not "the team". When everyone is responsible, no one is.
Dependencies and the critical path
What can't start until something else finishes. The longest chain of dependencies is your critical path: any delay there delays the whole project.
How to make an activity schedule in 6 steps
List every activity
Braindump everything that needs to happen, without ordering it yet. Then group by phase (planning, execution, wrap-up) and remove duplicates. It's easier to trim a long list than to discover forgotten tasks mid-project.
Estimate realistic durations
Ask the person who will actually do each activity how long it takes — not how long you'd like it to take. Add a 20-30% buffer to anything that depends on approvals or external vendors.
Define order and dependencies
Mark which activities can't start until another one finishes (design before production, contract before deposit). That gives you the real sequence and reveals your critical path.
Assign one owner per activity
A name, one single person. Others can help, but the owner is the one who answers for the date.
Put it on a visual timeline
Move the list into a Gantt or kanban view where bars show duration and overlap, and mark the key milestones. A schedule that lives in a text table gets consulted by no one.
Review it every week
A schedule isn't a document you hand in — it's a tool you use. Reserve 15 minutes a week to adjust dates against reality; an outdated schedule is worse than none at all.
Example: a 4-week campaign schedule
Picture an agency launching a campaign in 4 weeks. Week 1: brief and strategy (owner: account lead). Week 2: asset design and copywriting in parallel (design and content). Week 3: production and client approval — that approval sits on the critical path: if it slips, everything after it slips too. Week 4: media buy, publishing, and reporting. With dependencies mapped, the team knows the copy can wait — the approval can't.
What if you want to build it in a spreadsheet?
You can: one column per week, one row per activity, cells painted as bars. But it'll cost you about an hour of formatting, dependencies are tracked by hand, and two weeks of changes later the file is stale and nobody opens it. The alternative: describe your project to Doku — typed or out loud — and get the same schedule in 2 minutes, with a Gantt view, owners, and automatic reminders included.
Ready-to-use schedule templates
Marketing campaign
4 weeks from brief to report: strategy, design, production, approval, and media buy with the critical path marked.
Use template for freeProduct launch
From definition to post-launch: development, testing, marketing, and support coordinated on one board.
Use template for freeEvent or build project
Vendors, permits, setup, and D-day: external dependencies padded so nothing catches you off guard.
Use template for freeDescribe it out loud — Doku builds it
Tell Doku what you're doing, who's on your team, and when it needs to be done. The AI assembles the schedule with dates, owners, and reminders — free, in under 2 minutes.
Create my schedule for freeFrequently asked questions
What should an activity schedule include?
Four things: the activity list grouped by phase, start and end dates for each, one owner per activity, and the dependencies between them. Key milestones (deliveries, approvals) should be clearly visible.
What's the difference between a schedule and a Gantt chart?
The schedule is the plan (what, who, when); a Gantt chart is one way to visualize it, with horizontal bars showing duration and overlap. Every Gantt chart is a schedule, but a schedule can also live in a calendar or a kanban board.
How do you make a schedule in a spreadsheet?
One column per week (or day), one row per activity, colored cells simulating bars. It works for very small projects, but it demands manual formatting, can't handle dependencies, and goes stale fast. For anything involving more than one person, use a tool with an automatic Gantt view.
How often should I update the schedule?
Weekly at minimum, ideally in a short 15-minute review with the team. If a critical-path activity moves, update it the same day — every other date depends on it.
What free tool can I use to make a schedule?
Doku has a free plan with Gantt, kanban, and list views, and its AI drafts the first version of your schedule from a description — typed or spoken. You can also start from a template and adjust it.