1 / 27

Case Study

Case Study. LO: Understand the scenario of the 2011 case study and the software required. Learning outcome: Give correct response to exam-type questions. Key words: Liquid Silver, On-line purchasing, Validation, Encoding, Computer workstations, Health and safety.

kamilia-sawicki
Télécharger la présentation

Case Study

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Case Study LO: Understand the scenario of the 2011 case study and the software required. Learning outcome: Give correct response to exam-type questions Key words: Liquid Silver, On-line purchasing, Validation, Encoding, Computer workstations, Health and safety

  2. A Rock band which is becoming more popular. They have a growing fan club. Liquid Silver Despite the fact that their music is really lousy!

  3. They have a small office which runs the admin for their fan club The office has a number of networked PCs.

  4. Question … What types of topology could the company use to link the computers? Star Ring Line/Bus What are the advantages and disadvantages of each?

  5. Liquid Silver have a website . . . What is the purpose of maintaining the website? Provide background information about the band Provide facility to join the fan club on-line(or by posting a hand-written form) Fans can request email updates Purchase merchandise

  6. Question List reasons why fans may wish to purchase items over the internet rather than calling and using a credit card? Easy to search Can see items Better security No waiting if busy

  7. Advantages of an online store Open 24/7 Don’t have to leave home Saves money travelling Easier to search for specific items Less staff needed to take orders Open to a wider customer base(e.g. people out of town.)

  8. Question Liquid silver are planning a 2012 tour. DTP is used to create publicity. What features of DTP make this the best type of software? Frames Stylesheets Templates Formatting (advanced) Graphics (e.g. wrapping)

  9. Using text wrap This is an example of text wrapping- describe the process of taking an image of a book from the website and wrapping text in a DTP application. 1 Open the website, navigate to the correct page 2 Copy (or save) the image 3 Switch to the DTP application, go to the correct place 4 Paste (or insert) the image 5 Set to ‘wrap’ under the image properties 6 Click away from the image, enter the text

  10. Key features of Databases General Office admin tools:Databases • Sort by value (queries) • Searchfor records (queries) • Sharebetween different users • Reports(Output different layout)

  11. Members_File (Database) The field Mem No. is the key field, what is a key field and why is it used? It is a unique reference to a single record. It is used to refer to the record in another file/table (foreign key)

  12. Members_File (Database) What is validation, and why is it used? Validation is a software check to ensure that the data entered is reasonable

  13. Members_File (Database) Name the types of validation which can be applied to the field Gender PresenceLengthType

  14. Members_File (Database) Describe the steps needed to apply validation to the Gender field so that only the values F or M will be accepted. 1. Enter the Members_File and enter design view 2. Click on the Gender Field 3. Enter the validation rule: “M” or “F” 4. Optionally, enter the validation text: “Please enter M or F” 5. Save the changes

  15. Key features of spreadsheets General Office admin tools:Spreadsheets • Formulas used to make calculations • Appearance (formatting) using features like cell fill and conditional formatting • Graphs and charts to display data.

  16. Stock_Detail file (Spreadsheet) If the Selling Price is worked out as a formula based on the Purchase price, what formula would you expect to see in cell C2? Answer: Any of the following: =B2*1.2 =B2+(B2/5) =(B2/5)+B2

  17. Stock_Detail file (Spreadsheet) What formula would you expect to see in cell F2? =D2-E2

  18. Stock_Detail file (Spreadsheet) What function would you expect to see in cell G3? =IF (F3 <100 , “Y” ,”N” )

  19. Network Manager Responsible for ... Logins Installing software Maintenance (for when things go wrong) Backups Security (e.g. AV and Firewall)

  20. Go through that again please Kyezha ... Network Manager Responsible for ... L ogins I nstalling software M aintenance (for when things go wrong) B ackups S ecurity (e.g. AV and Firewall)

  21. What is a workstation?

  22. Using a computer for hours on end can cause Three main problems ... RSI (Repetative Strain Injury) Eye Strain Circulation / back problems

  23. Three main solutions Take regular breaks Including walking around, looking away. Buy the correct equipment Chair with backrest, ergonomicaly-designed keyboard Adjust and arrange Monitor at eye level, chair position

  24. An ideal workstation ...

  25. Three main solutions Take regular breaks Including walking around, looking away. Buy the correct equipment Chair with backrest, ergonomicaly-designed keyboard Adjust and arrange Monitor at eye level, chair position

  26. Get to work!

  27. www.LiquidSilver.com Click here to purchase items Click here for latest tour dates Click here to purchase concert tickets

More Related