List Five Conventions That Are Used In Spreadsheet Design

Submitted By Dionrogue

Words: 350

Pages: 2

Open Document

From Data to Information Part 5

Reference: Potts and Lawson (Eds), Information Technology, VCE Information Technology Units 1 & 2, 5th Edition Chapter 1 p3-40

Read the reference material, then answer the following questions.

1. What is the difference between a format and a convention?
Conventions are the standard ways of formatting data, A format are ways in which data and information can be presented. Such as Tables, graphs and sounds. The format has its own conventions, which specify the mandatory.

2. List five conventions that are used in spreadsheet design.
Money values, decimal points, text, dates and text font.

3. List five conventions that are used in graphic representations.
Graphs, charts, titles, legend, colors and unit of measurement.

4. Identify the conventions that have and have not been applied in the graphic representation in Figure 1-34 on page 40.
The graphic representation has a bar chart, a title and the chart is colored. It provides dates, and decimal points.
The graph however does not have a key/legend and a unit of measurement.

5. What are the characteristics of an effective solution?
An effective solution matches the users search for information. It provides an effective way of solving a problem and serves a purpose in order to solve information problems.

6. What is the difference between validation and testing?
Validation checks that data input in a computer system is appropriate and reasonable. Testing however is performed in order

Create An Actors Table

Date | Task Description | Done? | | Part A: Create the Actor and Bookings Tables | | | Actor Table | | 12/9/11 | • Import the data from Actor.xls to create an Actor Table. | | | • Select an appropriate key field for the Actor Table, ensuring this will be a unique value. | | | Bookings Table | | | • Import the data from Bookings.xls to create a Bookings Table. | | | • Select an appropriate key field for the Bookings Table, ensuring it will be a unique value | |…

Words 2192 - Pages 9

Mis Chapter 5 Essay

Chapter 5 1. For each of the 9 parts, Type up 1 paragraph on each article, including: (1)Data, data everywhere -The world contains a vast amount of digital information that can make it possible to do many things, the data should be managed well that can be used to new sources of economic value, provide fresh insights into science and hold governments to account. -The interesting part of this article that I found out is the business of information management is helping organizations to make…

Words 880 - Pages 4

Biology-Ecosystems Essay

PART A Question 1 (UB and IB) Complete the following table: Ecosystem Organism ABIOTIC FACTOR Measuring technique Adaptation to overcome factor BIOTIC FACTOR Measuring Technique Adaptation to overcome factor Rocky Shore Example Limpet eg temperature eg thermometer hide under rock crevices to prevent overheating eg competition against other species for food using a quadrat to measure distribution and abundance efficient algae scraping device called a radula that aids in feeding…

Words 1875 - Pages 8

Essay about Information and Software Technology Assessment: Networking Systems

Year 10 Information & Software Technology (IST)Assessment Task No. 2 (2013) – Networking Systems | Due Date | PART A – Task 1- Fri, 7th June (Week 6)Task 2 & 3 - Fri, 14th June (Week 7)Task 4- Fri, 21st June (Week 8)Task 5 – Fri, 19th July (Week 1, Term 3)Task 6 – Mon, 22nd July (Week 2, Term 3) | PART B – Your class presentationWill commence on Monday 22nd July (Week 2, Term 3). | Weighting | 25% of your IST Assessment | Student Names: ………………………………….………………………………………………………..Submission…

Words 3381 - Pages 14

Essay about English Lies

2010 Higher School Certificate Preliminary Mid-course Examination INFORMATION PROCESSES AND TECHNOLOGY Total Marks - 80 Directions to Candidates Time Allowed: Working time - TWO (2) hours Reading time - 5 minutes Write using blue or black ink Write your student number at the top of this page Section I (20 marks) Multiple Choice Attempt ALL questions 1-20 Allow approximately 30 minutes for this section. Mark your answers on the Multiple Choice Answer Sheet provided…

Words 2153 - Pages 9

Every Computer Consists Of The Following Basic Components?

OR presentation. 2. Research - what is a computer? 3. If you can remember what the different parts of the machine are from your lesson, then label them in your Prezi. 4. Explain what each part does . Try out this link to help you: http://tinyurl.com/y2uy4jm Week 2 Every computer Consists of the following basic components: Ÿ Ÿ Ÿ Ÿ Ÿ Ÿ Ÿ CPU RAM Motherboard Power Supply Hard Drive Disk Drives Data cables Task 2 1. Are there an more components (parts) that you can think of. 2. In your Prezi or…

Words 412 - Pages 2

Issues in design, implementation and evaluation of a Health IS Essay examples

What is HIS : HIS is an Information system to improve the efficiency and effectiveness of health and welfare services through the creation and use of information for clinical, administrative, and monitoring purposes. System Components of HIS : Data Collection, Data Transmission, Data Processing & Data Analysis Key points to consider when evaluating a HIS from 3 different perspectives 1 Core Functionality of the System 2 Technology Feasibility & Project Management 3 Commercial Factors (Investments…

Words 512 - Pages 3

Qnt351 Week 3 Team Assignment Essay

Data Collection BIMS, Ballard Integrated Managed Services, Inc. is a corporation specializes in the services of food and housekeeping to corporations and institutions. The general manager, Barbara Tucker, has noticed that over the last four months the turnover rate has shot up to 64%. Not only is the turnover rate higher than usual, but also employees seemed unmotivated to do their job. There are more employees walking around doing nothing and more employees not doing their job well enough, resulting…

Words 1811 - Pages 8

Cs 682 Assignment 1 Essay

------------------------------------------------- Contents 1. Introduction 2 2. Assignment Part 1 2 2.1 Management Information Systems - for WallGray’s pharmacy chain.(1) 2 2.1.1 Purpose 2 2.1.2 System Users 2 2.1.3 Inputs to the System 2 2.1.4 Outputs from the System 2 2.2 Decision Support Systems – for Home Depot (2) 2 2.2.1 Purpose 2 2.2.2 System Users 3 2.2.3 Inputs to the System 3 2.2.4 Outputs from the System 3 2.3 Executive Information Systems – for Wal-Mart (3) 3 2.3.1 Purpose 3…

Words 1358 - Pages 6

Analyse Fundamental Concepts To Extrapolate The Nature Of Information Systems And Their Role In Business

UNIT TITLE Information Systems UNIT CODE WDB1005 PRE-REQUISITES Nil CREDIT POINTS N/A MODE OF DELIVERY Off Shore LOCATION Onshore UNIT COORDINATOR Wendy Lyle Wendy.Lyle@vu.edu.au 99199228 OTHER TEACHING STAFF TBA DESCRIPTOR This unit of study introduces students to the nature and types of Information Systems and their importance to business processes. The unit provides an introduction to the principles that need to be applied in the development and application of effective Information Systems in…

Words 2393 - Pages 10