ICTL - F1 - Spreadsheet & Task

Spreadsheet (MS Excel) :
- one of the MS Office
- use cell
- Activity :
1) State the steps to launch spreadsheet software
2) Launch a spreadsheet application
3) State and identify features in spreadsheet application and demonstrate understanding of user interface State the main toolbars in spreadsheet software
4) List icons in standard, formatting, formula and chart toolbars.
5) Create a new worksheet using spreadsheet software
6) Enter data into new worksheet
7) Copy, Cut, Paste and Delete data
8) Save the worksheet

- Toolbar : Standard bar
Formatting bar
Formula bar
Chart bar

- Formula : Sum (autoSum)
Average
Grading (VLookup)
Percentage (%)
Ranking

- Task : Make one Mark Sheet - mid year exam 2008 consist :

No Name BM BI M3 KH Sc PAI GEO SEJ PS TOTAL AVERAGE % GRADING

using skills that you have learn. Save as, name of file : ResultMY08. Duration : 1 week.


Revision :

1. GENERATIONS OF COMPUTERS & PROCESSORS USED
TYPES OF COMPUTERS :

1. Supercomputer

2. Mainframe

3. Mini Computer

4. Micro Computer

5. Work Station

2. COMPUTER PARTS & COMPONENTS

MAIN COMPONENTS IN COMPUTER SYSTEM

1. Monitor

2. Keyboard

3. Speaker

4. Mouse

5. System unit

6. printer

3. BLOCK CYCLE DIAGRAM :

1. Input

2. Process

3. Output

4. Storage

4. TYPES OF PERIPHERALS :

1. Input devices
2. Output devices
3. Storage devices

5. DATA MEASUREMENT

1. Bit

A bit is a binary digit, taking a value of either 0 or 1. For example, the number 10010111 is 8 bits long or in most cases one modem PC byte.

2. Byte
3. Kilobyte
4. Megabyte
5. Gigabyte