Data Management 12 - Technology Applications

PRESCRIBED LEARNING OUTCOMES

It is expected that students will:

• demonstrate proficiency in using industry-standard software (including word processing, spreadsheet, database, desktop publishing, and presentation) to accomplish advanced business tasks
• analyse a variety of business situations to determine the appropriate software to solve business problems
• demonstrate proficiency in merging data between software applications to create business documents
• use the Internet to plan, research, and develop a business project
• demonstrate proficient use of e-mail software and its applications in business
• explain implications of computer viruses
• prepare and use word processing, spreadsheet, and database software macros

SUGGESTED INSTRUCTIONAL STRATEGIES

• Invite each student to create a database for a school activity (e.g., tracking the merchandise of a school store). Then ask students to develop user's manuals for their databases and to demonstrate the manuals for potential users.
• Have each student arrange a travel itinerary using a spreadsheet and a database to compare travel and accommodation costs. Ask students to design templates and macros to store, sort, retrieve, and report the information. Then have them use presentation and desktop publishing software to present the information.
• Ask students to generate invoices using a word processing package, merging all the data from a database program. Have students establish criteria and critique one another's invoices.
• Give students a fixed budget and have them research web sites for information on office furnishings. Then ask them to prepare, using software, detailed reports on equipping and furnishing new offices for a specified business.
• Compose and save a document containing minutes and a distribution list from a class meeting using word processing software. Arrange for students to send an e-mail message to the distribution list.
• Ask students to do research on antiviral software and report on its use.

SUGGESTED ASSESSMENT STRATEGIES

• Invite students to use compatible software to create documents that import information from one program to another. Observe and note evidence that they can:
  • follow directions carefully
  • manipulate the software effectively
  • explain the processes used
  • create a single document from several source documents
• With the class, develop criteria for selecting software for a specific business application. Encourage students to use a variety of information resources and tools, including the Internet, to gather information on several products. Then ask them to use the criteria to compare them. Have them report their findings using industry-standard software. Collect their reports and record evidence that students can:
  • select and use tools and resources appropriately to locate, gather, and process information
  • recognize similarities and differences in product features
  • rank or weight the importance of each feature
  • justify selections based on various end-user needs
  • describe their findings in clear, concise language
  • effectively use software to present their findings
• Encourage students to monitor their own effective- ness in using e-mail. Ask each student to use the help feature in an e-mail program to develop checklists they can use as they develop e-mail distribution lists and send e-mail attachments. After they send e-mail messages and attachments to their distribution lists, have them ensure the messages went through properly. Ask students to use the help feature and revise their checklists as necessary.

• Desktop Publishing Practical Exercises, Second Edition
• Exploring Desktop Publishing: A Projects Approach

• Database Applications, Third Edition
• Desktop Publishing Activities
• A Guide to Microsoft Office 97 Professional for Windows 95

Previous Page Next Page

  BC Ministry of Education Home Page