Computer Practice N6 SB

TVET FIRST

ME Smith, DL Ouwerkerk K Mewa

• Publisher: Macmillan
• Year: 2015
• Print ISBN: 9781430802068
• eBook ISBN: 9781430803300
• Topic: Negocios y empresa
• Subtopic: Negocios en general

Full colour to accurately reflect on-screen reality.Student-centred approach means the students can work independently at home.Labelled diagrams break down practical concepts so that they can be easily understood.

Table of contents

• ME Smith, DL Ouwerkerk & K Mewa
• Cover page
• Title page
• Copyright page
• Contents
• Module 1: Text manipulation
• Unit 1.1: Use page and paragraph borders to enhance the appearance of documents
• Unit 1.2: Create a primary and secondary document to perform a merge
• Unit 1.3: Sorting data
• Unit 1.4: Macros
• Unit 1.5: Styles
• Unit 1.6: Labels
• Unit 1.7: Equations
• Unit 1.8: Graphics
• Unit: 1.9: Image processing technology
• Unit 1.10: Advanced columns and tables with maths function
• Unit 1.11: Fonts
• Unit 1.12: Automatic paragraph numbering
• Unit 1.13: Table of contents and indexes
• Unit 1.14: Set up paper size
• Unit 1.15: Thesaurus
• Module 2: Spreadsheets (elective module)
• Unit 2.1: Use the necessary spreadsheet functions to calculate the amount payable per month where the rate of interest, period, principal amount and formulas are given
• Unit 2.2: Use the necessary spreadsheet functions to display certain text when a condition is true and other text when the condition is false(decision-making)
• Unit 2.3: Use the necessary spreadsheet function to do certain calculations to round off figures to certain decimal places
• Unit 2.4: Use reference tables to look up tax rates for calculations
• Unit 2.5: Create professional templates by suppressing zeros in the spreadsheet
• Unit 2.6: Use basic macro commands to include cursor movements in keystroke macros
• Unit 2.7: Create macros that execute automatically when a spreadsheet is loaded or retrieved to place the cursor, suppress the display of zeros and limit the movement of the cursor to unprotected cells
• Unit 2.8: Use range names in formulas and functions and combine spreadsheet ranges
• Unit 2.9: Change formulas and functions in ranges to values after variable data have been entered in a template before being saved
• Unit 2.10: Save a specified range from a spreadsheet under another name
• Unit 2.11: Create line, column and stack bar graphs from non-contiguous data ranges, display legends, change settings for grids, scale, data labels and line symbols
• Unit 2.12: Create pie charts with an exploded segment and data labels for segments
• Unit 2.13: Use escape codes, or graphic facilities, to fit larger spreadsheets on one page of A4 paper and to print in landscape format
• Module 3: Information systems
• Unit 3.1: Information systems
• Unit 3.2: Computer programs
• Unit 3.3: Files and access methods
• Unit 3.4: Methods of processing
• Unit 3.5: Data communication and networks
• Unit 3.6: Acquisition of computer technology
• Unit 3.7: Security
• Module 4: System software
• Unit 4.1: DOS commands
• Unit 4.2: Batch files
• Unit 4.3: Hard disks
• Unit 4.4: Files in the root directory
• Unit 4.5: Damaged disks and lost files
• Unit 4.6: Demonstrations (not for exam purposes)
• Module 5: Viruses
• Unit 5.1: Types of viruses
• Unit 5.2: Virus infection
• Unit 5.3: Prevention of virus infection
• Unit 5.4: Antivirus software
• Unit 5.5: Detection of a virus by using the operating system
• Module 6: Troubleshooting
• Unit 6.1: Hardware-related errors
• Unit 6.2: Monitor malfunctions
• Unit 6.3: Interpret hard drive failure messages
• Unit 6.4: Solving specific printer problems
• Unit 6.5: Specific questions about memory
• Unit 6.6: Use application software manuals
• Glossary
• Back cover