Thursday, February 5, 2015

Problem Solving Phase

The key to solving a problem is understanding what is being asked to do, logic how to do it, and get it done.



The Five (5) Steps in Problem Solving Phase
  1. Define the problem
  2. Find a solution
  3. Evaluate alternate solutions
  4. Choose the most efficient solution and write an algorithm
  5. Test algorithm for correctness
To define the problem, programmers use a defining diagram, commonly referred to as an IPO table. 
Defining Diagram - a three column table that separates a given problem into Input, Processing, and Output.

The IPO table does not solve the problem; it simply outline the procedural steps.  Calculations are not shown in the table.  

Example of IPO Table
 
Problem: Calculate and output the total cost of three items.


Input
Processing
Output
Cost1
Cost2
Cost3
1.   Read Cost1, Cost2, Cost3
2.   Calculate Total
3.   Print Total
Total

Input
We have assigned a name (variable name) to each of the cost values that will be entered.
we will learn more about variables at a later point.

Processing
Each processing step is numbered.  
The processing steps are what steps the computer will have to do to solve the problem.
The first processing step is always to (read) the variables that are inputted.
The final processing step is always to display (or print) was is to be outputted.

Output
Anything that needs to be displayed or the result of what is being asked to solve

You try one...
Prepare the defining diagram for the following problem:  Calculate and output the average of two quiz grades.  (hint...there are four processing steps)

Wednesday, January 28, 2015

Thursday, January 22, 2015

The Internet and the World Wide Web

The Internet and The World Wide Web
ž  Many people use the terms Internet and World Wide Web (aka. the Web) interchangeably, but in fact the two terms are not synonymous. The Internet and the Web are two separate but related things.
ž  The Internet is a massive network of networks, a networking infrastructure. It connects millions of computers together globally, forming a network in which any computer can communicate with any other computer as long as they are both connected to the Internet. Information that travels over the Internet does so via a variety of languages known as protocols.
ž  The World Wide Web is a way of accessing information over the medium of the Internet.
ž   It is an information-sharing model that is built on top of the Internet. The Web uses the HTTP protocol, only one of the languages spoken over the Internet, to transmit data.
ž  The Web also utilizes browsers, such as Internet Explorer or Firefox, to access Web documents called Web pages that are linked to each other via hyperlinks.
ž  The Web is just one of the ways that information can be disseminated over the Internet.
ž  The Internet, not the Web, is also used for:
ž   e-mail, which relies on SMTP (simple mail transfer protocol)
ž  Usenet (worldwide bulletin board system) news groups
ž  Instant messaging and FTP (file transfer protocol; works the same as HTTP).
ž  So the Web is just a portion of the Internet

Search Engines...
ž  A ‘search engine’ keeps indexed records of all the web pages that can be accessed via hot links.
ž  It is a software system that is designed to search for information on the WWW
ž  There are three major types of search engines:
¡  Crawler-based search engines
¡  Human-powered directories
¡  Meta-search engines
ž  Crawler-based search engines create their listings automatically by using a piece of software to ‘crawl’ or ‘spider’ the web and then index what it finds to build the search base. 
ž  They are good when you have a specific topic in mind and can be very efficient in finding relevant information in that situation. 
ž  Examples include:
¡  Google
¡  AllTheWeb
¡  AltaVista
ž  Human-powered directories depend on human editors to create their listing.  Typically, webmasters submit a short description to the directory for their websites, and these manually edited descriptions will form the search base.
ž  They are good when you are interested in a general topic of search.
ž  Not an efficient way to find information when a specific search topic is in mind.
ž  Examples include:
¡  Yahoo directory 
ž  (Yahoo also provides crawler-based results)
¡  Open Directory
¡  LookSmart
ž  Human-powered directories depend on human editors to create their listing.  Typically, webmasters submit a short description to the directory for their websites, and these manually edited descriptions will form the search base.
ž  They are good when you are interested in a general topic of search.
ž  Not an efficient way to find information when a specific search topic is in mind.
ž  Examples include:
¡  Yahoo directory 
ž  (Yahoo also provides crawler-based results)
¡  Open Directory
¡  LookSmart
ž  Meta-search engines transmit user-supplied keywords simultaneously to several individual search engines to actually carry out the search. 
ž  Search results returned from all the search engines can be integrated, duplicates can be eliminated and additional features such as clustering by subjects within the search results can be implemented by meta-search engines.
ž  Meta-search engines are good for saving time by searching only in one place and sparing the need to use and learn several separate search engines.

Friday, November 21, 2014

First Semester IT Exam Schedule



Practical Exams:
Class 3A
     Spreadsheet -December 2, 2014 [Day 3] @ 1:22 pm - 2:12 pm
     Database - December 3, 2014 [Day 4] @ 8:10 am - 9:00 am

Class 3C
     Spreadsheet -December 1, 2014 [Day 2] @ 12:32 pm - 1:22 pm
     Database - December 1, 2014 [Day 2] @ 1:22 pm - 2:12 pm

Class 3D
     Spreadsheet -December 2, 2014 [Day 3] @ 10:55 am - 11:45 am
     Database - December 3, 2014 [Day 4] @ 2:12 pm - 3:02 pm

Theory Exam:
All 3rd Form Classes on Tuesday, December 9, 2014 @ 1:10 pm - 3:10 pm

Wednesday, November 5, 2014

Practical Test on Access Dates

3A  Cycle 8 Day 4
3C  Cycle 8 Day 6
3D  Cycle 8 Day  5

The test will assess you ability to:
  1. Create a database
  2. Create tables
  3. Format fields
  4. Select Primary Key
  5. Create a relationship
  6. Perform Select queries to extract data based on criteria
  7. Perform Make-table queries to create new tables based on criteria
  8. Perform Summary queries using functions to extract data