Zonal ICT Education Centre - Polonnaruwa

Courses Module Contents

 


Course name: - Certificate in Responsive Web Design & Development

Duration: - 120 Hours

Software used: - HTML, CSS, Bootstrap, and PHP & MySQL

Assessment Criteria: - Continues assessment during the course

                                           Final assessment at the end of course

                                           Final Website published on WWW

Target group: - For students who have done ICT at O/L

 

Levels to be achieved

Subjects content

Theory hours

Practical Hours

1.      Investigates  Responsive Web Design & Development

·        Introduction to Web design & web development

·        Introduction to Responsive web design

·        Introduction to Internet and describe services offered by Internet,

·        Explain WWW, HTTTP , URL, domain, IP address

3

 

2.       Creates a web page using basic HTML code

·        Identify the basic structure of web page

·        Planning the web page

·        Introduction to HTML

·        Introduction to Sublime Text editor

·        Creating a simple web page

·        Organizing information into web page

3

4

3.       Investigates different tags and formats in HTML

·        Enhancing web pages using different tags and formats

·        Heading, Paragraph, fonts, colors, links, images, tables, lists, br , insert audio & video

 

 

3

4

4.      Explores the concept of styling web page using Cascading style Sheets (CSS)

·        Introduction to CSS - CSS describes how HTML elements should be displayed.

·        Identify syntax, selectors, comments, colors, backgrounds, borders, margins, height/width, text, fonts, icons, links, tables, image gallery, forms,

·        Identify CSS advanced features like rounded corners, border images, gradients, text effects, web fonts, buttons,

 

4

6

5.      Create web site  using HTML and CSS

·        Use CSS features that previously learnt and organize a complete web site using HTML

4

15

6.      Identifies the concept of Responsive web design

·        Introduction to Bootstrap - Most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites

·        Identify Grid system of Bootstrap

·        Identify typography, tables, images, jumbotrons, alerts buttons, drop downs, panels, navbar, forms, carousel,

3

6

7.      Install XAMPP and Create database using MySQL

·        Introduction XAMPP server and install

·        Introduction to concept Database Management System

·        Introduction to MySQL

·        Identifies SQL commands

·        Explores the phpMyAdmin

·        Create a database

3

6

8.      Create dynamic web pages using PHP and MySQL

·        Introduction to dynamic web page

·        Introduction to PHP

·        Identifies variable, arrays, control structures, functions, database connectivity

·        Embeds PHP codes to web page

3

6

9.      Create PHP codes to save data into database and retrieve data and display on web page

·        Create database

·        Connect database with PHP

·        Design a form with inputs elements (Type, name, value), text inputs (Password), radio buttons, check boxes, submit buttons, action attribute, method attribute,

·        Saving data into database

·        Retrieve data and display on web page

3

15

10.   Web hosting , domain registration and upload web into Server

·        Introduction to web hosting & Domain Registration

·        Compare Web Hosting sites

·        Select hosting providers and plans

·        Buy domain names and hosting plans

·        Upload your site to  server

3

3

11.   Maintain and update using CPanel file Manager

·        Explores the CPanel

·        Hands on experience with File manage, phpMyAdmin and MySQL database

2

3

12.   Final written test and practical test

 

 

6

13.   Student final  website project

 

 

15

 

Course name: - Certificate in Certificate in Graphics & Multimedia

Duration: - 80 Hours

Software used: - Adobe Photoshop, Adobe Flash, Audacity, and Windows Movie Maker

Assessment Criteria: - Continues assessment during the course

                                           Final assessment at the end of course

                                           Final Project

 

Levels to be achieved

Subjects content

Theory hours

Practical Hours

1.      Investigates Multimedia Technology

·        Introduction to Multimedia technology

·        Explores fundamentals of graphics – Pixel, Resolution, Size , Color, Bit depth, PPI, DPI

·        Identifies to Color models – RGB, CMYK, Grayscale, Bitmap

·        Identifies different graphics file formats –JPEG, GIF, BMP etc.

·        Explores graphic compression - Lossy  compression, Lossless  compression

·        Explores graphic types – Raster, Vector

 

3

 

Photo Editing - Adobe Photoshop

 

2.      Identifies the graphic editing Software

·        Introduction to Adobe Photoshop

·        Explores the Photoshop application interface

·        Start the application & create Photoshop file

·        Explores the tools – Move tool, Lasso tool,  Zoom too, Magic wand tool, Gradient tool, Dodge tool, Burn tool, Healing brush too, Patch tool, Clone Stamp tool etc.

 

 

3

6

3.      Uses layers in image editing

·        Uses layers in image editing

3

6

4.      Uses graphic tools to create and edit still images

·        Basic editing tools and image enhancing tools – Transform tools, Adjustment with Levels, Curves, Color balance, Brightness & Contrast etc.

·        Use Filters.

·        Understands file formats and Save options

 

4

6

 

2D Animation – Adobe Flash

5.      Uses layers in image editing, Timeline, Key frames, 

·        Uses layers in image editing

·        Explores Timeline, Frames such as Key frame, Blank Frame

3

6

6.      Uses tools to create animations

·        Introduction to types animation - Motion Tween, Shape Tween, Frame by Frame, Motion Guide animation etc.

·        Use methods of  Onion skin and Easing with animation

·        Animation file types.

3

6

7.      Uses advanced animation techniques

·        Insert sound, video clips

·        Introduction to Scripting

3

15

 

Audio Recording And Sound Editing - Audacity

1.      Identifies the tools in Audio Recording And Sound Editing software

·        Introduction to Audacity

·        Identify features of Audacity

·        Explores the Audacity application interface

·        Start the application & create Audacity file

·        Explores the tools – Selection Tool, Envelope tool,   Draw Tool, Time Shift Tool, Multi tool etc.

                                                               

3

6

2.      Uses tools to edit a sound file

·        Using audio control buttons

·        Record audio in Audacity

·        import audio files into Audacity

·        How to remove noise from audio

·        How to extract a selection from audio

·        How to amplify an audio selection

·        Understand Audio formats

 

2

4

3.      Adds effects to a sound file

 

 

·        Explore Effects menu – Bass Boost, Changing Pitch, Change speed, Change tempo, Echo, Equalization, fade in, Fade out, Noise removal etc.

·        Importing and combining tracks and Exporting (saving).

·        Use Lame encoder (Plugins) to convert to MP3 format

2

4

 

Video Editing – Windows Movie Maker

1.      Identifies the tools in Video Editing software

·        Introduction to Windows Movie Maker

·        Explores the Windows Movie Maker application interface

·        Start the application & create Windows Movie Maker file

·        Explores the tools – Preview Monitor, Story Board, Editing Panel, Playback controls, Spilt clips etc.  

3

6

2.      Uses tools to edit a video file

·        Import video file and add Title

·        Insert  Video Transitions

·        Insert visual effects

·        How to add audio as background music

·        Adding animations

·        Adjust video  length using trimming

·        Adding Credits

·        Video rendering - process of finalizing a video file from different elements that include edited video files and special effects.

3

5

 

 

 

 

1.      Final written test and practical test

 

 

8

2.      Student final  Multimedia project

 

 

10

 

Course name: - Certificate in Software Development (JAVA, MySQL)

Duration: - 80 Hours

Software used: - Java (JDK), NetBeans & MySQL

Assessment Criteria: - Continues assessment during the course

                                           Final assessment at the end of course

                                           Final Software Project

Target group: -       For students who have done ICT at O/L

 

 

Levels to be achieved

Subjects content

Theory hours

Practical Hours

3.      Investigates  Object Oriented Programming

 

·        Introduction to Software Development

·        Introduction to Computer programing with Java

·        Explore Software Development Life Cycle (SDLC)

·        Defines Algorithm

·        Problems solving using Flow chart and Pseudo code methods

·        Analyses  Three control structures – Sequence, Selection & Repetition

·         

3

 

4.      Explores Java Programming

·        Installs java and configure

·        Set Path in Java

·        Identifies key components to basic Java syntax

·        Compile and Run program in Java

·        Analyze variables and data types

·        Identify key components of  branching statements – “if” and “switch” 

·        Construct looping  statement using “While” and “for”

 

6

8

5.      Investigates & introduces the NetBeans Platform

·        Install Oracle NetBeans software

·         Explores the NetBeans interface – Menu bar, Tool bar, Code editor, Project window, Tools palette, Properties, Navigator and inspector tab and etc.

·        Create the first project in Netbeans IDE

·        Create a Java source file

·        Adds code to the Java source file

·        How to run and save the application

·        Creates executable file  

3

4

6.      Identifies tools in palette.

·        Explores the NetBeans Palette

·        Use Swing controls- Label,Text fiels, Textarea, Button, Combo box, List, Radio buttons etc

·        Use Swing Menus – Menu bar, Menu, menu items etc.

·        Use Swing containers – Panel, tabbed pane, Toolbar etc.

·        Use Swing windows- Dialog, Frame, File chooser, Option pane etc.

3

4

7.      Develop desktop apps using NetBeans

·        Develops simple calculator

·        Develops Salary System

·        Develops Color changer system

·        Develops Password Login system

·        Develops Examination Evaluation system

·        Develops Students selection to Sport houses system

 

6

10

8.      Install XAMPP and Create database using MySQL

·        Introduction XAMPP server and install

·        Introduction to concept Database Management System

·        Introduction to MySQL

·        Identifies SQL commands

·        Explores the phpMyAdmin

·        Create a database

3

6

9.      Create Java Database Connectivity with MySQL

·        Connect database with PHP

·        Use Exam Evaluation System and save student data

·        Create  codes to save data into database and retrieve data and display

 

3

6

10.   Final written test and practical test

 

 

6

11.   Student final  Software project

 

 

16

 

 

 

Course Name: - Certificate in Advanced Office Application

Duration:- 120 Hours

Assessment Criteria:- Continuous assessment during the course

                                        Final assessment at the end of the course

1.      Syllabus

 

Unit

Number

Unit Name

Theory

Hours

Practical

Hours

Total

Hours

U01

Introduction To Computers

5

0

5

U02

Operating Systems – Windows 10

4

6

10

U03

Word Processing – MS Word 2013

9

18

27

U04

Spreadsheet – MS Excel 2013

9

18

27

U05

MM Presentation – PowerPoint 2013

6

14

20

U06

DBMS – MS Access 2013

9

18

27

 

Extra time for completing Assignments

 

4

4

Total Hours

42

78

120

 

2.      Assessments

 

ASSESSMENTS (W) Written Test & (P) Practical Test

Assessment No.

Name of the Assessment

Time (Hours)

Marks

U01A1

Assessment 1 - Introduction to computers(W)

1

100

U02A2

Assessment 2 - Operating System(W)

1

50

U03A3

Assessment 3 - MS Word 2013 (P)

1 ˝

30

U04A4

Assessment 4 - MS Excel 2013 (P)

1

30

U06A5

Assessment 5 - MS Access 2013 (P)

1

30

U03A6

Assessment 6 - Word Processing (W)

1

22

U04A7

Assessment 7 - Spreadsheets (W)

1

28

U06A8

Assessment 8 - DBMS (W)

1

30

 

Total Hours

9 ˝

 

 

3.      Assignments

 

Unit No.

Assignment Number

Description

Marks

Total

U02

U021

Files & Folders Management

50

50

U03

U031

Practical 01

06

48

U032

Practical 02

06

U033

Practical 03

06

U034

Practical 04

06

U035

Practical 05

06

U036

Practical 06

06

U037

Practical 07

06

U038

Practical 08

06

U04

U041

Practical 01

07

42

U042

Practical 02

07

U043

Practical 03

07

U044

Practical 04

07

U045

Practical 05

07

U046

Practical 06

07

U05

U051

Creating Presentation on the given topic & Presenting

100

100

U06

U061

Practical 01

08

40

U062

Practical 02

08

U063

Practical 03

08

U064

Practical 04

08

U065

Practical 05

08

 

*Total Marks = (Assessment Marks/Practical & Written) + (Assignment Marks)

Introduction to Computers

1.      Explore the basic component of a computer

1.1.   What is a computer

1.2.   Hardware

1.2.1.Input Devices, Output Devices, CPU, Memory and Secondary Storages

1.2.2.Basic Functions of a computer.

1.2.3.Connecting Peripherals to the System Unit.

1.2.3.1.            Ports (Video, USB,, HDMI, DVI and Power)

1.3.   Software

1.3.1.What is software?

1.3.2.Classification of Software

1.4.   Live ware

1.5.   Firmware

1.6.   Simple Architecture of a computer

1.7.   Classification of computers

 

Operating Systems – Windows 10

2.      Characteristics of an Operating System

2.1.   The functions of an operating system

2.1.1.The purpose of an operating system

2.1.2.Running programs

2.1.3.Basic functions of an operating system

2.1.4.Providing user machine interface (Desktop, Menu, Windows…..)

2.1.5.Correct operation procedure of a PC

2.1.5.1.            Switch on procedure

2.1.5.2.            Safety measures

2.1.5.3.            Shutdown procedure

2.1.5.4.            Memory Management

2.1.6.Disk Management (Partition, Formatting, Defragmentation, Scandisk and Disk Cleanup)

2.1.6.1.            Directory and File management ( Create folders, Move, Copy, Delete, Rename)

2.1.7.File types and File Extensions

2.1.8.Resource Management

2.1.9. 

Word Processing Software

3.      The concept of Word Processing and its Features

3.1.   Introduction to word processing Features and Limitations

3.2.   Use different types of formatting in Word processing

3.2.1.Components of a Word Processing Window

3.2.2.The working environment

3.2.3.Customizing Ribbon

3.3.   Create Documents

3.3.1.Creating New Document

3.3.2.Saving a Document in a Document folder & user created Folder

3.3.3.Use Save Option and General Option in Save Dialogue Box

3.3.3.1.            Password Protection

3.3.3.2.            Embed Fonts

3.3.4.Open And Close Documents, Exit Application

3.4.   Spelling and Grammar Check

3.5.   Editing Documents

3.5.1.Copy, Move, Find & Replace, Change Case

3.6.   Formatting Document

3.6.1.Font Formatting (Type, Color, Size, Bold, Underline, Italic, Styles, Superscript, Subscript)

3.6.2.Paragraph Formatting( Indenting, Spacing, Columns & Drop Cap, Bullet & Numbers, Borders & Shading, Tab Setting)

3.7.   Tables

3.7.1.Creating Tables (Drawing ,Pen& Eraser and Inserting)

3.7.2.Inserting & Removing Columns & Rows

3.7.3.Merging &and Splitting Cells

3.7.4.Changing Column width and Row Height

3.7.5.Cell Alignment and Auto fit

3.7.6.Moving Table

3.8.   Insert and Drawing Objects

3.8.1.Shapes, Pictures Charts, Symbols, Equation, Screenshot, WordArt, Date & Time

3.8.2.Formatting Objects

3.9.   Header and Footer

3.9.1.Insert, Remove & Edit Header

3.9.2.Insert , Remove & Edit Footer

3.9.3.Page Numbers

3.10.                  Page Layout

3.10.1.   Paper Size

3.10.2.   Margins

3.10.3.   Orientation

3.10.4.   Gutter

3.11.                  Developer Tab

3.11.1.   Using Legacy Tools

3.11.2.   Creating Fillable Forms

3.11.3.   Saving as Templates

3.12.                  Mail Merge

3.12.1.   Creating Data source

3.12.2.   Using an Existing List

3.12.3.   Merging to multiple Letters

 

Spreadsheet Software

4.      What is spreadsheet

4.1.   Identifying the concept of Spreadsheet

4.1.1.Introduction to Spreadsheet            

4.1.2.Terminology – Columns, Rows, Cells, Cell Address, Cell Range, Worksheet and Workbook

4.2.   Introduction to Microsoft Excel

4.2.1.Run MS Excel

4.2.2.Explore the working Environment

4.2.2.1.            Moving around the cells using Mouse and Keyboard

4.2.2.2.            Entering Data (Numeric Data & Alpha Numeric data)

4.2.2.3.            Delete Data in the cell

4.2.2.4.            Editing Data (Change data in a cell, Copy, Move)

4.2.2.5.            Identify the Formula Bar and the Name Box

4.2.2.6.            Entering Formula (User created)

4.2.2.7.            Change Formula

4.2.2.8.            Naming a cell Range

4.2.3.Creating, Saving, Opening Workbook

4.2.3.1.            Create workbook

4.2.3.2.            Saving Workbook

4.2.3.3.            Closing Workbook

4.2.3.4.            Opening workbook

4.2.4.Work with multiple Worksheets

4.2.4.1.            Delete a Worksheet

4.2.4.2.            Rename a worksheet

4.2.4.3.            Insert a Worksheet

4.2.5.Perform Basic Mathematical operations

4.2.5.1.            User Define Function

4.2.5.1.1.                 Addition, Subtraction, Multiplication, Division, Exponent

4.3.   Cell Reference

4.3.1.Relative Cell Reference

4.3.2.Absolute Cell Reference

4.3.3.Mix Cell Reference

4.3.4.Freezing Cells

4.4.   Using Built in Functions

4.4.1.SUM

4.4.2.AVERAGE

4.4.3.IF

4.4.3.1.            Perform with comparison operation (<, >, +, >=, <=,<>)

4.4.4.RANK

4.4.5.MIN

4.4.6.MAX

4.4.7.COUNT

4.4.8.COUNTA

4.4.9.COUNTIF

4.4.10.  VLOOKUP

4.5.  Format Cells

4.5.1.     Merge Cells

4.5.2.Column Width

4.5.3.Row Height

4.5.4.Wrap Text

4.5.5.Text Orientation

4.6.   Data Formats in Excel (Number, Dare, Time, Currency, Text……)

4.7.   Data Analysis

4.7.1.Sorting

4.7.2.Filtering (Normal & Advanced) Conditional Formatting

4.8.   Format as table

4.9.   Create Charts

4.9.1.Creating different types of charts

4.9.2.Format Charts

4.9.3.Editing Data in a Chart

4.10.                  Printing Worksheet and Charts

4.10.1.   Page Layout

4.10.2.   Print Preview

4.10.3.   Print

 

Multimedia Presentation Software

5.      Multimedia Presentation Software

5.1.   Explore the concept of Electronic Presentation and their features

5.1.1.Introduction to presentation

5.1.2.Define Multimedia and its component ( Objects)

5.1.2.1.            Text

5.1.2.2.            Images

5.1.2.3.            Shapes

5.1.2.4.            Charts

5.1.2.5.            Audio

5.1.2.6.            Video

5.1.2.7.            Animation

5.1.3.Define Multimedia presentation

5.1.4.Explore Advantages and Application of Multimedia Presentation

5.1.5.Introduction to Presentation Software

5.1.6.Explore the User Interface of Presentation Software

5.1.6.1.            User Interface

5.1.6.2.            Slides

5.1.6.3.            Slide Views

5.1.6.3.1.                 Normal

5.1.6.3.2.                 Slide Sorter

5.1.6.3.3.                 Reading

5.1.6.3.4.                 Slide Show

5.1.6.3.5.                 Out Line View

5.1.6.3.6.                 Notes Page

5.1.6.3.7.                 Slide Master

5.1.6.3.8.                 Hand Out Master

5.1.6.3.9.                 Notes Mater

5.1.7.Guidelines for creating good Presentation

5.1.7.1.            Font – Size, Color, Type

5.1.7.2.            Spelling and Grammar Check

5.1.7.3.            Slide Designs and Backgrounds

5.1.7.4.            Using suitable Animations

5.1.7.5.            Using Audio

5.1.7.6.            Slide Structure

5.2.   Create Effective Presentation

5.2.1.Design a story board to create attractive and effective Multimedia Presentation

5.2.2.Explore the following important component and functions in a Presentation software

5.2.2.1.            Slides

5.2.2.1.1.                 Slide Layout

5.2.2.1.2.                 Slide Background

5.2.2.1.3.                 Insert Slide

5.2.2.1.4.                 Delete slide

5.2.2.1.5.                 Copy Slide

5.2.2.1.6.                 Apply Design Templates

5.2.2.2.            Insert Text, Pictures, Images, Audio, Video, Charts and Shapes

5.2.2.3.            Use Animation and Slide Transition to get attention from the audience

5.2.2.4.            Use Hyperlinks, Action Buttons and Book Marks to Improve Presentation skills and save time.

5.2.2.5.            Be aware of the Keyboard Short cuts

5.2.3.Use Slide Master

5.3.   Save Presentation

5.3.1.Save Option

5.3.1.1.            Save File Types

5.3.1.2.            Embed Fonts

5.3.2.General Option

5.3.2.1.            Password Protection

 

Database Management Systems

6.      Explore the concept of Database

6.1.   Identify the Manual Database Systems

6.1.1.Explore the Objects of Manual Database

6.1.2.Create a suitable Form to get information from a Relevant source

6.1.3.Create a suitable Table to store the collected information

6.1.4.Identify the fields and records in a Table

6.1.5.Identify the key field ( Primary Key ) of a Table

6.1.6.Explore the Relationships with the Tables

6.1.7.Define a Database and its components

6.2.   Analyze DBMS software to identify its components

6.2.1.Identify Database Management Software

6.2.2.Explore IDE of DBMS Software ( MS Access )

6.2.3.Identify the Objects of DBMS software

6.2.3.1.            Tables

6.2.3.2.            Forms

6.2.3.3.            Queries

6.2.3.4.            Reports

6.3.   Create Tables using DBMS Software

6.3.1.Create a Database

6.3.2.Create Tables

6.3.3.Identify the Data Types

6.3.4.Change the properties of Fields of Tables

6.3.5.Save the Tables

6.3.6.Identify the types of views

6.3.6.1.            Design View

6.3.6.2.            Data Sheet View

6.4.   Create Forms Using DBMS Software

6.4.1.Use Forms to store data in a Table

6.5.   Make Relationships between Tables

6.5.1.Identify the Primary Key Field

6.5.2.Identify the Foreign Key Field

6.5.3.Make Relationships Between the relative Tables

6.6.   Create Queries to retrieve information according to the use of useful criteria

6.7.   Create Reports