Otts documentation

This Wiki/Project is a work in progress and is subject to change.

INTRODUCTION

Synopsis

oTTs, On-Time Timesheets, is an online system that allows Professors and Students to work collaboratively on System Design Projects. Seneca College's Computer Studies Department emphasizes strong team building skills, and achieves this through team projects. In the past, student and team progress have been monitored and maintained using conventional word processing documents. These conventional methods have proven to be difficult to synchronize between group members, and tended to lack substantial effort from those who were required to use them. oTTs creates an online environment where professors and students can work together to create and maintain personal timesheets and group project files. By allowing easy maintenance of projects and students for the professor, and simple manipulation functionality of timesheets and project files for students, oTTs takes the large task of project maintenance, and makes it simple for all of those involved.

Disclaimers

This project site and wikipedia are a student project only. Any opinions, statements or claims expressed here are those of the creators and are not necessarily those of Seneca College. Seneca College's Information Technology Acceptable Use Policy (ITAUP) can be found here.

INSTALLATION

System Requirements

In order to host oTTs, the system requirements are as follows:

1. Internet Information Service (IIS)
2. Web server such as warp.senecac.on.ca or hermes.senecac.on.ca
3. Microsoft SQL Server
4. ASP
5. Compatible Browser (see Section 2.2 Browser Compatibility)

Browser Compatibility

oTTs strives to achieve a uniform appearance across all browsers and has been tested extensively on Firefox 2.0 and Internet Explorer 7. Either browser must have javascript enabled for full and proper functionality to work.

For the best performace, it is suggested that FireFox 2.0 is used, and the system be viewed in full screen mode.

Getting Started

Before you Begin

Make sure you have installed and met all system requirements listed in Section 2.1 System Requirements (link..?). This document will describe how to install oTTs assuming these requirements have been met.

Database Step Up

1. Open SQL Query Analyzer, and connect to the warp server (http://warp.senecac.on.ca), using SQL Authentication.
2. Enter your user ID and password, and click Connect
   (INSERT SCREEN SHOT)
3. Once you are authenticated, select File -> Open and navigate to the location where the script, otts_schema.sql is located.
4. Validate the script by pressing CTRL + F5
5. Once the validation is complete, run the script by pressing F5. The query should read 1 row(s) affected. The database is now setup.
   (INSERT SCREEN SHOT)

Note: By default after the script has been executed, there will be a master adminstrator login in the database. It is recommended to use this login in order to create the initial adminstrator login before using the system. It is also highly recommended that the master administrator login be deleted upon initial login. Since the master adminsitrator login does not have a valid email, simply changing the password is not allowed.

Master Adminstrator Login Information

User ID: master_admin
Password: master_password

FUNCTIONALITY

Logging In

There are two types of accepted users that may log into oTTs, students and administrators. The two are distinguished by their email addresses, students have email addresses with domains of "learn.senecac.on.ca" and professors have email addresses with domains of "senecac.on.ca". User ID's for both login types are each respective email prefix, for example a user with the email address of johndoe@learn.senecac.on.ca, their user id would be johndoe. Each user's initial password wil be emailed to them upon creation of their account by the administrator, the default password may be changed at any time by using the "Change Password" function (see Section 3.1.2 for details).

Forgotten Passwords

At the main login screen, users will be autheticated, and directed to the appropriate screen. If a user has forgotten their password, it may be retrieved by clicking the Reset Password Link located above the login button, see Figure 2.1. The user must enter a valid email address associated with their account inorder to have their password reset and emailed to them, see Figure 2.2.

Change Password Function

Passwords may be changed by the user by clicking on the Change Password button on the default screen, see Figure 2.3. A floating pop-up box will be displayed, and the screen below will be disabled. The user can change their password, or cancel the action without any changes occuring.

Valid Passwords

Passwords must be at least one character in length, and are case sensitive. A password may contain numbers, letters, and most special characters with the exception of single quotation marks.

Administrator

The role of the Administrator user is to create and maintain all users and their associated projects, as well as semester start/end dates, and project/individual deadlines. When an administrator logs in, the default tabs are Summary, Manage Semester, Manage Project, Manage Users and Deadlines, all of which are described in the following sections. The layout is shown in Figure 3.1.

Manage Projects

Every student account must be assoicated with a project, in order to do so, a project must be created before adding a student account.

Adding a Project

When adding a project, you must enter a unique project ID, and a name for the project. Once all fields have been validate, you may then click the "Add Project" button. When a project is added it is marked active for the current semester. Only active projects are displayed in the project table. For reference, see Figure 3.2.1.

Figure 3.2.1 - Adding a Project

Deleting a Project

To delete a project, select the check box to the left of the record in the table. You may select more than one project at a time. Once you have selected all of the projects you wish to delete, click the "Delete Project(s)" button. You will be promted with a confirmation box, if you wish to continue, please click "Ok", if you do not want to continue with the delete, please click "Cancel". When a project is deleted, all assoicated users, timesheets and tasks are deleted as well. Upon deletion the administrator is prompted with an confirmation box, confirming the delete. For reference, see Figure 3.2.3 and 3.2.4.

Manage Users

An adminstrator can add or edit two types of users, other administrators or students. The type of user being added or edited is determined by which radio button is selected, this radio button also determines which user table is displayed to the right. Each user is identified by a user ID, this user ID is automatically assigned by using the prefix of the user's email address. A valid email address must be entered, the prefix can only contain letters (a-zA-Z), number (0-9), and special chacters of (- _ or .). Administration email addresses are automatically assigned the the domain of "senecac.on.ca", and student email addresses are automatically assigned the domain of "learn.senecac.on.ca". Once all of the corresponding fields have been entered and validated, the user is emailed an auto-generated password, this password should be changed as soon as possible using the Change Password function (see Section 3.1.2). A description of how to add or edit each type of user is listed below.

Adding an Administrator User

To add an administrator, make sure the "Adminstrator" radio button is selected. You must enter a first and last name of the administrator, each may only be a maximum of fifty characters. An email address prefix must also be entered, currently on the Seneca College Web Mail, a valid professor email address should be formatted as "first_name.last_name". The email prefix may only be thirty-six characters long. Once all of the required fields have been entered, click the "Add Administrator" button, and the new administrator will be shown in the table to the right. If there are any validation errors, they will be shown below each of the fields. For reference, see Figure 3.3

Adding a Student User

To add a student, make sure the "Student" radio button is selected. You must enter a first and last name of the student, each may only be a maximum of fifty characters. An email address prefix must also be entered, the email prefix may only be twenty characters long. Each student must also be assoicated with a project, to do this select a project name from the Project Name drop down list (the project ID is assoicated within this drop down list). Once all of the required fields have been entered, click the "Add Student" button, and the new student will be shown in the table to the right. If there are any validation errors, they will be shown below each of the fields.
A group of students may be entered at one time by uploading a Comma Separated Value File (CSV), in the file upload section (see Figure 3.4).
The format of the file should be as follows: Last_Name, First_Name, Student_ID, Project_ID, making sure that each field is separated by a comma.
An example of a record in this file would look like the following:
Doe, John, JDoe, bts630_071g01
For reference, see Figure 3.4

Editing a User's Details

To edit a user's details, press the "Edit" button located to the far right of the user's record. This will load the user's details into the form to the left. The email prefix will be disabled, and you will only be able to edit the enabled fields (first name and last name for an administrator, and first name, last name, and project ID/name for a student). Once you have edited the details, you can submit the changes by clicking the "Update <User Type>" button.
Note: If you would like to change the user's email address, you will have to delete the user, and re-add them. (For deleting instructions please see Section 3.2.2.4, and for adding instructions please see Section 3.2.2.1 or 3.2.2.2) For reference, see Figure 3.5.

Deleting a User

To delete a user, select the check box to the left of their record in the table. You may select more than one user at a time. Once you have selected all of the users you wish to delete, click the "Delete <User Type>" button. You will be promted with a confirmation box, if you wish to continue, please click "Ok", if you do not want to continue with the delete, please click "Cancel". For reference, see Figure 3.6.1 and 3.6.2.
Note: If you are deleting a student, you will also be deleting all associated timesheets and tasks for this student.

Deadlines

The administrator can create two types of deadlines, individual work deadlines for students, or project work deadlines that are to be completed by all project members.

Adding a Deadline

To select a certain type of deadline, select the appropreiate radio button, "Individual" or "Project". For an "Individual" deadline, you may select a "Timesheet" or "Other". For a "Project" deadline, you may select a "Project File" or "Other", for reference see Figure 3.7.1.

When selecting "Other" for either deadline type, a textbox will appear where you must enter a description for that item. For reference see Figure 3.7.2. Once you have selected your deadline type and item name/description, you must select a due date that falls within the dates of the current semester, the current date is hilighted with a border in light grey. After all fields have been validated, you may click the "Add Deadline" button.

Editing a Deadline

To edit a deadline's details, press the "Edit" button located to the far right of the user's record. This will load the deadline's details into the form to the left. The current due date will be hilighted with a dark grey background. You may make changes and then click the "Update Deadline" button. For reference, see Figure 3.8.

Deleting a Deadline

To delete a deadline, select the check box to the left of the record in the table. You may select more than one deadline at a time. Once you have selected all of the deadlines you wish to delete, click the "Delete Deadline" button. You will be promted with a confirmation box, if you wish to continue, please click "Ok", if you do not want to continue with the delete, please click "Cancel". For reference, see Figure 3.9.1 and 3.9.2.

Manage Semester

There must be an active semester, before any other functions can be used. A student may not login if there is no active semester. Adminsitrators are forced to add, or extend a semester if there is no active one. Once a semester has been added, it may not be deleted, only extended.

Adding a Semester

Adding a semester is only premitted if a semester has ended, or there is no active semester. To add a semester, make sure that the "Add" radio button is selected. You may then select a semester ID from the drop down lists, which is unique and does not exist already. You may then select a start date for the semester, the start date must be after the end date of the previous semester (if any), but not later the the selected end date for the newly added semester. You may also select an end date for the semester, which must be later than the start date. Neither dates may be left blank. Once all fields have been validated, you may click the "Add Semester" button. For reference, see Figure 3.10

Figure 3.10 - Adding a Semester

Extending a Semester

Extending a semester is only premitted if there currently is an active semester. A semester's end date may be extended at any time, or when the previous semester has ended. You may extend the semester by choosing an end date that is later than the current semester end date. Once the end date has been validated you may click the "Update Semester" button. For reference, see Figure 3.11.

Student

Project File

The project file contains all the tasks that a group has completed or is going to complete. All tasks are broken in Summary Tasks that categorizes these tasks. For example, Create Tables might be one task in your Database category.

Time is broken into hours, and fractions if necessary. For example, 3.33 hours represents 3 hours and 20 minutes. Which you can get by calculating (time you spent in minutes)/60

Reminders

The calendar has coloured days for a quick analysis of future deadlines.

• Purple days represent deadlines that the entire team is responsible for

• Green days represent individual deadlines and timesheet deadlines