Performance Software www performancesoftware org Automated Grading System

Performance. Software www. performancesoftware. org Automated Grading System for Microsoft Excel - Detailed Design Roger Bacon Science Center, Room 328 February 21 st, 2006 1

Welcome Dr. Scott Hunter Computer Science Department Siena College Ms. Jami Cotler Computer Science Department Siena College 2

Our Team Whitney Cave Team Leader whitney@performancesoftware. org Patrick Durham Systems Administrator patrick@performancesoftware. org Raymond Navarette Development Manager ray@performancesoftware. org Nicholas Sitterly Webmaster nick@performancesoftware. org Joseph Strube joe@performancesoftware. org 3 Software Developer

Agenda Prototypes Database Testing 4

Prototypes: Raymond Navarette 5

Displays and Command Summary 6

Student – New Registration Page 7

Student – Landing Page 8

All Users – Change Password 9

All Users – Successful Password Change 10

Student – Ungraded Lab Report 11

Student – File Submission 12

Student – Graded Lab Report 13

Lecture Instructor – Grade Report 14

Lecture Instructor – Detailed Grade Report 15

Lab Instructor Landing Page – Lab Section Overview 16

Lab Instructor – Detailed Grade Report 17

Course Coordinator – Landing Page 18

Course Coordinator – User Search 19

Course Coordinator – Section Creation and Editing 20

Course Coordinator – Category Creation and Editing 21

Course Coordinator – Assignment Creation 22

Course Coordinator – Entering File Information 23

Course Coordinator – Grading Files Submission 24

Course Coordinator – User Tasks (Search, Add, Batch Add) 25

Course Coordinator – Search Results and Editing 26

Instructors & Course Coordinator – Generate Report 27

Course Coordinator - Archive 28

Lab Instructor – Lab Section Detail 29

Lab Instructor – Grading Software 30

Key File 31

Database: Joseph Strube 32

Key PK – Represents a primary key FK – Represents a foreign key 33

Student User Table 34

Other User Table 35

Sections Table 36

Student Submissions Table 37

Assignment Table 38

Assignment Detail Table 39

Category Table 40

Graded Elements Table 41

Release Table 42

Semester Table 43

ERD 44

Project Testing: Whitney Cave 45

Unit Testing • Actions: – Test Each Individual Function • Goals: – System is free from data, logic, or standard errors – Each function creates correct immediate outcome 46

Unit Testing Example Unit Test: 47

Integration Testing • Actions: – Groups the Unit Tests • Goals: – Pinning Errors Between Units 48

Integration Testing • Examples: – Instructor Deletes a Student – Course Coordinator Adds/Deletes an Assignment – Graded Assignments are Reflected 49

System Testing • Actions: – Simulate a mini semester with fake accounts and assignments • Goals: – Specified Functional Requirements are correct – Requirements Specification Document has been satisfied in full 50

Acceptance Testing • Actions: – Completed System presented to Clients – Use is Described in Detail – Final Changes Made if anything is Unsatisfactory • Goals: – Clients’ Satisfaction in the Final Product 51

Development Schedule 52

Summary Next: Acceptance Test Questions? Thank You 53