File Name Conventions

I organise my files by having a file for each school subject, then a file inside each one of those for the year.  I name all my documents with a name which will let me know what the document is.  I use camel case to name my files.  This is when the file names have no spaces in them but capitols at the start of each word.
 

Another way of naming your files is having underscores instead of spaces.
If you use spaces in the file name then if the file is used on the internet, the computer may change the name.  This is why you shouldn't use spaces in the file name.
Another thing you should try not to do is use special characters such as !#$%? except for underscores and dashes.

However you organise your file you should always be consistent.

Exel - Cell References and Copying to Word

Relative Reference - This means that when you reference a cell in a formula and you use the formula for different cells, the cells in the formula will move across and down depending on where the cell is that you chose to use.
 

Absolute Reference - This is used in a formula to set a cell so when the formula is used in different cells, the cell you have set will stay the same.  You do this by adding '$' before the letter or number reference for the cell, depending on what you want to stay the same.  eg  =B2+$A$8     A8 will stay in the formula even when you change the cell.   





Copying to Word - If you copy and paste information from excel to word you will have many different paste options.  One of them is 'linking'.  This means that if you change something on the original excel document, the information will also change on the word document.

Tools in Word

• Quick Styles - This is used when you are formatting your text and you have different formats such as font, size and spacing for different parts of your text (e.g. title, subheadings).  It is a lot easier to make the format you would like to use then save it as a quick style so you can reuse it later in the text.  It is easier to use this than to try remember spacing or font sizes each time when making a new heading.
• Paragraph and Line Spacing - You can use line spacing to spread out your text more so it is easier to read.  Paragraph spacing is used to separate paragraphs instead of using double 'enters'.  You can do this by right clicking the text style at the top of the page and going to 'modify'.  You can then go to 'paragraphs' and edit the size of the gap before or after the paragraph.  If you with to make a new line without getting a paragraph gap, use 'shift, enter' instead of just 'enter'.  
• Tables - Tables are a useful way to display information.  To make them, you go to 'insert', then to 'table'.  You can then pick how many columns and rows you want.  When using tables you should always adjust the cell margins so the text doesn't look too crammed up.  In the table you can merge cells and right, left and centre align text.
• Tabs - Tabs can be useful to show information.  To make a tab, simply turn the rulers on then click on the ruler where you would like a tab.  With a tab you can left, right and centre align text as well as aligning decimals.