Business Technology (Computer Education II)

I. Review of Basic Concepts in Computer Operations

1. Demonstrate basic knowledge of computer operation concept

• Discuss the difference between data and information
• Differentiate between syntax and semantics
• Discuss the natural approaches to problem solving
• Trace the steps in problem solving
• Explain why learning to program is valuable
• Show understanding on the use of computer files
• Discuss how programs are being processed
• Observe the safety measures in the operations of the computer systems

II. Introduction to Basic Programming

1. Demonstrate the skills on basic programming

1.1 Define algorithms
1.2 Describe what a flowchart is
1.3 Differentiate the major types of flowcharts
1.4 Enumerates the uses of the flowcharts
1.5 Explain the advantages and disadvantages of flowcharts
1.6 Discuss the following symbols which are being used for flowcharts

• Rectangle (processing)
• Parallelogram (input/output)
• Diamond
• Connector box
• Flow lines or arrow lines
• Start box or finish box

1.7 Identify a flowcharting template
1.8 Enumerate the notation used in flowcharting
1.9 Explain how looping in flowcharting is used
1.10 Cite the functions of counters in flowcharting
1.11 Follow the steps in loop control

• Initialization
• Test for limit condition
• Incrementation

1.12 Point-out the importance of trailer record
1.13 Perform how flowchart facing is done
1.14 Identify the functions of the accumulator
1.15 Design a well-organized flowchart

III. Using Databases

1. Manifest functional knowledge and skills on the use of data management packages

1.1 State the importance of database
1.2 Define the concepts/terminology of databases

• Field
• Records
• Files

1.3 Discuss field descriptors
1.4 Differentiate between file processing and database management
1.5 Discuss the steps involved in planning database files
1.6 Perform different operations in file processing

1.6.1 Creating the database files
1.6.2 Defining the structure of the file in terms of the fields
1.6.3 Using a data entry screen in entering the information
1.6.4 Listing the records on the file in desired order
1.6.5 Searching for a particular record or listing all records on the file with some special characteristics
1.6.6 Creating the report format to be used
1.6.7 Outputting the information in the desired report format

1.7 Perform indexing and sorting data base records
1.8 Identify how changes are make in database files
1.9 Explain the differences between relational, hierarchical and
network models
1.10 Perform the operations in working with relational database
management system
1.11 Discuss common problems and pitfall and their solutions on:

• Improving sorting speed
• Maintaining data integrity
• Avoiding deletion error
• Avoiding data loss

1.12 List the considerations in selecting a database management for personal computers

IV. Introduction to HTML

1. Demonstrate skill on basic website creation

1.1 Explain the meaning of Uniform Resource Locator (URL)
1.2 Describe the parts of URL
1.3 Explain the meaning of Hyper Text Markup Language (HTML)
1.4 Describe the structure of an HTML document
1.5 Discuss the process of formatting text
1.6 Differentiate logical and physical character attributes of HTML
1.7 Discuss the different list types of HTML supports

2. Demonstrate knowledge and skills in creating HTML pages using word processing

1.1 Discuss the easy ways in creating web pages through word processing
1.2 Describe the steps in creating a web page from wizard or template
1.3 Perform steps to create a web page

1.3.1 Accessing file menu
1.3.2 Clicking New, then clicking Web Page Tab
1.3.3 Double clicking Web Page Wizard
1.3.4 Adding or changing text or formatting
1.3.5 Saving a word document in HTML format

1.4 Publish web site to the internet

Courtesy of:

Mr. Antonio B. Venegas Jr., ICT Coordinator, Samal NHS
Mr. Allan O. Lamon, ICT Assistant, Samal NHS
Mrs. Emmalina G. Galagnara, SSP I, Samal NHS

Next: Introduction to HTML