About Course
Lecture:T TH 11:00am-12:15pm. Henson Hall 109
Lab: W 11:00am-12:45pm. Henson Hall 150
Required Textbook
New Perspectives on Computer Concepts 2018: Introductory (20th ed.), by June Jamrich Parsons, ISBN 9781305956391 : Amazon
Recommended Textbooks
Technology for Success: Computer Concepts (1st ed.), by Jennifer T. Campbell, ISBN: 9780357124826
Blown to Bits by Hal Abelson, etc.
Resources
MS Excel
MS Access
HTML & CSS
- How to Code in HTML5 and CSS3 by Damian Wielgosik
- The Missing Link: An Introduction to Web Development and Programming by Michael Mendez
- W3School HTML
- W3School CSS
Python
- Think Python: How to think like a Computer Scientist by Allen B. Downey:
- Python for Everybody: Exploring Data Usng Python 3 by Dr. Charles R. Severance:
Required Software
- Microsoft 20216 or updated version(Word,Excel, Access)
- Adobe PDF reader
- Notepad++ (for Window user) or Visual Studio Code(for mac user)
- WinSCP (for Window user) or FileZilla (for both Window and Mac)
- Python
Assignments
Homework 1:
Homework 2:
Homework 3:
Homework 4:
Lecture Schedule
| Week | Topics | Readings | Files |
|---|---|---|---|
| 1 | Impact of Digital Technology & Digital Contents | Textbook | >Files |
| 2 | A History of Computation, Computer Hardware Devices, von Neumann Computer Architecture/ Operating System, File Management and Software Applications and Apps | Textbook | >Files |
| 3 | Concept of Database | Readings | >Files |
| 4 | Database Management System | Readings | >Files |
| 5 | Review & Exam 1 | Textbook | >Files |
| 6 | Internet, Browser, HTML | Textbook | >Files |
| 7 | Web Development: HTML | Readings | >Files |
| 8 | Web Development CSS | Readings | >Files |
| 9 | Review & Exam 2 | Textbook | >Files |
| 10 | Introduction to computational thinking, problem solving strategies, software programming process. Python(Variables, Operators, Expression) | Textbook | >Files |
| 11 | Python (Data Structure, Condition, Iteration) | Readings | >Files |
| 12 & 13 | Python(Functions, Files, Turtle Module) | Readings | >Files |
| 14 | Python(Turtle Module), Exploration of digital communication, networking, digital transformation such as cloud, e-commerce, and AI | Readings | >Files |
| 15 | Discussion on digital citizenship such as ethical, legal, and social issues in digital world, Current Issues (Metaverse, Blockchain) | Readings | >Files |