• 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
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  • Level: GCSE
  • Subject: ICT
  • Word count: 2791


Extracts from this document...


Analysis Introduction: I have been given a task to find out a real end user for my project who is currently having problems with paper. I am brainstorming different types of techniques to improve the efficiency and quality of the paper based problem. I have found an end user for my project; it is one of my teachers in Sir John Cass, Mr Shah who is a key skills ICT teacher. His currently having a paper problem he needs to input details of individual student of their term report, his currently using a pen and a paper to input all the details such as the whole terms attendance, predicted grades etc. The type of software I will be using is Spreadsheet because it is one of the criteria in my project. Spreadsheet is an application used to input data into table graphs. This application will require basic computer (including input devices) and the spreadsheet application with a connected computer per unit. The way in which the spreadsheet will be constructed is a big factor when deciding its effectiveness and speed of input for example I do not want to overcomplicate the system. I will be using well known software called Microsoft Excel, which is ideal for the creation of table's and graphs as stated earlier. I in this case will be easy to use interface. Although the end user is not adept to the use of ICT I will be creating the system for a user with no ICT skills as this in a sense will speed up the input process further. ...read more.


Due to the non existent computer skills of the employees, an introduction into the use of computers is necessary. To accompany the basic skills they will acquire, I will need to develop a user manual which will provide detailed instructions in performing various tasks in the system as well as maintaining it, which is vital to its integrity and reliability. However, Victor has advised me to provide a manual of minimal size and contents in order to avoid confusion and enable the employees to read it swiftly, so they can get on with the job as soon as possible. Source Documents The source document that I have provided is a copy of marks book that Mr Shah uses to record her student marks. As you can see there is a lot of data to be inputted by hand. This is one of the problems that Mr Shah has. The calculations of total mark and overall have to make using calculator, which is time consuming. Objectives of the new system * The new system will perform the following tasks: * It should be able to identify students with poor performance by using a visual alert. * Ability to edit incorrect mark, so whenever Ms Gammon make an accidental mistake, she will have the ability to correct it. * The system should be able to produce average performance percentage of each student for her class. * It should have the ability to Edit and Delete students' details if required, thorough the use of data forms. * Easy and clear to use. * It should automatically calculate percentages and grades from the inputted a student marks and maximum mark available for each test. ...read more.


Corner SE1 9UH 012 7689 3946 I will also use grade boundaries and colour coded: 85% A* Green 75% A Yellow 65% B Blue 55% C Black 45%+ D Pink 35% E Brown 20% F White 19% U Red 0% U Red Test 1 16 Test 2 15 Test 3 13 Other data that I will use is to convert numerical values to percentages. Each test they will take will have minimum and maximum marks. E.g. 3 three test Global Diagram Implementation In order for me to start my project I need to use spreadsheet to start the project, I clicked on Start and the clicked on programs and then clicked on ICT and opened up Microsoft Excel. After clicking on Microsoft Excel, the programmed had opened up, as you can see a screenshot below how the spreadsheet looks like. After opening Excel I started creating my user form, I will show the steps of me creating the form. As you can see above I clicked on Tools and the clicked on macro and opened up Visual basic editor, as you can see below what had come up next on the screen. I then chose to add macro buttons in the user form to perform specific tasks; I clicked on one of the icons to create a macro button. As you can see below the icons I chose was the command button. After adding macro buttons I then chose to add a background picture. I added a picture by clicking on a icon pictured below. As you can see below after choosing a background it had come up on the screen below. This is the main menu when you open the system up. ...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

  1. GCSE Excel Project ICT

    mean associating customers to a date, which is a shared value, not something individual like their name, which is the standard arbitrary value. Two alternate software solutions considered There are two computerised options within Microsoft both are within the Microsoft Office 2007 Suite.

  2. ICT Project - Statement of the Problem

    * Create mail merge to existing club members informing them of any promotions or changes to the club. * Hold an order sheet for the order of more drinks, glasses etc which will be printed out when necessary and sent to one or both of the suppliers.

  1. AO4 ICT c/wk 2008-9

    have lots of books that can be found for one, usually very simple topic. The young learners of today resort to the Internet for information which they think is true, however they don't recognize is that the information found in books is the most reliable around.

  2. Impact of ICT on the community

    How does the technology meet the needs of my community? Bar code Scanner meets the needs of my community as it convenient for the people of my community. It also helps as cashier can't cheat with their customers as they can't charge people higher price which all computerised and all

  1. a level ict project

    However, Victor feels that there are various imperfections which need to be eliminated and improvements that need to be applied: 1st. The amount of archives is increasing rapidly as Victor's garage comes more popular, as a result paper is being misplaced and lost, and they are running out of places to store the paper where they can easily reach it.

  2. The impact of ICT on a person with special/particular needs

    Disadvantages (How it does not meet Sarah's needs) However, Sarah has essentially given up on a social life outside Facebook. While she may consider herself to have a social life due to being socially active on Facebook, it doesn't necessarily count as she does not go out in real life. Sarah has also become too reliant on Facebook.

  1. Developing the Mathematics Curriculum: Using ICT to teach angles

    simply putting the shapes in groups of colour or the number of sides they have. But for the more able, I would challenge them to think more about angles in the shapes. Possible questions to prompt thinking are: * What about right angles? * What about the symmetry of shapes?

  2. System requirements analysis

    My software does not automatically save, so if there is a sudden power cut, then all the data that was not stores will be deleted. The doctor and/or receptionist would have to save every time the made changes to the software; this is not a reliable technique as they may forget to do so.

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