| 2 |
 1.1 Components of a Business System
| 
|
| 3 |
 1.2 Hardware and Software
|
|
| 4 |  1.3 Data Communications Overview
|
|
| 5 |
 1.4 Internet Technologies
|
|
| 6 |
 1.5 System Security and Control
Learning OutcomeAt the completion of this topic, you will understand the security associated with the use of Information Technology in Business. 1.5 Assessment Criteria Resource- 1.5.1 Identify the overall purpose of security in a computing environment.
 Purpose of Information Security Resource- Backup of Information Systems Resource
- Disaster recovery procedures and threats Resource
- 1.5.2 Explain the procedures for and the importance of, backup and recovery, passwords, disk handling, and label checks.
- Identifying the Required Backup Approach Resource
- Storage of backup media Resource
- Backups and recovery - example for MS Windows Resource
- 1.5.3 Demonstrate an understanding of the concept of protection and access control in relation to physical and other threats, e.g. viruses, natural disasters, physical access, firewalls, encryption control.
- Virus control Resource
- Firewalls Resource
- Passwords Resource
- 1.5.4 Discuss the need for systems control with respect to auditability, maintainability and recoverability.
|
|
| 7 | Extra quizzes just for fun!
- These quizzes are 'above and beyond' the requirements for NZDB Computer Concepts 150... but you can try them out anyway just for fun
 IT general knowledge Quiz- HTML quiz
- Java quiz
- SQL queries Quiz
|
|
| 8 | Recommended reading
Suggested student references - theory component
Beekman, George: Computer Confluence: Orgegon State University. C.A.: Prentice Hall. Latest edition.
Capron, H.L.: Computers: tools for an information age. Readings, MASS:Addison-Wesley. Latest edition.
Curtin, Dennis P. and others: Information technology: the breaking wave. Boston: McGraw-Hill
Martin, Edward G. and Parker, Charles S. PC concepts Fort Worth, TX: Dryden Press. Latest Edition.
O'Leary, Timothy J. Computing essentials. New York: McGraw-Hill. Latest Edition.
Sawyer, Stacey C., Williams, Brian K. and Hutchinson, Sarah E. Using information technology: a practical introduction to computers & communications. Chicago, IL: Irwin. Brief Ed.
Suggested student references - practical componentMartin, Edward G. and Parker, Charles S. Mastering today's software. Fort Worth, TX: Dryden Press. Latest Edition.
Hutchinson S.E. and Coulthard G.J Advantage series for computer education New York: Irwin McGraw-Hill.
O'Leary, T.J. and O'Leary, L.I. The O'Leary lab series. New York: Irwin McGraw-Hill
Toliver P. and Johnson Y. Select lab series. Reading MASS: Addison Wesley.
Erikson, F.J., Vonk, J.A. The effective series. New Work: Irwin McGraw-Hill
Duffy T. Duffy lab series. Reading MASS: Addison Wesley.
Additional referencesNumerous supplements and support materials are available in conjunction with the references listed above and these should be discretionary but may include: videos, web sites, multimedia CD ROM's, interactive software tutorials, and of course this course!
|
|
| 9 |  2.1 Ethical Issues
Learning OutcomeAt the completion of this topic, you will understand ethical issues associated with the use of Information Technology in business.- 2.1 Assessment Criteria Resource
- Resources for this topic have been removed in the free version of this course
|
|
| 10 |  2.2 People Issues
Learning OutcomeAt the completion of this topic, you will understand the interrelationship existing between the user and the computer system.- 2.2 Assessment Criteria Resource
- Resources for this topic have been removed in the free version of this course
|
|
| 11 |  3.1 Generic Computer Skills
Learning OutcomeAt the completion of this topic, you will be
able to demonstrate that you have generic skills for the use of computer hardware and software in a business environment.- 3.1 Assessment Criteria Resource
- Resources for this topic have been removed in the free version of this course
|
|
| 12 |  3.2 Effective Use of Information Technology (Compulsory)
Learning OutcomeAt the completion of this topic, you will be
able expected to demonstrate that you can use information technologies effectively to satisfy a range of outcomes in a business environment.- 3.2 Assessment Criteria (Compulsory Outcomes) Resource
- Resources for this topic have been removed in the free version of this course
- 3.2.1 Format formal business reports.
- 3.2.2 Produce charts and graphs.
 Creating charts in Excel Word document- Modifying charts Word document
- Formatting charts Word document
 Excel files for exercises- Charts in Excel quiz
- 3.2.3 Use formulae and manipulate data to aid decision making.
- 3.2.4 Use IF Logic to perform tests on data.
- 3.2.5 Create forms for the input of data.
- 3.2.6 Edit and manipulate a database.
- 3.2.7 Extract information from a database and prepare ad-hoc reports.
- 3.2.8 Send and receive documents / messages electronically.
- 3.2.9 Retrieve information using online search facilities.
|
|
| 13 |  3.2 Effective Use of Information Technologies (Electives)
Learning OutcomeYou will be expected to use software effectively to satisfy at least three of the elective outcomes.- 3.2 Assessment Criteria (Electives) Resource
- Resources for this topic have been removed in the free version of this course
- 3.2.10 Customise the personal computer desktop.
- 3.2.11 Mail merge letters.
- 3.2.12 Produce overheads for presentations.
- 3.2.13 Create electronic slide shows.
- Create electronic slide shows in PowerPoint Word document
- Presentations quiz
- 3.2.14 Produce flyers / newsletters.
- 3.2.15 Digitise documents / images.
- 3.2.16 Automate repetitive tasks.
- Automate repetitive tasks, using macros in Word Word document
- Word documents required for macros file
- Macros quiz (not started)
- 3.2.17 Link and/or embed objects into documents.
|
|
