"Learning is finding out what we already know. Doing is demonstrating that you know it. Teaching is reminding others that they know just as well as you. You are all learners, doers, and teachers." -- Richard Bach
Wednesday, 23 May 2012
Thursday, 3 May 2012
ACCESS ASSINGMENT
TO
BE PRESENTED IN CLASS ON WEEK 14 (FINAL WEEK)
ACCESS ASSINGMENT: (70
marks)
This is a group project for no more than 4 people. In
this project, your group need to develop a database system using MS Access for one
small business company. Start your project by preparing a proposal to get the
approval from your lecturer. Information in the proposal must have. Prepare and submit your proposal next week (8 mei) during class:
Proposal
Requirement: (10 marks)
- Identify the specific types of business you want to develop the database.
- Mention the purpose of your database.
- Design on paper 5 main table and their field for this database. Each table must have at least 6 fields.
- Explain how you will do the relationship for your tables.
- Bring your group proposal contain this information’s for your lecturer approval on third week access class.
- When you get the approval you can continue with your project.
What need to be included in the database system? You
must include at least (this is min requirement. You can create more than
this).
Database
System Requirements: (60 marks)
- 5 main tables (include all what you have learn about design table eg: field name, data types, description and field properties. For data types, please include all types of data eg: date, currency, yes/no, lookup wizard, OLE object, hyperlink, attachment, text, memo, auto number) (10 marks)
- For the main table, the record must be more than 10 record. (10 marks)
- Create the relationship between tables. (5 marks)
- Then create 5 queries. (5 marks)
- Create 5 forms using different style eg: form and sub form. Include command button in form to link to other form and to the switch board. (10 marks)
- Create 5 reports .(5 marks)
- Create 1 start-up page (5 marks)
- Create 1 switchboard (MIN 10 BUTTON: 5 BUTTON FOR FORM AND 5 FOR REPORT) (5 marks)
- Your database must have calculation in form and in queries. (5 marks)
- Design and format all your forms and reports nicely by including the same header and footer. (5 marks)
Wednesday, 25 April 2012
UPDATE YOUR BLOG (3)
Labels:
Announcement,
Blog Instructions,
Reminder,
Students Blogs
Tuesday, 17 April 2012
Power of Positive Thinking: Which One Are You?
Once upon a time a daughter complained to her father that her life
was miserable and that she didn't know how she was going to make it. She was tired of fighting and struggling all the time. It seemed just as one problem was solved, another one soon followed.
Sunday, 15 April 2012
LAB TEST EXAM 1
Hope you all enjoy your holiday. This post just to remind you that:
Tomorrow : Tuesday 17/04/2012
Your: Lab test exam 1
Topic cover: Excel (familiar with all the formulas, like IF, IF+AND, VLOOKUP and others)
Word (Mail Merge) & Powerpoint presentation
Where & What time: Same place and same time with your class schedule
How long: Around 2 hours.
What to bring: Your pen drive (storage drive)
GOOD LUCK AND ALL THE BEST !!!
Wednesday, 28 March 2012
CORRECTION FOR EXCEL ASSIGNMENT
Click here for the revised version for excel assignment
Due date for this assignment is extended until 10 April 2012 not 4 April. Finish your powerpoint first for next week presentation. All the best. For those who already send your work you can revised your work and send again your task to the correct email.
Upload in your blog and send a copy to: eppd1063set1@gmail.com
Attention: Make sure you email your assignment using the software you used to create the documents like word for microsoft word assignment and excel for microsoft excel assignment. Don't send me the pdf file.
Monday, 26 March 2012
UPDATE YOUR BLOG (2)
&
May Allah bless Us All
Hope all of you are in a good health. Today blog update instruction:
Find a video clips in YouTube or what ever media regarding your topics (topic for newsletter assignment) and paste into your blog. At least one video or more.
For those who still don't start blogging or update your blog, start now. Now is week 6.
Good Luck and All the Best.
HOW TO CREATE AND EDIT VIDEO
First you need to record your video using either webcam, camera or your hand phone. Make sure the video you want to post on your powerpoint is .wmv types. When your video is in that format you can directly put in your presentation.
If your video is in different format you must convert it using video converter. You can find the converter from the internet. If you want to edit you video, one way is through youtube editor. When you already have the video you must create your account in youtube and then upload the video there. After uploading you can still edit the video. Following is on how to do so. Good Luck.
Power Point Task: CREATE YOUR OWN VIDEO
Assalamualaikum and hi everyone,
This week you will learn about powerpoint presentation. The topic for your powerpoint presentation assignment is same with the topic for your newsletter.
Your Due date presentation is on 3 March 2012
Your presentation must consists of at least 10 pages (more than 10 is accepted).
Your presentation must have all this elements:
Text
|
Sounds
|
Slides Transitions
|
Pictures /Graphics
|
Shorts movies/ videos
|
Slides Number
|
Animation
|
Background
|
|
Charts
|
Link or hyperlink
|
|
Custom Animations
|
Tables
|
**For videos, I want you to create your own video. For example for the fist or second slide you put your video introducing your name and the title of you presentation. The video duration should be no more then one minutes. Beside this you also can add other video related to your topic.
EVALUATION:
Marks will be given according to:
- The contents (must be informative)
- The creative layout and style of the presentation
- The elements in Microsoft PowerPoint
SUBMISSION:
Your Due date presentation is on 3 March 2012
BLOG: In your own blog, please upload
your video (1 file) and your PowerPoint presentation file (1 file) in two
separate blog entries.
EMAIL: Please don't forget to email a copy of your assignment. to the email: eppd1063set1@gmail.com after presentation.
EMAIL: Please don't forget to email a copy of your assignment. to the email: eppd1063set1@gmail.com after presentation.
Labels:
Announcement,
Assignment,
Blog Instructions,
Instructions,
PowerPoint
VIDEO FOR VLOOKUP IN EXCEL 2007
See This:
Vlookup in separate workbook and in saperate worksheet:
Vlookup in separate workbook and in saperate worksheet:
Monday, 19 March 2012
MS EXCEL ASSINGMENT
CLICK HERE TO DOWNLOAD THE TASK
Sunday, 11 March 2012
LIST OF STUDENTS BLOGS
The name highlight with yellow colour mean your blog is not registered or wrongly registered or cannot open. So you need to registered again with the correct address.
Bil
|
No.Pend
|
Nama
|
URL BLOG
|
1
|
A133457
|
NOOR FARHANA BINTI ABDUL NASIR
|
|
2
|
A133489
|
MUHAMMAD AZLAN BIN ZAINAL
|
|
3
|
A135905
|
SUHAILI BINTI SUBAIRA
|
|
4
|
A135909
|
NIK NOOR SYAHIRA WAHIDA BINTI MUHAMAD
|
|
5
|
A135962
|
FATIN ZETISYAKILA BINTI MD YUSOF
|
|
6
|
A135985
|
NURUL MALYANA BINTI SAHLAN
|
|
7
|
A135991
|
MUHAMAD SYAHAM BIN SUZMIN
|
|
8
|
A136005
|
NURUL NUR ASYIKIN BINTI GHAZALI
|
|
9
|
A136016
|
NOOR AMIRAH BINTI YUSOF
|
|
10
|
A136020
|
SITI AZMIRA BINTI SUKIYAT
|
|
11
|
A136041
|
NUR HIDAYU BINTI HALIM
|
|
12
|
A136060
|
KONG XIN LIN
|
|
13
|
A136262
|
NURZATIL IZZATI BINTI SALEH
|
|
14
|
A136286
|
NURUL FAIZAH BINTI ISMAIL
|
|
15
|
A136344
|
EE LI XIA
|
|
16
|
A136393
|
NURIN HAZIRAH BINTI OTHMAN
|
|
17
|
A136501
|
NADHILAH BASIRAH BINTI ABDUL RAZAK
|
|
18
|
A136544
|
ANN NUR BINTI JOHN
|
|
19
|
A136552
|
FAIQAH BINTI ABDULLAH
|
|
20
|
A136559
|
HANDRIERISYANO BIN SATE
|
|
21
|
A136573
|
TEH BOON CHIANG
|
|
22
|
A136577
|
SITI NURUL NAJIHAH BINTI AUZAR
|
|
23
|
A136581
|
NOR AZIRA BINTI NGADENAN
|
|
24
|
A136591
|
PUTERI NAQUIAH NADHIRAH BINTI YUSRI
|
|
25
|
A136605
|
BRENDA ALPEUS
|
|
26
|
A136607
|
NORHAPIZAH BINTI ISMAIL
|
|
27
|
A136610
|
NURUL AMIERA DYANA BINTI ZAINUDDIN
|
|
28
|
A136612
|
NUR ANEESA BINTI SUHAIMI
|
|
29
|
A136613
|
NIK ATHIRAH ILLANI BINTI NIK WAN
|
|
30
|
A136631
|
NORAFIQAH BINTI JAMIL
|
|
31
|
A136681
|
RUZANNA BINTI ABD KADIR
|
|
32
|
A136704
|
NUR ALIAH BINTI MOHD SUKERI
|
|
33
|
A136784
|
NORHALIZA FARIDA BINTI SULAIMAN
|
|
34
|
A136789
|
ROZILAWATI BINTI RAMLI
|
|
35
|
A136846
|
NOR SURYATI BINTI AIRUDDIN @ DIN
|
|
36
|
A136888
|
NURULFARIDAH BINTI M. MAZLAM
|
|
37
|
A136943
|
MUHAMMAD NOR SHAFIQ BIN SHAFARUDIN
|
|
38
|
A136995
|
NORASHIKIN BINTI TALKAH
|
|
39
|
A137008
|
RADHIAH BINTI KHALID
|
|
40
|
A137037
|
NOR SYAMILA BINTI MOHD MOHKHERI
|
|
41
|
A137051
|
SITI FATIMAH BINTI ABDUL MUTALIB
|
|
42
|
A137082
|
HO MUN YEE
|
|
43
|
A137458
|
SHUHAIDA BINTI SAMAT
|
|
44
|
A138732
|
ICBAL WIJAYA LESMANA
|
Subscribe to:
Posts (Atom)