use this as basis
1st SEM
-Laboratory(main)
--Lab Participation(sub) 5%
---Lab Participation1(subcat assesment)
---Lab Participation2
---Lab Participation3
...
---Total=SUM()(basically it totals how much the scores or points on the subcat assessment that the instructor added)
---Equivalent Rating: =ROUND(BA8/$BA$7*100,2)
---Percent Requirement: =ROUND($C$5*BB8,2)
--Lab Homework(sub) 10%
---Lab Homework 1
---Lab Homework 2
---Lab Homework 3
...
---Total=SUM()(basically it totals how much the scores or points on the subcat assessment that the instructor added)
---Equivalent Rating: =ROUND((DB7/$DB$7*100),2)
---Percent Requirement: =ROUND($BD$5*DC7,2)
--Lab Exercise
---Lab Excercise 1
---Lab Excercise 2
---Lab Excercise 3 and
---Total=SUM()(basically it totals how much the scores or points on the subcat assessment that the instructor added)
---Equivalent Rating: =ROUND((FC7/$FC$7*100),2)
---Percent Requirement: =ROUND($DE$5*FD7,2)
--Prelim Lab Exam
---Prelim Lab Exam 1
---Prelim Lab Exam 2
---Prelim Lab Exam 3
---Total=SUM()(basically it totals how much the scores or points on the subcat assessment that the instructor added)
---Equivalent Rating: =ROUND((GW8/$GW$7*100),2)
---Percent Requirement: =ROUND($FF$5*GX8,2)
--Midterm Lab Exam
---MIdterm Lab Exam 1
---MidtermLab Exam 2
---Midterm Lab Exam 3
---Total=SUM()(basically it totals how much the scores or points on the subcat assessment that the instructor added)
---Equivalent Rating: =ROUND(IQ8/$IQ$7*100,2)
---Percent Requirement: =ROUND($GZ$5*IR8,2)
--Final Lab Exam
---FInal Lab Exam 1
---FInal Lab Exam 2
---Final Lab Exam 3
---Total=SUM()(basically it totals how much the scores or points on the subcat assessment that the instructor added)
---Equivalent Rating: =ROUND(KK8/$KK$7*100,2)
---Percent Requirement: =ROUND($IT$5*KL8,2)
--PERCENT CHECKER 100%
---Laboratory Rating
=ROUND(BC7+IS7+KM7+GY7+FE7+DD7,2)
=ROUND(BC8+IS8+IS8KM8+GY8+FE8+DD8,2)
=ROUND(BC9+IS9+KM9+GY9+FE9+DD9,2)
-Lecture(main)
--Attendance
---Attendance(infinite count until the end of sem)
...
---Total=SUM()(basically it totals how much the scores or points on the subcat assessment that the instructor added)
---Equivalent Rating=ROUND((BA7/$BA$7*100),2)
---Percent Requirement=ROUND($C$5*BB7,2)
--Attitude(infinite count until the end of sem)
---Attitude
...
---Total=SUM()(basically it totals how much the scores or points on the subcat assessment that the instructor added)
---Equivalent Rating=ROUND((BA7/$BA$7*100),2)
---Percent Requirement=ROUND($C$5*BB7,2)
--Recitation(infinite count until the end of sem)
---Recitation 1
---Recitation 2
---Recitation 3
...
---Total=SUM()(basically it totals how much the scores or points on the subcat assessment that the instructor added)
---Equivalent Rating=ROUND((BA7/$BA$7*100),2)
---Percent Requirement=ROUND($C$5*BB7,2)
--Homework
---Homework 1
---Homework 2
---Homework 3
...
---Total=SUM()(basically it totals how much the scores or points on the subcat assessment that the instructor added)
---Equivalent Rating=ROUND((BA7/$BA$7*100),2)
---Percent Requirement=ROUND($C$5*BB7,2)
--Quiz
---Quiz 1
---Quiz 2
---Quiz 3
...
---Total=SUM()(basically it totals how much the scores or points on the subcat assessment that the instructor added)
---Equivalent Rating=ROUND((BA7/$BA$7*100),2)
---Percent Requirement=ROUND($C$5*BB7,2)
--Project
---Project 1
---Project 2
---Project 3
...
---Total=SUM()(basically it totals how much the scores or points on the subcat assessment that the instructor added)
---Equivalent Rating=ROUND((BA7/$BA$7*100),2)
---Percent Requirement=ROUND($C$5*BB7,2)
--Prelim
---Prelim Exam
---Equivalent Rating=ROUND((UZ7/$UZ$7*100),2)
---Percent Requirement=ROUND($C$5*BB7,2)
--Midterm
---Prelim Exam
---Equivalent Rating=ROUND((VC7/$VC$7*100),2)
---Percent Requirement=ROUND($C$5*BB7,2)
--Final
---Prelim Exam
---Equivalent Rating=ROUND((BA7/$BA$7*100),2)
---Percent Requirement=ROUND($C$5*BB7,2)
(note: the fomulas columns doesn't match because i just copy pasted a random column that results the same so disregard the column, what you need is the calculation))