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
-
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):
- How to create a database.
- Save and rename a table.
- Generate records and fields to Fill a table.
- Generate a form.
You are going to be able to define:
- Data record (database).
- Data field (database).
- 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:
-
Create a restaurant´s database “restaurant_lastname_firstname”.
-
Generate a table named: “products”.
-
Include in the table the following fields according to “Table 2”:
-
Generate a Form named: "Create Products"
-
Devise and register 10 meals.
-
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:
- Share with us an example of the data that you consider relevant to be recollected in your selected profession.
- Make a table with at least 5 data fields.
- Make a form and generate 10 data records with it.
- 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