2651_BSBTEC302_Assessment
docx
keyboard_arrow_up
School
Holmes Colleges Melbourne *
*We aren’t endorsed by this school
Course
CPP41419
Subject
Information Systems
Date
Dec 6, 2023
Type
docx
Pages
5
Uploaded by AdmiralGrouseMaster925
Assessment Task 1: Knowledge Test
Provide your response to each question in the box below.
Q1:
Answer the following questions:
1.1. How can you use the following key elements of formatting of
spreadsheets appropriate to workplace documents? Write your answer in
100-150 words.
a)
Applying borders
a)
Changing alignment
1.2. Document the formulas you would use to calculate the following:
a)
Sum totals
a)
Averages
a)
Counts of values
Satisfactory
response
Yes ☐
No ☐
1.1
a) To improve the visual attractiveness of data, you may draw a border around cells in Microsoft Excel.
The data may be formatted and laid out in a more attractive manner by using adjustable borders and
various sorts of lines with variable thicknesses. Borders are a useful tool for formatting texts in the
workplace. For instance, borders can be used to emphasise key content or to designate a header or
footer. Borders may also be used to organise data. Borders in a spreadsheet facilitate the
identification of dataset starts and ends as well as the emphasising of key information.
https://www.makeuseof.com/how-to-format-borders-excel/
b) Alignment is a formatting tool that you may use for business papers. You can align text, for
instance, to the left, right, or centre. Data can also be aligned into rows or columns. Microsoft Excel
aligns text to the bottom-left and numerals to the bottom-right of cells by default. Nevertheless, you
may quickly adjust the default alignment by utilising the Format Cells window, keyboard shortcuts,
ribbon, or your own custom number format. Selecting the required cell or cells, selecting the Home
tab > Alignment group, and selecting the desired choice are the steps involved in changing text
alignment in Excel.
https://www.ablebits.com/office-addins-blog/change-alignment-excel/
1.2
a)
You can add individual values, cell references or ranges or a mix of all three. For example:
=SUM(A2:A10)
Adds the values in cells A2:10. =SUM(A2:A10, C2:C10) Adds the values in cells
A2:10, as well as cells C2:C10.
https://support.microsoft.com/en-us/office/sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89
b)
Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20
Assessment Guidelines Task 01
Unit Code: BSBTEC302
Page
1
of
5
contains numbers, the formula
=AVERAGE(A1:A20)
returns the average of those numbers.
https://support.microsoft.com/en-au/office/average-function-047bac88-d466-426c-a32b-8f33eb960cf6
c)
Use the COUNT function to get the number of entries in a number field that is in a range or array of
numbers. For example, you can enter the following formula to count the numbers in the range
A1:A20:
=COUNT(A1:A20)
.
https://support.microsoft.com/en-us/office/count-function-a59cd7fc-b623-4d93-87a4-d23bf411294c
Q2:
Explain the key features of the following cloud-based and non-cloud
based spreadsheet applications:
a)
Google Sheets
a)
MS Excel
Write 70-120 words for each.
Satisfactory
response
Yes ☐
No ☐
a) Spreadsheets may be created and edited online with Google Sheets, an application for
the cloud. All the capabilities of a conventional spreadsheet program, including pivot
tables, charts, and formulae, are available in Google Sheets. In your browser, create and
collaborate on online spreadsheets for data analysis, project planning, and other
purposes. Take any text's formatting and apply it to another text selection; Format data
using several decimal places, a percentage, and other options; Modify or add boundaries
to cells; Combine cells; Modify the text's alignment; Rotate or alter the way text wraps;
Include links, comments, charts, filters, or other features; Engage in conversation with
other spreadsheet viewers; Start a discussion thread; Distribute to your group and/or add
a comment.
https://support.google.com/a/users/answer/9300022?hl=en
b) One of the productivity apps in the Microsoft Office suite is MS Excel, a spreadsheet
program. Excel has tools for producing pivot tables, visualising data, and carrying out
computations. Versions that are not cloud-based and those that are are both available. An
Excel spreadsheet may be formatted and edited in a variety of ways.
Includes choices for cell insertion and deletion, formatting options and styles, font size,
font styles, font colour, background colour, alignment, and editing.
Includes options for inserting photographs and figures, creating graphs, charts, and
sparklines, choosing a header and footer, and putting equations and symbols in tables.
Page Layout: The page layout option includes options for themes, orientation, and page
arrangement.
Recipes: With MS Excel's ability to generate tables with a lot of data, you may use this
function to add formulae to your table and obtain answers more quickly.
Info: This area includes adding external data (from the web), filtering choices, and data
tools.
https://byjus.com/govt-exams/ms-excel-basics/#Features-of-MS-Excel
Assessment Guidelines Task 01
Unit Code: BSBTEC302
Page
2
of
5
Q3:
Answer the following questions:
3.1. What are the key features of organisational guidelines on
spreadsheet design and use? Write your answer in 70-120 words.
3.2. Explain the purpose of an organisational style guide in 50-100
words.
Satisfactory
response
Yes ☐
No ☐
3.1 Spreadsheets ought to be as straightforward, unambiguous, and uniform as feasible.
To lessen clutter, eliminate extraneous formatting and data. To make it obvious which cells
are for calculations, which are for input, and which include headers and warning
messages, consider utilising cell styles.
Adopting a uniform standard is crucial when using a spreadsheet. It's possible that the
firm you work for has standards for all colours and typefaces, and that these standards
are followed when creating company branding materials. Multiple font styles in a
spreadsheet might make it challenging to read.
It's best to choose one or two and make sure the typefaces you use are appropriate for a
business setting. One useful technique for organising worksheets is to change the colour
of the spreadsheet tabs.
https://www.simonsezit.com/article/excel-spreadsheet-design/
3.2 An essential document that establishes standards and ensures a consistent brand
experience across all business channels is the organisational style guide. It includes all of
the crucial details you need to know when creating communications for your company,
such as the name, logo, mission, and vision of your brand, supporting and contributing to
standardised procedures and consistency.
https://www.grammarly.com/business/learn/style-guide-components/
Q4:
Explain the organisational requirements for ergonomics, work periods
and breaks, and sustainability in relation to spreadsheet production in
100-150 words.
Satisfactory
response
Yes ☐
No ☐
Exercise, Activity, and Posture
Maintain good posture, being mindful of how your head, neck, spine, arms, wrists, hips,
thighs, and feet are positioned. Basically, make sure your shoulders are relaxed (not
hunched over, not raised), your small of your back is supported, and your thighs are not
under any strain.
Make frequent adjustments to your posture by switching between them.
When typing, press the keys with the least amount of force possible.
Assessment Guidelines Task 01
Unit Code: BSBTEC302
Page
3
of
5
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Maintain a neutral posture with your hands, wrists, and forearms in a straight line.
Steer clear of awkwardly reaching for work items like the mouse, phone, and reference
books.
Steer clear of resting your elbows, forearms, or wrists on sharp edges or rough surfaces.
Throughout the day, take numerous little pauses to allow your muscles and joints to rest
and heal.
Organization, Work Style, and Breaks
By making a strategy and establishing reasonable goals for your workday, you may
lessen your stress.
To prevent feeling "swamped," arrange your workload to help balance out hectic and
slack periods.
To add interest to the day, switch up the chores. Deliver a message in person rather than
over the phone, for instance.
Steer clear of prolonged repeated activities. For instance, split up your computer work
with other duties like making calls, taking meetings, filing, and copying.
Arrange furniture, materials, and equipment such that they are most useful for everyday
chores.
Use privacy filters on computer screens and papers, as well as office partitions, to
improve privacy.
Reward colleagues' contributions and successes on a regular basis.
https://www.ergonomics.com.au/office-ergonomics-checklist/
Q5:
Why is it important to determine the target audience and purpose before
preparing a business document? Answer in 50-100 words.
Satisfactory
response
Yes ☐
No ☐
Analysing your audience is essential to knowing what should be included in any writing
article. Understanding your readership helps you choose the best format for your essay,
as well as the language and tone to employ, the material to include, and the order in
which to cover each issue.
https://www.umgc.edu/current-students/learning-resources/writing-center/online-guide-
to-writing/tutorial/chapter2/ch2-04
Q6:
How should you name and store spreadsheet according to organisational
requirements? Write your answer in 50-70 words.
Satisfactory
response
Assessment Guidelines Task 01
Unit Code: BSBTEC302
Page
4
of
5
Yes ☐
No ☐
Spreadsheets may be named and stored in a variety of ways based on the needs of the
business. Using a same naming convention for all spreadsheets is one method. This can
guarantee that spreadsheets are simple to recognise and find. Spreadsheets can also be
kept in one central location, such a shared network drive. By doing this, you can make
sure that everyone has access to the most recent spreadsheet version.
Q7:
How can you use online assistance or help function to overcome basic
difficulties with spreadsheet design and production? Write your answer in
50-100 words.
Satisfactory
response
Yes ☐
No ☐
Use the online support or help feature to get information on how to solve problems if you
are experiencing trouble with spreadsheet design. You may also ask questions regarding
spreadsheet creation and design using the online help or support feature.
LIST OF REFERENCES
https://www.makeuseof.com/how-to-format-borders-excel/
https://www.ablebits.com/office-addins-blog/change-alignment-excel/
https://support.microsoft.com/en-us/office/sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89
https://support.microsoft.com/en-au/office/average-function-047bac88-d466-426c-a32b-8f33eb960cf6
https://support.microsoft.com/en-us/office/count-function-a59cd7fc-b623-4d93-87a4-d23bf411294c
https://support.google.com/a/users/answer/9300022?hl=en
https://byjus.com/govt-exams/ms-excel-basics/#Features-of-MS-Excel
https://www.simonsezit.com/article/excel-spreadsheet-design/
https://www.grammarly.com/business/learn/style-guide-components/
https://www.ergonomics.com.au/office-ergonomics-checklist/
https://www.umgc.edu/current-students/learning-resources/writing-center/online-guide-to-
writing/tutorial/chapter2/ch2-04
Assessment Guidelines Task 01
Unit Code: BSBTEC302
Page
5
of
5