How to include drag and drop codes into your VB project

ICT Virtual Dictionary Project

 Let´s use Visual Basic in order to create your own aplication on ICT glossary

Design the password form like this.



Create and complete this menu using the tool menu editor.

           For example.

Computer Networks

http://www.functionx.com/networking/index.htm

Computer Networks

Visit this link and then answer these questions.
Use Prezi to show your knowledge about this topic.
What is a Network?
What is Networking Hardware?
•File Servers
•Workstations
•Network Interface Cards
•Switches
•Repeaters
•Bridges
•Routers
What is a Protocol?
What is Network Cabling?
Wireless LANs
•Advantages of wireless networks
•Disadvantages of wireless networks
What is a Topology?
Main Types of Physical Topologies
Considerations When Choosing a Topology
What is a Network Operating System?
• Peer-to-Peer
•Client/Server

Today we go on working with ACCESS

Remember:
A database is composed of several data tables related to each other by a key field.
Table: The set of rows (records) and columns (fields).
Records: A set of fields for a particular entity.
Fields: Information items contained in each record.

Don't  forget: You must compress the file to send by mail.

Senior III B

Database Test on September 2

Senior III A

Written Test about Data types August 29
Database Test on September 5

Senior III "B" 09/07/2011 - Practical Work of Module 5 from the book

THE FOLLOWING PRACTICAL WORK MUST BE SENT BY EMAIL TO THE TEACHER NO LATER THAN FRIDAY 15th AT NOON: These questions must be answered in a word document.  The "hard copy" (the printed document)  must be handed in to Gabriela at the beginning of the next class on August 5th.  The document must have its proper header and footer.  These questions will be included in the next written test that will have place on August 12nd. 

Questions

Data Base Manager System

A database is composed of several data tables related to each other by a key field.

Table: The set of rows (records) and columns (fields).

Records: A set of fields for a particular entity.

Fields: Information items contained in each record.

1. CREATE THE TABLES FOR A LIBRARY DATABASE

Tables to create:

• books
• authors
• students
• loans

Perform data entry: 20 records in books table, 10 records in the authors table, and 30 entries in the table students and 15 records in the table loans.

Data Type and organisation

Create a presentation with USERFORMS about this topic.

Use this web site http://www.igcseict.info/theory/5/index.html  and the information that you can find in Module 5.

Using a Word Processor...

You are going to produce a report about INPUT AND OUTPUT DEVICES.
Take in mind that you have to include

• a cover page,
• a table of contents
• foot references
• glossary with these terms:

SENSORS-QWERTY KEYBOARD-CONCEPT KEYBOARD-NUMERIC KEYPAD-TOUCHPAD-TRACKERBALLS-GRAPHICS TABLET-STYLUS-MIDI KEYBOARD-REMOTE CONTROL-OCR-OMR-MICR-BAR CODE-MAGNETIC STRIP-CHIP AND PIN READERS-ANALOGUE DATA-DIGITAL DATA-SENSORS-CRT-TFT-HEATERS-MOTORS-BUZZERS.

Use the IT book and the IGCSE web site to look for information.

The main title must be Input and Output Devices.
The titles to present each subtopic are going to be

• Different types of input device

Manual input devices
Direct input systems
Sensors

• Output devices and their uses

Monitors
Printers and plotters
Speakers
Control devices

Next practical test on Excel

Senior II A May 16
Senior II B May 20

Learning how to use other functions...

Clic here

Today finish the spreadsheet...

Hand in to me (by mail) the exercise in Excel. Don't forget to include graphics (pie charts and histograms)

Analysing Data Spreadsheet

• Remember to hand in to me (by mail) your PPT about Types and Computers Components.
• Take in mind that you'll have a test on next week (April 29th)

TODAY WE HAVE A PRACTICE EXERCISE. USE EXCEL TO SOLVE IT.

About the first ICT Test...

Senior III A   April 25
Senior III  B   April  29
Topics:

• Types and Components of a Computer System (chapter 1)
• About Excel Glossary, you have to know the meaning of these terms:

1. absolute reference
2. active
3. cell
4. cell reference
5. cell style
6. chart area
7. chart tips
8. chart title
9. chart type
10. formula
11. format Cells
12. function
13. relative reference
14. range
15. spreadsheet
16. worksheet
17. workbook
18. .xls

Excel Functions

Visit these sites:

Functions.


Glossary

BIBLIOGRAPHY

THE MAIN BOOK FOR THIS SUBJECT IS:
TITLE: Cambridge IGCSE ICT Coursebook (with CD-ROM)
(Information and Communication Technology)
Author: Leadbetter, C. and Wainwright, S.
ISBN: 9780521179119
Published in 2010 - Edition: 1
Published by Cambridge University Press, The Edinburgh Building, Cambridge, CB2 8RU, United Kingdom
Senior III A SHOULD BRING IT ON APRIL 11
Senior III B SHOULD BRING IT ON APRIL 15

Types and Components of a Computer System

Prepare a presentation about this topic using the information that you find in module1.pdf
Take in mind these tips:

• Be creative
• Organize data using hyperlinks
• Include pictures in order to illustrate concepts

Open the document with questions that is in your folder and answer them using one slide per question. Answer them using smartarts.
Hand in to me your ppt (by mail).

Diagnosis Period Activity

Today you have to finish the worksheet.
Take in mind these functions:

•  COUNT IF
•  SUM IF
•  VLOOKUP
• FRECUENCY
•  SUM
•  IF

Visit this web site...

http://www.igcseict.info/index.html

02/03/2011 - Welcome to ICT Classes!!!

"The" book is...
Cambridge IGCSE ICT Coursebook with CD-ROM
(Information and Communication Technology)matches the requirements of the revised University of Cambridge International Examinations ICT syllabus (0417). The book and CD-ROM are written by experienced IGCSE teachers and examiners, and is endorsed by Cambridge, ensuring that it is up to date and comprehensive in its coverage, with recent developments in ICT and its effects on our lives.
Author: Leadbetter, C. and Wainwright, S.
ISBN: 9780521179119
Published in 2010.
Edition: 1
Published by Cambridge University Press, The Edinburgh Building, Cambridge, CB2 8RU, United Kingdom