Wiki 101
Monday, December 15, 2008 // 9:05 AM
"To deny our own impulses is to deny the very thing that makes us human." - Andy and Larry Wachowski
Get to know the wiki better:
tiki - is your own area
wiki - community area
Setting up your own wiki is free!
Wiki is a community collaboration, comes from the hawaiian word "community".
In your tiki, you've got everything from an online agenda (add events to remind yourself when their happening) to contact lists.
Forums are a great way to develop initiative and leadership. Mr.Case marks highly of people who hang out in the Forums.
Labels: community, forum, Wiki
Random Excel Facts ! :)
Wednesday, December 10, 2008 // 9:22 AM
Random excel facts:
- SUM, division, addition, AVERAGE, etc are things called "FUNCTIONS"
- OVR makes the text you write in a cell overlap everything in the cell while Insert lets you write in addition to what you already have
- to merge, you can press the "MERGE and CENTER" button beside the alignments (center, etc)
formulas on the test:
- average, sum, basic stuff, formulas for marks
- AUTOSUM
- formula for figuring how many different types of information (e.g. cupcakes) =count(insert cells)
be comfortable with sorting data!!
Data/Sort
good way to study for a test is to put your cursor on the toolbars and watch what comes up and study.
POTENTIAL BONUS QUESTION - WHAT IS A WEIBULL??!?!?!?!
TEST IS ON WEDNESDAY!!! good luck! :)
Labels: cell, Excel, formula, Test Review
Lawsuits galore
Thursday, December 4, 2008 // 1:56 PM
"An ounce of action is worth a ton of theory." - Friedrich Engels
Today in class, we received a large, informative pdf file about Copyright laws in Canada for our podcasts. It was extremely long and boring but nontheless, necessary.
Truly, I had no idea that making a podcast could be such a headache. There's all sorts of copyright laws for songs, interviews, etc etc! It's almost impossible to make anything entertaining without getting your butt sued. I only briefly scanned through it but I will look at it more in depth later.
Goodbye,
- Serena
Incorporating Excel into our report cards!
Wednesday, December 3, 2008 // 9:30 AM
In class, we focused on more formulas in excel. As we have recently received our report cards, we learned today how to calculate our average, the percentage of the average throughout the whole term, and more nifty tricks on how to set reasonable goals and achieve them! This class, we basically focused on how to do algebraic equations, backwards. For example, if we already have an answer, we need to figure out a correct formula to insert into the cell to get that answer. We learned the importance of asking questions rather than looking for just an aswer.
A way we can take advantage of Excel for our marks is to make a vertical column with all the subjects and then put the three terms across on the top horizontally. We then insert what we got for term 1 and place a goal on the further right column that we want to achieve by the end of the year. Using a formula, we take the variable of your goal mark (e.g. 80), multiply it by three, subtract Term 1 variable, and then divide the remaining number by 2 in order to get what you will need for Term 2 so you can reach your goal. REMEMBER TO USE BEDMAS! For the Term 3 mark, just take the goal mark variable, multiply it by 3, subtract the Term 1 & 2 variables which will give you what you need to reach your goal. With these nifty formulas (instead of using actual numbers), you can go back to change your goals, your marks and Excel will automatically do the math for you if you achieved a higher or lower mark than expected, thus giving you what you need to aspire to for Term 2 & 3.
Useful hint*: Using formulas can be quite confusing, which is why if you want to test your formula out, put a dummy row on the bottom and put 3 100's across the terms and if your average for the three is 100, then your formula is correct.
Remember that each cell of Excel is a tiny calculator so be sure to use it to your full advantage! :)
Later, I shall place a screenshot here of my Excel Marks sheet to demonstrate!
So long,
- Serena
Labels: cell, Excel, formula, Marks, Microsoft
Tutorial
Monday, December 1, 2008 // 9:31 AM
"Our lives begin to end the day we become silent about things that matter." - Martin Luther King Jr.
In class, we looked briefly at Microsoft Excel tutorials on atomiclearning.com.
Username: ECOO2008
Password: atomic
They were quite confusing and filled with information.
With the rest of the time, we made our family budgets.
Peace,
- Serena