ICT
 
 
home search Contact
Lmarsden is a non-profit information site

Week 04: IDEAS - Design Technology

Class Task and Information

  • Lesson 01:

        • Investigate how digital systems represent text, image and audio data in binary (ACTDIK024)
          • explaining that characters in text correspond to numbers defined by the character set
          • recognising that Unicode attempts to represent the written symbols of every language; and using Unicode charts to look up characters from Asian writing systems 
          • investigating the different representation of bitmap and vector graphics and its consequences, for example pixelation in magnified bitmap and vector images 
          • investigating how colours are represented in images and videos 
          • converting between decimal and 8-bit (1 byte) unsigned binary, covering whole numbers typically used for characters and RGB, for example 65 in decimal is 01000001 in 8-bit binary 
          • explaining ways media elements are presented, for example the difference between embedded and linked media elements 




      • Learning Task 01: investigating the different representation of bitmap and vector graphics and its consequences, for example pixelation in magnified bitmap and vector images 

        • In your Design book answer the Guiding Questions:
          • When creating graphics for mobile devices, computers or digital sinage on a building, what graphic format is better to use from the following examples and why?






    • Learning task 02: explaining ways media elements are presented, for example the difference between embedded and linked media elements 

      • Read the following information:
        • When playing a computer games on a mobile device, the visual media elements can be embedded or linked depending on the developer's UX requirements. These media elements consist of rich visuals and audio to engage the player into the story line and prolong / increase the players desire to play. Therefore the rich media could be installed (embedded) with the application on your phone or downloaded (linked) when it is required.
        • Embedded media are audio and visual elements like a cut scene from a game. What are a cut scene in a computer game? Example from CoD Modern Warfare

      • Guiding Questions: Give a descriptive example of where a Web-page would use embedded or linked media elements. Record your thoughts in your Design journal.





    • Learning Task 03: investigating how colours are represented in images and videos 





      1. Explain how the following graphic represents how Turquoise is stored as a pixel value.






    • Learning task 04: - converting between decimal and 8-bit (1 byte) unsigned binary, covering whole numbers typically used for characters and RGB, for example 65 in decimal is 01000001 in 8-bit binary - explaining that characters in text correspond to numbers defined by the character set - recognising that Unicode attempts to represent the written symbols of every language; and using Unicode charts to look up characters from Asian writing systems 

      • View the following tutorial about converting between decimal and binary.
    • Learning task 05: recognising that Unicode attempts to represent the written symbols of every language; and using Unicode charts to look up characters from Asian writing systems 

    In your Design book answer the Guiding Questions:
    Unicode uses 7 Bits of information to represent letters found on your keyboard. What are the limitation of Unicode in the modern digital world?


          • Complete for knowledge check next Lesson.



  • Lesson 02: Intro topics A - Part 2
      • Querying an existing database to extract data for analysis, for example devising multiple selection criteria or using simple structured query language (SQL) SELECT statements to select records and retrieve specified fields describing the attributes of complex objects, for example defining the records, fields, formats and relationships of a simple dataset



    • Video Tutorial Files -= What to Do =-
      • You will need to view the video file and stop it along the way so you can implement, do what the video files shows you.

      • Remember: Information Action = KNOWLEDGE

      • Remember to take notes in your Design Book as you go.

      • Tutorial 01: Introduction to Relational Database Management Systems 7:50

          • Data – the building blocks
          • What are Relational Databases
          • How is information stored in a RDMS

        • You are to take down a minimum of 7 points from the Information tutorial.


    • Section 2: Practical introduction – 25 minutes
      • Students to access codecademy SQL course (MFAC server not available from P Block)
        • Students are to log onto: codeCademy



      • Sign in with student school credentials (use the Google email from school)

      • Read the instructions and complete the tasks:






    • TASK 03:
      • All students will be stopped 15 minutes before the end of the lesson to complete the following quiz / test for this section of Design Technology.
        • Link will become active with the test 15 minutes before the end of lesson.







    • Extenshion exercises for SQL Queries:
  • Lesson 03: Rotation to the next group.
    • Programming Language Workshops - Skills Development Topics - (Student Selections)
    • Students will have a selection of choice from:
    • mySQL & phpMyAdmin - BIG Data - What are you sharing on Snapchat and Instagram - LMR
    • Python Programming - DLN
    • Arduino Programming - RMR


          • Complete for knowledge check next week.




Readings / Homework

 

 

Focus Point

 

 

Information