Notesale: Turn your study into money

Document Preview

Extracts from the notes are below, to see the PDF you'll receive please use the links above

---

Guide for non-technical lecturers on how to use spreadsheets (electronic)
Unit 27_P1
In this document I will be explaining what electronic spreadsheets are, their functions and how to use them
(for a non-technical lecturer)
...

 What is a spreadsheet?
A spreadsheet is a grid that organises data and information into rows and columns
...
You can also insert
formulas into your spreadsheet to work with data
...
Spreadsheets are based on a variety of subjects
...


Row
Column Header
Row Header

Column

Different functions of a spreadsheet and key things:
Text – Text can be formatted in various ways, e
...
font/colour/size
...
For
example, you can change the currency format which will display a currency symbol (£
pound sign in the U
...
/ $ dollar sign in countries like Australia/United States of America)
Formulae – a formula carries out numerous equations in other cells
...

Formula Bar – The formula bar allows people to create and view formulae by adding some
of the cells together to get a sum/total
...

The column header – Column headers are used to identify and acknowledge each column
of the spreadsheet
...


Sorting and filtering
When you enter data or information into excel it is usually unorganised – in order to
organise it you make have to rearrange information into different ways to answer different
questions
...


In order to sort a list of data and information you must:
1
...

3
...


Select a single cell in the column containing the data you want to sort
...


Filtering – Filtering is a way that people can use Excel to quickly remove certain data and
information from their spreadsheet
...
Excel has an “AutoFilter” feature that makes it
very easy and simple to remove data from their spreadsheets
...

2
...

4
...

6
...


Lecturers at Universities can use spreadsheets by:
Fees – Universities can keep track with students’ fees by using a spreadsheet – they can
insert the students’ names and view/monitor if they’ve paid their fees or not
...
They can also see if the students are meeting their
targets with their work
...

Registers – Spreadsheets can keep track of students’ attendance – spreadsheets can also
organise the students’ names and lectures they can determine whether they’re present or
absent
...
csv” file in order to make it portable
...
csv
file can now be opened and read in many various software programs & the data
can be read and used in programming
...




---