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
This resource can be downloaded for free on CAS; this is only if you wish to make a donation so I can continue to create similar resources
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£3.00