ITGS Syllabus:

Strand : IT Systems

3.4 Internet(Current topic)

IT concepts to address in this topic

Fundamentals

• WWW (World Wide Web), URL (uniform resource locator), internet, intranet, extranet
• Internet protocols: for example, HTTP (hypertext transfer protocol), HTTPS (hypertext transfer protocol
secure), FTP (file transfer protocol), TCP/IP (transmission control protocol/internet protocol)
• IP address
• Modem, browser, internet service provider (ISP), bandwidth, download, upload, streaming audio/
video, compression, decompression, cache
• Domain names, domain name system (DNS)
• Features of a website: for example, hyperlinks, navigation, metatags, tags, forms
• Features of a browser: for example, bookmarks, visited links, tabs
• Web-based languages: for example, hypertext markup language (HTML), JavaScript
• Adding functionality to a browser (for example, plug-ins)
• Data-driven websites: for example, active server page extended (ASPX), personal home page (PHP)
• Site management: for example, web hosting, uploading
• Other site use: for example, bounce rate, click-through rate (CTR), avatar, profile
Tools
• Search engines, web crawler/spider, search directories, search techniques, filtering, keyword density,
keyword prominence, ranking of sites
• Social networking: for example, newsgroups, message boards, chat rooms, forums, instant messaging
• Email, email server, list server
• Web 2.0, Web 3.0 and beyond, collaborative online tools: for example, wikis, blogs, micro-blogs, RDF
(resource description framework) site summary feeds, RSS (really simple syndication) feeds, mashups,
forums, social bookmarking, online collaborative applications, podcasts, photocasts, vidcasts, social
networking sites, templates, tagging, viral marketing, webcasts, widgets, virtual worlds and learning
environments
• Web databases, encyclopedias
Services
• Online advertising and marketing technologies: for example, banners, pop-ups, cookies
• Push–pull technologies: for example, email newsletters
• Content management systems: for example, Moodle, Blackboard
• E-commerce technology: for example, business-to-business (B2B), business-to-consumer (B2C),
consumer-to-consumer (C2C), payment services, secure transactions
• The World Wide Web Consortium (W3C)
Internet threats and security
• Internet security: for example, firewall, proxy server, SSL (secure sockets layer), encryption, public and
private keys, digital signatures
• Internet threats: for example, global viruses, hackers, spam, phishing, pharming, spyware, adware
Practical techniques
• Collaborative online tools: for example, wikis, blogs, RSS feeds, mashups, forums, social bookmarking,
online collaborative applications, podcasts, photocasts, vidcasts, social networking sites, templates,
virtual worlds and virtual learning environments

3.7 Databases


IT concepts to address in this topic


Database organization
•Table
• Field, data types, key field/primary key, secondary key
• Record
• Flat-file database, relational database, normalization
• Database management system
• Specialized databases: for example, web databases, online encyclopedias

Functions
• Data validation: data types, range check, check digit, field size, input mask, drop-down list
• Queries: for example, searching, sorting, filtering, use of Boolean operators (AND, NOT, OR)
• Data entry form
• Report generation
• Macros
• Transfer of data between databases and other applications


Data storage and access
• Data integrity, reliability, redundancy
• Data matching, data mining
• Database security

Practical database techniques
• Table
• Field, data types, key field/primary key, secondary key
• Record
• Linking tables to create a relational database
• Data maintenance: changing, editing, deleting records
• Queries: for example, searching, sorting, filtering, use of Boolean operators (AND, NOT, OR)
• Data entry form
• Report generation
• Creating and editing simple macros
• Mail merge

Note. Topics in bold already covered in class and once unit(Like 3.7 databsae) is over test will be there.