Poem to our Teacher from Feeding minds Fighting hunger project Coordinator

 

To a man who is so really great
Its worthy of a day to celebrate
A man who is looking to change the world in every way
Oh Gioko you deserve a special day
a day of laughter
a day of fun
for all the work that you have done

So my dear friend I have to say
Have the most wonderful, fabulous day

Gives every minute of every day
Intelligence shines
Optimistic about changing the world
Knowledgeable
Outstanding in every way

HAPPY BIRTHDAY
HUGS, LYNN

Posted by Lynn Rosen Coordinator Feeding Minds Fighting Hunger Project

Modeling Challenge

Assessment Criterion PLAN

Charity Sweepstake

Your are supposes to design a model of determining the winner of the charity sweepstake
The numbers of the sweepstake are 10 numbers

9583726353

Design an model that will randomize the number in the sets of 1 2 3 4 1
That is first one number, second two numbers, third three numbers and the last number

9583726353

In the model develop.
20 trials at a go that is trial 1 to trial 20
Use conditional formatting put a condition such that when the wining number appears the cell turns green.
Use the F9 key and try to find out how long you will get the winning number.
Get the print screen of the winning condition.
How will you modify the design to achieve the results faster?
How many trials can fit on a single screen view at size 12 times roman?
Write a brief reflection of the process.

Print out all your work.

This work will be assessed on the Criterion Plan
See your Assessment Book for the aspects of the Criterion

BEST

TAKE HOME ASSIGNMENTS

Assessment Criterion DESIGN 
You are required to design a model of a toy manufacturing company

The toy uses plastic, metal, glass and paint

The ration of the material is decided by the manufacturer.

The cost of manufacturing one toy is 200 KSH for a toy between 200gms and 500gms

The cost of material is in kg

1 kg of Plastic 400 KSH

1 kg of Metal 1000 KSH

1 kg of Glass 600 KSH

I kg Paint 800 KSH

You can only purchase the material in 1 kg ONLY

If each toy has to weigh between 200 to 500gms and be sold at 500KSH

Design a model that will work out
-the ratios of the materials for the toy
-the combination of materials bought for the toys
-the break even point
Your model should give the BEST mixture ration of the materials
The BEST number of sales that will break even

Print out the spreadsheet and indicate in bold
Ratio
Metal: Plastic: Glass: Paint
Number of Cars Sold

TEST ON MODELLING

There will be a TEST on Thursday 6th May 2010.

The test will be on the creterion CREAT.

It will test your modelling skills and how you can apply them in determining a Goal Seek Scenario in a real life situation.

The task is 50 minutes long.

Put your skills into practice.

Welcome to the Month of MAY

My Reflection
Please reflection to find where you are (P) now in the understanding of modeling

Aspects	Expert	Proficient	Learning
My level of understanding
-the part of a spreadsheet
-How to enter formulas
-Using absolute formulas ( $D$2)
-Using the SUM function
-Using the * Function
-Using the + function
-Using the – function
-Entering details in the Header ( Name, class and date)
-Viewing a document with page break view
-Printing a document while repeating left columns
-Printing a document while repeating top columns
-Using Goal seek
-Determining the Breakeven point of a business model
-Determining the Actual Breakeven value in a business model

Write a brief reflection on your experiences in modelling (150 Words)


For the level that you are not expert
-Try to do more practice
-find out more information from your peers
-Consult your Teacher
This week we shall be working on LESSON 4 in the Workbook
Please make sure you have visited IERAN: Product in the Box project and introduced your self
Name:
The resource you are exploring:
And a brief summary on why you think exploring that resource is important