cs113EC

=01418113 **Course name : ** Computer and Information Technology = toc  Lecturers : Assoc. Prof. Dr. Chuleerat Jaruskulchai(T1) and Soontharee Koompairojn (T2)  **Lecture :**  section410 Tuesday 9:00 – 11:00 (EC5616) **Lab**
 * Date- time-Place **
 * section410 Monday 13:30 – 15:30 (SCL-303)
 * section411 Monday 15:30 – 17:30 (SCL-303) (Change to 16.00 – 18.00)
 * section412 Thursday 13:30 – 15:30 (SCL-301)

**Content **
Concepts of Computer and Information Technology. Computer components Computer Networks. Internet and World Wide Web.Computer Applications. Information system development. Database management. Computer Security, Ethics and privacy. Objectives =**Organization **= 2. Computer hardware and software <span style="font-family: 'Angsana New',serif; font-size: 14pt;">3. Operating system <span style="font-family: 'Angsana New',serif; font-size: 14pt;">4. Storage <span style="font-family: 'Angsana New',serif; font-size: 14pt;">5. Network, internet and world wide web <span style="font-family: 'Angsana New',serif; font-size: 14pt;">6. Database management <span style="font-family: 'Angsana New',serif; font-size: 14pt;">7. Computer security, Ethics and Privacy <span style="font-family: 'Angsana New',serif; font-size: 14pt;">8. Information system development <span style="font-family: 'Angsana New',serif; font-size: 14pt;">9. Enterpriase computing || <span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">1. Operating system <span style="font-family: 'Angsana New',serif; font-size: 14pt;">2. Word processing <span style="font-family: 'Angsana New',serif; font-size: 14pt;">3. Spread sheet <span style="font-family: 'Angsana New',serif; font-size: 14pt;">4. Internet and world wide web <span style="font-family: 'Angsana New',serif; font-size: 14pt;">5. Presentation software <span style="font-family: 'Angsana New',serif; font-size: 14pt;">6. Database <span style="font-family: 'Angsana New',serif; font-size: 14pt;">7. Homepage authoring || =**<span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Teaching method : **= <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lecture andactive learning in which students solve problems, answer questions, formulate questions of their own, discuss, explain, debate, or brainstorm during class
 * **<span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Give students an in-depth understanding of computer technology in business and society. **
 * = ==**<span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Lecture **== ||= ==**<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lab **== ||
 * <span style="font-family: 'Angsana New',serif; font-size: 14pt;">1. Introduction to computer

**<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Materials: **
<span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Lecture note, computers and edModo, <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5; text-align: justify;">Student must register and create an account at <span style="color: windowtext; display: block; font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5; text-align: justify;">[|https://www.edmodo.com/home#/group?id=5675188] <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5; text-align: justify;">and joints the group with code xgpq0d (This code will be expired after class has began one weeks)

**<span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Textbook **
<span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Gary Shelly and Misty Vermaat. Discovering Computers 2011(Complete).

**<span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Office hours **

 * <span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Assoc. Prof. Dr. Chuleerat Jaruskulchai Tu. 13:00 – 14:00 pm and by appointment (fscichj at ku.ac.th)
 * <span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Ajan. Soontharee Koompairojn Mon 13:00-15:00 pm and by appointment (fscisok at ku.ac.th)

**<span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Grade criteria **
=**<span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Activities **=
 * 1) <span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Midterm 25%
 * 2) <span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Final 25%
 * 3) <span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Assignments 10%
 * 4) <span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Lab 25%
 * 5) <span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Online Quiz 10%
 * 6) <span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Class participation 5%
 * <span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Grade assessment **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">: <span style="font-family: 'Angsana New',serif; font-size: 16pt;">grading on a //curve//
 * **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Date ** || **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Subjects ** || **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Activities ** ||
 * <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">1 || <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">Tu. 20/8/13 || **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lecture: **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">[[file:myChapter 01.pdf| Introduction to computer]] (By T1) || <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Reading Ch.1 ||
 * <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">2 || <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">Tu. 27/8/13 || **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lecture: **<span style="font-family: 'Angsana New',serif; font-size: 14pt;"> [[file:Chapter 02.pdf|Internet and World wide web]] <span style="font-family: 'Angsana New',serif; font-size: 19px; line-height: 1.5;">(By T1)

<span style="background-color: #e7f452; color: #0000ff; font-family: Georgia,serif;">online quiz <span style="background-color: #e7f452; color: #0000ff; font-family: Georgia,serif;">stat at after midnight on 27/8/2013 and <span style="background-color: #e7f452; color: #0000ff; font-family: Georgia,serif;">closed before midnight on 28/8/13) || <span style="font-family: 'Angsana New',serif; font-size: 14pt;">(By T1)
 * <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lab1: **<span style="font-family: 'Angsana New',serif; font-size: 14pt;"> Introduction to computer and operating system (By T2)
 * <span style="font-family: 'Angsana New',serif; font-size: 14pt;">File types
 * <span style="font-family: 'Courier New',Courier,monospace;">Accessories
 * <span style="font-family: 'Courier New',Courier,monospace;">CutePDF
 * <span style="font-family: 'Courier New',Courier,monospace;">Compressing and Archiving Programs
 * <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Internet and WWW || <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Reading Ch.2
 * <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">3 || <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">Tu. 3/9/13 || **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lecture: **<span style="font-family: 'Angsana New',serif; font-size: 14pt;"> [[file:Chapter 03-4p.pdf|Software for system]] and <span style="font-family: 'Angsana New',serif; font-size: 19px; line-height: 1.5;">[[file:Chapter 04-p4.pdf|ch4]],
 * <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lab2: **<span style="font-family: 'Angsana New',serif; font-size: 14pt;"> Presentation software (power point) (By T2)
 * <span style="font-family: 'Courier New',Courier,monospace;">command และ function
 * <span style="font-family: 'Courier New',Courier,monospace;">Design || <span style="background-color: #ffffff; color: #383d48; font-family: 'Helvetica Neue',Helvetica,Arial,sans-serif; font-size: 14px;">Assignment-2 due on 2/9/2013

<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Reading Ch.3 || <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Homework 3 due || <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Homework 4 due || <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Homework 5 due || <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Homework 6 due ||
 * <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">4 || <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">Tu. 10/9/13 || **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lecture: **<span style="font-family: 'Angsana New',serif; font-size: 14pt;"> Input & Output ( [[file:Chapter 05-4p.pdf|ch5]], [[file:Chapter 06-4p.pdf|ch6]]) (By T1)
 * <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lab3: Power point (By T2) **
 * <span style="font-family: 'Courier New',Courier,monospace;">Object insertion
 * <span style="font-family: 'Courier New',Courier,monospace;">Animation
 * <span style="font-family: 'Courier New',Courier,monospace;">Hyperlink || <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Reading Ch.5 & 6 ||
 * <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">5 || <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">Tu. 17/9/13 || **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lecture: **<span style="font-family: 'Angsana New',serif; font-size: 14pt;"> [[file:Chapter 07-4p.pdf|Storage]] (By T1)
 * <span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Lab4: **<span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;"> (By T2)
 * <span style="font-family: 'Courier New',Courier,monospace;">Command and function
 * <span style="font-family: 'Courier New',Courier,monospace;">View and tool bar
 * <span style="font-family: 'Courier New',Courier,monospace;">Cell and table and work sheet
 * <span style="font-family: 'Courier New',Courier,monospace;">formatting
 * <span style="font-family: 'Courier New',Courier,monospace;">Data menu || <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Reading Ch.7 ||
 * <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">6 || <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">Tu. 24/9/13 || **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lecture: **<span style="font-family: 'Angsana New',serif; font-size: 14pt;"> [[file:Chapter 08-4p.pdf|Operating system]] (By T1)
 * <span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Lab5: Database **<span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;"> (By T2)
 * <span style="font-family: 'Courier New',Courier,monospace;">Auto format and auto fill
 * <span style="font-family: 'Courier New',Courier,monospace;">Calculation
 * <span style="font-family: 'Courier New',Courier,monospace;">SUM, AVERAGE, MAX, MIN, SUMIFS, etc || <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Reading Ch.8
 * <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">7 || <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">Tu. 1/10/13 || **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lecture: **<span style="font-family: 'Angsana New',serif; font-size: 14pt;"> Application software (By T1)
 * <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lab6: Database **<span style="font-family: 'Angsana New',serif; font-size: 14pt;"> (By T2)
 * <span style="font-family: 'Courier New',Courier,monospace; font-size: 12px;">Conditional formatting
 * <span style="font-family: 'Courier New',Courier,monospace; font-size: 12px;">Print function
 * <span style="font-family: 'Courier New',Courier,monospace; font-size: 12px;">Graph || <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Reading Ch.8 ||
 * <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">8 || <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">Tu. 7/10/13 || **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lecture: **<span style="font-family: 'Angsana New',serif; font-size: 14pt;"> [[file:Chapter 09-4p.pdf|Computer network]] || <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Reading Ch.9 ||
 * || <span style="background-color: #ffff00; display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">Tu. 14/10/13 || **<span style="background-color: #ffff00; font-family: 'Angsana New',serif; font-size: 14pt;">Midterm ** ||  ||
 * <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">9 || <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">Tu. 22/10/13 || **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lecture: **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">[[file:Chapter 14-enterprise.pdf|Enterprise computing]] (By T2)
 * <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lab7: **<span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Spread sheet (MS-Excel) (By T1)
 * <span style="font-family: 'Courier New',Courier,monospace;">Command and function
 * <span style="font-family: 'Courier New',Courier,monospace;">View and tool bar
 * <span style="font-family: 'Courier New',Courier,monospace;">Cell and table and work sheet
 * <span style="font-family: 'Courier New',Courier,monospace;">formatting
 * <span style="font-family: 'Courier New',Courier,monospace;">Data menu || <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Reading Ch.14 ||
 * <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">10 || <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">Tu. 29/10/13 || **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lecture: **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Enterprise computing (By T2)
 * <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lab8: **<span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;"> Spreadsheet (T1)
 * <span style="font-family: 'Courier New',Courier,monospace;">Auto format and auto fill
 * <span style="font-family: 'Courier New',Courier,monospace;">Sort/Filter
 * <span style="font-family: 'Courier New',Courier,monospace;">Calculation
 * <span style="font-family: 'Courier New',Courier,monospace;">SUM, AVERAGE, MAX, MIN, SUMIFS, etc || <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Reading Ch.14
 * <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">11 || <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">Tu. 5/11/13 || **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lecture: ** <span style="font-family: 'Angsana New','serif'; font-size: 18.6667px;">[[file:Chapter 10.pdf|Database management ]](By T1)
 * <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lab9: **<span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Spreadsheet (By T1)
 * <span style="font-family: 'Courier New',Courier,monospace; font-size: 12px;">Conditional formatting
 * <span style="font-family: 'Courier New',Courier,monospace; font-size: 12px;">Print function
 * <span style="font-family: 'Courier New',Courier,monospace; font-size: 12px;">Graph || <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Reading Ch.10 ||
 * <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">12 || <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">Tu. 11/11/13 || **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lecture: ** <span style="font-family: 'Angsana New','serif'; font-size: 18.6667px;">[[file:Ch 12-development.pdf|Information system development]] (ByT2)
 * <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lab10: **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Google Docs
 * <span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Form
 * <span style="font-family: 'Angsana New',serif; font-size: 14pt; line-height: 1.5;">Calculate Data from Form || <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Reading Ch.13
 * <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">13 || <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">Tu. 18/11/13 || **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lecture: ** <span style="font-family: 'Angsana New','serif'; font-size: 18.6667px;">[[file:Ch 13-program.pdf|Program development]] (By T2)
 * <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lab11: **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Web authoring (By T1) || <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Reading Ch.14 ||
 * <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">14 || <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">Tu. 25/11/13 || **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lecture: ** <span style="font-family: 'Angsana New','serif'; font-size: 18.6667px;">Program development (By T2)
 * <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lab12: **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Web authoring (By T1) || <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Reading Ch.14
 * <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">15 || <span style="display: block; font-family: 'Angsana New',serif; font-size: 14pt; text-align: center;">Tu. 2/12/13 || **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Lecture: **<span style="font-family: 'Angsana New',serif; font-size: 14pt;"> [[file:Ch 11-ethics.pdf|Computer security, Ethics and privacy]] (By T2) || <span style="font-family: 'Angsana New',serif; font-size: 14pt;">Reading Ch.11 ||
 * ||  || **<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Final ** ||   ||

<span style="font-family: 'Angsana New',serif; font-size: 14pt;">Note : Every week, there will be an online test