Reference no: EM133520892

Learning Outcome 1: Be able to utilise the main functions of a word processor.
Learning Outcome 2: Be able to identify useful information from the Internet.
Learning Outcome 3: Be able to utilise the main functions of spreadsheet software.
Learning Outcome 4: Be able to utilise the main functions of presentation software.

Introduction:

You are a junior IT trainer for Bluetech Ltd, online sellers of branded bluetooth gadgets. You have been tasked with creating a YouTube video demonstration for the benefits of technology for all employees.

You are to create a screencast (video recording of your screen) and upload it to YouTube. It is recommended that you use screencast-o-matic or screenr co, but feel free to use any other software.

Task 1

In preparation for the YouTube video, prepare some notes which:

• Describes the main functions within a word processing package.
• Describes how website text should be presented in academic work in order to avoid plagiarism
• Describes the main functions of spreadsheet
• Explains the types of formulae that can be applied to data in a worksheet.

Task 2

The YouTube video should include a demonstration of:

1. The use of a search engine
• Open your web browser
• Open a search engine of your choice
• Change to a search engine for photos only
• Change to a search engine for video
• Change to a different search engine
• Execute a search
• Open a website
• Copy the information of 1 paragraph

2. The use of a word processor software (e.g., Word, Pages, etc.)
• Open your word process
• Create or open a document
• Paste the information from the website
• Insert symbols
• Add a picture and/or diagram
• Rephrase the paragraph copied
• Change the size, font and style (e.g., make it bold or italic) of some of the text
• Any other feature that you find useful
• Save and close the document

3. The use of a spreadsheet software (e.g., Excel, Numbers, etc.)
• Open your spreadsheet software
• Type some text in the first 4 cells and some numbers in the adjacent cells
• Change the font colour and add borders to the cells
• Add the numbers using a formula
• Divide the numbers using a formula
• Make an average using a formula
• Using your numbers add a graph
• Any other feature that you find useful
• Save and close the document

4. The use of a presentation software (e.g., PowerPoint, Keynote, etc.)
• Open the presentation software
• Create 1 slide with text and a graphic
• Duplicate the slide
• Create an animation in the presentation
• Launch the slideshow
• Any other feature that you find useful
• Save and close the document

ASSESSMENT CRITERIA

AC 1:

1.1 Describe the main functions within a word processing package.
1.2 Insert pictures and symbols in a word-processed business document.
1.3 Use common functions to manipulate and evaluate text in a business document.
1.4 Use of a range of functions to alter the presentation of word-processed business documents.

AC 2:
2.1 List a range of search engines which can be used to find specific information.
2.2 Extract relevant information from a web source.
2.3 Use website information in a word-processed business document.
2.4 Describe how website text should be presented in academic work in order to avoid plagiarism.

AC 3:
3.1 Describe the main functions of spreadsheet.
3.2 Format cells, rows, columns and worksheets.
3.3 Explain a range of formulae that can be applied to data in a worksheet.
3.4 Use a range of functions to improve the presentation of data in a worksheet.

AC 4:
4.1 Open, save and close a presentation slideshow.
4.2 Insert and duplicate slides.
4.3 Incorporate animation into a presentation.
4.4 Create a business presentation with text, graphics and animation.