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