TIC II

Innovation and creativity workshop

PyME(SMEs)

Session 7

Professor: Oscar Alonso Rosete Beas

Previous session

  • SCAMPER tool

  • Attribute Listing

  • What would (x) do?

  • Business model canvas

  • Test

Agenda

 

  • Data Innovation

    • Databases in Microsoft Access

Product Innovation

Process Innovation

Lean manufacturing, total quality management, six sigma

Data intelligence

TIMWOOD

Innovation through data intelligence

Data​

Things known or assumed as facts, making the basis of reasoning or calculation.

The quantities, characters, or symbols on which operations are performed by a compute

Innovation through data intelligence

  1. A database is a collection of interrelated data, stored on computers with the final goal of serving one or more applications in the most efficient manner.

Where do we find databases?

Brief introduction to databases

Innovation through data intelligence

Walkthrough excercise with professor (Classroom´s agenda):

  1. How to create a database.
  2. Save and rename a table.
  3. Generate records and fields to Fill a table.
  4. Generate a form.

You are going to be able to define:

  1. Data record (database).
  2. Data field (database).
  3. Table (database).

Innovation through data intelligence

Add the following fields:

  • Preferred College
  • Expected Income per month

Fill 5 records with information of your classmates

Innovation through data intelligence

Innovation through data intelligence

Upload your database to classroom´s activity

  • Add all of the fields to the Form.
  • Fill 5 records with additional information from your classmates.

Innovation through data intelligence (Student activity #1)

On a Microsoft Access document:

  1. Create a restaurant´s database  “restaurant_lastname_firstname”.

  2. Generate a table named: “products”.

  3. Include in the table the following fields according to “Table 2”:

  4. Generate a Form named: "Create Products"

  5. Devise and register 10 meals.

  6. Upload your second database to classroom´s activity

Innovation through data intelligence (Student activity #1)

Table 2

Field name Meal's name Description Price Rating
Data type Short Text Short Text Number Number
Field description Meal's name Meal's description Meal's price Meal's rating

Innovation through data intelligence (Student activity #2)

On a Microsoft Access document:

  1. Share with us an example of the data that you consider relevant to be recollected in your selected profession.
  2. Make a table with at least 5 data fields.
  3. Make a form and generate 10 data records with it.
  4. Personalize your form (Insert images, change font type, change colores, etc)

Upload your second database to classroom´s activity

TICS Session 7

By oscaralonso11

TICS Session 7

  • 223