IT Education and Computer Skills Guide
Uploaded by
ScribdTranslationsIT Education and Computer Skills Guide
Uploaded by
ScribdTranslationsGENERAL OBJECTIVES
To provide students with an IT education that allows them to assimilate and
apply new technologies of Information and communication.
Learn a set of basic computer concepts and procedures
that allows them to solve problems applied to other subjects or their own
half.
Develop habits and skills for interactive work with media
IT and communication.
Develop a critical attitude towards the social effects of the new
information and communication technologies.
TOPIC 1: INTRODUCTION TO COMPUTER SCIENCE
1.1. Brief History of Computers
1.2. Basic IT concepts;
1.3. Typical architecture and functioning of a Computer;
1.4. Main types of computer equipment (Hardware);
1.5. Main types of software programs;
1.6. The importance of Computer Science;
1.7. Virus and antivirus;
1.8. Computer Network;
1.9. Use of computers in science, in technology, and in all general life;
1.10. The Computer and Health.
SPECIFIC OBJECTIVES
. Identify the greatest inventions in the history of Computing;
. Computer Science
Memory (RAM), Read Only Memory (ROM), Bit, Byte, Kilobyte, etc.
. Discuss the basic components of a computer and their
functions;
. Describe how the Personal Computer (PC) works;
. Identify the main types of computer equipment
Input, output, and input/output hardware;
. Classify the main types of software programs
system, application and development programming language;
. Briefly discuss viruses and antivirus software;
. Identify the advantages of Computer Networks;
. Use knowledge of Computer Science in science, technique, and life in
general
. Take care with the computer equipment.
1
2. THEME 2: WORK ENVIRONMENT
2.1. Turn on and turn off the computer;
2.2. Main elements of the workplace;
2.2.1. Mouse Operations;
2.2.2. Start and Exit a program;
2.2.3. Windows and their manipulation.
2.3. Dialog box and list box;
2.4. The Windows Explorer
2.5. How to search for files and directories;
2.6. File and folder management;
2.6.1. Create and rename files or folders;
2.6.2. Select files or folder
2.6.3. Delete and recover files or folders;
2.7. Control Panel
2.8. Typing Course.
SPECIFIC OBJECTIVES
. Turn on and off the computer correctly;
. Change the properties of the Desktop;
. Manage and change the properties of the Mouse;
. Describe the parts and functions of a window
. Work with a dialog box / listing;
. Correctly interpret the content of the Computer;
. Show how to locate a directory;
. Use and create folder;
. Remove and recover items;
. Create and save a file (on the disk, or on another device of
mass storage;
. Basically format a text,
. Change date, currency format, and keyboard properties;
. Write correctly with the keyboard.
3. THEME 3: TEXT PROCESSING - MICROSOFT WORD.
3.1. Create a new document in Word;
3.2. Main elements of the Word window;
3.3. How to save a document;
3.4. How to save a document with access limited to registered users or
password
3.5. Document display mode on the screen
3.6. Page setup;
3.7. Document formatting
3.7.1. Character formatting (font type, style, size, underline,
spacing, effects (top and bottom) animation, spacing between
characters
2
3.7.2. Paragraph formatting;
3.7.3. Paragraph alignment;
3.7.4. Paragraph indentations (advancements and retreats);
3.8. Tables
3.8.1. Create a Table;
3.8.2. Draw a table;
3.8.3. Table limits;
3.9. Header and Footer;
3.10. Page Numbering;
3.11. How to insert an image into a document;
3.12. Index (referential and Summary);
3.13. Printing a document.
SPECIFIC OBJECTIVES
. Demonstrate how to create a document;
. Save and limit access to a document;
. Configure page;
. Use Superscripts (above the line) and Subscripts (below the line);
. Use spacing between characters, and between lines, and text animation;
. Use two or more columns for the text;
. Use uppercase letters, borders, and shading in a document;
. Demonstrate how to apply background and brands;
. Insert an image from the file, shape the text around the image
and/or WordArt;
. Create and format a table;
. Demonstrate how to insert a different header and footer on the pages
even and odd;
. Print a document.
4. SPREADSHEET - MICROSOFT EXCEL
4.1. Features of Excel
4.2. Introduction
4.3. Specific presentation of the Excel window;
4.4. Difference between book and sheet;
4.5. Formula Bar;
4.6. Sheet separators;
4.7. Columns and rows;
4.8. Cell address;
4.9. Enter data in a cell;
4.10. Through the keyboard;
4.11. Auto fill;
4.12. Custom lists;
3
4.13. Automatic conclusion;
4.14. Change the name of the sheet;
4.15. Insert spreadsheet;
4.16. Insert borders and shading;
4.17. Delete spreadsheet;
4.18. Insert data into the cell (review);
4.19. Edit the cell content;
4.20. Alignment;
4.21. Reduce and Adapt;
4.22. Unite cell;
4.23. Merge cell and center;
4.24. Format number fields;
4.25. Cell References
4.25.1. Relative References
4.25.2. Absolute References;
4.25.3. References to other sheets;
4.25.4. Simple calculations;
4.26. Configure Header and Footer;
4.27. Page orientation
4.28. Formulas and functions;
4.29. Formulas (Syntax);
4.30. Functions (Syntax): Sum(), Average(); Maximum(); Minimum(); Count(); If
COUNTIF(), SUMIF().
SPECIFIC OBJECTIVES
Explain the features of Excel;
Describe the basic parts of Excel;
Use cell references;
Demonstrate how to create formulas and functions;
Use and create a mini agenda in Excel for the classroom.
5. DATABASE – MICROSOFT ACCESS.
5.1. Concept and objective of the Database;
5.2. Construction of a database;
5.3. Tables;
5.4. Form
5.5. Report.
SPECIFIC OBJECTIVES
Explain what a Database is and the names of its components;
Describe the basic parts of the Database;
Use Forms;
4
Create and use a database of activities for a room.
6. GRAPHIC MANAGEMENT – MICROSOFT POWER POINT
6.1. Theoretical aspects;
6.2. Definitions:
6.2.1. Presentation
6.2.2. Slide or Device;
6.2.3. Characteristics of a presentation;
6.3. Create a presentation:
6.3.1. Through the automatic content assistant;
6.3.2. From the Model,
6.3.3. From nothing.
6.4. View Mode:
6.4.1. Normal;
6.4.2. Organization of device;
6.4.3. Device presentation;
6.4.4. Add a device or Slide;
6.4.5. Device scheme;
6.4.6. Transition between slides;
6.4.7. Customized animation;
6.4.8. Run presentation (Slide Show) - F5;
6.4.9. Finish – ESC.
6.5. Create a blank presentation:
6.5.1. Fund (Format);
6.5.2. Color gradation;
6.5.3. Texture;
6.5.4. Image;
Standard
6.5.6. Configure presentation (Presentations Menu);
6.5.7. Save in PPS Format.
SPECIFIC OBJECTIVES
Explain the characteristics of PowerPoint;
Describe the basic parts of PowerPoint;
Use Background, color gradient, Texture, Image and Pattern;
Show how to create a presentation;
Use and create a PowerPoint presentation for the classroom.
7. THEME: MICROSOFT INTEGRATION
7.1. Embedded objects (linked);
7.2. Word, Excel, Power Point.
5
SPECIFIC OBJECTIVES
Define Integrated Software;
Describe the basic parts and functions of integrated software;
Use and create an integrated repertoire of activities for a classroom.
8. THE INTERNET AND ITS TELEMATICS SERVICES
8.1. Email;
8.2. Internet Navigation;
8.3. Information Research on the Internet.
SPECIFIC OBJECTIVES
A global network that connects millions of private, public, academic, business, and government networks, enabling data exchange and communication.
Discuss about the history of the Internet;
Describe networks and explain how they operate;
Develop an internet application for the classroom;
Discuss distance learning and its application in education.
Common questions
Powered by AIProper management of digital workplace elements, like file and folder management, is essential as it ensures efficiency and organization, reducing redundancy and saving time. It aids in data retrieval, improves workflow, and enhances collaboration by maintaining a structured digital environment that supports seamless access and data integrity .
The formula bar and cell referencing system in Microsoft Excel enhance computational efficiency by allowing complex calculations to be executed automatically and with precision. These features support dynamic data analysis, streamline workflows, and facilitate the automation of repetitive tasks, which is crucial for data-driven decision-making .
The development of basic IT concepts equips students with the necessary skills to effectively solve problems in various subjects and everyday life by allowing them to understand and utilize technology in versatile ways. These skills foster the ability to navigate and apply technological solutions and innovations to problem-solving contexts beyond the IT discipline itself .
Understanding the typical architecture and functioning of a computer is crucial as it lays the foundation for students to troubleshoot, optimize, and efficiently use computer systems. This knowledge enables them to configure, maintain, and harness capabilities of hardware and software components to meet specific needs and enhance productivity .
Formatting skills, including the use of superscripts and subscripts, enhance document presentation by allowing tailored and visually appealing text structures. These skills improve readability and presentation clarity, essential for creating professional documents that effectively communicate complex information, such as scientific notations or citations .
Knowledge of computer science can be applied to enhance data analysis, automate repetitive tasks, and drive innovation in science and technology fields. In daily life, this knowledge aids in optimizing workflows, enhancing digital literacy, and improving problem-solving skills across diverse domains, leading to more efficient and informed decision-making .
Computer networks offer several advantages, such as resource sharing, improved communication, and data exchange efficiency, which are critical features for real-world applications. They enable global connectivity, facilitate collaboration in both professional and personal contexts, and support centralized management of information systems .
Adopting a critical attitude towards the social effects of computing and IT encourages students to assess and question the implications of technology on society. This reflective stance helps them understand the ethical, privacy, and security concerns associated with IT, leading to more informed decision-making and responsible use of technology in both personal and professional spheres .
Learning about viruses and antivirus software enriches a student's skill set by empowering them with the ability to protect and secure computer systems against malicious attacks. Understanding the nature of threats and the mechanisms of security software leads to better risk management and fosters a robust approach to maintaining data integrity .
Computers significantly impact general life by enhancing efficiencies in data processing, simulation, and modeling in scientific and technological fields. This technological leverage facilitates advances in research, healthcare, and communication, thereby improving quality of life through better services, learning environments, and societal connectivity .