Today’s society is often described as the ‘Information Society’ – where information is expected to be timely and accurate, and presented professionally. Individuals in the workplace now have access to, and are responsible for, the management and secure storage of large amounts of information.
This Unit is designed to provide candidates with the knowledge and skills for further study or employment in an administrative or IT environment. It introduces the database as a tool to help store, process and produce information in such a way as to be relevant to a manager and thus assist with management decision-making. Initially, you will focus on the analysis of a business problem, then the design and use of a database to collate data and turn it into information. On completion of the Unit you will be able to:
Credit points and level: 1 HN credit at SCQF level 7: (8 SCQF credit points at SCQF level 7)
Initially this Unit will focus on the analysis of a business problem, then the design and use of a database to collate data and turn it in to information. There are three outcomes:
In Outcome 1 you will learn how to analyse a business problem, identify the data you need to process and how best to order that data. Then you will be introduced to the relevant terminology as well as the basic concepts of database design. You will create a database structure using a relational database.
In Outcome 2 you will also learn how to input data, using tables. You will also design forms and demonstrate how to use these forms for both managing data and searching for specific records. Finally having created a database you will be introduced to the importance of storing information securely.
In Outcome 3 you will use the database facilities to help you solve a range of business problems. You will also use the database facilities to help you present the results in a format that is clear to the reader. You will also look at the range of statistical functions available within the report object. Having produced the appropriate information you will then be able to recommend a course of action to a business problem.
In order to complete this Unit successfully, you will be required to achieve a satisfactory level of performance in all assessed work. There are three assessments for this course that are carried out under open book controlled conditions. Your Tutor will mark your certified assessments. Any re-submissions, known as remediation, will also be directed and remarked by your tutor. Your work will then be cross-marked by an in college subject expert, a process called moderation. It is only then that a result can be sent to the Awarding Body for certification. A pass is not final until all cross-checking procedures have been successfully completed. Your pass will be notified to the SQA for certification.
Everything you need to know before applying for this course.
Candidates would normally be expected to be competent in numeracy and communication at SCQF level 5 or have similar qualifications or experience.
Previous experience in using a computer and database software would be beneficial. It is essential that you have experience in using a computer, the Windows interface and Windows terminology.
Pre-entry guidance is required before booking a place on this course. Please contact our Distance Learning Co-ordinators for more information.
This course involves an additional SQA fee. Further information is available here.
Your course may be free if you are not a full time student with NESCol and you are : in receipt of benefits; or care-experienced; or your household taxable income falls below defined levels.
This course is eligible for ITA funding which offers up to £200 towards the cost of training. Conditions apply.
“I’ve had such a positive experience with the College and can’t recommend the workplace learning route highly enough. I think it’s important to recognise that there are various routes to achieving qualifications and this was the right path for me.”
“NESCol is such a supportive place to study, and the staff go above and beyond to help you achieve your goals.”
“I loved that the course covered a broad range of topics, from animation and graphic design to programming”
“My daughter is so proud of me. I’m doing it for her – to show her if you want it, you can do it now for tomorrow.”
“If you’re not too sure about what you want to do, then I would definitely recommend a Foundation Apprenticeship because it gives you an insight into working while you’re still studying.”
“I feel confident moving forward as the experience of a Modern Apprenticeship and the skills I have managed to develop stand as a strong base structure for the rest of my career.”
“I’ve had a passion for computing from a very young age. I decided when my son was starting school that it was the best time to go back and follow a dream I had put on hold.”
“I really enjoyed the course and the hands on nature of the learning. Being able to build websites was great and I got a real sense of achievement from the work we were asked to produce.”
“I feel the course has prepared me well for my new role and I’m excited to put my new skills into practice and have the opportunity to do something I love every day! “
“I really have so much to thank NESCol for. I’m sure it is an experience that will have a positive impact throughout my life.”
This course requires some attendance at College, often for assessment purposes only. Please enquire about expectations for your specific course when booking.
Attendance is usually at the Aberdeen City Campus or Fraserburgh Campus.
When submitting your distance learning application form, please ensure you attach the additional information sheet listing qualifications and previous knowledge with your application. You may be required to attend College for assessment. Please check if this is a requirement for your course.
Distance Learning courses have flexible start dates and applications will be considered at all points of the year.
For non-Scottish residents – the College will confirm fees payable for your chosen course on booking and these may differ from the advertised fee.
If you take up a place on a College course, at the start of the course you will be asked to complete an enrolment form. In completing the form and/or taking up a place on a College course, you will enter into a contract with the College and be bound by the North East Scotland College Standard Terms and Conditions of Study. Copies of the Terms and Conditions are available for inspection on notice boards and at various locations throughout the College, at the College Reception, on the College website: nescol.ac.uk, or can be obtained on request from the Student Funding and Admissions Manager, North East Scotland College, Aberdeen City Campus, Gallowgate, Aberdeen AB25 1BN. Please note that courses are offered subject to (a) there being sufficient numbers of enrolments and (b) the availability of resources. The College reserves its right (i) not to run courses where the number of students is considered insufficient or where resources are unavailable and (ii) in certain circumstances, to refuse admission to an individual applicant.
Here are some courses you may also be interested in.
