<p>A spreadsheet assessment that self-marks as the students work on it</p> <p>It has 6 sheets for assessment; starting from basic data entry and going onto Pivot Charts at the end</p> <p>It should last about 50 minutes if the students want to spend time on it for full marks</p> <p>The instructions for the students are highlighted green on every sheet</p> <p>If the students mess-up any of the sheets, the sheet should reset to its original form automatically</p> <p>I have also included a VBScript that you can run to pull out all of the marks from the students’ work</p> <p>You must collect the files and place them in a folder, place the VBScript in the folder and double-click it</p> <p>The VBScript will create a file called Results which will contain the students’ names and grades for every level</p> <p>I have included a folder that has two test files and the VBS inside; double-click it to see the “results” for your self</p> <p>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</p> <p>The password for the spreadsheet is “compsci” if anyone wishes to make any changes</p>

<p>Work book with multiple levels of logic gate problems for students to solve.</p> <p>Teacher’s completed workbook is also included.</p> <p>23 questions split across 5 different levels.</p>

<p>8 Tracing activities.</p> <p>Each activity has a flowchart and a text pseudo-code to support students.</p> <ul> <li>Basic number calculations with IF statements</li> <li>FOR loop</li> <li>Counting the amount of letters in a word</li> <li>Calculating the percentage of a number</li> <li>Reversing a word. With error to find</li> <li>Integer dividing a number by three. With error to find</li> <li>Binary Search</li> <li>Converting Den to Bin</li> </ul>

<p>Spreadsheet with randomly generated numbers for students to practise Hex Notation</p> <p>The sheet has a macro the students can press to reset the numbers and try again</p> <p>The cells will format to green if student answers correctly</p> <p>The sheet is protected</p> <p>It has problems for all levels</p> <p>The password for the protection is “compsci” should you wish to make any changes to it</p>

<p>16 questions relating to storage. Short and Long answer questions.</p> <p>Mark Scheme included.</p>