School Based

ASSESSMENT ANALYSIS

Excel Spreadsheet that makes your assessment analysis so much easier!

Specification Sheet

Enter the specifications of your assessment.

All CAPS learning areas and Test Numbers pre-loaded. All you need to do is specify sub-content and total marks.

Sheet enters your specifications automatically in the Analysis Table according to Test Number

1

2

3

Assessment Analysis

Enter class name, and identify each test with the learner name, term number and test number.

Test numbers will automatically populate each Content Specification column according to the sub-content topic entered in the Assessment Specification sheet.

Formulas uses the maximum score allocations entered in the Assessment Specification Sheet for each sub-content topic to automatically calculate Percentages for each raw score entered in the Learning Area Column.

Percentages that are below performance standards automatically highlighted in red for easy identification.

Use auto-filter to group analysis according to desired learner/s, term/s and test/s or result/s specifications.

1

2

3

4

5

Performance Summary

Summarise group or class performances per learning area according to term/s and test/s.

Summary percentages are given in row 50.

Includes overall test percentage score.

4

1

2

3

Demonstration Video

Please watch the two video clips. The second one contains an update that I made to the workbook.

Order Now:��Bank Details:�Blue Rose Social Interventions�Standard Bank�Branch Code: 00051001�Account Number: 07-338-694-4��Link to online order form: �https://forms.gle/22NMXdAiSgeieAKs7�

6

Blue Rose Social Interventions Pty (LTD)

​

​

Take a Survey!��Let us know know more about you and if you interested��Link to online sirvey form:

�https://forms.gle/22NMXdAiSgeieAKs7�

7

Blue Rose Social Interventions Pty (LTD)

​

​