Monday, October 22, 2018

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

No comments: