The training focuses on Computer Desktop Publishing, Microsoft Excel, basic computerized accounting, financial record keeping, Internet research, preparation of financial documents, and news posting on the Techway website.
Week 1 — SIWES Orientation and Computer Appreciation
Day
Daily Training / Practical Activity
Monday
Introduction to Techway Solutions, SIWES objectives, workplace ethics, attendance and proper use of the SIWES logbook.
Tuesday
Introduction to computer applications in accounting, banking and financial management.
Wednesday
Identification and use of basic computer hardware and peripheral devices.
Thursday
Introduction to Windows, desktop navigation and application management.
Friday
Practical computer operation: creating, opening, saving and retrieving financial documents.
Week 2 — File Management and Financial Documentation
Day
Daily Training / Practical Activity
Monday
Creating folders and subfolders for customers, transactions, expenses and financial records.
Tuesday
Saving, copying, moving, renaming and organising financial files.
Wednesday
Understanding common file formats: DOCX, XLSX, PDF, CSV, JPG and PNG.
Thursday
Introduction to data backup, flash drives and cloud storage.
Friday
Practical exercise: create an organised electronic filing system for a small business.
Week 3 — Desktop Publishing for Financial Documents
Day
Daily Training / Practical Activity
Monday
Introduction to Desktop Publishing using Microsoft Word.
Tuesday
Typing and formatting professional financial/business documents.
Wednesday
Creating tables, headings, borders, numbering and professional page layouts.
Thursday
Preparation of invoices, receipts and payment acknowledgement documents.
Friday
Practical exercise: design and prepare a professional invoice and receipt.
Week 4 — Business and Banking Documentation
Day
Daily Training / Practical Activity
Monday
Preparing formal business and financial letters.
Tuesday
Preparation of payment requests and simple financial reports.
Wednesday
Creating quotations and pro-forma invoices.
Thursday
Preparing customer statements and transaction summaries.
Friday
Practical project: prepare a complete set of financial/business documents for a hypothetical customer.
Week 5 — Introduction to Microsoft Excel
Day
Daily Training / Practical Activity
Monday
Introduction to Microsoft Excel: workbook, worksheet, rows, columns and cells.
Tuesday
Entering, editing and formatting financial data.
Wednesday
Introduction to basic formulas: addition, subtraction, multiplication and division.
Thursday
Using SUM, AVERAGE, MIN, MAX and COUNT functions.
Friday
Practical exercise: create a simple daily income and expenditure worksheet.
Week 6 — Excel for Accounting and Finance
Day
Daily Training / Practical Activity
Monday
Preparing daily sales records using Excel.
Tuesday
Creating cash receipt and payment records.
Wednesday
Preparing simple income and expenditure statements.
Thursday
Calculating balances, totals and differences automatically.
Friday
Practical exercise: prepare a monthly income and expenditure statement.
Week 7 — Basic Bookkeeping and Financial Records
Day
Daily Training / Practical Activity
Monday
Introduction to bookkeeping and source documents.
Tuesday
Understanding receipts, invoices, credit notes and payment vouchers.
Wednesday
Recording basic cash transactions.
Thursday
Introduction to cashbook preparation and balancing.
Friday
Practical exercise: prepare a simple cashbook from a set of sample transactions.
Week 8 — Payroll and Financial Calculations
Day
Daily Training / Practical Activity
Monday
Introduction to payroll and basic salary records.
Tuesday
Creating employee payroll information using Excel.
Wednesday
Calculating gross pay, deductions and net pay using spreadsheet formulas.
Thursday
Introduction to percentages, discounts, commissions and simple interest calculations.
Friday
Practical exercise: prepare a simple computerized payroll sheet.
Week 9 — Introduction to Internet Use and Financial Research
Day
Daily Training / Practical Activity
Monday
Introduction to Internet browsing and effective use of search engines.
Tuesday
Searching for banking, accounting, business and financial information online.
Wednesday
Identifying reliable sources of financial information and avoiding misleading information.
Thursday
Downloading and organising reports, documents and financial information.
Friday
Practical assignment: conduct online research on a selected banking, accounting or finance topic and prepare a brief report.
Week 10 — Financial Data Presentation
Day
Daily Training / Practical Activity
Monday
Sorting and filtering financial data in Excel.
Tuesday
Introduction to basic charts and graphs for financial information.
Wednesday
Preparing monthly sales and expense summaries.
Thursday
Formatting spreadsheet reports for printing and presentation.
Friday
Practical exercise: prepare a financial summary containing a table and appropriate chart.
Week 11 — Introduction to News and Website Posting
Day
Daily Training / Practical Activity
Monday
Introduction to online news/content publishing and website administration.
Tuesday
Researching suitable business, banking, entrepreneurship and financial news.
Wednesday
Writing simple headlines and preparing news content for online publication.
Thursday
Editing, proofreading and verifying information before posting.
Friday
Practical exercise: prepare a business or financial news article for the Techway website.
Week 12 — Posting News on the Techway Website
Day
Daily Training / Practical Activity
Monday
Introduction to the Techway website administration dashboard under supervision.
Tuesday
Creating a new post and entering the headline and article content.
Wednesday
Formatting paragraphs, headings and hyperlinks within a news post.
Thursday
Adding categories, tags, appropriate images and featured images.
Friday
Preview, correct and publish an approved financial/business news article under supervision.
Week 13 — Basic Computerized Accounting and Customer Records
Day
Daily Training / Practical Activity
Monday
Introduction to the concept of computerized accounting systems.
Tuesday
Creating electronic customer and transaction records.
Wednesday
Recording sales, purchases, income and expenses electronically.
Thursday
Preparing simple debtor and creditor records.
Friday
Practical exercise: prepare electronic financial records for a hypothetical small business.
Week 14 — Banking, Finance and Digital Transactions
Day
Daily Training / Practical Activity
Monday
Introduction to digital banking and electronic payment systems.
Tuesday
Understanding bank transfers, POS transactions and electronic transaction records.
Wednesday
Introduction to basic bank reconciliation concepts.
Thursday
Recording and matching sample bank transactions with business records.
Friday
Practical exercise: prepare a simple bank reconciliation statement using sample data.
Week 15 — Integrated Financial and Digital Publishing Project
Day
Daily Training / Practical Activity
Monday
Create sample financial records for a small business using Excel.
Tuesday
Prepare income, expenses, balances and a simple financial summary.
Wednesday
Prepare a professional financial report using Desktop Publishing tools.
Thursday
Research and prepare a banking, accounting, entrepreneurship or finance-related news article.
Friday
Upload the approved article to the Techway website and present the completed financial project.
Week 16 — Final Assessment and SIWES Documentation
Day
Daily Training / Practical Activity
Monday
Revision of Desktop Publishing and financial document preparation.
Tuesday
Revision of Microsoft Excel formulas, financial records and spreadsheet preparation.
Wednesday
Practical assessment: prepare an income/expense spreadsheet and simple financial report.
Thursday
Practical assessment: research, prepare, format and post an approved financial/business news article on the Techway website.
Friday
Completion of SIWES logbook, final project presentation, assessment, corrections and supervisor’s feedback.
Expected Skills After 16 Weeks
At the end of the programme, Finance, Banking & Finance, and Accountancy students should be able to use computers for basic financial operations, prepare professional financial documents, create invoices and receipts, maintain electronic transaction records, use Microsoft Excel for basic financial calculations, prepare income and expenditure statements, create simple payrolls, maintain cashbooks, perform basic bank reconciliation, conduct financial research on the Internet, and prepare and post approved business and financial news on the Techway website.
For the joint class, a suitable training allocation is 30% Microsoft Excel and Financial Records, 20% Desktop Publishing and Financial Documentation, 20% Bookkeeping/Computerized Accounting, 15% Internet and Financial Research, and 15% News Preparation and Techway Website Posting.