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.

Year 2013

Thursday Lesson 4

Activity 6 (Investigate stage formative)

BIRTHDAY PARTY PLANNING

Problem: Fatima a 13 year old girl is planning for a birthday party and she has to make several decision on how she will spend the money she is given. She have 5000/- and She is not sure of the number of friends to invite because she have so many. She has an idea of what she could buy but she does not know the amount of the items she could buy. The number of friends and the things and amount of item she could invite and buy respectively depends on the amount of money she is given. Fatima is in a DILEMMA. Fatima has approached YOU because she has heard that you are taking computing technology. She knows technology could be used to help her out in this dilemma.

Problem description: (Describe in one paragraph the problem stated in points above)

Client: Who is your Client?

Design brief: (What will you need to solve the problem above? And why?

Use your workbook to respond to the questions.

Wednesday Lesson 6

Activity 5 -MYP CT Workbook

There are terminologies used when working with spreadsheets the following link can be used as a reference to the definitions of the terms. Fill in the table in the workbook with the definition and use activity 4 to show examples where possible. (Link- http://people.usd.edu/~bwjames/tut/excel/3.html)

Tuesday Lesson 6

What do we know about Smart Cells

We shall be going through an assessment on smart Cell.
To check what we know about smart cells and who can use smart cells.
Be ready?
Can you do it in 50 minutes.

Let us see.