IT in Business
IT in Business – Spreadsheets
IT in Business – Spreadsheets
An introduction to the features and functions of a spreadsheet for practical and effective use in an office environment.
This course can be undertaken as a standalone unit or as part of the HNC in Administration and Information Technology.
Course content includes:
- Basic spreadsheet skills
- Formatting text and cells; working with styles; ranges; worksheets; sorting data; headers and footers; printing
- Formulae and functions
- Cell referencing; logical functions; database functions; counting; conditional formatting
- Consolidation
- Referencing cells in other worksheets; 3-D formulae/functions
- Using named ranges, comments and workbook security
- Charts
- Statistical analysis
Entry requirements: ICT Level 5 or equivalent. You should have a good working knowledge of MS Excel. Our tutors would be happy to discuss your suitability and help you make the right choice.
Certification: SQA Higher National Unit
Duration: 34 hours which can be studied at your own pace over around 7 weeks.
Price: £86
IT in Business – Word Processing and Presentation Applications
IT in Business – Word Processing and Presentation Applications
For anyone who wants to develop skills and knowledge in word processing and presentation packages to help business communication.
This course is particularly useful for anyone seeking employment in administration, where document production and presentation are important. This course can be undertaken as a stand-alone unit or as part of the HNC in Administration and Information Technology.
Course content includes:
- Using word processing skills to produce complex business documents
- Working with graphics; mail merge; tables; forms; referencing; macros
- Using word processing knowledge and techniques
- Organisational house styles; templates
- Creating Microsoft PowerPoint presentations
- Security and confidentiality of information and equipment in the working environment
- Relevant legislation – data protection, copyright etc; computer security
- House styles and guidelines
Entry requirements: ICT Level 5. You should have a good working knowledge of MS Word and PowerPoint. Good keyboard skills will be key to completing this credit.
Certification: SQA Higher National Unit (Double Credit)
Duration: 68 hours which can be studied at your own pace over around 14 weeks.
Price: £172
IT in Business – Databases
IT in Business – Databases
Develop an understanding of database management software and the use of databases in business to help in the decision-making process, of particular interest to anyone interested in a career focussing on information management.
This course can be undertaken as a standalone unit or as part of the HNC in Administration and Information Technology.
Course content includes:
- Introduction to Relational
- Database Design
- Designing a database; primary keys; field properties; relationship modelling; referential integrity
- Inputting and storing data
- Working with fields; setting field properties; working with forms; wildcards
- Using the database to gather and present information
- Working with queries; reports; using wizards; creating totals; groupings
Entry requirements: ICT Level 5 or equivalent. You should have a good working knowledge of MS Access.
Certification: SQA Higher National Unit
Duration: 34 hours which can be studied at your own pace over around 7 weeks.
Price: £86