Should we keep track of people who pass the test?

[Pierre Abbat]

Right now the database schema has one table with people's names in it: cipfihi
holds the names of people who invent or review questions. I think that we
should keep track of people who achieve a level of proficiency, and I see no
reason why we can't put both sets of people in the same table. Do you agree?
What should be the columns of the table?

Pierre
--
The Black Garden on the Mountain is not on the Black Mountain.

[Jonathan Jones]

"Real name / Lojban name / tests attempted / tests passed / proficiency level"?

Also, where is this test?

--
mu'o mi'e .aionys.

.i.e'ucai ko cmima lo pilno be denpa bu .i doi.luk. mi patfu do zo'o
(Come to the Dot Side! Luke, I am your father. :D )

[Pierre Abbat]

On Monday 06 August 2012 22:16:53 Jonathan Jones wrote:
> "Real name / Lojban name / tests attempted / tests passed / proficiency
> level"?

"tests attempted" and "tests passed" should be in a different table. It is
possible to put arrays in a table column, but I don't know how to use them or
how portable it is. Do we really need "tests attempted"? I don't see the need
to enter someone who's never passed a test or authored a question.

Here's that part of the database schema with your fields added (I changed the
table name from "cipfihi" to "prenu":

create table prenu
(nacycme serial primary key,
cipfihi boolean,
plicme text,
sivyvla text,
rarbaucme text,
jbocme text,
nilcertu short
);

create table ciptoi
(tercipra int references prenu,
detri date,
nilnandu short,
snada boolean
);

> Also, where is this test?

We're still designing it.

Pierre
--
lo ponse be lo mruli po'o cu ga'ezga roda lo ka dinko

[Jonathan Jones]

On Mon, Aug 6, 2012 at 9:22 PM, Pierre Abbat <ph...@phma.optus.nu> wrote:

On Monday 06 August 2012 22:16:53 Jonathan Jones wrote:
> "Real name / Lojban name / tests attempted / tests passed / proficiency
> level"?

"tests attempted" and "tests passed" should be in a different table. It is
possible to put arrays in a table column, but I don't know how to use them or
how portable it is. Do we really need "tests attempted"? I don't see the need
to enter someone who's never passed a test or authored a question.

I was thinking of how GPA is reported, which is the average of credits completed to credits attempted.

Here's that part of the database schema with your fields added (I changed the
table name from "cipfihi" to "prenu":

create table prenu
(nacycme serial primary key,
 cipfihi boolean,
 plicme text,
 sivyvla text,
 rarbaucme text,
 jbocme text,
 nilcertu short
 );

create table ciptoi
(tercipra int references prenu,
 detri date,
 nilnandu short,
 snada boolean
 );

> Also, where is this test?

We're still designing it.

Pierre
--
lo ponse be lo mruli po'o cu ga'ezga roda lo ka dinko