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 Analizy Systemowej i Marketingu
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 3,01,00zaliczenie

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-2The 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-3Network services in information systems. Internet technologies: Internet browsers, email programs. Methods and techniques for searching information on the Internet.2
T-L-4Familiarizing 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 files3
T-L-5Operating for the WORD 2007-2010 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 EXCEL 2007-2010: 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 Microsoft PowerPoint 2007-2010. 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.4
30

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

KODForma aktywnościGodziny
laboratoria
A-L-1Participation in laboratory activities30
A-L-2Self-preparation for laboratories32
A-L-3Preparation of projects and project documentation23
A-L-4Project consultations5
90

Metody nauczania / narzędzia dydaktyczne

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

Sposoby oceny

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

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
E_1A_A6_W01
Student knows the features of the Microsoft Windows operating system (2000, XP, Vista or 7 Home Premium) and the standard Microsoft Office software (2002 – 2010). 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.
E_1A_W01, E_1A_W06, E_1A_W07, E_1A_W12, E_1A_W14C-2, C-1, C-3T-L-1, T-L-2, T-L-3, T-L-4, T-L-5, T-L-6, T-L-7M-1S-1

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
E_1A_A6_U01
Student can use the features of the Microsoft Windows operating system (2000, XP, Vista or 7 Home Premium) and the standard Microsoft Office software (2002 – 2010). 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.
E_1A_U02, E_1A_U07, E_1A_U17, E_1A_U20C-2, C-3T-L-1, T-L-2, T-L-4, T-L-5, T-L-6, T-L-7M-2, M-3, M-4S-1

Kryterium oceny - wiedza

Efekt uczenia sięOcenaKryterium oceny
E_1A_A6_W01
Student knows the features of the Microsoft Windows operating system (2000, XP, Vista or 7 Home Premium) and the standard Microsoft Office software (2002 – 2010). 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
E_1A_A6_U01
Student can use the features of the Microsoft Windows operating system (2000, XP, Vista or 7 Home Premium) and the standard Microsoft Office software (2002 – 2010). 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
  2. Murray K., First Look: Microsoft® Office 2010, Microsoft Press, Redmond, 2010
  3. Winston W.L., Microsoft Excel 2010: Data Analysis and Business Modeling, Microsoft Press, Redmond, 2011

Literatura dodatkowa

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

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-2The 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-3Network services in information systems. Internet technologies: Internet browsers, email programs. Methods and techniques for searching information on the Internet.2
T-L-4Familiarizing 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 files3
T-L-5Operating for the WORD 2007-2010 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 EXCEL 2007-2010: 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 Microsoft PowerPoint 2007-2010. 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.4
30

Formy aktywności - laboratoria

KODForma aktywnościGodziny
A-L-1Participation in laboratory activities30
A-L-2Self-preparation for laboratories32
A-L-3Preparation of projects and project documentation23
A-L-4Project consultations5
90
(*) 1 punkt ECTS, odpowiada około 30 godzinom aktywności studenta
PoleKODZnaczenie kodu
Zamierzone efekty uczenia sięE_1A_A6_W01Student knows the features of the Microsoft Windows operating system (2000, XP, Vista or 7 Home Premium) and the standard Microsoft Office software (2002 – 2010). 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ówE_1A_W01Ma podstawową wiedzę z zakresu ekonomii, jej miejscu w systemie nauk społecznych oraz powiązaniach z innymi dyscyplinami naukowymi
E_1A_W06Zna metody i narzędzia pozyskiwania, przetwarzania i prezentacji danych (w tym informatyczne) dotyczące zjawisk i procesów społeczno-gospodarczych
E_1A_W07Ma podstawową wiedzę z zakresu metod ilościowych (w tym matematyki, statystyki, ekonometrii i teorii podejmowania decyzji) i zna przykłady ich zastosowań w praktyce gospodarczej
E_1A_W12Ma podstawową wiedzę o metodach analizy ekonomiczno-finansowej oraz planowania
E_1A_W14Zna i rozumie podstawowe pojęcia i zasady z zakresu ochrony własności przemysłowej i prawa autorskiego
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-2The 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-3Network services in information systems. Internet technologies: Internet browsers, email programs. Methods and techniques for searching information on the Internet.
T-L-4Familiarizing 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 the WORD 2007-2010 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 EXCEL 2007-2010: 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 Microsoft PowerPoint 2007-2010. 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-1Problem lecture
Sposób ocenyS-1Ocena podsumowująca: Completing exercises based on written work and individual projects.
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ęE_1A_A6_U01Student can use the features of the Microsoft Windows operating system (2000, XP, Vista or 7 Home Premium) and the standard Microsoft Office software (2002 – 2010). 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ówE_1A_U02Potrafi zastosować podstawową wiedzę teoretyczną i pozyskiwać dane do analizowania konkretnych procesów i zjawisk społeczno-gospodarczych
E_1A_U07Rozwiązuje problemy makro-i mikroekonomiczne z wykorzystaniem różnorodnych narzędzi analitycznych, w tym nowoczesnych technologii informatycznych
E_1A_U17Potrafi wykorzystać technologie teleinformatyczne (ICT)
E_1A_U20Posiada umiejętność raportowania zamierzeń i efektów zrealizowanych działań
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-2The 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-4Familiarizing 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 the WORD 2007-2010 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 EXCEL 2007-2010: 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 Microsoft PowerPoint 2007-2010. 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-2Laboratory exercises
M-3Explanation
M-4Project 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.