# CTE Resource Center - Verso - Programming, Advanced Instructional Scenarios

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Instructional Scenarios

Cafeteria Catastrophe

Note: This scenario could be an ongoing project throughout the year or a culminating project at the end of the year.

Duty/Concept Areas

Developing Object-Oriented Programming
Developing Database Applications
Developing Web Applications
Developing Employability Skills

Scenario

The cafeteria staff in your school has many problems, which include students stealing food, students not paying the correct amount for their food, and students causing disruptions in the cafeteria line. The cafeteria manager has contracted with you to create a program that will track inventory, track sales, calculate a purchase, and store students’ disciplinary records.

Big Question

How would you design a program to meet the needs of the cafeteria staff?

Focus Questions

  1. What steps would you take to solve the problems?
  2. How would you design an interface that would allow the cafeteria workers to resolve all of their issues?
  3. What programming structures are needed to track inventory (beginning, ending, and replacement)?
  4. What programming structures are needed to track sales?
  5. What items should be included in the customers’ transactions?
  6. How would you determine tracking and storing discipline referrals?
  7. How would you report and track the students’ infractions?
  8. How will you report lost sales and total sales?
  9. How can you use Internet resources to enhance your program?
  10. How will you evaluate the effectiveness of the program you created?

SOL Correlations

Mathematics: COM.1, COM.2, COM.3, COM.4, COM.5, COM.6, COM.7, COM.9, COM.10, COM.12, COM.13, COM.14, COM.15, COM.16, COM.17, COM.18, COM.19, COM.20, AII.4, DM.3, DM.4, DM.11

English: 11.5, 12.5

Project-Based Assessment

A professional program should solve the issues identified by the cafeteria staff. The program interface should incorporate accepted advanced programming standards and styles and meet the users’ specifications. The program should be error-free with accurate output under different scenarios. Assess outcomes using a rubric, such as the following:

Programming Rubric
http://www.svcc.edu/~megillk/programming_rubric.htm


You Be the Judge

Duty/Concept Area

Developing Web Applications
Developing Employability Skills

Scenario

You are an employee who has recently been promoted to manager of the Information Technology (IT) department for a large accounting firm. Your department has received a request to create a small Web-enabled application that would convert loan periods into due dates. You asked a young programmer in your department to create a program that would accomplish this task. Shortly after the employee loaded the program on the company intranet, an e-mail listing all employees’ confidential salary information went out from your firm under a bogus account. After investigating this situation and conducting interviews with key staff members, you discovered that the employee did not write the program but copied it off the Internet. It was determined that the code contained a version of the password-stealing worm called Hazif-C. Apparently, the worm-stealing code sent the administrative password to a hacker, who then illegally entered the company e-mail server and sent the e-mail. Upon further scrutiny of the employee’s résumé, you also discovered that the employee may have fraudulently claimed to have earned programming certifications in MCSD for Microsoft .Net and Brainbench Visual Basic.

You have been asked by the company’s vice president to investigate this situation and create a report to be submitted within five days. The report should contain your recommendations, including suggestions about how to design Web applications with improved security features.

Big Question

What steps should you take to investigate this situation and prepare a report for management that would include a recommendation of how to deal with the employee who created the problem?

Focus Questions

  1. What is the nature of the Hazif-C worm?
  2. What legal and ethical issues are associated with this situation?
  3. What recourse does the company have to deal with the employee who created the problem?
  4. How can the employees’ certifications be verified?
  5. What action should the manager take to deal with the employee?
  6. Do you, as the newly appointed manager of this department, bear any responsibility for the problem?
  7. Should you assume any responsibility?
  8. What security measures should the company implement to prevent this problem from happening again?

SOL Correlations

Mathematics: COM.1, COM.2, COM.4, COM.5, COM.6, COM.7, COM.9, COM.10, COM.12, AFDA.1
English: 11.4, 11.7, 11.8, 11.10, 12.4, 12.7

Project-Based Assessment

A report that fully explores

 

The SOL Game

Note: This scenario could be offered as an ongoing project throughout the year.

Duty/Concept Area

Developing Object-Oriented Programming
Developing Interactive Multimedia Applications

Scenario

An elementary school teacher has requested a Mathematics Standards of Learning review game that will help students learn basic mathematics skills (e.g., addition, subtraction, multiplication, division). The game will be used for students in grades K-5. The teacher has requested that the game have a user-friendly, colorful interface. The instructions on how to use the game should be very simple and should appear within the interface. The student will be able to access a mathematical problem through the interface and supply the answer. If the answer entered by the student is not correct, the program should notify the student and provide a chance to correct the answer. If the second answer entered by the student is not correct, the student will be given the correct answer along with a message that encourages the student to continue to study the math concepts. Individual games should be scored by percentage of correct answers.

Big Question

What are the key design features required for this game, and what are your constraints?

Focus Questions

  1. What are the game design steps?
  2. Who is your audience?
  3. What is your content?
  4. Which platform should you choose?
  5. What are your look-and-feel features?
  6. What input and output devices will you offer to players?
  7. Will you provide accessibility for all?
  8. How and why should you document your production?
  9. What will your user instructions say, and how will you deliver them?
  10. What type of scoring will you provide?

SOL Correlations

Mathematics: COM.1, COM.2, COM.3, COM.4, COM.5, COM.6, COM.7, COM.8, COM.9, COM.10, COM.12, COM.13, COM.14, COM.15, COM.16, COM.17, COM.18, COM.19, COM.20, A.1, A.2, A.3, A.5, A.6, A.7, AFDA.1, AII.4, AII.6, AII.7, DM.3, DM.4, DM.11, G.1, G.3, G.11, G.14, T.6
English: 11.5, 11.6, 11.7, 12.5, 12.6, 12.7

Project-Based Assessment

Assess outcomes, using a rubric such as the following:

Programming Rubric
http://www.svcc.edu/~megillk/programming_rubric.htm

 

Putting It All Together

Note: This scenario could be offered as an ongoing project throughout the year.

Duty/Concept Area

Developing Object-Oriented Programming
Developing Interactive Multimedia Applications
Developing Web Applications
Developing Mobile Applications
Developing Database Applications

Scenario

You are a programming contractor bidding for a project offered by a sales business to create all the programming applications they need. The salespeople need secure access through an interface to all the data that will help them sell their product. When on the road, they also need to document their travel expenses, interactions with clients, and sales. An online, e-commerce site must also record order and inventory details, market the product, and securely process customers’ financial and personal information. The shipping department needs to record inventory and process orders. You must pick a team of programmers (i.e., classmates) to help you develop the system. Your objective is to win the contract at the highest rate of return and deliver an exceptional system.

Big Question

How do you get all applications working together in a seamless environment?

Focus Questions

  1. What are the application design steps?
  2. What are the objectives of each application?
  3. What should be the design features of each application?
  4. Who is the target audience for each of your applications?
  5. Which platform should you choose?
  6. What should be the look-and-feel features of each application?
  7. What interface will you choose?
  8. What input and output devices will you offer to employees?
  9. How will you provide accessibility for all?
  10. How should you document your project?
  11. What will your user instructions say and how will you deliver them?
  12. What type of data will you record and manipulate?
  13. Will you allow employees to submit reports?
  14. If so, how should these look?
  15. What data will they contain?

SOL Correlations

Mathematics: COM.1, COM.2, COM.3, COM.4, COM.5, COM.6, COM.7, COM.8, COM.9, COM.10, COM.12, COM.13, COM.14, COM.15, COM.16, COM.17, COM.18, COM.19, COM.20, A.1, A.2, A.3, A.5, A.6, A.7, AFDA.1, AII.4, AII.6, AII.7, DM.3, DM.4, DM.11, G.1, G.3, G.11, G.14, T.6
English: 11.4, 11.7, 11.8, 11.10, 12.4, 12.7

Project-Based Assessment

Assess outcomes, using a rubric such as the following:

Programming Rubric
http://www.svcc.edu/~megillk/programming_rubric.htm