INTRODUCTION TO COMPUTER SCIENCE (COSC 101)

OVERVIEW

1. COURSE DESCRIPTION

First, students study the Fundamentals of Computer Science and Information Technology including computer components, computer functions, and computer’s data/information processing. Second, the course will cover Industry 4.0, technology trends and security awareness which allow students to better prepare for their study, career and daily life. Third, students will study a new technology called BI (Business Intelligence) applications which are used for developing top management reports. Last but not least, students will then build a strong foundation in Python Programming Language which is rapidly becoming a de-facto programming language for various analytics applications.

2. REASON FOR THE COURSE

This course aims to give students a foundation in information technology systems and applications that are commonly used in business settings and have broad application in business. The professional roles of bachelor of accounting and finance graduates will require the use of information technology to optimize business processes, monitor business processes and output, and conduct analysis for decision making.  This course aims not to teach specific applications, but to introduce students to the elements of information technology and information technology management that are common to most businesses.  These elements are management information systems,  security awareness, BI (Business Intelligence), programming for non-tech (using Python).

3. STUDY HOURS

4. ROLE IN CURRICULUM

Prerequisites:

There is no prerequisite for the Introduction to Computer Science (COSC 101). However, students are expected to have basic knowledge of Microsoft Office (especially MS. Excel), windows and computer usage.  

SKILLS

  • LEARNING OUTCOMES
  • ASSESSMENT AND GRADING
  • TEACHING METHODS
  • STUDY PLAN
  • TEXTBOOKS AND REFERENCES

5. COURSE LEARNING OUTCOMES (CLO)

On successful completion of this course, students will be able to:

Knowledge Level of
Learning		 Related PLO
Describe computer components (CK1)
Describe computer components, its functions, Industry 4.0 and emerging technologies, security related to computers.		 Understand PCIT2
Explain Python Programming (CCIT2)
Explain programming constructs of Python Programming Language.		 Understand PCIT2
Cognitive Skills Level of
Learning		 Related PLO
Analyze the operations of ALU (CC1)
Analyze the operations of Arithmetic Logic Unit (ALU) in the Computer Processing Unit (CPU).		 Analyze PCIT2
Communication, Information Technology, and Numerical Skills Level of
Learning		 Related PLO
Use Power BI to create reports (CCIT1) 
Use Power BI to create top management reports and Dashboard.		 Apply PCIT2
Apply Power BI to visualize the business content (CCIT2)
Use Power BI to dynamically and interactively visualize the business content.
 Apply  PCIT2
Interpersonal Skills and Responsibilities Level of
Learning		 Related PLO
Work in a team (CIP1)
Work effectively in a team.		 Value PIP1

6. ASSESSMENT AND GRADING

  Grades will be determined based on the following assessments and score allocations:

SKILL Assessment Skill Weighting for Grade
Participation Homework/ Assignment Quiz Midterm Exam Final Exam
Describe computer components (CK1)     40%  40% 40% 15%
Explain Python Programming (CCIT2)     40% 20% 40% 15%
Analyze the operations of ALU (CC1)     30% 30% 40% 20%
Use Power BI to create reports (CCIT1)   50%     50% 20%
Apply Power BI to visualize the business content (CCIT2)   50%     50% 20%
Work in a team (CIP1) 100%         10%

 

7. TEACHING METHODS

This course is primarily lecture and activity based; assigned readings will support learning and serve as a reference to material covered in class.  During class, approximately half of the class will be devoted to lecture with another half of the class working on case studies/activities on problem sets and reviewing the solutions.Hands-on use of information technology occurs at two points:  use of Power BI for problem solving on large and complex spreadsheets and use of python engine and pycharm to create and compile python scripts.

8. STUDY PLAN

The course targets the 30 lessons in the study plan below. Each lesson is 1.5 class hours each; there are a total of 45 class hours.  The study plan below describes the learning outcome for each lesson, described in terms of what the student should be able to do at the end of the lesson.  Readings should be done by students as preparation before the start of each class.  Implementation of this study plan may vary somewhat depending on the progress and needs of students.

 No Lesson Learning Outcomes Teaching (T), and Assessment (A) Methods
 1

Computer Architecture

  1. Identify the components of computer system (CK1)
 Lecture Reading: Selected Reading
2

Computer Architecture

  1. Outline the computer hardware, software and the concepts of computer safety (CK1)
  Lecture Reading: Selected Reading
3

Computer Architecture

  1. Outline the computer functionality (Input, Processor, Output) (CK1)
 Lecture Reading: Selected Reading
4

Cambodia towards the Industry 4.0

  1. Describe Industry revolution
  2. DescribeThe 4th Industrial revolution (Industry 4.0)
  3. Describe Cambodia towards the  Industry 4.0 (CK1)
 Lecture Reading: Selected Reading
5

Digital Technology and Emerging Technology

  1. Explain the Digital technology 
  2. Differentiate the Emerging Technology(CK1)
 Lecture Reading: Selected Reading
6

Digital Technology and Emerging Technology

  1. Explain the Digital technology 
  2. Differentiate the Emerging Technology (CK1)
 Lecture Reading: Selected Reading
7

Computer Security

  1. Describe Risks & Threats, Network Security, and  Basic Components Of Computer Security
  2. (Differentiate Online Security Vs Online Safety 
  3. Explain Steps to protect computer and information (CK1)
 Lecture Reading: Selected Reading
8

BI: Introduction and BI Architecture

  1. Explain the structure of Power BI and its concept. (CCIT2)
 Lecture PracticeReading: Selected Reading (https://docs.microsoft.com/en-us/power-bi/guided-learning/)
9

BI: Introduction and BI Architecture

  1. Explain the structure of Power BI and its concept. (CCIT1)
 Lecture PracticeReading: Selected Reading (https://docs.microsoft.com/en-us/power-bi/guided-learning/)
10

BI: Data Analysis with pivot table

  1. Build pivot tables using Power BI. (CIP1)
 Lecture PracticeReading: Selected Reading (https://docs.microsoft.com/en-us/power-bi/guided-learning/)
11

BI: Power View and Creating Dashboard

  1. Generate report and manage the content using Power BI. (CCIT1)
 Practice Reading: Selected Reading (https://docs.microsoft.com/en-us/power-bi/guided-learning/)
12

BI: Power View and Creating Dashboard

  1. Generate report and manage the content using Power BI. (CCIT1)
 Practice Reading: Selected Reading (https://docs.microsoft.com/en-us/power-bi/guided-learning/)
13

BI: Power View and Creating Dashboard

  1. Generate report and manage the content using Power BI. (CCIT1)
 Practice Reading: Selected Reading (https://docs.microsoft.com/en-us/power-bi/guided-learning/)
14

BI: Tips & Tricks with Power BI Q&A

  1. Use Power Q&A features of Power BI (CCIT1)
 Practice Reading: Selected Reading (https://docs.microsoft.com/en-us/power-bi/guided-learning/)
15

BI: Tips & Tricks with Power BI Q&A

  1. Use Power Q&A features of Power BI. (CCIT1)
 Practice Reading: Selected Reading (https://docs.microsoft.com/en-us/power-bi/guided-learning/)
16

Introduction to programming:

  1. Describe: What is programming? 
  2. Explain:  Why do we program? 
  3. Describe: What is Python (CCIT2)
 Lecture DiscussionTextbook: Python for Everybody: Exploring Data In Python 3
17

Setup Python Coding Environment

  1. Download & Install Python’s engine (Integrated Development & Learning Environment)
  2. Explain how to Download, Install PyCharm and  Running Code in PyCharm (CCIT2)
 Lecture / Practice / Hands-on Textbook: Python for Everybody: Exploring Data In Python 3
18

Build your first app in Python:

  1. Describe:  Introduction to Python Scripts 
  2. Build the first app in Python (CCIT2)
 Lecture / Practice / Hands-on Textbook: Python for Everybody: Exploring Data In Python 3
19

Basic Coding with Python

  1. Explain the Data Types (int, float, string, bool) 
  2. Explain the Operators (arithmetic, assignment, comparison, logical) (CCIT2)
 Lecture / Practice / Hands-on Textbook: Python for Everybody: Exploring Data In Python 3
20

Basic Coding with Python

  1. Explain the Data Types (int, float, string, bool) 
  2. Explain the Operators (arithmetic, assignment, comparison, logical) (CCIT2)
 Lecture / Practice / Hands-on Textbook: Python for Everybody: Exploring Data In Python 3
21

Basic Coding with Python

  1. Explain the Data Types (int, float, string, bool) 
  2. Explain the Operators (arithmetic, assignment, comparison, logical) (CCIT2)
 Lecture / Practice / Hands-on Textbook: Python for Everybody: Exploring Data In Python 3
22

Data Structures

  1. Explain Types (Lists, Tuples, Sets, Dictionaries, Compound Data Structures) 
  2. Explain Operators (membership, identity (CC1)
 Lecture / Practice / Hands-on Textbook: Python for Everybody: Exploring Data In Python 3
23

Data Structures

  1. Explain Types (Lists, Tuples, Sets, Dictionaries, Compound Data Structures) 
  2. Explain Operators (membership, identity)(CC1)
 Lecture / Practice / Hands-on Textbook: Python for Everybody: Exploring Data In Python 3
24

Data Structures

  1. Explain Types (Lists, Tuples, Sets, Dictionaries, Compound Data Structures) 
  2. Explain Operators (membership, identity)(CC1)
 Lecture / Practice / Hands-on Textbook: Python for Everybody: Exploring Data In Python 3
25

Control Flow

  1. Describe Conditional Statements 
  2. Illustrate  For & While Loops, Break & Continue (CC1)
 Lecture / Practice / Hands-on Textbook: Python for Everybody: Exploring Data In Python 3
26

Control Flow

  1. Describe Conditional Statements (CCIT3)
  2. Illustrate  For & While Loops, Break & Continue (CC1)
 Lecture / Practice / Hands-on Textbook: Python for Everybody: Exploring Data In Python 3
27

Control Flow

  1. Describe Conditional Statements 
  2. Illustrate  For & While Loops, Break & Continue (CC1)
 Lecture / Practice / Hands-on Textbook: Python for Everybody: Exploring Data In Python 3
28

Control Flow

  1. Describe Conditional Statements 
  2. Illustrate  For & While Loops, Break & Continue (CC1)
 Lecture / Practice / Hands-on Textbook: Python for Everybody: Exploring Data In Python 3
29

Complex Data Structure

  1. Describe Lists, Tuple, Set, Dictionary (CC1)
 Lecture / Practice / Hands-on Textbook: Python for Everybody: Exploring Data In Python 3
30

Functions

  1. Create Python Function
  2. Summary (CCIT2)
 Lecture / Practice / Hands-on Textbook: Python for Everybody: Exploring Data In Python 3
Total Hours: 45

TEXTBOOKS AND REFERENCES

Textbooks

  1. Roger F. Silva, Power BI – Business Intelligence Clinic: Create and Learn, 2023
  2. Charles Russell Severance, Python for Everybody: Exploring Data In Python 3

References

  1. Johnsie Barillo, Computer Components: Discover The Main Components Of Computer, 2022
  2. Ustundag, Industry 4.0: Managing The Digital Transformation, 2018
  3. https://learn.microsoft.com/en-us/power-bi/fundamentals/service-get-started
  4. https://www.w3schools.com/python
  5. https://docs.python.org/3.11/tutorial/

Education Resources