A senior collected data concerning the amount of time students had to wait when

ID: 3296620 • Letter: A

Question

A senior collected data concerning the amount of time students had to wait when adding or dropping courses at the beginning of the semester. The student then built a model of the behavior and experimented different strategies that at some cost would reduce the amount of waiting time. The data collected is given below:

Waiting time (Min)

Number of Occurrences

0-15

146

16-30

31-46

46-60

61-75

76-90

91-105

106-120

121-135

136-150

151-165

166-180

181-195

Total

758

Students are greeted by a receptionist who collects copies of their academic schedules. They then wait to be served by one of five "Academic Counselors". The counselors perform the following services:

Hour Changes

Hour Conflict Resolution

Add a Course

Replace a Course

Overload a Course

Change Field of Study

After accomplishing the necessary operation, students are logged out by a "receptionist" who collects the "Add-Drop" slips. However, approximately 5% of students must go to "Departmental Counselors" to gain approvals.

Requirement 1: Modeling the Current System

Identify any statistics that you would want to generate from your computer simulation. Why would the statistics be useful to the decision maker?

Using the "Harbor Simulation Algorithm" of the text as an example, construct an algorithm to simulate the scenario described above. (DO NOT CODE)

Describe in detail any data that you would like collected that would allow you to construct (and code) the various submodels of your algorithm.

Requirement 2: Constructing a Submodel

Each of the services described above would have to be studied and developed as a submodel. Additionally we must determine which service(s) the students required. The following data was collected for the 758 students serviced:

Service

Number of Occurrences

Hour Changes

269

Hour Conflict Resolution

Add a Course

238

Replace a Course

325

Overload a Course

Change Field of Study

Total

955

Refer to the Algorithm you constructed in Requirement 1. Construct a computer code in a language of your choice that assigns students to a service (or services) in the proper proportions.

Run the simulation you modeled above a sufficient number of times to mimic the distribution you are attempting to evaluate. Print out the assignments periodically to determine if you are converging to the required distribution.

Requirement 3: Modifying the Existing System

Discuss how you can verify that your simulation adequately models the observed behavior.

Discuss any changes you would consider making to the system. How would you measure the effect of the change? For example, consider the number of counselors used and the arrival pattern of students.

A Note about Preparing Assignments

Assignments must be prepared electronically, using a word processor and whatever equation editor integrates with your word processing software. However, if your word processor is not compatible with your mentor's word processor, you will need to save your document as a rich-text file (.rtf) before submitting it. Check with your mentor first to determine file compatibility. (Important: Use the equation editor to insert equations into your word-processed document, not to create the document itself.)

When preparing your answers, please identify each exercise clearly by textbook section and exercise number. To receive full credit for your answers, you must show all work and include complete solutions.

A Note about Graphing

Some textbook exercises occasionally ask for a graph, you are required to submit graphs with your written assignments. Consider trying one of the following online graphing utilities that have been called to our attention.

Graph

Waiting time (Min)

Number of Occurrences

0-15

146

16-30

31-46

46-60

61-75

76-90

91-105

106-120

121-135

136-150

151-165

166-180

181-195

Total

758

Hour Changes

Hour Conflict Resolution

Add a Course

Replace a Course

Overload a Course

Change Field of Study

Requirement 1: Modeling the Current System

Identify any statistics that you would want to generate from your computer simulation. Why would the statistics be useful to the decision maker?

Using the "Harbor Simulation Algorithm" of the text as an example, construct an algorithm to simulate the scenario described above. (DO NOT CODE)

Describe in detail any data that you would like collected that would allow you to construct (and code) the various submodels of your algorithm.

Requirement 2: Constructing a Submodel

Service

Number of Occurrences

Hour Changes

269

Hour Conflict Resolution

Add a Course

238

Replace a Course

325

Overload a Course

Change Field of Study

Total

955

Refer to the Algorithm you constructed in Requirement 1. Construct a computer code in a language of your choice that assigns students to a service (or services) in the proper proportions.

Requirement 3: Modifying the Existing System

Discuss how you can verify that your simulation adequately models the observed behavior.

Discuss any changes you would consider making to the system. How would you measure the effect of the change? For example, consider the number of counselors used and the arrival pattern of students.

A Note about Preparing Assignments

A Note about Graphing

Graph

Explanation / Answer

if you need code then here it is

//start-----

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
import java.util.*;

public class attendance extends JFrame implements ItemListener, ActionListener
{
private Connection con;
private Statement stmt;
private ResultSet rs;
private ResultSetMetaData rsMeta;
String query, dbURL, dbName, title;
Container cp;

String ref="",rollno="";
String[] heads;
int[] stChange;
String[][] cubeData;
int rows, cols, coo;

public attendance(String tit, String dbnm, String qry){
this.con = null;
this.stmt = null;
this.rs = null;
this.rsMeta=null;

this.dbName=dbnm;
this.query=qry;
this.title=tit;
this.rows=0;
this.cols=0;
this.coo=0;

dbURL ="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" +dbName;
cp = getContentPane();

try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
this.con=DriverManager.getConnection(this.dbURL);
this.con.setAutoCommit(false);
this.stmt=this.con.createStatement();

this.rs=this.stmt.executeQuery(query); // execure query and get resultset (rs)
rsMeta = rs.getMetaData(); // get rs metadata
this.cols = rsMeta.getColumnCount(); // get number of colums
this.coo =this.cols-1;
while(rs.next()) { // get rows in resultset
++this.rows;
}

heads = new String[cols]; // initialize col heads

for (int i = 0; i < cols; i++) { // getting colums heading in heads[]
int colindex=i+1; // column indexes start from 1
heads[i] = rsMeta.getColumnName(colindex);
}

stChange = new int[rows]; //to save value when status changed

this.rs=this.stmt.executeQuery(query); // execure query and get resultset (rs)
cubeData = new String[rows][cols]; // initialize table data

int j=0; int k=0; // function to get resultset data
while(rs.next())
{
if(j<=rows)
{ int h=1;
if(k<=cols)
{
for(int cc=0; cc<cols; cc++)
{ cubeData[j][k]=rs.getString(h);
h++;
k++;
}
}
k=0;h=0;
j++;
}
}

}catch(Exception ex)
{ System.err.println(ex.getMessage());
ex.printStackTrace(System.err);
}

cp.setLayout(new GridLayout(rows+2,cols)); // 1 additional Row of Col heading, 1 for save btn

//---------------- Adding heading in CP---------------------------------------

for (int i = 0; i < cols; i++) {
JLabel jl = new JLabel(" [ "+heads[i]+" ] ");
jl.setOpaque(true);
jl.setBackground(Color.gray);
jl.setForeground(Color.white);
cp.add(jl);

}

//---------------- Adding data ---------------------------------------

for(int j=0; j<rows; j++){
for(int k=0; k<cols; k++)
{
if(k==(cols-1))
{ ref="-"+j+"."+k;
String status=cubeData[j][k]+ref;
stChange[j]=Integer.parseInt(rollno); // save previously selected status of each // row(student) + array address
Choice jc = new Choice();

jc.add("Present"+ref);
jc.add("Leave"+ref);
jc.add("Absent"+ref);

jc.select(status);

jc.addItemListener(this);
cp.add(jc);

}
else
cp.add(new JLabel(cubeData[j][k]));
rollno=cubeData[j][k];
}
}
addSaveButton();
//----------------------------------------------------------------------------
setTitle(title);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
pack();
setResizable(false);
setVisible(true);

}

//------------------------SAVE BUTTON-----------------------------------------

public void addSaveButton(){
JButton saveBtn = new JButton(" :::: Save :::: ");
saveBtn.addActionListener(this);
cp.add(saveBtn);
}

//------------------------Item Listener -----------------------------------------
public void itemStateChanged(ItemEvent ie) {
String s = (String)ie.getItem();

String ro = s.substring(s.indexOf("-")+1,s.indexOf("."));
String co = s.substring(s.indexOf(".")+1,s.length());

String stats = s.substring(0,s.indexOf("-"));

int roo = Integer.parseInt(ro);
coo = Integer.parseInt(co);

cubeData[roo][coo]=stats;
}

//------------------------Action Listener-----------------------------------------
public void actionPerformed(ActionEvent ae) {

try{
for(int j=0; j<rows; j++)
{
String updt = "update students set Status= '"+cubeData[j][coo]+"' where Rollno="+stChange[j];
this.con=DriverManager.getConnection(this.dbURL);
this.stmt.executeUpdate(updt);
}
this.con.commit();
System.out.println("Records updated..!");
con.close();

}catch(Exception ex)
{ System.err.println(ex.getMessage());
ex.printStackTrace(System.err);
}
}

public static void main(String args[])
{
new attendance("..:: Attendance Form ::.. ", "mydb.mdb", "SELECT * FROM students order by Rollno");
}

}// ends class m

Navigate

A senior collected data concerning the amount of time students had to wait when

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.

A senior collected data concerning the amount of time students had to wait when

Question

Explanation / Answer

Related Questions

Navigate