• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  • Level: GCSE
  • Subject: ICT
  • Word count: 2709

Design Section

Extracts from this document...


Design Section Information Requirements I will need different types of information about this product such as what phone model it is, Colour, Details (If it has Bluetooth and internet) and price. I shall also need to find different specification etc - Colour. I will use primary and secondary research. I will ask the general public and look at other shops and the internet. I am doing this because I want to see what other people charge and what other people think is fair and is the right price. Software to be used There are two software's I could use to make the systems are; * Database - I could use this software as it will be able to save all my data so it will be very useful for this project. The data I shall have if things such as the customers details, Phone details and also a Data File. This should be able to organize my collection of Data. I could also make things likes fields and records. The key field contains an item of data that is unique to that record so no records have the same value in the key field. Also with databases you can search them quickly to specific data so this saves a lot of time. I can use to different types on database and relational databases which would be very good for my system. I can also include sorts, queries and reports so this gives me a various amount of options. * Spreadsheet - Spreadsheets can be used in many ways. ...read more.


* What must be included - Microsoft Excel this will allow me to include most things such as; Macro's, input messages, output messages and different types of forms. * What it must look like - Microsoft excel will help me make the system look presentable as it has a variety of colours I can choose from. Also it has good fonts such as; Arial or times new roman. Microsoft excel also allows me to use clipart if needed. * What it must do formulae and functions you will need to use to make outputs and calculations happen - * Will a user guide be needed - Microsoft Excel would let me create a user guide by using a fresh new tab on the system then I could write all the information on that page. Process Table Process Function Table = Statements on Staff Login Page This process will determine the amount of what will be in the process box as it depends what cells I link to it. IF and = Statements help me or the user will out calculations very quickly so this is very easy for me to do. Also if the cell changes the = of if statement cell will automatically change Macro on Staff Login Page This process will automatically link with another page so when you click on it takes you to another page. I am using it for the customer's satisfaction so it will save time as it is an easy transport to a different page. ...read more.


on Customer Details Page House Phone, Telephone and D.O.B. Typing into cell letters or abbreviations An error message should appear telling the user to you only numbers please 7a - Model, Make, Colour, Talktime, Cost, General on Motorola, Nokia, Sony Ericsonn and Samsung Page Model, Make, Colour, Talktime, Cost, General Using VLOOKUP to refer to the cells so it will appear on the next page It should come up as normal and showing all the stuff in the table 7b - Model, Make, Colour, Talktime, Cost, General on Motorola, Nokia, Sony Ericsonn and Samsung Page Model, Make, Colour, Talktime, Cost, General Typing into the cells instead of using VLOOKUP An error message should appear as this....#NAME 8a - List boxes on Extras Page List boxes Linking the format control to the right cell The cell should change to true of false 8b - List boxes on Extras Page List boxes Not using Format control Nothing will happen as it will be linked to nothing. 9a - = Statements on Extras Page = statements Typing in the right = statement It should come up as normal either saying its price or 0. 9b - = Statements on Extras Page =statements Using spaces or different types of abbreviations except for commas and brackets An error box comes up explaining what you have done wrong with a various amount of options 10a - Spinner on delivery page spinner Left click on the spinner and it should go up and down It should go up and down 10b - Spinner on delivery page spinner Right click on the spinner and it should go up and down Nothing would happen as you are right clicking the spinner Edward Asaggar 11 Ward Mr Evans AQA Assignment ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays


    Enter F To see how validation system handles correct data To make sure that it accepts correct data 11. Enter cat To see how validation system reacts to erroneous data Data should not be accepted. User will be told to enter correct data Data entry form Test and data used Purpose for test Expected result Results after testing 12.

  2. GCSE Excel Project ICT

    be put in, as we wish to reference from cell D4 it will be inputted into the formula, the formula used this time is: =VLOOKUP($D$4,Shells,2). However, this means the end query, when it clears the value the VLOOKUP sources from it would create a #VALUE error.

  1. Database Design Guideline

    Expected Result A record of all patients that are seen by male doctors should be returned. Fields Used From doctor's form: Doctor ID, forename, surname and gender. Form doctor's form: Patient ID, forename, surname, ward and illness. Query Design - this is what the 10th query will look like in

  2. Database design.

    This can be found at the left-hand side of the screen. This is my customers data entry form to fill it in you must use the next customer ID which is 3 digits long then fill in the customers surname it will automatically start with a capital letter because there is an input mask in.

  1. Computer project Alevels

    All of these features can be entered by selecting the relevant button and then placing the function where ever you want on the form. * Adding fields You can add fields on to the form so that you can enter data through the form and then the data will be entered to the tables through the forms.

  2. Coursework 1A

    Ultimately, this catalogue will end up greatly benefiting the band, due to attracting far more sales through an easily accessible and developed design system, as well as age specific products. The catalogue even includes helpful information that you may want to learn about the band, and thus may even help in attracting fans.

  1. IT investigative process

    The sea just off the pacific coast has an amazing marine biodiversity and has some key spots for divers. 4) The Orinoquia Region: also referred to as the eastern plains, it is an enormous savannah with unique vegetation and wildlife.

  2. In this (2b) report I am going to investigate software application, Input and Output ...

    In libraries, each book is marked with a code, and borrower tickets also have a code which allows the computer system to match borrowers with books and return dates. A similar system is operated with items of luggage and their owners at airport.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work