Developing a database application on the Internet

This assignment illustrates the power and simplicity of building an application using an Internet service.

I created two simple roster applications. I programmed one by hand and built the second using Zoho Creator, an Internet database service.

Add your name and email address to the hand-programmed roster:
http://sws.csudh.edu/lpress/rosterfixed/roster_view.asp

If you have not already done so, add your name and email address to Zoho Creator roster:
https://creator.zoho.com/lpress/copy-of-cis275-roster1/#View:CIS275_with_blog

Print both roster listings with your name on them.

Play around with both applications until you see how they work. For example, delete and re-add your record from both rosters. Sort the Zoho Creator roster. Filter out some records from it.

1. Both are class roster applications, but they are not identical. What are two differences between the two applications?

2. Which roster application is most useful and flexible? (Explain your answer).

Turn in your answers to these questions along with the printouts showing your entry in both rosters.

Link to topic module

Create a simple survey form

This assignment will give you practice with the mechanics of creating a simple form and start you thinking about survey design.

Google Docs has several modules, word processing, spreadsheet, presentation and forms.

Go to docs.google.com and create a new form like this one:

Make the field names and help text the same as mine. Note also that all four questions are required.

When your form is exactly like mine, get three friends to complete it.

The results of a form-based survey are presented in a Google Docs spreadsheet like this one:

(I only completed one form, so there is only one row).

Note that when you are looking at the spreadsheet view of your survey, you can go back to the form by clicking on the form menu (red arrow).

Turn in a printout showing your form and the spreadsheet view with three or more responses.

Link to topic module

Best class database

The purpose of this assignment is to give you experience using a shared database for collaboration. You will also create a useful resource to share with your fellow students.

What is the best class you have taken at CSUDH? Think a while before you answer, then enter a description of the class (in your own words) and your reason for choosing it in this database.

We will share this with other students, so do not be careless. Follow our tips for writing short documents, and make your contribution something you are proud of.

When you are satisfied, print a listing of the database, highlight your answer, and turn it in. Also state the name of the classmate who reviewed it and gave you feedback.

This is a companion assignment to one in which you update a best classes wiki page. You will use the same content for both assignments.

While you are working on it, think about the pros and cons of collaboration using a wiki and using a database.

Link to topic module