Mackygrupo Progress Report 10

Mar24-28

Things we have accomplished: Jerick prototype Daryl installer and exe Tina updated user manual Macky Lalaine revised report layouts documentation - interview summary, interview questions, revised class diagrams, description final presentation slides

Our next week goals are: vacation! CS 130 Exam

Our most important concerns/issues/questions are:

We learned: Jerick py-bcript, more about the project Daryl py2exe, NSIS Tina more about revising documentation Macky Lalaine more about documentation

Mackygrupo Progress Report 9

Mar17-23

Things we have accomplished: Jerick prototype, started connecting the db Daryl db Tina updated user manual Macky Lalaine meeting with client

Our next week goals are: Final Presentation Finalize Project - prototype and database Finalize Documentation

Our most important concerns/issues/questions are: Additional features specified by client - needs to be discussed prototype features and layout revision of logical database design

We learned: Jerick different ways to print using python. Daryl pysqlite Tina more about revising documentation Macky Lalaine sqlite features of glade more about the database

Mackygrupo Progress Report 9

Mar17-23

Things we have accomplished: Jerick prototype, started connecting the db Daryl db Tina updated user manual Macky Lalaine meeting with client

Our next week goals are: Final Presentation Finalize Project - prototype and database Finalize Documentation

Our most important concerns/issues/questions are: Additional features specified by client - needs to be discussed prototype features and layout revision of logical database design

We learned: Jerick different ways to print using python. Daryl pysqlite Tina more about revising documentation Macky Lalaine sqlite features of glade more about the database

Mackygrupo Progress Report 8

Mar10-Mar16

Things we have accomplished: Jerick prototype Daryl db Tina updated user manual Macky Lalaine

Our next week goals are: Prototype database implementation

Our most important concerns/issues/questions are: database design revisions prototype design

We learned: Jerick more about gtk Daryl more about pysqlite Tina revising documentation Macky Lalaine more about SQLite using SQLite manager

Mackygrupo Progress Report 7

Mar3-Mar9

Things we have accomplished: Jerick updated prototype Daryl db Tina updated user manual Macky Lalaine

Our next week goals are: Prototype Database Implementation

Our most important concerns/issues/questions are: Using pysqlite and SQLite instead of mysql prototype design

We learned: Jerick features of sqlite Daryl SQLite, pysqlite Tina documentation has to keep up with a prototype's flexibility Macky Lalaine SQLite

Mackygrupo Progress Report 7

Mar3-Mar9

Things we have accomplished: Jerick updated prototype Daryl db Tina updated user manual Macky Lalaine

Our next week goals are: Prototype Database Implementation

Our most important concerns/issues/questions are: Using pysqlite and SQLite instead of mysql prototype design

We learned: Jerick features of sqlite Daryl SQLite, pysqlite Tina documentation has to keep up with a prototype's flexibility Macky Lalaine SQLite

Mackygrupo Progress Report 6

Feb 25-Mar2

Things we have accomplished: Jerick updated prototype Daryl updated screen prototype Tina updated user manual Macky Lalaine Poster for CS Symposium meeting with client

Our next week goals are: Final Prototype Database Implementation

Our most important concerns/issues/questions are: prototype design

We learned: Jerick other useful python modules. Daryl more about gtk, pygtk, python, and various python modules Tina keeping documentation up-to-date Macky Lalaine how to use Adobe Photoshop formulas to be used in the project

Mackygrupo Progress Report 6

Feb 25-Mar2

Things we have accomplished: Jerick updated prototype Daryl updated screen prototype Tina updated user manual Macky Lalaine Poster for CS Symposium meeting with client

Our next week goals are: Final Prototype Database Implementation

Our most important concerns/issues/questions are: prototype design

We learned: Jerick other useful python modules. Daryl more about gtk, pygtk, python, and various python modules Tina keeping documentation up-to-date Macky Lalaine how to use Adobe Photoshop formulas to be used in the project

Mackygrupo Progress Report 5

PROGRESS REPORT

Feb 18-24

Things we have accomplished: Jerick Updated screen prototype Daryl Updated screen prototype Tina updated user manual Macky database implementation Lalaine database implementation sample data

Our next week goals are: Final Prototype Database Implementation Project Poster

Our most important concerns/issues/questions are:

We learned: Jerick more about gtk Daryl more about python and gtk Tina proofreading documentation Macky Using MySQL Query Browser Lalaine using SQLyog enterprise using MySQL Query Browser

Mackygrupo Progress Report 4

Feb 11-17

Things we have accomplished: Jerick Prototype Daryl Tina Macky Lalaine Report Layouts

Our next week goals are: Final Prototype User Manual Report Layouts Database Implementation

Our most important concerns/issues/questions are:

We learned: Jerick The use of Matplotlib, a plotting library for python. How to draw a pie chart using Matplotlib. More on Tepache, PyGTK, Python. Daryl Tina Macky Lalaine

GP’s Progress Report 8

This week we have accomplished

->Integration of all the codes made

• Beth Mercado: Tested the program for applicant functionalities
• Rona Tadlas: Tested the program for scholar functionalities
• Perla Loro: Tested the program for administrator’s functionalities
• KC Ferre: Tested the error cases of the program,updated and finalized all documentations

Our next week goals:

• Debugging of codes and preparation for the final presentation

Our most important concerns/issue:

· There are lots of errors encountered when we integrated our individual codes

We learned:

• Beth Mercado: Testing of the project by other people is really important and as well as the relation of all documentation with the final project. Teamwork is really needed in every group activity.
• Rona Tadlas: Teamwork and time management are important.
• Perla Loro: Teamwork and time management are very vital in creating a project
• KC Ferre: Integration of all we made in the project must really be given enough time because there were some inconsistencies that were not avoided

GP’s Progress Report 7

This week we have accomplished

• Beth Mercado: Connected the applicant functionalities to the database
• Rona Tadlas: Connected the scholar functionalities to the database
• Perla Loro: Connected most of the admin functionalities to the database, tested the program
• KC Ferre: Helped in connecting the admin functionalities to the database, made error checking codes, added confirmation messages for deletion

Our next week goals:

• Finalize the connection to the database, integration of all the codes into one final code and test the program if it’s functioning correctly

Our most important concerns/issue:

· MySQL queries and inconsistency of variables

We learned:

• Beth Mercado: Integration of our codes is very erroneous
• Rona Tadlas: Software testing is important
• Perla Loro: Integration needs extra carefulness
• KC Ferre: It’s hard to work on other’s codes and comments would really help understanding those codes that’s why it’s more advisable to work together for easier understanding of codes

GP’s Progress Report 6

This week we have accomplished

• Beth Mercado: Finalized the project’s prototypes
• Rona Tadlas: Finalized the project’s prototypes
• Perla Loro: Connected the log-in interface to the database
• KC Ferre: Started connecting the viewing functionality of administrator to the database

Our next week goals:

• Continue connecting the user interface to the database

Our most important concerns/issue:

· It’s been hard connecting to the database when the prototypes aren’t yet final.

We learned:

• Beth Mercado: MySQL, PHP
• Rona Tadlas: My SQL, PHP
• Perla Loro: MySQL, PHP
• KC Ferre: MySQL, PHP

GP’s Progress Report 5

This week we have accomplished:

• Beth Mercado: Make necessary changes in the project’s prototypes
• Rona Tadlas: Make ‘create table’ queries
• Perla Loro: Encrypted passwords using sha1 and handled sessions
• KC Ferre: Make ‘insert table’ queries with all the sufficient sample data

Our next week goals:

• Connect the database to the user interface

Our most important concerns/issue:

· There are some problems regarding foreign keys in our queries

We learned:

• Beth Mercado: how to connect database to the project
• Rona Tadlas: MySQL queries
• Perla Loro: use sha1 and make sessions
• KC Ferre: one cannot insert data in some tables if it refers to a non-existent foreign key of another table; and to validly insert data, one should consider the types of variables, constraints, etc.