WJEC Vocational IT L1-2 Unit 2 Marksheet

I made this to help keep track of the marks for the coursework section of the WJEC ICT Level 1-2 Vocational course.

There are 7 sheets which do the following:

• Overall - Tracks the whole unit marks with conditional formatting so it’s easy to see where each student is at.

• Task 1 - Marksheet for the database task.

• Task 2 - Marksheet for the spreadsheet task

• 2a - The spreadsheet task requires certain forumlas/functions to get marks so I made this one to track 2d in more detail.

• Task 3 - Marksheet for the automated document task.

• Task 4 - Marksheet for the logo task.

• 4a - As with 2a, this section is split into different criteria so Imade a seperate sheet to keep track of the individual elements.

There are buttons to help navigate and if you enter the student names on the “Overall” sheet then they will appear throughout. If you notice any errors please let me know and I will update the sheet.

Thank you