Help with VBA in Excel! (More in description)?

Write a function within a module called GradeProject. The function will take two ranges as parameters, the first will be the marks allotted for each type of evaluation (Cells C2:G2 in this case), and the second will be the marks for an individual student (For example, cells C4:G4 for the first student, C5:G5 for the second student). The function will then calculate the total mark by multiplying the actual mark, by its weighting. The sum of each mark will yield the total. Return the total.