ICT Year 6

Html

REVISION 2

LO: I can use basic tags to create a webpage

<html><head><title>REVISION2</title></head>

<p><center><font color="white">MeNu

<P><h1> <font color="red">WELCOME TO OUR RESTAURANT

<p>

<p>

<p>we are serving

<ul >

<li>Coffee</li>

<li>water</li>

</ul>

<ol>

<li>Coffee</li>

<li>water</li>

</ol>

</body>

</html>

Html

REVISION

LO: I can use basic tags to create a webpage

<html>

<head>

<title>revision</title>

</head>

<p><center><font color="white">invitation

<P><h1> <font color="red">Desert trip

<p><h4><font color="blue">March 2020

<p>

<p>meeting time Monday 8 AM, free beverage offered

<ul >

<li>Coffee</li>

</ul>

<ol>

<li>Coffee</li>

</ol>

</body>

</html>

Basic tags used

Bgcolor : background color

Font color: font color

Ul: unordered list (bullet point)

Ol: ordered list (numbers)

H1: Heading size P: new paragraph

lesson

1. Understand what HTML stands for and explain why it is used

2. Create a simple website using html tags

Hypertext Markup Language.

HTML is the programming language for writing web pages. Many web-sites are written using software packages such as Front Page and Dreamweaver. However programmers still need to be able to understand HTML and the more advanced Javascript.

As a first attempt at web page writing it is a good exercise to learn a few basic commands in HTML. The text is written in Notepad, go to Start > Programs > Accessories > Notepad. After some code has been written you can instantly view in Internet Explorer or Netscape by saving the document as an html document. Run the html document to see the results, and make any necessary arrangements by clicking on View in the menu and selecting Source, the source code is displayed, (the original Notepad document).

Note a Tag. It is the information stored within the arrow brackets i.e. <TAG>.

<HTML>

<HEAD>

<TITLE>

My First Web Page!

</TITLE>

</HEAD>

<BODY>

<H1>

Hello Everybody!!!

</H1>

</BODY>

</HTML>

Starting the document:

<HTML> defines the document, computer or browser can read in the correct syntax. It is always the first tag.

</HTML> end of the HTML document. It is always the last tag.

The structure of a web page:

<HEAD> creates a header, the head of the document, holds the information about the document such as the title. A Title should be present in the Head.

</HEAD> end of the Head.

<TITLE> gives the web page a title, appears on the web browser's title bar. It is used by search engines to find the page. Each page should have a different title.

</TITLE> end of the Title.

<BODY> creates the body of the web page, it is the content of the page that actually appears in the web browser. The entire content of the web page appears in the Body. The Body will contain the text, images, links, multimedia, animation etc. All the work you do will go into the Body.

</BODY> end of the Body.

<H1> creates the size of the text that comes next, H stands for Heading, and 1 stands for the biggest size. Therefore the most important message or headline could be written using this tag.

</H1> end of this size of text.

Note: every time a tag is opened i.e. <H1> it always has to be closed i.e. </H1>, the forward slash is used to denote the closing of the tag.

Term 2 : HTML – Creating your own websites

Revision

For the ICT assessment children will be expected to

type,format and update data in a table.
insert chart
sort and filter
do calculations using functions (sum, average, max, min ,if )

for more details

Excel is an incredibly powerful tool for getting meaning out of vast amounts of data. But it also works really well for simple calculations and tracking almost any kind of information. The key for unlocking all that potential is the grid of cells. Cells can contain numbers, text, or formulas. You put data in your cells and group them in rows and columns. That allows you to add up your data, sort and filter it, put it in tables, and build great-looking charts. Let’s go through the basic steps to get you started.

Create a new workbook

Excel documents are called workbooks. Each workbook has sheets, typically called spreadsheets. You can add as many sheets as you want to a workbook, or you can create new workbooks to keep your data separate.

1. Click File, and then click New.

2. Under New, click the Blank workbook.

Enter your data

1. Click an empty cell.

For example, cell A1 on a new sheet. Cells are referenced by their location in the row and column on the sheet, so cell A1 is in the first row of column A.

2. Type text or a number in the cell.

3. Press Enter or Tab to move to the next cell.

Apply cell borders

1. Select the cell or range of cells that you want to add a border to.

2. On the Home tab, in the Font group, click the arrow next to Borders, and then click the border style that you want.

Apply cell shading

1. Select the cell or range of cells that you want to apply cell shading to.

2. On the Home tab, in the Font group, choose the arrow next to Fill Color , and then under Theme Colors or Standard Colors, select the color that you want.

Use AutoSum to add your data

When you’ve entered numbers in your sheet, you might want to add them up. A fast way to do that is by using AutoSum.

1. Select the cell to the right or below the numbers you want to add.

2. Click the Home tab, and then click AutoSum in the Editing group.

AutoSum adds up the numbers and shows the result in the cell you selected.

Create a simple formula

Adding numbers is just one of the things you can do, but Excel can do other math as well. Try some simple formulas to add, subtract, multiply, or divide your numbers.

1. Pick a cell, and then type an equal sign (=).

That tells Excel that this cell will contain a formula.

2. Type a combination of numbers and calculation operators, like the plus sign (+) for addition, the minus sign (-) for subtraction, the asterisk (*) for multiplication, or the forward slash (/) for division.

For example, enter =2+4, =4-2, =2*4, or =4/2.

3. Press Enter.

This runs the calculation.

You can also press Ctrl+Enter if you want the cursor to stay on the active cell.

Apply a number format

To distinguish between different types of numbers, add a format, like currency, percentages, or dates.

1. Select the cells that have numbers you want to format.

2. Click the Home tab, and then click the arrow in the General box.

3. Pick a number format.

Put your data in a table

A simple way to access Excel’s power is to put your data in a table. That lets you quickly filter or sort your data.

1. Select your data by clicking the first cell and dragging to the last cell in your data.

To use the keyboard, hold down Shift while you press the arrow keys to select your data.

2. Click the Quick Analysis button in the bottom-right corner of the selection.

3. Click Tables, move your cursor to the Table button to preview your data, and then click the Table button.

4. Click the arrow in the table header of a column.

5. To filter the data, clear the Select All check box, and then select the data you want to show in your table.

6. To sort the data, click Sort A to Z or Sort Z to A.

7. Click OK.

Show totals for your numbers using Quick Analysis

The Quick Analysis tool (available in Excel 2016 and Excel 2013 only) let you total your numbers quickly. Whether it’s a sum, average, or count you want, Excel shows the calculation results right below or next to your numbers.

1. Select the cells that contain numbers you want to add or count.

2. Click the Quick Analysis button in the bottom-right corner of the selection.

3. Click Totals, move your cursor across the buttons to see the calculation results for your data, and then click the button to apply the totals.

Show your data in a chart using Quick Analysis

The Quick Analysis tool (available in Excel 2016 and Excel 2013 only) recommends the right chart for your data and gives you a visual presentation in just a few clicks.

1. Select the cells that contain the data you want to show in a chart.

2. Click the Quick Analysis button in the bottom-right corner of the selection.

3. Click the Charts tab, move across the recommended charts to see which one looks best for your data, and then click the one that you want.

Note: Excel shows different charts in this gallery, depending on what’s recommended for your data.

Sort your data

To quickly sort your data

1. Select a range of data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column). The range can include titles that you created to identify columns or rows.

2. Select a single cell in the column on which you want to sort.

3. Click to perform an ascending sort (A to Z or smallest number to largest).

4. Click to perform a descending sort (Z to A or largest number to smallest).

To sort by specific criteria

1. Select a single cell anywhere in the range that you want to sort.

2. On the Data tab, in the Sort & Filter group, choose Sort.

3. The Sort dialog box appears.

4. In the Sort by list, select the first column on which you want to sort.

5. In the Sort On list, select either Values, Cell Color, Font Color, or Cell Icon.

6. In the Order list, select the order that you want to apply to the sort operation — alphabetically or numerically ascending or descending (that is, A to Z or Z to A for text or lower to higher or higher to lower for numbers).

Filter your data

1. Select the data that you want to filter.

2. On the Data tab, in the Sort & Filter group, click Filter.

3. Click the arrow in the column header to display a list in which you can make filter choices.

4. To select by values, in the list, clear the (Select All) check box. This removes the check marks from all the check boxes. Then, select only the values you want to see, and click OK to see the results.

To get more information

https://drive.google.com/file/d/14ifNH5NWF6ztADVNfgHNtPk_p54CDKzw/view?usp=sharing

Microsoft Excel

Greetings! In this term, you'll learn about workbooks and the different parts of an Excel worksheet (spreadsheet), such as rows, columns, and cells. We'll discuss how to insert rows and columns, and how to move around in a worksheet.

We'll also learn how to enter data into cells, move and copy data, propagate cell contents, and more. We'll tell you everything you need to know to get started using Microsoft Excel. We encourage you to sort , filter data. create a chart and present data as a chart is an objective to this module.

Report abuse