Sunday, January 26, 2020

Introduction to the Internet

Internet Notes and Activities;

Visit the the links below and write brief short notes on your OneNote Page.

Task 1.

Internet Notes

Definitions of internet; http://www.brighthub.com/computing/enterprise-security/articles/63387.aspx#

Internet, extranet and intranet distinguished

http://www.slideshare.net/dyerah/internet-intranet-and-extranet

Task 2
Go thro presentations and videos below;
Resources for Internet
TCP IP and the Internet ppt


Types of internet Protocols


Videos








Task 3
Use your notebook page in OneNote to post all your notes below.
  • Distinguish between IP address and Mac address
  • What are domain names and DNS?
  • Most websites will have Hyperlinks, Metatags, tags. Describe each one of them.
Internet Website Tools.
Distinguish between the following tools as used in websites
  • Search engines
  • Keyword density
  • Keyword prominence
  • Page ranking
Social Networking
What is a social networking site?
What are the most common and recent social networking site?

SEO -Search engine optimization
Search engine optimization is a methodology of strategies, techniques and tactics used to increase the amount of visitors to a website by obtaining a high-ranking placement in the search results page of a search engine

https://searchengineland.com/guide/what-is-seo

Web 1.0, Web 2.0, web 3.0 and Web 4.0 and web 5.0



Write short notes on the following;
 Define each term listed here: wikis, blogs, micro-blogs, RDF(resource description framework), 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.

Research and prepare a short presentation for the assigned tasks

Internet Services
- What are web database? Give examples of web database you know. Abdi
- Describe the different online marketing technologies available. Alina
- Describe what a content management system is. an examples is Moodle. Sophie
- Distinguish with examples between push and pull technologies. Shaan
- Describe the following E-commerce technologies; B2B, B2C and C2C. Arman
- Describe the different online payment services; e.g Paypall. Adnan
- Describe the role of The World Wide Web Consortium (W3C). Arshman

Task 6
Internet Security
 Internet security can be provided by using Firewalls, Proxy servers, Encryptions, and Digital signatures
  • Using diagrams explain how firewalls work. Shiloh
  • Describe the role of proxy server in the management of Internet security. Aly
  • Describe what SSL is. Yesha
  • What is encryption and how is Public key different from Private key encryption. Use diagrams where possible. Ashhal and Aimaan
  •  Describe what digital signatures are and explain how they function. Simin
  • Describe other internet security measures in place and describe how each of the works.Khushbu
Internet Threat
Describe each of the internet threat below and suggest the several solutions with examples where possible for each of the threats.
  • Types of Viruses; Hisham
  • Hackers Tia
  • Phishing Faith
  • Spaminng Nami
  • Pharming Raphael
  • Spyware Jai
  • Adware Saliha

Monday, January 20, 2020

Database Project

Create a database product using MS Access that can be used to solve a unique clients problem in your community. The task will be done individually but you can consult widely from peers, database experts and from online tutorials


Your database should;
  • address unique problem (example; Train ticketing database).
  • have at least two related tables.
  • at least four queries with some complex calculations applied.
  • a well designed switchboard that loads first when the database opened.
  • include a logo in the switchboard with appealing colors used in the different forms.
  • have at least three forms.
  • use macros where possible.
  • have at least two well designed reports.
  • At least 5 min screencast of how the product functions should be uploaded on managebac.


    ONLY A screencast explaining how the product functions and what techniques were used,
     will be uploaded on managebac.

    Assessment Rubric

Level
Descriptors
1-4
Simple product developed that does not capture effectively the details of some limited requirement for the product listed. The use of database techniques in the software of choice is limited in the development of the product. The product does not solve a specific practical problem. The product fails to function as required. The screen cast fails to show how parts of the product function.
5-9
Good quality product developed that captures effectively some of the details for the database product as listed. Some of the database techniques are used appropriately in the development of the product. The product solves to some extent a practical problem. Product functions as required. The screen cast shows how some parts of the product function.
10-14
Excellent quality product developed that captures effectively most the details of most database productMost of the techniques in the software of choice are competently and appropriately used in the development of the product. The product solves effectively a practical problem. Most of the section of the product function effectively. The screen cast shows in detail how most of the product functions and how it was designed

Sunday, January 19, 2020

Databases Applications Assignment

You will be assigned a database research activity in pairs or otherwise. This activity will be assessed. Your task will be to research on the assigned area and prepare a presentation that will last for less that five minutes. Any mode of presentation can be used.

  1. Identify and name a database in the area assigned.
  2. Describe briefly how the database is used in the filed.
  3. What are the benefits of the named database in that field.
  4. What are some of the possible issues problems of using the database in the field?
  5. Suggest some of the specific solutions to some of the problems of using the database in the field.
Shaan & Sophie ; Medical database

Arman & Faith; Hotel Database

Shiloh & Simin; Airline reservation Database

Herzi & Khushbu: University application database

Hisham & Yesha; Mapping database

Adnan & Saliha; Digital Policing Database

Raphael & Alina & Asrhman; Online voting database

Aly & Nami; Military Database

Ashhal & Tia; Social Media Databases

Aimaan & Jai; Music Databases.


Databases Assessment Rubric
0-4: 
The presentation is fairly prepared and presented. The database is described partially with limited links to the scenario. The impacts of the database is superficial and the social issues are stated with limited evidence from research. The solutions suggested are fairly viable and supported with limited research evidence.


5-9: The presentation is properly prepared and presented. The database in the assigned field is described well with some links to the scenario. The impacts of the database is good and the social issues are explained with some evidence from research. The solutions suggested viable and supported with some research evidence.


10-14: The presentation is well prepared and presented. The description database and the issues is detailed and supported with evidence from research linked to the scenario. The impacts of the database is clear and the social issues described with some evidence from research. The solutions suggested are practical and supported with good research evidence.


15-19: The presentation is thoroughly prepared and presented. The database is described clearly with clear links to scenario. The impacts of the technology are thorough and the social issues are stated with extensive evidence from research. The solutions suggested are laudable and supported with sound research evidence..

Sunday, January 5, 2020

Data Transformations: Databases

Introduction to Databases

Links to database notes 

Database Normalization


Practical Exercises


Use the downloaded GCFAccess2010Sample the link sample database perform the following practical tasks.
a) How many tables have been related to create the Cakes & Pies Sold query?
b) Create a query using Customers Table that filters customer whose First names start with letter A, B, C and D. Save query as ABCD. 
b) Study how Decembers orders query was created and create 2011 Orders query.
c) Create a Switchboard Form that opens all the listed forms and the two Reports

Write short notes on the following;
Databases News Articles
1. Google Maps Databases












Mid-term DS Paper 3 Research Activities

  See below the assigned area of investigation Az-zara:  AI-Based Hiring Platforms: HireVue Objective: Research how HireVue uses AI-driven...