Topics that aren’t examined but you might be interested in. Now you have completed your Analysis you need to start making your project. You have to make a program for a real user , this is very important, you can’t just make them up. This is great because if you work hard enough then you can make sure you get some really good marks, you have access to the mark scheme after all! AQA’s marks scheme says, to get in the top band for complexity, you need at least one of the following:.

Write all of this down somewhere, it’s going to come in useful for your Analysis! Think about using complex queries and fancy ways to present your results. It is called a data flow diagram after all! Fundamentals of computer systems 7. This might involve copying an email into the document. You need to introduce your problem, a quick two paragraphs of what the problem is and how a computer might solve it.

This is very easy with a database, but you must get beyond the defaults of add, edit, delete, that something like Access gives you. Whilst you are getting those skills, head over to Design.

A-level Computing/OCR/The Practical Project – Wikibooks, open books for an open world

Relationships will be enforceable I will be able to use SQL to perform searches. However, who is your user? This solution will allow the user to login online. Excel is a flat file database and won’t let me handle links between data.

Practical Project: Analysis

For example if you only have one person sitting an online test at one time, you only need a simple computer. In other languages Add links. From Wikibooks, open books for an open world. Consequences of uses of computing Alternatively you can use Microsoft Visio.

  OCR ADVANCING PHYSICS B A2 COURSEWORK

Description of measures planned for system security vi. This should come directly from your research and will influence how you complete your project and what sort of hardware you will need to use.

You will need to provide the following information for everything you will store data on:. In most cases you’ll use a database, but compjting could also use a file-based system or xml.

This is an important decision as this will drive the rest of this coursework.

a2 computing coursework wikibooks

The tables don’t have to be normalised at this stage but the relationships should be described in a little detail. This sounds very complex with the graphical representation and AI element, but again, who is your user?

A-level Computing/AQA – Wikibooks, open books for an open world

If you are storing a database make sure that you have stored data on all the fields that will be in your database, for example the data above is storing data on a student in a school. You might also want to get the program to create dynamic visual displays of the random questions being asked, such as creating triangles of the dimensions being tested.

If you aren’t using a database explain that there is no need to complete this section.

a2 computing coursework wikibooks

a22 Books with print version. If you want to do a simulation, your maths or physics teachers may be helpful. Justification of chosen solution iii.

  WMU MEDALLION SCHOLARSHIP ESSAY

This page was last edited on 31 Julyat Now you have cojrsework your Analysis you need to start making your project.

For example if they use a Mac all the time then an interface similar to an OS X interface would be useful. Ask your teachers, maybe they still need to write reports manually, maybe they would want a revision tool for their subject, maybe they would like web based system to book out rooms, maybe they want a program writing that could simulate projectile motion to demonstrate something in class. There should be at least 3 tables and relationships between them.

Fundamentals of computer systems 7. Why not use pre-existing libraries? Make sure you check with your teacher.

Fundamentals of functional programming A-level only Non-exam assessment If your code is complex enough then you don’t have to store any data and the parts of the write up that talk about databases, you can skip. NET The user doesn’t need to access it from multiple computers It requires a server and networking know-how.

Is it that core to what you are doing?

a2 computing coursework wikibooks

This generally shows all the people involved in the system.