E005 Market Session, GAPOSA Saapade, Remo, Ogun State. | F8-f21, Lagos State University of Science and Technology, Ikorodu, Lagos State

08144080852 | 07059739417 techway008@gmail.com

Finance

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

DayDaily Training / Practical Activity
MondayIntroduction to Techway Solutions, SIWES objectives, workplace ethics, attendance and proper use of the SIWES logbook.
TuesdayIntroduction to computer applications in accounting, banking and financial management.
WednesdayIdentification and use of basic computer hardware and peripheral devices.
ThursdayIntroduction to Windows, desktop navigation and application management.
FridayPractical computer operation: creating, opening, saving and retrieving financial documents.

Week 2 — File Management and Financial Documentation

DayDaily Training / Practical Activity
MondayCreating folders and subfolders for customers, transactions, expenses and financial records.
TuesdaySaving, copying, moving, renaming and organising financial files.
WednesdayUnderstanding common file formats: DOCX, XLSX, PDF, CSV, JPG and PNG.
ThursdayIntroduction to data backup, flash drives and cloud storage.
FridayPractical exercise: create an organised electronic filing system for a small business.

Week 3 — Desktop Publishing for Financial Documents

DayDaily Training / Practical Activity
MondayIntroduction to Desktop Publishing using Microsoft Word.
TuesdayTyping and formatting professional financial/business documents.
WednesdayCreating tables, headings, borders, numbering and professional page layouts.
ThursdayPreparation of invoices, receipts and payment acknowledgement documents.
FridayPractical exercise: design and prepare a professional invoice and receipt.

Week 4 — Business and Banking Documentation

DayDaily Training / Practical Activity
MondayPreparing formal business and financial letters.
TuesdayPreparation of payment requests and simple financial reports.
WednesdayCreating quotations and pro-forma invoices.
ThursdayPreparing customer statements and transaction summaries.
FridayPractical project: prepare a complete set of financial/business documents for a hypothetical customer.

Week 5 — Introduction to Microsoft Excel

DayDaily Training / Practical Activity
MondayIntroduction to Microsoft Excel: workbook, worksheet, rows, columns and cells.
TuesdayEntering, editing and formatting financial data.
WednesdayIntroduction to basic formulas: addition, subtraction, multiplication and division.
ThursdayUsing SUM, AVERAGE, MIN, MAX and COUNT functions.
FridayPractical exercise: create a simple daily income and expenditure worksheet.

Week 6 — Excel for Accounting and Finance

DayDaily Training / Practical Activity
MondayPreparing daily sales records using Excel.
TuesdayCreating cash receipt and payment records.
WednesdayPreparing simple income and expenditure statements.
ThursdayCalculating balances, totals and differences automatically.
FridayPractical exercise: prepare a monthly income and expenditure statement.

Week 7 — Basic Bookkeeping and Financial Records

DayDaily Training / Practical Activity
MondayIntroduction to bookkeeping and source documents.
TuesdayUnderstanding receipts, invoices, credit notes and payment vouchers.
WednesdayRecording basic cash transactions.
ThursdayIntroduction to cashbook preparation and balancing.
FridayPractical exercise: prepare a simple cashbook from a set of sample transactions.

Week 8 — Payroll and Financial Calculations

DayDaily Training / Practical Activity
MondayIntroduction to payroll and basic salary records.
TuesdayCreating employee payroll information using Excel.
WednesdayCalculating gross pay, deductions and net pay using spreadsheet formulas.
ThursdayIntroduction to percentages, discounts, commissions and simple interest calculations.
FridayPractical exercise: prepare a simple computerized payroll sheet.

Week 9 — Introduction to Internet Use and Financial Research

DayDaily Training / Practical Activity
MondayIntroduction to Internet browsing and effective use of search engines.
TuesdaySearching for banking, accounting, business and financial information online.
WednesdayIdentifying reliable sources of financial information and avoiding misleading information.
ThursdayDownloading and organising reports, documents and financial information.
FridayPractical assignment: conduct online research on a selected banking, accounting or finance topic and prepare a brief report.

Week 10 — Financial Data Presentation

DayDaily Training / Practical Activity
MondaySorting and filtering financial data in Excel.
TuesdayIntroduction to basic charts and graphs for financial information.
WednesdayPreparing monthly sales and expense summaries.
ThursdayFormatting spreadsheet reports for printing and presentation.
FridayPractical exercise: prepare a financial summary containing a table and appropriate chart.

Week 11 — Introduction to News and Website Posting

DayDaily Training / Practical Activity
MondayIntroduction to online news/content publishing and website administration.
TuesdayResearching suitable business, banking, entrepreneurship and financial news.
WednesdayWriting simple headlines and preparing news content for online publication.
ThursdayEditing, proofreading and verifying information before posting.
FridayPractical exercise: prepare a business or financial news article for the Techway website.

Week 12 — Posting News on the Techway Website

DayDaily Training / Practical Activity
MondayIntroduction to the Techway website administration dashboard under supervision.
TuesdayCreating a new post and entering the headline and article content.
WednesdayFormatting paragraphs, headings and hyperlinks within a news post.
ThursdayAdding categories, tags, appropriate images and featured images.
FridayPreview, correct and publish an approved financial/business news article under supervision.

Week 13 — Basic Computerized Accounting and Customer Records

DayDaily Training / Practical Activity
MondayIntroduction to the concept of computerized accounting systems.
TuesdayCreating electronic customer and transaction records.
WednesdayRecording sales, purchases, income and expenses electronically.
ThursdayPreparing simple debtor and creditor records.
FridayPractical exercise: prepare electronic financial records for a hypothetical small business.

Week 14 — Banking, Finance and Digital Transactions

DayDaily Training / Practical Activity
MondayIntroduction to digital banking and electronic payment systems.
TuesdayUnderstanding bank transfers, POS transactions and electronic transaction records.
WednesdayIntroduction to basic bank reconciliation concepts.
ThursdayRecording and matching sample bank transactions with business records.
FridayPractical exercise: prepare a simple bank reconciliation statement using sample data.

Week 15 — Integrated Financial and Digital Publishing Project

DayDaily Training / Practical Activity
MondayCreate sample financial records for a small business using Excel.
TuesdayPrepare income, expenses, balances and a simple financial summary.
WednesdayPrepare a professional financial report using Desktop Publishing tools.
ThursdayResearch and prepare a banking, accounting, entrepreneurship or finance-related news article.
FridayUpload the approved article to the Techway website and present the completed financial project.

Week 16 — Final Assessment and SIWES Documentation

DayDaily Training / Practical Activity
MondayRevision of Desktop Publishing and financial document preparation.
TuesdayRevision of Microsoft Excel formulas, financial records and spreadsheet preparation.
WednesdayPractical assessment: prepare an income/expense spreadsheet and simple financial report.
ThursdayPractical assessment: research, prepare, format and post an approved financial/business news article on the Techway website.
FridayCompletion 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.