Today's Slides: November 28
|
| 0
comments
Showing posts with label Spreadsheets. Show all posts
Showing posts with label Spreadsheets. Show all posts
Wednesday, November 28, 2007
Thursday, November 22, 2007
BLOGGING ON BLOGGING
What I learned in this unit was that spreadsheets is an easy way to use formulas, and organize numbers. I learned that spreadsheets have labels and different types of values. Not only could we put numbersand the different equations but also, we can use Formulas to resolveeach cell. I also learned different types of math tricks in mental mathsuch as when a number is multiplied by 9 you use an easier trick by comparing it by 10.
Examples For Forumlas :
=SUM (B4*B5)
=AVERAGE (D6*D7)
|
| 4
comments
Wednesday, November 21, 2007
[ ! ] BLOGGING ON BLOGGING
I thought that our last unit on spreadsheets was fairly simple. I was absent the day our class started the unit, so the next day when we were doing our mental math about spreadsheets, i was lost. After we reviewed the answers, i understood almost every concept. You don't need to know much about spreadsheets, to know how to do one. All you need to know, basically, is what a label is, what a formula is, and what a value is.
A label usually consists of ONLY letters in a cell. A formula is an equation beginning with an equal sign (very important), and a value is content in a cell that consists of nothing other than numbers. Along with this, you're also going to have to know how to identify cells. Cells are the little boxes that make up the spreadsheet.
Along the top of the spreadsheets are letters of the alphabet, and along the left-hand side are numbers. The proper way to identify a cell is to first find the column in which the cell is in, go all the way to the top, and remember the letter. Then find the row in which the cell is located, go all the way to the left, and remember the number. Then put the two together; letter first, number comes after.
Using the spreadsheet above as a reference, this is how you'd determine which cell it is. The highlighted box is under the "B" column, and located in the "2" row, therefore it is cell "B2".
When you know which cell you're supposed to put content in, then its pretty straight forward. If you're typing in a label, you should type NOTHING other than letters or words, with the acception of dates and such. If you're typing in a formula, letters and numbers are allowed, but you MUST remember to place an equal sign (=) before it, or it won't work the way it should. If you were to type in a value, there should be NOTHING but numbers in that cell.
When you put a label into your spreadsheet, it should automatically align to the left of the cell, unless it is further formatted. Opposite of labels, values are automatically aligned to the right of the cell, again, unless it is further formatted. Formulas are similar to labels, they are aligned to the left, and then automatically calculated to show the answer. You'll find that when you type the formula in, the answer will show up in the cell, but in the textbox, the formula is still there.
Speaking of formulas, there are a variety of formulas that are already there for you to use. You can find them all listed under the 'formulas' tab just along the top of the actual spreadsheet. Not all spreadsheet programs are the same, so you might have to search for a button that says 'formulas'. Formulas make spreadsheets all the more easier to work with, because it does all you're calculations for you automatically, the only thing you have to do is make sure the formula that you put in is correct, and that you didn't leave out the equal sign.
Examples of commonly used formulas are:
[ & ] = SUM(A2:G2) , OR , = SUM(A2+B2+C2+D2+E2+F2+G2)
... .... > to add cell values together .
[ & ] = A2*B2
..... .. > to multiply two cells together .
[ & ] = SUM(A2:A7)/2
... .... > to add multiple cells together , then divide by two .
[ & ] = AVERAGE(C2:C9)
....... > to find the average of multiple cells .
Spreadsheets are a good way to keep track of everything, especially when it comes to banking. Its easy to understand, quick to do, simple to access, and a big plus, no paper work OR self calculating!
[ ! ] GOOD LUCK ON THE TEST :)
|
| 4
comments
Blogging on Blogging
In our last lesson, i learn a lot of things about spreadsheets. I dont know before how do spreadsheet but thanks to Mr. Kuropatwa, i know now how to make an spreadsheet on my own.
Spreadsheet contains a LABELS and VALUES. Before we put anything in the spreadsheet, we must first READ and FOLLOW the directions carefully because if we dont, everything will be mess up. And if we want to put a formula, always remember that always put an EQUAL SIGN because if we dont, the answer not gonna show up. For example, =sum(A2,A3),we can do this too, =A2+A3, this formula are both the same.
About the tricks too in mental math like how to solve 9 multiply into other number like 42. There's an easy way to solve this without using a calculator. this is how it is,
9x42=378
instead we multiply 9 to 42, we multiply 42 to 10 because 9 is close to 10 and 10 is easy to multiply to 42, just put zero after the number 42 then we get 420
10x42=420
then, we subtract 420 to 42 because we only need nine 42 and we multiply it in 10 so we must take one 42 in 420 and we get 387, and that's the answer.
420-42= 378
Its amazing that we are learning this unit because some other young teenager like us dont go to school. So dont waste time, learning everything makes a big changes in our life.
Goodluck in the test,,,,,
|
| 4
comments
Blogging on Blogging
For the past few weeks, we've been learning about spreadsheets. There are different kinds of spreadsheets and they all work differently. It is very important that you follow the instructions carefully, otherwise you won't get the answer you want.
We learned that a cell can contain a label, value, or formula.
A cell that contains words is called a label.
A cell that contains numbers is called a value.
In order for it to be considered a formula, it MUST include an = sign (equal sign).
Some of you may have found this unit pretty easy, while the others found it pretty difficult. However, don't forget to STUDY for the math test tomorrow! Goodluck everyone.
|
| 2
comments
Blogging on Blogging
It's Jaaaaaaames
In this section of Math, I found quite a lot of things interesting. However, one thing that stayed with me, was the trick of multiplying by 9. It helped me in a lot of places.
Step 1: Look at the equation. 14 x 9 = ?
Step 2: To multiply them together, multiply by 10. (Which is much easier) 14 x 10 = ?
Step 3: Solve the equation with the 10. 14 x 10 = 140
Step 4: Take the product and minus ONE of the numbers you used in the equation (NOT the 9 or 10). You want to do this, because you wanted 9 groups of that number, NOT 10. 140 - 14 = ?
Step 5: Solve the equation, once again. 140 - 14 = 126
Step 6: Dance around in circles, because you are done!
That is what I think helped me the most in this part of Math. Remember to study! You don't want to become some poor bum on the street, begging for money or trying to buy underwear, because you don't have any. A healthy mind, is a good mind!
|
| 9
comments
Blogging on Blogging =)
Hello, Its me Joyce.
During this past few weeks I have learned alot about spreadsheets and the different kinds of spreadsheets I never knew before.
When doing spreadsheets you always have to read the directions very carefully. If you don't, it won't work.
When you type in a formula, we always have to have an "=" sign (equal sign). If there isn't a equal sign, IT ISN'T A FORMULA, it would be called a value.
A Label is a cell with words and a Value is a cell with numbers.
We looked at google spreadsheets and pbwiki spreadsheets.
This is what I learned in this unit =)
Good Luck on the test everyone =) and take your time =)
Always Smile,
Joyce
|
| 2
comments
Blogging On Blogging
This is my Blogging on Blogging. during this past month i had learn So many things that i never even thought about. Like a new way of multiplying. In stead of......Pressing on your caclulator 34x36=1224 u can do it this way..
Example: take the two numbers that are the same from each digit. Witch is 3. Add one of them to make it turn to 4. so now you have 3x4 now multiply that together to get 12. then you take the 4 and the 6 that was left over then multiply that together and you get 24. So now you got the answer to the multiplication question. Its 1224 =D
34x36
3 x add one to the three = 4
3 x 4= 12
take the left overs
4 x 6 = 24
Now put it together
1224 =D
That was a new multiplication problem that i learn in Class and theres lots more.
In our current assignment spreadsheets. I learned that this symbol ( ^ ) was Exponent on the keyboard and this( * ) was Multiplication and( / )was Division. Well good luck to everyone on the spreadsheets test and hope you all do well. :D
|
| 2
comments
Monday, November 19, 2007
Spreadsheets Assignment 6 - The Multiplication Table
Hand in your assignment here by adding a comment to this post. Your comment should include your name (first name only) and a link to your page on the class wiki where you created your multiplication table using the spreadsheet built in to pbwiki.
This is a bonus marks assignment. Only PERFECT assignments will receive any marks.
Photo credit: Multiplication Table
|
| 14
comments
Thursday, November 15, 2007
November 15, 2007 Scribe Post.
What we learned in class today, was how to use some techniques in Spreadsheets. It's interesting because the spreadsheets that we used was a lot different from the other spreadsheets we usually use. I also learned how to make a new page on http://cm20sf07.pbwiki.com; Not only do we have our own page as a class, but we also could put our assignments, and we can make our own spreadsheets. We may edit it and publish it so other people may see it. I also learned how to get answers on using basic Formulas to figure out the result of an equation more easily.
For example:
= Sum (B3:D3)
=Average (A1:A11)
*The next scribe will be Melchor.
|
| 6
comments
Wednesday, November 14, 2007
In Our class ,we do mental math. Mr.K Gave us a 10 Question to answer. each Question is all about the spreadsheet Except a and 10.Mr.K taught us how to use the BEDMAS some of us know how to use the BEDMAS and some are not for example =4+8*2=20 This is how the answer got.
we should do first multiplication lot stead of addition Because Division or multiplication must be done first before addition division or subtraction.
But if the Question is written in this way =(4=8)2=24
always remember that we should add first the number inside the column before multiply it.
The next scribe is BatangX
|
| 4
comments
Tuesday, November 13, 2007
Scribe post, November 13, 2007.
Our class started off with 10 mental math questions as usual. Mr. Kuropatwa tried to explain how to answer the questions while we were marking our papers, because a few students had a little difficulty coming up with solutions. The first question was tricky; it asked us what would appear in the spreadsheet cell if "8*2" was in it. Some students made the mistake of multiplying it together. You'd actually put "8*2" in the cell, because the result of the equation doesn't appear unless the formula has an = before it.
After correcting our mental math sheets, the class headed to the maclab to do some work online. Due to the bad connection, we just ended up doing our homework in the yellow booklets we were given.
HOMEWORK:
+ Page 151 # 1-2
+ Page 163 # 1-2 & 4-7
+ Page 173 # 1-3
+ assignments 1-4 online: http://cm20sf07.pbwiki.com/
> The next scribe will be Jay.
|
| 3
comments
Monday, November 12, 2007
Scribe Post - November 12, 2007
Today in class, we began by talking about the lockdown drill that took place this morning. Although it's not part of math, it is still very important. Other than that, we did our daily mental math and I believe that many of us were having difficulties with the problems. Most of us were confused about multiplying the percents with another number. It would be easier if you just find the percent of the number, rather than multiplying them. The answer would still be correct if you multiply both the number and the percent. Why? The thing is, you divide by 100 because the percent symbol means to divide by 100. Here is an example:
25% x 68
50% of 68 = 34
25 % of 68 = 17
OR
25% x 68 = 1700%
1700% / 100% = 17
We also did a quiz, which wasn't too hard. Still, many of us had some problems here and there. The next scribe will be Maximo.
|
| 5
comments
Spreadsheets Assignment 4
In the comments below this post leave your name and a link to your Spreadsheet Assignment 4 published online. Just so you understand the math behind how all this works:
No Name = No Marks
and
No Link = No Marks
|
| 18
comments
Friday, November 9, 2007
Scribe post, November 9, 2007.
Today's class began with our daily Mental math. The questions were almost like a review of what we already knew about Spread sheets. We were given a little over 5 minutes to answer all the questions to the best of our ability, then we exchanged our papers and corrected them as a class.
After handing in our papers to Mr. Kuropatwa, we went to the lab to work on our spread sheet assignments. There are 9 different assignments posted on the site http://cm20sf07.pbwiki.com/. You can also find this link on the last page of yesterday's slides. Each assignment has its own site, be sure to put your link on the right page.
When you've completed the assigment:
1) Make a final save.
2) Publish your work.
3) Get the link to your work.
4) Comment on the correct class blog
5) Include your link and your name in your comment.
* YOUR NAME IS IMPORTANT! No name, no marks.
[ ! ] The next scribe will be Tina.
|
| 0
comments
Thursday, November 8, 2007
Scribe, November 8, 2007
Today, we did some mental math. Then we headed to the mac lab and did our first spreadsheet/first assignment.
Whats important in spreadsheets is that you have to follow the directions very carefully, using the addresses like for example, C3 .
Today for our assignment we had to copy what was on the spreadsheet and then we clicked the link that brings us to a written part of our assignment, which we had to follow carefully.
If one 'value', 'label', or 'formula' isn't placed correctly, everything will be messed up.
=) There isn't much we did.
The next scribe will be, Deaarly.
|
| 3
comments
Subscribe to:
Posts (Atom)
