SPOT

| No Comments

So I was asked to beta test the new student plsql ...something... training program, for new student programmers to learn the basics of the tools we use here at WOU. I was created by students for students! (Catchy, right?)

So it looks pretty good, easy to use and goes over the basics. I really am nit-picking, but I wanted to get all the bugs down:

In the try it boxes, there are spaces in the textarea that have to be deleted before typing will work. Otherwise it just shows it as wrong.

In GET/POST - submit button doesn't show t

In JAVASCRIPT - "Click to Execute" doesn't do anything..
What should go there? <script> or rescomp.js ?

In the try it, a new window pops open, but the Home link on that page takes you out of the portal with no style.

On all continue to next section, I always get the alert: You are not allowed to view this page yet.

PL/SQL - It says to delete everything, but don't delete author, created date, and purpose! It's important for later programmers to know a little about this program later.

Also, I noticed the use of htp.prn(', htp.p(' and htp.print(' without explanation.

In the URL for the db, also give the aliases - public2db and debug2db.

INFINITE LOOPS - Add exit or exit-when for them to test it, ie EXIT WHEN x > 5;

EXCEPTIONS - weather should be whether

PL/SQL Quiz - This quiz was ridiculous. It took me 6 times to pass it, and that was just by remembering what I picked before and using a process of elimination. The answers are confusing and there are gotchas, which is not the point of quizzes. Some are even plain wrong:
What's done every time you create a table? -> Says correct answer is create test data, but that is not what the training said. It stated to create a sequence.
Foreign Key is suppose to be a key from another country? Come on...
Doesn't keep money total from quiz to quiz.
Doesn't give correct answer when wrong.
Question make a custom exception -> should be declare a custom exception.
exception BOO; -> should be BOO exception;
when BOO then...

SEQUENCES - misspell --> relationps

RELATIONSHIPS - They primary key --> The primary key

ODL and SSN Example - intelligible (?) I think you mean something else; subscript 1 on hover says Easter Egg! I'm not sure what's up with that.

Okay, that's all I got for now.

Leave a comment

About this Entry

This page contains a single entry by published on November 10, 2009 2:30 PM.

Project List was the previous entry in this blog.

amCharts is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

Pages

Powered by Movable Type 4.23-en