Making a Spreadsheet for a Teacher's Grades and Attendance
My friend’s class teacher named Dave has to take a register every day
and has to keep marks that students have achieved on a regular basis.
Dave finds it very hard to keep all his papers organised, as they tend
to overflow and get messy. Because of this it can be an agonising
process trying to find a students set of results or attendance marks
when they are needed. He recently received a new computer from his Dad
as a present. My friends wants me to create a computerised spreadsheet
for him whereby he could keep attendance of pupils and their grades
and also create graphs out of the information to simplify it.
The more primitive way to solve this problem would be to create a more
organised and effective manual system, like a folder with various
sections in it to identify different pupils and grades that they have.
However it is not the ideal way of solving this certain problem as it
may prove to be just like his previous method. Another way by which
the problem could be solved would be to create a spreadsheet system.
The types of software packages I am considering for the use of this
project are as follows: Database, DTP, Word Processing and Spreadsheet
Each piece of software has its downsides and its positives.
Spreadsheets are one of the best programs for storing information, it
has fields in the row and column format and they can do calculations
of the sum, max, formulae type and etc. This is everything I will need
for the Dave’s situation and therefore I have decided to use this type
of program for my system.
Word Processing packages such as Microsoft Word are ma...
... middle of paper ...
... the user. I sent an
E-mail to Dave asking him what he thought of the spreadsheet and if it
worked better then his manual system. I asked him to send me his reply
and it said:
“Thanks kid, that new spreadsheet thing works wonder, when I get the
hang of this ill use it in the future because it saves me a lot of
time”
The improvements and extensions that I could have made to the
coursework would have been to have made a printable version of the
spreadsheet so that the teacher could use it in his folder if he was
not used to his new computer.
After reading the letter from Dave I have decided that numerous
spreadsheets should be used all around for a much easier way of doing
things efficiently and I believe that I have learnt a substantial
amount in this project and I hope to use those skills in the future.