New Assessment Marksheets

Our new marksheets give you a powerful and easy-to-use spreadsheet, with intuitive features such as keyboard data entry, copy and paste, and column filtering and resizing.

• Intuitive and easy-to-use - No need to learn any new tricks, Arbor marksheets mirror the features you are already familiar with in other spreadsheets, like Excel.
• Speed up data entry - Save time when inputting Assessment data, as you can navigate the spreadsheet using only your keyboard. Plus, you can copy and paste data into and out of the marksheet to move seamlessly between external spreadsheets and your MIS.
• Make your marksheet work for you - Pin and reorder columns depending on the information you need to see first. Marksheet settings are saved per user, so you can customise the layout and it will stay the same in your next session.

 

How can we use the new marksheets?

How do we switch them on?

There's nothing you need to do to switch on our new marksheets! Everyone who could access marksheets before will be able to use the new marksheets from the same place.

Can we switch back to our old marksheets?

Yes you can switch back to the old marksheets for now, by clicking the Toggle New Tables switch.

Does this work with Custom marksheets?

Yes, our new marksheets work with Custom Marksheets - enabling you to do even more with your marksheet formatting!

 

Which pages have the new marksheets?

We've introduced the new marksheets to all the assessment marksheet pages:

• The Academic Unit marksheet
• The Summative Tracking marksheet
• The Baselines & Targets page
• The Data collection marksheets
• The Ad Hoc marksheets
• The DfE assessment Input marks pages
• The export marks pages

 

What are the new features?

We've introduced a whole host of amazing new features, and improved some existing functionality.

Additional option buttons at the top

Use the arrow buttons to undo or redo the last action taken.

 

Choose whether to hide any columns using the Hide columns feature - just untick the box and the column will no longer show.

Top Tip: Click and drag a column offscreen to hide it too! 

 

Click the tooltip button to hide or unhide tooltips showing more information when you hover over a field in the marksheet. Perfect for speeding up mark entry as you don't need to move your mouse away to see what you're inputting.

 

Use the cog button to change your text display size and reset your table settings.

Top Tip: This won't change any data in the table, just the way it's displayed.

 

Bring up a full-screen view of your marksheet using the expander.

 

Search, sort and filter your marksheet

Use the search bar to find specific pieces of data in the table, such as to search for a student's name.

 

Click the arrow in a column header to open your sorting and filtering options.

 

Pin this column to the very far left or far right of your marksheet. Pinned columns will always be shown on the screen, so you never have to scroll to see them. Select No Pin to put it back where it originally was.

 

Click and drag the line between two column headers to resize the column. If you columns are too wide or narrow, select to autosize the current one to the correct width, or all of them.

Top Tip: Use the cog button and select Reset your table settings to revert back to the default widths.

 

Use the filter to only show rows with the selected values.

 

The footer will tell you how many results are shown based on your filter.

 

New ways to enter your data

Fill in a field by straight typing and pressing enter to jump to the next cell below, our double click on a comment field for the full textbox. You can also click the pencil icon if you’d prefer to use your mouse.

 

Copy and paste from any source, across multiple fields.

• To copy, select the fields and drag until they are all selected, then use Ctrl+C (Windows) or Cmd + C (Mac).
• To paste, select the fields and drag until they are all selected, then use Ctrl+V (Windows) or Cmd + V (Mac).

 

You might need to agree to share data from your Clipboard with Arbor by clicking Allow in the pop up.

 

If you enter an invalid value, the value won't save and the field will be reset to blank.

If you paste in an invalid value, there's now no more getting trapped in the editor. Now it'll highlight the invalid value in red, and won't send the data to other areas of Arbor until you fix it.

 

If you refresh the page, close your window or tab, or leave Arbor, the invalid value won't be saved. You'll get a pop-up to confirm you still want to leave the page.

 

Revamped features you know and love

Tick the boxes next to students to select them to use with bulk actions - you can see more about using this feature here: How and what can I update using bulk actions?

 

Click and drag both downwards and upwards to select and deselect the rows.

 

The footer will tell you how many rows you have selected.

 

Download your marksheet into different formats such as Word or PDF by clicking Download - you can see more about using this feature here: What files can I download from Arbor?

 

Click the column headers to sort from highest to lowest or alphabetically.

 

Click and drag the line between two column headers to resize the column.

Drag and drop your columns into any order you like, and we'll remember them for you for when you return to this specific marksheet - you can see more about using this feature here: Can we change the order of columns in assessment marksheets?