Database Practice

Attempt the following practical tasks in the link below;

1. http://paulatisa.blogspot.co.ke/2015/03/ms-access-exercise-1.html

2. http://paulatisa.blogspot.co.ke/2015/03/ms-access-exercise-2.html

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

Introducing Databases

Introducing to Databases

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

https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/v/welcome-to-sql

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

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

http://www.slideshare.net/jothamgadot/9780538469685-ppt-ch01

https://www.techopedia.com/6/28832/enterprise/databases/introduction-to-databases

https://www.quackit.com/database/tutorial/

TEN WAYS DATABASES RUN YOUR LIFE

http://www.liquidweb.com/blog/index.php/ten-ways-databases-run-your-life/

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

https://www.quora.com/What-are-some-examples-of-databases-we-interact-with-every-day

The top ten most common database security vulnerabilities

http://www.zdnet.com/article/the-top-ten-most-common-database-security-vulnerabilities/

Database News

http://www.dbta.com/Categories/Database-Management-334.aspx

http://www.infoworld.com/category/database/

http://www.teach-ict.com/news/news_stories/news_databases.htm

Network related Stories

ead the news article below

ATM Crime & Fraud Information
https://www.european-atm-security.eu/ATM%20Crime%20/

EFT POS Hacker Net $50 Million
http://www.bloggernews.net/123778

Steps for Preventing EFT problems
http://www.isaca.org/Journal/Past-Issues/2003/Volume-4/Pages/Preventing-EFT-Fraud.aspx

Other news
http://www.atmsecurity.com/

http://www.asiaone.com/News/Latest%2BNews/Singapore/Story/A1Story20120111-321215.html

http://www.bdo.co.za/resources/showitemarticle.asp?ResourceSectionId=4&ResourceSectionName=Publications&ResourceId=11&ResourceName=News%20and%20Views&IssueId=44&ContentPageID=&Archive=&articleid=52

Network Functionality Activities and Notes

5G Video

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

Write brief notes on ;

Protocols http://www.slideshare.net/makyong1/chapter-32-12564235

Asynchronous vs Synchronous data transmission

broadband, baseband and dial-up connection http://www.careerride.com/nw-baseband-vs-broadband.aspx

Remote Access

Bit rate vs Bandwith http://www.slideshare.net/kajal070/data-transmission-rate-and-bandwidth-293031

What is the difference between WPA, WEP and WAP in wifi security https://www.webopedia.com/DidYouKnow/Computer_Science/WEP_WPA_wireless_security.asp

You may use the links below for references

https://www.digitalocean.com/community/tutorials/an-introduction-to-networking-terminology-interfaces-and-protocols
http://fcit.usf.edu/network/default.htm
http://www.integritycomputing.com/ppt2/sld009.htm
http://www.kelso.scotborders.sch.uk/departments/computing/resources/projects/james_mcmunn/synas.htm

Attempt all the activities in the links below
http://wps.prenhall.com/bp_beekman_tomtech_10/183/46880/12001471.cw/index.html
http://wps.prenhall.com/bp_beekman_compconf_7/29/7508/1922285.cw/index.html 
http://wps.prenhall.com/bp_beekman_tomtech_9/104/26867/6877973.cw/index.html

Cloud Computing

Lesson Objective 

Definition of cloud computing

Describe how cloud computing functions and describe it's main features

Describe the models/services of cloud computing

Explain the advantages and disadvantages of using cloud computing

Outline examples of cloud computing applications.

Evaluate the common social / ethical issues arising from using cloud computing services.

Use the resource links to be make short notes on your OneNote page addressing the above objectives.

Cloud computing SlideShare notes

https://www.slideshare.net/ProfEdge/introduction-to-cloud-computing-23970527

Advantages and disadvantages

http://leavcom.com/articles/ieee_jan09.htm

Video explaining the concept of cloud computing

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

News article explaining the concepts of cloud computing

http://www.explainthatstuff.com/cloud-computing-introduction.html

Revision Questions on Cloud Computing
https://www.4cornerit.com/cloud-computing-test/

http://www.mcqtutorial.com/MCQ/Miscellaneous/Cloud%20Computing/121_198_1.php


News articles on cloud computing
http://www.tomsitpro.com/tags/cloud-computing/

https://gadgets.ndtv.com/tags/cloud-computing/articles

https://www.computerworld.com/video/83375/digital-is-the-new-shiny-spoon-danielle-di-masi-digital-is-the-new-shiny-spoon-danielle-di-masi

Types of computer Network

Networking Summary Notes

Notes Summary

Audio explanation of computer networks.
https://snatpedia.com/Types-of-network.html

Notes Summary of Computer 
https://snatpedia.com/Types-of-network.html

Difference between SAN and RAID
http://www.careerride.com/nw-raid.aspx

Intranet, Extranet, Internet
http://www.omnisecu.com/basic-networking/internet-intranet-and-extranet.php

Network Topologies
https://www.youtube.com/watch?v=4ZaTa_JQM_E

Slideshare https://www.slideshare.net/AdilAslam4/types-of-network-topologies-69291119

Revision Quizzes
https://www.proprofs.com/quiz-school/story.php?title=types-computer-networks

http://www.bbc.co.uk/bitesize/quiz/q58447030

Game Making Project

Our next project will be creating a simple game using any free game building software of choice.

The game developed should;

• Solve a specific problem
• Apply different gaming building techniques and skills i.e moving from level 1 to level 2
• Last for not more than 2 minutes.
• Have instructions on how it is played
• be interactive with multimedia use where possible
• Demonstrated in class how the game is played or  the is uploaded on YouTube and link shared on ManageBac under message space.

- You will be allowed to consult freely with your peers and get help from experts but your product should be unique using different game building software and solving unique problems.

- You will be allowed to code or modify existing code of a game to solve you specific problem.

This work will be assessed based on your creativity, how the game solve the problem identified and the degree to which software techniques and skills are applied.

Resources for Reference
http://www.makeuseof.com/tag/five-free-game-development-tools-make-your-own-games/

https://lifehacker.com/the-best-free-tools-for-making-your-own-video-games-1689905461

https://www.buildbox.com/12-indie-games-thatll-inspire-you/

http://wimi5.com/

Assessment Rubric

CRITERIA	Levels of Achievement
	Baseline	Effective	Exemplary
Organization and Design
Navigation	0 points Navigating the game is confusing and information cannot be found easily.	3 points Some navigation is unclear, resulting in a few places where Players can become lost.	5 points The game is well-organized and easy to navigate. Players can clearly understand where they are and where to go next.
Application of Skills and Techniques
Different Techniques and skills used	0 points The game applies very few basic software techniques and skills.	3 points The game applies some useful  software techniques and skills.	5 points The game applies detailed and appropriate software techniques and skills.
Solving the Problem
Effectiveness	0 points The game does not solve the stated problem	3 points The game partially solves the problem stated	5 points The game solves the problem identified effectively