Next Steps

Today 7^th Thursday to 11^th Monday –Work on the Plan Summative

 

12^th Tuesday – Submit Summative before going into class

12^th Tuesday –Start Create Summative

13^th Wednesday –Continue with Create summative in class

14^th Thursday – Continue with Create summative in class

19^th Tuesday –Continue with Create in class

20^th Wednesday –Continue with Create in class

21^st Thursday –Continue with Create in class

26^th Hand in Create before entering the class

26^th Start Evaluate

27^th Complete evaluate

28^th Complete a 5 minutes presentation on the project.

 

All the best

 

 

 

Plan Stage: Summative

 

 

 

Based on your problem identified in investigate stage for the budget problem in organizing a big event, develop a plan to be followed from the beginning to the end of the product realization.

You plan should have exactly three pages used.

· Page 1 will have the Basic plan or a Gantt chart

· Page 2 will have a logical product process details which includes;

§         Description of activities and techniques/ skills to be used

§         Duration for each stage

§         The resources to be used in each stage

· Page 3 will use half the page to evaluate the plan. Evaluating the plans involves

§         Describing if the time and resources assigned for each step was appropriate. If “yes” provide examples from plan to support that. If “No” suggest what you will do.

§         Suggest some changes that you will make for your design.

Plan Checklist

o   I have developed a clear basic plan or a Gantt chart with all the required details.

 

o   I have included a process plan describing the activities with skills/techniques, duration, resources and dates for each step.

 

o   I have evaluated my plan by sharing how appropriate time and resources are in my plan.

 

Assessment Criteria

0	Has not reached standard of any descriptors below.
1-2	The student produces a Gantt / basic plan, and a plan that contains some details of the steps and/or the resources required.
3-4	The student produces a basic plan/Gantt and a plan that contains a number of clear steps that include resources and time. The student tries to evaluate the plan.
5-6	The student produces a basic plan/Gantt and a plan that contains a number of very clear steps that describe the use of resources and time. The student evaluates the plan and suggests some changes the design.

 

Plan formative

Plan the product/ solution

-devise, with guidance, a series of logical steps to create the product/solution

-construct a plan to create the product/solution that makes effective use of resources and time

-analyse the plan and explain the need for any modifications to the design.

 

Information

James wants to create a spreadsheet file which will show his expenses. He has five days do to so and he need to check out with his mum how much money the mother will send. Once the mother tells him the amount he will develop a budget on the items that he needs to get. He already has a list of items and their pictures which he downloaded from the internet. After having all the items in the budget he will adjust it to see what combination of item he will get the best value of. He will then present the budget to the mother to negotiate for money if the money is above the requirements. He will need a computer, a phone to call shops for prices and communicate to the mother, internet to send the spreadsheet home and a colour printer for printing his spreadsheet with pictures of what he wants to buy and a graph showing the prices of eth items and another graph showing the amount of the items to be bought. James has Tuesday 5^th to Sunday 10^th to complete this work. He is also attending classes so he has only the study time to do this work.

 

Activity

-Device a series of logical steps to create the spreadsheet.

-Construct a plan for the spreadsheet that will make effective use of the resources and time.

-Analysed the plan and make suggestion for any modification.

 

Plan.

Time (Date and Hours)	Who (People involved)	What (Activity)	With What (Material used and their quality)

 

 

Gant Chart ( How to make a Gantt Chart) What the process, 2007 2003

Plan Analysis (Review the plan and share any modification needed)

____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

 

Assess your plan using the criteria

Score	Plan
5-6	* Produces a step by step plan that contains a number of understandable steps. * A time line is present with the scale clearly marked .( Gantt chart ) * A list of material /software/hardware requirements with the quantity required is given.
3-4	* Produces a step by step plan that contains some understandable steps. * A time line is present (Gantt chart) necessary markings missing. * A list of material /software/hardware requirements given.
3-4	* Step by step plan lack necessary details. * An attempt to make a time line. *  A list of some of the materials/software/hardware  requirements  given
1-2	No evidence of achievement

Score your work using the above criteria.

My Score	Reasons for the Score

Date  DD/MM/YYYY  Signature ________________

 

 

Give your friend your work to score

 

My Friends  Score	My friends Reasons for the Score

Date  DD/MM/YYYY  Signature _________________

 

 

 

Design Summative

You must have enjoyed the design process.

 

The weather Charts, Graphs, Graphics  and use of formulas.

 

The linked cells and Conditional formatted cells

 

The search of different types of phones to match the prices.

The search of prices the match the model given.

All these formative activities were to prepare you for the design process.

 

You did two designed and analyzed each against the design specs.

 

You finally selected one and Justified why you though this was the best.

 

Now is the time to apply the skills to you project.

 

The Design Summative will be used to guide the process.

 

 

 

 

Design Formative Activity 2

 

Develop two colorful designs using a spreadsheet to prepare a report for a mobile shop that sold the following products in December 2012.

20 Nokia Model 1* each @ 45000

15 Nokia Model 2* each @ 65000

16 Samsung Galaxy each @*

12 Samsung model 2* each@*

7 iphone model 1* each@*

8 iphone model 2* each@*

34 Idios  each @ *

2000 Safaricom 1000 credit

4000  Safaricom 500 Credit

1000 Airtel 1000 credit

4000 Airtel 500 Credit

* indicates that you search for prices or the models.

Each design should be appealing and showing important information.

The design should not be limited to the following

¨    Images of phone

¨    Borders

¨    Coloring of fonts and shading or background

¨    Sorting using a column of choice

¨    A graph for particular information

Orientation of text etc

.

 

Design Formative Activity 1

a)    The data in the table below can be represented in a spreadsheet in different ways;

Visit http://www.yr.no/place/Kenya/Coast/Mombasa/statistics.html and use the data to generate the two graphs as shown in the website.

Tabular view for temperature and precipitation per month
	Temperature			Precipitation
Months	Normal	Warmest	Coldest	Normal
January	27.6°C	33.2°C	22.0°C	3
February	28.1°C	33.7°C	22.5°C	1
March	28.3°C	33.7°C	22.9°C	5
April	27.6°C	32.5°C	22.7°C	10
May	26.2°C	30.9°C	21.6°C	14
June	24.8°C	29.4°C	20.1°C	10
July	24.0°C	28.7°C	19.3°C	10
August	24.0°C	28.8°C	19.3°C	8
September	24.7°C	29.7°C	19.7°C	9
October	25.7°C	30.5°C	20.9°C	9
November	26.9°C	31.6°C	22.1°C	8
December	27.4°C	32.8°C	22.0°C	7

 

                                                  i)  Shade each column to have different colors for fonts and background

                                                ii)  Identify the appropriate position to show the averages readings for each column

                                               iii)  Insert an appropriate image in the background for the above data

                                             iv)  Change the orientations for the months to  slant

                                               v)  Sort the data using normal temperature in ascending order.

                                             vi)  Position one chart to the left and the other to the right of the table.

b)    The data in the table above can be captured in a different way (different design) Use the spreadsheet software to demonstrate how the above data can be captured differently.  Change the processes I) to v) in this design.

Between design A and design B which one do you think presents the information better and why?

 

 

Design Stage: Smart Cells.

 

In this stage you will be expected to come up with some designs that measure up with design specification. You will compare each design against the design specification and then select one design and explain why that is the best choice.

 

There are different designs or ways of capturing data in a spreadsheet

Different designs will capture the following differently

¨    Graphs

¨    Formulas used

¨    Shading

¨    Images

¨    Autoshapes used

¨    Links

¨    Orientation of text

¨    sorting

 

 

INVESTIGATE SUMMATIVE FINAL

Investigate final touches.

 

During the lesson today we are doing our final touches on INCESTIGATE SUMMATIVE.

 

Please note the Summative must be handed in on HARD COPY @ 11.10 on Thursday 17 January 2012

 

Use the checklist to ensure that you have addressed all the points

 

CT project information Guide

As we undertake our project we have so many questions to ask.

Here is some project information guide which might be useful.

 For each stage Attach the Check List at the end and tick what you have done.

Investigate Summative

Click on  workbook to get the summative workbook.