• 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. ICT Project - Statement of the Problem

    The total amount of all the money taken by the club each Month will be entered under a special account under the accounts system. At the end of the year the expenses on the club will be taken away from all the money taken in by the club throughout the

  2. Different types of technology How I use ICT at home and at school

    You spend too much of your time on Facebook doing nothing when you could be doing something productive, doing something active while actually outside or anything at all. But instead, Facebook ultimately drags you in its social network and in the end, it's a time waste.


    Problems with Current System By interviewing Ms Gammon, I found out what her problems are with her current system. These include: * The current system is inaccurate and most of the time she makes mistakes. For example, when she is working out percentage and grades for each student, she often makes calculation errors.

  2. GCSE Calculator Project

    This is available in the accessories of the XP computer. A disadvantage is that the magnifier could make using the computer awkward because you have to move the cursor point over the bit you would like to magnify. Why is the ICT solution the ideal solution?

  1. ICT Report 2b: ICT in Organisations

    on the screen is also displayed on the screen - this is much quicker than using a keyboard and mouse, as you are constantly looking at the screen. A disadvantage of touch-screen technology is of its pricing. I think Boots would have to pay a great sum of money if

  2. Impact of ICT on the community

    It is also some time slow and takes time to download the page. And some teenagers do graffiti on information point and damage the point so it gives a bad image to my community. Possible development of the technology in the future Information Point is really useful for my community and it attract tourist.

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

    proficient; the term 'simple' in fact is a complete misdemeanour in describing a computer as it is anything but simple. The uses can range to storing movies, documents and music to browsing the innumerable amount of data on the world wide web to get hold of information about most, if not, anything.

  2. The impact of ICT on an adult in employment. The work of an Atif ...

    The swipe card machine allows Mr. Ajaib to save time by taking out the necessity of having to manually register everyone who attended the lesson, everyone who was late to the lesson and everyone who was absent. More focus can be put into getting the class to settle and going straight into working.

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