Data analysis

---

Data analysis is a lot about spreadsheets and how they can be used to create a data model. Also how these models can be tested. Once a model has been created, the results from the model can be extracted and presented in a suitable way. For example you can summarize the results of the model or present the results of the model as a graph or a chart.


What is a data model?
A data model is used to mimic a real situation. For example, a data model can be created using a spreadsheet software. Data models can be used to provide answers to questions such as "What would happen if I did this?"

Creating a data model
In the examination you will be required to produce or adapt a computer model using the spreadsheet skills learnt during the IGCSE course.

Operator	What it does
+	Add
-	Subtract
*	Multiply
/	Divide

Lessons

currencies_CSV_file.csv

• Details
• Download
• 1 KB

database_of_employees.xls

• Details
• Download
• 31 KB

dubai_weather_table.xls

• Details
• Download
• 25 KB

table_showing_fat_and_protein.doc

• Details
• Download
• 30 KB

Activities


Modelling with spreadsheets

Bitesize

Glossary

1. data Values, typically letters or numbers.
2. font Style applied to text, eg Times New Roman, Arial, Verdana are all types of font.
3. formula A simple piece of arithmetic you type into a spreadsheet to perform a calculation. The plural of 'formula' is 'formulae'.
4. graphic A visual image displayed on screen or stored as data.
5. information Data that has meaning, not just a number or a letter.
6. software The programs, applications and data in a computer system. Any parts of a computer system that aren't physical.
7. spreadsheet A piece of software used to manipulate data, often used in modelling.