Educamp Certificate Tracker

	A	B	C	E	F
1	Start Here — Educamp Certificate Tracker
2	Use this sheet before adding or updating certificate records. Keep every Certificate ID unique and permanent.
3
4	Quick workflow
5	1	Choose certificate type	Participation, Appreciation or Certification. Certification rows (EDUCAMP-CRT) are added automatically by the Academic Hub certification engine when Academic Services verifies a pass.	Certificate ID rules
6	2	Get the next ID	Open Dashboard → copy the suggested Next ID.	Participation	EDUCAMP-PAR-2026-0001
7	3	Paste the ID as a fixed value	Do not leave the ID as a formula. Never reuse an old ID.	Appreciation	EDUCAMP-APP-2026-0001
8	4	Complete the record	Enter recipient, school, program/event, topic/purpose, issue date, duration and signatories.	Permanent rule	Once issued, an ID must never be changed or reused.
9	5	Add the certificate link	Paste the Google Slides / final certificate link in Certificate link.	Duplicate warning	If ID check shows Duplicate, correct it before issuing the certificate.
10	6	Move the status	Draft → Ready for signature → Issued → Sent.	Replacement	Mark the old record Replaced. Create a new row with a new ID and reference the old ID in Notes.
11	7	Record delivery	When sent, enter Sent date. Use Notes for special cases.	Cancelled	Keep the row and ID. Mark it Cancelled. Do not recycle the ID.
12
13
14	Status guide
15	Draft	Record is being prepared. Certificate is not ready for signature.
16	Ready for signature	Details checked; certificate is ready for authorised signatures.
17	Issued	Certificate is final and officially issued.
18	Sent	Certificate has been delivered to the recipient/school. Fill Sent date.
19	Replaced	This certificate was superseded by a new certificate with a new ID.
20	Cancelled	Certificate will not be used. Keep the record and do not reuse its ID.
21
22
23	Field guide
24	Certificate ID	Unique permanent ID copied from Dashboard.
25	Certificate type	Participation or Appreciation.
26	Recipient name	Use the exact name that will appear on the certificate.
27	School / organization	Recipient's school or organisation.
28	Program / event	Workshop, seminar, induction, EASE activity, appraisal activity, etc.
29	Topic / purpose	Workshop topic or reason for appreciation.
30	Issue date	Official date printed on the certificate.
31	Duration (hours)	Use for participation certificates when relevant.
32	Signatory 1 / 2	Official signatory roles or names used on the certificate.
33	Certificate link	Link to the final Google Slides / certificate file.
34	Sent date	Date the certificate was actually delivered.
35	Notes	Replacement references, corrections, exceptions or internal notes.
36
37
38	Important: The tracker is the official register. Do not delete historical rows simply because a certificate was cancelled, replaced or corrected. Keep the audit trail.
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100