Data notes · Data management

🗂️ 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.