Research Log of Web Science Students

Computer Science is not simply programming

Posts Tagged ‘UPS

Into XML

leave a comment »

Whoever said “Maraming namamatay sa maling akala…” is a really wise person.

I thought that XML is just about tags and data, but NO… there’s more to XML than those two things. I’ve started reading a book about XML so I can use whatever I’d pick up from there for our XML Schema.

P.S. Thanks Ma’am Weng for the book! 🙂

Advertisements

Written by jasetiojanco

September 16, 2009 at 1:41 pm

Posted in UPS

Tagged with , ,

Thank You, Admissions, Thank You.

with one comment

One of the things we need for our project  is a lot of various F-137s from different schools. The Office of Admissions was supposed to provide that.

Today, Ma’am Leah informed me that the Office of Admissions wouldn’t be handing us the F-137s. Confidentiality issues. Oh crap. How in the world will we be able to make the template for UPS? Ma’am Leah told me to write a letter addressed to them, saying that the F-137s would be used within the department and for research purposes only.

Hopefully they’d change their mind. 😐

Written by jasetiojanco

September 8, 2009 at 6:14 am

Posted in UPS

Tagged with , ,

Hello Admissions

with one comment

Finally, after weeks of waiting we’ve finally met with the head of the Office of Admissions. The consultation was scheduled by Ma’am Leah at around lunch time so right after our CS 131 class, I zoom-zoomed to their building.

Funny as it sounds, but I got lost inside the Office of Admissions building. I was looking around, trying to guess the whereabout of Ma’am Leah, even asking the guard where she was. Thank goodness, she appeared behind the glass windows on the upper level of the building and signalled me to go up.

When I met her, we immediately went to the Admissions Head. After introducing myself, it was straight to business. I explained our project to the Office of Admissions person, giving every detail of it. Everything was going well until I mentioned about the transmutation of their grades into the UPCAT-accepted form. Apparently, their process of transmuting grades is confidential. According to him, the process is part of Academic Freedom and it’s their discretion as to how they would compute the grades. By including that in our software, we would be practically giving away their method of computing the high school grades since we would be distributing the software to the registrars of high schools. Also, he told me that the way of computing the grades changes every year, so it would be a huge effort to upgrade the software every year just because of the changes in grades.

OOOOOKAY. There goes part of our project. Ma’am Leah suggested though that we could still include grade transmutation given that it is open-ended, meaning the user can change the values for the grades, and the other that it should not be dependent on how the Office of Admissions processes the UPCAT grades. In short, it would be a tool to represent their grades, whatever format they may be, to one single form, let’s say, numerical.

Another problem they saw was that there was no way to verify the grades if they were to be submitted online. The registrar could easily alter the grades if they’re given online since there was no way of checking them. The solution proposed was to allow the online version to be printed and it has to be signed by the principal.

One more thing, they wanted us to create a template of grades that can be used by different schools, not just for the UPCAT. Ma’am Leah told me that the F-137 (Transcript) forms of various schools can be borrowed from the Office of Admissions so YAY.

After the meeting, Ma’am Leah and I talked to each other to clarify some things about our project. She has already set a meeting with us next week so there, yay!

Written by jasetiojanco

September 4, 2009 at 2:57 am

Posted in UPS

Tagged with , , ,

POI-lease Cooperate

leave a comment »

The XSSF part of the POI library can’t be found by our program. The thing is the POI library contains all Apache-POI components, including HSSF+XSSF. The HSSF bit is ok, but whatever happened to XSSF? I need to fix this as soon as possible. 😐

Written by jasetiojanco

September 2, 2009 at 3:15 am

Posted in UPS

Tagged with , , ,

Finally, a (probable) Solution!

with one comment

Most of you know that one part of our project is processing a spreadsheet (template for grades) and convert it to XML. We already have a solution for Excel files, which is Apache-POI. But for OpenOffice Spreadsheets (note: *.ods spreadsheets), we were feeling a little bit hopeless.

Thank God for online communities! I was browsing through a forum when I stumbled upon a person asking how to use ODS files in Java. There were some not-so-nice replies (like someone saying you can’t since ODS is an open, unusable format) and there were some gems. Yes, gems. A person referred the person asking to a site which contains a library for using ODF files in Java!

One of the links posted there redirected to the OpenOffice ODF Toolkit Project page. According to the site, the odftoolkit…

Aims to provide a home for libraries and tools that ease the development of applications that support ODF, where applications means applications in general, not just office productivity applications like OpenOffice.org

Woohoo! We’re one of those who’d be developing applications that would be supporting ODF.

The other recommendation of one of the people who replied to the thread was jOpenDocument. This one looks good as well, the guy was even kind enough to include a code (which reads/writes spreadsheets in ODS) as reference.

As for which to use between the two, well, I have to try first. Whichever is easier to work it will be the one to be used. Contest? Haha!

Written by jasetiojanco

August 26, 2009 at 9:27 am

Posted in UPS

Tagged with , , , ,

It’s Working!

leave a comment »

Yay! After hours of coding I’ve finally finished the prototype for the XLS Parser. It only supports Excel ’97 – ’03 but at least I’m going somewhere.

The program can read an Excel file, parse it, then convert it into XML already! As of now, the subjects I included in the template are Math, Science, and English. Until we finalize the grades required in entering UP, we’d be doing our prototypes with those three subjects.

Written by jasetiojanco

August 10, 2009 at 9:27 am

Posted in UPS

Tagged with , , ,

POIng!

leave a comment »

For the Excel Parser, I have chosen the Apache POI HSSF/XSSF parser. It seems to have better support unlike the JExcelAPI which seems to be outdated. I have tried out both APIs and I found working with the POI API a much more pleasurable experience.

 

Now that I have chosen my parser, I need to implement it for a spreadsheet of highschool grades! Whee!

Written by jasetiojanco

August 8, 2009 at 9:29 am

Posted in UPS

Tagged with , ,