Definition of spreadsheets

1
Spreadsheets

• Definition of spreadsheets
• Features and capabilities of spreadsheet
• Advantages of using spreadsheets
• Using spreadsheets in the classroom
• Teaching students to use spreadsheets

2
Spreadsheets

• Definition of spreadsheets
• A spreadsheet is a table, grid or matrix of data
  that shows data in rows and columns and used to
  perform a wide variety of simple to complex
  calculations.
• Definition of spreadsheets software
• A computer program that allows the user to enter
  text and numbers into a table with rows and
  columns, and then maintain and manipulate those
  numbers using the table structure.

3
Spreadsheets

• Features and capabilities of spreadsheets
• Calculations and comparisons
• Automatic recalculations
• Copying of cells
• Lining up information in columns
• Creation of graphs that correspond to data
• Creation of custom functions

4
Spreadsheets

• Advantages of using spreadsheets
• Saving timecalculate quickly, recalculate
  easily, update data faster
• Creating chartscreate different types of chars,
  chart wizard, chart prosperities
• Answering what if questions (problem-solving)vi
  sualize the impact of changes, recalculate
  changes, transform data
• Motivationplay with numbers, immediate feedback,
  explore the relationship between inputs and
  outputs

5
Spreadsheets

• Using spreadsheets in the classroom
• to create
• Score and record keeping
• Attendance charts
• Timetables
• Illustration of abstract concepts
• Graphical demonstration
• Problem-solving activities
• Sharing formulas and solutions

6
Spreadsheets

• Teaching students to use spreadsheets
• Format cells
• Develop formulas
• Visualize numerical data
• Automate calculations
• Exchange data

7
Databases

• Definition of databases
• Features and capabilities of databases
• Advantages of using databases
• Using databases in the classroom
• Teaching students to use databases

8
Databases

• Definition of databases
• A database is a system designed to store
  information in a way that makes it easy to locate
  later.
• Definition of database software
• Computer programs that allow users to store,
  organize, and manipulate information, including
  both text and numerical data.

9
Databases

• Features and capabilities of databases
• Allowing changes to information (not document)
• Sorting information alphabetically or numerically
• Searching for information
• Automatically creating reports or summaries
• Merging with word-processing documents

10
Databases

• Advantages of using databases
• Reducing data redundancymultiple location
  access, central database, customized reports
• Simplifying accessunique identifier, simple
  interface, accessible forms
• Saving time easily make changes, central access,
  anytime access
• Allowing comparisons of informationsearching
  data, filtering of data, sorting data
• Safeguarding privacy and securitysecure access,
  different levels of access, data backup

11
Databases

• Using databases in the classroom
• to
• Create Inventorying and locating instructional
  resources
• Supply teachers and students information
• Store and retrieve records
• Plan instruction and enhance learning
• Design research and study skills
• Enhance problem-solving and decision-making
  skills

12
Databases

• Teaching students to use databases
• Create a new database using Wizard
• Create new tables by entering data
• Create forms in design mode
• Understand the different between database
  components
• Export data to Word document
• Search and filter data