TGJ1O
ENGINEERING
ENGINEERING
Success at basic computing starts at the same place - organization. If you don't know how/where to find it, you can't work on it. This is as true as as student as it is for the IT professional. Click on the Start icon and browse to the Computer icon. Alternatively, press the windows key and the letter E and that opens windows explorer (NOT to be confused with Internet Explorer)
Notice - (see image below) there are a series of categories when you open Computer. On the left you'll see your Favorite Locations, your Libraries, your Computer icon (and a triangle next to it to open that into further subdivisions) and the Network icon and the triangle next to it to navigate to the network sub-divisions visible to you.
1) On the right side there are Hard Disk Drives, listing all physical devices IN YOUR COMPUTER that you have access to. There is a c drive which is NOT visible to you and a d drive (sometimes E or G etc..), which IS visible to you. Technically they're a logical division of the same physical entity - a hard-drive spinning away in the tower sitting next to you. We'll talk more about this in a couple of classes. While you have access to save/retrieve from the hard drive, it exists ONLY on your computer. You cannot access it from anywhere else except at the seat you're on right now.
2) There is a Devices with Removable Storage division. If you have a USB stick, a camera, a fax machine, a keyboard, a microphone, a time-traveling-device-sent-to-exterminate-mankind, it will appear here when you plug it in.
3) Finally, you have Network Locations. At school, using Active Directory you will see 2-3 drives. The first drive, the P drive (S drive for students), is where your Active Directory profile is kept. Your files, including daily and/or weekly backups, are kept here by default (except some programs which try to save them to the C drive). In the second folder (if visible) you will see Shared Data. Finally, more importantly, there is the X drive. This is where the school's hand-in and hand-out folders are. You will receive some relevant course materials from the hand-out folder under SouthCarletonDocuments(X)>Mcintyre>TGJ1O
Of them, the locations that you'll use regularly are your student network drive (your.name@ocdsb.ca- your student ID), the South Carleton Docs drive (Handin/Handout), and the computer's internal hard drive Data (D:) as well as several cloud locations like gClassroom and gDrive
(File Naming Rules or "Naming Conventions")
When creating a project file for later submission, use the following format:
Lastname_Firstname_Description
Your student drive is where you should save your work. It is a network drive, so it may take a while to save files there sometimes (depending on how many people are reading/writing to it). Be patient and save one thing at a time.
- The South Carleton Docs drive is where the HANDIN and HANDOUT folders are. Occasionally you will need to get files from the HANDOUT folder.
- Your USERID and PASSWORD that you use to login are for your use only. Keep this information to yourself - you are responsible for any use (or misuse) of your account - do NOT "share" accounts with other students.
- You can access your server folders (both your Student Network Drive and South Carleton Docs) from home by going to VM OCDSB and following these instructions.
Classroom
Most of the materials/ assignments we'll have in the course will be retrieved from the Google Classroom for the course. Relevant materials may be listed under the assignment files there.
Website
In other cases, materials will be provided on the website
Handouts
Occasionally files that are large will be given in the HANDOUT folder on the South Carleton Docs drive.
Classroom
Most of the materials/ assignments we'll do in the course will be submitted to the Google Classroom for the course. Each assignment will indicate the location for submission
Open you student drive (protip: Win+E opens explorer).
Create a folder for course work named TGJ1O on your student server account (It's the first network drive and should have your name on it). You can use the icon up at the top left of the window or - protip - right click in empty space and New>Folder
Using the same method create a text document in that folder with your name in the text document's title. You can put whatever you want IN the text document. For example, it could just be ':)'
In this simple assignment you will create folders to help you keep your work organized. You will create a TGJ1O folder. Inside of that you will create 5 other folders: Engineering, Programming, Design and photography, Animation and lastly one called Video and Audio. To do so:
Click on the folder icon on the bottom toolbar, then browse to the THIS PC icon on the left of the window. DON'T CLICK ON DOCUMENTS. While that is safe at home, here at school the link to your personal server folders is sometimes broken and it will store to the C drive. You don't have access to any work stored there. Alternatively, press the windows key and the letter E (Win+E) and that opens windows explorer.
Click on the icon for your personal drive space (Under Network Locations> P drive). It will have your login name (e.g. your.name@ocdsb.ca- or it might list your name instead)
Open the TGJ1O folder.
Inside the TGJ1O folder, create 1 of your folders by clicking on home>NEW FOLDER icon up at the top of the explorer window
Create 1 of your folders by right-clicking your mouse in the blank space in the right pane of your explorer window. Choose New>Folder
Create that last 3 folders any way you prefer (there's also a new-folder icon up on the top left).
Once you have completed this task make sure your explorer window is open showing your newly created network folders in your network space. Take a screen snip using the screen snip tool WIN+SHIFT+S and grab a selection to save. The Action Center (see picture below) will show that you have a screen snip you can edit/save. Click on it. The click on the old disk icon (below right) to save that picture.
IN WINDOWS 11 THE ACTION CENTER MAY NOT APPEAR when you use a snip. In which case tap WindowsKey then type in Snip. Then the + in the top left corner to take the snip.
Call it Yourname_Assignment #1 and save it into your network folder in the ENGINEERING folder you just created.
ALSO paste this picture to google classroom for Assignment #1 and submit it by clicking on ADD>FILES
Call me over to make sure you've done this right if you're worried about it
Action Center showing screen snip available
How to save picture from the screen snip tool
In this exercise you are to create a Google Site. If you need additional instruction beyond what's taught in class there is a lot of instructional material out there.
You are to create a homepage (feel free to embellish it with whatever you want). Now create 5 more pages, one for each unit of the course (ie Engineering, Programming, Design/Photography, Animation, Audio/Video). Using Google's image search tools (see picture below) to filter for creative commons use, find a representative picture for each webpage on your Google Site. You can use the snip tool to grab and paste the shot in (or any other method to get the picture).
On the Engineering webpage on your website
Arrange the webpage into a 4 column table, and fills in the following details:
Its name
When was it created?
Why was it significant? (paraphrase findings from your research)
Find a youtube video that explains what it was, or why it was important
So for example, the first row will read:
Abacus | ~1300BC | Ancient weapon used by the merchant class |
<youtube embedded video>
This is an example of what your page could look like
List of devices
Pascal's Calculator
Babbage's "Analytical Engine"
Zuse 1-3
Eniac
Univac
Altair
Commodore-64
Apple IIe
IBM-PC
Apple Macintosh
Atari 2600
Sega Saturn
Xbox
Cat 5 cable
When complete, ensure the site is published and then click on the link icon to get the published link. Paste that link into Classroom and turn it in.
Since we're learning to use the computers in "a business setting" we will focus on modern digital, personal computer systems. A "SYSTEM" a collection of things that somehow work together. A "Computer System" is a combination of HARDWARE and SOFTWARE designed to manipulate information.
1. HARDWARE - Physical "components" that have been designed to work together. Hardware components are specifically designed to:
Input Information
Store Information
Process Information
Output Information
2. SOFTWARE - Digital information that directs the operation of the hardware. Software can be stored on a "physical medium", but at it's purest, it is just 1's and 0's in meaningful, coded combinations. Three categories of software would include:
Applications (e.g. Word, Call of Duty, Chrome)
System Software (picture below - runs the OS)
Programming Tools (technically still applications, but differs subtly since the first two categories use the computers towards a pre-designed end whereas this one uses application towards YOUR end)
Computer Applications
A computer application is a piece of software that controls the components of a computer, and gives it the ability to perform a specific function. For example:
Word Processing
Spreadsheets
Graphic Editing
Driver
Web Browsing
Animation
Video Editing
Background Services
Games
Are all typical examples of software that can be installed in a computer system to give it a greater range of functions.
Applications are typically launched by double clicking a file that has an "EXE" file extension on a PC
Each different will likely output files in their own "languages", and they may not be compatible with each other. (list of file extensions)
Commercial Applications can cost hundreds to thousands of dollars
Shareware Applications can be relatively inexpensive, but of limited quality or ability
"Open Source" Applications are typically free, and are as good and updated as the people who volunteer to develop them.
Exercise:
Group up with your neighbour. Come up with a list of all the various word editing pieces of software available to you on your computers right now. <5 minutes>
File Formats and Extensions
Applications that store your work in files each use their own "language". These are referred to as "File Formats". They may be specific to one particular application, or they may be a common standard between many different applications.
Extension (format)
File Function
Typical Application
.doc, .docx | word processing | Native to MS Word
.jpg, .jpeg | rastered image file | Microsoft Picture Viewer, Paint, Photoshop
.xls, xlsx | spreadsheet | Native to MS Excel
.htm, .html |markup language (web page) | Viewable in browsers, editable in everything from website design software to Notepad
There are two types of hardware associated with computers. Internal hardware and peripherals ("plug-in hardware").
A typical PC consists of a case or chassis in the desktop or tower case and these components.
Motherboard (things soldered/attached to the board)
• CPU (brains of the box)
• Computer Fan (cools down the computer to keep it running efficiently)
• RAM (temporary information storage)
• BIOS (boot up instructions)
• Digital Circuitry (allows communication between mobo locations)
• PCI Slots (allows for peripheral component card)
• PSU (powers the machine)
Buses (integral slots/ports soldered to the board)
• PCI (connects pci card to the rest of the computer)
• USB (connects removable components to mobo)
• Hyper-transport (specific high speed connection between north and south "bridge" : chips)
• AGP (graphics port)
• ISA (pathways for logic/communication)
• EISA (enhanced versions of ISA)
Expansion Cards
• Video
• SATA
• Audio
• Specialty
Storage Media
• CD-Rom
• DVD-Rom
• BD drive
• HDD (IDE and SATA)
• Flash drive
• Cloud?
Input devices
• Mouse
• Keyboard
• Digital Camera
Output Devices
• Printer
• Scanner
• Monitor
• Speakers
• Headset
The CPU
Architectures: E.g. Celeron, Dual Core, Core2 Duo, Core2 Quad, Core i7 - deals with how calculations are made and how information flows through the CPU
Features and Metrics: Cache (ie. 8MB L2), Clockspeed (ie. 2.66GHz); Bus (1066FSB)
In this assignment you are to act as the purchaser in the IT department of your organization. You must purchase 50 workstations that have to be identical. You have an overall budget of $35,000. Figure out the maximum cost PER workstation (computer). Because you're buying in bulk, you are given a 15% discount - so apply this calculation when getting your quotes from the various companies. You need not buy keyboards, monitors or any other peripherals, however the IT manager said they would like to get monitors if they could be obtained within that same price-point.
Working in MS Excel
Working in Google Sheets
Step 1: Setting up the sheet
(in MS Excel)
Upon creating your sheet, save it to your network filespace as Yourname_Assignment #3.xls by clicking on the Quick Access button in the top left corner (see image above)
(in Sheets)
log onto google suite and go to sheets. Change the title from "untitled spreadsheet" to "Yourname_Assignment #3"
In either Sheets or Excel
Using the Font Style dropdown change the font (shown as Calibri above) to a sans-serif font of your choice (like lucida sans). Choose the centering text icon from the alignment group in the ribbon (hover your cursor over each icon, choose "center")
You will be using cells that will create a table that is 5 columns wide by 6 rows. Title each column in the same sans-serif font from your title, but at 20 pt. font, with the following labels:
Column 1: Computer Provider;
Column 2: Computer Model;
Column 3: Computer Components;
Column 4: Cost per computer;
Column 5: Cost per computer - with discount
Column 6: Total cost of all computers
Column 7: System Graphic
Step 2: Researching quotes
You are to find your quotes from to the following websites
Dell Canada's
Lenovo
HP
BestBuy
Some local computer stores are:
www.shoprbc.com (limited selection)
You are primarily looking for 4 things in a machine:
1) Processor (cpu)
2) Memory (ram)
3) Storage (hard drive)
4) Video (onboard, or is it a separate card)
If you're stuck, in a business machine you're looking at something like the following: CPU: i3 or i5, 4 GB RAM, 1 TB hard disk drive, Windows 10 Enterprise and typically it's an onboard video chip like "intel UD 750"
Find a GOOD, but small graphic for each machine system being bought (e.g. get a picture of the dell computer for dell's quote, a picture of an Acer computer system from Acer's site etc...), and use a screen snippet to include it in the cell for that row in the last column
Step 3: Applying the discount
Figure out what amount of money you have per workstation. Apply a 15% group discount to each vendor price you are quoted.
In order to automatically apply the discount in the Cost-Discount column (#5) we're going to use formulas in excel.
in cell E2 press + (or if you're using gSheets, then the equal sign '=' ) , then choose left bracket. Notice it's waiting for you to choose a cell? We want a formula that takes the original price, and subtracts 15% from it, to do so we'll put in D2-(D2*0.15)
Step 4: Formatting the sheet (Excel)
Let's spruce up the sheet a bit. We're going to use one of the pre-set formats for making the sheet look nice. Select all of the completed cells in your sheet.
From the Format as Table dropdown choose one that looks like the one I chose at right (table style med #6)
Notice the annoying dropdown indicators that showed up in the title (see below)? Get rid of them by going to Sort&Filter (button far right) and turn off filters
One last thing, everything would be separated clearer if we chose to include cell-lines. Let's do that now. Under the FONT group there's a dropdown icon that allows you to add lines to your selection. Go ahead and add all border and internal lines.
Step 4: Formatting the sheet (gSheets)
Let's spruce up the sheet a bit. We're going to use one of the pre-set formats for making the sheet look nice. Select all of the completed cells in your sheet.
From the Format option on the toolbar (see left). Choose a THEME of your choosing.
Now choose Format>Alternating Colours (see right)
Choose a style and hit DONE
Now lets insert lines by clicking on the icon that looks like a heavy-lined window (see image below left). Choose ALL BORDERS
Step 5: Creation of a business brief for the IT manager
Create a one paragraph MS Word document or gDoc called Yourname_Assignment #3 that summarizes your findings and your recommendations to the purchasing department.
In your excel sheet/google sheet highlight the row that is the "winning computer vendor" (e.g. in my example below Dell Canada) highlight and as a screen snippet (WIN+SHIFT+S) include this picture in your business brief to the IT manager.
Open your group's computer and identify the parts inside and the wiring connections.
- DO NOT DISCONNECT any wires or take out any parts today (you will another day).
- Take pictures of inside the computer so you can see the individual parts.
- You should be able to find and show in pictures:
1) Power supply; Power supply wires to motherboard and other devices (hard drive, optical drive);
2) Hard drive;
3) optical drive;
4) Wires:
from front of case (power button, lights, USB ports) to motherboard (hint: it's a bundle that's been cut).
Data wires from motherboard to hard drive/optical drive;
5) Motherboard and its basic parts including:
CPU
North Bridge
MEMORY slots
Expansion card slots;
graphics card slot
- MAKE SURE THE PICTURES ARE IN FOCUS before you send them to computer. (zoom in on the phone).
- Send the pictures from phone to computer using email, upload to Google Drive, or a wire connection.
- divide picture labelling work evenly among your group members. Each picture should have the name of the group member that did the labelling work.
- Draw on the pictures (shape or freehand) using snipping tool or Photoshop, or some other picture editing tool to show the parts by circling them or pointing to them with an arrow. Make sure you Save As JPEG or PNG.
- A picture may show multiple parts.
- The same picture may be used more than once and by more than one group member to show different parts.
- WHEN THE PICTURES ARE LABELLED, Create a Google Doc and share it with your partner(s). Put your group member names (if applicable) on the top as well as the assignment #, followed by the pictures, into the document. Each picture should have the name of the group member, one or two circled and labelled parts, and the name of the person who did the labelling work.
Arrange the pictures in groups by the person that worked on them.
- Name your document: YourNamesCombined_ComputerParts. You will each submit the document to Google Classroom
A numeral system (or system of numeration) is a writing system for expressing numbers, that is a mathematical notation for representing numbers of a given set, using graphemes or symbols in a consistent manner. It can be seen as the context that allows the symbols "11" to be interpreted as the binary symbol for three, the decimal symbol for eleven, or a symbol for other numbers in different bases.
(source)At first, it would seem like using any number system other than decimal is complicated and unnecessary. However, since the job of electrical and software engineers is to work with digital circuits, engineers require number systems that can best transfer information between the human world and the digital circuit world and those forms are usually binary, octal, or hexadecimal. It turns out that the way in which a number is represented can make it easier for the engineer to perceive the meaning of the number as it applies to a digital circuit. In other words, the appropriate number system can actually make things less complicated.
The decimal counting system comes from the greek prefix ‘dec’ meaning ten. This makes sense to us because humans have 10 fingers to count on, and thus we developed ten digits in which to count: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9.
If you can recall back to when you first learned math in primary school, we were taught that from 0-9 we are counting in the ‘ones’ column, but 9 is the biggest single digit that we have, so we increment our next column like an odometer, ‘tens’ to one, and then reset our ‘ones’ column back to 0.
This method of counting makes a lot of sense to us because we can count it on our fingers, and to increment to the next unit, we simply add a 0 to the end, and we’ve multiplied by 10 and gone from ones to tens, or tens to hundreds etc.
Decimal is great for us, but completely counter to the way a computer works. A computer doesn’t think between 0-9, it thinks in either ON or OFF, HIGH or LOW, 1 or 0. This is due to the way that the silicon hardware works, a transistor can either turn on or off, it can’t be in between. Which brings us to the binary counting system.
A Binary Number is made up of only 0s and 1s.
110100
Example of a Binary Number
There is no 2, 3, 4, 5, 6, 7, 8 or 9 in Binary!
A "bit" is a single binary digit.
Binary numbers have many uses in mathematics and beyond.
To show a number is binary we do the following (picture at right), or sometimes we show it as 0b e.g. 0b11010
To show numbers in decimal 0d18
or hexadecimal 0x1F
As with the decimal system the far right column is the "1's" column (2^0). We use all the digits available to us to count up in this column. 0 then 1. But then we've hit our cap, so like an odometer, we roll over to the next column.
The next column over is the 2's column (2^1). We count all the digits there we can 0 then 1. But then we've hit our cap, so like an odometer, we roll over to the next column.
Next column over is the 4's column (2^2). We count all the digits there we can 0 then 1. But then we've hit our cap, so like an odometer, we roll over to the next column.
Binary to decimal:
So what is the binary value 10101110 in decimal? The fastest method is to make a table. Then find the column number representation (e.g. the 128 column or the 16 column). Lastly add the values together.
So we added (1x128) + (0x64) + (1x32) + (0x16) + (1x8) + (1x4) + (1x2) + (0x1) = 174
Decimal to Binary:
An easy method of converting decimal to binary number equivalents is to write down the decimal number and to continually divide-by-2 (two) to give a result and a remainder of either a “1” or a “0” until the final result equals zero. If there's a non-perfect division (e.g. the remainder is 0.5) then the remainder becomes 1 and the number rounds down.
NOTE: THE FIRST DIVISION IS ON THE RIGHT, THE LAST DIVISION IS ON THE LEFT
e.g. the number 294
divided by 2
is evenly 147 with a remainder of 0
divided by 2
is 73.5->73 (there's a decimal so we round down) and the remainder is 1
divided by 2
is 36.5->36 with a remainder of 1 (rounded down and the # becomes 36 with the R =1)
divided by 2
is evenly18 with a remainder of 0
divided by 2
is evenly 9 with a remainder of 0
divided by 2
is 4.5->4 with a remainder of 1
divided by 2
is evenly 2 with a remainder of 0
divided by 2
is evenly 1 with a remainder of 0
divided by 2
is 0.5->0 with a remainder of 1
So the number's : 1 0010 0110
‘What?!’ I hear you say? If computers work best in binary, why do we need to use another counting system? It’s a great question and there are a few different reasons why hexadecimal is commonly used in computing systems.
Hexadecimal is much easier for humans to interpret than binary, its closer to our base 10 counting logic than binary is. It’s also requires far less digits to represent a number than both binary and decimal, and isn’t overly hard for computers to understand.
Before we can take a look at why hexadecimal is great to use, we need to understand how it works first. Our plain old decimal system is known as base-10 counting, binary is known as base-2 counting, and hexadecimal is known as base-16 counting.
Instead of stopping at 9 (our 10th unique digit) to increment the next column, hexadecimal uses 16 unique digits to represent the numbers 0-15. Except we only have 0-9, so we use A, B, C, D, E, and F for the numbers 10-15. Hexadecimal is represented with either ‘0x’ or ‘h’ before the number.
e.g. 0x1C8
Below is the digit map
In HEX we have a
1's column (16^0)
16's column (16^1)
256's column (16^2)
And in grade 9 we'll ignore anything greater
Notice the hex value for decimal 0d12->is 0C
for 0d255 it's 0xFF
decimal to hex:
So what is the decimal value 122 in hex? Like in the case of binary we'll be dividing. Start by dividing the number by 16
122
122 divided by 16 is unevenly 7.625
So the integer division result is 7 (throw out anything after the decimal point). Remainder 10. However, the HEX value for 10 is A. Record it on the RESULT column.
7 divided by 16 is unevenly 0.4375
So lose the decimal and the result is 0 with a remainder of 7
So the hex for 0d122 is 0x7A
hex to decimal:
So what is the decimal value for hex 0x37? As with binary, the fastest method is to make a table. Then find the column number representation (e.g. the 16's column or the 1's column). Lastly add the values together.
So 48+7 = 0d55
Binary to Hex
We are simply going to break our number into 4 bits at a time. So let's take 0b101101
Breaking it into 4 bits (called a nibble):
0010 | 1101 (note we add leading 0's on the left just to hold the places)
so that's decimal 2 and decimal 13, which in turn are hex 2 and hex D
So 0x2C is the conversion.
Hex to binary
Is just the reverse of the above example. Eg. let's convert 0x1C8 to binary
Breaking our hex into nibbles is as simple as breaking them into each column
1 | C | 8
which is decimal 1 | 12 | 8
which is binary 0001 | 1100 | 1000
so 0b111001000 (ignoring the leading 0's)
Complete the following conversion assignment and show your work. You are going to get the IPv4 and MAC address from your NETWORK CONNECTIONS panel in order to do this.
Submit to Google Classroom when completed
In Windows 10/11:
WIN+X and choose NETWORK CONNECTIONS. Now choose ETHERNET (or wireless). Click on the adapter icon in the main window that appears. At the bottom will be your adapter address (like the image below). Click on Properties
IP address in top pic
MAC (hex) address in bottom pic
Students are responsible for setting up their own computer, getting it connected to the router in the room and testing connectivity to other computers in the lab.
Boxes will be given as a collection of parts. You will need to put together everything in/on your computer and hard-wire it to the router in the room.
You will install the OS, and install any relevant drivers to get the computer running and connected.
Each computer must:
have a keyboard, mouse and monitor.
be assembled/connected properly
be able to boot up into the windows OS.
once the OS (operating system) is installed able to access other computers using:
WIN+R, type in CMD (for command).
be able to ping other computers on the network (from the command prompt type in "ping 10.190.1.2" (or whatever IP our address for our network will be)
run DXDIAG from the command prompt
TAKE PICTURES AT EACH STEP
DURING INSTALLATION:
of the completed assembly (guts of the computer)
of the post screen (black and white bios boot screen)
of the BIOS where you set the CD or USB to be first boot priority
of the installations of windows (at some point in the setup process)
POST INSTALLATION
in the command window (WINKEY+ CMD) of the ping report as you communicate to another computer
of the computer running with Windows on it running DXDIAG (from the command window type in DXDIAG and include the pic in the report)
Describe:
How you installed the OS (e.g. off of usb? Off of CD?)
Roughly how long installing the OS took.
Roughly what steps were taken to get the OS up and running
The result of the DXDIAG report, including:
What is the CPU type (processor)?
How much RAM is in the machine (memory)?
What is the video card or chip that is being used (on the display tab)
Describe any challenges along the way for the install.
What changes would you make in installing your next OS?
When the MS Word/gDocs report is complete make sure the pictures you took are included along with descriptions in the section above. Submit it to Classroom. One report per group is sufficient but please CLEARLY identify group members and any contributions they made (in general terms) and everybody must submit their own copy of that report. To be clear 'taking pictures' is helpful towards the report, but insufficient in terms of meeting all expectations.
Basics of computer networking