file formats

Question 1

what do file formats affect

Answer 1

accessibility, quality, compatibility

Question 2

common file formats

Answer 2

• documents
• PDF files
• spreadsheets
• flat file databases
• relational databases
• presentation software
• audio files
• image files
• video files

Question 3

file format considerations

Answer 3

• compatibility: software + hardware
• purpose
• quality
• file size
• accessibility

Question 4

documents

Answer 4

text files edited using word processing software
- education, business, personal life
- docx, doc, pages
- lossless

Question 5

documents stats

Answer 5

• 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

Question 6

PDF files

Answer 6

sharing documents + maintain consistent layout and formatting regardless of device/software
- adobe acrobat, microsoft word, google docs
- lossless

Question 7

PDF stats

Answer 7

• 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)

Question 8

spreadsheets

Answer 8

stores + manipulates + visualizes data in tables, w/ column and row format
- financial analysis, budgeting, project management
- .xlsx(microsoft excel), .gsheet, .numbers(apple numbers)
- lossless

Question 9

spreadsheets stats

Answer 9

• 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

Question 10

flat file databases

Answer 10

stores simple format, records separated by delimiter
- small-scale applications like simple inventory systems
- .csv(comma-separated), .tsv(tab-separated), .json, .accdb

Question 11

relational databases

Answer 11

structured organization of data in tables w/ relationships between them
- large-scale apps like customer relationship management + online stores
- MySQL, Oracle, Microsoft SQL

Question 12

database stats

Answer 12

• adv: can organize + manage large amounts of data efficiently
• dis: limited formatting options
• sql, csv, xml, json

Question 13

presentation software

Answer 13

allows users to create visually appealing + interactive presentations
- education, business, personal life
- .pptx, .odp

Question 14

presentation stats

Answer 14

• 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

Question 15

audio files

Answer 15

stores sound recordings
- entertainment, education, personal life
- raw: lossless
- mp3: lossy

Question 16

audio files stats

Answer 16

• 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

Question 17

image files

Answer 17

stores visual information
- art, design, advertising, personal life
- png: lossless
- jpeg: lossy

Question 18

image stats

Answer 18

• adv: provides visual information for various purposes
• dis: large file sizes
• jpeg, png, gif, bmp

Question 19

video files

Answer 19

stores moving images
- entertainment, education, personal life
- mp4: lossy
- wmv: lossless

Question 20

video stats

Answer 20

• adv: engaging + immersive content
• dis: large file sizes; high quality hard to store + share
• MP4, AVI, MOV, WMV, FLV