Introduction to Databases

Links to database notes 
http://www.slideshare.net/sakuvenderzira/c1-basic-concepts-of-database

http://www.teach-ict.com/as_a2_ict_new/ocr/AS_G061/315_database_concepts/terminology/miniweb/index.htm

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


Database Quizzes
http://dotatmac.mcmaster.ca/db_basics/db_10_quiz.htm

http://www.teach-ict.com/gcse_new/databases/terminology/quiz/matchup_dbterminology.htm

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

http://quizlet.com/2158898/database-quiz-1-flash-cards/


Practices exercises
a)

http://www.tctcmalta.com/esf/pdf/Module%205/Practical_Exercise_2.pdf

b)
Practical instructions http://eniac.cs.qc.edu/cs12/PracticeAccess2.pdf

Source of files link http://eniac.cs.qc.cuny.edu/cs12/practice.html

Reviewing software

Use the online resources to attempt the software activities
http://wps.prenhall.com/bp_beekman_tomtech_10/

Read some notes and questions in the link below
http://www.docstoc.com/docs/109185308/ITGS---Banking-worksheet-2---answersheet

Friday Lesson 4 Activity

Read the following two news article and respond to the following questions for each article.
http://www.huffingtonpost.com/2012/02/26/billboard-with-face-recognition-technology-ad-women-not-men_n_1302286.html

http://www.china.org.cn/business/2012-10/29/content_26934653.htm

Criterion A; 

• What is the main social / ethical issue raised in the article?
• Copy an extract from the article that supports issue stated.
• Identify the main primary stakeholders in the article.

Criterion B; 

• List down the IT concepts and terms explicitly stated in the article 
• List down other IT concepts and terms that would be necessary to describe the technology.
• What do you think may contribute to the Issue identified in A to exist? 

Criterion C; 

• List down the advantages and disadvantages of the IT technology/system to the stakeholders in the article.
• Name other stakeholders that can be impacted and not directly stated in the article.

Criterion D; 

• State one main problem to the stakeholders of the technology/system described in the article. 
• State one solution to the problem stated above.
• State one strength and one limitation of your suggested solution.

Computer Software

Write brief notes on the following;

• Application software: word processing, desktop publishing, presentations, photo and video editing, music and sound development, website development
• System software: operating systems and utilities programs.
• Interfaces: graphical user interface (GUI), command line interface (CLI), menu-driven interface (MDI), voice interface.
• Distinguish between the following in terms of licencing: shareware, public domain, freeware, proprietary and open source software.
• Licensing authorities: for Business Software Alliance (BSA), what is their role. Which other examples exist?
• Commercial and custom-built (bespoke) software, Web-based software: What is the difference?
• Software Registration process: What is a serial number, warranty, copyright agreement.
• User support: what is the function of the following in any software developed? manuals, assistants, tutorials, help systems, “Read Me” files, Macros, templates, wizards.
• Define file formats: Why do different software have different file formats? for example, RTF (rich text format), TXT (text), PDF (portable document format), XLS, (Excel spreadsheet), SWF (small web format), ZIP (zipped file), JPG/JPEG (Joint Photographic Experts Group bitmap), PNG (portable network graphics bitmap), CSV (comma-separated values), HTM/HTML (hypertext markup language).
• Data transfer: ASCII (American Standard Code for Information Interchange), tab-delimited text file, zipped file, 

System utilities

• What is the role of Defragmentation/optimization and disk utility software, Backup, file management, account and accessibility management.
• Distinguish between; Virus, Trojan horse, malware, logic bomb, worm
• Distinguish between Compression/decompression (lossless, lossy)
• What is Colour synchronization as a computer utility feature.

Computer confluence online Editions

Useful on resource below.
http://www.pearsonhighered.com/beekman/

Computer Hardware

Write brief notes on the following. Use images for the devices described.

The computer system:

•      Types of computers: personal digital assistant (PDA), laptop, desktop computer, mainframe computer, supercomputer etc

•      Internal hardware parts of a computer; MAC address/ Motherboard/ Central processing unit (CPU), microprocessor, clock speed: for example, megahertz (MHz), gigahertz(GHz), terahertz (THz)/Primary storage: read-only memory (ROM), random-access memory (RAM)/Secondary storage: optical, magnetic, flash memory: for example, USB (universal serial bus) flash drive/

•      Measure of storage: Bit, byte, kilobyte (KB), megabyte (MB), gigabyte (GB), terabyte (TB), petabyte (PB), exabyte (EB),zettabyte (ZB), yottabyte (YB)/Character encoding: ASCII (Unicode and American Standard Code for Information Interchange)/Ports

Input and output devices

•      Input devices: Keyboards, mice, touch pads/ Optical mark recognition (OMR), optical character recognition (OCR), magnetic ink character recognition (MICR), radio frequency identification (RFID), radio tag, bar code scanners, magnetic stripe readers/Microphones/ Smart card readers/ Webcams, digital cameras/digital video cameras/Sensors, probes, real-time data collection/Composite devices: for example, game controllers/Touch-sensitive devices:

•      Output devices: Printers, monitors, speakers, projectors/CD-ROM (compact disc read-only memory), DVD (digital versatile/video disk) readers and burners.

     Some Resources for Reference
     http://www.authorstream.com/Presentation/MissBenjamin-112909-computer-hardware-introduction-input-output-devices-software-system-education-ppt-powerpoint/
 

    http://www.computerhope.com/jargon/i/inputdev.htm