• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

In this IT project, I am going to use Microsoft Excel to computerise and store the information in my faculty for my tutor who is the faculty head.

Extracts from this document...


Introduction BACKGROUND C omputers have many applications in the 21st century. Specific software such as databases and spreadsheets are designed to help, improve, speed up, and reduce the workload of certain tasks. In this IT project, I am going to use Microsoft Excel to computerise and store the information in my faculty for my tutor who is the faculty head. The aim of this project is to make it easier and more efficient for my tutor to access and update information of all the students. She will be able to: * Add new students * Edit student's details * Update progress details * Grade predictions * Compare student results with the class average * She can email this worksheet to her colleague, other school, Head of the Department etc. without using the paper. * She can display the student's performance on the graph, table, designed table etc. The project is based in Desborough School where my tutor - Mrs. Brennan works as a math teachers. She needs to calculate the average mark, overall performance, compare the individual results with the class average, predict grades of all the students in her faculty so that she can monitor their progress, and print out the student report. This is difficult with paperwork and very difficult to make amendments and not very user friendly, as it is very tedious. ...read more.


In year 11, I have 31 students What system do you have at home or school? E.g. Pentium processor, windows, and MS OFFICE? Well at home, I have Windows 95 and I do have office but I have no idea what is the version. About the school, I have no idea because I do not use the PC at the school. Do you know your way around Microsoft Excel? I have a basic knowledge, e.g. feeding in the student's names and marks but have no idea as to how to calculate the average marks etc. How good are you in computer? I am fairly competent. I have a basic knowledge of computing because I use my computer for working in WORD, EXCEL, and using Internet. From the interview, a number of problems were realised with the current system, of manually doing the work. It was said that the old way of doing things was far too slow and time consuming, and many mistakes were made with the data. So many records have to be manually put in and a lot of paper work done. This is where our new system would help. Also available for use at the school are Pentium PC�s running Windows 98 and a laser jet printer. The Windows system comes installed with Microsoft Office 97 and includes all the major programs (Word, Excel, and Access). ...read more.


Monitor 4 MB of Graphic card Software: Windows 95 or later (latest version will be the best) Microsoft office 97 or later (Word and excel are necessary) Microsoft outlook 97 or later (sending email or fax) Microsoft Outlook express 5 or later (sending email using the network) Microsoft Internet Explorer 5 or later (sending email using the web server like Yahoo! Or Hotmail) According to the interview, Mrs. Brennan has mentioned that she has a computer at home with Windows 95 and preinstalled Microsoft Office 97 or maybe later (she is not sure what it is). About the computer processor, RAM and other hardware, she feels that all the specification this system needs will definitely meet her computer at home, so the end-user have all the hardware and the software available. According to my research, I found that the school system is quite good for this system. All the hardware and software are available. In addition, Mrs.Brennan has a basic knowledge of computer and Microsoft Excel. We do not need an expert to run this system because its will be a user-friendly system. As I mentioned, all she has to do is to feed in the student's details and grades. Hence, she may not be familiar with this system but I believe she will like the system and enjoy it too! Shoaib Malik IT COURSEWORK 1 ...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. Computer project Alevels

    The entry must be 7 characters long. The first letter must be the letter M, the second letter must be C, and the third letter must be P followed by 4 numbers. E.g.: MCP1234 PATIENT NAME Text DOCTOR NAME Text DOCTOR ID Text Like "MCD###" Text you entered is invalid in the field DOCTOR_NO.

  2. Database Coursework

    This no certain length needed. Output Format Testing I decided to test the system by using a variety of data that would include examples that were inside and outside my specifications as this would test the data input aspects of the system.

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

    that are appropriate for the operator's language. Other keys can produce actions when pressed, and other actions are available by the simultaneous pressing of more than one action key. MOUSE- In computing, a mouse is a pointing device that functions by detecting two-dimensional motion relative to its supporting surface.

  2. GCSE Database Project ICT

    Service Pack 2 (2600.xpsp_sp2_qfe.070227-2300) Print technology Printing method 4-colour inkjet printer with Dual Black Ink System, Epson Micro Piezo(tm) print head Nozzle configuration 360 nozzles Black / 59 x 3 nozzles Colour (cyan, magenta, yellow) Droplet size 3 Pl (minimum)

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

    This makes the DS, with its touchscreen, the most successful and unrivalled system in terms of educational aspects. The DS has some other purposes other than gaming, as well. It can be used as an alarm, as a flip-note, as a memo and various other things.


    name, gender, from group, overall percentages mark, grade obtained and an automatic comment on progress. * The system should be able to produce chart, which will analysis student overall performance and also compare girls' and boys' performance. Processing * The system will put the names of student in alphabetical order.

  1. GCSE Calculator Project

    Measures 7" x 5" x 1.12". We could give the elderly a physical calculator that has big numbers, can talk and has a large display. These are available at www.eldercorner.com. The disadvantages are they cost money and they could potentially be stolen. Another alternative is the magnifier, to get a close up of what they are doing.

  2. This project is designed to help non-computerized library to easily keep track of their ...

    That would show that the system is too complex * The ultimate aim is to make sure that the program will calculate the income and expenditure of the library. SOFTWARE REQUIREMENTS: * Spreadsheet on Microsoft Excel * Microsoft world * Set up files for installation * Windows XP/2000/NT * Windows

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