The ICT Project Essay Example for Free

The ICT Project EssayIntroductionI have been given a task to find knocked out(p) a real end drug social functionr for my project who is currently having businesss with wallpaper. I am brainstorming different types of techniques to improve the efficiency and quality of the paper plant problem. I have found an end user for my project it is one of my t severallyers in Sir John Cass, Mr Shah who is a key skills ICT teacher. His currently having a paper problem he needs to stimulant details of individual disciple of their marge report, his currently using a pen and a paper to input whole the details such as the whole terms attendance, predicted grades etc. The type of softw ar I go away be using is Spreadsheet because it is one of the criteria in my project. Spreadsheet is an action used to input data into table graphs. This application provide require basic computer (including input devices) and the spreadsheet application with a connected computer per unit. The mien in which the spreadsheet result be constructed is a big factor when deciding its effectiveness and speed of input for example I do non destiny to overcomplicate the frame. I go out be using well known softw are called Microsoft Excel, which is ideal for the creation of tables and graphs as stated earlier. I in this case forget be easy to use interface. Although the end user is not adept to the use of ICT I will be creating the dust for a user with no ICT skills as this in a sense will speed up the input process further.Why not continue the old methods of registry and deeply entries1. All the work is written down so there are human errors such as spelling and when something like this is to happen you have to abrasion over because on a formal piece of information there screwingnot be mis canvasss this can be clock consuming.2. Accuracy will be greatly increased with the user friendly interface which in addition to accuracy increases efficiency.3. You may not able to make im mediate electronic copies of information tables.4. The additional features available with Excel (spreadsheet) are no longer an plectrum such as, immediate calculation, from entry, graphs and charts, etc.5. Most of the surnames and first names are the same it can be difficult to find phone details, however with this schema you can have this information self-loadingally loaded with the name entry.Current SystemMr Shah teaches socio-economic class 7 to year 11 students for Key Skills ICT, the problems his currently facing is filling in individuals students records such as their term report, attendance record, working grade, everything on paper as it is a bit time consuming to find all the records of each students when filling in their report. Mr Shah is a very busy man as he is withal the head of year of ICT key skills. The current system involves Mr Shah marking grades by using a pen and filling in term reports by manually and keeping records of individual students which involv es writing everything on paper.Therefore I have stepped in to help him with his problems. I will be in the main focusing on year 11 as it is important for them because their about to face their exams.Problems with Current SystemBy reviewing Mr Shahs problem I have found out what the current common mistakes happened to be, they are* The current system is inaccurate and most of the time he makes mistakes. For example, when she is working out percentage and grades for each student, she oftentimes makes calculation errors.* It is very time consuming, especially the calculation of percentages attained in marked worked and grades obtained overall.* As the names of students are not in order he finds it difficult to find the student to record a mark.* The report could easily get lost.* Also writing in individual names several times, which is time consuming.Interviewed QuestionsWhat is your position at this school?What type of system do you use for your mark tracks?What method do you use t o mark your student work?What problems are you facing with your current system?How would you want your current system to be improved?What do you think is the major failings in your current system? establish you ever used a computer for tracking mark?Can you give me any samples of your current system?Is there a CD read-only memory drive in your computer?Do you have a printer?How certain are you when using computers?How certain are you when using Excel?What features and functions are you aware of in Excel?Do you keep all your records?Do you have any additional questions?End substance abuser RequirementStatement of user requirementsMr Shah feels a computerized system will solve some of her current problems as she thinks she has some knowledge about Excel. She feels I will be able to pass water an effective, fast, and easy to use automated system to rate her students marks for her, which will enable her to solve her problem. They are the following things she expects to get from a com puterized system.Input* She wants the youthful system to enable her to make management decisions that she uses to support student, which need help, whether parents need contacting, whether other action is required e.g. Detention.* The system should automatically shoot for the percentage and grades of each student. This system will therefore make her work more accurate and easy to use.* Mr Shah wants the new system to be able to enter student private details, e.g. DOB, tutor group, surname, etc.* She wants the new system to be able to edit student personal details. Also she wants the system to able to delete student personal details if a student moves form her teaching group.Output* Mr Shah the new system to use colour coding when displaying grades of each student, e.g. Green for A*, coloured for A etc.* Mr Shah would like a report facility where she can select a student from a list and the report will supply the students name, sexual practice, from group, overall percentages m ark, grade obtained and an automatic comment on progress.* The system should be able to produce chart, which will analysis student overall action and in addition compare girls and boys performance.Processing* The system will put the names of student in alphabetical order.* Mr Shah wants the new system to automatically convert mathematical marks to percentages.Storage* Mr Shah wants the new system to be able to store 30 students personal detail and also store results for up to 70 tests.* Finally, the new system should not be used by anyone else except Mr Shah, I will make indisputable the system is safe and I will make sure it has a security code.Backup protocols are a necessity in the event that the master copy is lost or destroyed. Backup up will be provided by an external hard drive, and the system will be backed up periodically, i.e. every week, or in special circumstances, for example, there is a significant in take of data into the system. Furthermore, the supporting copy will be stored of site, so that if theres a natural disaster affecting the main site, the respite copy will remain. Plus, this method of backup can be described as differential backup, which practices a cumulative backup of changes from the last full backup , allowing a full system restore base upon the last full backup.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 DocumentsThe seminal fluid 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 big bucks 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 monstrous mark, so whenever Ms Gammon make an accidental mistake, she will have the ability to line up 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.* Cell, formulae protect to prevent accidental deletion.* It should automatically work out a studen ts grade, based on overall percentage for all tests taken.* It should be able to generate an automated report for students demonstrate student performance.* Password (security) on file access.* It should automatically colour code student grades.User Skill LevelMr Shah has used Microsoft Excel but does not use it to calculate percentage, and grades of her marks. She is an average user, which means she does not understand most of the advanced features. Such as Vlookup, IF Statement, Macros, etc.Project ConstraintsMr Shah uses school standard PC that I will be using to calculate percentages and grades for the new system. It has a four processor, which has 512 MB of RAM and 30 GB hard disk. It has Microsoft software including the excel 2000. Mr Shah Pc has CD Rom, USB and floppy drive, which are also connected to school network. This will make my work to be easy when loading the new system onto her computer because I can store it on the CD or floppy disk and transfer the system. Ms Gam mon has printer in her office, which will be used to print out reports of student performancePerformance CriteriaThese are the performance criteria that are going to be used in the new system that Mr Shah asked for* MR Shah will be able to correct mistakes that she might make during marking this will make the system to be more neatly presended and pleasant.* It should be able to add and delete students if required.* The system will generate automated reports of each student by click of a button showing their performance that can be sent to parent.* It will be easy and clear to use.* The new system will produce an average performance percentage for each student. And also it will automatically convert numerical marks to percentages.* It should have protection to prevent accidental deletion of important formulae, numbers, table, chart and text. All the sheet and cells in the system must be protected with security to prevent these.* Graph and charts should be generated quickly and easil y to compare boys and girls performance, All student and by form.* The new system will not take more than 4seconds to view performance and grades for each student.* The system will generate automated colour coding when displaying grades of each student.* The system will store 40 student personal details, and also store results for up to 50 tests.* Mr Shah will be able to select student from a list and the report will show the students name, gender, overall percentage mark, grade obtained and an automatic comment on progress.DesignChoice of SoftwareI think that Microsoft Excel is the best option of software because it has got many features such as* It has advanced functionality such as rowlock table, sort, forms, Vlookup, average, and write protection. This will make things more automated for the user.* Pivot this will hold table for charts. This will not need to be seen by the user. When they select the chart that they require on the student summary sheet, the pivot table on the sh eet will change to represent that choice. It will also used to summaries archive data for use in charts showing1. By gender2. Form* Data entry form will be able to edit and delete student records.* Conditional formatting will allow automatic shading of cells to give visual message for highlighting grade attained and also table displaying student grades.* Macros can be used to perform intricate tasks at the press of a single button.* It can perform complex calculation such as working out the grade for each student.* User Forms for controlling actions with macros using buttons.* Chart /Graph can be used to display output of information such as averages, predicted grades etc.* The user wants the system to be as error-free as possible. Excels Validation facility will allow me to set up range validation to control data input when entry student personal details, overall mark etc.* Protections of cell so that user cannot accidentally delete information.Statement of Input, Processing Out put requirementThe input would bePersonal DetailsFirst nameSurnameGenderDate of BirthFormRoll numberStudent marks appellative marksMaximum /minimum markGrade BoundariesThe Processing would beCalculating the grades through a Vlookup to the grade boundaries table.Sorting, grouping and summarizing data with a pivot table.Calculate the average of total marksUsing Vlookup work out a grade for the average.The output would bePivot Chart/Graph showing comparisons between gender, form-by-form and overall year group achievement.Give students their grades using report card.Table displaying student grades.Creating report for using student with performance.School letter, which would be sent out to parent using conditional formatting to highlighting grade attained.Data SetBecause of Data Production Act, I cannot be able to use the real detail of Mr Shah Students. For that reason, I will create my own data set of example student details, which I will work with.