Lab

Lab Exercise (10%)
10% out of 100 on Every Week.
Passing Mark(s): 50
Lab Exercise CLO: 2

Group Project (10%)
10% out of 100 on Week 9.
Passing Mark(s): 50

Lab Project CLO: 2


MS Windows

Introduction to Windows (Compulsory)

- Features and editions -
- Basic : Interface, part of a window, dialog box -
- Desktop :
window Aero,
taskbar,
menu bar,
flip 3D

- Window Explorer :
File & folder,
searching,
libraries

- Customisation :
Gadgets,
themes

- Accessories :
Calculator,
paint,
recorder,
snipping tool,

- system tools
Windows Memory Diagnostic
Performance Monitor
Computer Management and Administrative Tools
Advanced User Accounts Tool
Disk Cleanup
Local Group Policy Editor
Registry Editor
System Configuration
System Information

- Shortcut keys

Windows Exercise:

Create folder
csc134/word,excel,ppt,access,blog

Create file
Crop picture



MS Word

Using MS Word, create a job advertisement as depicted in the picture and then create a resume for you to apply for the job.

Create resume: Applying Job Resume
What to include: Personal profile, contact info, skills, education, experience, brief description, referee, photo, any relevance information)

Create Brochure. Theme: Plantation is a business.

Create Book Template for portfolio/final report

GUIDELINES ON THESIS / DISSERTATION FORMAT


MS Excel

Create your daily timetable in a week
(cell name, table border, insert row, insert column, delete row/column/cell, colour, resize row/column, copy/paste data)

Create monthly budget for your business (sum, +, *, -, /, chart)

Preset functions (name table, sum, vlookup, countif, sorting, chart)

-----------------
Lab Excel 3
-----------------

GPA calculation

fields/column: No, subject code, credit unit, cw, exam, total, grade, points

formula GPA = Total point value attained / total credit units

functions involve: sum, auto sum, data sort, named table, vlookup, countif, chart


MS Power Point

Create presentation on your plantation business
Use template
Include text, image, sound, video, links, transition
Write points instead of paragraph of text
Make sure your sound will not disturb you during presentation
You may embed video from internet or from your local drive

MS Access

Business management database
Create table products, customer, sales
create form
create report
Macro

FAQ Database
Create table course, questions, answers
Create query from table questions
create form from table
create report from table and queries
Macro
Create switchboard

MS Access Lab

Create questions table
create questions form
change topic text box to combo box
retrieve combo box data from table topics
insert a few questions
create questions report
Add close form button on question form
add open question report button on question form
create switchboard
add button to open form course, topics, questions
add button to open report course, topics, questions

Web Blog
Create web blog for your business
theme
post
page
widget
navigation
Sidebar

Internet Marketing
Email marketing
Social media marketing
Phone Apps marketing
Marketing documents

Portfolio
Create final report on lab exercises for your plantation business
Create a cover page for your portfolio.
Write summary of what you have learned. Write in MS Word.
Save files into folder (rename with your name)
zip
email to mycodingclass@gmail.com