Introduction Academic program in higher learning refers to the course of study which is a list of requirements a student must meet before he/she can graduate. Another term that is used in connection with a student information system is degree audit. Academic Program referred to here means the academic degree […]
Course Registration
At the moment, a staff member only manually register a student for one course at a time verses the student shopping cart in the student portal. Below is a screenshot of the course registration form. Enter the student’s ID in the first field and the student’s name will auto-populate below […]
Course Section
Course sections are created from active courses. Course sections can only be created by person’s who have permission. You can set proper permissions where schedulers can create course sections but only finance can activate them once course fees have been added. In keeping with the course format, course sections are […]
Course
Adding courses to the system is quite easy, but there are three things to consider when creating a course. One is course numbers. Course numbers are not unique. So if a course becomes out of date, it is best to set it to inactive, and add an end date. When you […]
Student Application
You can create a new student application for a prospective student by searching the prospect on the person screen. When the prospect is returned in the search, click the application button to create a new application (see figure 1). Once you get to the application screen you can enter […]
SQL Statement Structure
There are two types of SQL statements: DML (Data Manipulation Language) DDL (Data Definition Language) For generation SQL reports, we will be focusing on DML statements. We will first look at two keywords that make up a SQL statement: SELECT and FROM. SELECT – A keyword that specifies the data that […]