Form 5 - Computer
2024-2025
Floor 4 - Computer Room
Mr. Peter, Ms. Angela
Check Digit in HKID
Santa Rosa de Lima English Secondary School
聖羅撒英文中學
Colégio de Santa Rosa de Lima - Secção Inglesa
How is check digit calculated in a HKID ?
This is a HKID
How is check digit calculated in a HKID
Y
3
6
4
9
1
5
(4)
How is check digit calculated in a HKID
Y
3
6
4
9
1
5
(4)
1
Step 01 - Separation
How is check digit calculated in a HKID
1
Step 01 - Separation
Y
3
6
4
9
1
5
(4)
How is check digit calculated in a HKID
2
Step 02 - Letter conversion
Y
3
6
4
9
1
5
(4)
25
This is because 'Y' corresponds to the number 25 in the alphabetical sequence of English letters
How is check digit calculated in a HKID
2
Step 02 - Letter conversion
3
6
4
9
1
5
(4)
25
How is check digit calculated in a HKID
3
Step 03 - Assign weights and calculation
3
6
4
9
1
5
(4)
25
8
7
6
5
4
3
2
\times
\times
\times
\times
\times
\times
\times
200
21
36
20
36
3
10
+
+
+
+
+
+
=
326
=B2*B3=SUM(B4:H4)How is check digit calculated in a HKID
4
Step 04 - Taking the remainder after dividing the sum by 11
326
=MOD(I4, 11)How is check digit calculated in a HKID
5
Step 05 - If the remainder is 0, the check digit will be 0
How is check digit calculated in a HKID
5
Step 05 - If the remainder is 0, the check digit will be 0
=IF(MOD(I4, 11) = 0, 0, 11 - MOD(I4, 11))How is check digit calculated in a HKID
6
Step 07 - Check Digit Validation
Y
3
6
4
9
1
5
(4)
Are they the same?
=IF(MOD(I4, 11) = 0, 0, 11 - MOD(I4, 11))