S.3 ICT FOR NEW CURRICULUM

TERM 1

TOPIC 9: WORD PROCESSING II                                            48Periods

THEME: DATA MANAGEMENT & SHARING

Competency: The learner uses advanced word processing features to enhance document outlook.

LEARNING OUTCOMES

The learner should be able to:

1. Explain the effects of various advanced tools and features of a word processor (k, u).
2. Use advanced tools and features of a word processor to format and edit documents (s, v)

LEARNING ACTIVITIES

• Research about various advanced word processing features (footnotes, mail merge, paragraph, text columns) and how they affect document appearance. (QTNS)
• Work in groups to choose a topic or topics and write about it in form of a school magazine (about 4 pages). (PRAC)
• Ensure that the article has the following characteristics: – Images at different points with text wrapping around them in different ways. – Some of the information in tabular form – Use footnotes and end notes – Some text in multiple column layout – A watermark – The document is secured with a password – Page numbers in both Arabic and Roman numerals within the same document. – A list of figures and tables and a table of contents for the entire document. (PRAC)
• Write and send a personalized letter to the parents of 10 (fictional) selected students informing them of their children’s performance (use mail merge) (PRAC)

TERM II

TOPIC 10: ELECTRONIC SPREADSHEET II                  32Periods                          

THEME: DATA MANAGEMENT & SHARING

Competency: The learner processes data using advanced spreadsheet features for quick and easy interrogation.

LEARNING OUTCOMES

The learner should be able to

1. Explain the effects of various advanced tools and features of a spreadsheet (k,u).
2. Use advanced tools and features of a spreadsheet to process and present data.(s,v)

LEARNING ACTIVITIES

• Enter data provided in a table and: – Generate bar / column, pie and line charts – Work with chart formatting; title adjustment, positioning, legend and data label formatting. – Use varying scales on graph axes. – Customise chart appearance (e.g. colour, design)
• Load a mark sheet with at least 20 (fictional) students and 3 subjects, e.g. Maths, English, History populated with marks out of 100. – Filter the data in various ways, e.g. students who scored more than 30% in Maths, between 25 and 50 in English. – Work with the functions of IF, Sumif, CountIf, Rank, Vlookup and HLookup (up to 4 outcomes for nested functions). – Reference using absolute/ relative/ mixed referencing. – Toggle between formula and value views. – Set print area. – Deliberately create the following errors, explain and fix them: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!, ####

TOPIC 11: ELECTRONIC PUBLICATION                                             16Periods

THEME: PUBLICATIONS

Competency : The learner uses desktop publishing software (e.g. MS Publisher) to design and produce simple publications such as business cards, flyers, calendars, invitation cards, letterheads and certificates.

LEARNING OUTCOMES

The learner should be able to:

1. Explain the concept of electronic publishing. (k, u, v)
2. Use the electronic publishing application features to prepare a publication. (u, s,v)

LEARNING ACTIVITIES

• Discuss the meaning of electronic publishing. (QTN)
• Identify publications in their school and other organisations and research about techniques involved in electronic publishing.
• Research about different examples of electronic publishing software. (QTN)
• Navigate through a publication software suite to discover the different templates provided.
• Open electronic publishing application software.
• Study the application interface; take note of and practice using the various features/ tools.
• Explore the features of a pre-type set hardcopy document with various formats.
• Use a template and blank page to create a publication, customise the templates and add content (shapes, images and text) and produce a publication, also adjusting measurement units (inches, centimetres). (PRAC)
• Save a publication to a given location.
• Load an existing publication and format the publication to a desired style, adjusting the shapes, sizes, colour of graphics, objects and text, applying borders to the publication or parts of the publication and adjusting the publication background.
• Effectively make use of the spaces in a publication

TERM III

TOPIC 12: DATABASE MANAGEMENT SYSTEMS                         48Periods

THEME: DATA SHARING & MANAGEMENT

Competency: The learner uses a Database Management System (DBMS) programme (e.g. MS Access) to manage data.

LEARNING OUTCOMES

The learner should be able to:

1. a) Explain the concept of databases. (k, u, v)
2. b) Use tools and features of a DBMS to manipulate data. (s, v)

LEARNING ACTIVITIES

• Research and report on: a) commonly used Database Management Software (e.g. MS Access, Oracle, MySql) and their features b) how and why database management systems are used in businesses, the public sector and the home, contributing their thoughts to class discussion (e.g. family records, e-library management system, students’ records, government records, bank account records, hospital patient details, airline booking systems) (QTN)
• Identify records and fields in the database of class list, address book, library catalogue.
• Add some information to selected databases (records and fields). Launch database software and create and save databases, identifying the various database objects such as tables, forms, queries, reports. (PRAC)
• Determine an appropriate data type for each of the fields identified and respective field properties.
• Apply simple validation rules, validation text and input mask
• Enter data in a table to create a form and use it for data entry.
• Query the database, retrieving data in various form views and create query objects to retrieve specific records and or fields.
• Use the following operators in a query: = (Equal),<> (Not equal to), < (Less than),<= (Less than or equal to), >(Greater than), >= (Greater than or equal to) NULL and NOTNULL.
• Practice generating reports using various approaches: design view, report view and generate automatic calculations in various database objects.
• Create a relational database of up to two tables.

Print objects to required layouts and formats