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.
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.
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
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.
- 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.
- 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:
Post a Comment