 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
 |
|
||||||||||||||||||
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
||||||||||
Building a Simple Database
Building an online database can be as easy or complicated as you want to make it. Microsoft Office provides two programs which can be used for creating databases (Excel and Access). Beyond MS Office, other, more advanced programs exist for creating and maintaining databases. For the purposes of this course, we will focus on creating a simple database using MS Excel.
Example of an Excel Database for Social Studies:
Gathering Data
Once you have chosen a topic to build a database on (ex: population
of Africans transported to the Americas during the Slave trade),
you need to use the Internet to find data on your topic.
Importing Data into Excel
Now that you have the data, you want to enter it into your Excel spreadsheet,
in a easily categorized manner.
Filtering
Select for top cells for the columns of data you have created, then
click on Data in the Menu Bar, select Filter and then click on AutoFilter.
You have now turned the spreadsheet into a database.
Saving the Database
Go the File on the Menu Bar, select Save As… and then change
the format to XML Spreadsheet.
Project #6 – Creating
a Database
Working in a group of 5-6 people, create a database on a topic of your
choice and post a copy of it on the Database web page of your digital
portfolio.