How do I decide Unit; Criterion C: Creating Solution

Follow the checklist below as you work on the creation of your solution

• The Plan:
• I have constructed a logical plan (a step-by-step procedure) for the creation of the solution.  (sufficient for peers to be able to follow)
• I have stated the resources that will be needed.
• I have completed a timeline / Gantt chart
• The Creation Process:
  • I have demonstrated excellent technical skills when making the solution.
  • I have fully justified changes made to the chosen design and plan when making the solution.
• Process Journal: 

                        I have maintained a process journal through the entire creation process.

• I have explained the tools and techniques used in the process of creation.
• I have included evidence in the creation phase that I have followed my time plan.
• I have reflected any changes I made to my plan during the creation phase.
• I have included screen shots and other photographic evidences of the key phases of creation.
• I have kept notes in my process journal about how well I worked, problems encountered, and use of time - to be used in the evaluation.
• The Final Project: I have presented the solution as a whole, either in electronic form, or through photographs of the solution from different angles, showing details.
• Evaluate: I have evaluated and reflected on my performance in the this stage.
• Challenges and successes
• Areas of concerns
• The strengths and weaknesses.
• Observations on how this stage could have been improved.
• General reflections 

Requirements for each strand 

(i) Construct a logical plan that describes the efficient use of time and 

resources, sufficient for peers to be able to follow to create the solution. 

pages 1- 2

By the end of year 4 you should be able to:

• construct a series of logical steps to create the solution, using charts, diagrams and text that include aspects of quality control and quality assurance
• construct a plan to create the solution that makes effective use of resources and time
• construct a clear and concise plan that peers will be able to follow to create the solution

(ii) Demonstrate excellent technical skill when making the solution

At the end of year 4 you should be able to:

• develop manipulative skills to effectively use a wide range of tools, techniques and equipment
• use a wide range of tools and equipment proficiently to create high-quality solutions
• ensure a safe working environment for themselves and others

(iii) Follow the plan to create the solution, which functions as intended

By the end of year 4 you should be able to:

• independently follow the plan to produce the solution, which functions as intended
• manage time effectively to produce the solution to the deadline stated in the plan

 ( strand 2 and 3. At-least 6 Pages)

(iv) Fully justify changes made to the chosen design and plan when making the solution

By the end of year 4 you should be able to: Pages 2 or 3 pages

• justify, through the use of drawings/diagrams, any changes made to the design while making the solution and how they affected the plan

Examples plus resources

1. http://designyear10.blogspot.com/

2. http://robc84.wixsite.com/bisdesign/copy-of-crit-b-4

3. https://www.slideshare.net/MichaelBonnick/myp-design-cycle-resource

4. https://ois9dd.wordpress.com/infographicsupport/

5. https://oisdesign11.wordpress.com/2018/01/31/criterion-c-creating-the-solution-4/

Sample Products

1. https://blog.appsheet.com/how-to-manage-stock-in-excel-three-free-excel-templates

Criterion B: Developing Ideas

At the end of year 5, students should be able to:

i. develop design specifications, which clearly states the success criteria for the design of a solution

ii. develop a range of feasible design ideas, which can be correctly interpreted by others

iii. present the chosen design and justify its selection

iv. develop accurate and detailed planning drawings/diagrams and outline the requirements for the creation of the chosen solution.


Strand i)

i)   develop design specifications, which clearly states the success criteria for the design of a solution

-      The design specs should be measurable with a clear way on how the specs will be tested.

-      The specification should be directly connected to your design brief. 

Example: Game Product

Specification	Test
Game will be less than 1 MB in size	Install it in a computer  the size in properties
Played by two players (Multiplayer game)	Allow two players to play simultaneously
The game 3 levels that will advance in complexity.	Play the game at each level time the duration it takes to complete a level and record the complexities.

Maximum of 2 pages

Strand ii) 

ii) develop a range of feasible design ideas, which can be correctly interpreted by others

- Develop a range of good quality designs and measure each of them against the design specs.

- Your description for each design should be detailed and clear and use captions on images or diagrams which are not clear.

- Annotate  the designs with sufficient detail to explain how they meet the requirements of the design specification and to explain design thinking

-  Develop only TWO designs

Sketches
https://sketchboard.io/

https://sketch.io/sketchpad/

Examples of Designs

Maximum of  7 pages

Strand iii)

iii.           present the chosen design and justify its selection

         -      State the chosen design from the two designs.

         -      Provide detailed justification why the design was chosen.

         -      Suggest possible improvements to the chosen design. 

         -      If possible show the chosen design with the improvements included as a final design.

Maximum of  2 pages 

Strand iv)
iv.           develop accurate and detailed planning drawings/diagrams and outline the requirements for the creation of the chosen solution.
          
          The above can be achieved using either of the following tools
           a) Table of requirements.
b)  Flowchart
c)  Site Map

 This should not be confused with the designs developed and justified. This is the process detailing the requirement for the creation of the chosen solution.  

Site Map

Flowchart Sketching software
https://www.digikey.com/schemeit/project/

Site Map Builders
https://www.gloomaps.com/

Maximum of 4 pages

Resources

http://robc84.wixsite.com/bisdesign/copy-of-crit-b-1

Ranking Using Excel

The RANK function in Excel returns the order (or rank) of a numeric value compared to other values in the same list. In other words, it tells you which value is the highest, the second highest, etc.

In a sorted list, the rank of a certain number would be its position. The RANK function in Excel can determine the rank starting with the largest value (as if sorted in descending order) or the smallest value (as if sorted in ascending order).

Ranking Examples
https://www.excel-easy.com/examples/rank.html

How Do I Decide ? Smart Cells; Summative Assessment

The Aga Khan Academies

Summative Assessment Guidelines on Unit - How Do I do?

Topic - Sustainable solutions to everyday life

Time: 2 lessons

_________________________________________________________________________

The following systems are some solutions to different problems.

1. Library Management System

2. Students Database Management System

3. Aka Mombasa, Tuck shop

4. Manage budgetary for year level party

5. Plan a birthday /  wedding budget.

6. Budget for Commons ( breakfast, lunch super)

________________________________________________________________________

UNIT – How do I decide?

Criterion A: Inquiring and analysing

Maximum: 8

Topic – Sustainable solutions to everyday life

Sustainability is about enabling all people whether in school, office and home to satisfy their basic needs and enjoy a better quality of life without compromising the quality of life.  Sustainability here in Design is to create something new or simply by re-designing what that already exists. It is the new way of thinking that need to be found and new systems based on these new ideas, have to be generated.

Challenge

Identify a problem faced by a client which requires the application, use of calculated values and presentation of the information in different formats for decision making. 

Your task therefore is to identify a problem that can be addressed or solved using an IT software that calculates values, and presents the information in a suitable formats for decision making. The problem should be clearly described and the client's current way of addressing the  situation described. The problem description should include the current  limitations the client is facing in relations to sustainability and detailed explanation of why you think an IT solution will be the best for this situation. 

Breaking the requirements for each strand;

i). Explain and justify the need for a solution to a problem for a specified client/target  audience: (Maximum of 2 pages)

• Have introduction to the unit by highlighting; Global Context, Key Concept, AK strand/s and Learner profile. Ensure that the introduction is link to the unit. 
• Explain the background of the problem facing the client/target audience, discuss this problem and how long it has persisted, show how it has affected the client and community, show how the client is in dire need for solution. Give examples of social challenges arising from this problem, show how an IT solution will be better placed to solve this problem and share the benefits to the client if the problem is solved.

Please note the TWO things to consider;

 a) Detailed background information of the current problem.
 b) Clear and to the point problem justification. Why you think IT solution is best suited for the problem.

           Make sure you identify and justify:

                a) What is the problem?

                b) Whose problem is it? ( identify the client/target audience)

                c) Where is the problem occurring? ( identify the situation)

                d) What is the cause of the problem? 

                e) What effect is the problem?
                     

          Grading 7-8: Section that relates to strand

           i. A detailed explanation and justification of the problem.

           ii.   identify and prioritize primary and secondary research needed to develop a solution to the problem: (Maximum of 2 Pages)

          ( clearly identify which sources are primary and secondary and demonstrate understanding of each)

- construct a detailed research plan which identifies and prioritizes the primary and secondary research needed to develop the solution to the problem. Show the what you need to research, how you will gather the info,(primary/secondary), when the task will be completed.

- follow the research plan to collect your detailed information from primary/secondary sources.

- Let your research question cover the business problem and the IT tools in detail.

- Independently generate 12+ detailed SMART and appropriate questions, which are clearly prioritized (Top 3 must be in a logical order) and identified as the specific type of primary and secondary research sources, to help develop the solution focused on:

❏- Client

❏ ‐ Time

❏ ‐ Resources

❏ ‐ Function

❏ ‐ Aesthetics

Sample (example) Strategy in responding to this strand
The section of the plan below will guide my investigation into understanding the solution for the problem.
   

Task	Priority	Importance	Sources	Completion Date
What unique excel functions are used extensively to increase productivity in organizations?	High	Understand the importance of using functions to increase efficiency for sustainability	Web	1/11/2018
What impacts do spreadsheet software have on the development of graphs?	High	Examining the impact of using graphs for data analysis	Web	3/11/2018

(Below are some potential areas of research based on the above plan)

HLOOKUP Function and its Importance


VLOOKUP Function and Its importance


Graphs generated Using Spreadsheets

 iii.   Analyse a range of existing products that inspire a solution to the problem: (maximum of 4 Pages)

           (have a clear analysis of exiting products IT tools and finished products which can solve the same problem)

           Discuss different IT tools and products; in each type show examples and how they work plus their images; you intend to use, in each categories show examples and how they  work plus their images, advantages and disadvantages. Their rating/statistical performance of the existing products other companies have used.

           Finally select one out of the list of tools e.g mobile app, excel puzzle and justify why it is the best solution than the rest for the problem, show the different types of your IT solution, e.g different excel mobile software and select one excel mobile software that you will use explaining how it work with supporting images  

- 4+ products are all analyzed in detail (excel mobile apps, excel puzzles and/or Parts, purposes, complexities thinking routines, etc..). Appropriate usage of subject specific vocabulary ‐ the elements of design ‐ Aesthetic and functional elements.

           iv).      Develop a detailed design brief, which summarizes the analysis of relevant research. (maximum of 2 Pages) ( produce a design brief that summarizes their research and then links it to the client/target audience)

- Write a detailed design brief that outlines, the client/target audience opinion, the experts opinion, and your personal opinion. Discuss the IT tools you will use, discuss the key features of the tool, specifications  and its benefits to the client based on your research.

- Your design brief should cover all relevant areas of your research and explaining in detail why you did not use IT tools (these) plus justifications and why you will use other tools and justifications.

- Write a summary of the collected research, with appropriate images, which tie together the findings from the student’s research and how it will affect their project. Include a coherent design brief (in paragraph form) that connects the clients’ needs, and how the student’s product intends to solve the problem and any potential constraints (such as time, materials, etc.). Guidance: 400 + words.

The design brief must highlight the following aspects of the students research
❏ ‐ Time
❏ ‐ Resources
❏ ‐ Environmental considerations
❏ ‐ Safety
❏ ‐ Function/Usability
❏ ‐ Aesthetics/Visual Communication
❏ ‐ Technical Skills

Bibliography should be using APA formatting. ( A maximum of 1 page)

Using APA Formatting, spelling, and grammar should be done.

- Your document should page numbered
- Appropriate diagrams can be used for the explanation in strand

Following Rubric helps to evaluate their work.

At the end of the unit, students should be able to:

i. Explain and justify the need for a solution to a problem

ii. State and prioritize the main points of research needed to develop a solution to the problem

iii. Describe the main features of one existing product that inspires a solution to the problem

iv. Present the main findings of relevant research.

Achievement Level	Level Descriptor
0	The student does not reach a standard described by any of the descriptors below.
1-2	The student:  i. states the need for a solution to a problem for a specified client/target audience. (Student explains the word sustainability in a paragraph and connects why sustainability is needed for his chosen solution. He also justifies that why he is doing his research on a given system and what made him to do.)  ii. develops a basic design brief, which states the findings of relevant research. (Student writes a paragraph on what kind of solution he/she is going to provide to the client, eg., An Excel software solution or a web page creation. Here, the student mentions the impact on environment (if any), and an awareness than the existing solution that are available in the market, off-the-shelf.)
3-4	The student: i. outlines the need for a solution to a problem for a specified client/target audience. ii. outlines a research plan, which identifies primary and secondary research needed to develop a solution to the problem, with some guidance. (Here, student need to create tables mentioning the Primary and Secondary research methods through which he acquired the required information to create his solution.) iii. analyses one existing product that inspires a solution to the problem (Here, student critically analyses the existing manual register / software and writes its drawbacks in order to have a sophisticated solution) iv. develops a design brief, which outlines the analysis of relevant research.
5-6	i. explains the need for a solution to a problem for a specified client/target audience. ii. constructs a research plan, which identifies and prioritizes primary and secondary research needed to develop a solution to the problem, with some guidance. iii. analyses a range of existing products that inspire a solution to the problem. iv. develops a design brief, which explains the analysis of relevant research.
7-8	The student: i. explains and justifies the need for a solution to a problem for a client/ target audience ii. constructs a detailed research plan, which identifies and prioritizes the primary and secondary research needed to develop a solution to the problem independently iii. analyses a range of existing products that inspire a solution to the problem in detail iv. develops a detailed design brief, which summarizes the analysis of relevant research.

Resources  
https://www.youtube.com/watch?v=IvW0kcajWKk

Introduction to Spreadsheet (Tutorial)
https://edu.gcfglobal.org/en/excel2016/getting-started-with-excel/1/


Spreadsheet Exercises
http://web.utk.edu/~dhouston/excel/exercise.html

How to make crossword puzzles using Excel
https://www.internet4classrooms.com/excel_puzzle.htm

http://eforexcel.com/wp/excel-quiz-7-crossword/

Sample Products
1. Hotel Excel booking
 https://www.onlinepclearning.com/excel-room-booking-system/

2. Tuckshop Budget Product
http://i-learnertuckshop.weebly.com/budget.html

3. Threatre Booking System
https://www.youtube.com/watch?v=D8q51d8Mbro

4. Creating A quiz
https://www.westernsydney.edu.au/tld/home/how_to/how-to_resources/excel_resources/create_a_quiz_in_excel

5. Creating Mobile apps using Excel
https://support.openasapp.net/hc/en-us/articles/207930855-Create-an-app-from-an-Excel-calculation

https://www.appsheet.com/apps-from-office-365-and-onedrive-for-business