Detailed · Deep study
1Managing files
- Locate stored files using the file manager or the open dialogue, or search by name.
- Open and import files: e.g. import a .csv file into a spreadsheet or database, or a .txt file into a word processor.
- Save files in a planned hierarchical directory/folder structure, so files are easy to find and back up.
- Use appropriate file names that describe the content (e.g. Task2_Poster_v1), not "Document1".
- Save and print in a variety of formats: a document, screenshots (evidence), database reports, data tables, graphs/charts, a web page in browser view and in HTML view (the code).
| Application package formats | Generic formats |
|---|---|
| .docx, .doc (word processor); .xlsx, .xls (spreadsheet); .accdb (database); .pptx, .ppt (presentation); .sdb, .sdc, .odb (other office suites); .rtf | .csv, .txt, .rtf, .pdf, .css, .htm, .jpg, .png |
| keep all the features of the software (formulae, macros, layouts); may only open in that software or version | can be opened by many different programs on different computers; some formatting may be lost |
2File formats
| Format | Characteristics and uses |
|---|---|
| .css | cascading stylesheet – the styles for web pages |
| .csv | comma separated values – plain-text table data, one record per line; opens in any spreadsheet or database |
| .gif | image with up to 256 colours; supports animation and transparency; small files for simple graphics and logos |
| .htm/.html | hypertext markup language – a web page, opened by any browser |
| .jpg/.jpeg | compressed photographic images (lossy); small files, millions of colours |
| portable document format – keeps the exact layout on any device; hard to edit; good for sharing and printing | |
| .png | compressed images without losing quality (lossless); supports transparency; good for screenshots and logos |
| .rtf | rich text format – text with basic formatting, opened by most word processors |
| .txt | plain text with no formatting, opened by any text editor |
| .zip / .rar | compressed archives holding one or more files in a smaller size |
Generic file formats are needed so that files can be opened by different software, on different operating systems and devices, without the user owning the original application – e.g. sending a .pdf to a client, or exporting data as .csv to move it between a database and a spreadsheet.
3Exam focus
Key words: hierarchical folder structure; file name; import; export; application format; generic format; csv; rtf; pdf; png; jpg; gif.
Quick self-check
Answer in your head first, then reveal.
So files can be opened by different software/computers (1) without needing the original application (1).
Transferring data between a database and a spreadsheet (1).
jpg is lossy compression for photos; png is lossless/supports transparency (1).
