C1SE-12 Team

Hours
# available per Member Name
Sprint

1 112.4 Do Huy Hoang Start date Oct 2, 2023

2 14.4 Nguyen Ngoc Huy End date Oct 25, 2023

How to use this:
3 28.4 Tran Van Chi
NEW 4 SPRINT 98.4 Huynh Le Thanh Truong
1) Make a copy of this sheet, change X in cell D1 to sprint number.
5 30.4 Hoang Quang Dat
2) Each team member estimates the number of hours they have to work in the sprint.
Remanning
SUM
ENTERING 284 A NEW TASK
1) For the sprint, select a user story from the product backlog (based on input from Product Owner).
hours -16 x

2) Break down the user story into tasks of around 0 to 8 hours.

x
3) For each task, enter the backlog ID in column B. a description of the task, the originator and responsible team

10

11

12

13

14

15

16

17

18

19

20

21

22

23
0

9
members.
4) Finally, and most Important, enter the initial estimate in hours in column H.

02/10/2023

03/10/2023

04/10/2023

05/10/2023

06/10/2023

07/10/2023

08/10/2023

09/10/2023

10/10/2023

11/10/2023

12/10/2023

13/10/2023

14/10/2023

15/10/2023

16/10/2023

17/10/2023

18/10/2023

19/10/2023

20/10/2023

21/10/2023

22/10/2023

23/10/2023

24/10/2023

25/10/2023
Status(Not

Truong
Day 23

Day 22

Day 21

Day 20

Day 19

Day 18

Day 17

Day 16

Day 15

Day 14

Day 13

Day 12

Day 11

Day 10

Hoang
Day 9

Day 8

Day 7

Day 6

Day 5

Day 4

Day 3

Day 2

Day 1

Day 0
Started Inita

Huy

Dat
Chi
UPDATING
No. BACKLOG ID Task Description (User Story/Use Case Broken Down) Responsible Comp.
In Progress l Est.
Every day you should re-estimate the tasks entering the new estimate on the next day. This means you could end up
Completed)
with more hours on a task the next day even if you spent time on it in the current day. What is important is to know how
much work is left to do. Not how much work was done.
300 8 300 298 288 266 236 210 183 164 154 142 134 118 108 102 90 76 58 38 28 20 20 16 16 8

1 Sprint Detail Plan All member Completed 6 0 6 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x x x x x 1.2

3 Planning meeting Hoang Completed 6 0 6 6 6 6 6 6 6 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 6

4 Proposal Document All member Completed 6 0 6 6 6 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x x x x x 1.2

5 Project Plan Document Chi Completed 6 0 6 6 6 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 6

6 Product Backlog Document Huy Completed 6 0 6 6 6 6 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 6

7 User stories Document Chi Completed 6 0 6 6 6 6 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 6

Pre-sprint
8 Create Sprint Backlog Hoang Completed 6 0 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 4 2 0 0 0 0 0 x 6

9 Create UX/UI document (Login, Admin) Chi, Huy Completed 12 0 12 12 12 10 8 6 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x x 6

10 Create Test Plan Hoang Completed 8 0 8 8 8 6 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x -8

11 Set-up Front-end Truong, Dat Completed 8 0 8 8 6 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x x 4

12 Set-up Database Hoang Completed 4 0 4 4 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 4

13 [Design] Analyze login screen requirements and authorization. Truong Completed 8 0 8 8 8 6 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 8

14 [Design] Design the interface for the login screen Truong Completed 8 0 8 8 8 8 8 6 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 8

15 [Design] Database desgin Hoang Completed 8 0 8 8 8 6 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 8

16 [Design] Interface for account management screen Truong Completed 8 0 8 8 8 8 6 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 8

17 [Design] Add new account screen Truong Completed 4 0 4 4 4 4 4 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 4

18 [Design] Interface for menu management screen Truong Completed 8 0 8 8 8 8 6 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 8

Design
19 [Design] Add new dish screen Truong Completed 4 0 4 4 4 4 4 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 4

20 [Design] Interface for the dining table information management screen Truong Completed 8 0 8 8 8 8 6 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 8

21 [Design] Add new table screen Truong Completed 4 0 4 4 4 4 4 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 4

22 [Design] Interface for Table screen and table status of Staff Dat Completed 8 0 8 8 6 4 4 4 4 4 4 4 4 0 0 0 0 0 0 0 0 0 0 0 x 8

23 [Design] Interface for Menu screen of Staff Dat Completed 8 0 8 8 6 6 4 4 4 4 4 2 2 0 0 0 0 0 0 0 0 0 0 0 x 8

24 [Design] Interface for the Report screen Dat Completed 8 0 8 8 6 4 2 2 2 2 2 2 2 0 0 0 0 0 0 0 0 0 0 0 x 8

25 [FE] Create a login form Truong, Hoang Completed 12 0 12 12 12 12 12 12 12 12 10 6 2 0 0 0 0 0 0 0 0 0 0 0 0 0 x x 6

26 [FE] Build account management screen Truong, Hoang Completed 12 0 12 12 12 12 12 12 12 12 12 12 12 10 8 6 4 2 0 0 0 0 0 0 0 0 x x 6

27 [FE] Build menu management screen Truong, Hoang Completed 8 0 8 8 8 8 8 8 8 8 8 8 8 8 8 8 6 4 2 0 0 0 0 0 0 0 x x 4

28 Build UI [FE] Build a screen to manage dining table information Truong, Hoang Completed 8 0 8 8 8 8 8 8 8 8 8 8 8 8 8 8 6 4 2 0 0 0 0 0 0 0 x x 4

29 [FE] Upvote/Downvote action Truong Completed 8 0 8 8 8 8 8 8 8 8 8 8 8 8 4 2 0 0 0 0 0 0 0 0 0 0 x 8

 Build UI

30 [FE] Navbar, icon Truong Completed 8 0 8 8 8 8 8 8 8 8 8 8 8 8 4 2 0 0 0 0 0 0 0 0 0 0 x 8

31 [FE] Pull Data source Truong, Hoang Completed 8 0 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 4 2 0 0 0 0 0 x x 4

32 [BE] API User Account Hoang Completed 8 0 8 8 8 8 8 8 8 8 6 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 x 8

33 [BE] Decentralized system Hoang Completed 8 0 8 8 8 8 8 8 8 8 6 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 x 8

34 [BE] API list Account Hoang Completed 4 0 4 4 4 4 4 4 4 4 4 4 4 4 4 4 2 0 0 0 0 0 0 0 0 0 x 4

35 [BE] API Update Account Hoang Completed 4 0 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 2 0 0 0 0 0 0 0 0 x 4

36 [BE] API Delete Account Hoang Completed 4 0 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 2 0 0 0 0 0 0 0 0 x 4

37 [BE] [BE] API add new Account Hoang Completed 4 0 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 2 0 0 0 0 0 0 0 0 x 4

38 Backend [BE] API lists dishes in the menu Hoang Completed 4 0 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 2 0 0 0 0 0 0 0 x 4

39 [BE] API Update dishes Hoang Completed 4 0 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 2 0 0 0 0 0 0 0 x 4

40 [BE] API Delete dishes Hoang Completed 4 0 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 2 0 0 0 0 0 0 0 x 4

41 [BE] API add new dishes Hoang Completed 4 0 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 2 0 0 0 0 0 0 x 4

42 [BE] API Update Table Hoang Completed 4 0 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 2 0 0 0 0 0 x 4

43 [BE] API add new Table Hoang Completed 4 2 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 2 x 2

44 [BE] API deltete Table Hoang Completed 4 2 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 2 x 2

45 Test the login screen and authorization Chi Completed 4 2 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 2 x 2

Test
46 Test the account management screen, menu and table information Chi Completed 8 2 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 4 4 2 x 6

240.4

Working hours per day Day 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

13.04 EST 300 287 274 261 248 235 222 209 196 183 170 157 143 130 117 104 91 78 65 52 39 26 13 0

Actual 300 298 288 266 236 210 183 164 154 142 134 118 108 102 90 76 58 38 28 20 20 16 16 8

350
Hours available per Sprint
300
Hoang Quang Dat
250

200
Do Huy 150
Hoang
Huynh Le
Thanh 100
Truong
50

0
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
Nguyen
Tran Van Chi Ngoc Huy
Actual Estimate
 Sprint 2 WEB-BASED DATA VISUALIZATION TOOL
41.2
Hours
# available per Member Name
Sprint
1 63.2 Do Huy Hoang Start date Oct 26, 2023
2 34.2 Nguyen Ngoc Huy End date Nov 20, 2023
How
3 to use this:
13.2 Tran Van Chi

NEW4 SPRINT52.2 Huynh Le Thanh Truong

1) Make a copy of this sheet, change X in cell D1 to sprint number.
5
2) Each team 57.2 Hoang Quang
member estimates Dat of hours they have to work in the sprint.
the number

ENTERING A NEW TASK Remanning

SUM 220
1) For the sprint, select a user story from the product backlog (based on input from Product Owner). hours -66 x
2) Break down the user story into tasks of around 0 to 8 hours.

x
3) For each task, enter the backlog ID in column B. a description of the task, the originator and responsible team

05/11/2023 10

06/11/2023 11

07/11/2023 12

08/11/2023 13

09/11/2023 14

10/11/2023 15

11/11/2023 16

12/11/2023 17

13/11/2023 18

14/11/2023 19

15/11/2023 20

16/11/2023 21

17/11/2023 22

18/11/2023 23

19/11/2023 24

20/11/2023 25
0

9
members.
4) Finally, and most Important, enter the initial estimate in hours in column H.

26/10/2023

27/10/2023

28/10/2023

29/10/2023

30/10/2023

31/10/2023

01/11/2023

02/11/2023

03/11/2023

04/11/2023
Status(Not

Truong
Day 25

Day 24

Day 23

Day 22

Day 21

Day 20

Day 19

Day 18

Day 17

Day 16

Day 15

Day 14

Day 13

Day 12

Day 11

Day 10

Hoang
Day 9

Day 8

Day 7

Day 6

Day 5

Day 4

Day 3

Day 2

Day 1

Day 0
Started Inita

Huy

Chi

Dat
No. BACKLOG ID
UPDATING Task Description (User Story/Use Case Broken Down) Responsible Comp.
In Progress l Est.
Every day you should re-estimate the tasks entering the new estimate on the next day. This means you could end up Completed)
with more hours on a task the next day even if you spent time on it in the current day. What is important is to know
how much work is left to do. Not how much work was done. 286 66 286 272 264 256 238 214 192 170 154 146 136 112 108 106 100 96 90 84 78 76 74 72 72 72 72 72

1 Sprint Detail Plan Hoang 6 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 6

2 Sprint Backlog Hoang 8 0 8 8 6 6 6 6 4 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 8

3 Planning meeting All member 6 6 6 4 4 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x x x x x 0

4 Architecture Document Chi 8 0 8 8 8 8 8 6 6 6 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 8

Pre-sprint
5 Set up database Hoang 8 0 8 8 8 8 8 6 6 6 6 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 8

6 Sprint Retrospective All member 6 0 6 6 6 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x x x x x 1.2

7 [Design] Interface for Homepage for table reservations Dat 12 0 12 10 10 10 8 6 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 12

8 [Design] Interface for Contact screen for table reservations Dat 4 0 4 4 4 4 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 4

9 [Design] Interface for Booking screen for table reservations Dat 4 0 4 4 4 4 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 4

Design
10 [Design] Interface for Menu screen for table reservations Dat 12 0 12 10 8 8 8 6 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 12

11 [Design] Interface for Menu screen for customers to order Dat 8 0 8 8 6 4 4 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 8

12 [Design] Interface for Cart screen for customers to order Dat 8 0 8 6 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 8

13 [FE] Interface displays a list of dining tables Truong, Huy 8 0 8 8 8 8 8 8 8 4 4 4 2 0 0 0 0 0 0 0 0 0 0 0 x x 4

14 [FE] Displays the status of the table Truong, Huy 8 0 8 8 8 8 8 8 6 4 4 4 2 0 0 0 0 0 0 0 0 0 0 0 x x 4

15 [FE] Edit table status Truong, Huy 8 0 8 8 8 8 8 8 8 8 8 8 8 0 0 0 0 0 0 0 0 0 0 0 x x 4

16 [FE] Interface displays a list of dishes Truong, Huy 12 0 12 12 12 12 10 8 6 6 4 2 2 0 0 0 0 0 0 0 0 0 0 0 x x 6

17 [FE] Add dishes to the table Truong, Huy 8 0 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 6 6 6 6 6 6 6 6 6 x x 4

18 Build UI [FE] Displaying information revenue Truong, Huy 8 0 8 8 8 8 6 6 4 4 2 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x x 4

19 [FE] Table reservation interface Truong, Huy 8 0 8 8 8 6 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x x 4

20 [FE ]Customer ordering menu interface Truong, Huy 12 6 12 12 12 12 12 12 10 8 8 6 6 6 6 6 6 6 6 6 4 4 4 4 4 4 4 4 x x 3

21 [FE] Upvote/Downvote action Truong 8 0 8 8 8 8 6 4 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 8

22 [FE] Navbar, icon Truong 8 0 8 8 8 8 6 4 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 8

23 [FE] Pull Data source Truong, Hoang 8 4 8 8 8 8 8 8 8 8 8 8 8 6 4 4 4 4 4 4 4 4 4 4 4 4 4 4 x x 2

24 [BE] API to retrieve table information and status Hoang 8 0 8 8 8 8 8 8 8 8 8 8 8 8 8 8 6 6 4 2 0 0 0 0 0 0 0 0 x 8

25 [BE] API to update table status Hoang 8 0 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 6 4 2 0 0 0 0 0 x 8

26 [BE] API to retrieve a list of dishes Hoang 12 0 12 12 12 12 12 12 12 12 12 12 10 10 8 8 6 4 2 0 0 0 0 0 0 0 0 0 x 12

27 [BE] API to add dishes to the table Hoang 8 2 8 8 8 8 8 8 8 6 4 4 4 4 4 4 4 4 2 2 2 2 2 2 2 2 2 2 x 6

Backend
28 [BE] API to retrieve revenue information Dat 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 x 0

29 [BE] API to store table reservation information Dat 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 x 0

 Backend

30 [BE] API to send table reservation notifications Dat 8 0 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 x x 4

31 [BE ]API to handle QR code scanning requests Hoang 8 0 8 8 8 8 8 8 8 8 8 8 8 6 6 4 2 0 0 0 0 0 0 0 0 0 0 0 x x 4

32 Test the table list display and status feature Huy 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 x 0

33 Test the table status editing feature Huy 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 x 0

34 Test the feature of displaying the dish list Huy 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 x 0

35 Test the feature to add dishes to the table Chi 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 x 0

Test
36 Test the revenue information display feature Chi 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 x 0

37 Test QR code Chi 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 x 0

38 Test The ordering feature via the electronic Menu Chi 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 x 0

39 Test the reservation feature in advance Chi 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 x 0

Working hours per day Day 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

11.44 EST 286 275 263 252 240 229 217 206 194 183 172 160 149 137 126 114 103 92 80 69 57 46 34 23 11 0

Actual 286 272 264 256 238 214 192 170 154 146 136 112 108 106 100 96 90 84 78 76 74 72 72 72 72 72

350
Hours available per Sprint
300

250

Hoang 200
Quang Dat Do Huy
Hoang 150

Huynh Le Nguyen 100

Thanh Truong Ngoc Huy
Tran Van Chi 50

0
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

Actual Estimate
 Sprint 3 WEB-BASED DATA VISUALIZATION TOOL
84.2
Hours
# available per Member Name
Sprint
1 85.4 Nguyen Dang Phuc Start date Apr 26, 2023
2 64.4 Tran Van Tuyen End date May 18, 2023
3 53.4 Che Quang Nhat
4 75.4 Vo Thi Phuong Loan
5 67.4 Mai Thi Ngoc Anh

Remanning
SUM 346
1) For the sprint, select a user story from the product backlog (based on input from Product Owner). hours 0 x
2) Break down the user story into tasks of around 0 to 8 hours.

x
06/05/202310

07/05/202311

08/05/202312

09/05/202313

10/05/202314

11/05/202315

12/05/202316

13/05/202317

14/05/202318

15/05/202319

16/05/202320

17/05/202321
26/04/2023 0

27/04/2023 1

28/04/2023 2

29/04/2023 3

30/04/2023 4

01/05/2023 5

02/05/2023 6

03/05/2023 7

04/05/2023 8

05/05/2023 9
3) For each task, enter the backlog ID in column B. a description of the task, the originator and responsible team
Status(Not

Day 21

Day 20

Day 19

Day 18

Day 17

Day 16

Day 15

Day 14

Day 13

Day 12

Day 11

Day 10

Tuyen
Day 9

Day 8

Day 7

Day 6

Day 5

Day 4

Day 3

Day 2

Day 1

Day 0

Loan
Started Inita

Phuc

Nhat

Anh
No. BACKLOG ID Task Description (User Story/Use Case Broken Down) Responsible Comp.
In Progress l Est.
Completed)

346 0 346 340 337 329 309 292 276 256 239 232 206 191 180 169 146 130 113 96 74 45 25 0

1 Sprint Detail Plan Loan Completed 6 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 6

2 Sprint Backlog Loan Completed 6 0 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 3 1 1 1 0 x 6

3 Planning meeting All member Completed 6 0 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 3 2 2 0 x x x x x 1.2

Pre-sprint
4 Sprint Retrospective All member Completed 6 0 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 3 0 0 x x x x x 1.2

5 [Docs] Architecture Loan, Nhat Completed 10 0 10 10 10 10 10 6 6 6 6 6 4 4 4 4 2 2 2 1 1 1 1 0 x x 5

6 [Docs] Interface Design Loan Completed 6 0 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 3 0 0 x 6

7 [Docs] Database Design Anh, Tuyen Completed 6 0 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 2 2 1 1 1 0 x x 3

8 [Docs] Test Plan Loan, Tuyen Completed 6 0 6 6 6 6 6 6 6 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x x 3

9 [Docs] Test Case Nhat Completed 8 0 8 8 8 8 8 8 8 8 8 8 8 8 8 8 6 6 5 3 3 0 0 0 x 8

10 [Docs] Team meeting Tuyen Completed 6 0 6 6 6 6 6 6 6 6 6 6 6 6 6 2 1 1 1 1 1 1 1 0 x 6

Docs
11 [Docs] Mentor meeting Nhat Completed 6 0 6 6 6 6 6 6 5 5 5 6 5 5 4 4 4 4 1 1 1 1 1 0 x 6

12 [Docs] Technologies Stack Nhat Completed 6 0 6 6 6 6 4 4 4 6 4 4 3 3 3 6 3 3 3 3 3 2 1 0 x 6

13 Reworking Proposal Anh Completed 6 0 6 6 6 6 5 5 5 6 5 5 5 5 4 4 4 4 4 4 3 1 0 0 x 6

14 Reworking Project Plan Tuyen Completed 6 0 6 6 6 6 6 6 6 5 5 5 4 4 3 3 3 2 2 2 2 1 1 0 x 6

15 Reworking Product Backlog Tuyen Completed 6 0 6 6 6 6 6 6 6 6 6 4 4 0 0 0 0 0 0 0 0 0 0 0 x 6

16 Reworking User Story Nhat Completed 6 0 6 6 6 6 6 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 6

17 Design [Design] Diagram table page Nhat Completed 8 0 8 8 5 5 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 8

18 [FE] Table component Anh Completed 8 0 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 6 5 2 0 0 x 8

19 [FE] Link (relation) betweem table component Tuyen Completed 16 0 16 16 16 16 14 13 12 11 11 10 8 8 7 6 5 5 4 4 2 1 1 0 x 16

20 [FE] Modal add table to diagram Phuc Completed 8 0 8 8 8 8 8 8 8 8 8 8 8 8 8 6 4 2 0 0 0 0 0 0 x 8

21 [FE] Modal Update relation between tables Phuc Completed 4 0 4 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 4

22 Build UI [FE] CRUD diagram Tuyen Completed 16 0 16 16 16 16 16 16 16 16 16 16 16 16 16 16 8 0 0 0 0 0 0 0 x 16

23 [FE] Export diagram to image Tuyen Completed 6 0 6 6 6 6 6 6 6 6 6 6 6 6 6 4 2 0 0 0 0 0 0 0 x 6

24 [FE] Diagram page Phuc Completed 16 0 16 16 16 16 16 16 16 16 16 16 8 0 0 0 0 0 0 0 0 0 0 0 x 16

25 [FE] Fix draw line, bar, pie chart Anh Completed 16 0 16 16 16 16 8 8 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 16

26 [FE] Map chart Anh Completed 16 0 16 16 16 16 16 12 8 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 16

27 [BE] CRUD diagram Phuc Completed 16 0 16 16 16 12 8 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 x 16

Back-end
28 [BE] CRUD relation between table(mapping) Phuc Completed 16 0 16 16 16 16 16 16 16 12 8 4 0 0 0 0 0 0 0 0 0 0 0 0 x 16
Back-end
29 [BE] Get data frame merged Phuc Completed 20 0 20 20 20 20 20 20 20 17 17 16 14 13 13 11 11 8 8 5 4 4 3 0 x 20

30 [BE] Integration Covid visualization module Nhat Completed 12 0 12 12 12 12 12 12 12 8 8 8 6 4 2 0 0 0 0 0 0 0 0 0 x 12

31 Test CRUD diagram Loan Completed 10 0 10 10 10 10 10 10 10 10 10 10 10 10 6 5 4 4 3 2 1 1 1 0 x 10

32 Test CRUD relation Loan Completed 10 0 10 10 10 10 10 10 10 10 10 10 7 7 6 6 5 5 4 3 3 2 1 0 x 10

33 Test Add, remove table in diagram Loan Completed 6 0 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 4 3 0 x x 3

34 Test Export diagram to image Loan Completed 6 0 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 4 2 2 1 0 x 6

Test
35 Test Diagram page Loan Completed 10 0 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 8 8 6 4 2 0 x 10

36 Test Graph page Loan Completed 8 0 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 6 4 2 0 0 0 x 8

37 Test Home page Anh Completed 8 0 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 6 4 2 0 x 8

38 Test My profile page Anh Completed 8 0 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 6 4 2 0 x 8

Working hours per day Day 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

16.48 EST 346 330 313 297 280 264 247 231 214 198 181 165 148 132 115 99 82 66 49 33 16 0

Actual 346 340 337 329 309 292 276 256 239 232 206 191 180 169 146 130 113 96 74 45 25 0

400
Hours available per Sprint
350

300

250
Mai Thi Nguyen
Ngoc AnhDang Phuc 200

Vo Thi 150
Tran Van
Phuong Tuyen
Loan 100

Che Quang Nhat 50

0
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

Actual Estimate
There are problem with this task, like OT…
By this time this task must be done on plan
Place to input data Phuc Tuyen Nhat Loan
Sprint 1 86.4 76.4 72.4 75.4
Sprint 2 66.4 78.4 72.4 64.4
Sprint 3 95.4 58.4 49.4 71.4
Total (hours) 248.2 213.2 194.2 211.2

Contribute of each member of team for project

Anh Phuc
20% 22%

Loan
19% Tuyen
20%

Nhat
19%
 Anh
79.4
74.4
73.4
227.2

or project