Spreadsheets and Databases in Data Handling (Grade 11 NSC Matric Computer Application Technology): Flashcards
📚Flashcards
Practise the cards
10 cards from this deck
ShowHide
Practise the cards
10 cards from this deck
Definition of spreadsheets
Definition of spreadsheets
Digital worksheets in grid format with numbered rows & lettered cols
4 examples of spreadsheet applications
4 examples of spreadsheet applications
Excel, Google Sheets, LibreOffice Calc, iWork Numbers
Main strength of spreadsheets
Main strength of spreadsheets
Manipulate and organise raw data before moving to databases
Mathematical operations spreadsheets perform
Mathematical operations spreadsheets perform
Totals, averages, percentages - saves time & reduces errors
Visual data representation in spreadsheets
Visual data representation in spreadsheets
Charts and graphs that help spot patterns and trends
Key characteristic of databases vs spreadsheets
Key characteristic of databases vs spreadsheets
Handle much larger amounts of info, run on powerful servers
Database advantage: data capacity
Database advantage: data capacity
Store & process enormous data without performance issues
Database advantage: processing power
Database advantage: processing power
Use server resources for complex calculations faster
CSV format purpose
CSV format purpose
Comma separated values - enables easy data transfer between systems
When databases become essential (data volume)
When databases become essential (data volume)
Over 100,000 rows or complex data relationships