INFORMATION TECHNOLOGY 2014- 2016 GRADE 10 



Introduction to the various programmes o CSEC

o Mainstream NCTVET

o NCTVET

o City and Guild

Application and Implication of I.T. o Data Communication and Networks 

Definition of data communication and network



Types of networks



Data transmission o Transmission media o Wireless networks o Bandwidth o Communication modes o Point to point o Broadcast communications



The Internet o Intranet o Extranet



Data communication via the Internet o E-mail o Newsgroup o Internet relay chat (instant message) o File transfer o VoIP (voice over internet protocol---online voice conversations)

I.T. department 2014-2016 Topics www.cumberlandhigh-infotech.wikispace.com

[email protected] Page 1



The World Wide Web (WWW) o HTML, XHTML o Web browsers o Web servers o URLs o Uses of websites

o Misuse of Information and Computer crimes 

Surveillance



Electronic eavesdropping



Propaganda



Inaccurate information



Industrial espionage



Software piracy



Computer fraud



Credit card fraud



Identity theft

o Application of technology (the use of the software and hardware in the various sectors) 

Business



Science and technology



Education



Law enforcement



Recreation and entertainment



Engineering and design

o ICT in the workplace 

New skills

 Office employees

 Mass media

 Teachers  Engineers  Medical personnel  Musicians 

personnel 

Law enforcement personnel  Movie industry

Patterns of work

I.T. department 2014-2016 Topics www.cumberlandhigh-infotech.wikispace.com

[email protected] Page 2





E-commerce



Telecommuting



Flexitime



Time placed communications

Disadvantage of ICT in the workplace 

Loss of jobs



Retraining

o Careers in I.T. (The function of individuals) o Programmers

o

File librarians

o System analysts

o

Computer technicians

o System designers

o

Computer engineers

o IT managers

o

Software engineers

o

Software testers

o

Web masters

o

We-developers

o

Software trainers

o

Multi-media artists

o System programmers o Database administrators o Network administrators o Emerging technological trends 

Fundamentals of Hardware and Software o Data Representation 

Decimal to binary, octal, hexadecimal



Binary to decimal, octal, hexadecimal



BCD



Sign and Magnitude



Binary addition



Binary subtraction



Binary algebra (finding x)



ASCII and EBCDIC



Two’s complement



Subtracting using two’s complement method

I.T. department 2014-2016 Topics www.cumberlandhigh-infotech.wikispace.com

[email protected] Page 3

o Hardware 





Input 

Key entry



Multimedia entry



Pointing entry



Terminal entry



Source data

Output 

Soft copy



Hard copy

Storage 

Primary storage

o RAM

o EPROM

o ROM

o EEPROM

o PROM 

Secondary storage devices and media o Sequential o



Direct

Units of Storage o Bit o Byte

o Gigabyte

o Kilobyte

o Terabyte

o Megabyte 

Processor 

Control unit



Arithmetic / Logic unit



The machine cycle

o Software 



Application 

Operating system



Utility software



Translators

System 

General purpose



Specialized



Custom written



Integrated



Customized

I.T. department 2014-2016 Topics www.cumberlandhigh-infotech.wikispace.com

[email protected] Page 4



Introduction to Windows o Boot up/ shut down computer system correctly o Identify desktop o Create folders/ files o Delete folders/ files o Hierarchy of folders 

Expand



Collapse

o Launching a web browser o Signing up for an e-mail account o Send an e-mail to the teacher 

Problem Solving and Program design o Problem Solving o Algorithm o Psuedocode



Word Processing o Definition and types of word processing 3/10/14 o MS Word window 3/10/14 o Launch a word Processing 10/10/14 o Using keyboard keys correctly 10/10/14 o Saving document to secondary storage o Creating, editing and formatting a document 

Lists and bullets



Line spacing



Header and footer



Borders



Lines and tables



Add graphics



Mail merge

I.T. department 2014-2016 Topics www.cumberlandhigh-infotech.wikispace.com

[email protected] Page 5



Fundamentals Of Hardware and Software o Hardware Specification o CPU o Main Memory o Hard disk o Monitor o Ports o Expansion slots o File Management o Processing Mode 

Batch processing



Online processing



Real-time processing



Time sharing

o User Interface 

Command line interface



Graphical user interface



Menu –driven interfaces

o Data Security o Using software to protect data  Passwords  Encryption  Virus protection  firewalls o Using physical means to protect data  Biometric system  Guards  Locks  Fire/water proof cabinets o Recovery when things go wrong 

Backups



Archives



Proprietary software

I.T. department 2014-2016 Topics www.cumberlandhigh-infotech.wikispace.com

[email protected] Page 6



Spreadsheet o Definition and types of spreadsheet software o Purpose of using spreadsheet software o Manipulate data in spreadsheet 

Arithmetic formulae 

Functions o Sum, average, minimum, maximium o Date, Count o If, vlookup, rank



Formatting worksheet 

 

Copying formulae

Charts and graphs

Program design / Problem Solving o Flowchart o Truth Table



SBA



Program Implementation o Programming Language o Implementing a program o PASCAL Basics o PASCAL sequence



Database Management System o Definition and types of spreadsheet software o Purpose of using spreadsheet software o Manipulate data in spreadsheet 

Arithmetic formulae 

Functions o Sum, average, minimum, maximium o Date , Count o If, vlookup, rank



Formatting worksheet 



Copying formulae

Charts and graphs

I.T. department 2014-2016 Topics www.cumberlandhigh-infotech.wikispace.com

[email protected] Page 7

GRADE 11 year 2 

SBA



Data Representation (Revision)



Information Processing o Data, Information and Information processing o Type of processing 

Commercial data processing



Industrial data processing





Control systems



Process control systems

Scientific data processing

o Information, retrieval and management 

Documents used for information processing 

Source document



Human readable documents



Machine readable documents



Turnaround documents

o Verification and validation of data 

Data verification



Data validation





Range checks



Data type checks



Inconsistency checks

File organisation and file access 

File organisation o Sequential o Index-sequential o Random



File access

I.T. department 2014-2016 Topics www.cumberlandhigh-infotech.wikispace.com

[email protected] Page 8



Program Implementation (PASCAL) o PASCAL selection o PASCAL For Loop o PASCAL While Loops o PASCAL Repeat …Until Loops o PASCAL Arrays



SBA (Program Implementation)



Program Implementation



Revision



Revision --April



Presentation--April



Web Page Design--April

I.T. department 2014-2016 Topics www.cumberlandhigh-infotech.wikispace.com

[email protected] Page 9