On The Right Track

Technology Design Cycle Report


This is a design cycle report about 'On The Right Track'. My name is Sereirath and I'm a student in grade 8 at Northbridge International School Cambodia.

Identifying The Problem

Students don't know about assessment task. This is a problem in grade 8. We don't know how much points we get in each criterion. Students also don't know what to do to get top marks and don't know clearly how teacher grades their work. Some might understand how the grading system works, but they don't know the criterion and the points the teacher is assessing on.

For better student engagement and students to get better grade, the students should be aware of the objectives and assessment task and marking criteria. If the students are aware of assessment tasks and the way it will be mark, then student can be more efficient with their time and energy, because if the students know the criteria well, they can focus more on that thing to make their grades better. Assessment should help students learn. Also you need to use what you learn in class in your assessment task, because assessment will consist with objectives of the course and what is taught and learnt in class.

The importance of knowing the assessment task/criteria is that student can focus on what to work on and recheck their work make sure they got all of what the assessment task is needed, by doing this way, students can get better grade.

So to understand more, I have created a chart to see my knowledge on how much I know about each subject assessment task and take a picture of it. You might not see it clearly but I'm going to put what I write on the 2 images below.

Image 1




Language B

-Writing (8 points)

-Visual Interpretation


-Personal Engagement


-Knowledge and Understanding

English A

Image 2


-Personal Engagement



-Knowledge and Understanding


-Investigation (6 points)

-Plan (6 points)

-Create (6 points)

-Evaluation (6 points)

To get top marks, you need to met the criterion


-Knowledge and Understanding



So from my chart, it looks like and barely know anything about the criterion and the points of each criterion.

Design Brief

I'll demonstrate the problem by creating a product that clearly explains assessment for each subject and a spreadsheet where I can add my grades for each assessment task that is easy for me to use and easy to understand for the audience.


I discovered, through research, that a spreadsheet is an excellent way to display and explain my classroom assessment tasks. Here is some background information about spreadsheets.

A spreadsheet is a grid that organizes data into columns and rows. Spreadsheets make it easy to display information, and people can insert formulas to work with data. Spreadsheets are designed to ease the management of numbers and calculations. They calculate totals, averages, percentages, budgets and complex financial and scientific formulas. Accountants have used spreadsheets for hundreds of years (Power, D.J). VisiCalc was the first computer spreadsheet program. In 1978, Harvard Business School student, Daniel Bricklin came up with the idea for an interactive visible calculator. Bricklin and Bob Frankston then co-invented or co-created the software program VisiCalc. (Bellis, n.d.). Everyone uses spreadsheet. Business man/woman, students, teacher etc. Spreadsheets offer a range of advantages, particularly to business users. Spreadsheets provide complex processing in ways that even people with little technical experience can access. The ability to enter mathematical formulas is key to the usefulness of spreadsheets. Spreadsheet programs can transform data sets into various types of graphical displays. Spreadsheet is also useful for analyzing data and make graph easier. There are lots of different types of spreadsheets and here are some.

Two-Dimensional Spreadsheets

Two-dimension spreadsheets consist of “cells”-a box holding one piece of data-arranged in rows and columns like a table.

Three-Dimensional Spreadsheets

Modern spreadsheet application allow for more then one two- dimensional “sheet,” effectively stacking related spreadsheets on top of each other and introducing a third dimension.

Design Specification

The product created to explain how assessment in grade 8 must:

  • be stand alone
  • be appropriate in length (not to long or too short)
  • for MYP students (audience)
  • outline assessment criteria, how each assessment criteria is graded and how and overall grade is calculated
  • use a good balance of images and text
  • when information and/or images are used from other sources - it must be referenced

The spreadsheet created must:
  • include all subject
  • include all assessment criteria
  • allow for multiple units of work
  • calculate averages, when appropriate
  • include overall grade
  • use different cell colors for different subjects
  • include a heading

Arithmetic Spreadsheets

Spreadsheets often utilize arithmetic functions, such as automatically adding up all the values of one particular column. These functions are necessary for budget and invoice spreadsheets, for example.

Logical Spreadsheets

Some spreadsheets utilize logic functions, rather than arithmetic functions, to allow for deductive reasoning.

Stand-alone Presentation

What is a stand-alone presentation?

A stand-alone presentation means that a presentation that doesn't require anything beside itself. It can operate independently without anyone to generate it. So if you decide to do a stand-presentation by yourself, it means that you just stand up and talk without anything, you're the one that explains all of the things. You can see stand-alone presentation everywhere, because a stand-alone presentation can be a banner or poster that tell information about something and it doesn't require a person to explain all the time. There're a lot of stand-alone presentation that you can use such as Prezi, Globster, Weebly, Sliderocket, and other kinds of online website or powerpoint. Poster, banner, slideshow,etc are also a stand-alone presentation, because it doesn't require anything or anyone to explain it all the time, you just have to look at it then you'll get the information that you need.

Here are 3 examples that I found that use a stand-alone presentation:





What is MYP?

MYP stand for Middle Years Programme. The MYP program is designed for students aged 11-16. It provides a framework of learning which encourages students to become creative, critical and reflective thinkers. The IB Middle Years Programme consists of eight subject groups integrated through five interactive areas providing global contexts for learning.Students are required to study at least two languages (as part of their multilingual profile), humanities, sciences, mathematics, arts, physical education and technology. In their final year, students will also undertake an independent ‘personal project’ to demonstrate the development of their skills and understanding.

So now I will outline assessment for each subject:

I conducted the research by interviewing the technology teacher on Thursday August 29th 2013 and this is the information that I got from the interview.


Technology class maximum mark is 36 points. There are six components, and each components are worth 6 marks.

Criterion A: Investigation

Criterion B: Design

Criterion C: Plan

Criterion D: Create

Criterion E: Evaluate

Criterion F: Attitudes in Technology


I conducted some research and went to a website. The website is in the bibliography section in MYP and here is the information I got for the website. The maximum mark is 28 points.

Criterion A: Knowledge and understanding (Maximum 8)

Criterion B: Investigating patterns (Maximum 8)

Criterion C: Communication in mathematics (Maximum 6)

Criterion D: Reflection in mathematics (Maximum 6)

Language B

I conducted some research I went to a website that tells me about Language B assessment criteria. All of the criteria are worth 8 points. The maximum mark is 32 points.

Criterion A: Oral communication (Maximum 8)

Criterion B: Visual interpretation (Maximum 8)

Criterion C: Reading comprehension (Maximum 8)

Criterion D: Writing (Maximum 8)

Language A/English A

The maximum mark for Language A is 30 points. All of the criteria are worth 10 points.

Criterion A: Content (receptive and productive) (Maximum 10)

Criterion B: Organization (Maximum 10)

Criterion C: Style and Language mechanics (Maximum 10)


All of the criteria are worth 6 points. The maximum mark for Science is 36 points.

Criterion A: One World (Maximum 6)

Criterion B: Communication in Science (Maximum 6)

Criterion C: Knowledge and Understanding in Science (Maximum 6)

Criterion D: Scientific Enquiry (Maximum 6)

Criterion E: Processing Data (Maximum 6)

Criterion F: Attitudes in Science (Maximum 6)

Art and Music

Art and Music have the same criteria and points.The maximum mark for Art and Music is 34 points.

Criterion A: Knowledge and Understanding (Maximum 8)

Criterion B: Application (Maximum 10)

Criterion C: Reflection and Evaluation (Maximum 8)

Criterion D: Personal Engagement (Maximum 8)


The maximum mark for PE is 32 points.

Criterion A: Use of Knowledge (Maximum 8)

Criterion B: Movement Composition (Maximum 6)

Criterion C: Performance (Maximum 10)

Criterion D: Social skills and personal engagement (Maximum 8)


All of the criteria are worth 8 points. The maximum mark for humanity is 32 points.

Criterion A: Knowledge and Understanding (Maximum 8)

Criterion B: Investigating (Maximum 8)

Criterion C: Thinking Critically (Maximum 8)

Criterion D: Communicating (Maximum 8)

Testing Methods

Sophie, Dina, Lareach, Nara and Erica will test my product , the following test will be used to gather feedback about the effectiveness of my product.

My stand-alone will be test by Sophie, Dina and Erica and they will use the following criteria to access it.

  1. Was the stand alone product appropriate for the target audience (MYP Students)?
  2. Was there a careful balance between text and image in the stand alone product?
  3. Were all classes covered in the stand alone?
  4. Was there a clear introduction on the stand alone?
  5. Was the colour scheme, font choice and layout stylish and effective?

My spreadsheet will be test by Sophie, Dina and Erica and they will use the following criteria to access it.

  1. Was the spreadsheet complete with space for all subjects, all assessment criteria, all units of work?
  2. Did the spreadsheet have an excellent title?
  3. Was colouring used effectively on the spreadsheet?
  4. Did the speadsheet use formula for average, sum, sorting and display appropriate cell merge, bordering and shading?
  5. Was the layout excellent?


  1. Name three things you liked about the stand alone presentation.
  2. List three key facts from the stand alone.
  3. Name three things that should be changed on the stand alone to make it better.
  4. Name three things you liked about the spreadsheet.
  5. Name three things that should be changed so that the spreadsheet is better.

I'll conduct test between 24th, 26th of September



N.A."What Are Spreadsheets?" What Are Spreadsheets? N.p., n.d. Web. 27 Aug. 2013. <http://www.web-esl.com/spreadsheet/Spreadsheets.htm>

Power, D. J., "A Brief History of Spreadsheets", DSSResources.COM, World Wide Web, http://dssresources.com/history/sshistory.html, version 3.6, 08/30/2004. Web 27 Aug. 2013

Mary Bellis. "The First Spreadsheet - VisiCalc - Dan Bricklin and Bob Frankston." The First Spreadsheet - VisiCalc - Dan Bricklin and Bob Frankston. N.p., n.d. Web. 27 Aug. 2013. <http://inventors.about.com/library/weekly/aa010199.htm>.

Dance, Michael. "Types of Spreadsheets | EHow." EHow. Demand Media, 11 May 2009. Web. 27 Aug. 2013. <http://www.ehow.com/facts_5016747_types-spreadsheets.html>.

"Tips for New Staff." Assessing Student Learning. N.p., n.d. Web. 27 Aug. 2013. <http://www.cshe.unimelb.edu.au/assessinglearning/07/>

Spreadsheet Picture

"2 Understanding Express Databases." Understanding Express Databases. N.p., 6 Mar. 2004. Web. 03 Sept. 2013. <http://docs.oracle.com/html/A96501_01/02chap.html>.

"Royalty Free Stock Images: 3d Progress Bar on Spreadsheet Background." Dreamstime. N.p., n.d. Web. 27 Aug. 2013

"St Mary's KS3 ICT." St Marys KS3 ICT. N.p., n.d. Web. 27 Aug. 2013. <http://stmarysks3.wordpress.com/category/year-7-homework/>

"Logical Functions." Magick, Wicca, Paganism and Other Esoteric Knowledge. N.p., n.d. Web. 27 Aug. 2013. <http://www.realmagick.com/logical-functions>


"The IB Middle Years Programme." IB Middle Years Programme at a Glance. IBO, n.d. Web. 03 Sept. 2013. <http://www.ibo.org/myp/>.

"Logical Functions." Magick, Wicca, Paganism and Other Esoteric Knowledge. Byron Farrow, 26 Jan. 2011. Web. 03 Sept. 2013. <http://www.realmagick.com/logical-functions>.