CSC134 Assessments | June 2015 – October 2015

Announcement
Complete your group assignments and lab assignments.

Class Materials || Lesson Plan || Notes 2014

Laboratory Modules
[1] Windows XP
[2] Ms Word 2010 || Lesson 1 || Lesson 2 || Lesson 3 || Lesson 4
[3] Ms Excel 2010 || Lesson || Tutorial
[4] Ms Access 2010 || Lesson || Tutorial
[5] Ms PowerPoint 2010 || Lesson

Quizzes || 5%
Quiz 1 || 10/7/2015 || 2.5%
Quiz 2 || 4/9/2015 || 2.5%

Group Assignments || 10%
Assignment 1 || infographic || 17/8/2015 || 3%
Assignment 2 || infographic || 17/8/2015 || 3%
Assignment 3 || infographic || 7/9/2015 || 4%

Test || 15%
Test 1 || Chapter 1 – 5 || 7% || 14/8/2015 || day || venue || time
Test 2 || Chapter 6 – 9 || 8% || 25/9/2012 || day || venue || time

Laboratory Assignments || 20%
Lab Assignment 1 || Introduction to Windows || 19/6/2015 || 2%
Lab Assignment 2 || Ms Word || 3/8/2015 || 3%
Lab Assignment 3 || Ms Excel|| 31/7/2015 || 2%
Lab Assignment 4 || Ms PowerPoint || 14/8/2015 || 3%
Group Presentation || 19/9/2015 || 10%

Textbook
Shelly, Gary B. and Misty E. Vermaat, Discovering Computers – Fundamentals 2012: Your Interactive Guide to the Digital World, Course Technology, Cengage Learning, 2013
You can buy it from En Razulaimi Razali (ground floor blok Arjuna IST) which cost you RM65. Buy a book then you can get an extra knowledge!

“Database already exist…”

Dear students,

Regarding on the problem experienced by students after completely install IBM DB2 on your machine, this is might be the solution to those who get a message about “SAMPLE database already exist in the database…”. Please try the solutions and feedback to me immediately.

Steps:

1. Open your Command Line Processor (CLP) which can be found in your Start Menu > IBM DB2 > Command Line Tools.

2. Type the following command, db2 => list db directory c [press enter]. You will see db installed in your machine including SAMPLE.

3. Type the following command, db2 => catalog db sample as sample [press enter].

4. Open IBM DB2 Control Center, and look for SAMPLE db under All Databases. The SAMPLE database should be there. If yes, then you are good to go.

 

Sources:

http://www.channeldb2.com/forum/topics/sample-database

http://www.michael-thomas.com/tech/db2/db2_installation_notes.htm

credit: En Muhd Eizan Shafiq Abd Aziz

CSC134 | Notes | Discovering Computers 2014 Living in a Digital World

You may download CSC134 2014 notes here.

Chapter 1 – Introduction to Computers
Chapter 2 – The System Unit
Chapter 3 – Input and Output
Chapter 4 – Secondary Storage
Chapter 5 – System Software
Chapter 6 – Application Software
Chapter 7 – Internet and the Web
Chapter 8 – Communication and Networking
Chapter 9 – Privacy, Security, Ethics and Ergonomic

Do review your notes for a best revision and good luck!

ITS232 | Assessments | Dec 2014 – Apr 2015

Announcement
Prepare for your group project. See below.

Class & Laboratory Materials
[1] Lesson Plan || IBM DB2 software
[2] Notes ITS250 || ITS232
[3] Lab Modules & Exercises

Tutorial || 10%
[1] Tutorial 1 (Relational Database) || 15/12/2014 || 2.5%
[2] Tutorial 2 (E-R Modelling) || 19/1/2015 || 2.5%
[3] Tutorial 3 (Normalization) || 9/2/2015 || 2.5%
[4] Tutorial 4 (SQL) || 2/3/2015 || 2.5%

Mini Project Presentation || 20%
[1] Permission Letter
[2] Proposal Form || YELLOW paper || 15/12/2014
[3] Project Proposal || BLUE page cover || binded using TAPE in BLACK color || 19/1/2015 || 5%
[4] Project Proposal Grading Rubric
[5] Final Project Grading Rubric
[6] Final Report || RED page cover || bind using TAPE in BLACK color || Guideline || 16/3/2014 || 15%

Test || 20%
Test 1 || Chapter 1 -3 || 26/1/2015 || Monday || -venue- || -time-
Test 2 || Chapter 4 -6 || 16/3/2015 || Monday || -venue- || -time-

Textbook
Carlos Coronel, Steven Morris and Peter Rob, Database Principles: Fundamentals of Design, Implementation, and Management, International Thomson Publishing (ITP), Ninth Edition, 2011.