Abstract
I described the following contents that I checked out as it is needed in the work, for contribution to efficiency of the future work. At first, I showed a procedure to set up a test or a questionnaire as the assessment on a course of the Blackboard Learn™. Then, I showed a method to download a result file, and to sum it up on Excel(R). In the processing with Excel, it is able to use "countif" function to count the number of cells in line with search condition written in a certain cell. For the first, the answers are added up entirely in this way to make the whole total sheet. After the sheet is copied, by erasing the values of the answer lines those are in disagreement with the conditions, it'll be the partial total sheet. To assemble the whole and partial total of the answers written down on separated sheets to one sheet, it is effective to use an "indirect" function to refer the values in the target cells of separated sheets. The functions is able to refer to a value of a target cell with a pointer to a certain cells containing the address of the target cell.
