android studio (java) with SQLite browser & excel reporting

In this course we will learn how to create a new android studio project, create a SQLite database and generate 1000’s of records using Excel to simulate the app, and then we will insert all generated records into our app’s database.

The database is about a school
  * we have levels: Elementary School, Middle School, High school, University
  * we have grades: First grade, Second grade, Third grade, Fourth grade, Fifth grade, Sixth grade, Seventh grade, Eighth grade, Ninth       grade, Tenth grade, Eleventh grade, Twelfth grade, Freshman, Sophomore, Junior, Senior.
  * we have subjects: English, Math, Sciences, Physics
  * we have 600 students
  *we have 2400 tests

We are going to:

1. Create the android project

2. Create the activities

  o menu activity ( java & XML )

  o levels activity ( java & XML )

  o grades activity ( java & XML )

  o subjects activity ( java & XML )

  o students activity ( java & XML )

  o tests activity ( java & XML )

  o test’s result activity ( java & XML )

  o insert activity ( java & XML ), to insert the generated records

  o design of result ( XML )

3. Create the database using SQLite

  o Tables ( levels, grades, subjects, students, tests)

  o View

4. Generate 1000’s of records in excel to simulate the app

5. Insert the generated records into SQLite browser

6. Insert the generated records into app’s database

7. Request a permission to access the device storage

8. Download the test’s results to device storage as CSV files