HTML vs CSS

HTML (hypertext markup language) tells the website where to put things on the page for example make the title centered or the picture on the left hand side half way down the page.It is the building blocks of the whole website.

CSS (Cascading Stylesheets) is they styling and design of the website for example all links on this site will be blue or every title has size 42 font. The CSS is the design consultant when the site opens up every time, it tells the site how to appear.

Example of CSS code 

h1 { 

    font-family: Georgia, "Times New Roman", Times, serif; 

    font-size: 18px; 

    font-weight: bold; 

    color: #000000; 

    } 

h2 { 

    font-family: Georgia, "Times New Roman", Times, serif; 

    font-size: 16px;

    font-weight: bold; 

    color: #000000; 

    border-bottom: 1px solid #C6EC8C; 

    }  

Microsoft Excel

1. import: .csv (comma seperated value file)- standardised format. Save as Excel Workbook! Open all files!
2. Absolute and relative cell references-Relative cell references are relative to where you are, the formula changes depending on where you copy and paste it and absolute means it will absolutely always refer to that cell.
3. Named cells (absolute reference), named ranges (automatic reference e.g. naming list of marks as marks). It makes reading formula's easy. Rather than a whole lost of numbers.
4. Sum, average, maximum, minimum, integer, rounding, counting, if, lookup
5. Filtering (cutting down the information), perform searches using AND, OR, NOT, LIKE
6. Perform searches using wildcards (*or anything)- Broadens searches
7. Sort data

Notes

• All formula's have equals sign, their name and brackets.
• Click enter when naming cells