On The Right Track

Technology design cycle report



This is a design cycle report about this unit called 'on the right track'. My name is Dina Ung and I'm a student of grade 8 at NISC. This flyer will show what I do throughout this unit.

Identify the problem

Students don't really know and understand about assessments and how they get graded for all subjects in the MYP. Most students are always unsure of what they should do to get top marks for each class and each criteria; they are also not sure about how the teachers assess and grade their work.
If students don't know what they are supposed to do in each classes to get top grades, they will feel helpless and some will just give up on that subject. Some students will do whatever they think will make them get top marks, but might ended up doing the wrong thing and got lower marks that those who didn't even try, which is not fair for those who tried.
When students know clearly about their assessment and how they get graded by the teachers, they will know where to spend their time and energy correctly and wisely; and by spending their time and putting their effort correctly on the right things, they will get top marks.

To prove this is true, I created a chart, based on my memory, to demonstrates all that I know about assessment in each class and the images of my charts are on display (two images below).

These are the charts I created based on my memory. As you can see, I could only remember approximately 20% of all the subjects, and just briefly.

Design brief

I will create a product that can clearly explain assessments for each subject and a spreadsheet where a student can add their grades for each assessment task. It must be easy to use (the user) and easy to understand (the audience).

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 colours for different subjects
  • include a heading

Testing Methods

Sereirath and Erica will test my product, the following test will be used to gather feedback about the effectiveness of my product. (insert test)

My spreadsheet will be tested by Sereirath and Erica, they will use the following criteria to assess it.

  1. Was the spreadsheet complete with space for all subjects or criteria or all the units?
  2. Did the spreadsheet have an excellent title?
  3. Was coloring use effective?
  4. Did the spreadsheet use formulas?
  5. Was the layout excellent?

My stand-alone product will be tested by Sereirath and Erica, they will use the following criteria to assess it.

  1. Was the stand-alone product appropriate for target audience (MYP students)?
  2. Was there a careful balance between text and image in a stand-alone product?
  3. Were all the classes covered in the stand-alone?
  4. Was there a clear introduction?
  5. Was the color scheme and font choice and lay-out stylish and effective?

Test on my products:

  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 will conduct the test between the 24th and 26th of September.

Testers: Erica, Sophie, Sereirath, Alpha and Mr. Luke.


To increase my understanding about spreadsheets, I decided to conduct some research on the internet.


Through research I found out that 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 the data.
"A table of values arranged in rows and columns. Each value can have a predefined relationship to the other values. If you change one value, therefore, you may need to change other values as well

Spreadsheet applications (sometimes referred to simply as spreadsheets) are computer programs that let you create and manipulate spreadsheets electronically. In a spreadsheet application, each value sits in a cell. You can define what type of data is in each cell and how different cells depend on one another. The relationships between cells are called formulas, and the names of the cells are called labels."

Spreadsheets are being used by accountants for hundreds of years already. Computerized or electronic spreadsheets are used recently. Information Systems oral history and some published newspaper and magazine stories celebrate Dan Bricklin as the "father" of the electronic spreadsheet.

Accountants, teachers, engineers, sales people, scientists, super markets and market researchers use spreadsheet to help them with their data that they need to keep track of.

A spreadsheet is better than a calculator or a pen as it can handle data more effectively. When calculating costs using a spreadsheet, a formula can be used and applied uniformly. The information in the spreadsheet can also be presented in many ways making and it also makes it easier to alter as well as save ones work.

There are many different types of spreadsheets, here are some examples:

  • Two-Dimensional Spreadsheets

  • Three-Dimensional Spreadsheets

  • Arithmetic Spreadsheets

  • Logical Spreadsheets

  • Object-Oriented Spreadsheets


Refers to a device that is self-contained, one that does not require any other devices to function. For example, a fax machine is a stand-alone device because it does not require a computer, printer, modem, or other device. A printer, on the other hand, is not a stand-alone device because it requires a computer to feed it data.(Webopedia)

Stand-alone presentations are presentations that don't need other equipments besides itself, it doesn't need people, anyone to talk or explain anything, the stand-alone presentation will explain everything.

Example of stand-alone presentations:


To increase my understanding about MYP and how each subject is graded I conducted some research and also interviewed my teachers. This is what I discovered...

The Middle Years Programme (MYP) is specially designed for the unique needs of children ages eleven to sixteen (grades 6 through 10), at a time when they need to develop exceptional learning habits, self-confidence and a thorough understanding of their academic subjects.I will now explain assessments for each of my subject.


I conducted my primary research by interviewing my technology teacher- Mr. Luke Watson, and these are the things I got from him:

Maximum marks for each unit/ assessment is 36 ( 6 marks for each criteria. there are 6 criteria ):

A- Investigation 6/6

B- Design 6/6

C- Plan 6/6

D- Create 6/6

E- Evaluate 6/6

F- Attitudes in technology 6/6


I conducted more research on mathematics assessments in MYP, and this is what I found:

Maximum marks for each unit/ assessment is 28 ( 8 marks for two criteria and t 6 marks for the other two criteria ):

A- Knowledge and understanding 8/8

B- Investigating patterns 8/8

C- Communication in mathematics 6/6

D- Reflection in mathematics 6/6


I did more research on physical education assessments in MYP, and this is what I found:

Maximum marks for each assessment/ unit is 32, there are 4 criteria in total:

A- Use of knowledge 8/8

B- Movement composition 6/6

C- Performance 10/10

D- Personal engagement 8/8


I also also researched about arts assessments for MYP, this is what I found:

Maximum marks for each assessment/ unit is 38, there are 4 criteria in total ( 10 marks for one criteria, and 8 marks each for the other three criteria:

A- Knowledge and understanding 8/8

B- Application 10/10

C- Reflection and evaluation 8/8

D- Personal engagement 8/8


What I found about English assessments in MYP:

Maximum marks for each unit/ assessment is 30, there are only 3 criteria in total ( 10 marks for every criteria)

A- Content 10/10

B- Organisation 10/10

C- Style and language mechanics 10/10


What I found about science assessments in MYP:

Maximum marks for each unit/ assessment is 36, there are 6 criteria in total ( 6 marks for each criteria)

A- One world 6/6

B- Communication in science 6/6

c- Knowledge and understanding 6/6

D- Scientific inquiry 6/6

E- Processing data 6/6

F- Attitude in science 6/6


What I found about mandarin assessments in MYP:

Maximum marks for each unit/ assessment is 32, there are 4 criteria in total ( 8 marks for each criteria)

A- Oral communication 8/8

B- Visual interpretation 8/8

C- Reading comprehension 8/8

D- Writing 8/8


What I found about humanities assessments in MYP:

Maximum marks for each unit/ assessment is 32, there are 4 criteria in total ( 8 marks for each criteria)

A- Knowing and understanding 8/8

B- Investigation 8/8

C- Thinking critically 8/8

D- Communicating 8/8

(Atlanta International School, 2009)


Works Cited

Dssresources."A Brief History of Spreadsheets." Brief History of Spreadsheets, v. 3.6. 01 Sept. 2013 <http://dssresources.com/history/sshistory.html>.

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

Wikimedia."File:Spreadsheet animation.gif." - Wikimedia Commons. 01 Sept. 2013 <http://commons.wikimedia.org/wiki/File:Spreadsheet_animation.gif>.

Ibo."Humanities guide." Humanities guide. 01 Sept. 2013 <http://xmltwo.ibo.org/publications/MYP/m_3_human_guu_1202_1/html/>.

Ibo."Language A guide." Language A guide. 01 Sept. 2013 <http://xmltwo.ibo.org/publications/MYP/m_1_langa_guu_0901_2/html/production-app3.ibo.org/publication/149/part/2/chapter/2.html>.

Ibo."Language B guide." Language B guide. 01 Sept. 2013 <http://xmltwo.ibo.org/publications/MYP/m_2_langb_guu_1203_1/html/>.

Wikispaces."MYP - Physical Education Assessment Criteria." MYP - Physical Education Assessment Criteria. 01 Sept. 2013 <http://myp.biss.wikispaces.net/Physical%20Education%20Assessment%20Criteria>.

Wikispaces."MYP - The Arts Criteria Assessment." MYP - The Arts Criteria Assessment. 01 Sept. 2013 <http://myp.biss.wikispaces.net/The Arts Criteria Assessment>.

Ibo."Sciences guide." Sciences guide. 01 Sept. 2013 <http://xmltwo.ibo.org/publications/MYP/m_4_scien_guu_1002_1/html/production-app3.ibo.org/publication/215/part/2/chapter/2.html>.

Webopedia."Spreadsheet." Webopedia. 01 Sept. 2013 <http://www.webopedia.com/TERM/S/spreadsheet.html>.

Webopedia."Stand-alone." Webopedia. 01 Sept. 2013 <http://www.webopedia.com/TERM/S/stand_alone.html>.

Ask.com."What Are the Advantages of Using a Spreadsheet?" What Are the Advantages of Using a Spreadsheet. 01 Sept. 2013 <http://www.ask.com/question/what-are-the-advantages-of-using-a-spreadsheet>.

ThinkQuest."What is Spreadsheet?" ThinkQuest. Oracle Foundation. 01 Sept. 2013 <http://library.thinkquest.org/J0110054/definition.html>.

ED-ucation."What is the MYP? - What is IB?" What is IB? 01 Sept. 2013 <http://www.whatisib.com/what-is-myp.html>.

WikiAnswers."Who uses spreadsheets?" WikiAnswers. Answers. 01 Sept. 2013 <http://wiki.answers.com/Q/Who_uses_spreadsheets>.

Atlanta international school. "Middle Years Programme (MYP)." Atlanta International School:. Atlanta International School, n.d. Web. 03 Sept. 2013.