# What questions to ask to students from a mineral guide dataset?

I am programming an app that consist in 180 mineral sheets of interest for geology students.

My database have the following fileds:

• Identifier
• Name
• Name 2
• Type
• Class
• Formula
• System
• Environment1
• Environment2
• Environment3
• Environment4
• Environment5
• Habit
• Color
• Diaphaneity
• Luster
• Streak
• Density
• Hardness
• Cleavage
• Fracture

For example the entry for golds look like:

INSERT INTO MINE180 VALUES('1','gold','gold','Non sillicates.','Native Elements.','Au','Cubic.','Hydrothermal: Associated to quartz veins.','Sedimentary: Placers.','Magmatic: IOCG deposits.','','','Octaedrical crystals.','Characteristic yellow.','Opaque.','Metallic.','Characteristic yellow.','19.3','2.5-3','---','Splintered, jagged.');


I am going to generate questions such as:

Wich mineral belongs to inosillicates class?

a) Calcosine

b) Augite

c) Quartz

d) Pirope

I can generate questions from all the fields ot the database but I don't think questions about physical-chemical properties are of use for the students. Unless density or hardness maybe.

What fields would you use to generate the questions that the students of geology and minning are going to check?

I guess you'll mostly get opinions here, which means your question is probably not the greatest fit for Stack Exchange, but FWIW here's my opinion, take it or leave it.

• They mainly ask about important things, to check the big concepts. A student might know that augite is a pyroxene, for example, or that pyroxenes and amphiboles are related families of silicates, but I wouldn't expect many to know that augite is an inosilicate. That just feels like something I can look up in a book if I ever need to know it.
• Tricky concepts are tested several times by asking various different questions about the same ideas.
• The answer alternatives must reflect the kinds of mistakes students typically make.
• Correct answers are backed up or reinforced, and incorrect answers are explained.