march 4th, 20081 simnet view detailed design by innosmart technologies

March 4th, 2008March 4th, 2008 11

Simnet ViewSimnet View

Detailed Design

by

InnoSmart Technologies

March 4th, 2008March 4th, 2008 22

Welcome!Welcome!Ms. Jami CotlerMs. Jami CotlerLecturer of Computer ScienceLecturer of Computer ScienceComputer Science DepartmentComputer Science DepartmentSiena CollegeSiena College

Dr. Timoth C. LedermanDr. Timoth C. LedermanProfessor of Computer ScienceProfessor of Computer ScienceComputer Science DepartmentComputer Science Department

Siena CollegeSiena College

March 4th, 2008March 4th, 2008 33

InnoSmart TechnologiesInnoSmart TechnologiesCaitlin SheilCaitlin Sheil Team LeaderTeam Leader

Kevin DeckerKevin Decker Lead DeveloperLead Developer

James Mayben Jr.James Mayben Jr. Test ManagerTest Manager

Shane LeightonShane Leighton Webmaster & DocumentarianWebmaster & Documentarian

Andrey TaranAndrey Taran DeveloperDeveloper

March 4th, 2008March 4th, 2008 44

Order of EventsOrder of Events

Introduction: Caitlin SheilIntroduction: Caitlin Sheil

Testing: James Mayben Jr.Testing: James Mayben Jr.

Database Structure: Kevin DeckerDatabase Structure: Kevin Decker

Prototypes: Caitlin SheilPrototypes: Caitlin Sheil

Conclusion: Caitlin SheilConclusion: Caitlin Sheil

March 4th, 2008March 4th, 2008 55

AgendaAgenda

Problem DefinitionProblem Definition

TestingTesting

Database StructureDatabase Structure

Prototypes Prototypes

TimelineTimeline

Conclusion Conclusion

March 4th, 2008March 4th, 2008 66

Problem DefinitionProblem Definition

Simnet TestsSimnet Tests

Analyzing Test Result DataAnalyzing Test Result Data

AccessibilityAccessibility

March 4th, 2008March 4th, 2008 77

AgendaAgenda

Problem Definition Problem Definition

TestingTestingDatabase StructureDatabase Structure

Prototypes Prototypes

TimelineTimeline

ConclusionConclusion

March 4th, 2008March 4th, 2008 88

Testing Testing

System TestSystem Test3 Stages:3 Stages:

Unit TestingUnit Testing Integration TestingIntegration TestingRegression TestingRegression Testing

March 4th, 2008March 4th, 2008 99

Unit TestingUnit Testing

PurposePurposeValidationValidation

UnitsUnitsRequirementsRequirements

Test CasesTest CasesVariables Variables

March 4th, 2008March 4th, 2008 1010

Unit Test ExampleUnit Test Example12. Manage Accounts: Administrator Screen

Num

Name DescriptionState Before

TestState After Test Input

Steps to be Executed

Expected Output

Comments Pass/Fail

12.1

Load Page Administrator: Manage Accounts

Screen Loads Properly

Administrator Welcome

Screen

Administrator: Manage

Accounts Screen

None None Screen displays Faculty: Change Password Screen properly in web

browser

12.2 Home Home Link is clicked and

released

Administrator: Manage Accounts

Screen

Administrator Welcome Screen

None Redirected to Administrator

Welcome Screen

Screen displays Administrator

Welcome screen properly in web

browser

12.3Manage

Account / Password

Manage Account /

Password link is clicked and

released

Administrator: Manage Accounts

Screen

Administrator: Manage

Accounts Screen

None Redirected to Administrator:

Manage Accounts Screen

Screen displays Administrator:

Manage Accounts

Screen properly in web browser

12.4

Manage Files

Manage Files link is clicked and released

Administrator: Manage Accounts

Screen

Administrator Manage Files

Screen

None Redirected to Administrator:

Manage Files Screen

Screen displays Administrator Manage Files

Screen properly in web browser

12.5

Logout Logout link is clicked and

released

Administrator: Manage Accounts

Screen

Simnet View Login Screen

None Redirected to Simnet View Login Screen

Screen displaysLogin screen

properly in web browser

March 4th, 2008March 4th, 2008 1111

Integration TestingIntegration Testing

Unit Linked Units Description

1 12, 13 Changes to a Password

Changes to a Password

Unit Changed Unit Affected Description Effect Pass/Fail

Manage Accounts:

Administrator Screen (12.9)

Login Screen (1)

Administrator Changes a Users’ password.

If a password is changed it must be checked to see if it works properly.

Unit Changed Unit Affected Description Effect Pass/Fail

Change Password:

Faculty Screen (13.9)

Login Screen (1)

Faculty user changes their password.

If a password is changed it must be checked to see if it works properly.

March 4th, 2008March 4th, 2008 1212

Regression TestingRegression Testing

Remote RegressionRemote RegressionTesting “Bugs”Testing “Bugs”Procedure Procedure

March 4th, 2008March 4th, 2008 1313

AgendaAgenda

Problem Definition Problem Definition

TestingTesting

Database StructureDatabase StructurePrototypes Prototypes

TimelineTimeline

ConclusionConclusion

March 4th, 2008March 4th, 2008 1414

USERUSER

USER Example:

Username varchar(10) Primary Key Admin1

Password varchar(20) Not Null *md5 sum of users password*

Admin number Not Null 1

Email varchar(30) username@domain.tld

AdminName varchar(20) John Doe

March 4th, 2008March 4th, 2008 1515

REPORTSREPORTSREPORTS Example:

ReportID number Primary Key 1

ReportName varchar(50) Not Null, UniqueCSIS SSX Summer 07 Report 1

CreateDate date Not Null 8-24-07

Created By varchar(10)

Foreign Key, USERS(Username

)

admin1

ReportAvgScore number Not Null 61.83

ReportAvgTries number Not Null 2.33

Year number Not Null 2007

Session varchar(10) Not NullSummer

Course varchar(10) Not NullCSIS SSX

MostCommInc number Not Null 2,16,20

MostCommSkip number Not Null 19,25

March 4th, 2008March 4th, 2008 1616

STUDENTSSTUDENTS

STUDENTS Example:

SVstudentID number Primary Key 2

Username varchar(15) Not Null kj23deck

ReportID numberNot Null, Foreign KeyREPORTS(ReportID)

1

Score number Not Null 64.10

NumQsAns number Not Null 39

NumCorrect number Not Null 25

NumIncorrect number Not Null 14

AvgNumTries number Not Null 1.33

March 4th, 2008March 4th, 2008 1717

AgendaAgenda

Problem Definition Problem Definition

TestingTesting

Database StructureDatabase Structure

PrototypesPrototypes TimelineTimeline

ConclusionConclusion

March 4th, 2008March 4th, 2008 1818

Prototypes: Login Prototypes: Login

March 4th, 2008March 4th, 2008 1919

Prototypes: Forgot PasswordPrototypes: Forgot Password

March 4th, 2008March 4th, 2008 2020

Prototypes: HomePrototypes: Home

March 4th, 2008March 4th, 2008 2121

Prototypes: Manage AccountsPrototypes: Manage Accounts

March 4th, 2008March 4th, 2008 2222

Prototypes: Change PasswordPrototypes: Change Password

March 4th, 2008March 4th, 2008 2323

Prototypes: View ReportsPrototypes: View Reports

March 4th, 2008March 4th, 2008 2424

Prototypes: Class DataPrototypes: Class Data

March 4th, 2008March 4th, 2008 2525

Prototypes: Student SummaryPrototypes: Student Summary

March 4th, 2008March 4th, 2008 2626

Prototypes: Student DataPrototypes: Student Data

March 4th, 2008March 4th, 2008 2727

Prototypes: QuestionPrototypes: Question

March 4th, 2008March 4th, 2008 2828

Prototypes: Export Dialogue BoxPrototypes: Export Dialogue Box

March 4th, 2008March 4th, 2008 2929

Prototypes: Print Dialogue BoxPrototypes: Print Dialogue Box

March 4th, 2008March 4th, 2008 3030

Prototypes: Manage FilesPrototypes: Manage Files

March 4th, 2008March 4th, 2008 3131

Prototypes: Copying FilesPrototypes: Copying Files

March 4th, 2008March 4th, 2008 3232

Prototypes: LogoutPrototypes: Logout

March 4th, 2008March 4th, 2008 3333

AgendaAgenda

Problem Definition Problem Definition

TestingTesting

Database StructureDatabase Structure

Prototypes Prototypes

TimelineTimelineConclusionConclusion

March 4th, 2008March 4th, 2008 3434

Timeline (Gantt Chart)Timeline (Gantt Chart)

March 4th, 2008March 4th, 2008 3535

AgendaAgenda

Problem Definition Problem Definition

TestingTesting

Database StructureDatabase Structure

Prototypes Prototypes

TimelineTimeline

ConclusionConclusion

March 4th, 2008March 4th, 2008 3636

Linear Sequential ModelLinear Sequential Model

March 4th, 2008March 4th, 2008 3737

Testing

Database Structure

Final Prototypes

Topics CoveredTopics Covered

March 4th, 2008March 4th, 2008 3838

Supporting DocumentationSupporting Documentation

Detailed Design Document – March 4Detailed Design Document – March 4th,th, 2008 2008Acceptance Test – April 29Acceptance Test – April 29thth, 2008, 2008

March 4th, 2008March 4th, 2008 3939

Thank You!Thank You!Simnet ViewSimnet View

Questions?Questions?

Detailed DesignDetailed Design