Softwiro
Free Excel template

Graduation project manager sheet: tasks, team, phases and deliverables

A free Excel sheet that runs a university graduation project from proposal to defense in one file. It holds the team members, project phases, and a task list with dates and completion percentages. A weekly Gantt chart is built with formulas. It also covers supervisor meetings and their action items, each member's workload, the project budget and how it is split across the team, report chapters, a risk register and a defense preparation checklist. The summary shows progress and delays in charts.

Excel file (.xlsx) · 92 KB · 15 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “المهام” tab (Arabic), with the numbers and formulas that are in the file.
#المهمةالمرحلةالمسؤولالموعد النهائينسبة الإنجازالحالةالتنبيه
1كتابة مقترح المشروعالمقترح والفكرةأحمد سمير46307100%منتهية
2اعتماد الفكرة من المشرفالمقترح والفكرةأحمد سمير46310100%منتهية
3جمع الأبحاث والمشروعات المشابهةمراجعة الأدبياتسارة محمود46311100%منتهية
4قراءة الأبحاث وتلخيصهامراجعة الأدبياتمنة الله حسن46331100%منتهية
5مقارنة التقنيات والأدواتمراجعة الأدبياتكريم عادل46331100%منتهية
6كتابة فصل الدراسات السابقةمراجعة الأدبياتسارة محمود46338100%منتهية
7تحليل المتطلبات ومخططات حالات الاستخدامالتصميمأحمد سمير46329100%منتهية
8تصميم قاعدة البياناتالتصميممنة الله حسن46338100%منتهية
9تصميم نماذج الواجهاتالتصميمكريم عادل4634090%جاريةمتأخرة
10تصميم الدائرة الإلكترونيةالتصميمعمر خالد4634370%جارية
11اعتماد التصميم من المشرفالتصميمأحمد سمير463450%لم تبدأ

Example from the “المهام” tab (Arabic), with the numbers and formulas that are in the file.

What is inside

  • الإعدادات (Settings): Project name, today's date, the start date of week 1 and the defense date, plus the maximum open tasks per member and the required presentation length.
  • الفريق (Team): Up to 10 members: name, role, skills and mobile number. The owner drop-down lists in the other tabs are fed from here.
  • المراحل (Phases): Each phase with planned and actual dates, its task count, its progress weighted by task days, its status and days late.
  • المهام (Tasks): Up to 100 tasks, each with phase, owner, start, deadline, completion percentage, status, priority and the number of the task it depends on. It flags late tasks and tasks that start before their predecessor ends.
  • الجدول الزمني (Timeline): A 20-week Gantt chart built with formulas: a ■ appears in each week a task is active, red for late, green for done and blue for the rest. The current week is shaded.
  • الاجتماعات (Meetings): Each action item from a supervisor meeting with its owner, follow-up date and status, and a flag for items past their date.
  • عبء العمل (Workload): For each member: tasks, how many are done, remaining and late, open working days, weighted progress and an overload alert.
  • المصروفات (Expenses): Each expense with its date, item, category, amount and who paid.
  • الميزانية (Budget): Planned budget per category against actual spending, with an overspend alert. The total is split equally across members so you can see who should be refunded and who should pay.
  • التوثيق (Documentation): Report chapters with target words and pages, how much has been written, chapter status and due date.
  • المخاطر (Risks): Each risk with its probability, impact, score, level, owner, mitigation plan and status.
  • البروفة (Rehearsal): A defense preparation checklist with owner and due date, flagging overdue items, and a log of presentation rehearsals with the length of each against the required length.
  • الملخص (Summary): Days remaining, project progress, late tasks, budget, documentation, risks and defense readiness, with four charts.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

What makes it different

The sheet answers the questions of every weekly team meeting: where are we, what is late, who is overloaded, how much have we spent and who owes whom, how many words of the report are written, and which risk threatens the defense date. Instead of each member carrying the picture in their head, the whole team sees it in one file, and the supervisor can review it in minutes.

How to use it

  1. In the «الإعدادات» (Settings) tab, enter your project name, today's date, the start date of week 1 (a Saturday, for example) and the defense date.
  2. In «الفريق» (Team), list the team members with each one's role and skills, and in «المراحل» (Phases) list the project phases with their planned dates.
  3. In «المهام» (Tasks), enter each task: phase, owner, start, deadline, completion percentage, status and priority, plus the number of the task it depends on, if any.
  4. Open «الجدول الزمني» (Timeline) to see your tasks across the project weeks. Late tasks are red, finished ones green, and the current week is shaded.
  5. After each supervisor meeting, record the action items in «الاجتماعات» (Meetings) with the owner and follow-up date. Record spending in «المصروفات» (Expenses) and finished chapters in «التوثيق» (Documentation).
  6. Open «عبء العمل» (Workload), «الميزانية» (Budget), «المخاطر» (Risks), «البروفة» (Rehearsal) and «الملخص» (Summary) to review the full picture before each weekly team meeting.

Before you start:

  • The sheet holds 10 members, 10 phases, 100 tasks, 20 timeline weeks, 60 meeting items, 200 expenses, 25 chapters, 30 risks and 30 items in the rehearsal checklist.
  • Today's date is typed by hand in the Settings tab (or enter =TODAY() to update itself). Late tasks, overdue follow-up items and days late are calculated from it.
  • A late task is one whose deadline has passed and which is not finished. "Late start" applies to a task with status "Not started" whose start date is before today. If a task starts before the task it depends on has finished, the alert "starts before the task ends" appears.
  • The task number is calculated automatically from the row order. In the "depends on" column, enter the number of the preceding task. Do not delete a row in the middle because the numbers would change; clear its contents instead.
  • Phase and project progress is weighted by task days: a 10-day task counts for more than a 2-day task. A member's overload appears when their open tasks exceed the limit set in Settings.
  • The budget split divides total expenses equally among the team members listed, and shows each member what they paid and what they owe or are owed. Numbers and names are illustrative examples.

Excel file (.xlsx) · 92 KB · 15 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

Cheat sheet: graduation project manager (1/3)Cheat sheet: graduation project manager (2/3)Cheat sheet: graduation project manager (3/3)
0 downloads · 3 pages

Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

In this sheetIn Custom Software from Softwiro
One file that one person edits at a time, and copies reach you on WhatsApp.A program with a login for each user and permissions you define, and everyone sees the same data.
You type everything and check the numbers by hand.We design the screens around your work steps, so each person records only what concerns them.
Columns and formulas are fixed as the sheet was designed.We build what you need: reports, alerts and screens your way.
Backups and security are your own responsibility.The program runs on a secured server with regular backups.

See Custom Software from Softwiro · Ask for a demo

Frequently asked questions

Does it suit any field of study?

Yes. It works for any graduation project done by a team, whether software, engineering or research. Phases, tasks, chapters and categories are names you type and change to fit your project. The examples in the sheet are for a sample software project.

How is the Gantt chart drawn?

With formulas. Each week column starts with a date calculated from the start of week 1, and a ■ appears in every week that overlaps the task's duration. You draw nothing by hand: if you change a task's date, its bar moves.

How many tasks and members does the sheet hold?

100 tasks, 10 members, 10 phases, 20 weeks in the timeline, 60 meeting items, 200 expenses, 25 chapters and 30 risks. Lateness is calculated from the date you enter in Settings.

Does the expense split suit every team?

The sheet divides the total equally among the members listed in the Team tab and shows each member what they paid and the difference. If your team agreed on unequal shares, use each member's "paid" figures and work out the shares among yourselves.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

More free templates for: Schools and students

More free templates

All templates · Free tools