Category: News

Evaluating the Design of Web Pages

Web pages are not put together in a random manner. Much thought will have been put into the layout and content of a web site, especially if the web site is designed to sell or promote products over the internet. Remember the web designer will have to have had interviews with the client (customer) to find out what is requiresAreas that can be used to evaluate how good a web page is can be as follows :-
  • Content – This is the actual text,  pictures and graphics that make up each page.
  • Balance – This refers to colour, text and pictures being evenly spread over the page.
  • Unity – Topics relating to each other should be in the same area on the page.
  • Texture – Areas on a web page that give the impression of a surface (e.g brick, carpet.)
  • Tables and Lines – Tables used to contain information, lines used to make borders etc.
  • Colour – Too many colours on a web page puts people off. Red and Green is not a good colour combination.
  • Movement – This means leading the viewers eye from one area to another.
  • Navigation – How to get from one area to another. (Hyperlinks, scroll bars etc)

Spreadsheet Formula

Today we looked at how spreadsheets use formula. Every spreadsheet formula must start with an equals sign (=), this tells the spreadsheet application to treat the cell contents as a formula.

We use the following mathematical formula in spreadsheets

  • Add +
  • Subtract –
  • Multiply *
  • Divide /

The rules of BODMAS apply for complex mathematical conditions

  • =A1*A5
  • =A1*A5 + 5
  • =A1*(A5+5)

Read more

Spreadsheet Starter Question 1

  1. Name two things that a spreadsheet could be used for?                                    (2)
  2. Spreadsheets are like grids made up of what two things?                                  (1)
  3. What mathematical symbol is used to divide in a spreadsheet?                           (1)
  4. What term is used to identify a cell’s position on a spreadsheet?                          (1)
  5. Name three types of data that can be entered into a spreadsheet         (3)

Read more

Spreadsheets Introduction

Today we started spreadsheets, which are used to store and process numbers.

We looked at how spreadsheets use “cell references” to name cells. These cells can contain Text (labels), Values (numbers) or formula.

You were set a task to create the six times table using excel, this took about 5 minutes on the PCs, tomorrow we will look at how to make creating this faster.

Slides after the jump

Read more