OER Resources For MAC100

Computing Fundamentals

Content

  1. Course Syllabus
  2. Open Book Resources
  3. Hands-on Exercises
  4. Experiments Data and Handouts

Open Book Resources

Topics eBook Video Resources
Database Design - 2nd Edition Read Book Fundamental of Database     Database Fundamentals
Introduction To Networking Read Book Introduction to Networking Part I      Part II      Part III      Part IV
Marking up with HTML Read pdf Introduction to HTML Part IHTML Part IIHTML Part IIIHTML Part IV
Cascading Style Sheets Read pdf CSS Part I - CSS Part II - CSS Part III - CSS Part IV - CSS Part V
CSS - Transitions, Animations Read pdf Animation with CSS
WWW - Web Searching Techniques Get Data 15 ways to search - Cool Google Search Tips
Information Representation (Bits - Bytes - Binary) Get Data How bits and bytes work- Bits Representation
Data and Information Security Get Data Information Security - Physical Security - Authentication - Protecting Your Data
Spreadsheets - Basics and Advanced Spreadsheets for Planning Read Book MS Excel From Beginner to Certified Professional
JavaScript Programming Read Book JavaScript Tutorial- JavaScript Fundamentals

Hands-on Exercises Tutorials

Students may be required to submit an individual report for each lab. PDFs are the preferred format since PDFs can be uploaded to Blackboard.

Labs Download Resources
Installation of MySQL on Windows Read Installation Installation of MySQL on Windows Video 1     Installation of MySQL on Windows Video 2
Connecting to MySQL Read Connection Connecting to MySQL using WorkBench
Creating Databases Read Creating DB Creating Database using Workbench
Creating simple static and dynamic web pags read Info Creating static web page - Creating dynamic web site
Apply CSS and JavaScript to web pages Get Data Apply Javascript to a website
Techniques and Setting for web security Read Info How to protect your online privacy when browsing
Use Vlookup and database formulas in spreadsheets Read Instructions Vlookup and Hlookup tutorials - Database formulas in Excel

Students may use MySQL/MariaDB or any open source HTML editor to submit the lab assignments

Lab Names Instructions Due Dates Upload/Email Links
Lab 1. Create a database
Lab 2. Create a Login Page
Lab 3. Apply CSS and Javascript to Lab 2
Lab 4. Connect to the database from Login Page
Lab 5. Techniques to Secure your website
Lab 6. Create a Vloop Report

Additional OER Resources

Topics Go to Site
HTML5 examples, tutorials, and Online ​HTML Editor TutorialRepublic     W3schools
Text-to-ASCII and ASCII-to-text converters Unit-conversion     Browserling
Binary/Decimal/Hexadecimal converters BinaryHexconverter     Mathsisfun
Flowchart interpreter RAPTOR Raptor Martincarlisle
Online Python compilers Tutorialspoint     Onlinegdb     Programiz     Jdoodle
Crash Course in Computer Science (a collection of video lectures covering course related topics) The Crashcourse