carpentary

profilenaidurupa07
BSBITU304LearnerActivityBookletFillable.pdf
Home>Architecture and Design homework help>carpentary

Learner Activity Booklet CPC30211 Certificate III in Carpentry

Learner name: _______________________________

BSBITU304 Produce spreadsheets

Learner Activity Booklet BSBITU304 Produce spreadsheets V1 CPC30211 Certificate III in Carpentry

Page 2

Learning Activities Section 1

1.1 Computers are known to present a number of issues surrounding the area of Occupational Health and Safety. These health and safety issues may include: tick all that apply  Lighting  Noise  Heat  Cables  Posture  Occupational overuse syndrome

1.2 Posture is very important when working with computers, as poor posture can lead to a number of health issues.  True  False

1.3 Some energy conservation techniques can include: identify 4 examples in the table below

1

2

3

4

1.4 What is waste management?

Learner Activity Booklet BSBITU304 Produce spreadsheets V1 CPC30211 Certificate III in Carpentry

Page 3

1.5 Spreadsheets are electronic worksheets that utilise a scientific calculator in a column and row page format.  True  False 1.6 Complete the table below by numbering the steps for entering data into a spreadsheet.

Number Step

When Excel sees that you are typing into a list, pressing enter at the end of the row will move the cursor down one row and back to the first column.

To enter data in Excel, just select a cell and begin typing. You'll see the text appear both in the cell and in the formula bar above.

You can also press the tab key instead of the enter key. If you press tab, the cursor will move one cell to the right once the information has been entered.

To tell Excel to accept the data you've typed, press enter. The information will be entered immediately, and the cursor will move down one cell.

At any time while you are typing you can press the escape key to cancel. This brings Excel back to the state it was in before you started typing.

When you want to delete information that has already been entered, just select the cells, and press the delete key.

Learner Activity Booklet BSBITU304 Produce spreadsheets V1 CPC30211 Certificate III in Carpentry

Page 4

Learning Activities Section 2

2.1 When planning to create a spreadsheet, it is important to consider the audience of the spreadsheet and any information requirements that need to be included. A good spreadsheet must have a good design and contain good data in order for it to be effective.  True  False

2.2 Not everyone reads in the same way. In fact, there are four types of readers: What are they?

1

2

3

4

2.3 There are many different types of operations and functions that occur automatically, when using spreadsheet software. Some of these functions could include: tick all that apply  Auto date  Auto correct  Auto format  Auto text  Default settings  Headers and footers

Learner Activity Booklet BSBITU304 Produce spreadsheets V1 CPC30211 Certificate III in Carpentry

Page 5

Learning Activities Section 3

3.1 The process of entering data into a spreadsheet/database is called data entry, and can be performed by either a person or a computer.  True  False

3.2 In order to perform computerised data entry, once can use programs such as Excel spreadsheet, which can be done via the Microsoft Excel program.  True  False

3.3 When one is formatting, they are arranging the data, size, colours etc. of a document for output process. This is what the formatting process is, and therefore may include the alteration of: tick all that apply  The alignment on the page.  The efficiency of the formulae.  Any enhancements to format – borders, patterns and colours.  Any enhancements to text.  Headers/footers.  The use of absolute and relative cell addresses.  The use of cell addresses in formulae.

3.4 Conditional formatting is useful, for what?

Learner Activity Booklet BSBITU304 Produce spreadsheets V1 CPC30211 Certificate III in Carpentry

Page 6

3.5 There is a multitude of resources that can be utilised for obtaining assistance with creating and editing spreadsheets. The easiest to follow are the in-client help documents, which can be located by accessing the help button – this is in the file tab on the excel toolbar.  True  False

3.6 In some cases, there may be time where you type in a formula that won't work or Excel may alert you that there is an error in the formula. For instance, rather than typing =SUM(F1,F@), the cell will display this: #NAME?  True  False

Learner Activity Booklet BSBITU304 Produce spreadsheets V1 CPC30211 Certificate III in Carpentry

Page 7

Learning Activities Section 4

4.1 Commonly used charts/graphs for numerical data are: list 6 examples

1

2

3

4

5

6

4.2 Once the chart has been inserted into the spreadsheet what happens next?

Learner Activity Booklet BSBITU304 Produce spreadsheets V1 CPC30211 Certificate III in Carpentry

Page 8

4.3 Explain how to switch row and column data in excel

Learner Activity Booklet BSBITU304 Produce spreadsheets V1 CPC30211 Certificate III in Carpentry

Page 9

Learning Activities Section 5

5.1 When a spreadsheet has been completed, it will need to be previewed and checked over to see if there are any mistakes that may have missed.  True  False

5.2 Designated timelines may include: list 3 examples below

1

2

3

5.3 Information about how to store spreadsheets could include: tick all that apply  Authorised access  File naming conventions  Filing locations  Organisational policy for backing up files  Organisational policy for filing hard copies of spreadsheets  Security  Storage in electronic folders/sub-folders  Storage on CD-ROM, USB, tape back-up, server

Learner Activity Booklet BSBITU304 Produce spreadsheets V1 CPC30211 Certificate III in Carpentry

Page 10

Orange International College Pty Ltd | ABN: 15 167 063 596 RTO No: 41315 | CRICOS Provider Code: 03446A

Level 6, 420 Collins Street Melbourne Victoria 3000 Phone: +61 3 9670 2985 | Email: [email protected] | Web: orange.edu.au

  • Unit of competency
  • Overview/Competency demonstration
  • BSBITU304 Produce spreadsheets
    • Select and prepare resources
    • Plan spreadsheet design
    • Create spreadsheet
    • Produce simple charts
    • Finalise spreadsheets
  • Learner Activity Workbook Overview
  • Instructions
    • Learning Activities
    • Simulated Learning Activities
    • Self-Assessment Questionnaire
  • Section 1 – Select and prepare resources
    • Adhere to ergonomic, work organisation and occupational health and safety requirements
    • Lighting
    • Noise
    • Heat
    • Cables
    • Posture
    • Use energy and resource conservation techniques to minimise wastage
    • 13 Energy Saving Ideas for a Sustainable Workplace
    • What is waste management?
    • Life cycle of a product
    • Why is managing waste important?
    • Identify spreadsheet task requirements in relation to data entry, storage, output and presentation
  • Learning Activities Section 1
  • Section 2 – Plan spreadsheet design
    • Ensure spreadsheet design suits purpose, audience and information requirements of task
    • Spreadsheet Design Tips for Microsoft Excel
    • Formatting to improve readability
    • Reading Styles
    • Formatting
    • Use style sheets and automatic functions to ensure consistency of design and layout
    • Style Sheets
  • Learning Activities Section 2
  • Section 3 – Create spreadsheet
    • Ensure data is entered, checked and amended to maintain consistency of design and layout, in accordance with organisational and task requirements
    • Creating a table
    • Creating a data spreadsheet
    • How to begin
    • Data to be entered
    • Process
    • Sizing columns/rows
    • Format spreadsheet using software functions to adjust page and cell layout to meet information requirements, in accordance with organisational style and presentation requirements
    • Adding/deleting columns/rows
    • Formatting cells
    • Formatting text
    • Headers/footers
    • Formatting the document
    • Apply conditional formatting based on text in a cell
    • Quick formatting
    • Advanced formatting
    • Relative & absolute cell references
    • Relative cell references
    • Absolute cell references
    • Using advanced formula
    • Ensure formulae are tested and used to confirm output meets task requirements, in consultation with appropriate personnel as required
    • Errors in your formula
    • Totalling wages
    • Use manuals, user documentation and online help to overcome problems with spreadsheet design and production
  • Learning Activities Section 3
  • Section 4 – Produce simple charts
    • Select chart type and design that enables valid representation of numerical data, and meets organisational and task requirements
    • Area chart/graph
    • Column/bar chart
    • Histogram
    • Line/curve
    • Pie
    • Scatterplot
    • Create charts using appropriate data range in spreadsheet
    • Arrange data for charts
    • Creating charts
    • Modify chart type and layout using formatting features
    • To switch row and column data
    • Let's look at how to do this.
    • To move a chart
  • Learning Activities Section 4
  • Section 5 – Finalise spreadsheets
    • Preview, adjust and print spreadsheet and any accompanying charts, in accordance with task requirements
    • Ensure data input meets designated timelines and organisational requirements for speed and accuracy
    • Name and store spreadsheet in accordance with organisational requirements and exit application without data loss/damage
  • Learning Activities Section 5
  • Further Reading
  • Self-Assessment Questionnaire – Produce spreadsheets
  • Learning Participation Record
  • Unit of competency
  1. Learner name:
  2. Lighting: Off
  3. Noise: Off
  4. Heat: Off
  5. Cables: Off
  6. Posture: Off
  7. Occupational overuse syndrome: Off
  8. True: Off
  9. False: Off
  10. 1:
  11. 2:
  12. 3:
  13. 4:
  14. 14 What is waste management:
  15. True_2: Off
  16. False_2: Off
  17. NumberRow1:
  18. NumberRow2:
  19. NumberRow3:
  20. NumberRow4:
  21. NumberRow5:
  22. NumberRow6:
  23. True_3: Off
  24. False_3: Off
  25. 1_2:
  26. 2_2:
  27. 3_2:
  28. 4_2:
  29. Auto date: Off
  30. Auto correct: Off
  31. Auto format: Off
  32. Auto text: Off
  33. Default settings: Off
  34. Headers and footers: Off
  35. True_4: Off
  36. False_4: Off
  37. True_5: Off
  38. False_5: Off
  39. The alignment on the page: Off
  40. The efficiency of the formulae: Off
  41. Any enhancements to format borders patterns and colours: Off
  42. Any enhancements to text: Off
  43. Headersfooters: Off
  44. The use of absolute and relative cell addresses: Off
  45. The use of cell addresses in formulae: Off
  46. 34 Conditional formatting is useful for what:
  47. True_6: Off
  48. False_6: Off
  49. True_7: Off
  50. False_7: Off
  51. 41 Commonly used chartsgraphs for numerical data are list 6 examples:
  52. 2_3:
  53. 3_3:
  54. 4_3:
  55. 5:
  56. 6:
  57. 42 Once the chart has been inserted into the spreadsheet what happens next:
  58. 43 Explain how to switch row and column data in excel:
  59. True_8: Off
  60. False_8: Off
  61. 1_3:
  62. 2_4:
  63. 3_4:
  64. Authorised access: Off
  65. File naming conventions: Off
  66. Filing locations: Off
  67. Organisational policy for backing up files: Off
  68. Organisational policy for filing hard copies of spreadsheets: Off
  69. Security: Off
  70. Storage in electronic folderssubfolders: Off
  71. Storage on CDROM USB tape backup server: Off