file formats Flashcards
what do file formats affect
accessibility, quality, compatibility
common file formats
- documents
- PDF files
- spreadsheets
- flat file databases
- relational databases
- presentation software
- audio files
- image files
- video files
file format considerations
- compatibility: software + hardware
- purpose
- quality
- file size
- accessibility
documents
text files edited using word processing software
- education, business, personal life
- docx, doc, pages
- lossless
documents stats
- adv: real-time share + collaboration, easy conversion
- disadv: limited formatting, large file size(if images + multi-media content), limited multi-media
- Microsoft word, google docs
PDF files
sharing documents + maintain consistent layout and formatting regardless of device/software
- adobe acrobat, microsoft word, google docs
- lossless
PDF stats
- adv: universal compatibility, security features, layout/formatting preservation
- disadv: hard to edit w/out proper software, large file sizes, multi-media limited(text-based)
- adobe acrobat, preview(built-in on mac)
spreadsheets
stores + manipulates + visualizes data in tables, w/ column and row format
- financial analysis, budgeting, project management
- .xlsx(microsoft excel), .gsheet, .numbers(apple numbers)
- lossless
spreadsheets stats
- adv: easy data organization + calculation, performs complex calculations + analysis, graphs + visualization
- disadv: difficult for beginners, limited formatting compared to word processing software, limited multi-media
- microsoft excel, google sheets
flat file databases
stores simple format, records separated by delimiter
- small-scale applications like simple inventory systems
- .csv(comma-separated), .tsv(tab-separated), .json, .accdb
relational databases
structured organization of data in tables w/ relationships between them
- large-scale apps like customer relationship management + online stores
- MySQL, Oracle, Microsoft SQL
database stats
- adv: can organize + manage large amounts of data efficiently
- dis: limited formatting options
- sql, csv, xml, json
presentation software
allows users to create visually appealing + interactive presentations
- education, business, personal life
- .pptx, .odp
presentation stats
- adv: creative of visually appealing + interactive presents, includes multimedia, animations + transitions for visual interest
- dis: overused/badly used, limited collaboration features, time consuming to create + edit
- Microsoft PowerPoint, Google Slides
audio files
stores sound recordings
- entertainment, education, personal life
- raw: lossless
- mp3: lossy
audio files stats
- adv: portable + easy to share, variety of purposes, listened to on various devices/platforms
- dis: limited audience, limited interactivity, large file sized: difficult to share + store
- MP3, WAV, AIFF
image files
stores visual information
- art, design, advertising, personal life
- png: lossless
- jpeg: lossy
image stats
- adv: provides visual information for various purposes
- dis: large file sizes
- jpeg, png, gif, bmp
video files
stores moving images
- entertainment, education, personal life
- mp4: lossy
- wmv: lossless
video stats
- adv: engaging + immersive content
- dis: large file sizes; high quality hard to store + share
- MP4, AVI, MOV, WMV, FLV
