This version is now out of date.

See Full Australian Curriculum v8.0 Assessment Grid for the latest version.


Did you know that the Australian Curriculum has 12088 elaborations? These come from 3284 content descriptions in 27 subjects from Foundation to Year 10.

And now it’s all in a beautiful little spreadsheet with a lovely flat UI that you can use to assess your students.

  • Add up to 70 student names to the worksheet.
  • Hover over cells with your mouse to read full content descriptions and elaborations.
  • Filter by subject, year, content descriptions, elaborations, electives and more.
  • Each time you double click a cell you give a student a different evaluation for the elaboration. There are four available marks: “no data”, “little understanding”, “some understanding”, and “full understanding”.
  • Select any area with your mouse and set them all to your chosen mark with a single click using the buttons at the top. This allows you to set your full class to any mark for one or more elaborations and then make individual changes.

This Excel file includes macros so you’ll need to enable editing and allow macros when you open it. The macros are required for the double clicking, selection marking and hovering tooltips.

This was made possible because ACARA had the foresight to make available their curriculum as structured data (here). Thank you, ACARA. Please, take note BOSTES!

Download:

aus_curric_flat_grid.xlsm [The Australian Curriculum F-10 Flat UI Assessment Grid (unofficial)] 8021 kB

 

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

17 Responses

  1. Rob McTaggart

    This has proven to be way more popular than I expected! Thanks to everyone who shared it on.
    As a result, I’ll update the spreadsheet to v8.0 of the curriculum as soon as I can.

    Reply
    • Marg Howlett

      This looks fabulous but I’m not so excel savvy … but I’m going to try and nut it out! Thanks for sharing your hard work.

      Reply
    • Judy Sobey

      Thankyou so much, it’s such a terrific resource. Thanks for sharing your expertise!

      Reply
    • Brett Salakas

      The more I look at this the more useful it is. Thanks so much Rob. I have NO IDEA how you added this into your workload and made this! WOW!!!

      Reply
  2. Bec

    Fantastic resource Rob, thanks for sharing. One question though, if the computer wont let you add macros what would you suggest?

    Reply
    • Rob McTaggart

      Hi Bec,
      I’ve updated it to to v8.0 of the curriculum. In the post, I give some extra details about enabling macros along with a link but I’m not sure if that will help. If you’re still having troubles, please let me know.

      Reply
  3. Kate

    Hi Rob,
    Thankyou so much for putting this together – it is a huge task!! I was wondering whether there is a way to open it on my Mac though as when I download it it doesn’t have any colour. Is there an easy way to make it Mac compatible?

    Kind regards, Kate.

    Reply
    • Caroline

      This is great, thanks heaps (looking forward to the 8.0 update too)

      Kate – I have the latest version of Excel running on my Mac and it works well. I don’t know that earlier versions supported macros.

      Reply
    • Rob McTaggart

      Hi Kate,
      Thanks so much! I’m surprised about the missing colour because that’s not related to macros. It relies on formulas and conditional formatting which is standard in all of the latest versions of Excel.
      Caroline has pointed out that it can sometimes work on a Mac (that’s promising). Perhaps the new version for v8.0 of the curriculum will work better for you? http://aussieed.com/full-australian-curriculum-v8-0-assessment-grid/
      If it’s still playing up, please let me know.

      Reply
      • Kate

        Hi Rob,
        On my Mac I am using the spreadsheet program ‘Numbers’ not Excel.
        Upon opening the file I get a warning stating:
        1) the font Calibri isn’t available and has been replaced with Trebuchet MS.
        2) “Unsupported conditional highlighting rules were removed.”
        Is there any easy way to fix this?
        Kind regards, Kate.

      • Rob McTaggart

        Hi Kate,
        I’m afraid the spreadsheet program needs to be Excel if you want the colours or for the click-marking to work. This relies on the conditional highlighting rules that you mentioned Numbers doesn’t have. I’m unsure whether the table filtering will work in Numbers either.
        If you’re happy to work with a basic spreadsheet, you might like to download the “F-10 Content Descriptions and Elaborations.xlsx” spreadsheet from the ACARA website here: http://www.australiancurriculum.edu.au/Download/Excel
        I’m sorry I can’t help any more than that but I don’t have access to Numbers (or a Mac, currently!).

  4. Julie

    Hi Rob, thank you! That’s great. Can you edit the document for just your class (years 5, 6, 7). I tried it but it all went a grey colour! Thanks, Julie

    Reply
    • Rob McTaggart

      Hi Julie,
      Thanks!
      You can show only the years or subjects you want, but not by deleting rows.
      Just use the drop down arrows on the column headers, and deselect the other years. Does that help?

      Reply

Leave a Reply

Your email address will not be published.