KS3 - 4 Spreadsheet Assessment (Automatic Marking)Quick View
zymberi_arben

KS3 - 4 Spreadsheet Assessment (Automatic Marking)

(0)
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