Information Management Part 2

Information Management​ Part 2

Unit 13.4 and beyond

​Unit 13.4 - Spreadsheets and Databases

​They're very similar but...

• ​Spreadsheets can be used to:

  • manipulate and organise raw data before putting it in a database.

  • ​predict trends (act as a modelling tool)

  • ​do math

  • ​display data

  • ​define and refine data

• ​Databases can be used to:

  • ​Do whatever the spreadsheeet can do but can handle MORE data

​

​Databases BETTER analyse and connect data than spreadsheets and are designed to do it more easily.

Multiple Choice

What is the main difference between a database and a spreadsheet?

• Databases can do exactly what a spreadsheet can, but with more data and much faster.

• Spreadsheets can do exactly what a database can, but with more data and much faster

• They do exactly the same thing with no differences what so ever

• Databases only handle tables and spreadsheets can work with numbers.

Multiple Select

When will you use a database rather than a spreadsheet?

• For small amounts of data.

• For when you don't want data to be connected.

• For large amounts of data.

• To connect data more easily.

​Unit 13.5: Processing Data

• ​Need to analyse data to find more relevant information

• ​Manipulating data = process of sorting, arranging or moving data.

• ​When manipulating:

  • ​Need to know how to use programs.

  • ​Might need more than one program.

  • ​Use sorting, formulae, functions and queries.

  • ​Video reminder on how to sort stuff in Excel: https://youtu.be/Ep5q1cUhQas

​Extracting Appropriate Information

• Use various tools and commands to extract information.

• Difference in extraction between Excel and Access?​

  • ​Excel would need us to use filters to extract specific information

  • ​Access can do the same thing with one query

​Unit 13.6 - Analysing data and information

​Need to analyse results and compare them to your focus question.

​

Best way to support or disprove your question is to look at trends and patterns.

​

​We do this by adding data questions and looking for those trends and patterns presented in the answers.

​

​Examples of data questions: How many? What is most popular? What is least common? How many more than? What is the average?

​Trends and Patterns!

• ​Final step!

• ​Trends = general tendency to move in one direction

  • ​Downward trend

  • ​Correlation trend

• ​Pattern = repeat itself in a predictable way or form a shape

  • ​Centred

  • ​Spread

  • ​Shaped

Multiple Choice

Data handling can be used to do which of the following?

• Collect information

• Organise data

• Sort information

• Analyse data

Multiple Choice

Which of the following is the last step of the information management process?

• Presenting information

• Collecting data

• Processing a database

• Analysing results

Poll

When evaluating a website, which of the following questions must NOT be asked?

• Who supports this website?

• Who is this website aimed at?

• Which year was the website established?

• Who is the author?