HELLO. Welcome to the roughly-put-together, not-very-accurate instruction sheet for the math portfolio. Read if you need(: THANK YOU.

Ok

The contents of this entry will be as following:

1. Arrangement of the presentation table
2. Formulas for calculation (THIS IS EXTREMELY IMPORTANT. it is required in your final piece you hand up)
3. AND other miscellaneous stuff that you have to take note of.

WOOHOO.


1. Arrangement of the presentation table

a) Columns and headers

In case you were wondering what are columns, they are the vertical rows in a table. Headers are… well… the headers, ‘kay?

EXAMPLE TIME!!













(sorry... my camera's resolution sucks)

This (look up^) is a table. The purple row is the header and the cells highlighted in yellow (including the header… but because I can’t highlight it yellow and purple at once…) is a column.

b) The arrangement.

So basically, the headers for the first 4 columns will be default for everyone:
1. length of cuboid
2. width of cuboid
3. height of cuboid
4. volume of cuboid

MOVING ON.

The rest of the columns will be similar, except with different headings.

Example,

For the cylinder:

• radius of cylinder
• height of cylinder
• volume of cylinder

For the cube

• length of cube
• width of cube
• height of cube
• volume of cube


NB> always have the volume of the shape/object at the end of everything, like the cuboid (way above^) example.

c) Amount of columns you’ll need

You are supposed to have columns for every shape you have. At the very end, you are supposed to have the total volume, total mass and cost. The total mass and cost varies with the material you have decided to use.

ANOTHER EXAMPLE:












(Fill in the cost according to the portfolio instructions or whatever. Everyone has to do two materials so remember to repeat twice for both materials)*

*CORRECTION. THE TOTAL COST WILL REMAIN IN $/G. NO NEED TO CONVERT. THANKS(:

d) The PROPER way of keying in all your info

Now comes the harder part >_>

(This part needs a lot of reference to the formulas section.)

*Ahem* to key in all your info, you first need… your info!

Ok, fine. I’ll be serious-.-

This is how you are supposed to key in your info.

Take the base as an example (EXAMPLE PEOPLE!!!! Do not take this as an actual answer)

After doing the obvious, you start to type in all your details. Take my desired length of cuboid and width of cuboid to be 12 and 8 respectively.
You do not start with 12 cm in the length column and 8 cm in the width column.

…

Seriously. Don’t.


You do… this:

YEAP! You do that.

…

WHY? Because besides calculating your actual volume, mass, cost whatever, you have to give the marker (grader, teacher, whatever) a range of feasible volume, mass, cost and whatever. So you have to come up with a pattern on your own and apply it.

Geddit? No? RE-READ

Then you key the formula for adding a fixed value to the original number a.k.a =(column and row of the cell of the original number)+value you want to add
(Refer to the formulas section for examples)

Then you drag using the black, plus-like cross function and…

GASP A MIRACLE
Not really actually… it just that the formula is too cool (FORMULAS HAHAHAHAHA<33333)>

now you do the same to the other one...

Ta-daaa~

Got it? YAY.

Now, we calculate the volume~

For volume, we need to multiply the values of the different cells together. As a result, we use the formula for multiplying the values of different cells together (I know, I know =.=)


a.k.a =(column and row of the cell of the original number)*(column and row of the cell of the original number)*(column and row of the cell of the original number)
(Refer to the formulas section for examples)

This will definitely vary for different geometrical shapes. Go to the formulas to find out how to calculate pi.


OK! THE END FOR FIRST SECTION. at least all i can remember...

2. Formulas

Just several formulas you may find useful. Not all but enough (I think…)

Formula for adding a fixed value to the original number:

=(column and row of the cell of the original number)+value you want to add

Eg =C3+2

















Formula multiplying the values of different cells together:

=(column and row of the cell of the original number)*(column and row of the cell of the original number)*(column and row of the cell of the original number)

* equals times

So, this basically means this:

Eg =B3*C3*D3
















Formula for calculating pi:

=PI()*(cell number of radius)^2

PI is pi but in caps

^2 is square

Eg (for the volume of a cylinder) =(PI()*(F3)^2)*G3
















You can create formulas on your own with the symbols and calculate the volume of the shapes. Its really easy~(:

THE END



3. Other miscellaneous stuff that you have to take note of

-convert everything to 2 decimal places (at least that's what Mrs Fong recommends)

-Summary of symbols for Excel:
^= (to the) power (of___)
*= multiplication
PI= pi

-2 pieces of the final copy must be printed BUT one must be the one with the table and every thing whereas must be the one with all the formulas. for this, you need to press CTRL and the button with this ~ on it

Eg CTRL+~

YAY THE END HAVE FUN PPL HAPPY HOLIDAYSSSS

ps: can someone please revive this blog? it is SERIOUSLY DEAD=.= oh and also, if any part of this entry is wrong or inaccurate, please tell me or else everyone will be making the same mistakes

thanks~<3
jiaying~

HELLO. Welcome to the roughly-put-together, not-very-accurate instruction sheet for the math portfolio. Read if you need(: THANK YOU.

Ok

The contents of this entry will be as following:

1. Arrangement of the presentation table
2. Formulas for calculation (THIS IS EXTREMELY IMPORTANT. it is required in your final piece you hand up)
3. AND other miscellaneous stuff that you have to take note of.

WOOHOO.


1. Arrangement of the presentation table

a) Columns and headers

In case you were wondering what are columns, they are the vertical rows in a table. Headers are… well… the headers, ‘kay?

EXAMPLE TIME!!













(sorry... my camera's resolution sucks)

This (look up^) is a table. The purple row is the header and the cells highlighted in yellow (including the header… but because I can’t highlight it yellow and purple at once…) is a column.

b) The arrangement.

So basically, the headers for the first 4 columns will be default for everyone:
1. length of cuboid
2. width of cuboid
3. height of cuboid
4. volume of cuboid

MOVING ON.

The rest of the columns will be similar, except with different headings.

Example,

For the cylinder:

• radius of cylinder
• height of cylinder
• volume of cylinder

For the cube

• length of cube
• width of cube
• height of cube
• volume of cube


NB> always have the volume of the shape/object at the end of everything, like the cuboid (way above^) example.

c) Amount of columns you’ll need

You are supposed to have columns for every shape you have. At the very end, you are supposed to have the total volume, total mass and cost. The total mass and cost varies with the material you have decided to use.

ANOTHER EXAMPLE:












(Fill in the cost according to the portfolio instructions or whatever. Everyone has to do two materials so remember to repeat twice for both materials)*

*CORRECTION. THE TOTAL COST WILL REMAIN IN $/G. NO NEED TO CONVERT. THANKS(:

d) The PROPER way of keying in all your info

Now comes the harder part >_>

(This part needs a lot of reference to the formulas section.)

*Ahem* to key in all your info, you first need… your info!

Ok, fine. I’ll be serious-.-

This is how you are supposed to key in your info.

Take the base as an example (EXAMPLE PEOPLE!!!! Do not take this as an actual answer)

After doing the obvious, you start to type in all your details. Take my desired length of cuboid and width of cuboid to be 12 and 8 respectively.
You do not start with 12 cm in the length column and 8 cm in the width column.

…

Seriously. Don’t.


You do… this:

YEAP! You do that.

…

WHY? Because besides calculating your actual volume, mass, cost whatever, you have to give the marker (grader, teacher, whatever) a range of feasible volume, mass, cost and whatever. So you have to come up with a pattern on your own and apply it.

Geddit? No? RE-READ

Then you key the formula for adding a fixed value to the original number a.k.a =(column and row of the cell of the original number)+value you want to add
(Refer to the formulas section for examples)

Then you drag using the black, plus-like cross function and…

GASP A MIRACLE
Not really actually… it just that the formula is too cool (FORMULAS HAHAHAHAHA<33333)>

now you do the same to the other one...

Ta-daaa~

Got it? YAY.

Now, we calculate the volume~

For volume, we need to multiply the values of the different cells together. As a result, we use the formula for multiplying the values of different cells together (I know, I know =.=)


a.k.a =(column and row of the cell of the original number)*(column and row of the cell of the original number)*(column and row of the cell of the original number)
(Refer to the formulas section for examples)

This will definitely vary for different geometrical shapes. Go to the formulas to find out how to calculate pi.


OK! THE END FOR FIRST SECTION. at least all i can remember...

2. Formulas

Just several formulas you may find useful. Not all but enough (I think…)

Formula for adding a fixed value to the original number:

=(column and row of the cell of the original number)+value you want to add

Eg =C3+2

















Formula multiplying the values of different cells together:

=(column and row of the cell of the original number)*(column and row of the cell of the original number)*(column and row of the cell of the original number)

* equals times

So, this basically means this:

Eg =B3*C3*D3
















Formula for calculating pi:

=PI()*(cell number of radius)^2

PI is pi but in caps

^2 is square

Eg (for the volume of a cylinder) =(PI()*(F3)^2)*G3
















You can create formulas on your own with the symbols and calculate the volume of the shapes. Its really easy~(:

THE END



3. Other miscellaneous stuff that you have to take note of

-convert everything to 2 decimal places (at least that's what Mrs Fong recommends)

-Summary of symbols for Excel:
^= (to the) power (of___)
*= multiplication
PI= pi

-2 pieces of the final copy must be printed BUT one must be the one with the table and every thing whereas must be the one with all the formulas. for this, you need to press CTRL and the button with this ~ on it

Eg CTRL+~

YAY THE END HAVE FUN PPL HAPPY HOLIDAYSSSS

ps: can someone please revive this blog? it is SERIOUSLY DEAD=.= oh and also, if any part of this entry is wrong or inaccurate, please tell me or else everyone will be making the same mistakes

thanks~<3
jiaying~