Spreadsheet For School Records

 Benefits of spreadsheets
🔵The amount of learning required by the principal to use spreadsheets is not as
much as that for databases ...
🔵it’s easier to use spreadsheets and get solutions straight away
🔵Spreadsheets are easier to use to store student data/perform numerical
calculations on exam scores/format cells/adjust layouts to generate output
and reports
🔵Easier to create complex formulae such as exam scores per teaching group in
spreadsheets
🔵Easier to use functions to calculate average exam scores in spreadsheet
🔵Repeated data such as names or classes can be easier to enter using spreadsheet software
🔵Charts to show student progress are easier to produce using spreadsheets



Drawbacks of spreadsheets
🔴As work gets more complex, such as an increase in the number of students,
spreadsheets become more difficult to change and manage
🔴Spreadsheets are good for creating one-time analysis such as exam scores
for one year, but become problematic as the data grows and evolves over
time
🔴As new rows and columns are added for extra scores and students, ranges
and formulas may need to be modified or new ones created