SDLC Introduction

http://www.tutorialspoint.com/sdlc/

ITGS Past Papers

https://docs.google.com/folderview?id=0BwCdsItMsAgoSFJpQ2tvYUxQMmM


http://www.globaljaya.net/secondary/IT/y11_itgs_2012/Lists/Posts/Post.aspx?ID=173

Spreadsheet Activities

Please use the links below for the different Spreadsheets activities;

Spreadsheet tutorials http://www.gcflearnfree.org/excel2003

Practical exercises (Attempt the following activities)

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

Attempt the other activities in

http://web.utk.edu/~dhouston/excel/exercise.html

http://www.abacustraining.biz/Exercises/Excel/BasicSSConcepts.htm

Activities for 5/10/2015
Make brief notes in OneNote from the link below
http://codegaitgs.pbworks.com/w/page/65915471/Spreadsheets%2C%20modeling%2C%20and%20simulations

Study the essential Questions following.
http://codegaitgs.pbworks.com/w/page/53156219/Spreadsheets

More reference Notes
http://pac-itgs.wikispaces.com/Databases+and+Spreadsheets

http://hhsitgs.wikispaces.com/3.8+Spreadsheets,+Modeling,+and+Simulations

ITGS Criterion D Project Designs

There are four significant components to the product design.

• Overall structure
• Internal structure
• List of resources
• List of techniques

The following information should also be included as part of the product design.

• Test plan
• Agreement of client

Overall structure (Can be developed using relevant sketches and diagrams) 

Website - Hierarchical navigation model clearly indicating web pages and navigation; sitemap Video - Storyboard DTP - Overall plan and short description for the content of the pages Database - Entity relationship diagram along with field definitions/type Spreadsheet - Workbook layout  

Internal structure (Using relevant sketches and diagrams) 
Website - Layout for each page showing position of text, graphics, animations, audio. 
Video - Short description of the action in each video sequence, audio, effects, graphics, dialog/narration, transitions. 
DTP - Master page layout. Layout of other pages showing fonts used, position of text, tables, graphics, headers/footers 
Database - Layout of main menu, forms, (showing location of text, graphics, navigation buttons) layout of reports 
Spreadsheet - Layout of individual worksheets showing location of text, graphics, formulae. Indication of input cells, output cells, locked areas 

List of Complexity techniques document.

https://drive.google.com/file/d/0B8VAiXCgqIIbOWhtQlRJRUcxTUE/view?usp=sharing

Database Sample for Criterion D

https://docs.google.com/file/d/0B8VAiXCgqIIbYVNUNENmeDBTclk/edit?pli=1

Other Samples

Website Design Sample

Website Design Sample 2

Website Sample 3

Video Storyboard Design Sample

Spreadsheet Sample

Smart Homes Case Study Activities

a) Read the article below identify the different smart-homes apps. (Post the summary responses in OneNote page.)

http://www.smarthome.com/iphone_apps.html

• Which one are the most important in your opinion and why
• Which one are less important and why. 

b) Read one article from the link below and use the ITGS triangle to analyse it. (be ready to share your findings)

http://www.wareable.com/smart-home

• What IT systems/terms and concepts stated
• Who are the main stakeholders directly stated or implied?
• What are the benefits and risks of the systems / technology?
• What are the issues that can arise based on the article?
• Can you identify one main problem and suggest a solution to that one problem?

c) It has been difficult for people to implement the smart home concept in many parts of the world. How do we bring smart home together?

Read the article below;

http://readwrite.com/2015/09/08/smart-home-industry-standard-open-apis

Watch the best smart homes videos;

https://www.youtube.com/watch?v=sUo1SEGXCHA

https://www.youtube.com/watch?v=i73n-LTXPIM

From the above link list down all the IT terms stated by the presenter.

Smart Home gadgets https://www.youtube.com/watch?v=n5CvkR9siaE

Answering ITGS Paper 2 Strategies

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 extract from article has will use to support or give the context?

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      

Summary of all \Criteria.
Overall strategy for Paper 2 Criteria

Answering Extended Response Part (c)

Use the link below to obtain see how to respond to extended response question

Strategy for extended response

ITS systems in organizations

Find short notes on the following and post them in your OneNote page

a) The role of IT systems in organization
b) Organizational IT policies

http://www.techrepublic.com/article/the-top-five-user-policies-every-organization-needs/5995547/

http://www.nersc.gov/users/accounts/user-accounts/account-policies/

c) IT personnel and Organization structure