Team Log

Submitted by kchong on Thu, 2011-01-13 13:00

This team log briefly summarizes activity in descending order.

Each entry records the date and amount of time spent, type of entry, and text describing the entry. An entry is one of three types:

  • A description records an activity;
  • An explanation says why something happened;
  • A prescription is a plan for something to do later.
Date
2011-03-13
Member(s)
Kyle Chong
Time Spent
1 hour
Description
Miscellaneous fixes. Web versions of documents updated to reflect latest changes.
Date
2011-03-13
Member(s)
Derek Lyons
Time Spent
90 minutes
Description
Created a vector logo, edited slide content, and redesigned the background for the final presentation.
Date
2011-03-11
Member(s)
Kyle Chong
Time Spent
7 hours
Description
Finished administrative backend. Import and export of scheduling spreadsheets is now fully implemented. Only remaining tasks is finding and fixing bugs (testing that we likely don't have time for).
Date
2011-03-10
Member(s)
Kyle Chong; Derek Lyons
Time Spent
30 minutes
Description
Ninth meeting with Professor Carey. We went over the changes to the prototype. The new database schema was discussed. He recommended that we use transactions for handling mass queries (e.g. when importing by spreadsheet).
Date
2011-03-07
Member(s)
Kyle Chong
Time Spent
2 hours
Description
Laid groundwork for administrative backend. Most basic functions (e.g. editing courses, instructors) currently work, although overall pages have yet to be created. Bulk of the remaining work lies in building robust forms (validation) as well as transactional import of spreadsheets.
Date
2011-03-03
Member(s)
Kyle Chong; Derek Lyons
Time Spent
20 minutes
Description
Eighth meeting with Professor Carey. We went over the changes to the prototype. The new database schema was discussed. He recommended that we use transactions for handling mass queries (e.g. when importing by spreadsheet).
Date
2011-02-28
Member(s)
Danny Kim
Time Spent
15 minutes
Description
Made modifications to the Software Design Document by replacing a duplicate sequence diagram with the appropriate diagram.
Date
2011-02-28
Member(s)
Danny Kim, Kyle Chong, Derek Lyons
Time Spent
2.5 hours
Description
Created and modified "final" presentation for Tuesday's (3/1/11) presentation. This presentation will be modified after receiving feedback in preparation for the actual final presentation to be delivered to our project sponsor.
Date
2011-02-28
Member(s)
Kyle Chong
Time Spent
6 hours
Description
Redesigned database schema to use surrogate keys. The existing data was updated to reflect the new schema. Courses such as COMPSCI 295 and STATS 295 (the reasons for the change in database schema) were updated to demonstrate the new functionality. The system was modified to use surrogate keys. Additionally, course details now contain a history of all the years they were offered. Importing schedules by spreadsheet has been implemented to the point of printing the generated sql; however, the queries are not actually sent at this time to avoid the possibility of database corruption.
Date
2011-02-24
Member(s)
Kyle Chong; Derek Lyons
Time Spent
50 minutes
Description
Seventh meeting with Professor Carey. We went over the changes to the prototype. He decided that he liked the use of rounded corners for title row differentiation, so we've made that aspect more distinct.
Regarding the representation of programs that courses belong to in the spreadsheet, they may be appended as columns to the right of all other information due to the potentially large number of programs a course may belong to.
One of the major things realized during this meeting was that the composite key of year, department, and number does not match the real life model. For example, COMPSCI 295 is a catch-all that contains multiple different courses for each quarter despite all having the same year, department, and number. Thus, we must introduce a surrogate key into the database to ensure unique records.
Date
2011-02-20
Member(s)
Kyle Chong
Time Spent
2 hours
Description
Ported Java-like StringTokenizer class. The string tokenizer was used to create a parser for Derek's prerequisite output. Modified database schema to allow for 'other' prerequisites apart from courses, such as LOWER DIVISION WRITING, or SENIOR STANDING, etc. The database is now populated with prerequisite data.
One thing to note is that many of the courses for which we have prerequisites data are not in the database, likely because the courses have not been offered since ICS started maintaining their database. However, there are enforced database constraints that do not allow prerequisites to exist for courses that are not in the database. This ensures that prerequisites will be for the course of correct year; not a different course with the same department and number in another year. Essentially, there will not be any issues when the database has course records for every course.
Date
2011-02-20
Member(s)
Derek Lyons
Time Spent
2 hours
Description
Debugged and wrote an output mode for the offline prerequisites parser to conform to the prerequisites database structure.
Date
2011-02-19
Member(s)
Kyle Chong
Time Spent
1 hour
Description
Implemented prerequisites structure in database and the course details page. Currently, only CSE has prerequisites data for the sake of testing purposes. Additionally, some error-handling code now exists for cases such as missing courses.
Date
2011-02-18
Member(s)
Derek Lyons
Time Spent
38 minutes
Description
Replaced Use Case diagrams in the SRS with color versions. Looked for inconsistency between our database and the WebSOC database. This inconsistency is due to our current data acquisition method which is not tied to WebSOC and, as such, is not updated concurrently with the same information once the school year begins. Deleted test results due to them no longer being relevant.
Date
2011-02-18
Member(s)
Kyle Chong
Time Spent
3 hours
Description
Implemented various tweaks, such as the addition of the CSS3 border radius property to more distinctly style title rows. Forms now generate options directly from database records, so the system will always be up-to-date in regards to information available (thus, the addition of new years, programs, etc, will be reflected in the system if the records are in the database). Refactored codebase to make page structure easier to understand and allow for modular change. Some files were renamed for this purpose as well.
Date
2011-02-18
Member(s)
Derek Lyons
Time Spent
70 minutes
Description
Performed Use Case Test #2 and posted results.
Date
2011-02-18
Member(s)
Derek Lyons
Time Spent
11 minutes
Description
Added some Use Case Test Results to the Software Test Plan. Numbered each use case test with a bullet for each description. Performed Use Case Tests 6-8 and posted results.
Date
2011-02-18
Member(s)
Derek Lyons
Time Spent
17 minutes
Description
Added Use Case Tests to the Software Test Plan.
Date
2011-02-17
Member(s)
Danny Kim
Time Spent
25 minutes
Description
Updated the overall sequence diagram and the "Administrator Sequence Diagram" found in the Software Design Document in order to include the functionality of importing/exporting excel spreadsheets.
Date
2011-02-17
Member(s)
Kyle Chong; Derek Lyons
Time Spent
40 minutes
Description
Sixth meeting with Professor Carey. We went over the changes to the prototype. He decided that the tapered bottom of title rows was enough differentiation, so we do not need a full line of separation between sets of courses and their title rows.
Regarding the highlighting in the spreadsheet, he requested the addition of multiple columns to represent all the programs in which the course was a core requirement. Also, a public version of the export functionality should be available without professor UCInetID's (due to spam concerns).
For the administrative backend, it is acceptable that we implement the functionality without security (e.g. secure connection, encryption). It is assumed that integration of the project into the ICS website would mean integration with the UCInetID authentication system by internal ICS programmers.
Another optional feature to be implemented (time pending) is fuzzy searching/matching, for both the on-the-fly search as well as the importing of spreadsheets. However, it is not necessary to accommodate to this extent, so it is acceptable to simply report errors or no results. He emphasized the need for strenuous error-checking and input validation, as database corruption is possible.
Finally, it was made clear that the minimum version of PHP required for our system is 5.2. The current version installed on ICS systems is 5.1, but we do not have to regress functionality to be backwards-compatible. It is expected that the department will upgrade its installation of PHP should it decide to use our system.
Date
2011-02-16
Member(s)
Kyle Chong
Time Spent
2 hours
Description
Revised database structure to include the core courses of Bren programs. Implemented filtering by program, and revised the export functionality to highlight core courses. Presentation was updated to reflect these changes.
Date
2011-02-16
Member(s)
Danny Kim
Time Spent
2 hours 30 minutes
Description
Filled in a skeleton use-case on the Software Requirements Document. Created a new overall sequence diagram for the Design Document. Also created separate sequence diagrams for each of the six use cases found on the Requirements Document.
Date
2011-02-15
Member(s)
Derek Lyons
Time Spent
70 minutes
Description
Added a third Use Case diagram to the SRS. Replaced the diagrams of Use Cases 1 and 2 to be clearer and match the diagram for Use Case 3. Uploaded images and set up sections for Use Cases 4-6.
Date
2011-02-15
Member(s)
Kyle Chong
Time Spent
1.5 hours
Description
Created Presentation 3. Discarded the lackluster template we had been using (DJ Dodson's last contribution) in preparation for the polish that will be required for the final presentation. Outlined presentation structure and summarized the concerns of the after-class team meeting in a group email to ensure clarity.
Date
2011-02-15
Member(s)
Kyle Chong; Danny Kim; Derek Lyons
Time Spent
20 minutes
Description
Met as team in the remaining time after class (due to class ending early). Various concerns regarding documentation were discussed. Presentation order for Thursday was also determined.
Date
2011-02-14
Member(s)
Kyle Chong
Time Spent
3 hours
Description
Researched viability of spreadsheet export-import feature as requested by Professor Carey. Settled on PHPExcel as a viable solution and proceeded to implement export to Excel spreadsheet functionality. This library will also be used for importing data from spreadsheets into the database. Also fixed some minor issues with the prototype.
Date
2011-02-11
Member(s)
Derek Lyons
Time Spent
25 minutes
Description
Edited the Test Plan, Design Document, and Project Plan to fix some issues such as verb-subject agreement, formatting, section title capitalization, and missing features.
Date
2011-02-10
Member(s)
Derek Lyons
Time Spent
2.5 hours
Description
Added additional functionality to an offline prerequisite parser to further populate the database for use with linking from courses to their prerequisites.
Date
2011-02-10
Member(s)
Kyle Chong; Derek Lyons
Time Spent
30 minutes
Description
Fifth meeting with Professor Carey. We presented the changes to the prototype since the last meeting. Again, there are aesthetic changes desired, primarily with further differentiating the sets of courses and their corresponding titles.
As only minor progress had been made since the previous week, there was little else to discuss. We requested some additional information regarding the ICS systems (e.g. version of PHP and MySQL) for compatibility concerns.
Date
2011-02-09
Member(s)
Danny Kim
Time Spent
2 hours
Description
Made updates and additions to the Project Plan and Test-Plan. All documents should now follow correct revision history formatting.
Date
2011-02-06
Member(s)
Kyle Chong
Time Spent
1 hour
Description
Extended object classes. Both the course listing and the course details page now use objects to represent data. The change in paradigm should improve the quality of implementation since Course objects are common to multiple functions.
Date
2011-02-05
Member(s)
Kyle Chong
Time Spent
2 hours
Description
Implemented css to visually link a course row and its title row together. The course cells which show instructors now also indicate how many times the instructor is teaching that course during that quarter if more once. Began transition from procedural logic to object-oriented logic. The prototype is now in a stage where a revision control system is desired, so I have begun to use Mercurial to track versions.
Date
2011-02-04
Member(s)
Kyle Chong
Time Spent
30 minutes
Description
Modified database schema to allow for a professor to teach the same course in the same quarter multiple times. Also added a table to store the core courses of each major for undergraduates and graduates. Elaborated on database schema and prototype in the design document.
Date
2011-02-03
Member(s)
Kyle Chong; Derek Lyons
Time Spent
1.1 hours
Description
Fourth meeting with Professor Carey. We presented the changes to the prototype since the last meeting. There appears to be general satisfaction with its current state, albeit certain aesthetic tweaks were requested. These tweaks are the addition of blue borders between rows if title is not shown, as well as some visual indication of connection between a course and its title row (e.g. shared color along left side). It was also requested that the system incorporate data that we may not currently have, but may dictate as a requirement for maintenance when the system goes into production (e.g. units, category). A link to the year's catalog on the course details page was also suggested.
We have also settled on a data format with the aid of the context in which the Bren School scheduling occurs. It is the case that the chair requests from each professor what he or she would like to teach in the coming year, which the chair receives informally (e.g. email). The chair then uses this data to make a spreadsheet, which is then sent back to the professor for review. Thus, the process involves an artifact (the spreadsheet) which is sent between various persons in various incarnations. Therefore, our system should be built with this process in mind, in that the system can export its data as a spreadsheet, and import data from spreadsheets in the same format. We are still in the process of determining exactly what this format will consist of, and what filetype is viable.
Other important notes include the addition of a "quantity" field to the schedule table in order to represent professors teaching the same course multiple times during the same quarter of the same year. Another consideration that Professor Carey intends to investigate is how visiting professors are stored, because the current database schema requires instructors to have a UCInetID. Another requirement is the ability to view courses that are not taught; in other words, a view of all courses in the database. Finally, optional functionality was brainstormed for implementation post-requirements. This functionality is the creation of alternative views, such as viewing by professor to see what each professor is teaching per quarter.
Date
2011-02-03
Member(s)
Kyle Chong
Time Spent
2 hours
Description
The course details page has been reworked to make the description more prominent and to list the instruction schedule of the course at the bottom. For the listing, the on-the-fly search functionality now includes course descriptions. Also, titles are now displayable (shown by default) and may be toggled on or off on a per-course basis or for the current listing results at once. The database has been fully populated with this year's planned schedule.
Date
2011-01-31
Member(s)
Derek Lyons
Time Spent
10 mins
Description
Edited the Project Description and Executive Summary to reflect the length and detail preferences expressed by the course TA.
Date
2011-01-31
Member(s)
Danny Kim
Time Spent
45 mins
Description
Updated the Project Plan Document with a Gantt Chart of deliverables and milestones
Date
2011-01-30
Member(s)
Kyle Chong
Time Spent
5 hours
Description
The database structure has been reworked in light of the new requirements. The system now fully supports unique course entries for every year. When sorting, a natural sort algorithm is used so that course numbers are now sorted in natural order rather than in lexicographical order. In addition, the on-the-fly search functionality now includes course titles. Individual column sort fields are also available. Columns may be dynamically hidden or shown, with summer being hidden by default. Remaining tasks include reworking the course details page and populating the database with currently available course and schedule information.
Date
2011-01-30
Member(s)
Danny Kim
Time Spent
3 hours
Description
Created two individual use cases for the Requirements Document with descriptions under each diagram. Added three new sections to the Project Plan: Technical Constraints, WBS, Communication Covenant. Gantt chart wasn't created for the WBS yet because I do not have MS Project right now.
Date
2011-01-28
Member(s)
Derek Lyons
Time Spent
20 mins
Description
Added descriptions to the components listed in Low-Level Architecture.
Date
2011-01-28
Member(s)
Danny Kim
Time Spent
45 mins
Description
Added a deployment architecture diagram for the high-level architecture of our web interface. A short description describing the diagram has also been added.
Date
2011-01-27
Member(s)
Kyle Chong; Derek Lyons
Time Spent
1.2 hours
Description
Third meeting with Professor Carey. Professor Carey relayed his findings since the last meeting. There is a MySQL database of Bren School lower- and upper-division courses that is updated yearly by hand. It contains the following information: course department, course number, course description, and the max enrollment for fall, winter, and spring (where 0 means no enrollment). This information is useful for our purposes, but still lacking. Fortunately, we have another source of data, the yearly teaching plan of Bren ICS courses, from which we can parse instructors of these courses. Data we cannot get easily include course prerequisites, instructor names, and instructor urls, all of which will not have to be updated often and thus may be manually added and maintained over time. We utilized the current prototype to discuss design changes. Additional requirements gleaned from this meeting include: make summer column optional (due to lack of available information as well as a lack of need from the majority of students), and the ability to search by course title. Support for multiple years is desired time permitting; otherwise it is acceptable for the system to support only the current year.
Date
2011-01-26
Member(s)
Derek Lyons
Time Spent
30 minutes
Description
Added components to the Lower Level architection section of the system design document
Examined and provided instructions on how to construct a WebSOC prerequisite query string in lieu of a fully functional prerequisite search and link generation mechanism.
Updated timestamps on documents to reflect when they were last edited.
Date
2011-01-26
Member(s)
Kyle Chong
Time Spent
3 hours
Description
Prototype database schema revised, preliminary course details page created.
Date
2011-01-26
Member(s)
Danny Kim
Time Spent
40 mins
Description
Created the first iteration of the Software Design Document with the first two sections filled in (Scope and Purpose of Doc).
Date
2011-01-25
Member(s)
Kyle Chong
Time Spent
6 hours
Description
Prototype started, displays course offerings by quarter for selected year filtered by course level and department. Database with dummy data created as one large table for testing purposes. The structure of relational tables will be designed and implemented later.
Date
2011-01-25
Member(s)
Danny Kim
Time Spent
30 mins
Description
Two new sections to the Requirements Document were added: Assumptions, and Software Requirements.
Date
2011-01-24
Member(s)
Kyle Chong
Time Spent
1 hour
Description
The requirements specification was updated with the current status of the project. In addition, the first iteration of the software test plan was expanded. However, it is still mainly a skeleton and the sections will be elaborated upon in the next iteration.
Date
2011-01-23
Member(s)
Danny Kim
Time Spent
1 hour
Description
The first iteration of the software test plan was created. The first iteration is mainly a skeleton at this point with specifications to be added on the next iteration.
Date
2011-01-20
Member(s)
Kyle Chong; Derek Lyons; DJ Dodson
Time Spent
1 hour
Description
Our second meeting with Professor Carey occurred. Using the results of the market analysis, we were able to narrow down a general layout and a number of pages we must have. We intend to mock-up these pages and in the process of doing so determine what information we need to store in the database.
Date
2011-01-17
Member(s)
Danny Kim
Time Spent
1 hour
Description
The first iteration of the project plan was created. The requirements specification was created on Google Docs and will be converted into the ReadySET document template to remain consistent with the requirements specification and all future documents.
Date
2011-01-17
Member(s)
Kyle Chong; Danny Kim
Time Spent
1 hour
Description
The first iteration of the requirements specification was created and is available @ http://aquarius.kylechong.com/requirements/specification.html. The requirements specification is based on the ReadySET document template which is referenced in Professor Ziv's requirements guidelines.
Date
2011-01-16
Member(s)
Kyle Chong; DJ Dodson; Danny Kim; Derek Lyons
Time Spent
20 minutes
Prescription
We intend to consolidate the best elements from our market analysis to create a mock-up to clarify the software requirements at our next meeting with Professor Carey on 2011-01-20 at 5-5:30p in DBH 2091.
Date
2011-01-16
Member(s)
Kyle Chong; DJ Dodson; Danny Kim; Derek Lyons
Time Spent
1 hour
Description
We looked at the top ten universities for computer science according to US News, as well as all of the UC schools. We examined the course listings available at those universities as if we were students interested in planning our schedules throughout the year and noted anything done well.
Date
2011-01-13
Member(s)
Kyle Chong; Derek Lyons
Time Spent
30 minutes
Description
The meeting with Professor Carey occurred. At this time, Professor Carey has no requirement apart from the fact that the project must be implemented as a web application. This web application does not have any constraints; it does not have to be designed like the current UCI ICS course listing (in fact, the anti-requirement is that it should not look like the current website), neither in style nor in structure. We are free to choose the data storage of our choosing, though he is going to inquire as to what database backend, if any, is currently being used for the current course listing. Thus, he has recommended that we simply do market analysis for requirements, in that we should determine the successful elements of course listing websites at competing universities (successful defined as satisfactory for the students at those universities) to incorporate them into our implementation.
Date
2011-01-13
Member(s)
Kyle Chong
Time Spent
30 minutes
Description
Team website created to fulfill course requirements and facilitate team coordination. Available @ http://aquarius.kylechong.com
Date
2011-01-11
Member(s)
Kyle Chong
Time Spent
10 minutes
Description
Meeting scheduled with Professor Carey for requirements elicitation in DBH 2091 @ 5-5:30p on 2011-01-13.
Date
2011-01-10
Member(s)
Kyle Chong
Time Spent
10 minutes
Description
Team members' availability and contact information exchanged. Schedule of availability @ http://www.google.com/calendar/embed?src=NDVyN2VnMjlpb3JvZjc5YTdjOXAza2I4YmdAZ3JvdXAuY2FsZW5kYXIuZ29vZ2xlLmNvbQ