Table of Contents

[2019, First 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

Section 701

Instructor

Section 701: 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.

The checklist for submitted assignments can be viewed here ( 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. Click on “Lec” tab for writing work and “Lab” tab for lab work. (We will only be using Lab)
  2. Select the course you want to send the file for
  3. 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)
  4. Click “Upload”
  5. 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. There is no need to delete the old file first.

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.

Holiday & Important Days

Holiday & Important Days Date
First day of semester / classes August 5, 2019
National Science Week 2019 August 18-20, 2019
Mid-term examinations (no classes) September 30 - October 4, 2019
Last day of semester/classes November 23, 2019
Final examinations November 25 - November 23, 2019

Course Schedule

Week Lecture (Tue) Lab (Fri)
01 (August 6th, 9th) Introduction MS Word
02 (August 13th, 16th) Computer Systems MS Word
03 (August 20th, 23rd) – No Class – MS Word
04 (August 27th, 30th) Computer Systems MS PowerPoint
05 (September 3rd, 6th) Computer Networks MS PowerPoint
06 (September 10th, 13th) Online Services – No Class –
07 (September 17th, 20th) Basic of Web Design Google Sites
08 (September 23rd, 27th) – No Class – Google Sites
Midterm Exam (October 5th, 2019 (Saturday), 3:30pm-5:30pm @ RB3401, RB3402)
09 (October 8th, 11th) Data Processing Google Form
10 (October 15th, 18th) Database in Everyday Life MS Excel
11 (October 22nd, 25th) Computer Ethics and Security MS Excel
12 (October 29th, November 1st) Presentation MS Excel
13 (November 4th, 8th) Presentation MS Access
14 (November 11th, 15th) Presentation MS Access
15 (November 18th, 22nd) Presentation MS Access
Final Exam (December 1st, 2019 (Sunday), 12:00pm-2:00pm @ RB5401 )

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
#0.4: MS Windows MS Windows
Midterm Materials
#01: Computer System Computer System HW01 (SEP 02)
#02: MS Word pt.01-04
pt.05-06
pt.07-09
pt.10
Report Example
Finished Report and Images
Example: main document
Example: recipient list 01
Example: recipient list 02
LAB01(both)
In-lab (AUG 16)
Take-home (AUG 22)

LAB02(in-lab) (AUG 23)
LAB02(take-home) (AUG 29)

lab01_inlab_XXXXXXXXX.docx
lab01_takehome_XXXXXXXXX.docx

lab02_inlab_XXXXXXXXX.docx
lab02_takehome_XXXXXXXXX.docx
#03: Computer Networks & The Internet The Internet HW02 (SEP 16)
#04: Online Services Online Services HW03 (SEP 23)
#05: MS PowerPoint pt.01-06
pt.07-12
LAB03(both)
In-lab (AUG 30)
Take-home (SEP 12)

lab03_inlab_XXXXXXXXX.pptx
lab03_takehome_XXXXXXXXX.pptx
#06: Basic of Web Design Web Design
#07: Google Sites Google Sites
Example Website
Lab04(In-lab) (SEP 20)
Lab04(Take-home) (OCT 03)
Final Materials
#08: Data Processing Data Processing
#09: Database & Everyday Life Database HW04 (DOUBLE CREDIT) (OCT 28)
#10: Computer Ethics and Security Ethics & Security HW05 (NOV 04)
#11: Google Form Google Form Lab05(In-lab) (OCT 11)
Lab05(Take-home) (OCT24)
Alternative URL
#12: Ms Excel pt.01
pt.02
pt.03
pt.04
grade_example
survey_example
Lab06(Both)
lab06_scoresheet_en.xlsx
In-lab (OCT 18)
Take-home (OCT 31)

Lab 07 (In-lab) (OCT 25)
Lab 07 (Take-home) (NOV 07)


lab06_inlab_XXXXXXXXX.xlsx
lab06_takehome_XXXXXXXXX.xlsx

lab07_inlab_XXXXXXXXX.xlsx
lab07_takehome_XXXXXXXXX.xlsx
#13: Ms Access 01 - Intro & Table
02 - Form
03 - Query
04 - Report
05 - Relationship
MyStudent.accdb
Lab 08 (both)
In-lab (NOV 08)
Take-home (NOV 21)
lab08_en.accdb

Lab09 (both)
In-lab (NOV 15)
Take-home (NOV 28)
14_Students_class_grade.accdb

lab08_inlab_XXXXXXXXX.accdb
lab08_takehome_XXXXXXXXX.accdb



lab09_inlab_XXXXXXXXX.accdb
lab09_takehome_XXXXXXXXX.accdb

Older Pages