Diploma in ICT (Business Applications) Level 2

Course Modules:
Semester 1
IT Principles (Unit 001)

• Describe and use hardware
• Describe and use software
• Use files and directories
• Use operating environment
• Describe information networks
• Identify health and safety requirements

Word processing (I) (Unit 002)- Microsoft MS Word

• Starting MS Word
• Cursor movement
• Mouse operations
• Cursor movement using the mouse
• Creating a New document, saving, printing, closing and opening.
• Text Alignment (left, centre, right, justify)
• Formatting (bold, italic, underline, cut, copy and paste)
• Changing Font face, colour and size
• Creating simple business letter
• Inserting date, picture etc
• Margin settings, Using tabs
• Using Indents, Using line spacing
• Replacing text, Spell checking

(Spreadsheets I) (Unit 003) - Microsoft Excel

• Starting MS Excel
• Entering, saving and printing simple worksheet.
• Cursor movement
• Cursor movement using the mouse
• Pointer types
• Changing Column widths
• Naming the worksheet
• Freezing and unfreezing panes
• Using cut, copy and paste commands
• Using formulae, Using = sum function
• Using IF Statement
• Creating Charts (pie, bar, line and column)

Database (I) (Unit 004): Microsoft Access

• Starting Ms Access
• Cursor movement
• Cursor movement using the mouse
• Pointer types, creating a new database
• Creating new tables, saving, printing, closing and opening.
• Deleting records, cut, copy and paste commands
• Using find command, sorting tables
• Creating queries
• Using the Auto Form wizard
• Designing Reports

Semester 2 I.T Principles (Unit 021)

• Prepare peripheral devices and hardware for use
• Use Software Applications
• Manage and maintain directory structure
• Use the operating environment
• Identify health and safety requirements.

Business Documentation by using Word processing II (Unit 022)

• Plan and produce new documents
• Creating a standard Business letter
• Inserting text box, pictures, logos etc
• Using proportional and UN-proportional fonts
• Using replacing commands
• Writing a letter using Auto Text, Writing Agenda
• Creating a letter wizard, Writing Business Memo
• Sending memos using Mail Merge
• Creating mailing labels using Mail Merge
• Writing a report
• Using Tabs, Indent, Bullets, Tables and Borders
• Using Styles, Page Numbering and Hard page break
• Using Header, Footer and Footnotes
• Creating simple Advert using newspaper style columns
• Creating a blank order form, Creating a blank invoice
• Proof correction symbols

Advanced Accounting by using Spreadsheets II (Unit 023)

• Design a spreadsheet to meet a given specification
• Create and test a spreadsheet
• Link, import and test spreadsheet
• Link import and extract data
• Freezing and Unfreezing panes
• Using formulae, Using = Sum Function
• Using IF Statement
• Creating Charts (pie, bar, line and column)
• Setting Print area, Naming Cells
• Using the cell protection command
• Using the Paste Function (wizard)

Relational Database II (Unit 024)

• Apply database concepts
• Create and modify a database structure
• Create and use a data entry form
• Maintain a database
• Sort and index a database
• Carry out single and multiple searches
• Using Find Command
• Sorting Tables, Creating queries
• Using the Auto form wizard
• Creating Mailing labels using the Label Wizard

How long is the course: The course is module based. There are 8 modules and each module is scheduled to take up to 60 hours to complete. Students will study a minimum of 15 hours per week for 1 academic year.
Assessment and Qualification you will achieve: Practical assignments and multiple-choice questions assess course. You will obtain the City & Guilds 7262 scheme Diploma for Information Technology users. You will study IT principles (I), IT Principles (II), Word (I), Word (II), Spreadsheet (I), Spreadsheet (II), Database (I) and Database (II).
What are the opportunities for further studies? On completion of this Diploma, you can progress to studying for the Advance Diploma or you can choose another appropriate course this college has to offer. Advice on opportunities for further study will be provided during your course.