Areas to be covered in
Form 4 Junior Lyceum ( Syllabus For ICT J.L.)
|
|
|
1. Module 1 – Basic Concepts – Knowledge module
1.4 BC4
1.1.1. Memory (secondary) storage devices – internal/external hard disk, zip disk, CD ROM, floppy disk, data cartridges – comparison in terms of speed, cost, capacity
1.1.2. The purpose of formatting a disk
1.1.3. Types of memory – Ram and Rom – their uses
1.1.4. Measuring memory – bit, byte, Kb, Mb, Gb, Tb.
1.1.5. Types of software – distinction between system and application
1.1.6. Understand the reason for software versions.
1.1.7. Application software – uses of common software – WP, SS, DB, accounting, DTP, web browsing
1.1.8. Operating system software – main functions of OS, the GUI, advantages of GUI, examples
Suggested Tasks:
Project on
different storage devices
Different
types of application software and their uses
2. Module 5 – Databases
– Skills module
5.4 DB1
5.1.1
Use and
advantages of DB, structure of a database (tables, records, fields, datatypes)
5.1.2 Open application, the DB interface with default settings, exit
5.1.3 Show/Hide Toolbars
5.1.4 Using help functions
5.1.5 Database concept – file, record, field, item, key field.
5.1.6 Open existing database – demonstration of concept, navigate through table
5.1.7 Modify/update database – insertion of new records, deletion of unwanted records, amending of existing records, saving to a hard disk/floppy disk
5.1.8 Viewing modes – datasheet (table), form, report, query
5.1.9 Filter using given criteria or common logical operators and sorting
5.1.10 Setting up for printing – print preview, printing of datasheet and selected records
Suggested Tasks:
Comparison
between manual and electronic databases
Give
specific examples of databases in society (e.g. hospitals, insurance,
banking….) including a brief description highlighting their advantages
Search in Help for a specific topic
Other practical tasks are integrated within the module specifications
3. Module 6 – PowerPoint
– Skills module
6.4 GR3 (Presentation)
6.3.1 Open several presentations – cut, copy, paste within open presentations
6.3.2 Using help functions
6.3.3 Modify preferences in application such as user name, default directory
6.3.4 Drawing objects – different types of lines, modify line width, moving lines, changing line colour – adding other shapes (boxes, circles, freeform), colours and fill effects, outline type – rotating, flipping, shadowing, grouping and ungrouping, layering
6.3.5 Slide duplication and re-ordering slides
6.3.6 Text build effects, apply pre-set animation effects, changing pre-set animation effects, slide transition
6.3.7 Running slide show from beginning, from any
slide. Hide slides, timing slides
6.3.8 Printing
Suggested Tasks:
Prepare a presentation of 4 slides
and give one slide transition effect to the 4 slides. Type the title
“AutoShapes” to appear in all 4 slides. - give subtitles “Basic Shapes”, “Block
Arrows”, “Stars and Banners”, “Flowcharts” to the slides. In each slide draw
related shapes from AutoShapes and fill with colour from the More Fill Colors and Fill Effects.
Insert a clipart in a slide, copy and
paste, rotating the image slightly, then flip the image to face the other side.
Group the 3 images to form 1 object. Give a title to the slide and give a text
build effect
Make up a 4 slide presentation on a
subject related to the environment, give a single slide transition effect and
animate the slide titles and pictures.
Open a new blank slide and draw 4 thick lines with the line tool to form a square. Animate the 4 lines with the wipe right, wipe up, wipe left and wipe down effects to simulate the drawing of the square.
Other practical tasks are integrated within the module specifications
6.4
GR4 (Presentation)
6.4.1 Create and modify an organisation chart
6.4.2 Create charts – pie, bar, line; edit, move, duplicate, delete charts
6.4.3 Edit and use a slide master, insert objects, numbering the slides, using footers.
6.4.4 Output format for distribution – overhead, handout, 35mm, on-screen show – Adding notes for presenter
6.4.5 Save as RTF, template, image file format, software type/version
6.4.6 Setting up for printing – print in various views and output formats
Suggested Tasks:
Draw a
storyboard type of chart representing a simple 6 slide presentation from an
existing template. Indicate the titles, text, clipart and images. Label the
chart including notes on any text build effects, animation and timing.
In a blank
slide insert an organisational chart representing the school administration.
Try out the different styles and choose one. Give the boxes a shadow and vary
the fill colour according to rank. Give a title to the chart.
Make up a
4-slide presentation and insert a prepared chart from the spreadsheet data in 4
different formats: Column, Bar, Line, and Pie. Give a title to the slides.
Prepare a 4-slide presentation to display text only. Open the Slide Master and insert a date, footer and a slide number. Give the slide master a background fill. Import a light coloured graphic (or make up your own from Basic Shapes) as a background for your text.
Other practical tasks are integrated within the module specifications
4. Web pages – Skills module
7.4
INT4
(Web-Page Creation)
7.4.1 Web-authoring tool
interface
7,4,2 Planning your site,
navigation and layout
7.4.3 Insert a table – Add rows
and columns
7.4.4 Merging cells, splitting
cells, remove/apply border and fills
7.4.5 Inserting text/images in
tables (image types: e.g. JPEG, GIF, transparent GIF, animated GIFs)
7.4.6 Hyperlinks (text or images)
To
page in same web
To
bookmark on same page
To
external web page
Open
in current/in new window
To
an e-mail address
7.4.7 Use background image, change background colour
7.4.8 Edit page title
7.4.9 Open and save pages
7.4.10 Preview web site in
browser
7.4.11 Publish to the web
Suggested Tasks:
Plan a
website on paper showing intended links and navigation
Create a
web site with a minimum of three hyperlinked pages
Include
hyperlinks which open a different web site in a new window
Include a
navigation system within the created web pages
Other
practical tasks are integrated within the module specifications
|
|
|