Mit-xxx Visual BASIC for Engineering

Mit-xxx Visual BASIC for Engineering

SET-105 - Technical Computing WELCOME! The most important thing for an engineer to learn is to figure things out on your own. Instructor: Dan Wolf http://web.acd.ccac.edu/~dwolf/ 2/18/2020 1 Week #1 Introduction and MS_Word Agenda : 1.Introductions

2.Course Formalities 3.Retirement 4.Arduino Summary Demo Homemade Force Sensor Lab Assignment: Lab #1.2 Google Account Lab #3 MS_Word Resume 2

Student Information 1. Name 2. Student ID Number 3. Phone Number 4. Alternate Phone Number 5. Do you have any hardware or electronics experience? What areas? 6. What is your major? Is your major a 2 or 4 year program? 7. What do you already know? Word, Excel, PP, Mathcad, HTML 8.c. What is your expected graduation date? 9. Your EMAIL address 3 Introductions 1. Introduction to the Instructor

2. Student Introductions a) Name b) Where do you work or what is your degree? c) Why are you taking this class? 4 Administrative Information 1. Grading 2. Syllabus 3. Questions? 5

Course Introduction This is a course in the application of computers in the engineering and engineering technology fields. Students will develop skills in the solution of engineering equations using computer-based analysis programs. The application of office productivity tools to engineering reports, with graphics from multiple sources, will be practiced. The movement of documents, engineering drawings and data electronically through the local area network and the internet will be covered. We will work with the following: Word, Excel, PowerPoint, Mathcad, and HTML 6 Syllabus Decision

This is a small class do we want to go off the (syllabus) grid? Lets discuss and decide. 7 General Advice The internet contains a huge wealth of information about any subject. Dont limit your learning material to what I pass out in class. If you want to do something and dont know how, start doing Google searches. Many search results will not be appropriate (not right or too complex), but if you look around, you can almost always find what you are looking for. Course Objective: Helping you realize that you can learn material yourself without much guidance. I will assist but will

not be telling you everything so you must Figure things out yourself. 8 Unit / Lab Assignments for SET-105 See the Syllabus for a list of assignments/labs 9 Maximize Your Time Do not get behind ! You will need the entire scheduled class time each week 10

Demo of the Night Information There will be a non-graded mini-quiz on the last night that will ask you to describe the technical concepts of each of the demos. This is part of an assessment initiative that I am doing to evaluate the value of technical demos without actual hands-on experiments. Your attention and questions during the demos are greatly appreciated. Week#1; Arduino and the Homemade Force Sensor Week#3: Arduino Controlled Hand Week#4: Arduino DC Motor Speed Control Week#5: Arduino Servo Motor Control Week#6: Arduino Stepper Motor Control 11 Assignment #1 Questions to ask of two other students: 1) Name

2) Degree 3) Name of Pet 4) Employment 5) What do you want to learn from this class? 12 How much is your time worth? 11 participants in the workplace can cost the company $14.67 per minute. 13 The Microsoft Calculator

14 Additional Advice - READ THIS! Set Windows Explorer to show the file extensions: a) From the Menu Bar, click on View b) Check File name extensions 15 File Management How familiar are you with Microsoft Explorer? File Copying File Moving Folder Creation CCAC Network Shared Drives Demo provided if necessary.

16 Google Drive Topics 1. Installing Google Drive (on-line file storage) 2. Installing FreeFileSync 3. Using FreeFileSync to backup and synchronize folders 4.

Logging Off Google Drive 17 Things are always changing! Note that the internet, Google, Microsoft, Windows 10, Windows programs, etc. are always being updated with new features. As a result, instructions created today may evolve into something else tomorrow. If a pre-existing link, process, command no longer works, then you must analyze the situation and figure out a work-around. This is normal. It is also true that I will not tell you everything in exact detail so you will be expected to Figure it out by asking me, others, or searching Google, etc. 18

Utilities 1. Installing FreeFileSync 2. Using FreeFileSync to backup and synchronize folders What utilities do you use? 19 The Home tab a bc

d e f g The Home Tab allows you to change: a. Format Painter (a timesaver) b. Font type, size, and color. c. Bold, Italics, Underline d. Left, Right, or Center Justify. e. Bullets and Numbering f. Indent Text (this is much better than using spaces to align text) g. Find and Replace

20 The Insert tab a b c d e f g

h The Insert Tab allows you to insert: a. Tables b. Pictures (You can adjust the picture properties, crop, and add lines & shapes) c. Charts and Graphs Insert | Chart d. Hyperlinks e. Headers and Footers f. Page Numbers g. Equations Insert | Equation Modify an equation: click on the equation then click on the Design tab h. Symbols Insert Symbols 21 The Layout tab a

b c The Layout Tab allows you to change: a. Margins b. Orientation of the page between Portrait and Landscape c. Line Spacing 22 The Review tab a b

c The Review Tab supports: a. Spelling and Grammar Check b. Thesaurus c. Translate 23 The Developer tab Show the Developer tab: a.Press the File button next to the Home tab and choose Options. b.Select the section Customize Ribbon.

c.In the right pane, enable the selection field before Developer. d.Press OK to close the open dialog. Developer | Record Macro, Stop, Run 24 Additional MS-Word Features Pictures: Inserting Pictures Insert | Pictures Inserting Charts Insert | Chart Cropping Double-Left-click on Picture | Crop

EquationTool Insert | Equation Insert | Symbol 25 MS-Word: Resetting Spell Checker When Spell Check finds a word it doesnt recognize, it offers you the opportunity to change or ignore the word. If you ignore the word, the feature remembers; the next time you run Spell Check, it wont stop at the ignored word. Most of the time, thats exactly what youll want. On the other hand, if you need to find the word later, this behavior is less than helpful. When this happens, the best thing to do just might be to start over by resetting Spell Check: 1.Click on File button and then click Options in the bottom-left corner. 2.Choose Proofing from the left pane. 3.In the When Correcting Spelling And Grammar section, click the Recheck Document button. 4.Click OK.

26 Spell & Grammar Check Reminder Are you using MS-Word for your labs? Are you using the Spell Checker and Grammar Checker? Go to the Review tab then click on the Spell or grammar icons Excel and PowerPoint also have a Spell and Grammar function. 27

Grading of Assignments Each of the assignment sheets will include a grading matrix which lists the specific items that I will be grading. Make sure you include each item in these lists when you complete the assignments. It is the easiest way to improve your grade. Take a look at tonights grading matrix now. 28 Ask me to help! Ask me to help with this assignment! You will not lose points by asking for help but you will lose points by not completing parts of the assignment. 29

The End 30 Week #2 Excel and Finance Agenda: 1.Excel 2.Demo: Pixy Tracking Camera Demo Lab Assignment: 1. Lab #2 Excel Financial Calculations 31

Do you want to be a millionaire? Tonight, I will show you how. 32 Success with Retirement Goals 1. Many companies match the first 3-6% of your contributions to a 401K retirement plan. 2. Assuming a salary of $50K/year and a company matching contribution of 6%, the company will be giving you $3000 if you contribute $3000 / 12 = $250 each month.

3. BUT, your contribution of $3000 is not taxable so you will also pay $750 less in taxes for the year (assume 25% tax bracket). 4. Your contribution of $3K yields you $3K + $3K + $750 = $6750 What would be a good reason to justify not contributing? 33 Success with Retirement Goals 1. Due to the power of accumulated interest, saving at an early age

will net a you far greater amount at retirement than if you only start saving at the age of 30-40. 2. Someone entering the engineering profession today can expect to have $2-4M in his/her retirement account at age 60 but 34 only if you contribute (early and often)! Retirement Basics In general, 401k retirement plans allow you to invest in mutual funds which consist of stocks and bonds. A 401K allows your contributions to grow without being taxed but they will be taxed when you start taking your money out. In many cases, your employer will contribute about 3-6% if you contribute 3 to 6%, matching either 50 or 100% of your

contributions. Your contributions are tax-free when you contribute but taxes are due when you use the money at retirement. If you dont contribute, then neither does your employer! 35 Two Quick Tips 1. Start now by contributing whatever you are able to do not wait. 2. Each year when you get a raise or promotion, increase the amount that you contribute you will never notice the difference.

An individual is allowed to save up to $6,000 in a 2019 IRA and $19,000 per year to a company sponsored 401K plan. 36 Excel Topics Explained 7. Cells Equations and Text entry Worksheet creation and naming Linking data to/from other worksheets Average() Function Graphing Data Entry rapid duplication techniques 8.

Additional Excel topics will be covered in a later class 1. 2. 3. 4. 5. 6. 37 Assignment Explanation Complete the assignment titled: Assignment_2_Excel_Financial_Calculations_SPRING_2020.doc 1.Create

and finish Tables 1, 2, and 3 2.Add at least one optional, either one of mine or you may make them up. Choose something interesting or related to yourself. 3.The last page of the assignment is the grading checklist. Make sure your finished work agrees with it. 4.The due date is Week#5 February 11 (or maybe later if necessary). 38 The End Thank You ! 39 Week #3 - Excel Agenda: 1. Demo of filtering simulation with Excel

2. Google Translate 3. Demo: Arduino Servo Motor Control Lab Assignment: Lab#5 Excel Assignments 40 Servo Motor Operation Servo motors can be rotated from 0 to 180 degree, but can go up to 210 degree, depending on the manufacturing. The degree of rotation is controlled by applying an Electrical Pulse of proper width to its Control pin. The servo checks the pulse every 20 milliseconds. A pulse of 1 ms (1 millisecond) width will rotate the servo to 0 degrees, 1.5ms will rotate it to 90 degrees (neutral position) and 2 ms pulse will rotate it to 180 degrees. 41

Did you know about these? Mathway is an Android high-powered graphing calculator that does Trig, Pre-Calc, Calc, Linear Algebra, Chemistry, Statistics. It could be used to check your math class assignments RealCalc is an Android scientific calculator that also does number system (Hex, Binary, Decimal) conversions which are used by programmers. ConvertPad is an Android program which will convert just about any type of engineering, scientific, or measurement unit. 42 Excel Topics 1.

2. 3. 4. 5. 6. Dates and Date Functions Goal Seeking Scenario Manager Math Functions: SIN, COS, TAN Conditional Functions; =If(A3=USD, CA, USD) Defining Cell names: Formula Tab | Name Manager 43 Goal Seeking Calculates Input values given a

desired output/result. Data | What-If-Analysis | Goal Seek The equation in B12 is =C12*D12+E12 Cells C12, D12, and E12 contain data of your choosing 44 Scenario Manager Calculates Output values given a SET of Input Values. Data | What-If-Analysis | Scenario Manager The equation in B12 is =C12*D12+E12 Cells C12, D12, and E12 contain data of your choosing 45

Scenario Manager Data | What-If-Analysis | Scenario Manager 46 Filtering Data 1) Simple Average filter Simple to implement Does not work well with large spikes 2) Discard Upper and Lower values and then Average the rest A little slower because of the required sort Cleanly removes spikes within the algorithm limits Can adjust the number of discards and averaging for tuning 3) More sophisticated methods are available 47

The Average Algorithm Example Original Raw 205 221 201 198 205 202 197 202 198 198 203 230

Avg Filter 206 206 206 206 202 202 201 201 202 202

200 200 199 199 200 200 207 207 199 199 197

197 191 191 165 189 178 48 The Discard and Average Algorithm 1, 5, 10, 234, 15, 20, 25, 30, 35, 40, 45, 50, 55, 60, 65 Sorted: 1, 5, 10, 15, 20, 25, 30, 234 The middle four averaged: (10 + 15+ 20 + 25 ) / 4 = 17.5 ________________________________________________ 1, 5, 10, 234, 15, 20, 25, 30, 35, 40, 45, 50, 55, 60, 65

Sorted: 5, 10, 15, 20, 25, 30, 35, 234 The middle four averaged: (15 + 20 + 25 + 30) / 4 = 22.5 49 Discard and Average Example Average Discard Filter Original Raw 205 221 201 198 205 202

197 202 198 198 203 203 201 201 200 200 200 200

200 200 200 200 200 200 200 200 197 197 192

192 203 230 165 189 178 50 Raw Data Without Filtering 51 Raw Data With Averaging Filter 52

With Average and Discard Filter 53 The End 54 Week #4 Excel Agenda: 1.Excel Financial Assignment Comments 2.Excel Lines, Borders, and Drop Boxes 3.Demo: Arduino DC Motor Control 4.Lab Assignment: Lab#5 Excel Assignments

55 Demo DC Motors Servo Motors Typically only turn 180 degrees and can stop at any specific position. Include a DC Motor, gearing set, control circuit, and a position sensor. Must run closed-loop. Position is controlled by PWM (the duration of the pulse determines the position), fast, high torque. Uses 3 wires (power, ground, and control). DC Motors Direct current, high speed continuous rotation, cannot stop at a specific position and can run open-loop. Speed can be controlled by PWM (the %Voltage high determines the speed). Uses 2 wires. Stepper Motors Can turn 360 degrees, slow, precise rotation, can run open or closed loop. Use 4, 5, 6 or 8 wires. 56 Financial Assignment Comments

1. 2. 3. 4. 5. 6. 7. 8. 9. Table #1 would best be extended to include two additional columns, monthly and annual, then adding up each column. Tables #2 and 3 should use links to retrieve data from the previous tables (avoid hard-coded numbers whenever possible). Were hard-coded entry values identified via a different font or fill color? Setup links to the other cells, avoid hard-coded values

Review of data and results from Tables 1 to 3. Tables 1 & 2: Monthly & Annual expenses versus Total Expenses (monthly & annual) Include screen prints of the website results (embed into the Excel and Word document) One file per assignment (attach all parts via insert object) 57 Format data so it prints well. Financial Assignment Comments Parts of this assignment are subject to interpretation so some of the answers were not what I expected, however they were still correct (given your interpretation of the question). This is to be expected in engineering. How should we deal with this in industry? Tonights comments for assignment #2 directly relate to tonights Excel assignment (#5), Assignment #5 Enhanced

Excel Tensile Calculations 58 MS-Word: Track Changes Track Changes is used when multiple people are editing the same document. MS-Word Track Changes Review | Tracking | Track Changes Review | Tracking | Show Markup Review | Accept Changes 59 Excel Lines, Borders

To create a box around some cells, first select an area of cells then: 1. From the Home tab, click on small arrow for the Box Border Icon 2. Select the Thick Border 3. There are other Border options so try a few others. 4. This is very useful to highlight or separate sections of a worksheet. 60 Drop-Box List 1) Data 2) Validation 3) List 4) Validation Data

61 The End Thank You ! 62 Week #5 Excel Agenda: Completion of the Excel assignments Excel: Table Sort, Table Filter, Conditional Formatting Demo: Stepper Motor Control Lab Assignment: Lab#5 Excel Assignments 63

Summer Class Registration is Open! Fall 2020 Registration will start on March 27 Last Date to Withdraw with a W is April 13 64 Financial Comments https://www.calcxml.com/calculators/pay07 This is how much the employer will match of your contribution (dont use 3% here). This is the maximum the employer will match of your contribution. Thus the employer will match

100% of your contribution but no more than 3%. 65 Demo Stepper Motors Servo Motors Typically only turn 180 degrees and can stop at any specific position. Include a DC Motor, gearing set, control circuit, and a position sensor. Must run closed-loop. Position is controlled by PWM, fast, high torque. Use 3 wires (power, ground, and control). DC Motors Direct current, high speed continuous rotation, cannot stop at a specific position and can run open-loop. Speed can be controlled by PWM. Use 2 wires. Stepper Motors Can turn 360 degrees, slow, precise rotation, can run open or closed loop. Use 4, 5, 6 or 8 wires. 66 Career Development Suggestion

Register for one or more of these industry newsletters and read the pertinent articles. www.allaboutcircuits.com (select Join in the upper-left corner) www.controldesign.com/ (select Register in the upper-left corner) http://www.ganssle.com/tem-subunsub.html One of your own choosing 67 Excel Table Sorting Select multiple columns

in an Excel table From the menu: Data | Sort Select the column you want to sort by then press OK 68 Excel Table Filtering Select multiple columns in an Excel table From the menu: Data | Filter Select the column and data that you want to filter

Student Stewart, L. Stein, E. Tolano, W Parker, C. Shadid, A. Lokay, J. Lyall, S. DiRita, L. Wilson, S. Rohr, J. Stewart, L. Stein, E. Tolano, W Parker, C. DiRita, L. Wilson, S.

DiRita, L. Wilson, S. 18 16 17 12 20 15 13 20 17 17 12 34 67 89

35 68 12 90 26 24 20 28 26 20 24 24 30 29 25 29

98 11 33 13 15 17 24 24 23 24 25 24 25 22 20 25

79 23 46 66 44 14 16 18 69 Excel Conditional Formatting Select one or more cells on a worksheet. From the menu: Home | Conditional Formatting Specify the parameters.

Student Stewart, L. Stein, E. Tolano, W Parker, C. Shadid, A. Lokay, J. Lyall, S. DiRita, L. Wilson, S. Rohr, J. Stewart, L. Stein, E. Tolano, W Parker, C. DiRita, L.

Wilson, S. DiRita, L. Wilson, S. 18 16 17 12 20 15 13 20 17 17 12 34 67

89 35 68 12 90 26 24 20 28 26 20 24 24 30 29 25

29 98 11 33 13 15 17 24 24 23 24 25 24 25 22 20

25 79 23 46 66 44 14 16 18 M M M F F M F

F M M M M M F F M F M 70 Week #6 HTML WebPage Agenda : 1. Brief HTML presentation

2. HTML Webpage 3. Demo: The 3D Printed Hand Exam next week Lab Assignment: Assignment #4 HTML Webpage 71 Excel Percentage Calculations Assume you want to compute the Percent Elongation. The formula will depend on what data type that you define for the cell. If you use the General number style, you must divide by 100 and you will not see a percentage sign. If you use the Percent number style, you do not need to divide by 100 and Excel will include a percentage sign. Original Gage Length, in.

Final Gage Length, in. Percent Elongation, % 2.002 2.282 13.99% Original Gage Length, in. Final Gage Length, in. Percent Elongation, % 2.002 2.282 13.99 Using the Percent number style:

=(M29-M28)/M28 Using the General number style: =(M29-M28)/M28*100 72 Tensile Table Comments The Dutch text lacks parentheses so the Google translation is missleading. You have to understand the calculation and then validate the equation. Rek (%) = Final Lengte - Original Lengte * 100 -------------------------------------------------Original Lengte Rek (%) = (Final Lengte - Original Lengte) / Original Lengte * 100 Rack (%) = (Final Length - Original Length) / Original Length * 100 Same thing for the %Reduction in Area 73

Assignment #5 Comments The project grades should be the average percent of the lab grade, not the average of the number of lab points. =Sum(Points) / Sum(Total Points) =SUM(B4:K4)/SUM(B15:K15) Student Stewart, L. Stein, E. Tolano, W Parker, C. Shadid, A. Lokay, J. Lyall, S. DiRita, L. Wilson, S.

Rohr, J. Total Projects Exams 1 2 3 4 5 6 7 8 9 10 Mid-Term Final 18 16 17 12 20 15 13 20 17 17

26 24 20 28 26 20 24 24 30 29 24 24 23 24 25

24 25 22 20 25 32 33 40 40 34 31 39 40 38 37

16 17 16 20 19 13 17 18 19 14 30 30 30 29 30 28

30 30 26 30 59 60 52 55 55 51 59 58 53 55 37

32 34 36 36 31 40 40 32 40 26 22 30 27 30 30 24

30 25 27 18 18 20 19 17 16 20 20 15 14 90 94

81 82 73 89 92 100 81 93 87 92 89 96 84 72 98 96

78 97 20 30 25 40 20 30 60 40 30 20 100 100 Project Ave. Test Ave. 90.79% 88.50% 87.62% 93.00% 89.52% 85.00% 92.06% 89.00% 92.70% 78.50% 82.22% 80.50%

92.38% 95.00% 95.87% 98.00% 87.30% 79.50% 91.43% 95.00% Final Grade 89.07% 91.65% 86.13% 89.77% 82.05% 80.93% 94.35% 97.47% 81.45% 94.11%

74 Exam #1 Review You will be asked to use MS-Word, and Excel. Other than reviewing the past assignments and PowerPoint notes, I cant imagine how you can study for this exam. Bring all of your notes and assignments as it will be an openbook exam.

75 Setup your FLASH drive 1. Create a new folder on your FLASH drive named HTML_Assignment a) Right-Click on the top-level folder of your FLASH drive. b) Left-Click on New then Left-Click on Folder c) Type HTML_Assignment as the name. 2. Copy the folder named HTML-Kit to your FLASH Drive. 76 Create a shortcut for the HTML_kit editor 1. 2. 3.

Right-click on the top-level folder of your FLASH then rightclick on New and Shortcut Browse to the HTMLKit.exe file on your FLASH drive (HTMLKit\Bin\HTMLKit.exe). The shortcut will not work if the drive letter changes! 77 HTML Overview Internet Website http://web.acd.ccac.edu/~dwolf/ Google Chrome or Microsoft Edge Internet Browser Filezilla Used to upload the HTML file

up to the internet Website. index.html Contains the HTML code for the initial web page. Programmers Notepad 2 HTML editor Used to edit the HTML code. 78 Filezilla Setup 1. Start FileZilla 2. First time setup: File | Site Manager | New Site Set the general site parameters as shown here and then click

Connect: 79 Filezilla Remote Site View 80 Filezilla Upload Drag the upload icon to the remote link 81 The Basics of the HTML editor The free HTML Editor program: HTML_kit

Editor and Preview tabs HTML Template See Figure 3 and the Helpful Hints section in the assignment handout. 82 Startup Details

To view your website: http://web.acd.ccac.edu/~YOUR_USER_NAME To start the HTML-Kit editor: YOUR_NETWORK_S_DRIVE\HTML-Kit\bin\HTML-Kit.exe 83 Helpful Hint for the HTML_Kit editor Leave the S for the CCAC website address: This is correct: https://www.ccac.edu/ Do NOT type HTTPS for the personal website addresses: This is correct: http://web.acd.ccac.edu/~dwolf 84

Common HTML tags (commands)

Center text
new line

your website using FileZilla The normal revision sequence is: 1. Edit the HTML file with the HTML editor and save it to your harddrive or FLASH. 2. Upload it to the website with FileZilla. 3. Use the Internet Explorer or Google Chrome to verify that the file is working on the internet. Use the Internet Explorer Refresh button to load the new version. If you use the HTML_Kit editor, you can preview the webpage before using FileZilla and you can upload without FileZilla. 86 HTML Comments

Startup and loading multiple files. Indent your HTML code so it is easy to understand. Comments explain your code: Displaying an image:

-> Picture not found Displaying an image that is also a link to a file or location:

87 The End Thank You ! 88 Week #7 Mid-Term Exam Agenda: Demo: Pixy Tracking Camera with Analog Output for XPosition 2. Student Survey tonight! 1. 4. Exam

Lab Assignment: n/a 89 Week #8 - HTML Agenda : 1.Demo: Motor/Generator via 3D printed assembly 2.Assignment: Use two new HTML commands Lab Assignment: Assignment #4 HTML Webpage

90 HTML Assignment Comments Make sure you add comments and formatting (spaces and blank lines) to your HTML code. Read the assignment sheet and make sure you meet all of the requirements. Adding extra/new Tags (HTML features) will increase your grade.

Submittal Requirements: Paper copies turned in to the instructor Electronic copies saved on the S-Drive (in the new folder) Electronic files uploaded to the internet You must test everything when writing HTML code! 91 The End Thank You ! 92

Week #9 PowerPoint Agenda : 1.PowerPoint 2.Demo: Floppy Drive Stepper Motor Demo 3.Summary/Review 4.Lab of the Exam Assignment: Assignment #6 - PowerPoint 93

Course Agenda Changes??? 1. Who has already used PowerPoint? 2. A formal report is normally required for the final assignment 3. Have you already written a technical lab report for another class? 4. Idea: Introduction to Visual Basic programming instead of a

final report? Introduction to VB Scripts ? 94 PowerPoint Topics Review and demonstration of Section #2 in the PowerPoint Assignment. Review and discussion of Section #3 in the PowerPoint Assignment General Things To Consider. 95

The End 96 Week #10 MathCad Agenda: 1. PowerPoint Review 2. MathCAD Demo 3.

Demo: Blue I/O Box via Visual Basic Lab Assignment: Assignment #7 - Mathcad 97 MathCAD Topics MathCad is installed on SO-G424-S-01 through 06 plus the ADA compliant seat SOG424-S-15. The 01 station is the instructor PC. 98 Equal Signs with local variables Purpose

Symbol Keystroke Assign a value to a Local Variable := Shift : Must be prior to the local equation Assign a value to a Global Variable

Shift ~ May be before or after the equation Display solution = = Must be after the equation or value 99

Equal Signs Start MathCad: Type the following (exactly). Note that when you type the colon :, Mathcad will display :=. Length_box:5 Width_box:4 Area:Length_box*Width_box Area= Change the value of the two variables and observe the result 100 Week #11 Mathcad Agenda: 1.Finish

the Mathcad assignment 2.Arduino 3.Demo: Lab to start next class Pixy Tracking Helicopter Drone Lab Assignment: Assignment #7 MathCAD 101 Remaining Course Schedule March 24 - Week#11 Finish the Mathcad lab March 31 - Week#12 Arduino Lab

April 7 Spring Break No Class April 14 - Week#13 Arduino lab (Mathcad lab due) April 21 - Week#14 Arduino Lab April 28 - Week#15 Formal Arduino Lab Report due May 5 - Week#16 - Final Exam (Group/Class Evaluation) On-time attendance is mandatory! 102 FreeFileSync Demo 103 Related and Alternate Utilities Online graphing calculator: https://www.desmos.com/calculator Dashlane Passport Manager https://www.dashlane.com/ Dashlane is highly rated but the free version is limited to 50 passwords.

KeePass Passport Manager: https://keepass.info/download.html KeePass has Windows and Android (cell phone) versions and the Windows version also comes in a portable version which will run off a FLASH drive without being installed on the PC. There are no limits to the free version. 104 Accessing OneDrive from a Microsoft Application Do you know where your USB/flash/thumb drive is? Do you have CCAC assignments saved on your computers hard-drive? Or in Google Docs mixed in with personal information? OneDrive is the answer to keep all your CCAC courses related work organized and accessible anytime, anyplace, from any device! Here are the directions to save to OneDrive from a Microsoft application, (Word, Excel, etc.), when using a CCAC computer: 1.Select Save As from the File Menu 2.Select Add A Place

3.Select Office 365 SharePoint 4.You will need to enter your Academic Email address ([email protected]) and click Next 5.Enter your password and click Next 6.The OneDrive file/folder list will appear and you are now able to save your file to the cloud 105 OneDrive - For Cloud Storage OneDrive - Utilize Cloud Storage Students at CCAC have access to the Office 365 application OneDrive. Log into Academic Email and click on the Office 365 button in the top left of the screen, and then select OneDrive from the list of applications. This cloud-based folder gives students the option to store files in a location accessible through any device with web browsing and internet access. While logged into the application, click on the Upload link on the top of the screen and simply select files to move from the computer hard drive to the cloud.

Then to retrieve the file, open the associated file name in the list on OneDrive and either download it back to the computer hard drive, or keep the file stored on the cloud. 106 The End Thank You ! 107 Week #12 Arduino Lab Report Agenda: 1. Spring Break next week No Class on April 7! 2.Mathcad summary comments 3. Heater Control Demo 4. Introduction to the Arduino Arduino Sensors & Shields

5. FileSearcher and SearchMyFiles Lab Assignment: Arduino Lab 108 Remaining Course Schedule March 31 - Week#12 Arduino Lab April 7 Spring Break No Class April 14 - Week#13 Arduino lab (Mathcad lab due) April 21 - Week#14 Arduino Lab April 28 - Week#15 Formal Arduino Lab Report due May 5 - Week#16 - Final Exam (Group/Class Evaluation) On-time attendance is mandatory! 109

Arduino Sensors and Shields 3. Sound Detection - +5V, Ground, and Input Signal (D4) Proximity Detection - +5V, Ground, and Input Signal (D4) Light Detection - +5V, Ground, and Input Signal (D4) 4. Opto-isolator Relay - - +5V, Ground, and Output Signal (D2) 1. 2. 110

Lab Reports - An Overview The title page should include your name, chapter# and lab title. Printouts of the programs may be referenced in the text. Discuss as many of the lab concepts as possible. Optional work is highly encouraged and required for grades above 89%. 111 Lab Report Format INTRODUCTION: Provide an overview of the topics that are involved in the lab. BODY: List and discuss each experiment. Optionals should be identified. Experiment #1 Experiment #2 CONCLUSION:

Summarize each new instruction or concept. PRINTOUTS: Include a printout of each program and its output 112 Lab Report Examples Graded Lab Report examples are located on the class website under the SET-105 Files To Download page. Make sure you include: 1) You run the Grammar/Spell checker! 2) An introduction and conclusion 3) Description of each experiment 4) Cell phone pictures, screen snapshots, and source code. 5) Title Page 6) Optional Assignments 7) Explanation of each new concept!

113 File Search Utilities 1. FileSearcher Searches your hard drive for a filename 2. SearchMyFiles Hunts within your files for a text string 114 Week #13 Arduino Project Report Demo: PLC Simulation Demo Continued

115 Week #14 Arduino Project Report Demo: TBD Continued 116 Week #15 Final Review Agenda: 1.Oscilloscope and Ohms Law Demo Lab Assignment:

Assignment #8 Formal Lab Report 117 File Search Utilities 1. FileSearcher Searches your hard drive for a filename 2. SearchMyFiles Hunts within your files for a text string 118 Ohms Law Vt = It x Rt

Vt It = Rt Vt Rt = It Ohms Law - Series Circuit Set two values and leave the 3rd cell blank: V = 10 R = 500 I= V=IxR V = 10 R = 500

I = 0.02 Volts Ohms Amps 119 Ohms Law Series Circuit It = IR1 = IR2 Vt = VR1 + VR2 Rt = R1 + R2 Ohms Law - Series Circuit Set two values and leave V, R, or I blank: Vt = VR1 + VR2 = 10 R1 = 250

R2 = 250 It = IR1 = IR2 = V=IxR Vt = Rt = It = 10 500 0.02 Volts Ohms Amps 120

Ohms Law Parallel Circuit It = IR1 + IR2 Vt = VR1 = VR2 1 1 1 Rt = R1 + R2 Vt = VR1 = VR2 I1 Set two values and leave V, R, or I blank: Vt = VR1 = VR2 = 10 R1 = 250 R2 = 250 It = IR1 + IR2 = Ohms Law - Parallel Circuit

R1 V=IxR R2 Vt = Rt = It = 10 125 0.08 Volts Ohms

Amps + Vt I2 It 121 Final Review 122 Week #16- Final Exam Exam Time: 6:00pm to 8:00 pm

All outstanding work is due. 123 Final Wrap-up Final Exam All Labs and Materials are due 124 Quality Improvement Exercise Many times, there will be a need for a group consensus to decide on a business or technical plan. If the effort is unstructured, the result: a)May become tilted in favor of the more vocal, more knowledgeable, or more senior participants.

b)May not identify enough or miss critical suggestions. c)Consume a lot of time. This exercise will demonstrate a method to solicit a large number of suggestions and then prioritize them such that the individual team members will all feel that they own the final plan. The result is a better plan, higher moral, and a clear path forward. 125 Top-Level Process 1. 2. 3. 4. 5. The team facilitator identifies the objective and the rules of engagement.

Each team member documents his/her suggestions that support the objective. Redundant suggestions are sorted out and the final list is displayed on the white board. Each team member is assigned 100 points which he/she then assigns to the suggestions according to his priority evaluation. The list is resorted with the suggestions with the most points at the top. 126 Task Objective and Rules of Engagement Objective: Generate a list of improvements for the SET-105 class. The list should include suggestions of things to add as well as things to reduce or eliminate. Rules of Engagement:

During the suggestion identification phase, the merits of an idea shall NOT be discussed all ideas shall be collected, no matter how small, costly, or impractical they may seem. Discussions are encouraged to design, explain or clarify an idea but discussing the merits of a suggestion should be avoided. The good and the bad should be addressed! 127 Suggestion Ideas There are no limits! Think outside the box! Which existing topics should be enhanced, reduced, or eliminated? Google account/drive, OneDrive, Paint, Excel, Web Page, Powerpoint, Word, MathCad, Arduino, Lab Report, file search/sync utilities, retirement topic, weekly demos, industry

comments, lecture slides, grading, demos. What new topics should be added? Too much or not enough lecture/explanation? Assignment handouts? Room and computer accommodations? Exam comments? 128 The End Thank You for taking this class! Feel free to contact me if I can assist you in the future! 129

Recently Viewed Presentations

  • Partner logo here Caregiver Mediated Intervention DEMENTIA RESEARCH

    Partner logo here Caregiver Mediated Intervention DEMENTIA RESEARCH

    Caregiver Mediated Intervention Trumps Pharmacotherapy for BPSD DEMENTIA RESEARCH Professor Henry Brodaty Director Dementia Collaborative Research Centre - Assessment and Better Care
  • Asias Environmental Issues Pollution of the Yangtze and

    Asias Environmental Issues Pollution of the Yangtze and

    Ganges River. The Ganges River begins high in the Himalayas and flows southeast through India and Bangladesh for more than 1,500 miles to the Bay of Bengal. It is the most important river to the Indian subcontinent. The Ganges provides...
  • Criminal Justice Process 1. INVESTIGATION: After a crime

    Criminal Justice Process 1. INVESTIGATION: After a crime

    THE INITIAL APPEARANCE: Must be held within 48 - 72 hours after arrest in order to protect people from being put in jail and forgotten (habeas corpus).. WRIT OF HABEA CORPUS: A writ that directs the person detaining a prisoner...
  • CSE 105 Theory of Computation

    CSE 105 Theory of Computation

    State and use the Church-Turing thesis. Describe several variants of Turing machines and informally explain why they are equally expressive. Explain what it means for a problem to be decidable. Justify the use of encoding. Give examples of decidable problems.
  • Storm Prediction Center Russell S. Schneider Steven J.

    Storm Prediction Center Russell S. Schneider Steven J.

    Storm Prediction Center Russell S. Schneider Steven J. Weiss DOC/NOAA/NWS/NCEP Storm Prediction Center Warn-on-Forecast Kickoff Workshop February 18, 2010
  • Human Body Systems Interactions Test Review

    Human Body Systems Interactions Test Review

    Define homeostasis :list 3 ways your body maintains homeostasis. ... When you have too much water, the pituitary stops releasing the hormone, so that you can excrete the excess water (pee…) Reflex. A reflex happens when your body senses something...
  • The Law of Conservation of Energy Pg.39 EQ:

    The Law of Conservation of Energy Pg.39 EQ:

    During a hurricane, a large tree limb, with a mass of 22.0 kg and at a height of 13.3 m above the ground, falls on a roof that is 6.0 m above the ground. Conservation of Energy. A. Ignoring air...
  • Physique - St John's, Marlborough- GCSE PE

    Physique - St John's, Marlborough- GCSE PE

    Physique. Physique is very closely linked to somatotype. Inherent . Very little control over it. You can affect the following… Body Composition. Percentage of body weight which is fat, muscle and bone.