Interactive Maths - The Interactive Way to Teach Mathematics
  • Interactive Maths
    • Activities Index
    • 50 Great Activities for Any Classroom
    • QQI Activity Descriptions
    • About Me
    • Contact Me
    • Links
    • Legal & Fees
    • Privacy Policy
  • Blog
  • Number
    • Arithmetic >
      • The Four Operations >
        • The Four Operations (QQI)
        • The Four Operations (10QQI)
        • The Four Operations (QQI Count Down)
        • The Four Operations (QQI Relay)
        • The Four Operations (QQI BINGO)
        • The Four Operations (QQI Worksheets)
        • The Four Operations (Video)
        • Timestables Square (QQI)
        • Grid Multiplication (QQI)
      • Missing Numbers >
        • Missing Numbers (QQI)
        • Missing Numbers (10QQI)
        • Missing Numbers (QQI Count Down)
        • Missing Numbers (QQI Relay)
        • Missing Numbers (QQI BINGO)
        • Missing Numbers (QQI Worksheets)
      • Order of Operations >
        • Order of Operations (QQI)
        • Order of Operations (10QQI)
        • Order of Operations (QQI Count Down)
        • Order of Operations (QQI Relay)
        • Order of Operations (QQI BINGO)
        • Order of Operations (QQI Worksheets)
      • Powers of Ten >
        • Powers of Ten (QQI)
        • Powers of Ten (10QQI)
        • Powers of Ten (QQI Count Down)
        • Powers of Ten (QQI Relay)
        • Powers of Ten (QQI BINGO)
        • Powers of Ten (QQI Worksheets)
      • Decimal Operations >
        • Decimal Operations (QQI)
        • Decimal Operations (10QQI)
        • Decimal Operations (QQI Count Down)
        • Decimal Operations (QQI Relay)
        • Decimal Operations (QQI BINGO)
        • Decimal Operations (QQI Worksheets)
      • Rounding >
        • Rounding (QQI)
        • Rounding (10QQI)
        • Rounding (QQI Count Down)
        • Rounding (QQI Relay)
        • Rounding (QQI BINGO)
        • Rounding (QQI Worksheets)
      • Products and Sums (QQI)
      • Products and Sums (10QQI)
    • Fractions >
      • Cancelling Fractions >
        • Cancelling Fractions (QQI)
        • Cancelling Fractions (10QQI)
        • Cancelling Fractions (QQI Count Down)
        • Cancelling Fractions (QQI Relay)
        • Cancelling Fractions (QQI BINGO)
        • Cancelling Fractions (QQI Worksheets)
      • Mixed Numbers and Improper Fractions >
        • Mixed Numbers and Improper Fractions (QQI)
        • Mixed Numbers and Improper Fractions (10QQI)
        • Mixed Numbers and Improper Fractions (QQI Count Down)
        • Mixed Numbers and Improper Fractions (QQI Relay)
        • Mixed Numbers and Improper Fractions (QQI BINGO)
        • Mixed Numbers and Improper Fractions (QQI Worksheets)
      • Fractions of Amounts >
        • Fractions of Amounts (QQI)
        • Fractions of Amounts (10QQI)
        • Fractions of Amounts (QQI Count Down)
        • Fractions of Amounts (QQI Relay)
        • Fractions of Amounts (QQI BINGO)
        • Fractions of Amounts (QQI Worksheets)
      • Fraction Arithmetic >
        • Fraction Arithmetic (QQI)
        • Fraction Arithmetic (10QQI)
        • Fraction Arithmetic (QQI Count Down)
        • Fraction Arithmetic (QQI Relay)
        • Fraction Arithmetic (QQI BINGO)
        • Fraction Arithmetic (QQI Worksheets)
    • FDP >
      • Fraction Decimal Conversions Drill
    • Percentages >
      • Percentages of Amounts >
        • Percentages of Amounts (QQI)
        • Percentages of Amounts (10QQI)
        • Percentages of Amounts (QQI Count Down)
        • Percentages of Amounts (QQI Relay)
        • Percentages of Amounts (QQI BINGO)
        • Percentages of Amounts (QQI Worksheets)
        • Percentage of Amounts (Video)
      • Writing Numbers as a Percentage >
        • Writing Numbers as a Percentage (QQI)
        • Writing Numbers as a Percentage (10QQI)
        • Writing Numbers as a Percentage (QQI Count Down)
        • Writing Numbers as a Percentage (QQI Relay)
        • Writing Numbers as a Percentage (QQI BINGO)
        • Writing Numbers as a Percentage (QQI Worksheets)
        • Writing Numbers as a Percentage (Video)
      • Percentage Change >
        • Percentage Change (QQI)
        • Percentage Change (10QQI)
        • Percentage Change (QQI Count Down)
        • Percentage Change (QQI Relay)
        • Percentage Change (QQI Worksheets)
        • Percentage Change (Video)
      • Increase and Decrease by a Percentage >
        • Increase and Decrease by a Percentage (QQI)
        • Increase and Decrease by a Percentage (10QQI)
        • Increase and Decrease by a Percentage (QQI Count Down)
        • Increase and Decrease by a Percentage (QQI Relay)
        • Increase and Decrease by a Percentage (QQI BINGO)
        • Increase and Decrease by a Percentage (QQI Worksheets)
        • Increase and Decrease by a Percentage (Video)
      • Compound Interest and Simple Interest >
        • Compound Interest and Simple Interest (QQI)
        • Compound Interest and Simple Interest (10QQI)
        • Compound Interest and Simple Interest (QQI Count Down)
        • Compound Interest and Simple Interest (QQI Relay)
        • Compound Interest and Simple Interest (QQI BINGO)
        • Compound Interest and Simple Interest (QQI Worksheets)
        • Compound Interest and Simple Interest (Video)
      • Overall Percentage Change >
        • Overall Percentage Change (QQI)
        • Overall Percentage Change (10QQI)
        • Overall Percentage Change (QQI Count Down)
        • Overall Percentage Change (QQI Relay)
        • Overall Percentage Change (QQI BINGO)
        • Overall Percentage Change (QQI Worksheets)
      • Reverse Percentages >
        • Reverse Percentages (QQI)
        • Reverse Percentages (10QQI)
        • Reverse Percentages (QQI Count Down)
        • Reverse Percentages (QQI Relay)
        • Reverse Percentages (QQI BINGO)
        • Reverse Percentages (QQI Worksheets)
        • Reverse Percentages (Video)
      • Mixed Percentages >
        • Mixed Percentages (QQI)
        • Mixed Percentages (10QQI)
        • Mixed Percentages (QQI Count Down)
        • Mixed Percentages (QQI Relay)
        • Mixed Percentages (QQI BINGO)
        • Mixed Percentages (QQI Worksheets)
    • Factors and Multiples >
      • Number Properties (QQI)
      • Product of Primes >
        • Product of Primes (QQI)
        • Product of Primes (10QQI)
        • Product of Primes (QQI Count Down)
        • Product of Primes (QQI Relay)
        • Product of Primes (QQI BINGO)
        • Product of Primes (QQI Worksheets)
      • HCF and LCM >
        • HCF and LCM (QQI)
        • HCF and LCM (10QQI)
        • HCF and LCM (QQI Count Down)
        • HCF and LCM (QQI Relay)
        • HCF and LCM (QQI BINGO)
        • HCF and LCM (QQI Worksheets)
        • HCF and LCM (Video)
      • 100 Square Multiples (QQI)
      • 100 Square Types of Numbers (QQI)
    • Standard Form >
      • Standard Form Conversions >
        • Standard Form Conversions (QQI)
        • Standard Form Conversions (10QQI)
        • Standard Form Conversions (QQI Count Down)
        • Standard Form Conversions (QQI Relay)
        • Standard Form Conversions (QQI BINGO)
        • Standard Form Conversions 2 (QQI BINGO)
        • Standard Form Conversions (QQI Worksheets)
      • Standard Form Arithmetic >
        • Standard Form Arithmetic (QQI)
        • Standard Form Arithmetic (10QQI)
        • Standard Form Arithmetic (QQI Count Down)
        • Standard Form Arithmetic (QQI Relay)
        • Standard Form Arithmetic (QQI BINGO)
        • Standard Form Arithmetic (QQI Worksheets)
    • Ratio and Proportion >
      • Ratio (Video)
    • Surds >
      • Surds Activities >
        • Surds (QQI)
        • Surds (10QQI)
        • Surds (QQI Count Down)
        • Surds (QQI Relay)
        • Surds (QQI BINGO)
        • Surds (QQI Worksheets)
  • Algebra
    • Algebraic Manipulation >
      • Collecting Like Terms >
        • Collecting Like Terms (QQI)
        • Collecting Like Terms (10QQI)
        • Collecting Like Terms (QQI Count Down)
        • Collecting Like Terms (QQI Relay)
        • Collecting Like Terms (QQI BINGO)
        • Collecting Like Terms (QQI Worksheets)
      • Expanding Single Brackets >
        • Expanding Single Brackets (QQI)
        • Expanding Single Brackets (10QQI)
        • Expanding Single Brackets (QQI Count Down)
        • Expanding Single Brackets (QQI Relay)
        • Expanding Single Brackets (QQI BINGO)
        • Expanding Single Brackets (QQI Worksheets)
      • Factorising >
        • Factorising (QQI)
        • Factorising (10QQI)
        • Factorising (QQI Count Down)
        • Factorising (QQI Relay)
        • Factorising (QQI BINGO)
        • Factorising (QQI Worksheets)
      • Expanding Quadratic Brackets >
        • Expanding Quadratic Brackets (QQI)
        • Expanding Quadratic Brackets (10QQI)
        • Expanding Quadratic Brackets (QQI Count Down)
        • Expanding Quadratic Brackets (QQI Relay)
        • Expanding Quadratic Brackets (QQI BINGO)
        • Expanding Quadratic Brackets (QQI Worksheets)
      • Factorising Quadratics >
        • Factorising Quadratics (QQI)
        • Factorising Quadratics (10QQI)
        • Factorising Quadratics (QQI Count Down)
        • Factorising Quadratics (QQI Relay)
        • Factorising Quadratics (QQI BINGO)
        • Factorising Quadratics (QQI Worksheets)
        • Factorising Quadratic Expressions (Video)
        • Factorising Four Term Expressions (Video)
      • Indices >
        • Indices (QQI)
        • Indices (10QQI)
        • Indices (QQI Count Down)
        • Indices (QQI Relay)
        • Indices (QQI BINGO)
        • Indices (QQI Worksheets)
      • Completing the Square >
        • Completing the Square (QQI)
        • Completing the Square (10QQI)
        • Completing the Square (QQI Count Down)
        • Completing the Square (QQI Relay)
        • Completing the Square (QQI BINGO)
        • Completing the Square 2 (QQI BINGO)
        • Completing the Square (QQI Worksheets)
      • Algebraic Fractions >
        • Simplifying Algebraic Fractions (Video)
        • Adding and Subtracting Algebraic Fractions (Video)
        • Multiplying and Dividing Algebraic Fractions (Video)
    • Coordinates >
      • Coordinates (GGB)
      • Coordinate Battleship First Quadrant (GGB)
      • Coordinate Battleship All Four Quadrants (GGB)
      • 3D Coordinates (AGG)
    • Equations >
      • Linear Equations >
        • Solving Linear Equations >
          • Solving Linear Equations (QQI)
          • Solving Linear Equations (10QQI)
          • Solving Linear Equations (QQI Count Down)
          • Solving Linear Equations (QQI Relay)
          • Solving Linear Equations (QQI BINGO)
          • Solving Linear Equations (QQI Worksheets)
        • Solving Equations with Algebraic Fractions (Video)
      • Quadratic Equations >
        • Solving Quadratic Equations >
          • Solving Quadratic Equations (QQI)
          • Solving Quadratic Equations (10QQI)
          • Solving Quadratic Equations (QQI Count Down)
          • Solving Quadratic Equations (QQI Relay)
          • Solving Quadratic Equations (QQI BINGO)
          • Solving Quadratic Equations (QQI Worksheets)
        • Solving Quadratic Equations by Factorising (Video)
        • The Quadratic Formula (Video)
        • Problems Involving Quadratic Equations (Video)
      • Simultaneous Equations >
        • Solving Simultaneous Equations >
          • Solving Simultaneous Equations (QQI)
          • Solving Simultaneous Equations (10QQI)
          • Solving Simultaneous Equations (QQI Count Down)
          • Solving Simultaneous Equations (QQI Relay)
          • Solving Simultaneous Equations (QQI Relay Fixed)
          • Solving Simultaneous Equations (QQI BINGO)
          • Solving Simultaneous Equations (QQI Worksheets)
        • Solving Simultaneous Equations Graphically (Video)
        • Simultaneous Equations by Substitution (Video)
        • Simultaneous Equations by Elimination (Video)
        • Simultaneous Equations - One Non-Linear (Video)
    • Sequences >
      • Sequences Activity (QQI)
      • Sequences Activities >
        • Sequences (QQI)
        • Sequences (10QQI)
        • Sequences (QQI Count Down)
        • Sequences (QQI Relay)
        • Sequences (QQI BINGO)
        • Sequences (QQI Worksheets)
      • Generating Sequences (Video)
      • General Term for Linear Sequences (Video)
      • Simple Quadratic Sequences (Video)
      • General Term for Quadratic Sequences (Video)
      • General Term for Cubic Sequences (Video)
      • Geometric Sequences (Video)
      • Common Differences (QQI)
    • Graphs >
      • Straight Line Graphs >
        • Drawing Straight Line Graphs (GGB)
        • Gradient of a Line (GGB)
        • Gradient of a Line 2 (GGB)
        • Parallel Lines (GGB)
        • Perpendicular Lines (GGB)
        • y = mx + c Activity (GGB)
        • Battleships 1 (AGG)
        • Battleships 2 (AGG)
        • Battleships 3 (AGG)
        • Find the Lines 1 (AGG)
        • Regions in Graphs (Video)
      • Non-Linear Graphs >
        • Drawing Curves (GGB)
        • Quadratic Graphs Activity (GGB)
        • Finding Quadratic Functions (Video)
      • Graphs with a Casio GDC (Video)
    • Graph Transformations >
      • Graph Transformations 1 (GGB)
      • Graph Transformations 2 (GGB)
      • Graph Transformations 3 (GGB)
      • Graph Transformations 4 (GGB)
      • Graph Transformations 5 (GGB)
      • Graph Transformations 6 (GGB)
    • Functions >
      • Functions Introductions (Video)
      • Function Graphs and Important Points (Video)
      • Solving Unfamiliar Equations Using Functions (Video)
      • Function Notation Revision (Video)
      • Composite Functions (Video)
      • Inverse Functions (Video)
  • Shape
    • Symmetry >
      • Reflection Symmetry >
        • Reflection Symmetry in Quadrilaterals (GGB)
        • Reflection Symmetry in Triangles (GGB)
        • Reflection Symmetry in Other Shapes (GGB)
      • Rotational Symmetry >
        • Rotational Symmetry in Quadrilaterals (GGB)
        • Rotational Symmetry in Triangles (GGB)
        • Rotational Symmetry in Other Shapes (GGB)
    • Area and Perimeter >
      • Polygons >
        • Perimeters (GGB)
        • Area of a Triangle (GGB)
        • Area of a Parallelogram (GGB)
        • Area of a Trapezium (GGB)
        • Area of Compound Shapes (GGB)
        • Perimeter and Area (GGB)
      • Circles >
        • Discovering Pi (GGB)
        • Circumference of a Circle (GGB)
        • Area of a Circle (GGB)
        • Running Tracks (GGB)
        • Circle Area Problem (GGB)
        • Circles and Squares (GGB)
      • Area (QQI)
      • Area (10QQI)
      • Tilted Squares (GGB)
      • Difference Between Two Squares (GGB)
    • Volume and Surface Area >
      • Volumes and Surface Areas (QQI)
      • Volumes and Surface Areas (10QQI)
    • Angles >
      • Guess the Angle (GGB)
      • Angles on a Straight Line (GGB)
      • Angles around a Point (GGB)
      • Angles in a Triangle (GGB)
      • Angles in a Quadrilateral (GGB)
      • Angles in a Regular Polygon (GGB)
      • Angles on Parallel Lines (GGB)
      • Striping Angles (GGB)
    • Transformations >
      • Reflection >
        • Reflections (GGB)
        • Reflection Challenge (GGB)
      • Rotation >
        • Rotations (GGB)
        • Rotation Challenge (GGB)
      • Translation >
        • Translations (GGB)
        • Translation Challenge (GGB)
      • Enlargement >
        • Enlargements (GGB)
        • Enlargement Challenge (GGB)
        • Other Scale Factors (GGB)
      • Challenges >
        • Which Transformation (GGB)
        • How Many Transformations (GGB)
        • Find Them All (AGG)
        • Ultimate Challenge (GGB)
      • Matrix Transformations (AGG)
    • Pythagoras Theorem >
      • Pythagoras Theorem Activities >
        • Pythagoras Theorem (QQI)
        • Pythagoras Theorem (10QQI)
        • Pythagoras Theorem (QQI Count Down)
        • Pythagoras Theorem (QQI Relay)
        • Pythagoras Theorem (QQI BINGO)
        • Pythagoras Theorem (QQI Worksheets)
      • Pythagoras Theorem (GGB)
      • Pythagorean Triples (GGB)
      • Pythagoras Proof (GGB)
      • Ladders up Walls (GGB)
      • Pythagoras in 3D (GGB)
      • Finding the Hypotenuse Example (Video)
      • Finding a Shorter Side Example (Video)
    • Trigonometry >
      • Right Angled Trigonometry >
        • Right Angled Trigonometry (QQI)
        • Right Angled Trigonometry (10QQI)
        • Right Angled Trigonometry (QQI Count Down)
        • Right Angled Trigonometry (QQI Relay)
        • Right Angled Trigonometry (QQI BINGO)
        • Right Angled Trigonometry (QQI Worksheets)
        • Discovering Trig Ratios (GGB)
        • Finding Lengths (GGB)
        • Finding Missing Lengths (Video)
        • Finding Missing Angles (Video)
      • Sine Rule (Video)
      • Cosine Rule (Video)
      • Sine and Cosine Rules (Video)
    • Circle Theorems >
      • Angle in the Centre vs Angle at the Circumference (GGB)
      • Angle at the Centre vs Angle at the Circumference (Video)
      • Angles in a Semicircle (GGB)
      • Angle in a Semicircle (Video)
      • Angles in Cyclic Quadrilaterals (GGB)
      • Angles in a Cyclic Quadrilateral (Video)
      • Angles in the Same Segment (GGB)
      • Angles in the Same Segment (Video)
      • Tangents (GGB)
      • Tangents (Video)
      • Alternate Segment Theorem (GGB)
      • Intersecting Tangents (GGB)
      • Intersecting Tangents (Video)
      • Intersecting Chords (GGB)
    • Vectors >
      • Vectors and Scalars (Video)
      • Vector Notation (Video)
      • Resultant Vectors (Video)
      • Resultants of Column Vectors (Video)
      • Scalar Multiplication (Video)
      • Magnitude of a Vector (Video)
    • Miscellaneous >
      • Squares (GGB)
      • Tangrams (GGB)
      • Euler Line (GGB)
      • Geoboards
  • Statistics
    • Probability >
      • Probability (QQI)
      • Probability (10QQI)
      • Probability Tools (Flash)
    • Averages >
      • Averages Activity (QQI)
      • Listed Averages >
        • Listed Averages (QQI)
        • Listed Averages (10QQI)
        • Listed Averages (QQI Count Down)
        • Listed Averages (QQI Relay)
        • Listed Averages (QQI BINGO)
        • Listed Averages (QQI Worksheets)
        • Averages From Lists of Data (Video)
        • Quartiles and Interquartile Range (Video)
      • Averages from Frequency Tables >
        • Averages from Frequency Tables (QQI)
        • Averages from Frequency Tables (10QQI)
        • Averages from Frequency Tables (QQI Count Down)
        • Averages from Frequency Tables (QQI Relay)
        • Averages from Frequency Tables (QQI BINGO)
        • Averages from Frequency Tables (QQI Worksheets)
        • Averages From Frequency Tables (Video)
        • Averages From Grouped Frequency Tables (Video)
      • Averages With A GDC (Video)
    • Statistical Diagrams >
      • Cumulative Frequency (Video)
      • Scatter Graphs and the Mean Point (Video)
      • Scatter Graphs and Linear Regression on a GDC (Video)
      • Correlation and the Correlation Coefficient on a GDC (Video)
  • Post 16 Topics
    • Binomial Expansion >
      • Binomial Expansion (Video)
      • Binomial Theorem (Video)
      • Binomial Coefficients (Video)
      • Binomial Applications (Video)
    • Coordinate Geometry >
      • Coordinate Geometry (QQI)
      • Coordinate Geometry (10QQI)
      • Equation of a Circle (AGG)
    • Differentiation >
      • Differentiating Polynomials >
        • Differentiating Polynomials (QQI)
        • Differentiating Polynomials (10QQI)
        • Differentiating Polynomials (QQI Count Down)
        • Differentiating Polynomials (QQI Relay)
        • Differentiating Polynomials (QQI BINGO)
        • Differentiating Polynomials (QQI Worksheets)
      • Finding Gradients of Curves (QQI)
      • Finding Gradients of Curves (10QQI)
      • Finding Turning Points of Curves (QQI)
      • Finding Turning Points of Curves (10QQI)
    • Trigonometry >
      • Radian and Degree Conversions >
        • Radian and Degree Conversions (QQI)
        • Radian and Degree Conversions (10QQI)
        • Radian and Degree Conversions (QQI Count Down)
        • Radian and Degree Conversions (QQI Relay)
        • Radian and Degree Conversions (QQI BINGO)
        • Radian and Degree Conversions (QQI Worksheets)
      • Trigonometric Exact Values >
        • Trigonometric Exact Values (QQI)
        • Trigonometric Exact Values (10QQI)
        • Trigonometric Exact Values (QQI Count Down)
        • Trigonometric Exact Values (QQI Relay)
        • Trigonometric Exact Values (QQI BINGO)
        • Trigonometric Exact Values (QQI Worksheets)
      • Graphs of Trig Functions (GGB)
  • Starters, Puzzles and Enrichment
    • UKMT Random Question Generator
    • @mathschallenge Random Questions
    • School of Hard Sums Random Questions
    • Random Starter of the Day
    • Mathematically Possible (QQI Starter)
    • Adding Challenge (QQI Starter)
    • Date Starter (QQI Starter)
    • Name That Number (QQI Starter)
    • Matchstick Random Questions
    • Choose 3 Numbers (QQI Starter)
    • What's The Question (QQI Starter)
    • Mathematical Words (QQI Starter)
    • Number of the Day (QQI Starter)
    • Anagrams and Missing Vowels (QQI Starter)
    • Missing Vowels and Word Jumbles (QQI) >
      • Missing Vowels and Word Jumbles Simple Numbers (QQI)
    • Tables (QQI)
    • Target Boards (QQI)
    • Missing Signs (QQI)
    • Random Activities >
      • Exploding Dots
      • Easter Date
      • Easter Tangrams (GGB)
      • Zeller's Algorithm
      • Batman Equation (AGG)
      • Templates
    • Mathematical Videos >
      • Fermat's Last Theorem (Video)
      • Pi Song (Video)
      • Monty Hall Problem (Video)
      • Symmetry, Reality's Riddle (Video)
      • Music of the Primes (Video)
      • Folding Paper (Video)
      • Nature by Numbers (Video)
      • Inspirations (Video)

Self Assessment

26/7/2015

0 Comments

 
Introduction
We are just starting the revision process here in Peru for the IGCSE and IB exams in November. As part of the flipped classroom I am hoping to develop student independence in their learning, and with this I have been trying to come up with a way where they can identify areas that they need to work on. Self-assessment is not a new thing, and I have implemented it with relative success previously, but I am hoping the update system I have now created will help students to keep on top of this large amount of data more easily.
It starts with students filling out a Google Form which lists all the objectives for the year/course which they are studying. Image 1 shows an example for one section of the IB Maths Standard Level course. If you would like to give it a go, then fill out this form.
Picture
Image 1: An example of the form which students fill in.
Once completed, students then get emailed a link to see their personal results, listed in order of confidence, those needing most work first. Below is an example of one that I filled out. They can comment on this document, identifying areas they would like to work on first, and then you can see these comments. If they go to fill in the form again, they will be directed to their original submission, which they can then adjust and resubmit (this will send them a new email with a link to the updated document, with each update saved as a separate tab in the document).
Picture
I also have a second tab where I can add details of how they are doing in specific topics, by assigning them a grade of A,B,C or D. These could be based on specific tasks set for each objective, or a more fluid grade. These results are simultaneously shown with the self-assessment results, similarly filtered in order of needing the most work.
From my perspective as the teacher, I can see each individual breakdown that the students can see, but also can see the whole class split up by objective in the original sheet that the form submits to. With some conditional formatting, I can then also identify easily any objectives that the majority of the class are struggling with, so that I can provide whole class revision activities where necessary. Obviously, with the individual feedback, I can also plan more specific tasks for individuals as well.
I have managed to create the code that does all this using the Apps Script that you can enable for Google Sheets, and below I will explain how you can use this to create your own version of this Self-Assessment form.
How To
First of all open this Google Form which has the requied layout for the form. Go to File->Make a copy... (as shown in Image 2). Choose a name for the new copy which will be saved in YOUR Google Drive.
Picture
Image 3: Form Settings
The Form Settings should be as seen in Image 3. Should you have a personal (not institutional) account, then the top two options will not appear. For the form to still work, you need to add an extra question at the very beginning of the form collecting the email address of the respondent (make it required).
Picture
Image 2: Make a copy of the Google Form in your own Drive.
Now you can edit the questions themselves. Leave the first question as the Name box. For the remaining questions you have some options. When you click on one, it will look like Image 4.
Picture
Image 4: The Grid Question option used in this form
  1. If you have enough sections for your use already, then click this button to delete the current question;
  2. If you need more sections than are provided, then click this button to copy the current question;
  3. In this section you can edit and add extra parts to this section. This is where you add the individual objectives for each given section;
  4. This is the possible answers for students to select. DO NOT CHANGE THIS SECTION AT ALL. The script used later will only work if this remains as it is.
  5. You can decide if you want to force students to assess every objective, or allow them to assess some later on.
  6. Name the section that these objectives fit within.
Picture
Image 5: Set the spreadsheet to record the results
Now you are ready to set up the spreadsheet where the results will be recorded. Go to Responses->Change response destination... (as in Image 5), and when the pop-up appears set it as in Image 6.
Picture
Image 6: Choose the default spreadsheet
This will create a new spreadsheet to record all form submissions. When you originally copied the form, it probably created its own spreadsheet automatically. You will want to delete this one. Be careful though, as it probably has the same name as the new spreadsheet you just created. Now is also a good time to move both the form and the spreadsheet into a new folder for this (it is going to create a file for each student, so want them in a folder somewhere). You can drag them into a folder, or go via the File menu in each file.
Now open up the spreadsheet, either by clicking on View responses or opening it from the folder. It should look like Image 7 below.
Picture
Image 7: The spreadsheet where the responses will be collected before any changes.
Now you need to go to Tools->Script editor... (Image 8) A new window should open with the script editor (a pop up may appear offering templates, simply click Close on this). Now select all the code in this window and delete it. Open up the code file, copy the code and paste it into this window (it should look like Image 9).
Picture
Image 8: Choose Tools->Script editor...
Picture
Image 9: The input code
We need to save the code before we can proceed. Press the save button, and in the pop-up that appears type a name for this code (it does not matter what you call it, I always call it analysis).
Now go to Run->setup (as in Image 10). A pop up warning will appear saying "Authorization required". Click Continue, and then Accept on the next pop up that appears. This allows the code to edit the spreadsheet automatically, and send the automatic emails.
Picture
Image 10: Run setup to format the spreadsheet as needed for the rest of the code to work.
If you now go back to look at the actual spreadsheet, you will notice that it has added a second tab named "Teacher Assessment", renamed the original one "Self Assessment", and frozen some columns. It also renames the questions removing the excess that Google Forms automatically includes.
Picture
Image 11: The editted sheet after running setup.
Now we need to set it up to automatically email students after they have submitted their self assessment. Go to Resources->Current project's triggers (as in Image 12). In the pop up that appears, click the link "No triggers set up. Click here to add one now."
Picture
Image 12: Set a trigger to email students when they submit a form.
In the pop up that opens now, change the settings to what is shown in Image 13. Then click Save.
Picture
Image 13: Setting up the trigger
The form is now ready to distribute to you students. Close the script editor, and return to the form. In the top right corner is the button to Send Form, and you can follow the instructions here to send out the form to your class. They will all now receive an email inviting them to fill out the form. As they submit them, they will receive an email linking to their own personal document (as in the example at the beginning of this post).
Teacher Assessment

You can now manually input Teacher Assessment results for each student for each objective. In the relevent cell simply add an A, B, C or D for how the student is doing in this area from what you have seen. It must be one of these grades, nothing else will work.
If you now want to manually send out updated self assessment documents to all the students, then go back to the script editor (Image 8), and Run->selfAssess (Image 10). This will send the whole class an updated link for their document. When you do this, the conditional formatting should also kick in, colour coding the different grades.
Alterations
There are some relatively easy alterations you can make to the code to personalise the form a little bit, and I will go through these in this section.
1. If you want to change the self assessment wording (Image 4 point 4), then you also need to change the code to fit this. Maintain the number of options at 3 (unless you are confident enough in to add an extra bit of code). Once you have changed these you need edit the corresponding code TWICE.
Find the section seen in Image 14 (part of the function selfAssess, use the line numbers 93, 98, 103). In each of the red boxes you need to change the text to what you changed the questions too. This must match exactly (case sensitive and spaces/punctuation). Make sure you leave the text within quote marks as well. This is the manual one you can run at any time.
Picture
Image 14: Code to edit
You need to do the SAME CHANGE in selfAssessFormSubmit as well (lines 328, 333, 338). This is the one that goes automatically when they submit.
2. If you want to use different grades instead of A, B, C and D in the Teacher Assessment, then you can do this by changing the the four grades in the blue box in Image 14 (Line 80). Make sure each grade is inside quote marks, and that there are only four. They should be typed in uppercase, and start with the best grade and work down. You also need to make this change in Line 304.
3. You can add a button to run the selfAssess code manually so you do not have to access the script editor each time you want to do this. Go to Insert->Drawing... (Image 15) making sure you are on the sheet where you want the button (your choice, but you will normally run it from Teacher Assessment). A fairly intuitive pop up opens where you can design a button (mine is shown in Image 16 below). Click Save & Close to insert this into the sheet.
Picture
Image 16: Create a simple button from a drawing
Picture
Image 15: Insert a button using a drawing
Click on the button and drag it to where you want it. Then click on the little drop down arrow (1 in Image 17), and select Assign script... (2 in Image 17). In the pop up, type selfAssess, and press OK. Now when you press the button it will run the analysis.
Picture
Image 17: Setup script to run on press of button
4. Maybe you want to have the Teacher Assessment for you to see, but not available for students to see. If this is the case, use this slightly modified code. In the document that the student will be sent, there is no Teacher Assessment column, only the Self Assessment. But you can still see the Teacher Assessment column in the relevent tab in your spreadsheet. In this case, students are NOT sent an email when you manually run the code (as this is for when you update the Teacher Assessment, and they cannot see this), but they still receive it when they update their self-assessment.
Final Points

For some unknown reason, the browser seems to crash when the setup process in run. If this happens, simply close the spreadsheet, and reopen it. You can then carry on with the process.
I am hoping that this will allow my students to easily identify which objectives from their course they personally need to work on, and give them a springboard to direct their revision. I am also hoping that it will give me a very clear idea of what the students think they can do, and direct me to any topics that I need to focus on with the whole class, as well as any I need to make interventions with for specific students.
If you have any comments, I would love to hear them below. I hope this is useful for people.
0 Comments

    Dan Rodriguez-Clark

    I am a maths teacher looking to share good ideas for use in the classroom, with a current interest in integrating educational research into my practice.

    Categories

    All
    Coaching
    Displays
    General
    Leadership
    Personal
    Planning
    Projects
    Reading Review
    Reflections
    Research Based
    Resources
    Teaching Ideas
    Tech Ideas

    Archives

    August 2021
    April 2021
    January 2021
    December 2020
    October 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    February 2018
    December 2017
    November 2017
    October 2017
    May 2017
    May 2016
    February 2016
    January 2016
    September 2015
    July 2015
    April 2015
    March 2015
    February 2015
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    September 2013
    July 2013
    June 2013
    May 2013
    April 2013
    March 2013
    February 2013
    January 2013
    December 2012

    RSS Feed

Information
  • About Me
  • Contact Me
  • Links
  • Legal and Fees
  • Privacy Policy
Indices and Activities
  • QQI Activity Descriptions
  • Activity Index
  • Video Index
Sister Sites
  • The blog
  • Generators
  • Crypto Corner
  • ​Mr R-Cs Classes
©2012-2019 Daniel Rodriguez-Clark
All rights reserved
Picture