ITGS Project Report - IGCSE-IBDP-IT-IIS
Contents
1. pc s or laptops as MS Mi L S SENS Access is compatible on the same For mac msun ki Eaplop Samsung platform MS Office needs to be loaded R40 CPU Pentium 2 or above 1Ghz As my program works on windows 97 and 2003 higher processor speed will help in fast Pentium4 1 6Ghz processing If the processor speed is low with large volumes of data the system will run slow and may hang as well RAM 64mb Higher RAM space compulsory for database application as it needs to sort and query data 512mb from large databases Peripheral Devices Printer Laser or Ink jet printer for the reports UPS Backup power supply Pen drive or CD Useful for backing up the data Minimum Software Required Windows 98 Windows XP or Windows Vista Operating System Windows XP Home edition2 Operating systems are compulsory for any system to work As MS Access 2007 is GUI based a GUI based operating system will support the program well Microsoft Access 2003 or Microsoft Access 2007 Database System Microsoft Access 2007 MS Access is the best as it come as a pack with ms office and it is easy to integrate with word and excel It is quit standard software is excellent features and options 16 of 33 Song Boyoung 002272 085 Sec 2010 The PC CPU RAM is needed to run the computer which will operate the software My product is made by the Microsof2. Daaacic La 41 0 14 of 33 Song Boyoung No 002272 085 Sec 2010 Adding Macro B Main Form Commands Click eue mlEvent ze lists 7A Eventwise Result s GSE Bs 2 EI 08 Eventwise prize bsts 371 4 Whee 228 NA OBL NAT HVE WE AFE UA zoc 13 BAS SIMS BER vell Xe 71 18 SEUAIS House Points House Point House Point Houses sum of house point Hercules 50 Orion 31 Pegasus 42 Phoenix 27 Eventwise Prize Winners Master1 a Event Grade Position House Character Dramatization j Nayanthara 10 Third Orion SarayuAcharya 9 First Pegasus Simran 9 Second Hercules Character Dramatization s Vijayta Narang First Phoenix Arika Fyzee 11 Second Orion Sonali Rau 8 Third Pegasus Flower Arrangement j Tejaswini 10 Second Orion Suruchi 12 Third Orion Sai Aditya 11 First Orion Flower Arrangement s Akta Gupta 10 Second Pegasus Manju Shah 6 Third Hercules Stuti Aggarwal 8 First Phoenix Graffiti j Lavanya Valluri 8 Third Orion Manju Shah 6 First Hercules Stuti Aggarwal 8 Phoenix Graffiti s Akansha Second Hercules i MON 15 of 33 Song Boyoung 002272 085 Sec 2010 Minimum Hardware Required PC Laptop or Desktop We need tohave
3. The only software needed except the Operating system is the Microsoft Access This is very easy to install and widely spread in the world So that it would be very easy to install and use In the school usually there are the computers for the teachers and also even if there is no coordinator in the school for the program this product can be used as it is very simple and easy to use Anyone can use this when they are trained for an hour No need more than that so this can be used anywhere and by anyone in the world 21 of 33 Song Boyoung No 002272 085 Sec 2010 22 of 33 Song Boyoung 002272 085 Sec 2010 Appendix QUESTIONNAIRE 1 Name Bhaskar Menon Designation Activity counsellor School Indus International School Date of Testing 10 Sept 2009 1 Do you find the product easy to use Yes It was very comfortable to use even though I am not familiar with Microsoft Access in general The program was very simple and comfortable The only thing I needed was clicking what I wants Do you find any difficulties in the product There was no difficulty to use the products but some features were coming slow Do you think anything should be added for the better products Yes the result of this is not easy to see It will be much better if the result can be organized in event wise Do you think the products are properly organized The data was divided into the suitable sections so I thin
4. database Because of the presence of search Not every computer has this software so feature data can be accessed easily if it s not there the installation is needed Queries and reports can be made which Ilt occupies lots of sizes compare to would be very helpful for the user Spreadsheet More than two tables can be related together therefore better reports and forms can be made Easy to print the report using wizard and also better to look by using forms 8 of 33 Song Boyoung 002272 085 Sec 2010 Feasibility Study The time will be taken more for the Microsoft Access however as they are part of the Microsoft Office there will be no cost difference between them Microsoft Access has the function of inputting the spreadsheet file but the Excel there is not Justification of chosen approach As the result of the analysis between both possible IT approaches the use of Microsoft Access would be better solution than using Microsoft Excel What we need for the present problem is the database Microsoft Access is the program for the database and it will be more reasonable than Microsoft Excel as it contains wizards and search features which would help the managing of data easier We can relate more than two tables so that it is easier to produce the forms For example we can make the table of student event and so on separately and can relate them together in one query and produce report which the spreadshee
5. is also him as he is only the user can get what he needs what she wants Other users using the system would be school captain activity incharge captain and the activity department Criterion H Analysis and feasibility study There are many possible ways to solve the problem about the calculations and the reports about the scores for each houses System software has to have the capability of calculations and it is better to make the report to ensure that it is easy to look at The two softwares that l m going to compare for my project are the spreadsheet and the database 6 of 33 Song Boyoung 002272 085 Sec 2010 IT Approach 1 Spreadsheet As in many of the businesses and the schools use the Microsoft Excel which is the software for the spreadsheet It contains the faculty something like calculations graphs and tables Therefore actually it is helpful and user friendly For my project Simple calculation of the events it can be very suitable because the tables are easy to make calculations and the graph as well are very easy to produce using the spreadsheet The spreadsheet is much familiar than the database in the world Advantages Disadvantages It is the suitable software for the simple calculations or to make the charts It is not organized compare to the database Graphs are also made easily therefore easy to compare the data using the graph Only have rows and columns therefor
6. of 33 Song Boyoung No 002272 085 Sec 2010 32 of 33 Song Boyoung 002272 085 Sec 2010 BIBOLOGRAPHY http www coloradomtn edu 33 of 33
7. 1 Hercules Akruti 18 12 Orion Akta Gupta 16 10 Pegasus Anish 14 9 Phoenix Arika Fyzee 17 11 Orion Arjun 17 12 Orion Avinash Pras 16 10 Pegasus Ayana 15 9 Pegasus Bhavana Mer 15 10 Pegasus Dishan 18 12 Pegasus Feroz 16 11 Hercules Hamsini 17 11 Phoenix Hayoung 19 12 Hercules Karthik 17 11 Hercules Katyani 18 10 Hercules Lavanya Vall 13 8 Orion Manju Shah 11 6 Hercules 1 ae amp Hus za Final Results This table will lead you to the master table which you have to enter the final data of the cultural week With this final data the final reports forms and the calculation of the events are coming automatically Master IUBE Event Position Sarayu Character Dramatization j First Simran Character Dramatization j Second Nayanthara Character Dramatization j Third Arika Fyzee Character Dramatization s Second Sonali Rau Character Dramatization s Third Vijayta Narang Character Dramatization s First Sai Aditya Flower Arrangement j First Suruchi Flower Arrangement j Third Tejaswini Flower Arrangement j Second Akta Gupta Flower Arrangement s Second Manju Shah Flower Arrangement s Third Stuti Aggarwal Flower Arrangement s First Stuti Aggarwal Graffiti j Second Lavanya Valluri Graffiti j Third Manju Shah Graffiti j First Adit Sharma Graffiti s First Akansha Graffiti s Second gt so nee KBE zs zn 31
8. EDIMPAQCUT sete e toin iir tal er RR Fer balan TREND REOR Eus 21 7 guber E 23 QUESTIONNAIRE RERO B OEC 23 OUESTIONNAIREB 2 55 he Rd et p et Rr e a ERU es 25 QUESTIONNAIRE3J et EORR SR NOR GEB TER EATEN 27 4 of 33 Song Boyoung 002272 085 Sec 2010 Criterion G Identifying a problem within a social context In my school the students are divided to 4 houses which are Orion Phoenix Pegasus and Hercules Any activities we do the records and scores are given to each house when if the students win the prises and in any activities Inadequacies of the present system With reference to the discussion had with Ms Shruti Kotian our Activities Coordinator in the month of Feb Currently the calculations are getting done manually by our activity coordinator The problem is that there many chances of the humanistic errors which can exist during the calculations and also it takes lots of times because there are lots of things which gives scores or points to the respective houses She needs to check several times to ensure that calculations are correct So the calculations will take some times and the chance of error or mistakes exists Also she is making the list of students who won the competition and should get the prises She is making the list of those students and the reports manually which will take lots of time to make Problem in a social context These
9. POINTS 15 BVENEWISEPRIZE WINNERS aec OE ER E ERE SEE ERREUR CEA FERAE NER VERUS 15 Song Boyoung C 002272 085 Sec 2010 MINIMUM HARDWARE REQUIRED rtr ca dra d reo eer eer ana eT Ld v RU EN Ra Fe Lea e Fano roa s el ed Ead ea cba ce aR 16 PERIPHERAL DEVICES c cccscscesssscssssscsssscessescssssccsscscessescsescessuscssesscseecessesesseecessescssssscsescessescessssesesesseseessesenss 16 MINIMUM SOFTWARE REQUIRED suori terie 16 CLIENT HARDWARE AND SOFTWARE cccccesssscesssccessscesscscesssscssescessescssseceessscesssscsassessescsssescsssesessuseessescesssscessesens 17 DATA COLLECTIONS 5 AE rri e ERE Cr 17 CRITERION J TESTING AND EVALUATION scccsssscssscccssscccsscccsscecenscccsscccescesenscecesccsenscsessccseescesens 18 FIRST BETA TESTER BHASKAR MENON ACTIVITY COUNSELLOR ccccccssscesssecsssecesseecsssecesseecsessecssecseseesseeeess 18 SECOND BETA TESTER MR JAYAN PIEEIP ERR UE EAE EE 19 END USER ACTIVITY COORDINATOR 5040 uode dram ee dee eec n ER 21 CRITERION ASSESSING THE SOCIAL SIGNIFICANCE OF THE PRODUCT 21 PROJECTED IMPACT TREE o Rn et n RED CR ERE rod a en feels 21 OBSERV
10. Song Boyoung No 002272 085 Sec 2010 IT GS Project Report Eg Main Form Title Event Management System Candidate s name Boyoung Song Candidate number 002272 085 School Indus International School Teacher Mohan Robert Standard Level of ITGS Word Count 2495 1 of 33 Song Boyoung No 002272 085 Sec 2010 2 of 33 Song Boyoung 002272 085 Sec 2010 TABLE OF CONTENTS TABLE GLO MU OM cL 3 CRITERION IDENTIFYING A PROBLEM WITHIN A SOCIAL eene 5 INADEQUACIES OF THE PRESENT 6 8 1 nennen entres nensi 5 PROBLEM IN A SOCIAL CONTEXT cccssccssssecsssseesscecssseecsecsccsssecessecessseccusecesseessasecesasecsssecceaeecssseesssecesaeeceeseeesteeeeses 5 BENEFITS OR OUTCOMES OF AN SOLUTION eese nennen 6 CRITERION ANALYSIS AND FEASIBILITY STUDY 0 ccccsoccssscccsssccesscccssscccsscccesscccescccesscccessceeesse 6 IT APPROACH 1 SPREADSHEET ccccccsssecsssscesscecsseecssseccsseecessecesssecesaeecsssecesssecesaseeessececaeecseseeesseecesasecssseeesreceees 7 TT APPROAGH 2 DATABASE ME e ai de RA 8 FEASIBIEIEY S T DY e vr bc t 9 JUSTIFICATION OF CHOSEN APPROACH ccssssccssssscssssccsssscsssc
11. Suti Aggarwal FlowerAmangemenxs First Feroz 16 11 Hercules Suti Aggarwal Graffiri Second Hamsini 17 11 Phoenix Lavanya Vallur Graffizi j Third 9 Hayoung 19 12 Hercules Manju Shah Graffizi First ang ne s 4 4 ue created the submenu to edit data to separate opening master table which will record the result and the student table which have student information 20 of 33 Song Boyoung 002272 085 Sec 2010 End User Activity Coordinator He was very impressed by the product This product is very easy to look at and also in editing the data there is no difficulty He is the activity coordinator so he is the one who manage every event in the school Therefore he is the end user for this product Criterion K Assessing the Social Significance of the Product Projected impact This project was mainly to help our activity coordinator in our school This product can expand further and globally because in many schools there are the teams made and many competitions happening My product was mainly to calculate that which team comes first in the competition Therefore it can be used in any school where the interschool competition is happening Observed impact This product is very easy to insert and change the data Therefore the user of this the coordinator of the school can be benefiting with this a lot
12. be E XE via Grade House 9 Hercules 21 Orion iN 11 Hercules Akruti 12 Orion f Akta Gupta 16 10 Pegasus E Anish 14 9 Phoenix _ B Arika Fyzee 17 11 Arjun 17 12 Avinash Pras 16 10 Pegasus 15 9 Pegasus 10 Pegasus Age Ayana amp Bhavana Mer 15 amp Dishan E Feroz Hamsini Hayoung Karthik Katyani 18 16 17 19 17 18 12 1 11 12 11 10 Pegasus Hercules Phoenix Hercules Hercules Hercules Orion Lavanya Vall 13 8 E Manju Shah 11 E Nayanthara 15 6 10 Hercules Orion 18 Neha E 18 12 11 Pegasus Motes agam 1 41 ax Pn 85 13 of 33 zs Y Song Boyoung No 002272 085 Sec 2010 Event Table Event Category Junior Senior Junior Senior Junior Senior Junior Senior Junior Senior Junior Senior Junior Senior Junior Type Individual Individual Group Group Group Group Individual Individual Group Group Individual Individual Individual Individual Individual Individual Group Group Group Individual 8 Character Dramatization j jg Character Dramatization s amp Debate j jE Character Dramatization Debate Fancy Dress Flower Arrangement Graffiti Indian Classical Dance Mime Quiz Recitation Short story writing Teachers Group Dance Western Dance E Western Music Senior E Grade12 _ E Qu
13. current problem Yes This product will be very helpful to the current activity coordinator Tester Signature 25 of 33 Song Boyoung 002272 085 Sec 2010 26 of 33 Song Boyoung 002272 085 Sec 2010 QUESTIONNAIRE 3 Name Shruti Kotian Qualification Activity counsellor Office Indus International School Date of Testing 10 Dec 2009 1 Do you find the product easy to use Yes it is clear and user friendly 2 Do you find any difficulties in the product No 3 Do you think anything should be added for the better products Will use for some time and then give feedback Right now it looks fine 4 Do you think the products are properly organized Yes But you can work to give it a more sophisticated look 5 Do you think this product is helpful to solve the current problem Yes Totally Tester Signature 27 of 33 Song Boyoung 002272 085 Sec 2010 28 of 33 Song Boyoung No 002272 085 Sec 2010 Instruction for the program 1 Double click on the icon labeled Cultural week 2 When you open it you will see something like this Es Main Form Enter Finalists Jul INDUS Eventwise result Fas 1 1 Enter Finalists 1 When you click on it the form looks like below is coming Es Master Query x Master Query Event Graffi
14. e there is a limitation Easy to learn compare to the database Excess No relationship of the tables Many formulas like lookup and if function Large volumes of data cannot be used Not user friendly in terms of structure of queries reports and forms Takes more time to train the end users 7 of 33 Song Boyoung 002272 085 Sec 2010 IT Approach 2 Database Access is the small database program A database is a collection of data that is stored in a computer and that can easily be used and added to We can make a small program using the database easily Using Microsoft Access first of all it s easy to make the table and queries with the help of the wizard Each and every steps there is a wizard so that it is more comfortable to produce or adjust the data easily Using query we can easily filter the specific data in the database and also has the ability for the reports we can produce good report using this as well Also for the users it is much easier to use because when the program is developed the things to do for the user is only the importing data and they will get what they want It is very simple for the users however for the producers they will need to have the technological ideas and skills Advantages Disadvantages It is easy to create the tables queries Such things like pictures videos and and reports with help of the wizards charts cannot be stored in one
15. ecssecesseeceusecsssscssssecsssseeseescseasecsescesssecesaeecssseeesesenses 9 CRITERION I PLANNING THE CHOSEN IT SOLUTION cccssoscssscccssccccsssccesscccssccessccesscccssccsees 10 SCHEDULE a nea tete ari tue ett t v uw e rb uti ote i Fe 10 DESIGNER ERE ERE RUN E RE I EI RR Ns 10 APPROACHING TOWARDS THE TOPICS JANUARY 20009 10 COLLECTING THE DATA OF THE COMPETITIONS FEBRUARY 2009 11 MAKING THE PRODUCT JUNE 2009 AUGUST 2009 11 TESTING AND EVALUATION OF THE PRODUCTS AUGUST OCTOBER 2009 11 CREATING THE REPORTS SEPTEMBER 2009 NOVEMBER 2009 80 441 1 210 00 0000000000000000 11 8 25 12 MAWN TETTE EI ib tastes 12 E V AM 12 MASTER E uPLIE 13 STUDENT RNE A ote tepida ir n ba Fo die pattes bred e 13 BVENT EABEE 6 25 mE B E E RN RE ER fs ates A er ae eee oM 14 MASTER QUERY sissies Ses Greene iit men i n t OR a E DI oa edes 14 ADDING nter Soa tee t i D AV ERO T A YR E CX e OR rep Ed 15 HOUSE
16. iz j Junior E Quiz s Senior jg Recitation j iunior Recitation s Senior Master Query E Master Query Grade Age Event 4 Position House HousePoii 4 ayanthara 10 15 Character Dramatization j Third Orion 1 SarayuAcharya 9 15 Character Dramatization j First Pegasus 5 Simran 9 15 Character Dramatization j Second Hercules 3 Vijayta Narang 11 17 Character Dramatization s First Phoenix 5 Arika Fyzee 11 17 Character Dramatization s Second Orion 3 Sonali Rau 8 14 Character Dramatization s Third Pegasus 1 X Tejaswini 10 16 Flower Arrangement j Second Orion 3 Suruchi 12 18 Flower Arrangement j Third Orion 1 Sai Aditya 11 17 Flower Arrangement j First Orion 5 Akta Gupta 10 16 Flower Arrangement s Second Pegasus 3 Manju Shah 6 11 Flower Arrangement s Third Hercules 1 Stuti Aggarwal 8 14 Flower Arrangement s First Phoenix 5 Lavanya Valluri 8 13 Graffiti j Third Orion 1 Manju Shah 6 11 Graffiti j First Hercules 5 Stuti Aggarwal 8 14 Graffiti j Second Phoenix 3 Akansha 11 17 Graffiti s Second Hercules 3 Adit Sharma 9 15 Graffiti s First Hercules 5 Hamsini 11 17 Graffiti s Third Phoenix 1 Akruti 12 18 Indian Classical Dance s First Orion 5 Varshini 9 15 Indian Classical Dance s Second Phoenix 3 Manju Shah 6 Indian Classical Dance s Third Hercules 1 i Hi EY Indian Clacciesl facand
17. k it is very organized Do you think this product is helpful to solve the current problem This program gives the reports automatically So that the time will be reduced as he was doing it manually Tester Signature 23 of 33 Song Boyoung 002272 085 Sec 2010 24 of 33 Song Boyoung 002272 085 Sec 2010 QUESTIONNAIRE 2 Name Mr Jayakumar Designation ICT Technical Staff School Indus International School Date of Testing 15 Sept 2009 l Do you find the product easy to use It s a very user friendly product as everything one needed to know was given in the instruction manual itself Do you find any difficulties in the product encountered no problems while using the program but I feel that the data should have been more categorized You put three data types in one cell and this made the database disorganized in a way Do you think anything should be added for the better products I think it would be better if the data is easier to change Especially the student and the activity data the data of student is changing for every year Also the activities can be added or deleted Therefore it should be easy to change However it is wonderful idea that he made each tables for students activities and so on Do you think the products are properly organized I felt that the existence of tables and forms made the program very organized Do you think this product is helpful to solve the
18. matization s Third Character Dramatization s First Flower Arrangement First Flower Arrangement Third Tejaswini Flower Arrangement Second Akta Gupta Arrangemer Second Manju Shah Flower Arrangementis Third Stuti Aggarwal Flower Arrangement s First Stuti Aggarwal _ Second Lavanya Valluri Graffiti Third Manju Shah Graffiti first Adit Sharma Graffiti s First Akansha Graffiti s Second Hamsini Graffiti s Third Manju Shah Indian Classical Dance s Third ndianClassial Dance s Fist 0 0 0 0 0 0 150 PT After Edit Datas E3 Edit Table n Editing Data Student Info Final Results Studen mw Age Grade House Event Position NET 15 9 Hercules Sara Character Dromatizaticnij First a Aditya P 17 11 Orion Smran Character Dramatizationj Second 3 Akansha 17 11 Hercules _ Nayanthara Character Dramatizationij Third Akruti 18 12 Orion Arika Fyzee Character Drematizationis Second 9 Akte Gupta 16 10 Pegasus Sonali Rau Character Dramatizaticnis Third Anish 14 9 Phoenix Vijayta Narang Character Dramatizaticnis First Arika Fyzee 17 11 Orion Sai Aditya Flower Arrangement First 9 Arjun 17 12 Orion S ruchi HowerAmangemen j Avinash Pras 16 10 Pegasus Tsjaswini Flower Arrangemen j Second 3 Ayana 15 9 Pegasus Akte Gupta HowerAmangemen s Second Bhavana Mer 15 10 Pegasus Marju Shah HowerAmangemen s Third amp Dishan 18 12 asus
19. might make the entire school upset when if there is an error on the data especially the students and teachers who are the part of the house Also if the scores or the data are coming late we have to wait for the long time with the curiosity If it delays to come some of us will get angry We are willing to know the 1 Appendix Interview with our activity coordinator 5 of 33 Song Boyoung 002272 085 Sec 2010 positions of the houses because we made lots of efforts to bring us up Therefore it is bad to the activity coordinator as well as the entire people in the school Benefits or outcomes of an IT solution Whereas if it is done by the computer there will be no error unless we type the wrong data table which means there will not be any errors during calculations Also time would be also saved much for our activity coordinator because the calculations are done automatically and immediately He doesn t have to validate for calculations but only data that he entered The report of the student list that who has to get the prises also can be done automatically so that he would benefit a lot with this product Not only for the calculations the table and the data is going to be more organized It has a function of searching so takes less time to search the information what he wants would become easier The end user of this product will obviously be our Activity Coordinator Ms Shruti Kotian and the client for this product
20. nior Group amp Quiz s Senior Group Recitation j Junior Individual 9 Recitation s Senior Individual JZE 4 28 Gaon Form ae Enter Finalists Edit Datas Finalists Eg master Query Saxe gt tame 2 Grade Age 23 Event Recitation s aa Second v Hercules 124 KBE SS 12 of 33 Song Boyoung No 002272 085 Sec 2010 Master Table Master M Position 4 Adit Sharma Recitation s Second Akansha Indian Classic Junior Individual Pooja Indian Classic Senior Individual Adit Sharma Mime j Junior Individual Lavanya Valluri Senior Individual SarayuAcharya Quiz 12 Grade12 Group Rahul Bhide Quiz Junior Group Prasad Quiz s Senior Group Menon Recitation Junior Individual SarayuAcharya us 5 y Short story v Junior Individual Simran n Short story v Senior Individual Nayanthara AGE Teachers Gro Open Group 1 Western Dan Junior Individual Narang Western Dani Senior Individual Sonali Rau Western Mus Junior Individual Stuti Aggarwal Western Mus Senior Individual Tejaswini Flower Arrangement First Suruchi Flower Arrangement j Sai Aditya Flower Arrangement j First Surai aue 1 41 gt mL
21. student list so this will be helpful Making the product June 2009 August 2009 l ve collected the data from our activity coordinator First of all found that making the basic tables will be better to make the form which can view everything thats needed Also typed the data directly looking the data instead of typing it to Excel and copy it to the Access Testing and Evaluation of the products August October 2009 Testing and Evaluation of the products are carried out with 2 beta testers This is kindly explained down in criterion J which is Testing and Evaluation Creating the reports September 2009 November 2009 When I m almost done with my products started writing my reports with reference to my log books 11 of 33 Song Boyoung No 002272 085 Sec 2010 Screenshots of the products Event 222 Category Type 2 Character Dramatization j Junior Individual Character Dramatization s Senior Individual Debate j unior Group Senior Group Character Dramatization unior Group Debate Senior Group Fancy Dress unior Individual Flower Arrangement Senior Individual Graffiti unior Group Indian Classical Dance Senior Group Mime unior Individual Quiz Individual Recitation m unior Individual Basle Individual Teachers Group Dance m unior Individual Western Dance SU Senior Individual Western Music Grade12 Group Quiz j Ju
22. t Access therefore Microsoft Access is needed to run the product The printer is needed to print the final report if needed Client hardware and software She could use a basic laptop or a desktop with windows 95 and above along with Microsoft office consisting of word excel PowerPoint and access Though access is the main component for my product others can be used for additional documentations and presentations Data Collections The information with reference to development of my product was picked up from the Microsoft user manual and the online internet help also learnt to use the software taking help from our teachers and friends Data for the purpose of testing the software was collected from my activities coordinator and the other team members The original data for running of the system was used by the end user activity coordinator for the last Indus Festival 17 of 33 Song Boyoung No 002272 085 Sec 2010 Criterion J Testing and Evaluation When tested the product by myself to check weather there is the technical problem or some mistakes made and corrected some of them when find something Then gave it to beta tester for the testing First beta tester Bhaskar Menon Activity counsellor Bhaskar Menon is Leadership captain in our school He helps activity coordinators in many different ways so he knows what is needed for this kind of the product He commended that the result of this is no
23. t cannot do Also it would be better for the user too because we are creating one database which means one small program so that if the user has no idea with the Microsoft Access they are able to use it easily Takes less time to learn compare to the program made by excel Also Microsoft Access can store the data in the tables effectively We can also easily edit or manage the information using queries and the final reports will also help the end user a lot It has the search features so that it would be better for the users to look for the data which they need Because of these advantages the use of Microsoft Access is the better solution than the use of the Microsoft Excel 9 of 33 Song Boyoung 002272 085 Sec 2010 Criterion I Planning the Chosen IT Solution Before choose the topic for the project needed to understand what the IGTS Project is Therefore spent about a months with searching for the information on it and net was searching for the problem that can be solved at the school There was quite a lot and after talking to our activity coordinator found that there is something that can help with my programming knowledge finally decided to make the database program which would benefit for the activity coordinator Schedule Date Stages of Development Person Responsible Jan Feb 2009 Discussion with the activity coordinator about the product Activity coordinator Inter
24. t easy to see He said that it will be better if the result can be in event wise Before Edit Datas 18 of 33 Song Boyoung No 002272 085 Sec 2010 After Event Name Grade Position House Character Dramatization j Nayanthara 10 Third Orion SarayuAcharya 9 First Pegasus Simran 9 Second Hercules Character Dramatization s Vijayta Narang 11 First Phoenix 11 Second Orion Sonali Rau 8 Third Pegasus Flower Arrangement G 10 Second Orion 12 Third Orion 11 First Orion Flower Arrangement s Akta Gupta 10 Second Pegasus Manju Shah 6 Third Hercules 1 8 First Phoenix Graffiti j es Third Nrinn Z created one more report and in the main form using macro made that report to come in one click That was much easier to look at as Bhaskar said Second beta tester Mr Jaykumar He was our ICT technical staff who is well qualified and experienced in the field of computers he did my testing with respect to all technical aspects of my program He recommended that the student list must be changed for every year so that it should be easy to edit the student data too 19 of 33 Song Boyoung No 002272 085 Sec 2010 Before 7 Event A Position Character Dramatization First Simran Character Dramatization j Second Nayanthara Character Dramatization Third Arika Fyzee Character Dramatization s Second Sonali Rau Character Dra
25. ti s Position First House Hercules v ame 1 0 rn X 2 You will be able to find the student s name grade age partipated event position and house of the student prise winner You can search by typing the name or particular events in the textbox placed in right below corner That gives the search features so you can search whomever or the events you wants 29 of 33 Song Boyoung No 002272 085 Sec 2010 House points 1 When you click on it the reports of the calculated house points will be coming House Point House Point Hercules 50 Orion 31 Pegasus 42 Phoenix 27 m Eventwise results When you click on it the reports of the prize winner which will give you the list of the prize winners eventwise Editing data When you click on it you will find something like this Eg Edit Table Editing Data Student Info Final Results ELS re D 30 of 33 Song Boyoung No 002272 085 Sec 2010 1 2 Student Info You can change the data of the students in this table As the data of the student has to change for each and every year and therefore it should be easy to change When you click on it you will be able to find the table which contains the data of the students student Grade House A EE Z7 4 9 Hercules Aditya P 17 11 Orion Akansha 17 1
26. view with him Feb Mar 2009 Collecting the data of the competitions Activity coordinator and myself June Aug 2009 Creating the product Myself Aug Oct 2009 Testing and evaluating Beta testers and myself Sep Dec 2009 Creating Reports Myself Dec 2009 Final product given to End user Myself Design Approaching towards the topics January 2009 was actually searching for the topic in several places my school As I m staying in school as the boarder had to find the social problems inside the school only so was searching like in library sport stores and so on Finally found that the activity coordinator has the problem with their calculations and evaluation of the interschool events so decided to help in this problem with my product 10 of 33 Song Boyoung 002272 085 Sec 2010 Collecting the data of the competitions February 2009 This is needed to me to make the sample data of the program What I m doing is that the calculations and the feature of finding the prise winner easily so that the data of the competitions are obviously needed got the data from the activity coordinator didn t keep the record of the results before therefore had to use what has been collected by our activity coordinator This is for my sample data and with the reference of this the end user will be able to use the products easier For every year they have to change the
Download Pdf Manuals
Related Search