220 likes | 231 Views
An Architectural Review of TAKEaTEST.Net. Southern California Code Camp California State University, Fullerton January 21-22, 2006 Ben Aminnia Pointer Corporation. Primary Goals. A Table-Driven Test Taking Tool on the Web Conduct Multiple Test Styles, using the same Test Engine
E N D
An Architectural Review ofTAKEaTEST.Net Southern California Code Camp California State University, Fullerton January 21-22, 2006 Ben Aminnia Pointer Corporation
Primary Goals • A Table-Driven Test Taking Tool on the Web • Conduct Multiple Test Styles, using the same Test Engine • Define Test Groups Accessible by Each Login ID • Define New Tests without Creating New Web Pages • Store Test Results in a Database
Test Styles • Style 1 - Multiple Choice • Style 2 - Rating Scale of 0 through 5 • Style 3 - Rating Scale with 5 Custom Headings • Style 4 - Rating Scale with 2-5 Custom Headings • Style 5 - Rating Scale of 0 through 5 with User Comments • Style 6 - Rating Scale with 2-9 Custom Headings and Optional User Comments
Test Style 6Rating Scale with 2-9 Custom Headings and Optional User Comments
Scoring Styles • Different Score for each Question (e.g. The Millionnaire) • Order of Option Button • Reverse Order of Option Button (e.g. Priority Order) • None
Design Documents • Database E/R Diagram • Web Page Navigation Chart Sanity Savers • Session Variables • Stored Procedures Summary
Different Ways to Launch TAKEaTEST.Net • From the Internet … • Login with a Shared ID (e.g. Guest) • Login with a Private ID (e.g. CodeCamp) • Demo • From Another Application • Necessary Information Passed via Arguments • No Login Page – Proceed to Test Group • Demo
DB Technology • Original prototype was in MS Access! • Soon converted to SQL Server 2000 • A couple of in-line queries • Mostly Stored-Procedures
DB Connection • A Mix of OLEDB and SQLConnect • Logic to Identify Local vs. WWW (thus showing certain things in Local mode only) • Connection string housed inside the code (NOT in web.config)
Deployment Application • Development: FP2003 • Production: Visual Studio Setup App Database • Major Upgrades: Script • Minor Upgrades: Redo
Email Capabilities • Send test results to designated administrator • Via SMTP (not Outlook) • My SMTP or Yours • Optional
Speaker Evaluation Website:www.TAKEaTEST.net Login ID: codecamp
My Contact Information Ben Aminnia www.pointercorp.com www.TAKEaTEST.net www.sql.la ben@pointercorp.com president@sql.la