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)
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:
(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.
(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