A spreadsheet with raw grading data was downloaded that contained multiple assignment types, and the target assignment types ("Quiz", "Exam", and "Activity") needed to be extracted from the strings within each row of that column. Extraneous columns were deleted, and the VBA Like operator was used in conjunction with the * wildcard to find and label data in a new column. Knowing that all target assignments were scored out of 100 points, an additional column was created to list the Total Points Possible only in cells that were not blank using conditional statments and the ISBLANK function. Rows with other assignment types were left blank.
A pivot table was then used to break down the total number of points earned and possible for each activity type. Filters were used to display only the target assignment types and none of the blank rows.
The raw points earned and possible were then ready to be inputted into school records.