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.