The coursework task is open book. You can look at practical tasks you have done already and reuse bit of them if you need to. You can also refer to the notes on this wiki. In particular you will find the following sections useful:
You can also refer to anything in your folders. The "Common Errors in ..." helpsheets and the "Design to Python" helpsheet are especially useful.
You are also allowed to access online resources. w3schools is particularly useful for the website and databases section.
The tasks can be completed in any order. If you are having difficulty in completing one section, move onto a different section and attempt it instead.
You have 8 hours to complete the task. It is very unlikely you will get this 8 hours in one session. If there is something that you have not been able to do, you have a chance to think about it and find out more between sessions. You can then use anything you have learned between sessions to attempt parts you were unable to do previously. However, you can't ask your teacher for help between sessions - they aren't allowed to help you.
You can attempt the sections in any order. A good order to do the sections in is databases, then programming and finally websites. The website section is usually a bit easier than the programming, but it can be very time consuming.
Failing to successfully code a python program does not stop you testing and evaluating it. You can still devise appropriate test data, and attempt to test it. Your printout of testing will simply show that the program did not run or crashed. Your evaluation should honestly reflect that your program doesn't work and is therefore not fit for purpose.