Term+1+Files


 * **NOTE:** Bridge number: **6185096.** If dialing Charlton direct, SVN Charlton CO VC5 SLC2: 10.136.132.27


 * Week 1 & 2** ||  ||
 * **Introductions:**

- Protocols:

- Be on time; Charlton 1st period starts at 9.00 am

- Be organised, always have your netbook/laptop and be logged on and logged on to VC system.

- Link to Google shared folder: Computing; 2018; Create personal folder

https://drive.google.com/a/charlton.vic.edu.au/folderview?id=0B7_jMD5B98eAM0RpWHh1UlBpZmc&usp=sharing

- Personalised page

- Personal timetable

- Let me know when you're going to be away ||  ||
 * **Course Outline:**

Study Design:

Glossary:


 * Focus Term 1:**

- Data and Graphic Solutions - Infographics - Graphic solution showing data and information using different elements that include; graphs, pictures, diagrams, narrative and timelines

__**Lesson**__

Collaborative Google Spreadsheet, with some spreadsheet basics.
 * Software for graphic solutions: Include spreadsheets,**

Shared spreadsheet document in google; 2018; Contacts; Contacts 2018; complete the sheet with your details


 * Dedicated Infographics Software - Piktochart**

Creating a Piktochart account and an infographic:

Eamonn Prunty - https://www.youtube.com/watch?v=DFrn_91LdxM
 * Tutorial 2:**


 * Tutorial 2:**
 * Stacykeenan1 -** https://www.youtube.com/watch?v=-wOIcf5lcdo


 * Analysing infographics:**


 * The anatomy of a winning infographic (PDF)**


 * Application**


 * Graphics - Spreadsheets & Creating Charts:**

1. Revise your knowledge of charts and go to the following site for an online tutorial on the types of charts and using charts, completing __Exercise 17__ []

2. Complete the following exercise in either excel or google spreadsheets and then import to a new infographic.



Extension activity:


 * Theory**


 * Chapter 1 - Data analysis:**

1. Data Analysis PowerPoint

2. Research, Quantitative and Qualitative data

3. Complete Think About Computing 1.1, Pg. 6 ||  ||
 * **Week 3, Monday 12th - Friday 16th February**

__**Lesson**__


 * Theory:**


 * PowerPoint**


 * Chap 1 Cont. - Quality of Data and Referencing**


 * Application:**


 * Infographic Chart Exercises - to be completed in either Google Sheet or Excel and then imported to a new Infographic**

1. Complete the tasks outlined for the following World Health Data



2. Complete the Sporting Facilities Data spreadsheet exercise, using the data from the excel sheet


 * Week 4, Monday 19th - Friday 23rd**

__Lesson__


 * Theory:**


 * Chapter 1 - Data Analysis COnt.:**

1. Data Analysis, Privacy and Physical Security Controls

2. PowerPoint, Privacy and Physical Security Controls

3. Cloud Computing: This video will provide a deeper look at how Microsoft uses secure, reliable, scalable and efficient best practices to deliver over 200 cloud services to more than a billion customers and 20 million businesses in over 70 countries []

4. Data Analysis, Australian Privacy Principles,

5. PowerPoint, APP Principles


 * Application:**

||  || ||   ||
 * Reviewing Spreadsheet Basics** ||  ||
 * 1. Basic Functions, Fill Function, Sum Function, Multiply & Product Function, Average Function, Sort Function, Text to Columns
 * 2. Sales Exercise
 * 3. Absolute and Relative References Exercise


 * Week 5, Monday 26th February - Friday 2nd March** ||  ||
 * **Theory:**

1. Ch 2. Approaches to Problem Solving Methodology, Data Analysis

2. PowerPoint, Approaches to Problem-Solving Design Principles for Graphic Solutions Testing of Solutions


 * Applications:**

1. Use Google Forms to Create a Survey, Questionnaire

2. Spreadsheet, If Statements & Countif, Sumif & Protection

3. If function Word Doc with Exercises, Students & Hillcrest motors


 * LO1 SAC Preperation:**

1. Infographics

BBC Newsnight: Information Graphics https://www.youtube.com/watch?v=q2Wnu1SOhKs

The Bauty of Data Visualization https://www.youtube.com/watch?v=5Zg-C8AAIGg

2. Examples of Infographics

http://tinyurl.com/okvwlp5

http://tinyurl.com/o5nulbc ||  ||
 * **Week 6, Monday 5th March - Friday 9th March**


 * CHAPTER 1 TEST - WEDNESDAY 7th MARCH**


 * Theory**

1. Chapter 1 Revision

2. Ch 2, Design Principles for Graphics Solutions ||  ||
 * 3. PowerPoint, Types of Testing


 * Application**

1. Spreadsheet, Lookup Function

2. Lookup Examples ||  || ||   ||
 * 3. Review Lookup
 * [[file:Lookup_Trees.xlsx]]


 * Week 7 & 8** **Monday 12th March - Friday 23rd March**


 * Learning Outcome 1:**
 * Acquire, secure and interpret data, and design and develop a graphic solution that communicates the findings of an investigation** ||  ||
 * [[file:Learning Outcome 1.docx]]
 * [[file:Learning Outcome 1.docx]]


 * Theory**

1. Types of testing & validation


 * Week 9, Monday 26th - Thursday 29th March (Last Day of Term 1)**


 * Application:**

1. Complete the Vlookup_team exercise

2. Complete the lookup up salaries exercise ||  ||
 * **Term 1 Holiday Work - Due Monday 16th April**
 * **Term 1 Holiday Work - Due Monday 16th April**


 * Theory**

1. Networks

2. Devices ||  ||
 * **Application** ||  ||
 * 1. Spreadsheet Revision ||  ||
 * [[file:SS Data_revision_exercise_2016.xls]] ||  ||