Hi
I am developing a programmed solution using a graphical front-end which will allow users with limited competence using Excel to interrogate the underlying data set. This is a learner spreadsheet (ed context) with 280 learners (rows), 40 subjects (cols) with 5 cols relating to personal data (gender etc).
The system by way of 'looping' through the 'array' will search for and process specific learners grade outcomes etc and this works fine. However, my question relates to the structure of my program whem multiple search conditions are used. For example at least 6 check boxes and one combo box (with 4 options relating to ethnicity type.
This can imply considerable use of Case / nested case and/ or other constructs tio filter the data prior to processing with these multiple options.
Eg. Subject, Ethnicity (5 options), English, EnglishMaths, EnglishMathsAndScience etc..
Hope you can offer guidance on this
Many thanks in anticipation
I am developing a programmed solution using a graphical front-end which will allow users with limited competence using Excel to interrogate the underlying data set. This is a learner spreadsheet (ed context) with 280 learners (rows), 40 subjects (cols) with 5 cols relating to personal data (gender etc).
The system by way of 'looping' through the 'array' will search for and process specific learners grade outcomes etc and this works fine. However, my question relates to the structure of my program whem multiple search conditions are used. For example at least 6 check boxes and one combo box (with 4 options relating to ethnicity type.
This can imply considerable use of Case / nested case and/ or other constructs tio filter the data prior to processing with these multiple options.
Eg. Subject, Ethnicity (5 options), English, EnglishMaths, EnglishMathsAndScience etc..
Hope you can offer guidance on this
Many thanks in anticipation