X hits on this document

Word document

Information Processes and Technology Teaching Program - page 4 / 20





4 / 20


Timing and resources

Time: 2 weeks

Syllabus: pages 18–25 Section 8.2

Software/course specifications: pages 9–10

Texts: Heinemann IPT Prelim—G. K. Powers (chapter 6)

Syllabus outcomes

P1.1Describes the nature of information processes and information technology

P5.1Selects and ethically uses computer based and non-computer based resources and tools to process information

P6.1Analyses and describes an identified need

P6.2Generates ideas, considers alternatives and develops solutions for a defined need

Students learn to:

1.Basic features

(a)Explain the difference between a database and a database management system.

(b)Describe the advantages of electronic databases over manual databases.

(c)Create a simple flat file database.

(d)Understand and distinguish between the data structures—files, records, fields and characters.

(e)Define a database in a data dictionary—field names, data type, field size and description.

(f)Explain the purpose of a key, such as single key, composite key, primary key and secondary key.

(g)Design a table (list) to enter and display data.

(h)Design a form (record) to enter and display data.

(i)Understand when it is appropriate to use a table and a form.

(j)Open existing data from a storage medium.

2.Modifying a database

(a)Insert data into a field in a table and a form.

(b)Delete data from a field in a table and a form.

(c)Edit data by using cut, copy and paste commands.

(d)Amend the design by adding a field, deleting a field and changing a field name.

(e)Change the layout in forms (moving fields, headings, instructions or graphics) and tables (column width, rearranging columns or hiding columns).

(f)Alter the format of text in forms and tables using different fonts, styles and colour.

3.Finding information

(a)Sort data in a particular order—ascending and descending.

(b)Sort data using more than one field or level.

(c)Create a filter to view particular records.

(d)Search a database using the find or search command.

(e)Create a simple query to search a database.

(f)Apply a range of relational operators (=, <>, <, >, <=, >=) in a query including the use of wildcards.

(g)Combine simple queries using logical operators—AND, OR, NOT.


(a)Organise and present data using a report.

(b)Create a report based on a query.

(c)Position, format and sort fields in a report.

(d)Display data in different report sections, such as the report header, page header, details, page footer and report footer.

(e)Format a report using good design principles.

(f)Print a report and use the print options.

(g)Mail merge data from a database into a document created by a word processor.


Comment on topic: _______________________________________________________________________________________


Other resources used: _____________________________________________________________________________________

Date completed_________________________ Time taken_____________________ Teacher’s signature: _________________

Copyright ©  Pearson Australia (a division of Pearson Australia Group Pty Ltd)

                                                                              Sample Teaching Program

Document info
Document views70
Page views70
Page last viewedSun Jan 22 13:21:49 UTC 2017