BTEC level 3 LEARNING AIM F Pre Topic

BTEC level 3 LEARNING AIM F

Pre Topic Task Find out what an online service is Create a list of online services Explain how businesses use them effectively to be more productive. This could help you Convenience Security Ease of use Speed Flexibility

Impact of IT Systems

Online services How do the features of online services meet the needs of individuals or organisations? How does the internet help? Does exposing ourselves online mean anything for our data? What online services can you think of? What data do they need? Can we avoid using them?

Online services TASK – below are a list of industry sectors, in your books write down what services these sectors provide online Retail Financial services. Education and training News and information Entertainment and leisure Productivity Booking systems

The features and implications of using Retail – Most items can now be purchased online from a variety of shops, the products can be online services delivered to suit ours needs. It also means products can be bough which are not regulated by government standards. The risk of buying unregulated products before they arrive is also exposed. Financial services – e. g. mortgages, advice, investments, banking, debt and loans. The UK’s financial services are regulated but because we now have global access not all services can be guaranteed as authentic. We now have popular providers such as Pay. Pal who are becoming a dominant force on the internet. Education and training – Now a days a lot of CPD courses which employees take are based online and even university courses use online providers. With the advancement of technology students now use devices to connect to the internet for their research. However there are examples of fake research and unregulated online courses. News and information – It is suggested that we are bombarded with the content of the equivalent of over 200 newspapers per day. This is due to the ease of accessibility and range of tech that allows us access the news. News spreads quickly because people are able to capture the story there and then. For example the 9/11 bombings or the Shoreham air disaster. Because news is readily available, staff productivity can be affected as well as ensuring news is correct and not biased.

The features and implications of using online services Entertainment and leisure – with the emergence of smart phones, smart televisions, TV on demand, Netflix etc TV is now accessible all throughout the day and this can occupy more time in peoples lives. The watershed is no longer a factor as TV programmes can be streamed at any time. However it is possible to put safety locks on certain channels. People do not have to go to the casino to gamble as online services allows people to do it at home, all this issues and more have affected peoples leisure time. Productivity – there are some positive tools for example remote desktop which provides flexible working hours, cloud storage which allows collaboratively. However it could be argued that work can be intrusive into someone's personal life because they are expected to check communication from work in their own time. Social media has affected work productivity as people want to be up to date with the latest news. Some business confiscate mobiles or do not allow them in the workplace as it affects the companies productivity. Booking systems – No longer do we receive tickets to travel with, or need to print out paper copies for confirmation. Online services allow us to search and compare for the cheapest deals and book travel, holidays, sports tickets etc. of course there is always a security risk using online services as they will need to collect personal data.

The uses, impact and implications of online services TASK – Make notes of these 3 areas in your book. Use the internet or pages 59 -60 in the textbook Transactional data – data when a transaction is made. Targeted marketing – how business use transactional data to target marketing at their customers. Collaborative working – how do online services help individuals work together.

Impact on organisation How does technology affect organisations? E. g. online shopping, social media, borrowing money, travel and accommodations, medical consultations, internet dating What do office buildings look like (inside)? How can this all have an impact on business? TASK - List some advantages and disadvantages

Keywords CAD – computer aided design software which is used for detailed technical drawings. Used to help design cars and buildings. QR codes – quick response codes which provide direct links to, for example, websites or make a payment. Viral - unsolicited and infectious marketing tactics using social media to attract interest.

Features and implications of IT systems used by organisations Why has the use of IT systems dramatically increased in the past decade? How has the internet helped? What IT systems do businesses use? TASK – Research (pages 61 -63) – Stock Control / Data logging / Data analysis / General office tasks / creative tasks / advertising / manufacturing / security. What are they? What are the advantages for a business? What are the implications for a business? Explanation Advantages Stock control Disadvantag es

Keywords CRM – customer relationship management system MIS – management information system SAP – systems, applications and product is a data processing system CAM – computer aided manufacturing is done by machines that use software to operate tools and machinery for manufacturing, so providing greater precision and accuracy.

The impact of using IT systems What is the impact of using IT systems in relation to these concepts…. User experience Employee and customer needs Cost Implementation Replacement or integration with current systems Productivity Working practice Staff training needs User support Security TASK – Using these concepts above, you are going to sell to a company a product of your choice.

Keywords Data cleansing – ongoing checking of data for accuracy, currency and completeness Input mask – a database instruction which restricts or control the type, format or amount of data entered. Amortise – gradually write off the initial cost of an asset over a period of time, because regular payments are made. CSV – comma separated values if a file type which stores records in a line and presents data in plain text as individual fields, where each field is separated by a comma.

Using and manipulating data What is data? Primary data – data the organisation has collected or produced itself E. g. list of customer details Secondary data - data which someone else has ‘bought in’ or collected by someone else. E. g. research articles, government reports etc What is the source of the data? How does it first appear? Data comes in a raw format and must be given context and analysed in order for it to become useful. Task in your books research and answer the following How do you ensure that the data is reliable?

How is data collected? Task – use this table to explain how data can be collected. Quantitative – numerical data, generated into statistics Qualitative – gain an understanding and the underlying reasons Options to collect data Survey Questionnaire Focus Group Interview Explanation

Data Accuracy Why is the accuracy of data vital? What are the consequences? How can you ensure data is entered probably? Verification – checking with its original source Validation – if the parameters meet the input mask, data only accepted if its meets the criteria Task – Explain the importance of ensuring that data is accurate and reliable. Why may data be inaccurate? Careless data entry Misheard or misread data Duplications Inadequate data cleansing Omissions (gaps)

Exam Style Question John is going to open a new store and wants to collect the opinions of potential customers He is considering using online IT systems to form a focus group to conduct the research. Discuss the advantages and disadvantages of conducting a focus group is this way. (6 Marks)

Methods to extract and sort data Data that is extracted comes in a raw format, digital database can be used to extract and sort the data with ease. E. g. A-Z or Z-A. Data can be filtered using queries using a single data criteria.

Numerical data modelling Numerical modelling – the process of producing a mathematical model to perform predetermined actions. E. g. personal finances, business forecast sales / manage cash / project future growth. Data modelling – creating a conceptual image of the meaning of data, modelling the data helps to evaluate usefulness and justify decisions. E. g. databases can store data and provide access the data through the use of searches. Through the use of relationships data can be sorted and linked. Presenting the data – the tables contain raw data, this is where the data is stored, these tables are usually protected and do not allow for data entry. Databases present data using reports, forms and graphical representations i. e. graphs.

Exam Style Question John runs a chain of four supermarkets. He employs 150 supermarket staff and 10 warehouse staff. The chain uses a number of IT systems, including PCs, for general office tasks, data and numerical modelling and an EPOS system to keep track of stock. 2 (a) Explain two ways John could use numerical and data modelling in running his chain of supermarkets.

Implications of user interfaces and data collection and processing systems TASK – Go through and make notes on how this areas below can have a implication upon how data is collected and processed by an IT system. E. g. Ease of Use – are the questions clear? Are they linked to how the data is going to be presented. Ease of use Accessibility Error reduction Intuitiveness Functionality Performance, usability and cost Compatibility

Exam Style Question (c) John wants to start a loyalty card scheme for the supermarket. Customers sign up using an online form that will have multiple screens. Each screen will capture different information. The table shows part of a data dictionary for screen 1. Draw a suitable user interface for screen 1 of the application process (6 marks)

This would gain 6 marks, it contains all the correct information needed and have drop down menus to ease data entry. They have included buttons to aid navigation and text to help the user.

Exam Style Question Katalog is a large catalogue retailer with stores around the UK. Goods can be purchased in store or via the company website. Goods purchased online are delivered from a central warehouse. The company uses an automated stock control system throughout its stores and the central warehouse. (b) The company uses an automated stock control system in the central warehouse for sales to online customers. Analyse how the features of an automated stock control system will impact on the company and on online customers. (6 Marks)