More excel . . ?

We just finished our, hopefully, last test on excel. It was pretty easy, for the most part. I'm not absolutely sure if were finished with excel or not, but i sure enjoyed learning so much about excel. On Friday we didn't have class, because basically everyone went home at lunch. So our class will start again on the Monday we come back.

Have a Happy holiday, and Merry Christmas and Hanuka and anything else. (sorry i don't know much about the holidays :D )

Bye .

Getting to know the Wiki.

Knowing what you are working with is very important. For example, you need to be familiar with all the programs Mr.Case shows us. That's why we have test, so that the teacher can see how much you know about your programs, and of course to torture us but anyways.
Today Mr.Case went over some basic things you should be familiar with on the school wiki. Like for example, how to keep your own online agenda that you can access anywhere in the world. Its easier than paper and pencil because you never know what can happen, you can misplace it or lose it. The Tiki is your own place. You can make your profile the way you want people to view it, have friends, contacts, send others email and so much more. The wiki, however, is a place for everyone in the class, and whoever has access to the wiki. Its where everyone can see what you are doing, and they can edit pages and so much more.
Wiki come from the Hawaiian word community.
And an F.Y.I Mr.Case pays much attention to the forums because it shows leadership and initiative, so that's one way of getting good marks!

That's all for now.

Peggy.

A WEIBULL is a . . . ?

Today in class we spent most our time reviewing for the test we're going to have on Wednesday on excel. This is a really big test so study hard for it. The best way to study is to just go into excel and play around with the different functions until you get the hang of them. But remember, there are always different ways of doing something, so try finding the different ways. Also, another way to get good marks is to, of course, listen to Mr.Case in class, because in between his explanations, he gives out little tips that are going to be or could be on the test.
Here are just some of the things that could be on the test. You need to know the basic formulas, like Sum, division, average, count etc. These are called functions. The difference between a function and a formula is that a formula is what you use to come up with the answer to a question. There could be many functions in a formula for example adding, subtracting and multiplying could be functions of a formula. <- * that could be a question on the test. * There are other tricks that Mr.Case pointed out to us like the OVR button on the bottom right hand corner of your page. You can double-click it or press the insert button and it will turn on. That makes your text overlap each other when you are typing and the word you wrote before will be erased and the new word will take its place.

Here's a trick question, that could just be a bonus question on the test: Whats a Weibull ?

Good luck on the test.!

Peggy.

sales parson ?!

Today in class we had a new assignment. We had to pretend like we are a salesperson. We opened excel and created a spreadsheet with the following items: Item number. Item name. Wholesaleprice. Retail price. Tax. Total.
We had to come up with 15 different things we wanted to sell and come up with a number for each column. Then we had to add it up and see how much we would get in total when we were selling our products with tax. Tax is 13%.
Then when your done, you have to go to a site and practise your skills in excel. There will be a test on it this week so study !!

Later days.

Peggy

Are you breaking any laws ?

Today in class we learned a little about laws and regulations about copyright laws for podcasting. To be honest I don't know what its completely about because it was so long it made me tired just looking at it, but what it was basically about was about all the rules there are about making your own podcast. You need to be very careful when your making a podcast so that you don't break those rules because if you make the smallest mistake on your podcast and someone finds out, you can get sued so be careful! Also if you break one little rule and Mr.Case finds out, your going to have to do your podcast all over again!!
This article is about all the rules that need to be followed in order for you to not get sued. If you want to take images, songs, interviews, and pretty much anything, you have to be hundred percent sure that its not copyrighted or else the person can sue you. If you do happen to come across something you want and its copyrighted then you need to contact that person and ask for permission, and that requires a lot of work, so I think its better to just not use anything off the Internet. try making it yourself, it'll be original and that way, no one can sue you!

That's it for now.

See you.

Peggy.

Here comes the worst part of report cards. .

Getting the sad realization that you didn't do so well on your report card as you were hoping, is bad enough, but having to calculate your marks after it is even worse! You sit there and wonder how you can make up your marks for second and third term so you can reach your goals successfully. Well here's an easy way you can do that. Today we learned how to calculate our average for first term, what our goals are for third term and what grades we need to get to achieve our goal for term three. Excel is easy, if you know what you want to figure out. For example, today we learned to do things backwards. So we have an answer but we want to find out the question. Chose three columns, and at the top of each one write your term. (Term one, term two, term three.) Write your subjects in a column before your term one column. In that, going down, write all your subjects. Since you know all your subjects for term one, write them in. Now make a new column right after term three and in the heading write 'Goals'. In there, write all the marks you'd like to get for term three, and keep them realistic! Using a formula, you take the mark of your goals for the first subject [eg. F4 ] and multiply that by three. Subtract that from your term one mark and what ever you have left, divide it by two. And that will give you the mark you need for term two in order to achieve your goal. Now the great thing about excel is that once you've got a formula in one column, you can simply drag the number in your first row down and it will automatically calculate the marks you need for your other subjects. The easy thing about excel is that because you have used a formula, if you make a mistake or you want to change your marks, you can change one thing and excel automatically changes everything for you. After all that hard work, you want to check if your formula is correct, what you can do is make a dummy row at the bottom and drag your first number down (with the formula) because once you have a formula for one number, you can drag it and the formula will stay the same for everything else in that column. So drag it down, and if you get 100 in each row, you know you have done it right!

That's a lot to take in but once you get the hang of it, its pretty easy. So give it a shot and see what marks you need to get in order to achieve your goals!

Have fun !.

Peggy .

Tutorial. . .

Today in class, we got introduced to a new site. We have to go to http://movies.atomiclearning.com/k12/home and search for excel. Once we did that, we had to chose from a list of excel videos that people made. Each of them was a quick but helpful video on the different functions of excel.
We also had to ask our parents about out family budget on the weekend so that now we can make a spreadsheet on our budget so that we can get a slight idea on the amount of money our parents spend in a month.

our assignment: make a spreadsheet about your family budget. Try making it as realistic as possible. It doesn't necessarily have to be about your family budget. Also say how many people are in that family.

Byeee .

Peggy