📚 Data Management Study Notes
🗂️ Purpose of Data Organisation
- Efficiency: Quick and easy access, retrieval, and processing, saving time and resources.
- Accuracy and Consistency: Minimizes errors, inconsistencies, and redundancy.
- Meaningful Insights: Facilitates easy analysis to reveal trends and insights.
- Collaboration and Sharing: Improves understandability and ease of sharing.
- Compliance and Security: Easier implementation of security measures and regulatory compliance.
🎨 Common File Formats for Graphics and Audio
🖼️ Graphics
- Raster Graphics:
- .jpg/.jpeg: Compressed, common for photographs.
- .png: Lossless compression, supports transparency.
- GIF (.gif): Simple animations, limited colors, lossless compression.
- Vector Graphics:
- SVG (.svg): XML-based, scalable, great for web use.
- AI (.ai): Adobe Illustrator format, professional vector graphics.
🎧 Audio
- MP3 (.mp3): Compressed, smaller size, widely compatible.
- AAC (.aac): Improved quality over MP3, commonly used by Apple.
- WAV (.wav): Uncompressed, high-quality audio, large files.
- FLAC (.flac): Compressed but lossless, retains original audio quality.
Movie
- MP4 (.mp4): Highly compatible, compressed video with good quality.
- AVI (.avi): High-quality video, large file size, common in Windows.
- MKV (.mkv): Supports high-quality video, subtitles, and multiple audio tracks.
- MOV (.mov): High-quality format commonly used by Apple devices.
Documents
- DOCX (.docx): Standard Microsoft Word format ideal for creating formatted text documents with images and rich styling.
- XLSX (.xlsx): Microsoft Excel format for spreadsheets, perfect for data analysis, formulas, and charts.
- PPTX (.pptx): Microsoft PowerPoint format designed for presentations, incorporating multimedia and transitions.
- TXT (.txt): Plain text file containing unformatted text, lightweight and universally compatible.
🔄 Purpose and Strategies for Managing Software Updates
- Purpose: Security, bug fixes, new features, compatibility.
- Strategies: Automatic updates, regular backups, review release notes.
📄 Types of Software Licenses
- Open Source: Free to use, modify, distribute.
- Closed Source: Source code not publicly available, limited rights.
- Shareware: Free initial trial, payment required later.
- Freeware: Completely free to use without charge, but limited usage rights.
- Proprietry: Paid Software or Subscription
📐 Designing Effective Spreadsheets
- Clearly labelled rows and columns
- Consistent formatting (fonts, colors, number formats)
- Logical data arrangement
- Strategic use of formulas
- Data visualization (charts, graphs)
- Accessibility considerations
🔍 Organising Data with Sort and Filter
- Sorting: Arrange data based on values (ascending or descending).
- Filtering: Display only specific subsets of data.
- Combined Use: Filter first, then sort for refined analysis.
Best Practices: Always select entire datasets when sorting; use combined sort/filter functions for deeper insights.