ITGS news article exercise

You are expected to search for a news article with social and ethical significance assigned.

Samy	Intellectual Property		Hezi	Privacy and Anonymity
Sahir	Surveillance		Wayne	Digital Divide and equality of access
Shad	Security		Saumya	Globalization and Cultural Diversity
Amaar	Authenticity		Tanzil	Reliability and Integrity
Ali Shah	People and Machines

Use the links below or others for reference;

NYTIMES http://www.nytimes.com/pages/technology/index.html?excamp=GGTEsoftwarenews

BBC Technology Page http://www.bbc.com/future/sections/technology

Wirednews Page https://www.wired.com/latest-news

Information Week http://www.informationweek.com/default.asp

Teach Ict news http://www.teach-ict.com/news/newstopics.htm

Statesman News http://www.newstatesman.com/sci_tech

You will then post the link on your "OneNote" page and write brief summaries using your news article for each of the criterion below

Criterion A — The issue and stakeholder(s)                                                               

·         Describe one social/ethical concern related to the IT system.

·         Describe the relationship of one primary stakeholder to the IT system.

Criterion B — The IT concepts and processes                                                             

·         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 issue(s) on stakeholders                    

·         Evaluate the impact of the social/ethical issues on the relevant stakeholders.  

Criterion D — A solution to a problem arising from the article                                

·         Evaluate one solution that addresses at least one problem identified in Criterion C.   

Spreadsheets Notes and Excercises

Notes
http://www.slideshare.net/Giratorio/introduction-to-spreadsheets-30468628


Spreadsheets used for Modelling and simulation notes
http://www.teach-ict.com/gcse_new/spreadsheets/modelling_simulation/miniweb/pg2.htm


Attempt the following spreadsheet exercises

1. http://web.utk.edu/~dhouston/excel/exer1.pdf

2. http://web.utk.edu/~dhouston/excel/exer4.pdf

Database Practical Excercises

Attempt the following practical tasks

1.  Exercise 1  http://paulatisa.blogspot.co.ke/2015/03/ms-access-exercise-1.html
2.  Exercise 2 http://paulatisa.blogspot.co.ke/2015/03/ms-access-exercise-2.html
3.  Exercise 3 http://paulatisa.blogspot.co.ke/2015/03/ms-access-relationships-exercises-3.html

Database case studies

Read the article in the link below;
http://www.computerweekly.com/feature/Case-Study-Redbrick-database-analysis

• Which database was used by the company before?
• What were the limitation of the previous database?
• Which database was selected and what were the reasons for selecting it?
• Outlines the main merits of the Database system selected to be used by the company.

See of you can read specific solutions given in the link below;

https://www.quintify.com/case-studies.html

Database News Articles

Use the articles in the links below to answer ITGS Paper 2  type questions. 

1. AP: Across US, police officers abuse confidential databases

http://www.usnews.com/news/politics/articles/2016-09-28/ap-across-us-police-officers-abuse-confidential-databases

2. Police database will share data on 15 million people

http://www.bbc.com/news/uk-13879683

3. Police building Private DNA databases

http://www.businessinsider.com/police-are-routinely-building-up-private-dna-databases-2016-9

4. Three Mobile cyber hack: six million customers' private information at risk after employee login used to access database 

http://www.telegraph.co.uk/news/2016/11/17/three-mobile-cyber-hack--six-million-customers-private-data-at-r/

5. Database Error leaves 150 million exposed

http://thehill.com/business-a-lobbying/284519-database-error-leaves-150-million-voter-records-exposed-online

6. 'No password' database error exposes info on 93 million Mexican voters

http://www.theregister.co.uk/2016/04/25/mexico_voter_data_breach/

7. Police increasing the use facial  recognition Technology

http://www.cbsnews.com/news/law-enforcement-increasing-use-of-facial-recognition-technology/

Strategies for Answering ITGS Paper 2

Paper 2 May 2012



Paper 2 May 2012 markscheme

https://ekrisnawan.wikispaces.com/file/view/HL+P2+May2012+Markscheme.pdf

Business and Employment: IT in tranportation

The tasks will be worked on in pairs

i) Brainstorm  how IT has been applied in transportation in the following specific areas.

• Airline reservation systems, 
• Navigation, 
• Package tracking, 
• Traffic control systems, 
• IT systems in cars.

ii) Describe specific example technologies used in each of the following areas

iii) Discuss specific common problems associated with using information technologies in each of  the areas listed above.

iv) What are some of the solutions that have developed to address the problems listed above?

Databases in Business and Employment

• Compare and contrast any two recruitment online databases below and post your findings on onenote

https://www.workable.com/

http://www.jobvite.com/

http://www.recruitmentworx.com/Online-Recruitment-Database.aspx

• What are the advantages of using an online recruitment software

•  Describe in detail how one such software arrives at selecting the best candidate for a job.