Scribd
Upload
166 views4 pages

Data Modelling

Data modeling is the visual representation of data and its relationships, aiding in data-driven decisions and analysis. It includes conceptual, logical, and physical models, with Excel serving as a powerful tool for organizing and analyzing data through features like tables, formulas, and pivot tables. A practical activity is provided for students to apply Excel functions to a dataset of student grades and attendance.

Uploaded by

sana.iqbal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
166 views4 pages

Data Modelling

Data modeling is the visual representation of data and its relationships, aiding in data-driven decisions and analysis. It includes conceptual, logical, and physical models, with Excel serving as a powerful tool for organizing and analyzing data through features like tables, formulas, and pivot tables. A practical activity is provided for students to apply Excel functions to a dataset of student grades and attendance.

Uploaded by

sana.iqbal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Introduction to Data Modeling

Definition: Data modeling is the process of creating


a visual representation of data and its relationships.
It helps organize and understand data.
Importance:
- Helps in making data-driven decisions.
- Simplifies complex data sets.
- Facilitates analysis and reporting.

Types of Data Models


Q​Conceptual Model: High-level view, focusing on
what data is needed.
Logical Model: Defines data elements and their
relationships without considering how they will be
implemented.
- Physical Model: Detailed model that includes
storing and accessing data.

Using Excel for Data Modeling


Overview of Excel: A powerful spreadsheet tool
that allows users to organize, analyze, and visualize
data.
Key Features in Excel:
-Tables: Organize data into rows and columns,
making it easier to manage.
- Formulas: Perform calculations (e.g., SUM,
AVERAGE) to analyze data.
- Charts: Visual representations of data (e.g., bar
charts, pie charts) to help identify trends and
patterns.
- Pivot Tables: Summarize large data sets and
analyze relationships between different variables.
Practical Activity
Student Name Subject Grade Attendance Last Exam
ID (%) Date

001 John Math 85 90 2023-04-15


Doe

002 Jane Science 78 85 2023-04-12


Smith

003 Sam English 92 95 2023-04-10


Brow
n

004 Lisa Math 88 80 2023-04-14


White

005 Mark Science 74 88 2023-04-13


Green

006 Emm English 91 92 2023-04-11


a
Black

007 Tom Math 76 75 2023-04-09


Adam
s
008 Ava Science 89 90 2023-04-08
Lee

Simplified Challenges for Students

●​ Search Function: Use the search function to find the grade of "Sam
Brown."
●​ Filter Data: Apply a filter to show only students who scored above 80.
●​ Sort Data: Sort the data alphabetically by student names.
●​ Count Attendance: Use the COUNT function to count how many
students have attendance above 85%.
●​ Find Maximum Grade: Use the MAX function to find the highest grade in
the dataset.

Instructions

●​ Enter the data into an Excel spreadsheet.


●​ Complete the challenges listed above to practice basic Excel functions
and features.

You might also like