COMPUTER APPLICATION
CHAPTER 1: AN INTRODUCTION TO WORD PROCESSING
•A definition of word processing & its main functions
•Microsoft Office Word
•The Word screen
•Navigating the screen, different views
•Basic commands: new, open, save, close, print, page set-up, print properties, print preview
•Enter text, set language, autocorrect, spelling check, grammar check, thesaurus, word count
•Insert, overtype, move, delete, highlight text
•Edit: cut, copy, paste, undo, redo/repeat
•Modify text: find and replace, change case
•Search for text, graphics, tables
•Insert pictures, symbols, special characters, charts, screenshots
•Use shortcut keys
CHAPTER 2: EDITING AND FORMATTING WORD PROCESSED DOCUMENTS : PART I
•Format a page: format and edit background, change page orientation and size, adjust margins,
insert columns, edit columns, add headers and footers, add page numbers, insert a page break,
insert a watermark, select the page background colour
•Format text: bold, italics, underline, alignment, font style, font size, font colour, font effects
•Format paragraphs: alignment, indentation, spacing
•Select and edit themes and styles
•Insert and edit bullet points and numbering
•Format borders and shading
•Use shortcut keys
CHAPTER 3: EDITING AND FORMATTING WORD PROCESSED DOCUMENTS : PART II
•Insert a table
•Format a table
•Edit a table
•Insert shapes
•Draw shapes
•Format shapes, apply special effects
•Insert objects
•Resize, move, copy, delete, add text, fill, align, rotate, edit, and rotate shapes and objects
•Insert and format WordArt
•Insert and format Smart Art
•Produce a checklist for an effective word processed document
CHAPTER 4: FINDING AND USING INFORMATION FROM THE INTERNET
•Define plagiarism
•Examples of search engines
•Use search engines to find and select information
•Select text from a website
•Export text from a website
•Present website text and cite its source
•Select a picture from a website
•Export a picture from a website
•Present picture taken from website & cite its source
CHAPTER 5: AN INTRODUCTION TO SPREADSHEETS
•Definition of spreadsheet software & its functions
•Key terminology: workbook, worksheet, cell, row, column
•Microsoft Office Excel
•The Excel screen
•Navigating the screen, different views
•Basic commands: new, open, save, close, print page set-up, print properties, preview, select a
print area
•Types of data: labels, constants, formulae
•Edit: cut, copy, paste, undo, redo, find, replace, select all, edit active cell, clear cell contents
•Enter data: cell, row, column
•Format labels
•Format values
•Insert a row, column
•Widen columns
•Introduction to formulae: constants and operators
•Addition formula
•Subtraction formula
•Use shortcut keys
CHAPTER 6: SPREADSHEET FORMULAE AND FUNCTIONS: PART I
•Use relative cell references
•Use absolute cell references
•Use mixed cell references
•Use commonly used formulae and functions: multiplication, division, average, minimum,
maximum round a number, count values
•Use AutoSum
•Use Auto calculate
•Display formulae when printing
•Display row and column headings when printing
•Sort data
•Filter data
•Understand common error messages
CHAPTER 7: FORMATTING SPREADSHEETS : PART II
•Workbook management:
•Insert a new worksheet
•Rename a worksheet
•Move/copy a worksheet
•Change a worksheet tab colour
•Delete a worksheet
•Protect a worksheet
•Format cells, rows and columns
•Add borders
•Insert: diagrams, pictures, symbols
•Insert headers and footers
•Format as a table
•Hide selected rows
•Apply cell styles
•Hide columns and rows
•Use shortcut keys
CHAPTER 8: CREATING GRAPHS FROM A SPREADSHEET : PART III
•Present information using a graph
•Select appropriate types of graph
•Enter data ranges
•Enter titles: main, axes and data
•Enter a legend
•Format a graph
•Print a graph
•Modify a graph
•Resize a graph
•Move a graph
CHAPTER 9: AN INTRODUCTION TO PRESENTATION SOFTWARE
•Definition of presentation software & main functions
•Microsoft Office PowerPoint
•The PowerPoint screen
•Navigate the PowerPoint screen and different views.
•Define presentation software and its main functions
•Enter text, set language and use the spelling check, grammar check and thesaurus.
•Select slide design, background and layout.
•Navigate the PowerPoint screen and different views, including normal, slide sorter, reading,
slide show and the outline pane.Use basic commands such as: new, open, save, close, print, page
set-up, print properties, print preview, handouts and speaker notes.
•Format text – select font style, size and colour and alignment.
•Edit, delete, copy, find and replace text.
•Format paragraphs.
•Insert slide numbers, date and time, headers and footers.
•Insert new slides and duplicate slides.
•Rearrange and delete slides.
•Insert pictures, Clip Art graphics, SmartArt, diagrams, graphs, tables, text
boxes and hyperlinks.
•Format graphics.
•Draw shapes and objects and format, move, resize and delete objects.
•Run and stop a slideshow.
•Use shortcut keys
CHAPTER 10: PRODUCING A MULTIMEDIA PRESENTATION : PART I
•Define transitions, add transitions, effects to slides
•Define animations
•Add animations
•Add effects to objects
•Copy animation from one object to another
•Insert audio clips from files and ClipArt
•Record an audio clip
•Insert videos from files, websites and ClipArt
•Insert actions
•Set up slideshow delivery
