Table of Contents

[2017, Second Semester]

Welcome

Welcome to 204100, Information Technology and Modern Life (section 701) Make sure to check back at this page regularly for announcements and important news. Please also subscribe to the facebook group of this class for a more real-time channel of communications.

Announcement

Schedule of Classes

Instructor

Prakarn Unachak fortmanpung+204100@gmail.com

Grading

The course grade will be calculated as follows:

Assignment Submission

Lab assignments are divided into two categories. In-lab assignments are to be finished and shown to the instructor during the lab hour. Take-home exercises are longer assignment intended to be finished a week after it is handed out. Both are to be submitted electronically on the course website unless specifically noted otherwise. The URL for assignment submission is http://hw.cs.science.cmu.ac.th. For those of you who have not received the username and password for assignment submission, please contact me at fortmanpung+204100@gmail.com or facebook message me.

The checklist for submitted assignments can be viewed here: https://goo.gl/ZC1EyZ ( Note: You'll only get credit for an assignment if you have either FULL (full) or PARTIAL (half) for it. If the instructor feel that you need to rework your assignment before you can get full credit, you'll get a PARTIAL, where you need to make correction and submit the assignment again, before either Midterm or Final exam, depending on when the assignment is issued. A NO CREDIT will be assigned to an assignment if either (1) A hard deadline of either Midterm or Final exam has passed, or (2) There is a reason for me to believe that you have copied other's work (please don't do this). Unfortunately, you cannot fix NO CREDIT.

Homework assigned during lecture sessions are either in paper form, where it must be submitted to the instructor at the start of the next lecture session, or web form, which need to be completed online.

File Submission System (Getting Account & Using The System)

Some assignments will require you to submit a file as your work. For this, you need to use the department's file submission system. You can access the file submission system by following this link: http://hw.cs.science.cmu.ac.th and follow these steps:

  1. Select the course you want to send the file for
  2. Click “Choose File” and select the file you want to upload (The file can not be larger than 15MB and does not have .exe extension)
  3. Click “Upload”
  4. If the upload is successful, you will see the file and the upload timestamp on the file list

If you want to remove a file, click Delete

===== Notes =====

A. If you don't see the course you want to submit a file, or if you have any problems submitting a file, contact the instructor ASAP
B. If you submit a file whose name is already in the list, the new file will overwrite the old file.

Collaboration and Cheating

For homework assignment, students are allowed to discuss the assignments and/or get help from other students. In such circumstance, however, students are required to write down the name of the person the discussion has been made with. Also, each student must write down the answers in his/her own words. Assignment copying is considered cheating and will be penalized accordingly.

Assignment Due Date and Late Policy

In-lab exercise are due midnight the day it is issued, at 11:59pm. Preferably, you will finish and submit the exercise during the lab hour. In-lab assignment WILL NOT BE ACCEPTED AFTER DUE DATE If you cannot attend lab that day, you need to contact the instructor to hand in the in-lab assignment at later date.

Take-home assignments are due one to two weeks after it is issued, at 11:59pm. So if an assignment is given this Tuesday, it is due next Monday at 11:59pm (unless stated otherwise on the assignment sheet.) Substantial work on that assignment need to be submitted no later than the due date.

Corrections are due before midterm exam will only be accept until midnight before midterm exam. Those due after midterm will only be accept until midnight before final exam.

Course Schedule (Tentative)

Week Lecture (CSB202) Lab (CSB303)
01 (January 2nd, 5th) –No Class– Introduction + Computer Systems
02 (January 9th, 12th) Computer Systems MS Windows
03 (January 16nd, 19th) MS Word MS Word
04 (January 23th, 26th) –Graduation– MS Word
05 (January 30th, February 2nd) Computer Networks MS PowerPoint
06 (February 6th, 9th) Online Services MS PowerPoint
07 (February 13th, 16nd) Basic of Web Design Google Sites
08 (February 20th, 23th) –Break– Google Sites
Midterm Exam (February 28th, 2018 (Wednesday), 12:00pm-2:00pm @ RB5308)
09 (March 6th, 9th) Data Processing Google Form
10 (March 13th, 16th) Database in Everyday Life MS Excel
11 (March 20th, 23th) –No Class– MS Excel
12 (March 27th, 30th) Computer Ethics and Security MS Excel
13 (April 3rd, 6th) Presentation –Holiday–
14 (April 10th, 13th) Presentation –Songkraan–
15 (April 17th, 20th) –Songkraan– MS Access
16 (April 24th, 27th) Presentation MS Access
Final Exam (May 10th, 2018 (Thursday), 3:30pm-5:30pm @ RB5308 )

Handouts & Assignments

Slides Assignment (due date) File Naming Format
#0.1: Creating Google Account Google Account
#0.2: Google Drive Google Drive
#0.3: Office 365 Office 365
Midterm Materials
#01: Computer System Computer System HW01 (22 JAN)
#02: MS Windows MS Windows Lab01 (in-lab) (25 JAN)
Lab01 (take-home) (25 JAN)
#03: MS Word pt.01-04
pt.05-06
pt.07-09
pt.10
Example: main document
Example: recipient list 01
Example: recipient list 02
Lab02
In-lab (16 JAN)
Take-home (29 JAN)
Lab03 (take-home) (05 FEB)
Lab03 (in-lab) (26 JAN)

LAB02_inlab_5XXXXXXXX.docx
LAB02_takehome_5XXXXXXXX.docx
LAB03_takehome_5XXXXXXXX.docx
LAB03_inlab_5XXXXXXXX.docx
#04: Computer Networks & The Internet The Internet HW02 (12 FEB)
#05: Online Services Online Services HW 03 (19 FEB)
#06: MS PowerPoint pt.01-06
pt.07-12
Lab04
In-lab (02 FEB)
Take-home (15 FEB)

LAB04_inlab_5XXXXXXXX.pptx
LAB04_takehome_5XXXXXXXX.pptx
#07: Basic of Web Design Web Design
#08: Google Sites Google Sites
Example Website
Lab05 (In-lab) (16 FEB)
Lab05 (Take-home) (01 MAR)
Final Materials
#09: Data Processing Data Processing
Updated 2018/03/27
#10: Database & Everyday Life Database HW04 (26 MAR)
[DOUBLE CREDIT]
#11: Computer Ethics and Security Ethics and Security HW05 (9 APR)
#12: Google Form Google Form Lab06 (In-lab) (09 MAR)
Lab06 (Take-home) (22 MAR)
#13: Ms Excel pt.01
pt.02
pt.03
pt.04
grade_example
survey_example
Lab07
In-lab (16 MAR)
Take-home (29 MAR)
lab07_scoresheet_en.xlsx
Lab08 (in-lab) (Mar 23)
lab08_data_en.xlsx
Lab08 (take-home) (Apr 19)

LAB07_inlab_XXXXXXXXX.xlsx
LAB07_takehome_XXXXXXXXX.xlsx

LAB08_inlab_XXXXXXXXX.xlsx

LAB08_takehome_XXXXXXXXX.xlsx
#14: Ms Access 01 - Intro & Table
02 - Form
03 - Query
04 - Report
05 - Relationship
MyStudent.accdb
Lab09
In-lab (Apr 20)
Take-home (May 04)
Lab10
In-lab (Apr 27)
Take-home (May 09)

LAB09_inlab_XXXXXXXXX.accdb
LAB09_takehome_XXXXXXXXX.accdb

LAB10_inlab_XXXXXXXXX.accdb
LAB10_takehome_XXXXXXXXX.accdb

Older Pages

[2017, First Semester]