The ICT Project Essay Example for Free

The ICT Project EssayIntroductionI have been attached a task to find let out a factual end partr for my project who is shortly 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 substance abuser for my project it is one of my teachers in Sir John Cass, Mr Shah who is a happen upon skills ICT teacher. His acceptedly having a paper problem he needs to input lucubrate of individual educatee of their term report, his currently using a pen and a paper to input all in all the details much(prenominal) as the whole terms attendance, predicted social classs etc. The type of parcel I bequeathing be using is Spreadsheet because it is one of the criteria in my project. Spreadsheet is an application used to input information into t adequate to(p) graphs. This application provide 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 facilitate of input for drill I do not want to overcomplicate the outline. I will be using well cognise software called Microsoft Excel, which is ideal for the creation of t fitteds and graphs as stated earlier. I in this case will be weak to use interface. Although the end user is not adept to the use of ICT I will be creating the brass 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 late entries1. tout ensemble the employment is written down so there are human errors such as spell and when something like this is to happen you have to start over because on a formal piece of selective information there lowlifenot be mistakes this can be season consuming.2. Accuracy will be greatly change magnitude with the user friendly interface which in addition t o accuracy increases efficiency.3. You may not able to devote immediate electronic copies of information tables.4. The special features available with Excel (spreadsheet) are no longer an selection such as, immediate calculation, from entry, graphs and charts, etc.5. Most of the surnames and first names are the same it can be troublesome to find phone details, however with this frame you can have this information automatically strong with the name entry.Current SystemMr Shah teaches year 7 to year 11 bookmans for Key Skills ICT, the problems his currently confront is filling in individuals scholarly persons records such as their term report, attendance record, on the job(p) grade, everything on paper as it is a bit time consuming to find all the records of each educatees when filling in their report. Mr Shah is a very busy man as he is similarly the head of year of ICT key skills. The current trunk involves Mr Shah marking grades by using a pen and filling in term report s by manually and keeping records of individual students which involves writing everything on paper.Therefore I have stepped in to protagonist him with his problems. I will be mainly focusing on year 11 as it is chief(prenominal) 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 dodging is inaccurate and most of the time he bes mistakes. For example, when she is working out percentage and grades for each student, she often makes calculation errors.* It is very time consuming, especially the calculation of percentages win in marked worked and grades obtained overall.* As the names of students are not in rule 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 to mark your student work?What problems are you veneering with your current system?How would you want your current system to be improved?What do you think is the major(ip) failings in your current system?Have you ever used a computer for tracking label?Can you give me any samples of your current system?Is there a CD ROM repulse in your computer?Do you have a printer?How true 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 User Requirement story 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 create an effective, fast, and easy to use automated system to calculate her students label for her, which will enable her to solve her problem. They are the following things she expects to get from a computerized system.Input* She wants the freshly 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 calculate the percentage and grades of each student. This system will therefore make her work more(prenominal) accurate and easy to use.* Mr Shah wants the impertinently system to be able to enter student personal details, e.g. DOB, drill 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. issue* Mr Shah the new system to use twist coding when displaying grades of each student, e.g. Green for A*, Blue for A etc.* Mr Shah would like a report facility where she can select a student from a list and the report will show the stud ents name, gender, from group, overall percentages mark, grade obtained and an automatic notice on progress.* The system should be able to produce chart, which will analysis student overall coifance and also equalise 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 numerical attach to percentages.Storage* Mr Shah wants the new system to be able to enclose 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 sure the system is unspoiled and I will make sure it has a tribute code.Backup protocols are a necessity in the event that the master reduplicate 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 backup copy will be stored of site, so that if theres a natural disaster affecting the main site, the backup copy will remain. Plus, this method of backup can be described as differential backup, which practices a cumulative backup of changes from the conk full backup , allowing a full system restore based 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 fair play 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 source document that I have provided is a copy of tag 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 put 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 reduce 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 protected to prevent accidental swing.* It should automatically work out a students grade, based on overall percentage for all tests taken.* It should be able to generate an automated report for students showing 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 t ransfer the system. Ms Gammon has printer in her office, which will be used to print out reports of student performancePerformance CriteriaThese are the performance criteria that are liberation to be used in the new system that Mr Shah asked for* MR Shah will be able to correct mistakes that she ability make during marking this will make the system to be more neatly presented and pleasant.* It should be able to add and delete students if required.* The system will generate automated reports of each student by permeate 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 chart s should be generated quickly and easily 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 pivot 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 summ ary sheet, the pivot table on the sheet 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 highlight grade attained and also table displaying student grades.* Macros can be used to perform complex 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 exacting 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 entering student personal details, overall mark etc.* Protections of cell so that user cannot accidentally delete information.Stat ement of Input, Processing Output requirementThe input would bePersonal DetailsFirst namenicknameGenderDate of BirthFormRoll numberStudent marksAssignment 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 amongst 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.