Prototype Report Version 1.3
Prototype Report
Leamos
Team Number 7
Name / Email Address / Primary Role / Secondary RoleMonty Shah / / Project Manager / Life Cycle Planner
David Wiggins / / IIV&V / Off-campus Shaper
Pragya Singh / / System Architect / Prototyper
Shantanu Sirsamkar / / Requirements Engineer / Feasibility Analyst
Suchita Doshi / / Prototyper / Operational Concept Engineer
Swapnil Savdekar / / Life Cycle Planner / System Architect
Version History
Date / Author / Version / Changes made / Rationale10/10/11 / Suchita Doshi, Shantanu Sirsamkar / 1.0 / ●Original template / ●Initial Prototype with the navigation flow and the prototypes with the description
10/14/11 / Suchita Doshi, Shantanu Sirsamkar / 1.1 / ●Updated Sections 2 and 3 / ●The mock ups are updated with more details with more screenshots.
●Updated after Evaluation
10/18/11 / Suchita Doshi, Shantanu Sirsamkar / 1.2 / ●Added prototype / ●The prototype is required for managing students.
●Bug were also fixed
10/22/11 / Shantanu Sirsamkar / 1.3 / ●Made changes to prototype mock ups / ●Reduced the number of clicks in Sales web pages prototype and changes the migration prototype
Table of Contents
Prototype Reporti
Version Historyii
Table of Contentsiii
Table of Tablesiv
Table of Figuresv
1.Introduction1
1.1Purpose of the prototype report1
1.2Status of the prototype1
2.Navigation Flow2
3.Prototype4
Table of Tables
Table 1: Migration of Data4
Table 2: Sales website9
Table 3: Manage Student Profile14
Table of Figures
Figure 1: Navigation flow3
Figure 2: Data Migration4
Figure 3: Sales Website5
Figure 4: Manage Student Profile6
Introduction
Purpose of the prototype report
The prototype report is a report that provides the prototypes developed and documented for the Leamos ™ (Centro Latino Organization) as well as understandability of the navigation flow of the system. This report would provide the details of project through screenshots, diagrams and description for the same. It would also provide in detail of how the system would behave and function with the help of the prototypes designed. This would fetch the response from the client on prototypes which would help the system to get a better shape. It helps us to mitigate the risks.
Status of the prototype
The prototypes have been created based on the initial requirements from clients. These include the Migration of data and creating the sales website. New prototypes will be added as and when required.
Navigation Flow
Figure 1: Navigation Flow for Leamos Website
Prototype
3.1 Data Migration:
Table 1: Migration of data
Description / This screenshot is useful for migrating data from SQL to MySQL database. First we create a connection with the old database – SQL and then we create a connection with the new database –MySQL. Then we get all the rows of the related table and we insert the same into the new database. Finally we close the connection to the old database and the new database. Please note that based on the current observation, this seems to be a simple data migration. We are awaiting the client to share the existing schemas. Once the schemas have been shared we will get to know if there are any tricky scenarios and the prototype will be updated as required. The client is awaiting the schema from their development team. This should be available to us in a couple of weeks (1st week of November)Related Capability / Win condition 252 / Migration of database
Pre-condition / The admin/developer will open the program and set the connection string values in the configuration.
Post condition / Post execution of the program, data will be migrated from the old database to the new database.
Figure 2.1: Code for data migration
Figure 2.2: MySQL table before migration.
Figure 2.3: SQL Table to be migrated to MySQL
Figure 2.4: MySQL Table with the migrated data
Details:
The figure 2.1 displays a code which migrates the data, currently in MS SQL (table 2.3) to MySQL (for before migration refer table 2.2, for data after migration refer to table 2.4. The code demonstrates an example of how all the rows of one table in MS SQL are fed into the rows of another table in MySQL successfully. This would eliminate the pain of managing 2 databases for the client by migrating the data. This piece of code is a sample code, taking in some sample values in MS SQL and successfully migrating them to MySQL database.
3.2 Sales Website:
Table 2: Sales Website
Description / In the following mock ups, we demonstrate a sequence flow of how a user can buy Leamos licenses as a user or as an organization online, through a third party merchant system.Related Capability / Win Condition 245
Pre-condition / The user have selected the BecomeaLeamosLiteracySiteon the home page of Leamos website
Post condition / Post execution of the program, user will be provided with the License(s) with a username and password on completion of the payment.
Figure 3(a): Sales website Mockup
Figure 3(b): Sales website Mockup
Figure 3(c): Sales website Mockup
Figure 3(d): Sales website Mockup
Figure 3(e): Sales website Mockup
Figure 3(f): Sales website Mockup
Figure 3(g): Sales website Mockup
Details:
The above screenshots provides a brief overview of how the website would look when an organization wants to buy courses or wants to become an independent user or an independent site with Leamos.
Figure 3(a) displays the mock up of the 1st page from which the process of payment will start. There are 3 icons as described. The function of these icons is to give a more detailed idea of how much the purchase will cost them. The user needs to click on any of the 3 icons to move further.
Figure 3(b) displays mock up of the page that would give the potential customer information on his purchase if he is inside the boundaries of Los Angeles County.
Figure 3(c) displays mock up of the page that would give the potential customer about the information on his purchase if he is outside the boundaries of Los Angeles County and an independent site.
Figure 3(d) displays mockup of the page that would ask the partner or independent site user to enter the described details and store it to the database.
Figure 3(e) displays mock up of the page that would ask the individual user to enter the described details and store it to the database.
Figure 3(f) displays that the customer is being re-directed to the Course Merchant payment gateway for further processing.
Figure 3(g) displays mockup of the screen that shows the successful subscription of the product bought by the customer.
3.3 Managing Student Profile:
Table 3: Managing Student Profile
Description / Following are the mock ups for displaying how an administrator can manage the student profiles. The operations include adding a student profile, viewing student profile, editing student profile and generating a report on student profiles. All mock ups include relevant details respective to their operation.Related Capability / WC 243
Pre Condition / The admin must have logged into his account to access these web pages.
Post Condition / The student profiles would have been addedviewed edited or reports generated after access by admin.
Figure 4(a): Manage Student Profile Mockup
Figure 4(b): Manage Student Profile Mockup
Figure 4(c): Manage Student Profile Mockup
Figure 4(d): Manage Student Profile Mockup
Figure 4(e): Manage Student Profile Mockup
Details:
Figure 4(a): Displays the simple login screen for the user who will manage the student profiles.
Figure 4(b): Displays the screen after login where by default it shows the screen to Add student profile with their relevant details.
Figure 4(c): Displays the screen for the tab to View student profile details.
Figure 4(d): Displays the screen for the tab to edit student profile details.
Figure 4(e): Displays the screen for the tab to Generate Report about students and their progress. Also the admin can search the name of the student whose report he wants to see.
PRO_FCP_F11a_T07_V1.310/22/11