A Sample Final Report 4
Contents
1. SLE Ble JUI Y Bilingual Graduation Cer sys Bilingual Graduation Certificate System opel2. Mail Merge y Y DONG US ode N 3539 shad col OLY
3. ABLE MS Excel al ol Aute S
4. We MS Word
5. 0 Delete Add 5 Lal gI Record 1 Close About Bilingual Graduation Certificate Sys HA ity 199 KFUPM ICS 411 Seniour Project 29 30
6. MS Visual Basic 5 o 97 97 MS Excel MS Word 97 97 MS Access Visual Basic for Application VBA
7. sky OS Gf sly MS Word
8. SBM ov Ay pall BES MS Excel aa bil MS Excel Y
9. ag s y 333A al 23 This is to certify that MR MUHAMMAD ABD RAB AL RASOAL ALI FAMILY Student ID 777771 born 1400H has completed all formal and academic requirements for the Degree Of Bachalore Of science in Applied Civil Engineering The Degree is conferred with Second Honor by King Fahd University of Petroleum amp Minerals effective Decmeber 21 1998 Registrar Ahmed A Al Dharrab Dean Admissions amp Registration Mamdouh M Najjar Dean College of Applied Engineering Acting Mohammad O Budair Rector of the University Abdulaziz A Al Dukhayil 24 Appendix 2 Installation Instructions
10. Y able MS Word ab pis
11. student Hame AL GUNAPTAN KHALED ABDUL MUHSEN IBRAHIM Total Certifcates b Number of Finished Cer 1 dee LT Time 25 ee all The Create Screen Conclusion The system is a certificate generator program It has been developed as a senior project with in Information and Computer Science Department at King Fahd University of Petroleum and Minerals The system will get the student information from an Excel sheet Then it will process the information and store it in the system database The user will be presented with a list containing all the graduated students to select from After selecting the required students the system will create the certificates using MS Word 21 Appendix 1 Input amp Output Samples Below is the input Excel sheet sample ID NAME COL MAJOR DEG TERM epe kaa AL HASAN AE ACE BS 981 pi ABDALLAH e MUHAMMAD 935069 AL YAHYA ALI AE ACE BS 981 n 1997 5 6 ABDRABBARRASOU L ALI 880726 AL SUWAII BADER AE ACHE 31 71411 885846 AL JUHANI KHALED AE ACHE 981 3 4 1416 SALEM SALIM AL FAYEDI 903198 AL CYAHYA FAISAL AE ACHE BS 983 aal TEN pe MSD PP p aes MUHAMMAD SALEM MESFER MEAJEB 910946 AL KHALEDI AE ACHE BS 981 Q 3 1 1411 914293 AL SHAMMARI AE ACHE BS 983
12. SOM A SETUP EXIT SETUP OK Y ea pl idee suy 5 Change Directory o Change Directory ELS OK Cancel
13. EM OK 25 Appendix 3 User Guide a a rhe P C1 gt 0 nd YY Yy YA 26
14. 3 4 1416 AREF MUHAMMAD 1 HAMDAN ABDUH 916590 AL ZAHRANI AE ACHE BS E MUHAMMAD SALEH 1 6 3 1409 ABDALLAH AL 3 i HARIRI 920173 ZAATARI GHASSAN AE ACHE roms p esa 920179 UHARNMAD TAHA id acie M pae eaitit970 920897 AL HADDAD TURKI AE ACHE BS NI 1416 6 21 NASER BASEM HADI 921596 AL ZAHRANI JAMAN AE ACHE AHMAD ALI AL 921794 AL THUNAIYAN AE ACHE 981 aca c 1946 9 6 KHALED SALEH MUHAMMAD 924951 e WAIL ADLI JAE ACHE BS 983 Seal AE Dae 1946 8 21 ERECTAE Raum cese Een eat cu AE ACHE BS TEC 1984 5 30 MUHAMMAD SALEM 1 MUHAMMAD AL HAWASHELAH 926721 AL SADAT MAJED AE ACHE 981 8 1931 11 6 111 iens a ee 927204 MUBARKI YOUSEF AE ACHE BS FER mee 1980 10 17 rai s pie Re Mm rur gg Ew x e e ds ABDALLAH 928723 AL ASIRI MAJED AE ACHE m 3 1 1412 MUHAMMAD HASAN o AL ARAR Joe scirem e s m ANWAR SALEH en MUHAMMAD 22 p Uie qo cp asco 5 4 19 Below is the Output Word document Certificate Issue Date Decmeber 21 1998 Graduation Certificate CVV Y Y
15. Bilingual Graduation Certificate System The system is a certificate generator program The main idea of the program is to take student information from an excel sheet and produce an appropriate certificate The style and the content of the certificate vary depending on many criteria For e college and major Moreover the certificate must reflect the student status by printing appropriate message for honor student The system will take the information and create the certificate in Microsoft Word and system designing and it will end up with a conclusion It will include also three appendices they are Input amp Output Samples Installation Instructions and User Manual Project Planning shows both the estimated and the actual number of hours for each activity along with the project milestones The project activities are explained below along with the estimated number of hours Then the project plan will be followed hours 29 9 14 24 20 23 Description The needed time for Visual Basic 5 0 and Power Point self study It includes both learning and practicing the two packages Information gathering about the project and contacting the system users to come up with the formal functional and non functional requirements Dividing the project into different subsystems and then deal with each subsystem independently Each subsystem can be further divided into models and functions Programming the modules and writin
16. 981 Term 0 Selected 432 Total ID rangs From 890000 To 349999000 Search day Options pr Select AN Lis Select Nonels Y Lis Exit ti Import Date 432 Students Total 245 Insert the data Time 0 37 I ALL a 55 1 815479 Students ID dom Student Name IDRIS FAISAL MUHAMMAD AHMAD T Teer ee ae P EEUU j u ae asl 3 Total
17. ate o S 199 KFUPM ICS 411 Seniour Project The About Screen w Options ol U3 Torx High Studies Llll Sigaturesls dl sll File Locations Lil Collegs Lil ACCT Mor Major Code College Code IM English Major N ame Accounting Arabic Maior Name Delete bom Add 5 Lal IE Record 1 Closes The Options Screen Bilingual Graduation Cer sys Bilingual Graduation Certificate System peal Tern 381 ID Aq Selected 4 277771 EEEF Total 432 777773 eee ee ID rangs From fes0000 de To 549595000 Search daw oe oe Select AT Select Honest Y The Select Screen Import Date oF Way 1602 Students Total 432 Insert the data 177 Time D 34 a The Import Screen 20 Create Certficates 3305 4Jl LJ Students ID 794918
18. Certifcates 1 Number of Finished Cer a P A oe 23 0 0 Time 28 HEI EG High Studies Sigaturesi All File Locations lal ig Options Slb Major Code JACCT College Code IM English Major Name Accounting Arabic Maior Name
19. DataType It includes all the Colleges information with college code as a primary key It includes the Arabic amp English Dean _ EnglishDeanTitle title and name Moreover the Arabic amp English college j Engishbean ArabicDeanTitle name is also included ArabicDean ColegeEnalishName CollegeArabicName e Students Table EB Table The Student ID Arabic amp English Name College Major Degree Graduation Term Honor Birth Date are EnglishName sorted in this table The Student ID is the primary key The College is a foreign key to the College table The Major is a foreign key to Major table Finally the Degree is a foreign key to High Study Table E Majors Table El Field Name E EnglishName ArabicMame 89 HighStudy Table Field Name al EnglishDean lArabicDeanTitle ArabicDean EB Signature Table IE Field Name 9 Order Text E EnglishDeanTitle Text EnalishDean Text ArabicDeanTitle Text ArabicDean Text 8 Dates Table m Field Name ArabicIssueDate Text Z EnglishIssueDate Text ArabicGraduationDateH Text ArabicGraduationDateM Text EndlishGraduationDateM Text Table m Field Name ExcelSheetFile Text TemplateFile Text CertifcateLoc Text 8 Locations e Majors Table It includes all the Majors information with Major Code as a primary key It includes the Arabic amp Engli
20. the certificates It will loop for the students in the List and process the selected students only It will get the complete student information from the system database and then will start creating the certificate Creating the certificate begins by opening an empty document in MS Word from a certain template Then it fetishes the required data from the database processes it and then places it probably in the created document The required data e information and signature information The data placement mechanism is done by inserting a bookmark in the MS Word template for each field needed in the certificate Then the subsystem will move to this bookmark and then place the required information After placing all the need information in the document the certificate will be saved in a temporary directory The subsystem will show the creation progress by showing both the total number of required certificates and the total number of generated certificates Moreover it will count the time for the create operation It will also show the current processed student The control will be returned back to the Selection Subsystem after creating all the certificates for all the selected students Options Subsystem The system needs some customization to get running in highly changing requirements So this subsystem is responsible for providing the necessary options It will interact with the system database in order to customize the system functioanlity The
21. 12 5 24 3 Plan Sch 4 3 22 1 3 1 8 9 Write 3 5 5 5 1 0 5 2 3 3 3 341511121 25 20 Deb Test 2142 110131 2 4 5 2 2 41 212 3 111 23 18 Meeting 0 0 0 0 0 0 0 0 x 3 Demo 1 101 2 0 1 2 11122 1 1 7 T Present 2 1 413 6 4 Total Hla 6 lo 2 2 2 Leal er Je PS i Ult tan U Gn de E pee c D Ur n in in 97 amp dn tn 6n N e Requirements Gathering The second step after project planning is requirements gathering This phase includes meeting that will show a step by step procure to achieve a specific function It will also result with an initial thinking of the user interface Moreover It will come up with formal functional and non functional requirements along with platform specifications and risk analysis The Scenarios Four scenarios are provided below These scenarios show the mechanism of achieving some of the basic functions These functions are Manual Selection Special Selection Select All and Updating Manual Selection amp Print certificates Scenario Main Program Entry Manual Selection The program will start The user can manually After selecting the by showing a Main sel
22. FileOpenDirectory TempDir WordDoc ActiveDocument SaveAs filename target file doc FileFormat _ wdFormatDocument LockComments False Password AddToRecentFiles _ True WritePassword ReadOnlyRecommended False EmbedTrueT ypeFonts _ False SaveNativePictureFormat False SaveFormsData False _ SaveAsAOCELetter False e Print the certificate if it is needed WordDoc ActiveDocument PrintOut e Close the generated Document WordDoc ActiveDocument Close e Close the MS Word Application WordDoc Application Quit Set WordDoc Nothing The place function will take two parameters field location and Actual field The code of the function is as follows Public Sub place Field Location As String Actual Field As String WordDoc Selection GoTo What wdGoToBookmark Name Field Location WordDoc Selection Find ClearFormatting With WordDoc Selection Find Text Replacement Text Forward True Wrap wdFindContinue Format False MatchCase False MatchWholeW ord False MatchWildcards False MatchSoundsLike False MatchAIIWordForms False MatchKashida False MatchDiacritics False MatchAlefHamza False MatchControl False End With WordDoc Selection TypeText Text Actual Field End Sub nn User Interface The following are snap shots of the final user interface About Bilingual Graduation Certificate Sys LA
23. King Fahd University of Petroleum and Minerals College of Computer Science and Engineering Information and Computer Science Department Project Report Project Title Bilingual Graduation Certificate system Al Jarrash Ashraf ID 942596 11 21 22 24 25 Table of Contents Arabic Extended Abstract Project Planning Requirements Gathering The Scenarios Storyboarding Functional Req Non Functional Req Platform Specifications Risk Analysis System Designing High Level Arch Database Design Design Specification User Interface Conclusion Appendix 1 Input amp Output Samples Appendix 2 Installation Instruction Appendix 3 User Manual SY AV ENA Be
24. e if we are at the end of the record set Fields Field Name It will take the field name and it will return its value Methods MoveFirst move to the beginning of the record set MoveNext move to the next record in the record set MoveLast move to the last record of the record set Record Set Example e Declare a Database object Dim DbObj as DataBase e Declare a Record Set Object Dim RsObj as RecordSet e Open the database file Set DbObj OpenDatabase database file e Runanon singleton SQL statements and get the result in the record set Set RsObj DbObj OpenRecordset Non Singleton SQL Statement e Go to first record RsObj MoveFirst e Loop for all the records and get a specific field Do While Not RsObj EOF RsObj Fields specific filed name RsObj MoveNext Loop e Close the Record Set and the Database RsObj close DbObj close Set RsObj Nothing Set DbObj Nothing Date Processing This model is responsible for reading the date and change it to the standard format DD MM YYYY It is used in the Import Subsystem to convert the input dates to the standard format This is done by scanning the date and recognizes the day field month field and year field After that we build the date in the standard format by concatenating the three fields in day month year order and Name Processing The name of the imported students must not be in opposite form Family name then first name This model will convert the opposite form name t
25. ect any number of required students the Form that has the students by just clicking user can print the system title and a list of on the needed one certificates by just all the graduated The user can also clicking the Print students deselect any student by Command Button None of the students just re clicking the will be selected selected name again initially There will be three ways of selecting the students Select All amp Print Main Program Entry Select All e The program will start e The user can select all e After selecting the by showing a Main the students by click on required students the Form that has the select All Button user can print the system title and a list of The user can reset the certificates by just all the graduated list to its initial clicking the Print students unselected condition by Command Button e None of the students click on the Reset will be selected Button initially e There will be three ways of selecting the students Select by Certain Range amp Print Main Program Entry Special Select e The program will start e The user can specify e After selecting the by showing a Main the range of the student required students the Form that has the IDs by requiring that user can print the system title and a list of each student to have a certificates by just all the graduated certain range for their clicking the Print students IDs Command Button e None of the students After spec
26. ero or one record like the Delete Command that will delete on record in the database On the other hand the non singleton statements will return more then one record The non singleton statements need a record set to hold the resulted records The implementation of Singleton will be explained first then it will be followed by the non singleton Finally record set manipulation will be discussed Singleton SQL Statements e Declare a Database object Dim DbObj as DataBase e Open the database file Set DbObj OpenDatabase database file e Execute any singleton SQL statements DbObj Execute Singleton SQL Statement e Close the Database DbObj close Set DB Nothing Non Singleton SQL Statements e Declare a Database object Dim DbObj as DataBase e Declare a Record Set Object Dim RsObj as RecordSet e Open the database file Set DbObj OpenDatabase database file e Runanon singleton SQL statements and get the result in the record set Set RsObj DbObj OpenRecordset Non Singleton SQL Statement e Close the Record Set and the Database RsObj close DbObj close Set RsObj Nothing Set DbObj Nothing Record Set Operations After executing a non singleton SQL statement the result will be stored in a record set This record set has many properties and methods The needed properties and methods will be mentioned then a complete example of working with a record set will be explained Properties EOF it stands for End Of File it will indicat
27. following are included in the Options Subsystem Item Description Update Colleges Adding deleting and modifying the colleges The college code name and the college dean must be prvided For each college Update High Studies Modifying the university high studies degrees Each degree has a code a name and a dean associated with it and they must be provided Update Majors Adding deleting and modifying the majors along with their assoicated college The major code name and college must be provided Update Signatures The Registrar dean of Admission and Rector can also be modified The date must be provided in both Arabic and English Graduation Date The official Graduation date can be modified The date must be provided in both Arabic and English Issuing Date The certificate issuing date is also modifiable The date must be provided in both Arabic and English File Locations This includes the location of the Excel sheet Ms word template and the temporary locations The user can enter the complete path or he can browse for the target location Database Design inserted into the database via the Import Subsystem The database will be updated via the Options Subsystem Moreover the database will be accessed and used to create the certificates in the Create Subsystem The database consists of 7 tables and several queries The tables are as follows e Coll Table CollegesT able T able MM SE FieldName
28. g the source code for each model in MS Visual Basic Divide the project work along milestones Writing the needed documents and reports This includes writing project plan requirement document design document project final report with both an Installation Instructions and a User Manual Regular meeting with the project coordinator to follow the project progress and achievements Run the program in a test environment and monitor its performance and accuracy This includes also fixing any errors if any Present the project in its development time And demonstrates the project progress and achievement Present the final project with required documents And present the project using MS Power Point Activity Training Requirements Design Code Plan Scheduling Write Meeting Debug Test Demo Presentation Requirements Document Prototype Package Project Plan Design Document s 2 c c c c c c c c c c c c c c E e e e e e e e e e e e e e e 5 2 2 2 2 2 2 K 2 2 2 2 2 2 2 N w _ un o E E E E E e N e Un gt p Dp p m 5 je 2 E z z E B E ei amp B B E E E B EB B S e e ak e 6 6 e ak I 8 D D C n 6 6 E e 5 zs a E es 5 zs fes Training 7 4 89 1 20141 1 4 7 29 4 Req TIO TIZ L1 9 9 Design 3 3 5 3 41 41 212 14 2 Code 2 4 15 6 113 4 2 3 4 2 3 3 4 4
29. ify the will be selected Range the program will initially select every student that e There will be three satisfy that range ways of selecting the students Modify the dean The user can modify the dean name by clicking on it The user can type the The user can go to the Configuration Screen from the Main Form by clicking on the Configuration menu Configuration Button new dean name in a text A list with all the box majors along with their corresponding deans will be shown Storyboarding Below there are two tentative initial shots of a possible user interface The first one is the Main Form which contains all the students to chose from The user can chose the needed students and then print the corresponding certificates The second form is the configuration Al Ghamdi Khaled M Shaji Fathi Dhif Computer Science amp Engineering ic gf 880000 319399 The Main form of the program The Configuration screen Functional Requirements Functional requirements are the services that must be provided by the system for the end users below 1 Import from MS Excel the system should allow the user to import the student information from an Excel sheet 2 Different ways of selection the user should have the ability to select the students by different methods they are e Manual Selection the user must be able to select and de
30. n also select the students depending on certain search The system will allow the user to specify a range of values for the student ID Then the system will select all those students with their ID satisfying that range For example the user may want to select all the students with ID between 940000 to 949999 3 Select All the user can select all the students by clicking on Select All Button The user can also deselect all the students by clicking on Select None Button Moreover the subsystem will provide the user with total number of students and the number of the selected students After selecting the required students the user can create the certificates by clicking on the print button Import Subsystem This subsystem provides the user with the ability of importing the data from an Excel Sheet and storing the data in the system database It will start by opening the Excel sheet and then count the number of stored student in that sheet Then it will read the Excel sheet row by row It will process each row before storing it in the system database It will have a timer that will provide the user with the total time of the import operation Moreover it will indicate the operation progress by showing the total number of student and current number of the imported students The control will be returned back to the Selection Subsystem after finishing the import operation Create Subsystem This subsystem is responsible for creating and printing
31. nd how each subsystem communicates with other subsystems A description of each subsystem will then be followed This phase explains the system database along with its tables and quires Moreover detailed design speciation will be included Finally the final user interface will be shown High Level Architecture An overall architecture of the system which indicates the main subsystem and the way they are communicating The high level architecture is presented as a block diagram followed by a detailed description of each subsystem The system can be divided into four main subsystems depending on their functionality They are as follows e Selection Subsystem e Import Subsystem e Create Subsystem E e Options Subsystem E S Import Subsystem Create Subsystem Certificates Selection Subsystem It is the main starting subsystem It will include the system title in both Arabic and English It will include also the necessary links to all other subsystems This subsystem will provide the user with a complete list of all graduated students for the current academic term The system will provide the user get populated with the graduated students in the chosen term This student list is obtained from the system database The user can select the students by three ways they are 1 Manual Selection the user can select any student by clicking on his ID from the list and deselect by re clicking it again 2 Special Selection the user ca
32. o the required form First name then the family name does not contain a separator then the name is in the required form Otherwise we delete the separator and then split the name into two strings and then switch the two strings Reading from MS Excel The program must read the student information from an Excel file This is done by the following procedure e Declare a MS Excel Object Dim ExcelObj as Object e Set the MS Excel Object for a specific Excel sheet Set ExcelObj GetObject ExcelFile Excel Sheet 8 e Set the first sheet in the file to be visible ExcelObj Parent Windows 1 Visible 2 True e To read a specific cell at certain column and row ExcelObj Application Cells RowNumber CoulmnNumber V alue Quit the MS Excel ExcelObj Application Quit Set ExcelObj Nothing Writing to MS Word The certificates will be created in MS Word The Create Subsystem needs to access the MS Word to build the certificate Working with MS Word can be done in the following procedure e Declare a MS Word Object Dim WordDoc As Object e Create the Word Object Set WordDoc CreateObject Word application e Open the template WordDoc Documents Add Template TemplateFile NewTemplate False e Using the Place function we will add the needed fields to the Word file This function is explained below Place English Student ID Tag TheActualStudentID e After adding all the fields we save the certificate in a Temporary folder WordDoc Change
33. select any student from the list by simple method e Select by certain criteria the user should have the ability to select the students by specifying certain condition on them For example the user may want to select all the students with ID between 880000 and 919999 e Select all there should be a simple method to select all the students in the list 3 The configuration must be modifiable the dean for some majors colleges may change from time to time So we need to be able to modify the corresponding dean whenever there is a change This also applies to registrar dean of Admissions amp Registration and rector of the university because they may be changed also 4 Add majors colleges the user must be able to add new majors or college as it may be needed Since it is possible to open new colleges or majors in the future 5 Delete majors colleges it is also necessary to delete some majors or colleges from the system 6 Creation in MS Word the certificates should be generated and saved in MS Word Non Functional Requirements Non functional requirements specify constraints on the system They include the required operating system software packages and other needed hardware The following are the required non functional requirements MS Arabic Windows 95 or 98 is required Since the certificate is written in both Arabic and English languages MS Arabic Word 97 and MS Arabic Excel 97 are also needed Since the input
34. sh Major Name Moreover it contains the corresponding college as foreign key to the College Table e High Study Table This table conations all the academic degrees BS MS MBA PhD along with their Arabic amp English dean name and title The dean information for the BS students will be taken from the college table not from this table The Degree field is the primary key e Signature Table There are all four signatures for the certificates They are the Reactor Registrar Dean of Admission and College Dean The first three are stored in this table The table includes Arabic amp English dean name and title e Dates Table It includes all the needed dates for the certificates These are Issue date and the Graduation date e Locations Table It includes the file locations for the Excel Sheet and the Word Template Moreover it includes the temporary directory for the creating the certificates The system database uses one important query or view This main query is called All Student Full which presents each graduated student with all the releted information This query will pressent Student English Name Arabic College Dean Name English College Dean Name English Major Code Graduation Term each student with following fields e Student ID e Student Arabic Name e College Code e Degree e Major Code e Arabic Major Name e Honor e Birth Date This query can be built by dividing the students into two groups BS studen
35. t and Non BS students Then take the BS Students and link them to the related college and major On other hand the Non BS Students will get joined with the related High Study college and major After that the two groups will be mixed to get all the students with all the necessary information This procedure is illustrated using Relational Algebra below BS Students gt O Student Table Non BS Students gt O Student Table BS Students Full Info gt BS Students COmajor code Majors Ccotiege Code Colleges Non BS Students Full Info Non BS Students e9yij Code Majors OODegree Degree High Studies Table All Student Full gt BS Students Full Info U Non BS Students Full Info The All Student Full query will provid most of the needed information for certifacte ceration Date Table Also the signaturs information will be taken from the Signature Table Design Specification This section explains some of the system models and techniques which are used in the system functionality It will include some Visual Basic code to show how to implement it It will start by shown how to do database access how to process the date amp name how to read from MS Excel and how to work with MS Word Database Access Database Access is used heavily in all subsystems Itis possible to manipulate the database using SQL Structure Query Language There are two types of SQL statements Singleton and non singleton Singleton statements will return z
36. to the program is an Excel sheet and the output is a Word document e The certificate has a specific format and certain font e A printer is required to print the generated certificates The system should be user friendly e The creation of the certificates should be both fast and reliable Platform Specifications This section specifies the required machine along with its operating system It also specifies the programming language for the project development e Target Platform e PC at least 486 Pentium is recommended e Arabic Windows 95 or 98 e Development platform e MS Visual Basic 5 0 Risk Analysis This section indicates possible risks within the project period These risks show some uncertainty with project development Three risks are specified below gt Formatting the text it may cause a problem to fit the text exactly in its right position Moreover there may be a problem also with letting the some fields occupying two lines gt Application Communication there are some difficulties in reading the Excel sheet from VB Also this type of difficulty appears in communicating with MS Word with in VB gt User Input Validation the program must prevent the user from carrying an invalid command For example there is no point in deleting the rector or adding a second rector System Designing The design phase includes dividing the system into subsystems A high level architecture chart is provided to show the subsystems a
Download Pdf Manuals
Related Search