Technical Functionality Marking Scheme: 10-Prototype Database 10-User Interface 10-Browsing Works 5-Correct Browsing Access Restrictions 10-Updating Works 5-Corrent Updating Access Restrictions 5-Ability to change password 5-Printing 10-Overall Functionality 10-Completeness of solution (attention to details ie. messages) 10-Participation of group members in presentation/demonstration 10-Ability to answer technical questions Documentation Marking Scheme: 2-Table of Contents 5-Executive Summary 5-Team members' identification and what they'll be presenting 3-Structure of document 5-Completeness of document 5-Quality of document 10-Design Documentation Program Documentation: 5-Coding Standards 5-Readable Code 5-Re-usable Code 10-Use of Comments 10-Database Documentation 5-Test Database 5-Hardware Requirements 5-Installation Instructions 5-Execution Instructions 10-Description of how solution addresses problem "Employee Tracker" - software for controlling employee resources Guiding Design Principles: -easy to use -visually appealing under windows XP CD requirements: -CD with CD silk & cover -written installation instructions -program icon created on desktop during installation -written execution instructions Employee Information: General: -photograph -last name -first name -middle name -job title -department code -building -office -extension -company email address Home: -Street Address -City -province -postal code -phone number -birth date -marital status -first name of spouse -personal email address HR: -Employee number -SIN -date of hire -Outstanding Sick days available -outstanding days of vacation available Salary: -salary -salary level(between 1 and 15) -pay interval (biweekly or monthly) -date of last salary increase -merit bonus amount Non-visible security info: -password -access abilities Departments: -department code -department description Clearance Levels: -BrowseHome -BrowseHR -BrowseSal -UpdateGen -UpdateHome -UpdateHR-edit photo, create/delete users/deparments -UpdateSal -UpdateUser-add/delete users, edit priveleges Printing options: -screen display -report listing general information of all employees in company -(if has UpdateHR) printout of all users and their priveleges -report detailing all info on a employee viewable by current user Display: -user info display -browse by first letter of last name or by department Searching: -soundex support -timestamp <> support - Timestamp: -1 bit unused to prevent negative number problems -7 bits year -9 bits day of year -15 bits for every 4 seconds of day Security: -public key encryption for data transmissions Database: -fallback to read-only backup if server goes down -this option can be turned off Config file: -only editable by user with UpdateUser privelege -Server ip -timestamp of last backup update -is backup used? Program design: -employee editor control -department editor control -searching control Forms: -main form -options form -splash screen -about screen If time ideas: -record-level encryption of fields using public-key, with single hash of password encrypting public keys for data types Submission Label: Request for Proposal: Omni Group of Companies -- Employee Tracker Tender From: Sir Winston Churchill CVI Contact Person: Gino Russo Student Project Leader: Adam McLellan Info Needed in Tender Document: -Full name of developer organization -For School, Teacher & SPL: -name -address -telephone number -fax number -email address -Team member listing -Team members in presentation -Team members in demonstration & answering questions Tender Document: Includes: -no more than 30 pages -toc & executive summary -documentation describing design -program/operations documentation (comments, installation/execution instructions) -hardware requirements -source code listings Assessment base on: -document structure, presentation, completeness, quality -adherence to programming standards -quality of description of how solution addresses problem