A spreadsheet assessment that self-marks as the students work on it
It has 6 sheets for assessment; starting from basic data entry and going onto Pivot Charts at the end
It should last about 50 minutes if the students want to spend time on it for full marks
The instructions for the students are highlighted green on every sheet
If the students mess-up any of the sheets, the sheet should reset to its original form automatically
I have also included a VBScript that you can run to pull out all of the marks from the students’ work
You must collect the files and place them in a folder, place the VBScript in the folder and double-click it
The VBScript will create a file called Results which will contain the students’ names and grades for every level
I have included a folder that has two test files and the VBS inside; double-click it to see the “results” for your self
The VBS can only run from a drive where your school has allowed you to run such files; you can run it from your personal devices easily
The password for the spreadsheet is “compsci” if anyone wishes to make any changes
Work book with multiple levels of logic gate problems for students to solve.
Teacher’s completed workbook is also included.
23 questions split across 5 different levels.