Data and Information

Grade 10 :
Unit 1 : Data and Information

• Data and Information in ICT
• Applications of Information and Communication Technology
• Evolution of the Computer

Grade - 12 GIT Past Papers

Grade - 12 GIT Past Papers here...

Grade - 12 GIT Unit Questions

Grade - 12 GIT Unit Questions here...

Grade - 12 GIT Notes

Grade - 12 GIT Notes here...

Grade - 12 GIT Syllabus

General Information Technology (A/L)
The syllabus given here is based on competency levels.

Unit 1 : The computer and its components
(Explores the computer and its potential to reap timely benefits)

1. The computer system (using a block diagram)
• System concept
• Introduction to computer
• Components of a computer
• Hardware
• Input / Output devices
• Memory devices
• Storage devices (Optical, Magnetic, Semiconductor)
• Processor
• Software
• System software (OS, Utilities)
• Application software
• Block diagram of a computer
• Input
• Processing unit (ALU, CU)
• Output
• Memory / Storage
• Flow of data and control instructions among components
• Data and information
• Attributes of quality information
2. The specification of personal computers
• Hardware specifications of personal computers
• Processor
• Memory
• Hard Disk
• Motherboard
• Ports
• Chip set
• Display
• Graphics Processing Unit (GPU)
• Software specifications for a PC
• Operating System
• Application Software
• Utility Software

Unit 2 : Representation of data
(Explores the representation of data inside a computer)

1. Data representation used in computers and related fundamental concepts
• Number systems
• Decimal
• Binary
• Hexadecimal
• Relevant methods of conversion (Positive integers only)
• Decimal to Binary
• Binary to Decimal
2. Basic Boolean Operators
• Basic Boolean Operators
• AND
• OR
• NOT
3. Character representations and their usage
• Encoding systems used in computers
• ASCII
• UNICODE

Unit 3 : Operating System
(Uses computers efficiently and effectively with awareness of operating system)

1. The contribution of OS to the functioning of computer
• Introduction to operating system
• Basic functions of an OS
2. Functions of operating systems
• Managing Folders and Files (creating, naming, renaming, deleting, copying and moving)
• File names and extensions
• Making changes in setting Panel
• Backup
• Fonts
• Mouse Settings
• Date and Time, Regional and Language Settings
• Add Remove Programs
• User Accounts
• Tools in OS
• Character Map
• Disk optimization
• Disk Checking
• Disk Cleaning

Unit 4 : Application software
(Uses Application software in day to day activities)

1. Word processing software
• Introduction to word processing software
• Features of word processing software
• GUI components in word processing software
• Title Bar
• Formatting Tools
• Editing Tools
• Page Setup Tools
• View Tools
• Designing Tools
• Scroll bars
• Editing Area
• Insertion Point, Cursor
• Status Bar
• Creating a new document
• Page layout and page borders
• Header, footer and page numbers
• Typing text, formatting text
• Editing a document
• Find and replace
• Grammar and spell checker
• Cut / Copy / Paste
• Inserting objects and usage of relevant editing tools
• Pictures/charts/shapes/clip art /word art /text box etc.
• Inserting equations, symbols, links, breaks, date and time
• Short cut keys
• open/new/save/select all/cut /copy/paste/undo/redo/print
• Creating and formatting tables
• Methods of creating a table
• Selecting rows and columns with mouse /insert table/draw table
• Insert and delete rows and columns
• Merge and split cells
• Change row height/column width
• Table borders
• Styles
• Formatting paragraphs
• Saving documents in different formats
• Printing documents
• Print preview
• Print setup
• Printer properties
• Print
2. Spreadsheet software to solve simple mathematical problems
• Introduction to spreadsheet software
• GUI of spreadsheet software
• Work Book
• Work Sheet
• Columns
• Rows
• Cells
• Formula bar
• Function of cell pointer based on its appearance
• Moving around the worksheet
• Types of Data Entries in a cell
• Text
• Numbers
• Formula
• Formatting cells
• Number
• Alignment
• Font
• Inserting rows and columns
• Deleting cells, rows and columns
• Worksheet
• Rename
• Insert
• Delete
• Naming and selecting cell ranges
• Copying and moving cell contents
• Cut /copy/paste/paste special
• Simple calculations
• Arithmetic operations with basic operators ( + , - , * , / )
• Calculations using cell references and operators
• Relative cell references
• Absolute cell references
• Inbuilt functions
• Sum, average, max, min, count and rank
• Types of charts
• Column, Bar, Line and Pie
• Chart tools
• Design, layout and format
• Data filtering
• Data sorting
• Printing worksheets
• Page setup
• Page options
• Margin options
• Sheet options
• Print preview
• Print
3. Electronic presentation software
• Introduction to electronic presentation
• Attributes of an effective presentation
• Features of presentation software
• Usage of presentation software
• Selecting slide layout
• Selecting background
• Inserting text and multimedia contents
• Applying slide transition and animation
• Short cut keys specific to the presentation
• Saving a presentation in different formats
• Printing slides with different options
4. Database Management System (DBMS) Software
• Introduction to database
• Comparison of manual database and automated database
• Introduction to DBMS software
• Objects of DBMS software
• Table
• Query
• Form
• Report
• Field names
• Primary key and foreign key
• Data types
• Text
• Number
• Date / Time
• Currency
• Yes / No
• Field properties
• Field size
• Format
• Designing queries
• Filter fields
• Filter records
• Sort records
• Form wizard
• Report wizard

Unit 5 : Multimedia Contents
(Creates Multimedia contents to express ideas effectively)

1. Designs still graphics using a graphic software
• Types of graphics
• Raster
• Vector
• Properties of a digital image: pixel, resolution, size, color
• Graphic file formats and their features
• Jpg, png,gif, bmp etc
• Image capacity and compression: lossy formats and lossless formats
• Basic operations of a graphic software
• Open, save and edit
• Importing images
• Sizing and transformation
• Selections, cut, crop, replace
• Working with layers
• Working with Text
2. Edits audio contents using an audio editing software
• Recording audio contents
• Editing (editing a relevant segment from original content)
• Audio file formats
• Mp3, wav, au etc
3. Edits videos using an video editing software
• Manipulating and rearranging video
• Video file formats
• Mp4, avi, wmv etc

Unit 6 : Internet
(Uses the Internet efficiently and effectively to access and communicate information in day-today life)

1. Architecture of the Internet
• Purpose of computer network
• Data communication
• Sharing resources
• Network types
• PAN (Personal Area Network)
• LAN (Local Area Network)
• WAN (Wide Area Network)
• Communication devices of a network
• Modem
• Router
• Network Interface Card(NIC)
• Switch
• Wireless Base Station
• Mobile communication GPRS, GSM etc
• Connectivity types
• Guided
• Unguided
• Wired and wireless networks
• Client server model
• Peer to peer
• Hybrid
2. Uses the internet services to access relevant information
• Uniform resource locator (URL) / Uniform resource identifier(URI)
• Web browsers and search engines
• Internet services
• WWW
• Information sharing and electronic transactions
• Email
• Social Media
• internet based text and video based communication (Internet relay chat (IRC) / SMS / video calls etc)
• Blogging and micro blogging
• Cloud Computing
• Cloud based services
• Internet of Things(IoT)
• Definition
• Characteristics
• Needs
• Applications
• Enabling Technologies

Unit 7 : Websites Development
(Develops websites incorporating multimedia components)

1. Explores the arrangement and the composition of websites to organize pages and contents
• Contents of a website
• Home page
• Link page
• Building blocks of a web page
• Text, graphics, audio, video, animation
• Hyperlink
• Organization of contents
• Layout, frames, lists, tables
2. User requirements (multimedia contents) for web pages
• Defining the objectives of a website
• Contents to be displayed
3. Uses HTML to create web pages
• Introduction to Hyper Text Markup Language
• Basic HTML tags of a web page
• Page definition
• <html>, </html>
• Head section,
• <head></head>
• <title></title>
• Body section
• <body></body>
• Background color
• Text formatting
• <h1>…<h6>tags
• <p></p>
• <br/>
• Underline, bold, italic
• <font:></font>
• Size and color
• Adding comments
• Lists
• Ordered lists
• Unordered lists
• Multimedia objects
• Image
• Audio
• Video
4. Uses authoring tool to create web pages
• Introduction to web authoring tools

Unit 8 : Application of ICT
(Uses ICT efficiently and effectively to be successful in life)

1. Application of ICT
   (Explains the contribution of ICT towards national development)
• Education
• Learning / Teaching Process
• Learning Management System
• School Management System
• Health
• Investigation tools such as MRI scan, CAT scan etc
• Simulations in medical education
• Tele-medicine
• Agriculture
• Linking rural agricultural communities
• Communicating with the administration
• Meteorological Information
• Computer controlled devices
• E- Business
• Travel
• Online shopping
• Bank (ATM, Credit Card)
• On-line Employment
• E – Governance
• Issuing of identity cards, driving licence and passports
• Issuing birth, marriage, death certificates
2. Seeks ICT career opportunities and paths to suit one’s life
• Career opportunities related to ICT profession
• Software Engineer
• Software Quality Assurance Engineer
• Business Analyst
• IT Project Manager
• Graphic Designer
• Software Architect
• Quality Assurance Leader
• Technical Leader
• Network Administrator
• Database Administrator
• Computer Application Assistant
• IT Manager etc
3. Makes safe use of ICT with awareness on relevant issues
• Ethical and legal Issues
• Cyber crime
• Privacy
• Piracy
• E- Laws
• Sri Lanka Computer Emergency Readiness Team (SLCERT)
• Unauthorised access
• Ethical behaviour on cyberspace
• Cyber stalking
• Intellectual property (patent, copy right)
• Plagiarism
• Blackmail
• Ethical and legal issues in social media
• Inappropriate materials
• Security
• Hardware protection
• Physical protection
• UPS
• Surge arresters
• Environmental protection
• Dust, Humidity, Sunlight, Heat
• Protection from natural disasters
• Software protection
• Anti threat software
• Firewall
• Precautions in using internet
• Health & Safety
• Repetitive Strain Injury (RSI)
• E-Waste and green computing

Grade - 11 ICT Past Papers

Grade - 11 ICT Past Papers here...

Grade - 11 ICT Unit Questions

Grade - 11 ICT Unit Questions here...

Grade - 11 ICT Notes

Grade - 11 ICT Notes here...

Grade - 11 ICT Syllabus

Information Communication Technology (Grade 11)
The syllabus given here is based on competency levels. Grade 11 ICT is taught as a continuation of Grade 10 ICT. Therefore the Unit starts from 10.

Unit 10 : Programming
(Writes programs to solve problems)

1. Analyzes the problem
• Identification of inputs and outputs
• Identification of possible alternate process steps
2. Control structures in developing algorithms to solve problems.
• Introduction to algorithms: purpose
• Control structures for developing algorithms
• Sequence
• Selection
• Iteration (Repetition)
3. Different tools to present algorithms
• Tools for developing algorithms
• Flow charts
• Pseudo codes
• Conversion of flowcharts into pseudo codes
4. Data types in programming
• Identifiers, reserved words and key words in a computer programming language
• Variables and constants in computer programming
• Description of data types
• Purpose of data types
• Use of meaningful names for identifiers
• Basic Data Types:
• Numeric (integer, floating point)
• Character
• Logical
5. Operators in programming
• Purpose of operators
• Basic operators
• Arithmetic operators
• Comparison operators
• Logical operators: AND, OR, NOT
• Operator precedence
• Expressions
6. Programs involving selection control structure
• IF-EndIf and If-Else-EndIf statement
• Use of switch/case when single variable has multiple conditions
• Conversion of flow charts into pseudo codes and subsequent coding into a programming language
7. Programs involving basic iterations.
• Use of iterations (repetitions) in:
• Cases where the number of iterations are known
• Cases where the number of iterations are unknown
• Checking of the condition for iterations
• Beginning of the iteration
• End of the iteration
• Conversion of flow charts into pseudo codes and subsequent coding using a programming language
8. Programs with nested control structures
• The purpose of using nested control structures
• Use of control structures within another control structure
• Selection within selection
• Iteration within iteration
• Iteration within selection
• Selection within iteration
• Conversion of flowcharts into pseudo codes and subsequent coding into a programming language
9. Programs using one dimensional arrays
• The purpose of the use of arrays
• Definition of the one dimensional array
• Properties of an array
• Index
• Contiguous locations
• Random access
• Array Operations
• Declaration
• Accessing values
• Assignment of values
10. Structures programs through the use of subprograms
• The purpose of the use of sub-programs
• Improvement of code reusability,
• Readability , ease of testing
• Maintainability
• Types of sub-programs: value turning and not returning
• Structuring of programs using sub-programs
• Development of basic programs with a single sub-program
11. Evolution of programming languages
• Low-level languages
• Machine language
• Assembly language
• High-level languages
• Types of high-level languages:
• Procedural vs Declarative
• Structured vs Object oriented
• Programming vs scripting
• Methods used to convert source code to machine code
• Interpreters
• Compilers Testing and debugging

Unit 11 : System Development Life Cycle
(Explores the Systems Development Life Cycle of information system development)

1. Concept of information system
• Definition of a system
• Components of a system
• Input
• Process
• Output
• Manual systems
• Computer based systems
• Information systems
• Importance of Information in decision making
• Inputs, outputs, dataflows and processes
2. Systems Development life cycle
• The system development lifecycle
• Identification of requirements
• Design of the solution
• Implementation of the solution
• Testing of the solution
• Deployment of the solution
• Maintenance of the system.
• Difference between phased system development life-cycle and iterative increment life-cycle

Unit 12 : The Internet and the Electronic Mail
(Internet for information search and communication effectively)

1. Internet to access information
• Introduction to the Internet: URL, IP address and domain names.
• Client-server operation: Bi-directional information flow between browser and the server
• Functions of the Internet:
• E-mail, WWW, ftp, remote access, filesharing, streaming of media, cloud computing, search engines.
• Domain name server and its purpose
2. Internet for communication
• e-mail accounts:
• Sending and receiving mails- to, from, bcc and cc, attachments, subject
• Instant messaging services
• Video-based communication
• Social media networking

Unit 13 : Use of Multimedia
(Develops Multimedia contents to express ideas effectively)

1. Still graphics using suitable graphic software
• Digital image elements: pixel, resolution, size, color
• Image capacity and compression: lossy formats and lossless formats
• Image types: raster and vector
• Graphic types: raster and vector
• Working knowledge of graphic software to perform the following basic operations
• Open, save and edit
• Importing images
• Sizing and transformation
• Selections, cut, crop, replace
• Working with layers
• Text editing and effects
2. 2D animations using suitable 2D animations software
• Animation basics: Layers, frames, timing, frame rate
• Geometrical objects and shapes
• Frame types: frame, key frame, initial frame, destination frame, blank key frame.
• Animations
• Frame by frame animation
• Basic Tweening
• Publishing
3. Edit Audio and video contents using suitable software
• Recording audio content.
• Editing (extracting a relevant segment from original content)
4. Multimedia contents integration
• Integration of background images with animations
• Integration of audio and video

Unit 14 : Web Designing Using Multimedia
(Develops websites incorporating multimedia technology)

1. Structures information for development of websites
• Contents for websites
• Analysis of the purpose and the audience
• Organization of the content/messages
• Design of the layout and structure: scheme, color, font.
• Selection of mediaassets
2. HTML basics
• Difference between hypertext and normal text.
• Features of HTML
• HTML document structure – Head, Title, body
• HTML basics
• Line and paragraph breaks
• Text: format and color
• Insertion of images
• Use of hyperlinks
• Lists
• Tables
3. Develops web sites using web development tools
• Web authoring tools
• Text Formatting
• Page Layout
• Use of Multimedia building blocks: text, graphics, audio and video
• Hyperlinks
• Methods of web development
• Static vs dynamic webs
• Content managed web development
• Content Management Systems (CMS)
• The purpose of the process of CMS based web development
• Work-flow and roles in CMS
• Content creation, editing, publishing, and use
• Roles: Creator, editor, publisher, administrator, user
4. Preparedness to publish web sites
• Internet Service Providers for Web hosting
• Maintenance of a website

Unit 15 : Information and Communication Technology and Society
(Compares and contrasts benefits and issues related to ICT in society)

1. Contribution of ICT to the health sector
• ICT in Health services
• Tele Medicine
• Tele monitoring
• Computer controlled medical equipment
• Computer Axial Tomography (CAT) scanner
• Magnetic Resonance Imaging
• Maintenance of medical history records.
• Clinical history
• Medication
• Test reports
2. Contribution of ICT to education
• ICT Assisted Learning (elearning)
• Interactive teaching and learning material
• Web-based learning
• Learning Management Systems (LMS)
• School Management Information Systems
3. Contribution of ICT to agriculture
• Computer controlled agricultural equipment : Green houses
• Information searching on agriculture
• Virtual competitive market for agricultural products
• Optimization of agricultural productivity
• Detection and control of pests
• Optimization of fertilizer use
• Weather prediction
4. Usage of ICT in different industries
• Architecture: Computer Aided Design(CAD)
• Manufacturing - Computer Aided Manufacture (CAM)/Computerized machines in production
• Production – Robotic
5. Contribution of ICT to Business
• e-Business
• Internet based (on-line) shopping
• Internet based (on-line) Share market transactions
• Safety measures
• Advertising
• Outsourcing ITBusiness Process (IT BPO)
6. Contribution of ICT to Entertainment
• Movies and cartoon production
• Digital sound editing
• Games
• Simulations
7. Issues related to ICT with respect to ethical and legal aspects
• Legal Issues
• Data theft
• Unauthorized access to systems
• Intelligent property: copyright, patents and piracy.
• Privacy
• Forgery
• ICT legislation framework in Sri Lanka
• Ethical issues: Fair use, plagiarism
8. Issues and precautions related to ICT infrastructure protection
• Physical Security
• UPS
• Hardware firewalls
• Restricted access via door-locks
• CCTV surveillance
• Surge protectors
• Logical Security
• Passwords
• Software firewalls
• Backups
• Protection against malware: spam, virus, key-loggers
• Environmental factors
• Dust
• Humidity
• Temperature
• Institutions for information security of Sri Lanka
9. Health and safety issues inherent in the use of ICT
• Ergonomics and Health issues
• Repetitive Strain Injury: eye-strain, backaches
• E-waste: Hazardous elements and its impact on the environment.
• Safe disposal and destruction of electronic equipment
10. Issues associated with ICT and society
• Digital divide
• Digital bridge
• De-skilling
• Techno-rich employment
• Equal Opportunities
• Misuse of ICT and precautions to be taken (social media)

Grade - 10 ICT Past Papers

Grade - 10 ICT Past Papers...

Grade - 10 ICT Unit Questions

Grade - 10 ICT Unit Questions here...

Grade - 10 ICT Notes

Information Communication Technology (Grade 10)

Unit 1 : Data and Information
Unit 2 : Fundamentals of a computer system
Unit 3 : Data Representation Methods in the Computer system
Unit 4 : Logic Gates with Boolean Functions
Unit 5 : Operating Systems
Unit 6 : Word Processing
Unit 7 : Electronic Spreadsheet
Unit 8 : Electronic Presentations
Unit 9 : Database

Grade - 10 ICT Syllabus

Information Communication Technology (Grade 10)
The syllabus given here is based on competency levels.

Unit 1 : Data and Information
(Investigates the place of the computer in the world of information)

1. Investigates the contribution of ICT towards national development
• Definition of ICT
• Application of ICT in the society
• e-government, agriculture, education, health, industry, entertainment
2. Investigates the computer as a system for converting data into information
• Components of a system
• Difference between data and information
• Data as input and information as output
• Processing as the method for converting data into information
3. Explores the evolution of computers to identify its major developments
• Computer generations
• Evolution of processor technology
• Vacuum tubes
• Transistors
• Integrated circuits: LSIC,VLIC
• Improvements in system characteristics
• Size
• Capacity
• Speed
• Accuracy
• Efficiency

Unit 2 : Fundamentals of a computer system
(Selects and uses computer hardware)

1. Classifies computers using a variety of methods
2. Explores computer systems by function
• Functions of a computer and its peripherals
• Input
• Processing
• Output
• Storage
• Communication
3. Identifies and connects basic peripherals to the computer
• Basic computer components: keyboard, mouse, system unit and monitor
• Ports
• PS/2 port
• Serial port
• Parallel port(obsolete)
• USB port
• RJ 45
• Video port & HDMI, Audio(mic, speaker)
4. Uses the basic block diagram to demonstrate the computer system
• Flow path
• Data and instruction signals
• Control signals
5. Investigates benefits and concerns of computer networks for optimal communication
• Purpose of computer networks
• Data communication
• Resource sharing
• Components of a network
• Network Interface Card
• Internal and external devices
• Transmission media: guided and unguided
• Network cables: twisted pair, co-axial, fiber optics
• Modem, hub, switch, router
• Network operating system
• Types of computer networks: LAN,MAN,WAN
• Advantages and disadvantages of networks

Unit 3 : Data Representation Methods in the Computer system
(Investigates the methods used to represent data in computer systems)

1. Uses the binary number system to represent data in computer systems
• Methods of data representations
• 1 and 0 to represent two states
• Binary number system
2. Converts decimal numbers to Binary, Octal and Hexa Decimal
• Number systems: Decimal, Binary, Octal, Hexa Decimal
• Methods for number systems conversions
3. Converts Binary numbers to Decimal, Octal and Hexa Decimal numbers and vice versa
• Methods for conversions (positive integers only)
• Binary to Decimal
• Binary to Octal
• Binary to Hexa Decimal
4. Determines the capacity of data storage
• Units of measurement
  Bit, Byte, Kilo Byte, Mega Byte, Giga Byte, Tera Byte
• Order of capacities of different storage devices:
  Cache, RAM, ROM, hard disk, compact disk, USB drives & magnetic tapes
5. Explores coding systems in computers
• BCD
• EBCDIC
• ASCII
• Unicode

Unit 4 : Logic Gates with Boolean Functions
(Uses Boolean logic to work effectively with logic gates)

1. Identifies basic logic operators and draws truth tables to illustrate their functions
• Operators: AND, OR, NOR, NAND,NOT
• Introduction to Truth Tables (maximum of three inputs)
2. Applies concepts of Boolean logic to find solutions to simple day-to-day life problems
• Design of logic for simple real world applications.
• Alarm systems
• Selection criteria

Unit 5 : Operating Systems
(Works effectively with Operating Systems)

1. Explores operating systems by type, functions, benefits and concerns
• Introduction to OS
• Evolution of computer/human interface
• Types of operating systems: single user, multi user, multi tasking, real time
• Functions of the OS: user interface and resource management
• Benefits of the OS
• Utilities of an OS: Partitioning, Formatting, Defragmentation
2. Handles files and folders in Operating Systems
• Introduction to the files system
• Drives
• Folders
• Files and file extensions
• File and folder operations

Unit 6 : Word Processing
(Uses Wordprocessing Software to Solve Day-to-day problems)

1. Explores the concept and features of wordprocessing
2. Performs basic tasks in wordprocessing software
• Functions of wordprocessing software
• GUI of wordprocessing software
3. Uses different types of formatting in wordprocessing
• Formatting text
• Graphics: Insertion and formatting
• Shapes : Insertion and formatting
4. Manipulates table feature in wordprocessing software
• Insertion of tables
• Column width and height
• Deletion, insertion, splitting and merging of cells
5. Creates and prints documents
• Spelling and grammar checking
• Find and replace of text
• Page setup: paper size, margins, orientation and selection of printers
• Print options: copies and page range
6. Uses the Mail Merge facility
• Document types
• Common document
• Source data

Unit 7 : Electronic Spreadsheet
(Uses Spreadsheet to solve simple statistical problems)

1. Explores a Spreadsheet to identify its basic features and functions
2. Moves around the worksheet to gain hands on experience of data entry
• Introduction spreadsheets
• GUI of spreadsheet software
• Worksheet, columns, rows and cells
• Moving around worksheet.
• Data entry (label, number, formulae)
3. Performs basic mathematical operations
• Simple calculations using values and operators (+, -, *, /,^)
• Simple calculations using cell addresses and operators (+, -, *, /,^)
4. Uses inbuilt functions for calculations
• SUM, AVERAGE, MAX, MIN, COUNT
5. Formats a worksheet
• Font, Font size, Boldface, Italic etc.
• Alignment (centre, left, right, justify)
• Decimal places (increase and decrease)
6. Uses relative versus absolute cell references appropriately
• Absolute and Relative cell references
7. Creates charts using Spreadsheets to explain data
• Charts: chart type, chart options
• Chart types: Bar, column, line and pie

Unit 8 : Electronic Presentations

1. Produces effective presentations integrating multimedia
• Introduction to presentation software.
• Changing background, slide layout, slide designs.
• Inserting text and multimedia
2. Applies suitable animations to enhance the quality of presentations
• Slide transitions
• Custom animations

Unit 9 : Database
(Develops simple databases to elicit information)

1. Develops simple databases to elicit information
• Introduction to databases.
• Definition of a database.
• Advantages of databases.
• Features of databases: Absence of redundancy, Efficiency, Accuracy, Consistency, Security, Validity, Simplicity.
• Manual and electronic databases: comparison and contrast.
• Introduction to Relational Databases: Tables, records, fields, key fields
2. Creates a simple database with a single table, manually
• Field name, unique field, data types, field size
3. Converts a manual database into electronic media
• Field name, data types, field size, Primary key, Field properties
4. Design a simple relational database
• Tables, fields and key fields: Primary key, foreign key, relationships
5. Uses DBMS software to create relational databases
• Creation of a database
• Identification of primary and foreign key
• Creation of relationship between tables
6. Uses forms to view and update data
• Form design
• Manipulation of properties of a form
• Insertion of controls: Delete button
7. Creates Queries to extract information
• Design of queries using query tool without using SQL structure.
• Use of criteria.
• Sorting of records
8. Creates reports to present information
• Use of report Wizard
• Printing of reports