Monday, September 2, 2019

Databases; Introducing the World of Databases



TEN WAYS DATABASES RUN YOUR LIFE

What are some examples of databases we interact with every day?


The top ten most common database security vulnerabilities



Resources

Database Project (Wednesday and Thursday Lesson)

Create a database product using MS Access that can be used to solve a unique problem within your immediate environment/community. The task will be done individually but you can consult widely. 

Your database should;
  • address unique problems different to those of your IA.
  • have at least two related tables.
  • at least four queries with some complex calculations applied.
  • a well designed switchboard and at least three forms.
  • some macros used.
  • at least three well designed reports.
  • A 2 min screencast of how the product functions should be uploaded


    A screencast explaining how the product functions and what techniques were used, will be uploaded on managebac.
    Assessment Rubric

Level
Descriptors
1-3
Simple product developed that does not capture effectively the details of some limited requirement for the product listed. The use of database techniques in the software of choice is limited in the development of the product. The product does not solve a specific practical problem. The product fails to function as required. The screen cast fails to show how parts of the product function.
4-5
Good quality product developed that captures effectively some of the details for the database product as listed. Some of the database techniques are used appropriately in the development of the product. The product solves to some extent a practical problem. Product functions as required. The screen cast shows how some parts of the product function.
6-7
Excellent quality product developed that captures effectively most the details of most database productMost of the techniques in the software of choice are competently and appropriately used in the development of the product. The product solves effectively a practical problem. Most of the section of the product function effectively. The screen cast shows in detail how most of the product functions and how it was designed


Wednesday, August 21, 2019

Case Study Document FaceToFace Facial Recognition

Please click on the link below for the CASE STUDY Document for May 2020 ITGS Paper 3 Examination

CASE STUDY FACETOFACE FACIAL RECOGNITION


Task 1 Strand 3
What IT System / concepts will we need to research to develop our understanding of the Case Study?

Strand 2 
Which institutions, companies or organizations that use the technology will we investigation to enable use understand the application of these technologies?

Strand 1
What are some of the main social & ethical issues that related to this technology and why? 

Task 2 (For Task 2

Refer to CASE STUDY material using the ITGS Triangle, 
i) List the Technologies/Systems/ Concepts explicitly stated in the case study document
ii) List the Social and Ethical issues explicitly stated in the document
iii) List the areas of applications explicitly stated in the case study document
iv) List the stakeholders / organizations explicitly stated in the case study document.

Task 3
From the CASE STUDY material and using the ITGS Triangle,
i) List the Technologies/Systems/ Concepts not stated in the case study document but will be essential for our understanding of the case study
ii) List the Social and Ethical issues not explicitly stated in the document but will need to be investigated in the case study document.
iii) List the areas of applications not explicitly stated in the case study document but will be crucial for our investigation.

iv) List the stakeholders / companies/ organizations  not directly stated in the document who are involved in the development, policies, usage, improvement, of the face to face facial recognition system.

Task 4 (Period 2 Task)
Design an A3 poster showing how facial recognition system has developed from its conception to date. (This project will be grade out 12 marks)

The poster should;
i)  Show the developments, key highlights at each stage of the timeline to date
ii) Show the companies or organizations involved in its development.
iii) Use more of a images / diagrams and less of text
iv) The poster should be appealing with appropriate use fonts and background color.
v) The PDF A3 document should be uploaded on managebac.
vi) Using a poster building software is recommended.

Sample: http://aertecsolutions.com/wp-content/uploads/2015/01/infografia-UAS-EN-v02.jpg

Some reading Resources
https://www.scienceabc.com/innovation/facial-recognition-works.html

https://www.globalme.net/blog/facial-recognition-technology-explained

https://www.cioreview.com/news/the-future-innovations-of-biometric-facial-recognition-nid-27787-cid-135.html

https://us.norton.com/internetsecurity-iot-how-facial-recognition-software-works.html

Tuesday, August 20, 2019

Guidance for Answering Paper 2 Questions

Criterion A;

Part 1: What is the concern all about?
            Why is it a concern?What is the negative impact on one or more stakeholders?
            What extracts from article will you use to support or give the context?
            Use evidences from the article to support the main issue identified
            N/b Do not describe an issue that is not directly stated or implied. The issue should be straight
                  away clear from the article.
Part 2: Who is the primary stakeholder?
            What is the use of the IT system?
            Which part of IT system is the stakeholder using?
            Can this be supported with extract or  an example from the article?
            This answers "Who", "How" and "Why"

Criterion B;
Use the document in the link below to learn how to respond to criterion B.
         Answering ITGS Paper 2 Criterion B

Criterion C;
Use the document in the link below for ideas on how to respond to criterion C;
         Answering ITGS Paper 2 Criterion C

Criterion D:
Part 1: Describe the one problem resulting from the use of the IT system.
            What is the impact of the problem?
            State  one solution to the one problem described
Part 2:  Describe how the solution will work
             NB Technical solutions should be describe with IT terms showing inputs, processing, storage, outputs.
             Non technical solutions should be supported with policies and actions required.
Part 3:  Evaluate some positives strengths of the solution in solving the problem.
            Evaluate some negatives of the solution in solving the problem.
Part 4; Conclusion
            What  areas of the solution do you have issues with?
            What do you recommend for future development of the solution  
            Overall strategy for Paper 2 Criteria

Exercise
Read the news article in the link below and answers the assigned questions; Post your responses in your OneNote page.

Read the article in the link below;


Child Drinkers Article


Criterion A - The issue and stakeholder(s) (Afzal & Gabriella)
Describe one social/ethical concern related to the IT system

Describe the relationship of one primary stakeholder to the IT system (Heena & Amilio)

Criterion B - The IT concepts and processes (Azaan, Jonathan, Anita, & Alefiyah)

Describe, step by step, how the IT system works

Explain the relationship between the IT system and the social/ethical concern described in Criterion A

Criterion C - The impact of the social/ethical issues on stakeholder (Valarie, Jordan, Sneha & Sachwani)
Evaluate the impact of the social/ethical issues on the relevant stakeholder

Criterion D - A solution to a problem arising from the article (Ayaan, Jeanette, Abbas, Tamara)
Evaluate one solution that addresses at least one problem identified in Criterion C


Practice 2; Geo-Tagging

TASK B.
USING THE ARTICLE BELOW WRITE A COMPLETE PAPER 2 TYPE RESPONSE AND POST THE RESPONSE ON YOUR ONENOTE PAGE.


Introduction to Project Development

Post the notes for the activities below in your OneNote Page. You can use videos, diagrams  and illustrations to respond to the questions below;

What is PDLC?

Describe in details the main features and activities in each of the following stages
  • Investigation of existing system(s) 
  • Feasibility study
  • Requirements specification
  • Project schedule 
  • Product design
  •  Product development and technical documentation
  •  Client and end-user evaluation

Tuesday, August 13, 2019

ITGS Class of 2020

ITGS Class Expectation


  • Treat everyone with respect.
  • Respect everyone's right to learn
  • Meet all set deadlines
  • Participation highly encouraged.
  • Use OneNote for notes and for collaborative work.
Breakdown of Our lessons

  • Monday  ITGS Syllabus Content (IT System)
  • Tuesday ITGS Syllabus content (IT system)
  • Wednesday Paper 2 News Article exercises 
  • Thursday Case Study Introduction
  • ITGS IA tasks
Managebac Details
    Categories of work
  • Homework and Class Participation
  • IA Project Tasks
  • Case Studies Assignments
  • Paper 2 News Articles Tasks
  • Tests
Grade boundaries for all ITGS Tasks

7  - 79-100
6  - 66-78
5  - 54-65
4  - 41-53
3  - 26-40
2  - 13-25

Monday, April 1, 2019

Spreadsheets,modelling and simulations and Introduction to Project Management

Spreadsheets, modelling and simulations
  • What are the different ITGS terminologies covered in this topic?
  • What are the common social and ethical issues associated with this topic?
  • Discuss the different applications of these topics to the different areas;
  • What are the current technologies associated with either spreadsheets, modelling and simulations?
Project Management (Product Development Life Cycle PDLC)
  • What are the different ITGS terminologies covered in this topic?
  • What are the common social and ethical issues associated with this topic?
  • Discuss the different applications of this topic to different areas.
  • What are the current technologies associated with PDLC?

Revision links