Data Analytics

• Database Methods 5N0783 Use SQL to create a database with related tables, query that data, and produce meaningful reports. Free access to Office 365.
• Spreadsheet Methods 5N1977 Produce a spreadsheet that meets a simple design specification and is fit for purpose. Learn a range of spreadsheet features such as data and cell formatting techniques, conditional IF statements, financial, date and time functions. Generate a variety of types of graphs from spreadsheet data. Automate routine multi-step tasks through the creation, execution and management of simple macros.
• Statistics 5N2066 Understand data, data collection and compile statistical information. Identify and implement appropriate means of presenting data. Analyse and interpret statistical information and learn how to use statistics for work and life
• Teamworking 5N1367 Participate in core team-working activities to include negotiation, problem solving, finding solutions, decision making and conflict resolution. Demonstrate appropriate communications, problem solving and negotiation techniques in a range of team-working situations and roles to include leadership roles and give a receive feedback. Monitor personal strengths and skills as a team participant. 
• Programming and Design Principles 5N2927 Learn the fundamentals of programming including conditional statements, iteration and methods using Python (IDE: PyCharm), and the importance of programs being to industry standard at the front end and the back end.
• Information and Communication Systems 5N1952 Create a data capture form. Describe methods of securing data e.g access control, passwords, authentication etc. Explore data protection legislation. Use a range of common ICT terminology including server, dumb terminal, LANs etc.
• Web Authoring 5N1910 Build professional websites using HTML and CSS
• Work Experience 5N1356 Preparation for the work place, and a 2-week work placement in industry.

Additional Training/Workshops

• R Programming
• Report Writing: This workshop will equip the learner with the knowledge and skills to write an effective report.  The content of the workshop includes report objectives, the report writing process including research and writing the report including structure, style and tone, format and layout. Editing and proof-reading, effective executive summary as well as writing persuasively and avoiding common pitfalls is also covered.
• Microsoft Outlook: The Microsoft Outlook workshop demonstrates how to use the internet to compose, send, receive and store electronic mail to include attaching a file to an email and managing email folders.  It also facilitates the learner to explore areas related to browser-based email systems including demonstrating the use of at least one current email software package for example: compose, send, receive, reply, forward, print, store electronic messages and open file attachments, attach a file to an email message and create and manage mailboxes and transfer messages to and from relevant mailboxes.  Furthermore, learners develop an appreciation of email etiquette as regards: content, length, style and tone of composed messages and they set up a web-based email account
• Data Protection Workshop: This Data Protection Workshop gives learners an overview of GDPR. The workshop examines was GDPR stands for and gives an understanding of the current data protection rules and obligations.  The learners also receive information on the types of data, the terminology associated with GDPR, the penalties with breaches, storage of data and general do’s and don’ts regarding data.
• CRM Software
• STEM Aspire Mentorship Programme (for female students) run by Dell EMC: DELL EMC and VMware invite our female students to participate in workshops that will help them progress along their chosen IT path. Each participant is assigned a mentor who provides continued support, engagement and encouragement to facilitate a student in achieving their IT career goal.