User Tools

Site Tools


[2017, First Semester]


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.


  • Class starts on Tuesday, August 8th
  • NEW: Please reserve a presentation time slot here.
  • IMPORTANT: Assignments due before Midterm Exam will not be accepted after the midnight before Midterm Exam.
  • You will need a Google Account for this class. If you have not got a Google Account yet, you can apply for one here.
  • You can check your assignment submission status here.
  • You can see the instruction on how to get file submission system account&password, as well as how to submit a file here
  • Please check where you will be taking the final exam here: RB5209, RB5210

Schedule of Classes

  • Lecture: Tu 12:30 - 14:30 @ CSB210
  • Lab: Fr 12:30 - 14:30 @ CSB307


Prakarn Unachak

  • Office hours: Monday: 1:00pm-4:00pm, Thursday: 1:00pm-4:00pm
  • Office: CSB 107


The course grade will be calculated as follows:

  • Homework & Take-home Assignment: 25%.
  • In-Lab Exercise: 10%.
  • Presentation: 5%
  • Midterm Exam: 30%.
  • Final Exam 30%.
  • Exams will be multiple choice

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 For those of you who have not received the username and password for assignment submission, please contact me at or facebook message me.

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. ( To get an account for the file submission system, follow these steps:

  1. Click on “Get Password”
  2. Log in with your CMU account and password, you should be shown your submission account and password.

To submit a file, follow these steps:

  1. Make sure the file name matches the one specified in the assignment note.
  2. Select the course (204100 for this course)
  3. Select the section (701)
  4. Log in using your submission account and password
  5. Upload the file you want to submit

Note: There is no need to delete old files. Resubmitted file will overwrite the old one of the same name.

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 week 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.) You will get marked LATE if you submit passed this deadline, and PASS(LATE) when your work checks out, which may affect your credit.

Assignment, homework and corrections 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

Week Lecture (CS210) Lab (CS307)
01 (August 8th, 11th) Introduction + Computer Systems MS Windows
02 (August 15th, 18th) Computer Systems –Break–
03 (August 22nd, 25th) Computer Networks MS Word
04 (August 29th, September 1st) MS Word MS Word
05 (September 5th, 8th) Online Services MS PowerPoint
06 (September 12th, 15th) Computer Ethics and Security MS PowerPoint
07 (September 19th, 22nd) Basic of Web Design Google Sites
08 (September 26th, 29th) Data Processing (Final Material) Google Sites
Midterm Exam (October 7th, 2017 (Saturday), 3:30pm-5:30pm @ RB3402, RB3403)
09 (October 10th, 13th) Database in Everyday Life –Break–
10 (October 17th, 20th) Database in Everyday Life –Break–
11 (October 24th, 27th) –Break– Google Form
12 (October 31st, November 3rd) Presentation MS Excel
13 (November 7th, 10th) Presentation MS Excel
14 (November 14th, 17st) Presentation MS Access
15 (November 21st, 24th) Presentation MS Access
Final Exam (December 3rd, 2017 (Sunday), 12:00pm-2:00pm @ RB5209, RB5210 )


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 (Aug 29)
#02: MS Windows MS Windows In-lab 01 (Aug 25)
Take-home 01 (Aug 25)
#03: Computer Networks & The Internet The Internet HW02 (Sep 05)
#04: MS Word pt.01-04
Example: main document
Example: recipient list 01
Example: recipient list 02
Lab02 In-lab (Aug 25)
Take-home (Sep 08)
Lab 03(take-home) (Sep 14)
Lab 03 (in-lab) (Sep 01)
Lab 03 (in-lab) recipient list
#05: Online Services Online Services HW03 (Sep 17)
#06: MS PowerPoint pt.01-06
Lab 04 (in-lab and take-home)
In-lab (Sep 08)
Take-home (Sep 21)
#07: Computer Ethics and Security Ethics & Security HW04 (Sep 25)
#08: Basic of Web Design Web Design
#09: Google Sites Google Sites
Example Website
Lab 05 (in-Lab) (Sep 22)
Lab 05 (take-home) (Oct 5)
Final Materials
#10: Data Processing Data Processing
#11: Database & Everyday Life Database HW05 (Oct 30)
#12: Google Form Google Form Lab 06 (in-lab) (Oct 27)
Lab 06 (take-home) (Nov 09)
#13: Ms Excel pt.01
Lab 07 (in-lab & take-home)
In-lab(Nov 03)
Take-home(Nov 16)
Lab 08 (in-lab) (Nov 10)
Lab 08 (take-home) (Nov 23)


#14: Ms Access 01 - Intro & Table
02 - Form
03 - Query
04 - Report
05 - Relationship
Lab09 (in-lab and take-home)
in-lab (Nov 17)
take-home (Nov 30)
Lab 10 (in-lab and take-home)
in-lab (Nov 24)
take-home (Nov 30)


204100_701_1_2017.txt · Last modified: 2018/01/12 06:11 (external edit)