Term+3+Files+Page


 * Term 3 Files Page**


 * **Week 1, Monday July 11th - Friday 15th July**


 * Friday 15th**, Network Aths Sports at Charlton

What do we know about databases: Undertake the following quiz:

Undertake the quizlet exercise; go to this link:

[]


 * Databases:** Learning Microsoft Access: 2010


 * Go to:** [] and work through the topic: Introduction to databases


 * Theory:** Ch 8, Data Management, [[file:ch8_data_man_1.docx]]

Access Basics, 3, Getting started in AccesssDatabase exercise used in Access Getting Started,

Access Basics, 4, Managing Databases and Objects


 * Working With Data**

5, Working with tables

6, Working with forms

7, Sorting and filtering records


 * Week 2, Monday July 18th - Friday July 22nd**


 * Tuesday 19th, Pupil Free Day for Wedderburn Students**


 * Theory:** DBMS, capabilities, features, limitations, benefits & risks**, [[file:ch8_data_man_capab_features_limitations_2.docx]]**


 * Application:**

Access Ch 1, Complete, Database assignment 1, wages database, p 1-22

Access Ch 2, Processing Data, Database assignment 2, student database, 2-20

Access Ch 3, Introduction to Queries and creating relationships, Database assignment 3, 3-29. ||  ||
 * **Access Summary,[[file:Access_how_to_summary.docx]]**


 * Week 3, Monday July 25th - Friday 29th July**

KB away on Thursday

Aths Sports on Tuesday
 * Theory:** Characteristics of data types & collection tools & user interfaces for data entry, [[file:ch8_data_characteristics_data_types_3.docx]]


 * Application**

Access Ch 4, Simple forms; Database assignment 4, 4-14

Access Ch 5, Creating more detailed forms, database assignment 5, form for video store. ||  ||   ||   ||
 * Week 4, Monday 1st August- Friday August 5th**


 * Theory:**
 * Ch 8, Data Management,** Kaluganga Junior Swimming Club Case Study**, [[file:ch8_data_case_study_kaluganga_4..docx]]**


 * Application:**

Access Ch 6, Quick Reports, Database assignment 6, 6-16

Access, Ch 7, More Detailed Reports, Database Assignment 7
 * **Week 5, Monday 8th August - Friday August 12th** ||  ||
 * **Theory: Ch 8,** characteristics hardware; physical & software controls for protecting security, [[file:ch8_data_roles_functions_charact_hardware_5.docx]]
 * **Theory: Ch 8,** characteristics hardware; physical & software controls for protecting security, [[file:ch8_data_roles_functions_charact_hardware_5.docx]]


 * Ch 8 powerpoint summary for test, [[file:ch8_p_point_summary.pdf]]**

Database quiz: Undertake the quizlet exercise; go to this link:

[]


 * Applications:**


 * Week 6, Monday 15th August - Friday 19th August**


 * Application:**

Access Ch 6, Quick Reports, Database assignment 6, 6-16

Access, Ch 7, More Detailed Reports, Database Assignment 7

Access, Ch 8, Creating user-friendly databases, using buttons


 * Theory:**

Tuesday: Test on Ch 8, Databases,

Ch 7 Data visualisation, information needs, data integrity,

Article and questions:

Questions: ||  ||
 * **Week 7, Monday 22nd August - Friday 26th August**


 * Theory:**

Ch 7 Data visualisation, purposes of,


 * Application:**

Access, Ch 9, using Macros Access, Ch 10, Reports that total items


 * Week 8, Monday 29th August - Friday 2nd September**


 * Theory:**


 * Ch 7,** Data visualisation, Problem Solving Methodology, [[file:ch7_psm_3.docx]]


 * Application:**

Access, Ch 11, Applying Relational Database features ||  ||
 * **Week 9, Monday 5th September - Friday 9th September**
 * **Week 9, Monday 5th September - Friday 9th September**


 * KB away on Tuesday.**


 * Application:**

SAC1, Access Database, VET problem,

"Football NSW lifts its game with data visualisation resources",
 * Theory: Data Visualisation,**

Football questions,


 * Week 10, Monday 12th September - Friday 16th September** ||  ||
 * **Application**:

Continue and Complete SAC1, Access Database, VET problem ||