Welcome year 12 to your new google site for the year. The page will feature a blog style recap of lesson content, split across each topic, including links to other resources, copies of assessment tasks and an outline of what to expect for the year.
WEEK 7: Centralised & distributed databases
SQL FOR DUMMIES
week 7: searching, Selecting, Sorting
ACTIVITY:
|
Students Learn About:
sorting a database – selecting data from a relational database using Query by Example (QBE) and Structured Query Languages (SQL) commands, including:
|
week 6: storage & retrieval
ACTIVITY....
|
Students Learn About:
database management systems (DBMS) including:
on-line and off-line storage storage media including:
backup and security procedures |
Created with Haiku Deck, the free presentation app
week 5: Hypertext/hypermedia
activity...
- Create a storyboard for a simple hypertext/hypermedia system that is appropriate for implementation using basic HTML
- Using a text editor, write HTML code to create a simple web page containing 3 or 4 screens. The page should include text, images and videos.
- Use a web page creation application (Dreamweaver) to create a simple web site.
Students Learn About:
the logical organisation of hypermedia, including:
tools for organising hypermedia, including:
|
Students Learn To:
compare & contrast hypermedia & databases for organising data design & develop a storyboard to represent a set of data items & links between them construct a hypertext document from a storyboard use software that link data, such as:
|
week 4: Normalising Databases
Students Learn About:
non-computer methods of organising including:
computer based methods of organising, including:
the advantages and disadvantages of computer based and not-computer based organisation methods the logical organisation of flat-file databases, including:
|
Students Learn To:
choose between a computer based or not computer based method to organise data, given a particular set of circumstances identify situations where one type of database is more appropriate than another create a data dictionary for a given set of data demonstrate an awareness of issues of privacy, security and accuracy in handling data. |
week 3: Relational Databases
Students Learn About:
the logical organisation of relational databases, including: - schemas as consisting of:
- user views for different purposes data modelling tools for organising databases, including: - data dictionaries to describe the characteristics of data including:
- normalising data to reduce data redundancy |
Students Learn To:
identify situations where one type of database is more appropriate than another represent an existing relational database in a schematic diagram create a schematic diagram for a scenario where the data is to be organised into a relational database modify an existing schema to meet a change in user requirements choose and justify the most appropriate type database, flat-file or relational, to organise a given st of data. create a simple relational database from a schematic diagram and data dictionary populate a relational database with data describe the similarities and differences betweem flat-file and relational databases create a data dictionary for a given set of data create documentation, including data modelling to indicate how a relational database has been used to organise data |
week 2: Flat file databases
Students Learn About:
non-computer methods of organising including:
and non-computer based organisation methods the logical organisation of flat-file databases, including:
|
Students Learn To:
choose between a computer based or non-computer based method to organise data, given a particular set of circumstances identify situations where one type of database is more appropriate than another create a data dictionary for a given set of data demonstrate an awareness of issues of privacy, security and accuracy in handling data |
week 1: Information Systems & Databases
Students Learn About:
the characteristics of an information system, namely:
the different types of and purposes for information systems, including systems used to:
school databases holding information on teachers, subjects, classrooms and students. the RTA holding information on cars & licensed drivers. video stores holding information on borrowers and videos |
Students Learn To:identify the type and purpose of a given information
system represent an information system using a systems representation tool
technology for the given examples of database information systems describe the relationships between participants, data/information and information technology for the given examples of database information systems |