The Australian Curriculum Assessment Grid (unofficial) is now available for v8.0 of the ACARA Australian Curriculum.

This is an assessment grid in the form of an Excel spreadsheet with all Australian Curriculum content descriptions and elaborations. You can use it to mark your students.

The new v8.0 curriculum now has 12403 elaborations (up by 315 from v7.5). These come from 3250 content descriptions in 28 subjects from Foundation to Year 10.

Thank you for all of your interest in the previous version. There was well over 1000 likes and shares on Facebook, which is overwhelming. It was also overwhelming for our little aussieED website which went down multiple times. It couldn’t handle getting 8000 hits in a few days, especially with the large file download. I’ve added the project to SourceForge as a result. Click below to be taken to the download page.

Download Australian Curriculum Assessment Grid

The new version, as well as being for the latest version of the national curriculum (v8.0), has some extra features.

Features

Add up to 35 students for assessment purposes.
13

Double click cells to mark students
14

Mark multiple students and outcomes with a simple select and click interface
2

Available marks: “little understanding”, “some understanding”, “full understanding” and “no data”.
3

5

Display controls include full width, 100% zoom, distraction-free full screen interface, regular Excel view mode and a scroll bar for zooming.
4

Filter by subjects, years (F-12), strands, content descriptions, elaborations and more.7

Extra Information + Disclaimer

When you first open the file, security warning may show. Click Enable Editing and Enable Content buttons to begin. If you don’t do this, the macros cannot run. This will mean that the marking interface and buttons will not work. Other functions such as filtering and colours will still work. There are no malicious scripts in the macros. I coded them myself.

11

1

The spreadsheet has been tested with Windows 7 and Windows 10 running Microsoft Excel 2010 and 2013. It should work with Mac OS X running Excel for Mac but I haven’t been able to test it yet.

As always, backup often. If you choose to use this to hold your students’ assessment data, backup in multiple places to a physical storage device and to the cloud or server in a different physical location. Also, I’m a teacher, not a programmer. I make no guarantees for anything!

Use your professional judgment as to how or whether to use this assessment tool. You are given the option of selecting from three levels of understanding for each elaboration. You know that’s only part of the assessment story.

Teachers from NSW and some other states will not be able to use this tool. NSW teachers do not use the ACARA curriculum. I would like to create a similar tool for the current NSW BOSTES curriculums but it will take some time. The

Subjects are at various stages of implementation. Check the ACARA Australian Curriculum website for the most recent changes.

This spreadsheet does not include the general capabilities. A future version might if there is interest.

All data here is ported from the ACARA spreadsheet downloads page. This was made possible because ACARA had the foresight to make available their curriculum as structured data. Thank you, ACARA. Please, take note BOSTES!

Download Australian Curriculum Assessment Grid

This file is licensed as Creative Commons – Attribution 4.0 International (CC BY 4.0)

You are free to:
Share — copy and redistribute the material in any medium or format
Adapt — remix, transform, and build upon the material for any purpose, even commercially.
The licensor cannot revoke these freedoms as long as you follow the license terms.

Under the following terms:
Attribution — You must give appropriate credit, provide a link to the license, and indicate if changes were made.
You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
No additional restrictions — You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.

© Australian Curriculum, Assessment and Reporting Authority (ACARA) 2010 to present, unless otherwise indicated.
This material was downloaded from the Australian Curriculum website (accessed 14/11/2015) and was modified. The material is licensed under CC BY 4.0. Version updates are tracked on the Curriculum version history page of the Australian Curriculum website.

ACARA does not endorse any product that uses the Australian Curriculum or make any representations as to the quality of such products. Any product that uses material published on this website should not be taken to be affiliated with ACARA or have the sponsorship or approval of ACARA. It is up to each person to make their own assessment of the product, taking into account matters including, but not limited to, the version number and the degree to which the materials align with the content descriptions (where relevant). Where there is a claim of alignment, it is important to check that the materials align with the content descriptions (endorsed by all education Ministers), not the elaborations (examples provided by ACARA).

You can also download the old 7.5 version.

About The Author

Primary Technologies Teacher
Google+

Rob McTaggart teaches Technologies from K-6 in Newcastle, Australia. He is co-founder of the Digital Sparks regional student technology design challenge & expo.
Rob is a Google for Education Certified Innovator who loves to help students to engage and create with the world using technology. He developed the RAPID Design framework to support students and teachers in these aims.
Rob is a moderator for #aussieED and plays a logistics role for the team, managing the website and various channels. He is an ambassador and teacher trainer for Code Club Australia and runs a local Code Club for his students.
His main gig is teaching 550 amazing kids every week which makes him a very lucky teacher!

Related Posts

15 Responses

  1. Veronica sherwood

    Is this valid in QLD? Am about to have a grade 2 class in 2016 and really do not know where to look.

    Reply
    • Rob McTaggart

      Hi Veronica,

      I’m not from QLD, so I can’t give you much advice. ACARA has a page with curriculum “version implementation advice” here: http://www.australiancurriculum.edu.au/curriculum/overview

      For QLD, it says: “Consult your school sector or the Queensland Curriculum and Assessment Authority for advice”.

      On the QCAA website there is a page called, “Australian Curriculum implementation strategy” here: https://www.qcaa.qld.edu.au/p-10/aciq/implementing-aciq/implementation-strategy
      It includes a table which seems to suggest the following subjects be implemented from the Australian Curriculum by 2016 (some wouldn’t apply to year 2):
      English
      Mathematics
      Science
      History
      Geography
      The Arts
      Health and Physical Education
      Civics and Citizenship
      Technology
      Economics and Business
      Languages

      You would need to ask your school which version of the Australian Curriculum they’re using next year, version 7.5 or 8.0. Both are still available on the Australian Curriculum website ( http://www.australiancurriculum.edu.au/ ).

      I hope that’s of some help.

      Best wishes =)

      Reply
  2. Em

    Hi,
    Just wondering if you know if there is an audit already done that compares the new Victorian Curriculum to this Australian Curriculum. Thanks again,
    Em

    Reply
    • Rob McTaggart

      Hi Em,
      I haven’t seen or found anything that does a direct comparison. As I’m in NSW, I can only access what’s available on the internet. I hope you find what you’re looking for 🙂

      Reply
      • Em

        Thanks anyway.
        Might have to stop being lazy and just get on with comparing them.

  3. Katie Silva

    Hi Rob,
    Thanks for all your amazing work facilitating this. As a Teacher Librarian, I’m involved in a project to map Inquiry through the Australian Curriculum and this looks to be a great way to support that. I would be interested in the General Capabilities being presented in this format, as that is an area that I focus on in my teaching.
    Katie

    Reply
    • Rob McTaggart

      Hi Katie,
      Thank you very much.
      I’m pretty sure I can do that without too much trouble. Let me have a crack at it (as soon as I’ve got some time) and I’ll let you know how I go.

      Reply
  4. sheryl

    This looks great and just what ive been wanting ….. but any chance of having a mac version?

    Reply
    • Rob McTaggart

      Hi Sheryl,
      I haven’t had the opportunity to test it on a Mac but a couple of people have said it works fine on Excel for Mac. Have you been able to try that?
      The data would display on other spreadsheet programs but most features wouldn’t work.
      Please let me know if I’m wrong on it working on Excel for Mac.
      I’m afraid I’m not able to make a similar version for other spreadsheet programs at the moment but it’s creative commons so anyone can use it, port it and share it if they’re able.
      Let me know how you go 🙂
      Rob

      Reply
  5. Claire

    Hi Rob, this looks like a great tool to use but im unable to make any changes to the doc on my mac as its says its read only, do you have any advice to correct this? ive tried changing it in the info bar but it says its read and write???
    many thanks
    Claire

    Reply
    • Rob McTaggart

      Hi Claire,
      That’s an odd one. Is your file on a network drive, by chance? It could be that another person has the file open at the same time.
      You could try copying the file and opening the copied version. If that’s still read-only you might be able to give yourself write-permission in the File menu of Excel (press the Escape key to see the Microsoft ribbon (menus) at the top).
      Please let me know if these don’t work. I’m going to have to test the Mac version properly. You don’t want to donate me a Mac do you? 😉

      Reply
  6. Rebecca

    Hello,

    I am so glad I stumbled across this wonderful resource! Thank you.

    I am just wondering if there is a way to delete any year levels that are not needed to try and make the file size smaller?

    Thank you

    Reply
    • Rob McTaggart

      Hi Rebecca,
      Thank you and thanks for your great question. I’ve just tried deleting a row and it kind of doesn’t work without a lot of fiddling with formatting. The macros are also programmed for the length of the data and so they might not respond correctly.
      Have you found the column filters at the top? Once you select only the subjects and years you’re interested in, the irrelevant ones won’t reappear unless you select to bring them back. The file size is about 5MB, which is the size of an mp3 file. I was wondering, is it because your Excel is running slowly or another reason?
      Thanks again. Sorry I can’t be of more help. I expected it would just work deleting rows, but it kind of doesn’t. All the best =)

      Reply
  7. tamara

    hi, I cant seem to download this. it looks perfect and I would love to have a good look but the SourceForge site is not downloading the document ‘The sourceforge.net website is temporarily in static offline mode. Only a very limited set of project pages are available until the main website returns to service’

    Reply
  8. Trina Clayton

    Hey Rob, Love the spreadsheet. I’ve used the v7.5 on my Mac but the v8.3 can only be opened as ‘Read only’ because there is no Active X on Mac. This means I loose all the macros. I’ll go through and make the changes on the old version but just thought you’d like to know.

    Cheers Trina

    Reply

Leave a Reply

Your email address will not be published.