Case assignments must be completed with a written 1-page study on the assigned case questions in the textbook. The format requested for these assignments is based on elaborating and including two basic parts in the essay: 1) in a bullet presentation style (one phrase each bullet), list a summary of the key issues, situations, problems, opportunities and threats you may identify as relevant; 2) answer all the questions listed in each case in two or three sound paragraphs. Use the APA style for these assignments.

Case SpinCent: The Decision To Export

More than 300,000 U.S. companies export goods. Some 7,000 of these, such as Caterpillar, Boeing, General Electric, and Intel, generate about 65 percent of total exports.2  Their smallest shipments are typically larger than the largest shipments of smaller companies. Still, some 297,000 small and medium-sized enterprises (SMEs)— specifically, companies with fewer than 500 workers—account for nearly 98 percent of all U.S. exporters.3  One such SME is SpinCent of Pennsylvania.

SpinCent manufactures laboratory and industrial centrifuges.

Companies in chemical, pharmaceutical, food, environmental, and

mining industries use them to spin a substance into high-speed rotation

around a fixed axis, thereby moving heavy elements to the bottom,

lighter objects toward the top, and liquid in between. SpinCent’s

56 employees—43 workers, 8 product and process engineers, and

5 managers—operate out of its 90,000-square-foot facility in suburban

Philadelphia. SpinCent began operations in 2010 with one goal

in mind: create high-performance centrifuges that inspire absolute

confidence. Its patented technology anchors a full line of automatic

and manual centrifuges recognized for quality and value. To this day,

management believes it builds “centrifuges for which there simply

are no equals.”

To Export Or Not To Export: That Is The Question

From inception, SpinCent approached export passively. Its international

sales often resulted from other U.S. firms’ orders that were

set for export, occasional sale leads received at trade shows, or an

unsolicited order from a foreign buyer. Export sales generated high

gross margins; occasionally, unexpected complications, such as

customs or credit problems, increased administrative costs. Still,

SpinCent’s net margins on export sales ran about 15 percent higher

than domestic sales.

Paul Knepper, CEO and founder, explained that recurring problems

had dampened his interest in exporting. First, he and his colleagues

were skeptical about the likelihood of international success. Previous

efforts, they felt, had spent more time on unfocused searching or solving

situations than on purposefully growing export activity. Moreover,

serving customers in the domestic market had kept them quite busy.

As a result, developing exports stretched their already thin management

structure. Going international, they feared, would pose tough challenges,

especially heading into direct competition with seasoned exporters from

Germany and Japan.

Still, as time passed, market pressures raised concerns about

SpinCent’s ongoing productivity and profitability. The struggling U.S.

manufacturing sector had slowed SpinCent’s growth and pushed

some of its customers to import cheaper, lower-end centrifuges from foreign suppliers. Increasing price competition was inevitable.

Knepper knew the day of reckoning was at hand: SpinCent must

(1) focus on the domestic market and exploit every possible efficiency

to sustain productivity or (2) expand aggressively into export, looking

to fast-growing overseas markets. Ultimately, Knepper conceded,

market trends forced his hand. The slow-moving deindustrialization

of the United States, forecast to continue for years, would steadily

reduce domestic demand. Meanwhile, quickly industrializing emerging

economies, particularly in Asia, signaled rich opportunities.

Hence, Knepper accepted, somewhat grudgingly, that SpinCent must

export to promising markets.

Asia Calls

Big market trends signaled big opportunities in Asia. “Industries

were coming online everywhere and seemingly overnight,” observed

Knepper. Pro-market reform, improving economic freedom, and accelerating

economic development spurred industrialization throughout

Asia. Moreover, the types of goods moving through Asia’s

seaports signaled budding industries that used SpinCent’s sorts of

centrifuges. And, unlike the United States, which was in the mature

part of the product life cycle, emerging economies looked set to grow

for years.

Getting Started

New to the idea of the Asian market, SpinCent sought help on how

best to access the large, diverse region. Knepper feared wasting

resources flying solo. Moreover, he was not looking to generate a

single-shot export burst, but aimed to build relationships that would

support long-term growth. Hence, the primary challenge was finding

competent and trustworthy distributors who would develop, make,

and service local sales. “We were looking for a long-term partner

and not a quick export sale,” said Knepper. “The right partner for

SpinCent needed to be as confident and competent about the product

as we are, and able to promote, educate, and serve consumers in

the respective territories.” The key, he added, was partnering with

respected firms. On the flip side, SpinCent had to convince potential

agents that partnering with it made long-term sense.

Knepper began by seeking information on potential distributors,

confirming their reputation and resources. A few of the company’s

earlier export transactions, for instance, had run into problems with

agents who struggled financially. As Knepper warned, “Getting paid

is a huge part of running a business, and unless a company has

the right payment policies in place with the right partners, it will get

scammed.”

Mindful of these issues, Knepper attended a trade seminar sponsored

by the U.S. Commercial Service’s Export Assistance Center of  Philadelphia. On the agenda were market analysis and trade reports

on the emerging economies of Asia. Taking his seat, he couldn’t help

but wonder about the opportunities. Sure, he conceded, they sounded

great. However, he had seen hype like this come back to bite, not

to mention the horror stories he’d heard of the problems and pitfalls

of exporting. Indeed, he reflected, a key reason for attending was

reconciling his sense of the opportunities and threats.

Getting Help

Since exports promote economic growth, government agencies offer

extensive assistance, such as trade seminars, market research,

training programs, and financial planning. Trade officials encourage

SMEs like SpinCent, seeing them as the primary beneficiaries of initiatives

to initiate and accelerate international trade activity. Given

that 60 percent or so of all SME exporters posted sales to only one

foreign market, many could boost performance by entering just one

or two others. Expanding SMEs’ market horizons through trade seminars,

official reasoned, bolstered their confidence to do so.

After a full morning of profiles and presentations, Knepper

believed Asian markets held far more opportunities than risk. He

had learned quite a bit about Asia, as well as some technicalities

of exporting. Still, his unfamiliarity of local business practicalities,

compounded by the lack of local sales representatives, bothered

him. Filling in these blanks, he concluded, called for some on-the-ground

research. So, before leaving, he spoke to Commercial Service

agents and arranged to join a 12-day trade mission that was

heading to Hong Kong, the Philippines, Vietnam, and Taiwan the

following month.

Goal Setting

Knepper’s trip had straightforward goals: assess market potential,

identify competitors, get a sense of reasonable price points, and recruit

local sales representatives and distributors. Although he had

never visited Asia, he believed he had prepared well. His time with

the trade representatives in Philadelphia gave him a good sense of

the general characteristics and industry conditions in Asian markets.

Also, in the past, SpinCent had received inquiries from Asian distributors

ordering centrifuges; some had inquired about representing

the company locally. Depending on how busy it was with domestic

customers, SpinCent tried to respond yet nothing substantial had

ever come of it. Still, these contacts had been saved, thereby giving

Knepper a start on potential distributors and likely customers.

Knepper also tapped the Commercial Services’ Gold Key program

to prescreen potential distributors. This program helps SMEs

enlist Commercial Services agents overseas to scan local markets for

qualified agents, distributors, and representatives. Gold Key agents

will prescreen and prequalify potential partners, conduct background

checks, and customize local market research. Exporters report that

the Gold Key program ensures that when a firm adds a partner to its

network, it is a respected company in the target country. Thinking back to his days as a Boy Scout, Knepper believed that

he met the sacred command: “Be prepared.” With a briefcase full of

brochures, a laptop loaded with profiles of his product line, and the

sense of doing something potentially great, he headed to Asia. Over

the next two weeks, he interviewed potential agents, chatted with

likely customers, scouted competitors’ offerings, test called their

service support, spoke to freight forwarders and logistics companies,

and visited local government officials and customs agencies.

Asia Calls, Spincent Answers

On the flight home, tired but charged, Knepper realized that his misgivings

about exporting had been unfounded. There were risks, but

the opportunities outweighed them. Exporting was no longer an option

for SpinCent—it was an imperative. Besides a new sense of

commitment, Knepper had a bit more confidence, given the newly

signed distributors in the Philippines and Taiwan as well as promising

sales leads there and in Hong Kong.

Back in Philadelphia, Knepper tested the Asian market a bit

more, advertising in trade publications as well as running banner

ads on trade sites in tandem with his newly signed distributors (he

handled the English ads, they, the Mandarin versions). In addition,

he began working with an agent from Commercial Services on an

export plan. This work helped SpinCent secure its largest overseas

partner to date, a distributor in Hong Kong who served the fast-growing

Chinese market. Commercial Services arranged meetings with

others, eventually signing a distributor in Singapore and generating

leads in Australia.

Allied with strong partners, SpinCent continues tapping the support

provided by government agencies. The more he has dealt with

them, the more Knepper appreciates a friend’s advice: “Let the government

do what it can for you. This is their niche and they’re the

best at it.” Now, with an export plan in hand, Knepper has begun

working with the Export-Import Bank to secure financing options for

overseas distributors and customers.4 And, with a gleam in his eye,

he’s set to attend a U.S. Commercial Service’s profile of the emerging

markets of sub-Saharan Africa.

Going Forward

Steadily, as SpinCent gains experience in Taiwan, the Philippines,

Hong Kong, and Singapore, look onward and upward. Although exporting

creates challenges, it helps SpinCent boost productivity and

profitability. Indeed, overseas sales provided the firm with a growing

stream of business during the economic downturn in the United

States, while rivals who had not diversified via exports struggled.

More important, exporting taps a low-cost, high-return opportunity to

leverage SpinCent’s centrifuge technology.

This experience reflects Knepper, has straightforward lessons:

“If you are thinking about exporting internationally, do it. Get going,

do your homework, utilize low-cost resources, participate in trade missions, learn about business cultures, and build relationships.

Always verify your potential business partners. Gather as much

information as you can. Stress-test your assumptions; the wrong

guess costs you time and money. Above all, no matter the problems

that you’ll run into, stay committed. All of these seem tough,

but they only cost pennies on the dollar and the returns can be

substantial.”

Questions

14-1. Analyze two challenges that SpinCent overcame in developing its export activity. Describe how it overcame them.

14-2. Based on its Asian experiences, map a sequence to guide SpinCent’s export expansion to sub-Saharan Africa.

JAVA Program

The program below the text reads in the pet type …dog, cat or other (only the words dog, cat, other) and the appointment amount. It is supplied as a beginning code to the assignment:

_______________________________________________________________
pet_lab package; 
import javax.swing.JOptionPane; 
public class pet_lab 
{ 

        public static void main (String [] args) 
        { 
                String pet, temp; 
                double payment; 
                pet = JOptionPane.showInputDialog (null, 
                 "Enter the pet type", "", JOptionPane.QUESTION_MESSAGE); 
                temp = JOptionPane.showInputDialog (null, 
                "Enter the payment for the appointment", "", JOptionPane.QUESTION_MESSAGE); 
            payment = Double.parseDouble (temp); 
            System.exit (0); 
        } 
}
_______________________________________________________________

You are to make the following changes:

• Add a loop that reads data until the user wishes to stop
• Count and print the number of dogs, cats and other pets
• Calculate and print the total paid for dogs, cats and other pets
• Calculate and print the total payment of all pets seen
• Print which pet is seen the most, dogs, cats, or other

Please paste both the java code, a screenshot of the same code, and a screenshot/pasting of the final answer. Using this to check my Java data. Thanks!

Hi ERP experts! I am looking for ERP failure implementation cases. Specifically, I need suggestions of cases, so I can summarize key factors influencing the success of the Sales & Marketing ERP module implementation.

you have a toy car running on two batteries. if you could hook it up wit only one of the batteries, it would draw

a)twice as much current as the two batteries

b) half as much current as the two batteries

c) the same amount of current as the two batteries

why??

Analysis and Discussion about if, if else, else if statement and Switch C programming write on your computer font

Do you think communication is more important to leaders now than it was in Hitler's and FDR's time? Who is a more current charismatic leader that you know of, and how are they similar to Hitler or FDR in their communication style?

relate Dominance Concept to those below;
1. Democratic
2. Authoritative
3. Authoritarian

What is community policing? How does it differ from traditional policing? Does community policing offer a real opportunity to improve policing services in the United States? Why or why not?

1. What tests and instruments are available for assessing psychopathology? What is the current diagnostic system? How has it changed over time?

2. Explain each of the psychometric issues related to assessment and diagnosis: reliability, validity, standardization.

3. What are the uses and applications of the DSM? How are disorders classified? What are the problems with the current classification system used in the DSM?

Consider the following (assume that there are 2 workers in Mexico and 3 in the USA):

Bottles of tequila produced in one hour Mexico, 8 USA, 4

4 Pounds of rice produced in one hourMexico, 6 USA, 8

From the above table, select the correct answer:

A) The pre-trade relative price of tequila in the USA is 2 and in Mexico is 0.75 and therefore the USA has a comparative advantage in rice

B) The pre-trade relative price of rice in the USA is 0.5 and in Mexico is 1.33 and therefore Mexico has a comparative advantage in rice

C) The pre-trade relative price of tequila in Mexico is 0.75 and in the USA is 2 and therefore Mexico has a comparative advantage in rice

D) The pre-trade relative price of tequila in the USA is 0.75 and in Mexico is 2 and therefore USA has a comparative advantage in rice

Complete a qualitative risk assessment and response planning of each of the risks identified below. Use at least 1 of each of the threat risk response strategies for your response planning.

RISKS:

1. Project and purpose not well defined

2. Scope Creep

3. Project schedule is not clearly defined or understood

4. Lack of communication causing lack of clarity and confusion

5. No control over staff priorities

6. Delay in earlier project phases jeopardizes ability to meet fixed date

7. Unresolved project conflicts not escalated in a timely manner

8. Contractor delays

9. Added workload or time requirements because of new direction or policy

10. Stakeholder action delays project.

Rubric

Task	Point Value (out of 100)
Proper APA format, spelling, grammar, citation, and organization of writing	10 points
Risk Assessment	20 points
Risk Response Planning	50 points
Clear Format and Easy to View/ Report	20 points

1. Identify an organization that has achieved ISO 9000 certification and write a short paper (roughly one page) that summarizes the benefits and results that the organization has achieved using ISO 9000.
2. Find a customer satisfaction survey from a restaurant or a hotel and submit it along with your group report as an attachment. How do the questions relate to the five dimensions of service quality introduced in Chapter 2? Discuss how the survey results could be used to control quality. What types of quality control charts might be used?
3. Research and briefly describe one or two lean initiatives in service organizations and then make an argument for or against adopting lean principles in service businesses. What is different about applying lean in a factory versus a service situation? Describe your findings in a one-page (roughly) paper.
4. Pick one of the projects , i.e., in one of your group member’s home, fraternity/sorority or business organization. List at least 7 activities that comprise the project and draw the precedence network. What problems did you encounter in doing this?

Java does not have a retry keyword like Ruby. How can we implement the same sort of functionality?

Create a view that will display the student id, name, event id, category, and score for all

events for students who scored a 70 or below on any test. Call this view

atriskstudents.

a. What code did you write for this view? Insert the snip of the contents of the view SQL

code here:

b. Using this view, display those students who earned a score of 65 or greater. Insert your

snip here

***********************************************************************************************************************************************************

***********************************************************************************************************************************************************

CREATE DATABASE Class;

#-- Using the database

USE Class;

# create student table

DROP TABLE IF EXISTS student;

CREATE TABLE student

(
  
name VARCHAR(20) NOT NULL,
  
gender ENUM('F','M') NOT NULL,
  
student_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
  
PRIMARY KEY (student_id)

);

# create grade event table

DROP TABLE IF EXISTS grade_event;

CREATE TABLE grade_event

(
  
date DATE NOT NULL,
  
category ENUM('T','Q') NOT NULL,
  
event_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
  
PRIMARY KEY (event_id)

);

# create score table

# The PRIMARY KEY comprises two columns to prevent any combination
# of event_id/student_id from appearing more than once.

DROP TABLE IF EXISTS score;

CREATE TABLE score

(
  
student_id INT UNSIGNED NOT NULL,
  
event_id INT UNSIGNED NOT NULL,
  
score INT NOT NULL,
  
PRIMARY KEY (event_id, student_id),
  
INDEX (student_id),
  
FOREIGN KEY (event_id) REFERENCES grade_event (event_id),
  
FOREIGN KEY (student_id) REFERENCES student (student_id)

);

# create absence table

DROP TABLE IF EXISTS absence;

CREATE TABLE absence

(
  
student_id INT UNSIGNED NOT NULL,
  
date DATE NOT NULL,
  
PRIMARY KEY (student_id, date),
  
FOREIGN KEY (student_id) REFERENCES student (student_id)

);

#--Populate the student table

INSERT INTO student VALUES ('Megan','F',NULL);

INSERT INTO student VALUES ('Joseph','M',NULL);

INSERT INTO student VALUES ('Kyle','M',NULL);

INSERT INTO student VALUES ('Katie','F',NULL);

INSERT INTO student VALUES ('Abby','F',NULL);

INSERT INTO student VALUES ('Nathan','M',NULL);

INSERT INTO student VALUES ('Liesl','F',NULL);

INSERT INTO student VALUES ('Ian','M',NULL);

INSERT INTO student VALUES ('Colin','M',NULL);

INSERT INTO student VALUES ('Peter','M',NULL);

INSERT INTO student VALUES ('Michael','M',NULL);

INSERT INTO student VALUES ('Thomas','M',NULL);

INSERT INTO student VALUES ('Devri','F',NULL);

INSERT INTO student VALUES ('Ben','M',NULL);

INSERT INTO student VALUES ('Aubrey','F',NULL);

INSERT INTO student VALUES ('Rebecca','F',NULL);

INSERT INTO student VALUES ('Will','M',NULL);

INSERT INTO student VALUES ('Max','M',NULL);

INSERT INTO student VALUES ('Rianne','F',NULL);

INSERT INTO student VALUES ('Avery','F',NULL);

INSERT INTO student VALUES ('Lauren','F',NULL);

INSERT INTO student VALUES ('Becca','F',NULL);

INSERT INTO student VALUES ('Gregory','M',NULL);

INSERT INTO student VALUES ('Sarah','F',NULL);

INSERT INTO student VALUES ('Robbie','M',NULL);

INSERT INTO student VALUES ('Keaton','M',NULL);

INSERT INTO student VALUES ('Carter','M',NULL);

INSERT INTO student VALUES ('Teddy','M',NULL);

INSERT INTO student VALUES ('Gabrielle','F',NULL);

INSERT INTO student VALUES ('Grace','F',NULL);

INSERT INTO student VALUES ('Emily','F',NULL);

#--Populate grade event table

INSERT INTO grade_event VALUES('2015-09-03', 'Q', NULL);
INSERT INTO grade_event VALUES('
2015-09-06', 'Q', NULL);
INSERT INTO grade_event VALUES('
2015-09-09', 'T', NULL);
INSERT INTO grade_event VALUES('
2015-09-16', 'Q', NULL);
INSERT INTO grade_event VALUES(
'2015-09-23', 'Q', NULL);
INSERT INTO grade_event VALUES('
2015-10-01', 'T', NULL);

#--Populate the score table

INSERT INTO score VALUES (1,1,20);

INSERT INTO score VALUES (3,1,20);

INSERT INTO score VALUES (4,1,18);

INSERT INTO score VALUES (5,1,13);

INSERT INTO score VALUES (6,1,18);

INSERT INTO score VALUES (7,1,14);

INSERT INTO score VALUES (8,1,14);

INSERT INTO score VALUES (9,1,11);

INSERT INTO score VALUES (10,1,19);

INSERT INTO score VALUES (11,1,18);

INSERT INTO score VALUES (12,1,19);

INSERT INTO score VALUES (14,1,11);

INSERT INTO score VALUES (15,1,20);

INSERT INTO score VALUES (16,1,18);

INSERT INTO score VALUES (17,1,9);

INSERT INTO score VALUES (18,1,20);

INSERT INTO score VALUES (19,1,9);

INSERT INTO score VALUES (20,1,9);

INSERT INTO score VALUES (21,1,13);

INSERT INTO score VALUES (22,1,13);

INSERT INTO score VALUES (23,1,16);

INSERT INTO score VALUES (24,1,11);

INSERT INTO score VALUES (25,1,19);

INSERT INTO score VALUES (26,1,10);

INSERT INTO score VALUES (27,1,15);

INSERT INTO score VALUES (28,1,15);

INSERT INTO score VALUES (29,1,19);

INSERT INTO score VALUES (30,1,17);

INSERT INTO score VALUES (31,1,11);

INSERT INTO score VALUES (1,2,17);

INSERT INTO score VALUES (2,2,8);

INSERT INTO score VALUES (3,2,13);

INSERT INTO score VALUES (4,2,13);

INSERT INTO score VALUES (5,2,17);

INSERT INTO score VALUES (6,2,13);

INSERT INTO score VALUES (7,2,17);

INSERT INTO score VALUES (8,2,8);

INSERT INTO score VALUES (9,2,19);

INSERT INTO score VALUES (10,2,18);

INSERT INTO score VALUES (11,2,15);

INSERT INTO score VALUES (12,2,19);

INSERT INTO score VALUES (13,2,18);

INSERT INTO score VALUES (14,2,18);

INSERT INTO score VALUES (15,2,16);

INSERT INTO score VALUES (16,2,9);

INSERT INTO score VALUES (17,2,13);

INSERT INTO score VALUES (18,2,9);

INSERT INTO score VALUES (19,2,11);

INSERT INTO score VALUES (21,2,12);

INSERT INTO score VALUES (22,2,10);

INSERT INTO score VALUES (23,2,17);
INSERT INTO score VALUES (24,2,19);

INSERT INTO score VALUES (25,2,10);

INSERT INTO score VALUES (26,2,18);

INSERT INTO score VALUES (27,2,8);

INSERT INTO score VALUES (28,2,13);

INSERT INTO score VALUES (29,2,16);

INSERT INTO score VALUES (30,2,12);

INSERT INTO score VALUES (31,2,19);

INSERT INTO score VALUES (1,3,88);

INSERT INTO score VALUES (2,3,84);

INSERT INTO score VALUES (3,3,69);

INSERT INTO score VALUES (4,3,71);

INSERT INTO score VALUES (5,3,97);

INSERT INTO score VALUES (6,3,83);

INSERT INTO score VALUES (7,3,88);
INSERT INTO score VALUES (8,3,75);

INSERT INTO score VALUES (9,3,83);

INSERT INTO score VALUES (10,3,72);
INSERT INTO score VALUES (11,3,74);

INSERT INTO score VALUES (12,3,77);

INSERT INTO score VALUES (13,3,67);
INSERT INTO score VALUES (14,3,68);

INSERT INTO score VALUES (15,3,75);

INSERT INTO score VALUES (16,3,60);

INSERT INTO score VALUES (17,3,79);

INSERT INTO score VALUES (18,3,96);

INSERT INTO score VALUES (19,3,79);

INSERT INTO score VALUES (20,3,76);

INSERT INTO score VALUES (21,3,91);

INSERT INTO score VALUES (22,3,81);

INSERT INTO score VALUES (23,3,81);

INSERT INTO score VALUES (24,3,62);

INSERT INTO score VALUES (25,3,79);

INSERT INTO score VALUES (26,3,86);

INSERT INTO score VALUES (27,3,90);

INSERT INTO score VALUES (28,3,68);

INSERT INTO score VALUES (29,3,66);

INSERT INTO score VALUES (30,3,79);

INSERT INTO score VALUES (31,3,81);

INSERT INTO score VALUES (2,4,7);

INSERT INTO score VALUES (3,4,17);

INSERT INTO score VALUES (4,4,16);

INSERT INTO score VALUES (5,4,20);

INSERT INTO score VALUES (6,4,9);

INSERT INTO score VALUES (7,4,19);

INSERT INTO score VALUES (8,4,12);

INSERT INTO score VALUES (9,4,17);

INSERT INTO score VALUES (10,4,12);

INSERT INTO score VALUES (11,4,16);

INSERT INTO score VALUES (12,4,13);

INSERT INTO score VALUES (13,4,8);

INSERT INTO score VALUES (14,4,11);

INSERT INTO score VALUES (15,4,9);

INSERT INTO score VALUES (16,4,20);

INSERT INTO score VALUES (18,4,11);

INSERT INTO score VALUES (19,4,15);

INSERT INTO score VALUES (20,4,17);

INSERT INTO score VALUES (21,4,13);

INSERT INTO score VALUES (22,4,20);

INSERT INTO score VALUES (23,4,13);

INSERT INTO score VALUES (24,4,12);
INSERT INTO score VALUES (25,4,10);

INSERT INTO score VALUES (26,4,15);

INSERT INTO score VALUES (28,4,17);

INSERT INTO score VALUES (30,4,11);

INSERT INTO score VALUES (31,4,19);

INSERT INTO score VALUES (1,5,15);

INSERT INTO score VALUES (2,5,12);

INSERT INTO score VALUES (3,5,11);

INSERT INTO score VALUES (5,5,13);

INSERT INTO score VALUES (6,5,18);

INSERT INTO score VALUES (7,5,14);

INSERT INTO score VALUES (8,5,18);

INSERT INTO score VALUES (9,5,13);

INSERT INTO score VALUES (10,5,14);

INSERT INTO score VALUES (11,5,18);

INSERT INTO score VALUES (12,5,8);

INSERT INTO score VALUES (13,5,8);

INSERT INTO score VALUES (14,5,16);

INSERT INTO score VALUES (15,5,13);

INSERT INTO score VALUES (16,5,15);

INSERT INTO score VALUES (17,5,11);

INSERT INTO score VALUES (18,5,18);

INSERT INTO score VALUES (19,5,18);
INSERT INTO score VALUES (20,5,14);

INSERT INTO score VALUES (21,5,17);

INSERT INTO score VALUES (22,5,17);

INSERT INTO score VALUES (23,5,15);

INSERT INTO score VALUES (25,5,14);

INSERT INTO score VALUES (26,5,8);

INSERT INTO score VALUES (28,5,20);

INSERT INTO score VALUES (29,5,16);

INSERT INTO score VALUES (31,5,9);

INSERT INTO score VALUES (1,6,100);

INSERT INTO score VALUES (2,6,91);

INSERT INTO score VALUES (3,6,94);

INSERT INTO score VALUES (4,6,74);

INSERT INTO score VALUES (5,6,97);

INSERT INTO score VALUES (6,6,89);

INSERT INTO score VALUES (7,6,76);

INSERT INTO score VALUES (8,6,65);

INSERT INTO score VALUES (9,6,73);

INSERT INTO score VALUES (10,6,63);

INSERT INTO score VALUES (11,6,98);

INSERT INTO score VALUES (12,6,75);

INSERT INTO score VALUES (14,6,77);

INSERT INTO score VALUES (15,6,62);

INSERT INTO score VALUES (16,6,98);

INSERT INTO score VALUES (17,6,94);

INSERT INTO score VALUES (18,6,94);

INSERT INTO score VALUES (19,6,74);
INSERT INTO score VALUES (20,6,62);

INSERT INTO score VALUES (21,6,73);

INSERT INTO score VALUES (22,6,95);

INSERT INTO score VALUES (24,6,68);

INSERT INTO score VALUES (25,6,85);

INSERT INTO score VALUES (26,6,91);
INSERT INTO score VALUES (27,6,70);

INSERT INTO score VALUES (28,6,77);

INSERT INTO score VALUES (29,6,66);

INSERT INTO score VALUES (30,6,68);

INSERT INTO score VALUES (31,6,76);

#--Populate the absence table

INSERT INTO `absence` VALUES (3,'2015-09-03');

INSERT INTO `absence` VALUES (5,'2015-09-03');

INSERT INTO `absence` VALUES (10,'2015-09-06');

INSERT INTO `absence` VALUES (10,'2015-09-09');

INSERT INTO `absence` VALUES (17,'2015-09-07');

INSERT INTO `absence` VALUES (20,'2015-09-07');

***********************************************************************************************************************************************************

***********************************************************************************************************************************************************