Technology Applications Core · 3 min read
File Types, Formats, and Software Tools
Document Formats
Plain text files (.txt) contain unformatted character data using ASCII or Unicode encoding. These files are universally readable but lack formatting capabilities.
Rich Text Format (.rtf) supports basic formatting including fonts, styles, and colors while maintaining cross-platform compatibility. RTF files are larger than plain text but smaller than proprietary formats.
Microsoft Word documents (.docx) use Office Open XML format, a compressed collection of XML files. This format supports advanced features including styles, tables, images, headers, footers, and track changes.
Portable Document Format (.pdf) preserves exact document appearance across different systems. PDFs can contain text, images, forms, and multimedia. They support security features including encryption and digital signatures.
Spreadsheet and Database Formats
Microsoft Excel files (.xlsx) store tabular data with formulas, formatting, and charts. Workbooks contain multiple worksheets, each with rows and columns forming cells.
Comma-Separated Values (.csv) files store tabular data as plain text with values separated by commas. CSV files provide simple data exchange between different applications but lack formatting and formula support.
Database files store structured data in tables with defined relationships. Common formats include Microsoft Access (.accdb), SQLite (.db), and various proprietary formats. Databases support queries, forms, and reports for data management.
Image Formats
JPEG (Joint Photographic Experts Group) uses lossy compression optimized for photographs. Compression level balances file size against image quality. JPEG does not support transparency.
PNG (Portable Network Graphics) uses lossless compression preserving all image data. PNG supports transparency through alpha channels, making it ideal for graphics with variable opacity.
GIF (Graphics Interchange Format) supports animation and simple transparency but limits colors to 256. GIF works well for simple graphics and short animations.
SVG (Scalable Vector Graphics) stores images as mathematical descriptions rather than pixels. Vector graphics scale without quality loss, making SVG ideal for logos, icons, and illustrations.
BMP (Bitmap) stores uncompressed pixel data, resulting in large files but perfect quality. TIFF (Tagged Image File Format) supports various compression methods and multiple pages, commonly used in professional publishing.
RAW formats store unprocessed sensor data from digital cameras, providing maximum editing flexibility. Different manufacturers use proprietary RAW formats.
Audio and Video Formats
MP3 uses lossy compression to reduce audio file sizes while maintaining acceptable quality. Bit rate (kbps) indicates quality level, with higher rates producing better sound.
WAV stores uncompressed audio data, preserving perfect quality but requiring significant storage. WAV files are commonly used for professional audio production.
AAC (Advanced Audio Coding) provides better quality than MP3 at equivalent bit rates. AAC is the standard audio format for iTunes and YouTube.
FLAC (Free Lossless Audio Codec) compresses audio without quality loss, reducing file sizes while preserving original data.
MP4 serves as a container format for video, audio, and subtitles. MP4 typically uses H.264 or H.265 video compression with AAC audio.
AVI (Audio Video Interleave) is an older container format supporting various codecs. MOV is Apple's QuickTime format with similar capabilities.
WebM provides open-source video compression optimized for web delivery. MKV (Matroska) is a flexible container supporting multiple audio tracks and subtitles.
Compression and Archive Formats
ZIP creates compressed archives containing multiple files and folders. ZIP uses lossless compression, allowing perfect reconstruction of original data.
RAR provides higher compression ratios than ZIP and supports archive spanning across multiple files. 7Z offers even better compression using the LZMA algorithm.
TAR (Tape Archive) bundles files without compression, commonly combined with GZIP (.tar.gz) for compressed archives on Unix systems.
Software Tools for Education
Word processors support document creation with formatting, spell checking, and collaboration features. Common options include Microsoft Word, Google Docs, and LibreOffice Writer.
Spreadsheet applications handle numerical data, calculations, and visualizations. Microsoft Excel, Google Sheets, and LibreOffice Calc provide similar functionality.
Presentation software creates slideshows for instruction and communication. Microsoft PowerPoint, Google Slides, and LibreOffice Impress are widely used options.
Learning Management Systems (LMS) organize course content, assignments, and grades. Canvas, Blackboard, Moodle, and Google Classroom are common platforms.
Coding environments support programming instruction. Block-based tools like Scratch introduce concepts visually. Text-based IDEs like Visual Studio Code, Eclipse, and PyCharm support professional development.
Collaboration tools enable group work and communication. Video conferencing through Zoom, Teams, or Meet supports remote instruction. Shared documents and real-time editing facilitate collaborative projects.
Finished reading?
Lock it in with a quick Technology Applications Core quiz.