Programming High School Graduate TIC

TIC programming and New Technologies.

High school graduate of Sciences, Arts and Social Sciences.

course 2006_07

Introduction.

The computer science forms already part of our modern, coarse culture to observe that there are already phenomena related with her that have effects economical and socially in our relations in an important way. The computer science has worked in in a decisive way into different areas of the company|society, of the productive ones until those of consumption.

The existence of the great amount of information that is produced and is transmitted every day in the world makes necessary that him citizens develop capacities that allow them to obtain and to select the information in accordance with its|his|her|their needs and to have elements at the same time of critic analysis to appraise|value it in an every time more global context.

Our curricula of high school|school leaving certificate will have to include necessarily some studies that allow the pupil to attain the knowledge of computer science that will be necessary to him|her in back|posterior studies or to|in the university or to|in the formation|training professional from superior|upper degree. Likewise, apart from this purpose of preparation from back|posterior studies, the studies of computer science to high school graduate have to have the final goal to prepare citizens for one reality social, economic|economical and cultural. The computer science is an added value when incorporating to the my Work.

The contents of this optional one of high school graduate will have to guarantee some minimum knowledge common to all the high schools|school leaving certificates, completed with some knowledge specific to agreement to|in the modality of the high school|school leaving certificate chosen by the pupil.

With regard to the contents of the subject, we have to distinguish the modalities and other from patent medicines among some contents common to all of them for the concrete modality.

The aspects|looks with respect to contained common to all modalities that have to work sleep those which|who it make reference to notions of the components of software and hardware that they|who intervene in a computer system and the relation|relationship among these. Also the pupil has to dominate in facility the utilization of the main office automation tools, it|he|she has to have notions regarding the design and utilization of data bases, and has to know some tools for the edition of image, sound and elaboration of multimedia presentations like by exchange of information, it will also be important to make work about an every time more important aspect|look that is that of the communication and the nets of computers.

The concrete contents regarding the modality of arts and social sciences are those that make reference to the edition and make up of documents and to|in the data processing statistical. People will have to penetrate also in the utilization of multimedia software, of design of presentations and creation of animation.

Him evident that one of the methodological tools to use in this subject it is that of the resolution of practical problems, the nature of these problems will have to be set in a context to|in the concrete modality of high school|school leaving certificate.

The introduction of the computer science in the curricula of the subject of Technology at all the levels of the compulsory secondary education, the every time most evident possibility of the pupils to access easily in a computer, and the improvement in your computer endowments of the educational centers, they make think that that they arrive to first of high school|school leaving certificate will be the level of computer science knowledge of the pupils of every time best. A challenge, therefore, him to keep on adapting the level and the deepening of the curricular goals to|in this reality.

On the other hand, the computer science is one area where the changes and the improvements keep on being produced at a great speed, and therefore this subject should be capable of assuming these changes and evolving with them. If we intend to transmit some knowledge of computer science updated, it will be necessary to make work with the last tools, this will imply a constant effort of endowment and of formation|training of the teaching staff.

the idea about revision and adaptation in the face of the novelties, is one of the attitudes that the ours pupils should acquire. the pupil should attain also a critical attitude in the face of the impact of the information technology in our company|society, and a consciousness of the benefits|profits as well as also of the bad use that can be made of this technology. The computer science as a tool has to be promoted by the exchange and the understanding of the cultural diversity.

An aspect|look that we do not have to forget him the referring to the language|tongue, which he ties for us to our social and cultural reality. The need to use versions of software, in so far as it|he|she is possible, in Catalan language|tongue, as well as to know the correct terminology in our language|tongue has to be insisted on. Also the use of this in the elaboration and distribution of information about computer support has to be fostered.

With respect to the tools to to use, a resolution of the parliament of the Balearic Islands in session of the 6, 7 and 8 November of 2001 urges to|in the utilization of codes of open sources software, therefore when choosing the software about the that to make work should be prioritized the choice of software of this type.

General goals.

1. Knowing the incidence. of the information technologies in our company|society, its|his|her|their evolution and its|his|her|their future.

2. Developing in the students a positive attitude frontage the computer environment through the acquisition of certain skills that they enable for them for a future selfformation|selftraining.

3. Using correctly the concepts and the terminology, in Catalan language|tongue, of the world of the Computer Science.

4. Understanding and using correctly the basic elements of interaction with the computer through an operating system of graphic|graphical environment.

5. Knowing the basic functioning|operation of the nets, to exploit|explode the resources that they offer us and to enable to the pupil to elaborate and to share information generated by him.

6. Handling with fluency|fluidity the advanced functions of a software of desktop publishing and make up, being capable of exploiting any with the help of its|his|her|their documentation.

7. Knowing and using correctly the software for the resolution of numeric|numerical and statistical problems of type.

8. Understanding the basic concepts of the design of the data bases and to enable to the pupil to be able to sustain them and to explode.

9. Knowing and using correctly the software that allows to integrate multimedia elements different|distinct, to design presentations and to create animation.

Specific goals.

1. Knowledge of the basic operations of a graphic|graphical environment Windows.

2. You of a word processor when making documents of diverse characteristics: personal cards|letters, labels, article|item of a newspaper.. etc.

3. Basic notions about the language of data bases, to create, to introduce and to list datum of a data base.

4. Knowing the basic structure of a spreadsheet. You of its|his|her|their power and application when making determinate documents (current accounts, medicions, receipts...) ó to study determinate phenomena related with other areas of study.

5. Achieving when handling, copying, keeping and sorting ó archives|files of datum on the part of the pupil of a certain experience "to arrancar" programs with the graphic|graphical environment Windows or other like the different Linux distributions.

6. Achieving that the pupil has a certain experience in the resolution of small computer problems like: making to go a printer with a program, to make a backup copy in disquets...etc.

7. The acquisition on the part of the pupil of concepts and basic terminology on the world of the communications and the nets of extensive area, about the computer viruses, the peripherals of a PC and the Multimedia Technology.

General attitudes.

1. Appraisal of the influence that has the utilization of the Computer Science and of the new technologies in general to|in our company|society.

2. Accurate utilization of the computer system and respect for the rest of users.

3. Interest in using correctly the terminology typical of the world of the Computer Science.

4. Interest in developing the autonomy of the learning.

5. Ethical attitude in the use and the broadcast|diffusion of the information.

6. Accurate and prompt presentation of any document.

7. Tolerance and generosity towards its|his|her|their colleagues|partners and interest for the work in group.

8. Acquisition of an attitude of research and of curiosity as for the use of new software or of new versions.

9. Demonstration of a positive and critical attitude in the face of the corrections, disposal|disposition to|in the selfevaluation and selfdemand in the consolidation of the contents.

TIC Art High School Graduate and Social Sciences

Contents.

1. Introduction to the computers. General concepts.

2. The processing of datum and the Computer Science. Historical evolution of the Computer Science and trends of future.

3. The digital information. The one stored of the information.

4. The computer and their components. The peripherals.

5. The nets of computers.

6. EI software. Type. The computer applications of the humanistic and social area.

7. The persons. New professions derived from the use of the computers.

Procedures.

1. Recognizing the contributions of the computers and peripherals of the market.

2. Experimenting with the different|distinct elements of the computer.

3. Knowing how to handle the measures of capacity by heart.

4. Distinguishing among the different types of software. Installing applications.

2. The operating systems.

Concepts.

1. Basic functions of the operating system.

2. Type of operating systems.

3. Structuring of the information in the machine. Files.

4. The nets of local area and the sharing of resources.

5. The utilities.

Procedures.

1. Using the options of an operating system of graphic|graphical environment at level of user with skill.

2. Connecting the more general hardware of use.

3. Installing the more general software of use.

4. Sharing archives|files and resources through a net of local area.

5. Managing units, folders and files in a suitable way.

6. The communication networks of widespread area.

3. The communication networks.

Concepts.

1. Telematic. Telematic services.

2. Elements necessary for the connection in|on The nets of widespread area.

3. The information in The nets of widespread area.

4. EI specific software for the generation of material to publish in|on The nets.

Procedures.

1. Sailing through the information that the nets of widespread area provide.

2. Research of useful information for afterwards to be able to treat it|her, to manipulate and to exchange.

3. Generating own material and publishing it in the international nets making use of the specific software.

4. The word processing.

Concepts

5. Advanced functions of a word processor.

6. Integration of graphs and images in a text.

7. EI software for the make up.

8. The staff|templates.

9. The macros.

Procedures.

10. Using correctly The advanced functions of a word processor for generating documents.

11. Integrating graphs and images in a document of text.

12. Manipulating long documents with skill.

13. Using a software of make up.

14. Designing staff|templates and implementing them.

15. Describing and implementing macros.

5. Treatment of numerical information.

Concepts.

16. Elements of a spreadsheet.

17. Graphic|Graphical representation of information with a spreadsheet.

18. The macros to|in the spreadsheets.

Procedures.

20. Using correctly The functions that any spreadsheet provides for the resolution of numeric|numerical problems.

21. Showing|Presenting the results graphically.

22. Describing and implementing macros.

23. Using a software for the statistical treatment of information.

6. The data bases.

Concepts.

1. The data bases.

2. Conceptual design.

3. Maintenance and consultation|consulting|surgery.

4. The certainty|security.

Procedures.

1. Designing a simple data base from a heading|utterance.

2. Implementing the data base from its|his|her|their design making use of a business agent of data bases.

3. Making the maintenance of the information of the data base.

4. Carrying out consultations|consultings|surgeries against the data base.

7. The multimedia one.

Concepts.

1. Image, sound and video.

2. The different|distinct ones formed from archives|files.

3. Software for the capture and treatment of image, sound and video. 4. Software for the integration of text, image, sound and video.

Procedures.

1. Identifying the different ones formats of archives|files of image, sound and video.

2. Capturing and manipulating image, sound and video making use of the hardware and suitable software.

3. Constructing multimedia presentations using a software that allows to integrate text, image, sound and video.

TIC Science High School Graduate.

1. Introduction to the computers

Concepts.

1. The processing of datum and the Computer Science. Historical evolution of the Computer Science and trends of future.

2. The digital information. The one stored of the information. The computer and its|his|her|their components. The peripherals.

3. The nets of computers.

4. EI software. Type. The computer applications of the scientific area.

5. The persons. New professions derived from the use of the computers.

Procedures.

1. Recognizing The contributions of the computers and peripherals of the market.

2. Experimenting with the different|distinct elements of the computer.

3. Knowing how to handle The measures of capacity by heart.

4. Distinguishing among the different types of software. Installing applications.

2. The operating systems.

Concepts.

1. Basic functions of the operating system.

2. Type of operating systems.

3. Structuring of the information in the machine. Files.

4. The nets of local area and the sharing of resources. The utilities.

Procedures.

1. Using the commands of the operating system at level of user with skill.

2. Connecting and configuring the more general hardware of use.

3. Installing and configuring the more general software of use.

4. Sharing archives|files and resources through a net of local area.

5. Managing units, folders and files in a suitable way.

3. The communication networks.

Concepts.

5. Telematic. Telematic services.

6. Elements necessary for the connection in|on The nets of widespread area.

7. The information in The nets of widespread area.

8. EI specific software for the generation of material to publish in|on The nets.

Procedures.

4. Sailing through the information that the nets of widespread area provide.

5. Research of useful information for afterwards to be able to treat it|her, to manipulate and to exchange.

6. Generating own material and publishing it in the international nets making use of the specific software.

4. Office automation.

Concepts.

1. Advanced functions of a word processor.

2. Integration of graphs and images in a text. Capture and manipulation of image.

3. Treatment of the graphic|graphical cheerful and sound information. Capture and manipulation. EI multimedia software.

Procedures

1. Using correctly the advanced functions of a word processor for generating documents.

2. Integrating graphs and images in a document of text making use of the hardware and software suitable.

3. Capturing and working with graphic|graphical cheerful and sound information and handling a software with skill for elaborating multimedia presentations.

5. Treatment of numeric|numerical information.

Concepts.

1. Elements of a spreadsheet.

2. Graphic|Graphical representation of information with a spreadsheet. The macros to|in the spreadsheets.

Procedures.

1. Using correctly the functions that any spreadsheet provides for the resolution of numeric|numerical problems.

2. Showing|Presenting the results graphically.

3. Describing and implementing macros.

4. Using a software for the mathematical and scientific treatment of look information.

6. The data bases.

Concepts.

1. The data bases.

2. Conceptual design.

3. Maintenance and consultation|consulting|surgery.

4. The certainty|security.

Procedures.

1. Designing a simple data base from a heading|utterance.

2. Implementing the data base from its|his|her|their design making use of a business agent of data bases.

3. Making the maintenance of the information of the data base.

4. Carrying out consultations|consultings|surgeries against the data base.

7 . The languages of programming.

Concepts.

1. The languages of programming.

2. Algorism and coding.

3. The structures of control. 4. The structures of datum.

4. The functions and the procedures.

Procedures.

1. Describing the algorithm of a heading|utterance with the suitable structures of datum and of control.

2. Coding the algorithm in a language of high level previously clear-cut.

3. Purifying and executing the coded program.

Time and dates.

The foreseen development of the sessions is summarized on the table of low except unforeseen changes that can come out along the course.

20-09	Initial evaluation and previous knowledge. Filling in the card of pupil with particulars, type of computer, courses... etc.
22-09	Handbook\|Manual of Computer Science pupils. Comments
28-09	Completing the document General Concepts Batx.doc with different consultations\|consultings\|surgeries in\|on the Internet net. Adding terms like RDSI, ADSL, Javascript, Hacker, Cookie, Applet... etc.
30-09	Finishing the Concept Questionnaire Generals.doc with the consultation\|consulting\|surgery of documents: · He\|She\|It chronicles of the Informàtica.doc · Hardware PC.doc
02-10	Introduction to the digital edition of documents. Personalitzar el Word, to broaden the personalized dictionaries
06-10	Basic knowledge of the Windows systems. Other operating systems. About net of the Center. Practices.
14-10	Materials of Word 1ª Delivery Work with preformatted documents, you of headboards\|headlines and feet of page. Aspects\|Looks of design, styles and sections.
22-10	Materials of Word 2ª Delivery. Practices and final Questionnaire.
05-11	The multimedia, different documents formats of presentation. The most suitable for publishing in\|on the net. Multimedia Presentations. Introduction Adaptation of materials of the www.xtec.es
07-11	Elements of design Digital image Digital sound Practices with the programs Digesting Shop 7.0, Music Time and Cool Edit.
08-01	Formality\|Management of data bases. The program Access
13-01	Creation and design of tables. Importing datum Relations\|Relationships among tables of a same basis
28-01	Consultations\|Consultings\|Surgeries and updates\|updating Groups of datum and forms
10-02	Dynamic tables and graphs with Access Examples and final practices. All the materials on the page: http://www2.infotelecom.es/~ecampins/Materials/Batxiller/Access.
17-02	Introduction to the spreadsheets. Exsky, previous considerations Concrete and material examples to\|in the address: http://menorca.infotelecom.es/~ecampins/Materials/Batxiller/Excel
28-02	Development of the practices of the Módul 1 and Módul 2
11-03	Modul_3. Lists and groups of datum. Final examples
17-03	Three concrete projects. Applications

31-03	Introduction to the Telecommunications The Internet net
07-04	Services and applications Practices 1ª and 2ª Delivery. Final questionnaire

28-04	Introduction to HTML Edition and publication of documents in\|on the Internet net.
08-05	Works 3rd Term. Publications and revision of the works Selfevaluation Questionnaire matter\|subject.
16-06	Qualifications and evaluation of the group. (Practices of group, theory and works to make stockings of the pupils.)

Methodology.

The matter|subject will have a look more practical than theoretical and the teacher will devote the majority of the time|weather in this sense to advising the pupils in the practices that will be carried out along the course. In principle the different materials will be in digital format (.pdf. warehouse or. html) they will share|distribute you photocopy only of those materials that are considered more important.

At the beginning of each thematic block, the teacher will attempt to give a general vision of the application that will be using utilitzada,( if it|he|she made mistake the projection of the screen of the computer about a visible support to all pupils, with explanations and demonstrations|shows at the same time|weather) it|he|she will distribute the photocopied documentation that he|she|it considers necessary, for afterwards to go|pass to giving the pupils a listing of exercises - activities that they will carry out forming reduced groups of a maximum of two pupils in the possibilities of the classroom. It is intended with this to guarantee the general and specific goals of each thematic block.

The information technology, in general, and the computer science, in particular, disciplines of a strong instrumental character are. Therefore, he|she|it agrees on insisting a lot on the computer science as a means and not as a purpose by itself|herself. Activities of education/learning have to be thought for making the useful applications for the pupils available in other curricular areas, as well as the possibilities and new fields that he|she|it opens them. The activities have to be fundamentally practices. However, solid and clear concepts have to be based so that the pupil/to happen an intelligent user of the computer tool. That is, that he|she|it knows how to use the computer science in several situations, to choose the most suitable tool, to use the different ones made possible of research of information that gives us, to know specific software that leaves to the market, to connect the new peripherals correctly... etc.

Evaluation.

The teacher will appraise positively the assistance to the classroom and the realization of the different practices that will be carried out during the course.

They will be made, Concepts General, Managing of data bases and Nets of communications, Internet, services and applications, only 3 theoretical written tests along the course about concepts and procedures worked in the classroom of computer science.

The final note of course of a pupil will come out of the half an arithmetic of all the evidence|tests of theory together with the notes of practices that the pupil at the different didactic units obtains.

Specific tests.

1) Resolution of practices and exercises with the PC. (Maximum 2 pupils)
2) Evidence|Tests of knowledge and theory.
3) Degree of participation|shareholding in the practical sessions in group.

Criteria and Procedures of Evaluation.

1) Each pupil will have numeric|numerical notes corresponding to written tests with questions related to concepts and procedures of the didactic unit. Notes numeric|numerical of practices of group in front of the computer about the different didactic units worked in the classroom.

2) The assistance to the classroom and the realization will be appraised positively correct of the practices with the computer, individually ó in group. When a pupil overcomes the 3 mistakes not justified in a term, it|he will be able to be evaluated by each session that is missing with -0,5 points in|on the practical part of that Didactic Unit.

3) The final note of each pupil will be obtained for half an arithmetic of the notes obtained at the different Didactic Units.

Ciutadella, 8 September 2006