using excel for keeping student records
DESCRIPTION
USING EXCEL FOR KEEPING STUDENT RECORDS. WHAT THIS PRESENTATION COVERS. What Excel looks like Cells, rows and columns Renaming sheets Minimising the ribbon Copying and pasting content Sorting content Keeping records Formulas for adding, % and grades Other types of cell content. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/1.jpg)
USING EXCEL FOR KEEPING STUDENT RECORDS
![Page 2: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/2.jpg)
WHAT THIS PRESENTATION COVERS
What Excel looks like Cells, rows and columns Renaming sheets Minimising the ribbon Copying and pasting content Sorting content Keeping records Formulas for adding, % and grades Other types of cell content
![Page 3: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/3.jpg)
WHAT EXCEL LOOKS LIKE
![Page 4: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/4.jpg)
ROWS – DENOTED BY A NUMBER
This is Row 7
![Page 5: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/5.jpg)
COLUMNS - DENOTED BY A LETTER
This is Column D
![Page 6: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/6.jpg)
INDIVIDUAL CELLS - DENOTED BY LETTER AND NUMBER, EG, J8
Eg, this cell is called J8. Both the row and the
column are highlighted at the sides
Cell Name
![Page 7: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/7.jpg)
SHEETS
A new file will have three pages, called
Sheet1, Sheet2, Sheet 3.
You can rename them, move them
add them and delete them.
![Page 8: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/8.jpg)
CHANGE THE NAME OF A SHEET
Right-click on the sheet name and
select Rename. Type
in a new name.
![Page 9: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/9.jpg)
MINIMISE THE RIBBON
If the “ribbon” with all the tools takes up too much
space, right–click anywhere on it, then click on “Minimise the Ribbon” in the box that
appears
The Ribbon
![Page 10: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/10.jpg)
INSERT A NEW ROW
...then click Insert
Select the row directly beneath where you
want to insert a new row ...
![Page 11: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/11.jpg)
A NEW ROW WILL APPEAR ABOVE THE ONE YOU SELECTED
![Page 12: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/12.jpg)
INSERT A NEW COLUMN
Select the column directly to the right of
where you want to insert a new column...
...then click Insert
![Page 13: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/13.jpg)
A NEW COLUMN APPEARS TO THE LEFT
![Page 14: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/14.jpg)
ENTER CONTENT INTO A CELL
You can click on a cell and type content straight into
it...
...or you can click on a cell then type (or
edit) its content up
here
![Page 15: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/15.jpg)
COPY CONTENTS OF A CELL
First, click on the cell you want to copy, or drag-select multiple cells to copy them...
...Secondly, click the little double page symbol here on the Home tab
Or Control + COr Right-click and choose copy
The cells to be copied will become surrounded by a dotted line.
![Page 16: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/16.jpg)
PASTE CONTENT INTO NEW CELLS
First, click on the cell you want to paste into, or drag-select multiple cells to paste multiple
times into them...
...Secondly, click the clipboard symbol here on the Home tab
Or Control + VOr Right-click and choose Paste
![Page 17: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/17.jpg)
AUTO-COMPLETE
Type the first few letters and Excel will sometimes attempt
to auto-complete the word, based on words you have
already entered. To reject the
suggestion, press Backspace.
![Page 18: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/18.jpg)
SORTING DATA
Drag-select the content you want to re-order, eg by
House. Only the data you
actively select will be moved.
![Page 19: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/19.jpg)
...then Click “ Sort”
Click on the “Data” tab...
![Page 20: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/20.jpg)
IMPORTANT!If your
columns have headings,
(called headers) tick
this box first...
Secondly, drop this list down
and select the
header you want
to sort by, eg,
House...
...lastly click OK
![Page 21: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/21.jpg)
Note that the names are now in House
order
![Page 22: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/22.jpg)
We could have sorted them into year-level
order within the House as well. Let’s go
back...
![Page 23: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/23.jpg)
Control + Z to undo a move.List reversed
to alphabetical order...
Click “Sort”
![Page 24: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/24.jpg)
Add an extra level of sorting
here
As well as House as the
first level, select Class as the second level
You can add as many levels of sorting as you
wish .
![Page 25: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/25.jpg)
Note the students are now
sorted into House and then
Class. Q: What would
we see if we had sorted by Class then by House?
![Page 26: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/26.jpg)
ANSWERNow the year
10s appear first in House order, then the Year 11s in House
order
![Page 27: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/27.jpg)
PEDAGOGICAL ALERT!!
The following examples of record keeping are very simplistic!
They are intended for the purposes of demonstrating Excel only
They do not constitute Best Practice in assessment techniques and may not be VELS compliant!
These techniques should be adapted to your individual classroom situation
![Page 28: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/28.jpg)
KEEPING SIMPLE RECORDS
Enter a name for the task
![Page 29: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/29.jpg)
SPACE SAVING WITH VERTICAL TEXT
On the Alignment tab under Home, choose the angled “ab” for
orientation.Select “Rotate Text Up”
![Page 30: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/30.jpg)
CHANGING COLUMN WIDTH
You can drag the column narrower or use Format
![Page 31: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/31.jpg)
![Page 32: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/32.jpg)
ENTER STUDENT RESULTS
You could also sort students
by their results
![Page 33: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/33.jpg)
TOTALLING NUMERICAL RESULTS
Numerical results for some sample criteria
for an essay have been entered for
each student First student’s total will go here
![Page 34: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/34.jpg)
SELECT ALL CELLS INCLUDING TOTAL
... secondly, click the E-like symbol (Greek Sigma, standing for Sum) on the
Editing section of the Home tab.The Total will appear in the free cell.
First drag-select all cells including the
empty TOTAL cell ...
![Page 35: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/35.jpg)
=SUM(G2:I2) is the formula that Excel creates for the total in J2.
This means you have added the contents of cells G2, H2 and I2.
Note: •The EQUALS sign at the start
•The brackets•The colon
![Page 36: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/36.jpg)
COPY THE FORMULA DOWN THE COLUMN
First, dra
g
dow
n....
... Secondly, drop down the arrow box and choose Down
![Page 37: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/37.jpg)
THE TOTALS FILL DOWN THE COLUMN
![Page 38: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/38.jpg)
COMBINING RESULTSHere are results for three projects:
an Essay, an Oral Report and a Model. The darker columns are the
individual totals. We want an overall total.
Overall total
will go here
![Page 39: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/39.jpg)
Add these totals to get the overall total
=SUM(J2,N2,R2)is the formula for the sum total of cells J2, N2 and R2
OV
ER
A
LL
TO
TA
L
![Page 40: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/40.jpg)
FILL DOWN THE COLUMN AS BEFORE
![Page 41: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/41.jpg)
The Overall Totals
have filled down the column
![Page 42: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/42.jpg)
TURNING SCORES INTO %
For a percentage, the formula in this
example is
=S2* 100/40.This means cell S2
times 100 divided by the total possible,
which was 40 marks
![Page 43: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/43.jpg)
FILL DOWN AS BEFORE
![Page 44: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/44.jpg)
GRADES FORMULA MARKING SCHEMEGreater than 35 A
From 31 to 35 B
From 26 to 30 C
From 21 to 25 D
Less than 21 E
![Page 45: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/45.jpg)
GRADES FORMULA IS COMPLEX!
=IF(S2>35,"A",IF(S2>30,"B", IF(S2>25,"C",IF(S2>20,"D","E"))))
MEANING
IF(S2>20,"D" , “E“)
This means if the score in cell S2 is greater than 20, the grade is D, otherwise it’s an E
However...
IF(S2>25, "C"
...if the score is also greater than 25, the grade goes up to a C
However...
IF(S2>30, "B"
...if the score is also greater than 30, the grade goes up to a B
However...
IF(S2>35, "A"
...if the score is also greater than 35, the grade goes up to an A
![Page 46: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/46.jpg)
ONCE YOU WORK IT OUT, FILL DOWN
![Page 47: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/47.jpg)
OTHER TYPES OF CONTENT
![Page 48: USING EXCEL FOR KEEPING STUDENT RECORDS](https://reader036.vdocuments.us/reader036/viewer/2022062422/56813654550346895d9ddc01/html5/thumbnails/48.jpg)
NOW YOU CAN EXCEL AT EXCEL!