Zachodniopomorski Uniwersytet Technologiczny w Szczecinie

Wydział Ekonomiczny - Economics (S1)

Sylabus przedmiotu Information Technology:

Informacje podstawowe

Kierunek studiów Economics
Forma studiów studia stacjonarne Poziom pierwszego stopnia
Tytuł zawodowy absolwenta licencjat
Obszary studiów charakterystyki PRK
Profil ogólnoakademicki
Moduł
Przedmiot Information Technology
Specjalność przedmiot wspólny
Jednostka prowadząca Katedra Zastosowań Matematyki w Ekonomii
Nauczyciel odpowiedzialny Henryk Marjak <Henryk.Marjak@zut.edu.pl>
Inni nauczyciele
ECTS (planowane) 3,0 ECTS (formy) 3,0
Forma zaliczenia zaliczenie Język polski
Blok obieralny Grupa obieralna

Formy dydaktyczne

Forma dydaktycznaKODSemestrGodzinyECTSWagaZaliczenie
laboratoriaL2 30 2,00,50zaliczenie
wykładyW2 8 1,00,50zaliczenie

Wymagania wstępne

KODWymaganie wstępne
W-1Student knows and understands the basic concepts of IT, uses a computer set and its operating system. Student creates and names files and folders in accordance with the rules in force in this regard. Student can customize the system options to suit needs of the user and can handle different information media.

Cele przedmiotu

KODCel modułu/przedmiotu
C-1Familiarizing with the development of the information society, the electronic economy, new information and communication technologies and their impact on the modern economy.
C-2Familiarizing with the advanced functionality of the selected Microsoft Windows operating system and standard application software. The subject matter of the tasks is related to business applications.
C-3Familiarizing with Internet technologies and tools, and data protection and security issues in network communication systems.

Treści programowe z podziałem na formy zajęć

KODTreść programowaGodziny
laboratoria
T-L-1Computer resource management, configuration of the Windows operating system. Data organization, operations on files and folders.2
T-L-2Familiarizing with the working principles of the remote learning system based on the Moodle e-learning platform. Logging personal data and logging into the system, organizing communication and exchanging files1
T-L-3The basics of security in the use of computer systems, in particular the safety of the use of wired, wireless, local (LAN), corporate and global (WWW) networks.2
T-L-4Network services in information systems. Internet technologies: Internet browsers, email programs. Methods and techniques for searching information on the Internet.2
T-L-5Operating for word processor: navigation, toolbars, text editing and formatting, page setup, table editing and formatting, editing of statistical and mathematical equations, inserting formulas, drawing diagrams, embedding technique, computer graphics, editing charts.7
T-L-6Operating for the spreadsheet: workbook construction, navigation, cell addressing and formatting, editing and data entry, simple and complex formulas, mathematical functions, charting, function graphs, managerial charts, logical functions, selected financial functions, data analysis, creation of tables and PivotCharts, variant analysis - scenarios.10
T-L-7Operating for presentation graphics package. Options for toolbars and menus. Project templates, slide patterns. Working with slides. Formatting slides and presentations. Accessibility features in PowerPoint. Animating texts and objects. Creating and running presentations.6
30
wykłady
T-W-1Computer networks, network services and safe use of network services2
T-W-2The role of information in company management. The structure and functions of the enterprise information system.2
T-W-3Evolution and development directions of management support systems. Application software - application examples: word processing, spreadsheets, managerial and presentation graphics.3
T-W-4Written test of the lectures1
8

Obciążenie pracą studenta - formy aktywności

KODForma aktywnościGodziny
laboratoria
A-L-1Participation in laboratory activities30
A-L-2Self-preparation for laboratories10
A-L-3Preparation of projects and project documentation10
50
wykłady
A-W-1uczestnictwo w zajęciach8
A-W-2Preparation for passing the lectures10
A-W-3Acquainting with the literature on the subject7
25

Metody nauczania / narzędzia dydaktyczne

KODMetoda nauczania / narzędzie dydaktyczne
M-1Laboratory exercises
M-2Explanation
M-3Project method
M-4Lecture

Sposoby oceny

KODSposób oceny
S-1Ocena podsumowująca: Completing exercises based on written work and individual projects.
S-2Ocena podsumowująca: Test

Zamierzone efekty uczenia się - wiedza

Zamierzone efekty uczenia sięOdniesienie do efektów kształcenia dla kierunku studiówOdniesienie do efektów zdefiniowanych dla obszaru kształceniaCel przedmiotuTreści programoweMetody nauczaniaSposób oceny
Ec_1A_A05_W01
Student knows the features of the Microsoft Windows operating system and the office package Microsoft Office software. Student has knowledge of the functionality of the office suite MS Word, MS Excel, MS PowerPoint on a level consistent with the requirements for applicants for the European Computer Driving License(ECDL Core). Student knows the impact of Internet technologies on the development of the information society and the modern economy.
Ec_1A_W01, Ec_1A_W07, Ec_1A_W14, Ec_1A_W06, Ec_1A_W12C-2, C-1, C-3T-L-1, T-L-3, T-L-4, T-L-2, T-L-5, T-L-6, T-L-7, T-W-1, T-W-2, T-W-3, T-W-4M-4, M-2, M-3S-1, S-2

Zamierzone efekty uczenia się - umiejętności

Zamierzone efekty uczenia sięOdniesienie do efektów kształcenia dla kierunku studiówOdniesienie do efektów zdefiniowanych dla obszaru kształceniaCel przedmiotuTreści programoweMetody nauczaniaSposób oceny
Ec_1A_A05_U01
Student can use the features of the Microsoft Windows operating system and the office package Microsoft Office software. Student is able to use the modules of the office suite MS Word, MS Excel, MS PowerPoint on a level consistent with the requirements for applicants for the European Computer Driving Licence (ECDL Core). Student can use selected applications and Web tools to solve practical problems in the modern economy.
Ec_1A_U20, Ec_1A_U02, Ec_1A_U07, Ec_1A_U17C-2, C-3T-L-1, T-L-3, T-L-4, T-L-2, T-L-5, T-L-6, T-L-7M-1, M-2, M-3S-1

Kryterium oceny - wiedza

Efekt uczenia sięOcenaKryterium oceny
Ec_1A_A05_W01
Student knows the features of the Microsoft Windows operating system and the office package Microsoft Office software. Student has knowledge of the functionality of the office suite MS Word, MS Excel, MS PowerPoint on a level consistent with the requirements for applicants for the European Computer Driving License(ECDL Core). Student knows the impact of Internet technologies on the development of the information society and the modern economy.
2,0Student does not know the basic concepts of information and communication technologies and their impact on the modern economy, does not know the factors determining the development of the information society, does not know functions of standard system and utility software.
3,0Student knows the basic concepts in the area of information and communication technology. Student knows their impact on the modern economy, knows the factors determining the development of the information society, knows the basic functions of standard system and utility software.
3,5Student knows the issues in the area of information and communication technology applications in the economy. Student knows their impact on improving the information and decision-making processes in the enterprise and the economy.
4,0Student knows and analyses issues in the area of information and communication technology applications in the economy and their impact on improving the information and decision-making processes in selected sectors of the economy, knows the functionality of specialized software.
4,5Student knows and analyses the extended issues in the area of information and communication technology, their applications in the economy and their impact on improving the information and decision-making processes in selected sectors of the economy, knows advanced functionality of specialized software.
5,0Student knows and analyses the extended issues in the area of information and communication technology applications in the economy and their impact on improving the information and decision-making processes in selected sectors of the economy, knows the procedures for defining and Generating reports and reports.

Kryterium oceny - umiejętności

Efekt uczenia sięOcenaKryterium oceny
Ec_1A_A05_U01
Student can use the features of the Microsoft Windows operating system and the office package Microsoft Office software. Student is able to use the modules of the office suite MS Word, MS Excel, MS PowerPoint on a level consistent with the requirements for applicants for the European Computer Driving Licence (ECDL Core). Student can use selected applications and Web tools to solve practical problems in the modern economy.
2,0Student cannot work under the supervision of the operating system; can not perform standard operations and commands on the system, can not install selected programs and configure the program according to the user's needs.
3,0Student can work under the supervision of the operating system; can perform standard operations and commands in the system, can install selected programs and configure the program according to the user's needs.
3,5Student is able to work with the text editor: edits, formats and organizes the layout of the document, performs spell checking and corrects errors; creates a simple serial correspondence. Student operates spreadsheet: edits, formats and processes numeric, alphanumeric and text data. Defines formulas and calculation procedures. Applies mathematical, statistical, logical functions, dates and times. Analyzes data, creates pivot tables, scenarios, tracks relationships between cells containing formulas.
4,0Student operates spreadsheet: defines complex formulas and calculation procedures; uses text, financial and data search functions; analyzes data, filters, formats and groups data in a pivot table, generates reports based on a scenario, visualizes relationships between cells containing formulas, presents data and results on charts.
4,5Student operates a multimedia presentation program: uses in work on creating presentations from different types of views; prepares and inserts slide elements - graphics, charts, mathematical formulas; applies the slide transition effect for individual slides and sets the transition speed and switching method; uses slide designs from the Microsoft Office Online site and applies a design template for individual slides; can prepare sound files and put them in the presentation; can prepare diagrams and organizational charts and apply them in the presentation; uses hyperlinks in the presentation.
5,0Student defines and registers macro commands, assigns keyboard shortcuts to macro commands; develops scenarios, performs the reverse variant analysis; shares and integrates data files; integrates sheets with other office suite applications; looks for the results of alternatives and supports solver; explains and interprets the obtained results; alone in an interesting and creative way, plans and prepares a project for a given topic using the known tools.

Literatura podstawowa

  1. Mathew A., Murugeshan S.K., Fundamentals of Information Technology, Alpha Sceince, Oxford, 2013, ProQuest Ebook Central
  2. Murray K., First Look: Microsoft® Office 2010, Microsoft Press, Redmond, 2010, Microsoft Free Ebook
  3. Winston W.L., Microsoft Excel 2010: Data Analysis and Business Modeling, Microsoft Press, Redmond, 2011, https://docushare.sfu.ca/dsweb/Get/Version-493516/Data%20Analysis%20and%20Business%20Modelling.pdf

Literatura dodatkowa

  1. Silyn-Roberts H., Writing for Science and Engineering : Papers, Presentations and Reports, Elsevier, Amsterdam, 2012, 2, ProQuest Ebook Central
  2. Kapterev A., Presentation Secrets, John Wiley & Sons, Indianapolis, 2011, ProQuest Ebook Central
  3. Odnoha A., Excel 2010 Financials Cookbook, Packt Publishing, Birmingham, 2011, ProQuest Ebook Central
  4. Walkenbach J., Microsoft Excel 2010 Bible, Wiley Publishing, Indianapolis, 2010, ProQuest Ebook Central
  5. Tyson H., Microsoft Word 2010 Bible, John Wiley & Sons, Indianapolis, 2010, ProQuest Ebook Central
  6. Anderson-Williams R., Mastering Prezi for Business Presentations, Packt Publishing, Birmingham, 2012, ProQuest Ebook Central

Treści programowe - laboratoria

KODTreść programowaGodziny
T-L-1Computer resource management, configuration of the Windows operating system. Data organization, operations on files and folders.2
T-L-2Familiarizing with the working principles of the remote learning system based on the Moodle e-learning platform. Logging personal data and logging into the system, organizing communication and exchanging files1
T-L-3The basics of security in the use of computer systems, in particular the safety of the use of wired, wireless, local (LAN), corporate and global (WWW) networks.2
T-L-4Network services in information systems. Internet technologies: Internet browsers, email programs. Methods and techniques for searching information on the Internet.2
T-L-5Operating for word processor: navigation, toolbars, text editing and formatting, page setup, table editing and formatting, editing of statistical and mathematical equations, inserting formulas, drawing diagrams, embedding technique, computer graphics, editing charts.7
T-L-6Operating for the spreadsheet: workbook construction, navigation, cell addressing and formatting, editing and data entry, simple and complex formulas, mathematical functions, charting, function graphs, managerial charts, logical functions, selected financial functions, data analysis, creation of tables and PivotCharts, variant analysis - scenarios.10
T-L-7Operating for presentation graphics package. Options for toolbars and menus. Project templates, slide patterns. Working with slides. Formatting slides and presentations. Accessibility features in PowerPoint. Animating texts and objects. Creating and running presentations.6
30

Treści programowe - wykłady

KODTreść programowaGodziny
T-W-1Computer networks, network services and safe use of network services2
T-W-2The role of information in company management. The structure and functions of the enterprise information system.2
T-W-3Evolution and development directions of management support systems. Application software - application examples: word processing, spreadsheets, managerial and presentation graphics.3
T-W-4Written test of the lectures1
8

Formy aktywności - laboratoria

KODForma aktywnościGodziny
A-L-1Participation in laboratory activities30
A-L-2Self-preparation for laboratories10
A-L-3Preparation of projects and project documentation10
50
(*) 1 punkt ECTS, odpowiada około 30 godzinom aktywności studenta

Formy aktywności - wykłady

KODForma aktywnościGodziny
A-W-1uczestnictwo w zajęciach8
A-W-2Preparation for passing the lectures10
A-W-3Acquainting with the literature on the subject7
25
(*) 1 punkt ECTS, odpowiada około 30 godzinom aktywności studenta
PoleKODZnaczenie kodu
Zamierzone efekty uczenia sięEc_1A_A05_W01Student knows the features of the Microsoft Windows operating system and the office package Microsoft Office software. Student has knowledge of the functionality of the office suite MS Word, MS Excel, MS PowerPoint on a level consistent with the requirements for applicants for the European Computer Driving License(ECDL Core). Student knows the impact of Internet technologies on the development of the information society and the modern economy.
Odniesienie do efektów kształcenia dla kierunku studiówEc_1A_W01He / she knows and understands at an advanced level the issues in the field of economics and finance, their place in the social sciences system and connections with other scientific disciplines
Ec_1A_W07He / she knows and understands at an advanced level the issues in the field of quantitative methods (including mathematics, statistics, econometrics and decision-making theory) and examples of their applications in economic practice
Ec_1A_W14He / she knows and understands the concepts and principles of industrial property protection and copyright
Ec_1A_W06He / she knows and understands at an advanced level the methods and tools (including IT) of obtaining, processing and presenting data on socio-economic phenomena and processes
Ec_1A_W12He / she knows and understands at an advanced level the methods of economic and financial analysis and planning
Cel przedmiotuC-2Familiarizing with the advanced functionality of the selected Microsoft Windows operating system and standard application software. The subject matter of the tasks is related to business applications.
C-1Familiarizing with the development of the information society, the electronic economy, new information and communication technologies and their impact on the modern economy.
C-3Familiarizing with Internet technologies and tools, and data protection and security issues in network communication systems.
Treści programoweT-L-1Computer resource management, configuration of the Windows operating system. Data organization, operations on files and folders.
T-L-3The basics of security in the use of computer systems, in particular the safety of the use of wired, wireless, local (LAN), corporate and global (WWW) networks.
T-L-4Network services in information systems. Internet technologies: Internet browsers, email programs. Methods and techniques for searching information on the Internet.
T-L-2Familiarizing with the working principles of the remote learning system based on the Moodle e-learning platform. Logging personal data and logging into the system, organizing communication and exchanging files
T-L-5Operating for word processor: navigation, toolbars, text editing and formatting, page setup, table editing and formatting, editing of statistical and mathematical equations, inserting formulas, drawing diagrams, embedding technique, computer graphics, editing charts.
T-L-6Operating for the spreadsheet: workbook construction, navigation, cell addressing and formatting, editing and data entry, simple and complex formulas, mathematical functions, charting, function graphs, managerial charts, logical functions, selected financial functions, data analysis, creation of tables and PivotCharts, variant analysis - scenarios.
T-L-7Operating for presentation graphics package. Options for toolbars and menus. Project templates, slide patterns. Working with slides. Formatting slides and presentations. Accessibility features in PowerPoint. Animating texts and objects. Creating and running presentations.
T-W-1Computer networks, network services and safe use of network services
T-W-2The role of information in company management. The structure and functions of the enterprise information system.
T-W-3Evolution and development directions of management support systems. Application software - application examples: word processing, spreadsheets, managerial and presentation graphics.
T-W-4Written test of the lectures
Metody nauczaniaM-4Lecture
M-2Explanation
M-3Project method
Sposób ocenyS-1Ocena podsumowująca: Completing exercises based on written work and individual projects.
S-2Ocena podsumowująca: Test
Kryteria ocenyOcenaKryterium oceny
2,0Student does not know the basic concepts of information and communication technologies and their impact on the modern economy, does not know the factors determining the development of the information society, does not know functions of standard system and utility software.
3,0Student knows the basic concepts in the area of information and communication technology. Student knows their impact on the modern economy, knows the factors determining the development of the information society, knows the basic functions of standard system and utility software.
3,5Student knows the issues in the area of information and communication technology applications in the economy. Student knows their impact on improving the information and decision-making processes in the enterprise and the economy.
4,0Student knows and analyses issues in the area of information and communication technology applications in the economy and their impact on improving the information and decision-making processes in selected sectors of the economy, knows the functionality of specialized software.
4,5Student knows and analyses the extended issues in the area of information and communication technology, their applications in the economy and their impact on improving the information and decision-making processes in selected sectors of the economy, knows advanced functionality of specialized software.
5,0Student knows and analyses the extended issues in the area of information and communication technology applications in the economy and their impact on improving the information and decision-making processes in selected sectors of the economy, knows the procedures for defining and Generating reports and reports.
PoleKODZnaczenie kodu
Zamierzone efekty uczenia sięEc_1A_A05_U01Student can use the features of the Microsoft Windows operating system and the office package Microsoft Office software. Student is able to use the modules of the office suite MS Word, MS Excel, MS PowerPoint on a level consistent with the requirements for applicants for the European Computer Driving Licence (ECDL Core). Student can use selected applications and Web tools to solve practical problems in the modern economy.
Odniesienie do efektów kształcenia dla kierunku studiówEc_1A_U20He / she is able to report the intentions and effects of implemented activities, participate in the debate presenting and assessing various positions and opinions
Ec_1A_U02He / she can apply the possessed theoretical knowledge, properly selecting data, methods and tools, to formulate and solve unusual and complex problems related to socio-economic processes and phenomena, and to solve tasks in conditions that are not fully predictable
Ec_1A_U07He / she is able to solve macro- and microeconomic problems with the use of various analytical tools, including modern information technologies
Ec_1A_U17He / she is able to use information and communication technologies (ICT)
Cel przedmiotuC-2Familiarizing with the advanced functionality of the selected Microsoft Windows operating system and standard application software. The subject matter of the tasks is related to business applications.
C-3Familiarizing with Internet technologies and tools, and data protection and security issues in network communication systems.
Treści programoweT-L-1Computer resource management, configuration of the Windows operating system. Data organization, operations on files and folders.
T-L-3The basics of security in the use of computer systems, in particular the safety of the use of wired, wireless, local (LAN), corporate and global (WWW) networks.
T-L-4Network services in information systems. Internet technologies: Internet browsers, email programs. Methods and techniques for searching information on the Internet.
T-L-2Familiarizing with the working principles of the remote learning system based on the Moodle e-learning platform. Logging personal data and logging into the system, organizing communication and exchanging files
T-L-5Operating for word processor: navigation, toolbars, text editing and formatting, page setup, table editing and formatting, editing of statistical and mathematical equations, inserting formulas, drawing diagrams, embedding technique, computer graphics, editing charts.
T-L-6Operating for the spreadsheet: workbook construction, navigation, cell addressing and formatting, editing and data entry, simple and complex formulas, mathematical functions, charting, function graphs, managerial charts, logical functions, selected financial functions, data analysis, creation of tables and PivotCharts, variant analysis - scenarios.
T-L-7Operating for presentation graphics package. Options for toolbars and menus. Project templates, slide patterns. Working with slides. Formatting slides and presentations. Accessibility features in PowerPoint. Animating texts and objects. Creating and running presentations.
Metody nauczaniaM-1Laboratory exercises
M-2Explanation
M-3Project method
Sposób ocenyS-1Ocena podsumowująca: Completing exercises based on written work and individual projects.
Kryteria ocenyOcenaKryterium oceny
2,0Student cannot work under the supervision of the operating system; can not perform standard operations and commands on the system, can not install selected programs and configure the program according to the user's needs.
3,0Student can work under the supervision of the operating system; can perform standard operations and commands in the system, can install selected programs and configure the program according to the user's needs.
3,5Student is able to work with the text editor: edits, formats and organizes the layout of the document, performs spell checking and corrects errors; creates a simple serial correspondence. Student operates spreadsheet: edits, formats and processes numeric, alphanumeric and text data. Defines formulas and calculation procedures. Applies mathematical, statistical, logical functions, dates and times. Analyzes data, creates pivot tables, scenarios, tracks relationships between cells containing formulas.
4,0Student operates spreadsheet: defines complex formulas and calculation procedures; uses text, financial and data search functions; analyzes data, filters, formats and groups data in a pivot table, generates reports based on a scenario, visualizes relationships between cells containing formulas, presents data and results on charts.
4,5Student operates a multimedia presentation program: uses in work on creating presentations from different types of views; prepares and inserts slide elements - graphics, charts, mathematical formulas; applies the slide transition effect for individual slides and sets the transition speed and switching method; uses slide designs from the Microsoft Office Online site and applies a design template for individual slides; can prepare sound files and put them in the presentation; can prepare diagrams and organizational charts and apply them in the presentation; uses hyperlinks in the presentation.
5,0Student defines and registers macro commands, assigns keyboard shortcuts to macro commands; develops scenarios, performs the reverse variant analysis; shares and integrates data files; integrates sheets with other office suite applications; looks for the results of alternatives and supports solver; explains and interprets the obtained results; alone in an interesting and creative way, plans and prepares a project for a given topic using the known tools.