# CTE Resource Center - Verso - Computer Information Systems, Advanced Instructional Scenarios

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Instructional Scenarios

“FBLA Word Processing Competitive Event”
Duty/Concept Area: Using Advanced Word Processing Functions

Your FBLA Chapter is sponsoring a competitive event to determine who will represent the Chapter at the Regional Leadership Conference. You have been asked to create attractive certificates and congratulatory letters to be presented to event winners from all of your Computer Information Systems, Advanced classes.

Big Question: What is the most efficient way to create a large number of certificates and letters?

Focused Questions:
  1. How will you determine which software program you will use to create the certificate?
  2. What information will be included on the certificate?
  3. What design elements will you include on the certificate?
  4. What data will you need about your members to create a source document?
  5. What fields will you include in your congratulatory letter?

Project-Based Assessment:
  1. Certificate that has an appealing design and includes all essential information
  2. Data source document and congratulatory letter that includes complete and accurate information for winners

“Preparing a Software Sales Summary for Virginia Software, Inc.”
Duty/Concept Area: Using Advanced Spreadsheet Functions

You have been hired as a new employee at Virginia Software, Inc. Your primary responsibility is to track the sales of a variety of game, business, and utility software products to determine monthly software sales. Software is available in both Windows and Mac formats. Your boss has requested that you prepare monthly and quarterly reports (including graphs) to submit to the management team.

Big Question: How will you create a quarterly software sales summary for management that will provide key data for analysis and decision-making?

Focused Questions:
  1. What worksheets will you need to create for the first quarter?
  2. What types of software will be included in each product line?
  3. What financial information will be needed to determine software sales by category for Windows and Mac operating systems each month?
  4. What formulas will be needed to calculate totals?
  5. What type of graph will best provide management data for analyzing sales trends?

Project-Based Assessment:
  1. Monthly worksheets that track software sales for each product line and operating system
  2. Quarterly sales summary
  3. Graphical information to display product sales data

“Creating a Relational Database for Video Rental Outlets”
Duty/Concept Area: Using Advanced Database Functions

Your boss has asked you to set up databases to track employees, inventory, and customers at the company’s two new video rental outlets. Your first task will be to set up a database for the video endeavor, using relational database application software. You will name the database VIDEO.

The first data table you need to create will be called PERSONNEL. This part of the database will include information about employees, such as full name, address, hourly earnings, employee number, store, and start date. Each rental outlet has five employees.

The second data table you need to create will be called INVENTORY. This part of the database will eventually contain all the videos that each outlet has available to rent. You probably will want to create a numbering system for the videos at each store. Since the rental outlet is new, you will input only 30 videos for each store.

The final data table you will have to create for the new VIDEO database will be for the members (customers) of each outlet. Because this is a new venture, each outlet currently has 25 members. You will create a data table and call it MEMBERS.

Big Question: What process will you use to create a relational database that will provide the company with information they need to manage and make decisions about the operation of the two rental outlets?

Focused Questions:
  1. What process will you use to analyze the company’s needs for information regarding the video rental outlets?
  2. What information fields will be needed for each data table?
  3. What type of customer information will you need to keep track of for the two outlets?
  4. What types of specialized printouts do you think will be needed by the company’s management?
  5. How will the company benefit from use of relational database application software?

Project-Based Assessment:
A relational database for the company’s two rental outlets that includes data tables for employee information, video inventory, and customer (member) information. The database must contain complete and accurate information for the rental outlets that will assist supervisors in managing them.


“Creating and Enhancing a Presentation on Strategic Web Page Design”
Duty/Concept Area: Enhancing Multimedia Presentations

As a Web master at Creative Web Designs, Inc., you have been asked to make a presentation on Strategic Web Page Design at a local high school’s career fair. Your manager has suggested that you prepare a multimedia presentation incorporating advanced features and enhancements.

Big Question: How will you design an effective presentation on Strategic Web Page Design that is visually appealing and keeps the attention of your audience?

Focused Questions:
  1. What software will you use to create your presentation?
  2. What are the objectives of your presentation?
  3. What key points will be included regarding strategic Web page design?
  4. What advanced features and enhancements will you include in your presentation?
  5. What audio and visual elements will you incorporate into your presentation?
  6. What method of delivery will you use for your presentation?

Project-Based Assessment:
A multimedia presentation that includes key points for designing strategic Web pages and incorporates advanced features, enhancements, and visual/audio elements


“Creating a Professional Newsletter for a Desktop Publishing Business”
Duty/Concept Area: Producing Desktop Published Documents for Print and Electronic Distribution

You are employed as a desktop publishing specialist for Micronet Computer Services. Your supervisor has assigned you the task of designing and creating a professional newsletter (in color) that informs customers of the business and the services you provide. Your supervisor also suggests that you include some topics of general interest, such as state-of-the-art software available for a variety of uses, computer-related career information, and a “tips and tricks” column addressing topics that might help customers use their software more effectively. To add impact, the newsletter should include advanced layout and design features.

Big Question: How will you design and lay out a professional newsletter that provides key information, generates interest among your customers, and meets the expectations of your supervisor?

Focused Questions:
  1. What types of information will you include in your newsletter?
  2. How will you determine which topics of general interest to include, and how will you conduct the research on the topics you select?
  3. What software will you use to lay out the publication?
  4.  What graphical elements will you use to add impact and interest to your publication?
  5.  What steps will you take to make sure that your newsletter is camera-ready and free from errors?

Assessment Guidelines:
  • Key Information: The newsletter contains key information about the business, including contact information and a description of services provided for customers.
  • Layout Headlines and Captions: All articles have headlines that capture the reader’s attention and accurately describe the content. Graphics have captions.
  • Layout – Columns: Columns are neat. There are adequate and consistent “gutters” between all columns and articles. A glance at the newsletter makes the reader think “professional.”
  • Layout – Flag: The name of the newsletter is appropriately placed and is in a font that makes it stand out from other content. The date and edition of the newsletter appear below the name in a smaller font.
  • Graphics: Graphics and pictures are in focus, well cropped, and clearly relate to the articles they accompany.
  • Features to Enhance Newsletter: Special features are used to enhance the effectiveness of the newsletter such as dropped capitals, tables, ruling lines, headers and footers, multiple columns, text boxes, graphics, and shading.

Project-Based Assessment:
A professional newsletter, with a minimum of four pages, that follows established layout and design principles and incorporates features such as drawing objects, dropped capitals, tables, charts, ruling lines, headers and footers, multiple columns, text boxes, graphics (including scanned images or images from a digital camera), page and/or paragraph borders, current date, page numbers, and shaded paragraphs. The newsletter must include key information about the business, including contact information and a description of services provided for customers. It should include special features as specified by the supervisor and must be camera-ready with no errors.


“You’re Hired as a Web Master for Creative Web Designs, Inc.”
Duty/Concept Area: Designing and Producing Web Pages

You have just been hired as a Web master for Creative Web Designs, Inc. Your first assignment is to create a Web site for the Office of Career and Technical Education Services at the Virginia Department of Education. Your supervisor plans to meet with you in two weeks to review your plan for completing the project and to determine the progress you have made.

Big Question: What major steps should be undertaken to develop a Web site that will meet your client's needs?

Focused Questions:
  1. What questions will you ask during your initial meeting with the client?
  2. What will be included in your Web site plan or sketch?
  3. What main categories of information do you think you will need to include in the Web site?
  4. What type of theme will you use throughout the Web site?
  5. What graphical elements will you need to design or secure from the client to include on the Web site? What elements will you include to make the Web site easy to navigate?
  6. What advanced features will you incorporate into the Web site (e.g., frames, forms, search features, drop-down menus, image maps, audio and/or visual elements)?

Assessment Guidelines:
  • Content: Pages contain appropriate titles and structure.
  • Page Layout: Pages demonstrate careful thought about the order in which information is presented.
  • Graphics: Pages contain appropriate graphics, including an appropriate background and simple layout.
  • Navigation: Major section headings are clear and easy to understand. Links are logical and easily followed. Index page links to all pages on site and all other links work properly.
  • Design: The pages are well organized and include a table or bulleted list, horizontal rules, and paragraphs.
  • Information: Information is creatively written and contains no errors.
  • Advanced Features: Site incorporates advanced features.

Project-Based Assessment:
  1. A list of key questions that would be asked of the client at an initial meeting
  2. A professional Web site that incorporates advanced features, enhancements, and visual/audio elements


 “Developing a Maintenance and Troubleshooting Brochure”
Duty/Concept Area: Maintaining, Managing, and Troubleshooting Systems

As a student in Computer Information Systems, Advanced, you have had instruction and experience in maintaining and troubleshooting computers and printers. Your instructor wants to capitalize on your expertise and experience. He has asked you to create a “Maintenance and Troubleshooting” brochure that can be shared with students in computer-related classes.

Big Question: How will you approach the task of compiling and designing a brochure that contains key information, procedures, and tips for maintaining and troubleshooting the computers and printers in your laboratory?

Focused Questions:
  1. What key topics will you include in the brochure?
  2. What maintenance guidelines will you include in the brochure?
  3. What troubleshooting procedures and tips will you include in the brochure?
  4. What software will you use to lay out the brochure?
  5. What graphic elements will you use to add interest to your brochure?
  6. What special features will you use to give a professional look to your brochure?

Project-Based Assessment:
A brochure that contains key information, procedures, and tips for maintaining and troubleshooting computers and printers. The brochure must follow established layout and design principles and incorporate graphic elements and special features that enhance the professionalism of the brochure.


“Creating a Presentation on Networking”
Duty/Concept Area: Executing Networking Activities

Your instructor has asked you to design a multimedia presentation on networking to use at a curriculum fair. The presentation should introduce students and parents to the concept of networking and to careers/certifications associated with this field.

Big Question: How will you design a multimedia presentation that provides an effective introduction to computer networking and helps students and parents understand the career opportunities and education/training required for positions in this field?

Focused Questions:
  1. What topics will you include to introduce students and parents to computer networking?
  2. What career opportunities are available for students in this field?
  3. What certifications are associated with jobs in this field?
  4. What software will you use to create your presentation?
  5. What graphical elements will you use to enhance the effectiveness of your presentation?

Project-Based Assessment:
A multimedia presentation on networking that includes topics such as “What is a Network?,” “Types of Networks,” “Connectivity Hardware,” “Modems,” “Bandwidth,” “Communications Media,” “Network Topologies,” “Protocols,” “Local Area Networks,” “Networking Hardware,” “Bridges and Switches,” “Routers,” “Wireless Networks,” and “Network Security.” The presentation must also include information on networking careers and certifications associated with the networking field.


“Designing a Computer Program for Business”
Duty/Concept Area: Implementing Programming Activities

You are part of a programming team in charge of designing programs that perform specific tasks for your employer. The company needs budgeting, forecasting, data summary, and inventory tasks accomplished with a computer program.

Your group has been assigned to work on inventory tasks. Your group is to
  • write a problem statement and an algorithm
  • design a flowchart that performs the task
  • write the code
  • debug and test the program.

Big Question: What questions will the team need to develop prior to meeting with the Inventory Department to ensure that the computer program provides the desired output data?

Focused Questions:
  1. What is the definition of the problem?
  2. What is the scope of the problem?
  3. What known information already exists?
  4. What is the goal that you are looking for?
  5. What is the solution?
  6. What are the step-by-step procedures that will be included in a graphical diagram of your problem? Based on the graphical diagram, what are the sequences of steps that you will write in your program code?
  7. Upon running the program, did you find that you had forgotten anything?

Project-Based Assessment:
A problem statement, an algorithm, a graphical diagram of the step-by-step procedures, and a coded program that provides accurate output that meets company requirements for inventory information


“Creating an Algorithm as a Demonstration for the Class”
Duty/Concept Area: Implementing Programming Activities

In order to create computer program solutions to problems, the programmer/developer must walk through the problem-solving process. Your Programming instructor has asked you to use the problem-solving process to review the following scenario and to create an algorithm for the class as a demonstration.

Scenario: Jodi wants to wallpaper her room and needs to figure out how many rolls of wallpaper she needs to purchase to cover the room. Jodi needs to figure out the length, width, and height of room. She needs to know how many square feet each roll of wallpaper covers.

Big Question: What process is needed to create an algorithm as a demonstration for the class?

Focused Questions:
  1. What do you need to know to analyze the problem?
  2. What steps are needed to solve the problem (i.e., plan the algorithm)?
  3. How will you illustrate the algorithm with pseudocode or flowcharts?

Assessment Guidelines:

  1. Analyze the problem.
  2. Determine the steps needed to solve the problem (i.e., plan the algorithm).
  3. Walk through a scenario, and create an algorithm for the class as a demonstration.


“Creating a Copyright Laws Brochure”
Duty/Concept Area: Exploring Legal and Ethical Issues

You are employed in the Desktop Publishing Department of Dynamic Designs, Inc. Your supervisor has asked you to conduct research and develop a brochure related to copyright laws pertaining to scanned images, electronic clip art, and other elements adapted for use in desktop publishing, multimedia, and Web documents. This brochure will be used in training new employees and as a reference by all employees in the company.

Big Question: What steps will you follow in completing this important assignment for Dynamic Designs, Inc.?

Focused Questions:
  1. How many sites will you visit to verify the accuracy of the information regarding copyright laws?
  2. What format will you use to cite the sources of the information you select for use in the brochure?
  3. What type/style of brochure do you think will be the most effective for this project?
  4. How will you incorporate graphics and/or graphical elements to enhance your brochure?

Project-Based Assessment:

A brochure that outlines key information on copyright laws pertaining to scanned images, electronic clip art, and other elements adapted for use in desktop publishing, multimedia, and web documents. The sources of information should be cited. The brochure should be attractive, easy to read, and informative.