edublog

chsgentech

Blog Entry

May 21, 2010 by · No Comments · Uncategorized

I didn’t have a project. I read some articles in the class website and watch the “Depth of Field and Lenses Explained” video.

Summary:

Aperture diameter=(Focal length)/(F-stop)

Short DOF—-large aperture—-large focal length—-short subject-to-camera distance

Current Event Article

May 11, 2010 by · No Comments · ITGS EXAM

Issue: Security. The first major rule of any business is that it must be open in order to succeed. The same can be said of your technology, it has to be working in order to be useful. Not only is it important to have your systems installed and setup properly, but they must be safeguarded against constant attacks as well.

IT Component: Currently, stronger and more malicious viruses are being released every day. Forms: Virus, worms, adware, spyware

Potential Solution: Firewall Protection. Each type of threat has it’s own unique characteristics and in general has it’s own unique solution. While following general safe use guidelines is a good start, it is not nearly enough. Securing any system, from a single machine to a complex network, requires different solutions tailored to meet the needs of that particular system.

Link: http://thetotalitsolution.com/support/security.php

Area of Impacts–Banking and Finance

May 5, 2010 by · No Comments · ITGS EXAM

Composition Rules

April 26, 2010 by · No Comments · ITGS EXAM

Pirates of Silicon Valley

March 23, 2010 by · No Comments · ITGS EXAM

The movie tells about the history and the development of the Apple and Microsoft company. Steve Jobs and Steve Woz founded Apple and competed against IBM but they neglected that Microsoft was their larger competitor.

Journal–Feb 19th

February 19, 2010 by · No Comments · ITGS

Today I found and watched some of the tutorials about SQL

http://www.w3schools.com/sql/sql_intro.asp

Summary:

Basic:

1. Select

Syntax: SELECT (DISTINCT) column_name(s) FROM table_name (WHERE column_name operator value)

* represents all the data

2. Order

Syntax: SELECT column_name(s) FROM table_name ORDER BY column_name(s) ASC|DESC

3.Insert

Syntax:INSERT INTO table_name (column1, column2, column3,…) VALUES (value1, value2, value3,…)

or INSERT INTO table_name VALUES (value1, value2, value3,…)

4. Update

Syntax: UPDATE table_name SET column1=value, column2=value2,… WHERE some_column=some_value

5. Delete

Syntax: DELETE FROM table_name WHERE some_column=some_value

Advance:

1. Top

Syntax: SELECT TOP number|percent column_name(s) FROM table_name

2.Like

Syntax: SELECT column_name(s) FROM table_name WHERE column_name (NOT) LIKE pattern

Wildcards:

% A substitute for zero or more characters

_ A substitute for exactly one character

[charlist] Any single character in charlist

[^charlist] or [!charlist] Any single character not in charlist

3. In: allows to specify multiple values in a WHERE clause

Syntax: SELECT column_name(s) FROM table_name WHERE column_name IN (value1,value2,…)

http://www.w3schools.com/sql/sql_between.asp

Criterion H Analysis and feasibility study

February 12, 2010 by · No Comments · ITGS, Project

Two possible IT solutions are using database software and software development.

The advantages and disadvantages of the two solutions are listed below.

Database:

Several kinds of information about the music, for example, the name, the instrument, the page number, can be input into a database. By using built-in functions of the software, information can be reorganized and extracted quickly.

Advantages:

  • Built-in functions make it more convenient to start inputting information.
  • Data are well organized.
  • Data are independent and relatively easy to be extracted.
  • Data are stored in a secure way.
  • l  The format is likely to be compatible with other programs.
  • l  Easy to print the data in a specific format.

Disadvantages:

  • The database software is expensive.
  • The format is not very flexible.

Software development:

A simple software can be written specially for the collecting of music.

Advantages:

  • The software is designed specially for the music so that it can be easier to input information.
  • The cost is relatively low.
  • Various data-extracting processes can be more easily realized by developing software.

Disadvantages:

  • It costs a long time to develop the software.
  • It may not be very compatible with other programs.

Evaluation:

Although both solutions offer feasible arguments, I thought that the advantages of using database software exceeded those of developing software.

First, not so many pieces of music are needed to be organized. The advantages of developing software may exceed if a huge amount of music is needed to be dealt with. The cost of the time for developing software is larger than the benefit of the convenience of inputting data in the situation I am dealing with, in which only several hundred pieces of music is to be organized.

Second, the format of database is more easy to be changed. If a new characteristic of the music becomes needed to be recorded, it would be much easier for a database than for developed software.

Third, the software “Microsoft Access 2007” had already been purchased and installed in my laptop. So it is less expensive and more convenient to use this database software.

For these reasons, I have chosen the database for the final solution.

I explained these two solutions to the musician. He said he preferred the first solution, too. “The second solution lacks of flexibility once the software is written, and it also costs too much time. Moreover, it would be better to have the data printed out.”

To solve the problem, several characteristics of the music should be chosen in order to make them more categorized. The information can be input after examining the design of the database. Each of the music will be allocated a new unique ID after organized. The music will then be put in order according to the new ID. When data need to be extracted later, the ID number can be found based on several characteristics of the music, and then the music can be found based on the ID number.

Digital Nation Reflection

February 11, 2010 by · No Comments · Others

This video make me realize that more and more young people are getting engaged in technology now. I’ve known before that entertainment technology like video games and some other online chatting tools can make people addicted. But this video showed that almost all kinds of technological products can make people addicted. There are a lot of people who still support these products because they think these are necessary for the next generation. However, some younger people don’t consider it as learning but regard it simply as entertaining. This will limit their learning in other fields of life. The using of technology by some of those students in MIT is reasonable as long as they are learning and using technology in a positive way and they can know what they are doing with technology. In contrast, the students who are in schools that make them playing with technology all the time should be concerned because it’s hard for them to develop a positive view of  what technology is and how to use it.

Surveying End Users

February 8, 2010 by · No Comments · ITGS, Project

I plan to verbally survey my end users.

The questions are below:

1. What do you think is the better way to organize the music?

  • Writing a program for a data collecting system (take longer, easier to input and extract)
  • Put data in database (fast, easy to change)
  • Other _______

2. Which of character about the music should be recorded

  • Pages
  • Previous number labeled on the music
  • Instruments
  • Handwriting/printing
  • Style of the music
  • More___________

CSS Tutorial

January 27, 2010 by · No Comments · Web Design

Link: http://www.w3schools.com/css/default.asp

What I’ve learned:

How to insert CSS: External Style Sheet (file with a “.css” extention); Internal Style Sheet (in the head part <style></style>); Inline Styles (after the name, style=”___”). The later one can replace the property that had been defined by the first ones.

1em=16px

Order rules for styling links: link visited hover active

Table: <table><tr><th></th>…..</tr><tr><td></td>…</tr>…

overlapping: z-index= (the greater at the top)

Shorthand:

Background: body { background:color image repeat  attachment position}

List Style: ul {list-style: type position image}  The style of the icons

Border: border: width style color

Margin/Padding: margin: .. .. .. ..   4 for t,r,b,l; 3 for t,rl,b; 2 for tb,rl; 1 for all

For us beginners, it’s more important to learn the structures and what the functions of different syntax are, as the software will help us choose the spelling and the value.