Hello ALL,
I hope you can help me.
I have created a workbook in VBA in order to calculate marks for my class. It uses multiple worksheets from which data is pulled in, in order to come out with a final grade for my students. I introduced the program to my staff, and they loved it. Now I am having a problem since when I created the workbook, I only used one mark per test. My District tells me that I am supposed to break each mark in 4 (four) categories (Knowledge, Thinking, Communication and Application). Not necessarily all of them being tested for each mark. What I need to do is have a way where the marks for each test can be entered according to the categories above and then the final mark entered in my worksheet. Note that there are many possible tests to be entered for each student.
Any suggestions on how to go about doing this?
Thank yuou in advance for your help.
Brutium
I hope you can help me.
I have created a workbook in VBA in order to calculate marks for my class. It uses multiple worksheets from which data is pulled in, in order to come out with a final grade for my students. I introduced the program to my staff, and they loved it. Now I am having a problem since when I created the workbook, I only used one mark per test. My District tells me that I am supposed to break each mark in 4 (four) categories (Knowledge, Thinking, Communication and Application). Not necessarily all of them being tested for each mark. What I need to do is have a way where the marks for each test can be entered according to the categories above and then the final mark entered in my worksheet. Note that there are many possible tests to be entered for each student.
Any suggestions on how to go about doing this?
Thank yuou in advance for your help.
Brutium
