Term+One

Students commence school at Charlton, Wednesday Feb 1
 * **T** ||
 * **Week 1, Monday 30th January to Friday 3rd Feb**
 * Theory**
 * Theory**

First class, Wednesday afternoon.

Informatics 2017, powerpoint, ||   ||
 * Course Outline:** Overview of Informatics, [[file:EL_Overview_Informatics.pptx]]
 * **Informatics Glossary: [[file:informatics_glossary.pdf]]**


 * Problem Solving Methodology: [[file:informatics_psm.pdf]]**


 * Theory:** Ch 1, Organisations & data management, part 1, [[file:ch1_org_data_data_collection_1.docx]]


 * Activity:** Online data acquisition and creating a UFD,


 * Applications: Access summary: [[file:Access_how_to_summary.docx]]**

Review Ch 8, creating user-friendly databases, complete assignment 8


 * Week 2** **Monday 6th February - Friday 10 February**
 * Swimming Sports, Friday, Charlton**


 * Theory**

Ch 1, data types, data base terminology and relational databases, 2,


 * Applications:**


 * Access exercises:**


 * Ch 11,** Creating a relational database system, databases assignment 11

Ch 12, Setting up an Invoice System

commence Freetown exercises, ||   ||
 * **Week 3, Monday 13th - Friday 17th February**


 * Theory:**

Ch 1, organisations and data management, RDMS, normalisation**, ** , ||  ||
 * [[file:normalisation_examples.pdf]]**Normalisation exercise, word, [[file:Normalisation exercises_2017.docx]]; powerpoint, [[file:Normalisation_problems_2017_.pptx]]**

Normalisation examples, pdf & ppt, ;

Normalisation solution to problems,


 * Application:**.

Continue with Freetown exercises, Freetown, 2, Freetown, 3, Freetown 4

Freetown problems,, , ,

NCD Swimming, at StArnaud, Monday
 * Week 4, Monday 20th February - Friday 24th**


 * Theory**

Ch 1, Database design tools, 4**, ** Ch 1, Developing a RDMS and testing the solution, 5, powerpoint, database design tools,


 * Applications:**

Continue with Freetown Exercise, problem 5,

Freetown solution,

From text, Pizzas on the Go, additional instructions,


 * Week 5, Monday 27th February - Friday 3rd March**


 * Theory** ||  ||
 * Powerpoint on developing RDMS and testing solution, [[file:1.5 Testing the Solution.pptx]]

Ch 1, Security, protecting data, 6,

Powerpoint, security**,**


 * Application:**


 * Pizzas on the Go**


 * Pizzas on the Go, Case Study, [[file:Pizza on the Go skeleton.docx]]**

From text, Pizzas on the Go, additional instructions,


 * Chapter One powerpoints, [[file:ch1_powerpoints_data_rdms.pdf]]**


 * Week 6, Monday 6th March - Friday 10th March**


 * Theory:** ||  ||
 * **Test on topic 1**, Organisations and data management


 * Test solution: [[file:Topic 1 - Test (Solution).docx]]**

connor's test,


 * Application:**

Pizzas on the Go complete.

Prepare for **Outcome 1: Design & develop a RDBM system to solve an information problem**


 * Week 7, Monday 13th March - Friday 17th March**


 * Monday, 13th, Labor Day Holiday**

.
 * Outcome 1: Design & develop a RDBM system to solve an information problem** ||  ||
 * **Week 8, Monday 20th March - Friday 24th**

Complete Outcome 1,


 * Week 9, Monday 27th March - Friday 31st March ; Last Day of Term One** ||  ||
 * **Theory:**

Timeline for SAT,

SAT Criteria, 1-8,

Ch 2, Data Analytics: Drawing conclusions

Unit 3, Outcome 2, SAT, outline, criteria, 1-4,

Unit 3, Outcome 2, SAT, outline,

Ch 3, Data analytics, Project Management,

Project management, ppt,

Commence & complete criteria 2 using criteria documents provided; 30th March, project management egs.

ch 2, Data analytics, what is data, a hypothesis, 1,

Hypothesis, powerpoint,

Hypothesis, examples,

Holiday work: Creating a hypothesis, complete the following worksheet,

Developing a hypothesis, guidelines, ||   || Ideas for hypotheses,

Hypotheses samples,

Ch 2, Data analytics, Solution specifications, 2,