Today the teacher taught us how to colour the cells in our assignment. On Microsoft Excel 2007 you could just highlight the cells you want to colour than you just go to the home button and the colour button choose your colour and click apply, so that the backgrounds of the cell will change. You can also change the colour of the words, its beside the background colour button with the letter A and the colour under it change the colour if you want but if your background is black then change it so you can see. Another way to change the background in Microsoft Excel 2007 is go to Home than go to cell style than choose a style to make the background of you cells.
Cell Style (Microsoft Excel 2007):
Home, Styles, Cell styles
Colour Backgrounds (Microsoft Excel 2007):
Home, Font, Fill colour
Colour font (Microsoft Excel 2007):
Home, Font Font colour
These are the steps to colour cells with colour styles, you can also add a pictures as backgrounds but I don't suggest you do it because you have to cite it but if you want to know here it is:
Picture Background: (Microsoft Excel 2007):
Page Layout, Page Setup, Background, Choose the picture.
Beware this is a repeat background, and it may look horrible, but it is just for me to know.
To remove or put you value into the decimal point you want it you click on the cell and you can do one of the following:
Removing Decimal places (Microsoft Excel 2007):
1. Home, Number, Decrease Decimal (Be warned it goes 1 by 1 so it may take a long time to remove continuous decimals, you can also add decimal place by clicking on Increase Decimal instead.
2. Home, Cell, Format, Format Cell, Number, Select decimal places
3. Right mouse button, Format Cell, Number, Select decimal places
4. Crtl 1, Number Select decimal places
Any of these ways are fine but I like number 4 because it is the fastest way.
Wednesday, November 28, 2007
Report Cards with Excell
On Tuesday November 27 2007, we were supoosed to bring our report cards which we got on Monday to the computer class. We are supposed to put our marks on Microsoft Excel. We had the rows stating the courses, and the columns having marks in term, % out of the year, and a column for our goals. We are supposed to write out goals in the goals column and then we are supposed to imput the marks we got on the first term then we divided it by 0.23 for each course to get how much that mark is worth for the year, this is because each term is worth 23% and the sumative is worth 30%, Together you will get 100%. After finding out how much your first term marks were worth out of the year you subtract it from your goals. Since your goals to you is 100% you could do it in two ways. The first way is what I prefer most, you divide you goals by 100 to get the amount for 1 precent and then multiply it along the way byt 23.3 or 30. The second way is Finsh subtracting it and then divide by 76.6 because that is how much % it is after subtracting that 23.3% from your goals to get how much 1 precent is, then multiply by 23.3 to get the marks out of the year. After doing this you multiply divide the amount of marks during the year by 0.23 and then that is the mark you need to get in the 2nd term term to get to your goals. For your 3rd term it is the same as your 2nd term but you divide it by 53.3 after subtracting the marks out of the year from the goals, and then you follow the steps. For the summative it is a little different. You subtract all three terms from goals and what ever is left that is the how much the summative is out of in the year. Then you divide that by 0.3 to get the marks you need to get on the summatives at the end of the year.
Formulas for the marks:
Goals: Remember to right down your goals.
Term 1
First term: Write down the marks you got on first term
Out of the year: To figure out how much does first term wroth out of the year it is very simple, you just multiply it by 0.23 and you will get how much is your mark worth for your yearly mark.
Formulas:
1.=(Term 1 mark for course)*0.23
Term 2
Out of the year: To figure out second term marks you need to find how much marks is the marks that you will get in term 2 worth in the year. To find this out without the term 2 marks it is simpls, divide you goal by 100 and then multiply it by 23.3 or you can subtract the term 1 out of the year marks from the goal and, divide it by 76.6 becuase that is how much percent it is out of the goal, to find 1 % and then multiply it by 23.3.
Formulas:
1.=(Goal/100)*23.3
2.=((Goal-Term 1 yearly mark)/76.6)*23.3
Second term: To find this divide the out of year marks by 0.23, and you will get the marks you will need to get in term 2 to reach your goal.
Fomulas:
1.=(Term 2 yearly mark/0.23)
Term 3
Out of year: To find this it is same for the term 2 but this time you subtract term 2 yearly marks aswell from the goal then divide it by 53.3 to find out how much is 1 % then multiply it by 23.3 if your doing it the hard way. If you are doing it the easy way do the same as term 2.
Formulas:
1.=(Goal/100)*23.3
2.=((Goal-Term 1 yearly mark- Term 2 yearly mark)/53.3)*23.3
Third term: To find this you just divide term three out of yearly marks by 0.23 to get the marks you need to get in each course for term three to reach your goals
Formulas:
1.=(Term 3 yearly mark/0.23)
Summative
Out of yearly: To find this you subtract all three terms from the goal, then divide by 30 to get 1% than multiply by 30 to get the out of year marks for the summative or whatever is left is the marks in the summative this is the hard way. Or you can just divide the goals by 100 than multiply this by 30.
Formulas:
1. (goal/100)*30
2. ((Goal-All three terms)/30)*30
3. (Goal-All three terms) take the answer as the out of year mark for summative
Summative: You divide out of year mark by 0.3 to get the amount of marks you need to get on the summative to reach your goal.
This is the formulas for this assighnment.
Formulas for the marks:
Goals: Remember to right down your goals.
Term 1
First term: Write down the marks you got on first term
Out of the year: To figure out how much does first term wroth out of the year it is very simple, you just multiply it by 0.23 and you will get how much is your mark worth for your yearly mark.
Formulas:
1.=(Term 1 mark for course)*0.23
Term 2
Out of the year: To figure out second term marks you need to find how much marks is the marks that you will get in term 2 worth in the year. To find this out without the term 2 marks it is simpls, divide you goal by 100 and then multiply it by 23.3 or you can subtract the term 1 out of the year marks from the goal and, divide it by 76.6 becuase that is how much percent it is out of the goal, to find 1 % and then multiply it by 23.3.
Formulas:
1.=(Goal/100)*23.3
2.=((Goal-Term 1 yearly mark)/76.6)*23.3
Second term: To find this divide the out of year marks by 0.23, and you will get the marks you will need to get in term 2 to reach your goal.
Fomulas:
1.=(Term 2 yearly mark/0.23)
Term 3
Out of year: To find this it is same for the term 2 but this time you subtract term 2 yearly marks aswell from the goal then divide it by 53.3 to find out how much is 1 % then multiply it by 23.3 if your doing it the hard way. If you are doing it the easy way do the same as term 2.
Formulas:
1.=(Goal/100)*23.3
2.=((Goal-Term 1 yearly mark- Term 2 yearly mark)/53.3)*23.3
Third term: To find this you just divide term three out of yearly marks by 0.23 to get the marks you need to get in each course for term three to reach your goals
Formulas:
1.=(Term 3 yearly mark/0.23)
Summative
Out of yearly: To find this you subtract all three terms from the goal, then divide by 30 to get 1% than multiply by 30 to get the out of year marks for the summative or whatever is left is the marks in the summative this is the hard way. Or you can just divide the goals by 100 than multiply this by 30.
Formulas:
1. (goal/100)*30
2. ((Goal-All three terms)/30)*30
3. (Goal-All three terms) take the answer as the out of year mark for summative
Summative: You divide out of year mark by 0.3 to get the amount of marks you need to get on the summative to reach your goal.
This is the formulas for this assighnment.
Monday, November 26, 2007
Group project Planning
Today the teachers told us something that was crucial to our group project and it was planning. If you don't plan properly the finally product's quality will be effected. For the web page and interactive power points, smart ideas and its mind web will be effieceint, we can put notes on a idea box so lets say its a link to a web page or slide of you advertisments, you have ideas on what it will be like so you make a note on that box which represents the page, on this note this may include things like what will you put on this page or slide. To improve your knowledge of smart ideas, you can just use quick box, so you can make a box imediatley without wasting alot of time making boxes individually. If you think notes help wait till you see leveling. Right click and click on level, thant a new mindweb will pop up and it will be a secondary one, dont wory when you click on go to main it will go back to your original mind web, when you linked it to a box that means that that web is about this page or slide and you should put every one of your ideas for this page on it, this is even better that the notes but its your choice to choose which ever one you want they both work. When you go to the global option you will get too see all the levels, so what level is connected to what.
The 2 ways to explain what each webpage and slide is about and what does it contain
Notes:
-Fast
-Easy make and read
-Less work
This explains in lettle depth but it is useful
Level:
-in depth explaination
-more details
-gives people an outline of what should they put on their page, very useful to ESL's
Lots of work.
For the video the only time you choose to use the smart ideas is when you are making an interactive video so you watch a clip, and you choose what clip to watch next. But since videos are always moving and you cannot change its direction there wont be many ideas to split so its very hard to make a good plan unless its an interactive video. I highly suggest you use the story borad, manufactured for videos. Even Holleywood videos use this to plan. This is where you highlight the main parts of the video, so you draw a picture in a box and write in detail about what main part does that box regresent. You should only use this for videos and use smart ideas for the other two projects it is better.
The 2 ways to explain what each webpage and slide is about and what does it contain
Notes:
-Fast
-Easy make and read
-Less work
This explains in lettle depth but it is useful
Level:
-in depth explaination
-more details
-gives people an outline of what should they put on their page, very useful to ESL's
Lots of work.
For the video the only time you choose to use the smart ideas is when you are making an interactive video so you watch a clip, and you choose what clip to watch next. But since videos are always moving and you cannot change its direction there wont be many ideas to split so its very hard to make a good plan unless its an interactive video. I highly suggest you use the story borad, manufactured for videos. Even Holleywood videos use this to plan. This is where you highlight the main parts of the video, so you draw a picture in a box and write in detail about what main part does that box regresent. You should only use this for videos and use smart ideas for the other two projects it is better.
Excel
Today our teacher taught use how to use excel. It is a very useful program. In average businesses we usually oranguise our profits on spreadsheets but, it on paper so we have to use calculators to add and subtract, but this make life alot simpler. you just right a formula and drag it down the column and every single digit in that column will follow that formula. the formula is as follows.
There are 3 things that you could put on microsoft Excel, it is text, value and formula.
Text is what exactly what it is, text is words, sybols and other things that represent somthing but doesn't have a value, even when you wright the number out in words it isn't doesn't have a value.
Each side have their own name. This name is the Cell Adress. The cell adress is determined by the row and column titles. When you click on a cell on the top right corner you can see somthing with a letter and a numeber is is the cell adress bar and it makes it easier to find the cell adress.
Values are numbers and things that worth somthing.
All formulas start with and equals sighn or else it will be a value strand.
Formula formulas are usually operations between cells, so the value in the cells can be added subtracted or in other words could be operated. Some formulas are better that others, for exapmle if your just put formulas with values in one cell, if you messed up one cell with the value you will have to change the formula becuase it is operating with values, but if you operate with cells, if you change the value in the cells the formula will react and the column with the formula will change so the value will change. Formulas using cells have to have specific titles after the equals sighn to determine what operations to use. To make this formula go to the bar beside the cell adress bar, or just double the cell to write the formula, first put equal than the title like SUM(cell,operation,cell). After doing so whenever you change one of the 2 cells this cell will change occoding to the value of what is in the cell and the operation you are using. When you drag this cell down the column or row, the formula will be given to these cells but instead of the same cells you chose its the cells under these cell you chose because depending on where the formula goes it affects the cells you are draging it to, if the cells you chose were the on the left of it, than the cell on the bottom will have the same formula but with the cells 2 left of it so its under the cell and it will be different. Draging drags the formula and the values down the column so if you are recording bottled water sold, you will make a column for numbers of water sold, price, total. You would first make 1 cell under price, lets say 1.00 and then drag it down everything under will have 1.00 and then you just and it on the quantity on the number sold, and thand make the formula on one cell and drag it down. For the total, you just make a formula by putting equals than SUM(Cell+Cell+Cell) and so on so you click on all the sums you want to add. If you are lazy and the sums you want to add are in a strait row just click on the first cell and drag down than click enter, then thats the answer.
The text is usually used to organise things.
There are 3 things that you could put on microsoft Excel, it is text, value and formula.
Text is what exactly what it is, text is words, sybols and other things that represent somthing but doesn't have a value, even when you wright the number out in words it isn't doesn't have a value.
Each side have their own name. This name is the Cell Adress. The cell adress is determined by the row and column titles. When you click on a cell on the top right corner you can see somthing with a letter and a numeber is is the cell adress bar and it makes it easier to find the cell adress.
Values are numbers and things that worth somthing.
All formulas start with and equals sighn or else it will be a value strand.
Formula formulas are usually operations between cells, so the value in the cells can be added subtracted or in other words could be operated. Some formulas are better that others, for exapmle if your just put formulas with values in one cell, if you messed up one cell with the value you will have to change the formula becuase it is operating with values, but if you operate with cells, if you change the value in the cells the formula will react and the column with the formula will change so the value will change. Formulas using cells have to have specific titles after the equals sighn to determine what operations to use. To make this formula go to the bar beside the cell adress bar, or just double the cell to write the formula, first put equal than the title like SUM(cell,operation,cell). After doing so whenever you change one of the 2 cells this cell will change occoding to the value of what is in the cell and the operation you are using. When you drag this cell down the column or row, the formula will be given to these cells but instead of the same cells you chose its the cells under these cell you chose because depending on where the formula goes it affects the cells you are draging it to, if the cells you chose were the on the left of it, than the cell on the bottom will have the same formula but with the cells 2 left of it so its under the cell and it will be different. Draging drags the formula and the values down the column so if you are recording bottled water sold, you will make a column for numbers of water sold, price, total. You would first make 1 cell under price, lets say 1.00 and then drag it down everything under will have 1.00 and then you just and it on the quantity on the number sold, and thand make the formula on one cell and drag it down. For the total, you just make a formula by putting equals than SUM(Cell+Cell+Cell) and so on so you click on all the sums you want to add. If you are lazy and the sums you want to add are in a strait row just click on the first cell and drag down than click enter, then thats the answer.
The text is usually used to organise things.
Wednesday, November 21, 2007
The Group Project Work Day.
Today we continued to work on our group power point project. Most of our team mates went on a music trip. Yesterday we were supposed to make a mind map on paper about our project, the interactive power point one. Today we were supposed to put this mind map on Smart Ideas, a program used to plan for projects and make mind maps. We put in all the topics to 4 group members could think of and then we started assighning them to people. When we were finished, the tacher told us to assighn jobs for our group members, to keep them busy and out of trouble, but it was also to help make the slides on the topic they chose. In the end I have to do slides on Computer Labs, Library, books, the new batch of computers in them, uniforms the goods and bads of the uniforms, grade Nine which will lead to academic and applied, and a page about to school. Me and david just took some extra jobs because most of our group members were not here so we cannot decide so if they want something one of us will give on of these slides to them. Also since I was the president and david was the vice president we have to do more work than other members, it was what we decided before we chose presidents and vice presidents. It is fair for everyone. So this basically was a work period.
Monday, November 19, 2007
Business Ethics and Computer Ethics
We spent todays class talking about business ethics and computer ethics. Lucky for me I learned all about ethics in Introduction to Business because we just finished the chapter. We talked about what ethics is. Also we discused things about the internet and an incident that occured. The incident was, a principle from a local school baned cell phones, the tdsb baned it basciall, but the students thought that it was the principles choice so they went of face book and wrote bad things about the personal life of the principle taliking about his race, gender, sexual orientation and other things that involve discrimination. Principle found out and suspended them and other students said that they have the right of freedom to speech, and since it is in their home, and it is their computer they think they can do whatever they want but it is not true because the internet is a public place. It is ilegal to say bad things to people about their race, gender or sexual orientation it is harassment. You can say why you dont like the principle and what changes you may want the principle to make but you cant just attack the principle. Since the internet is a public place when you direct somthing nasty about race or sexuality to a person, and another person feels bad because of it you can be sued for harassment, because harassment is a way you act that makes another people feel uncomfortable and the words you direct are making other people uncomfotable so its harassment. The students protest saying they have feedom of speech, but when their speech is attacking a person based on their race or sexuality, it is against the law and the person being harassed have the rights to sew them. This class basically talked about this. The tachers also told us we should check what we write on the internet because alot of the times we are joking around with other students for example sexual jokes, when other people view it they may feel uncomfortable and you and your friend will be in trouble for harassing the person feeling uncomfortable becasue of what you wrote. This applies alot to the wiki. I think I should add rules to the wiki.
Harassment: When you act in a way that threatens or makes someone feel uncomfortable and it is not acceptable in society.
Ethics: Rules that determine right from wrong and encourages us to do the right thing.
Harassment: When you act in a way that threatens or makes someone feel uncomfortable and it is not acceptable in society.
Ethics: Rules that determine right from wrong and encourages us to do the right thing.
Sunday, November 18, 2007
Project for Months
On Friday 16, November 2007 our BTT teacher gave us a group project. We are split into 3 groups, 7 in a group. There were four 3 girls and 4 boys in my group, they made me president, and made my friend david the vicepresident, we didnt want to do it because we are sure we have to do alot of work. The tacher asked us for the top 2 choices out of the three projects, a video, a interactive Powerpoint assighnment, or a website. We chose video as our first on and the interactive PowerPoint was our second choice but in the end we ended up with the interactive power point. We need to figure out a name so one of our teamates sugested we name ourselves JungleBook, we have no other ideas so we just used it as our name, that time we were discussing thing about how do we make the slides and we dicided that everyone makes 2 slides, the vicepresident makes 3 slides and the president will make 4 slides and then we will figure out a way to make the power point. The group project is so we can advertise our school to children and parents from the schools feeder schools so Mr. Case can tourture them. I wonder how would we be able to advertise our school through a power point presenation? I sould ask my team mates of monday.
Wednesday, November 14, 2007
Andersons top three Adventures
Today our BTT teacher gave us somthing to do with the other classes adventures. We are supposed to play the adventures of the other class and rate them and put the top three adventures on the blog post. The top three presentations will be on the bottom:
1. Angela's presentation is the best one out of the hole class because she added sound affects. I never thought of adding sound effects. There may have been no hidden buttons, but the fact that the choices are weird made it fun like chosing the apple or oranges. The presentation was brought to life by the sound affects.
2.Shruti's Presentation is the second best becauseit is very fun and stupid. It is more like a quize but the quize is funny, and there are many choices and most of them lead to death, but most of them is common scence. I is so stupid it is entertaining. To me things that are stupid are usually more entertaining than things that are not so that is why I think Shruti's presentation is good.
3.Asamuddin's presetation is good, it was either Aqsaa's or Asamuddins because both have an interesting story line. I noticed that Asamuddin used hidden buttons in the porject, even though it was poorly done becuase you can still see the lines that means there is a hidden button there, it was preety good and entertaining, that is all that I cared for puting the presentation on my top 3 list.
I noticed that overall most people didn't remove slide transfer with mouse which was pretty annoying, only Angela and Shruti's out of most of the adventures i saw removed it so that is also another reason why they were in my list and they were the top 2.
1. Angela's presentation is the best one out of the hole class because she added sound affects. I never thought of adding sound effects. There may have been no hidden buttons, but the fact that the choices are weird made it fun like chosing the apple or oranges. The presentation was brought to life by the sound affects.
2.Shruti's Presentation is the second best becauseit is very fun and stupid. It is more like a quize but the quize is funny, and there are many choices and most of them lead to death, but most of them is common scence. I is so stupid it is entertaining. To me things that are stupid are usually more entertaining than things that are not so that is why I think Shruti's presentation is good.
3.Asamuddin's presetation is good, it was either Aqsaa's or Asamuddins because both have an interesting story line. I noticed that Asamuddin used hidden buttons in the porject, even though it was poorly done becuase you can still see the lines that means there is a hidden button there, it was preety good and entertaining, that is all that I cared for puting the presentation on my top 3 list.
I noticed that overall most people didn't remove slide transfer with mouse which was pretty annoying, only Angela and Shruti's out of most of the adventures i saw removed it so that is also another reason why they were in my list and they were the top 2.
Monday, November 12, 2007
No mouse click transition.
Today our teacher taught us how to stop transfering the slides with the mouse clicking, which is very useful to our power point adventure because on the power point adventrue. The reason why it is useful is becasue when you are trying to find hidden buttons and you click around you might go to the next page instead, also this will mess up the order aswell because if you accidentally go to another slide it will screw up the story which will make the story line confusing and the power point presentation which is supposed to be fun will no be fun.
To remove it you have to:
Open the slide transition page:
PowerPoint 2003:
Alt, D
Slide Show, Slide transition
PowerPoint 2007:
Animation, advance slides
Then when you have a window you uncheck the box that says on mouse click. This will make you slides unmovable with the mouse. This will make clicking around for hidden buttons alot easier, and make the adventure less confusing.
To remove it you have to:
Open the slide transition page:
PowerPoint 2003:
Alt, D
Slide Show, Slide transition
PowerPoint 2007:
Animation, advance slides
Then when you have a window you uncheck the box that says on mouse click. This will make you slides unmovable with the mouse. This will make clicking around for hidden buttons alot easier, and make the adventure less confusing.
Tuesday, November 6, 2007
Test + Game
Today our tacher gave us a assinment and infromed us about a test that will be given to us on Friday, November 9 2007. It is about binary, and the stuff we learned about it. I could probably use the wiki to study for the test or read my previous posts but to inform me a litte better. Bits is a piece of information that is only 0's and 1's because computers only can read the 2 numbers. The type of binary we are probably learning about is the ones multiplying up by 2. 8 if these pieces of infromation is a bite. 1000 (1024) bites is a kilobyte (8000 bits). It goes on.
Today Mr.Case showed us some neat things, he showed us how to make a game out of Power point. We first make a shape by going to the shape button click on it and choose a shape. In 2007 office we go to insert, shape and then choose a shape. After we made the shape we click on it than go to hyper link, (Insert, hyperlink) ( CTRL K) ( right mouse button and hyperlink). Than we go to place in this document so you are linking to somthing in you document basically, in other words another slide, choose the slide we want to go to and than click ok now that symbole can link to another slide. We have to make an adventure out of this. We can use Smart Idea to help us make this adventure, it is basically a program that helps us order our thoughts or make a mind web, so you can plan what slide connects to what.
The teacher also taght us how to make hidden buttons. After we make the buttons we just right click it and click hide behind background so there wont be fingures, you just have to click around to find it when you are presenting buttons and having fun with the game in the slide show. This is just for fun if you want to improve you marks on the slide show.
Today Mr.Case showed us some neat things, he showed us how to make a game out of Power point. We first make a shape by going to the shape button click on it and choose a shape. In 2007 office we go to insert, shape and then choose a shape. After we made the shape we click on it than go to hyper link, (Insert, hyperlink) ( CTRL K) ( right mouse button and hyperlink). Than we go to place in this document so you are linking to somthing in you document basically, in other words another slide, choose the slide we want to go to and than click ok now that symbole can link to another slide. We have to make an adventure out of this. We can use Smart Idea to help us make this adventure, it is basically a program that helps us order our thoughts or make a mind web, so you can plan what slide connects to what.
The teacher also taght us how to make hidden buttons. After we make the buttons we just right click it and click hide behind background so there wont be fingures, you just have to click around to find it when you are presenting buttons and having fun with the game in the slide show. This is just for fun if you want to improve you marks on the slide show.
The presentations.
Yesterday, we presented our brand projects. In my personal oppinion the best one was the one about Starbucks, becasue it had many pictures and effects that captured my attention, and also we didn't have to read much on the slides so we focus on her speach more than reading the slides, this is a good stratagy that I think I might want to use in the next power point presentation. Also using all those pictures made the presentation more entertaining. It made me feel that my presentation was horrible, but I am really proud of it because it has lots of tables and charts which were better than my old presentations which were only information, I also thought that my new presentation is less boring. I also learned a important lesson, when the teacher gives us 5 minutes to drop stuff in the drop box we better do it fast or else if it is not there we will get a zero.
Subscribe to:
Posts (Atom)
