xlsm, 1.27 MB
xlsm, 1.27 MB
zip, 2.01 MB
zip, 2.01 MB

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

Reviews

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.