1 / 123

Technical Computing

Technical Computing. WELCOME!. Instructor: Dan Wolf http://web.acd.ccac.edu/~dwolf/ 11/07/2019. Week #1 - Introduction. Agenda : Introductions Course Formalities Retirement Summary Arduino Demo – Homemade Force Sensor Lab Assignment: Lab #1.2 – Google Account Lab #1 – Paint & Clipart.

douglasthomas
Download Presentation

Technical Computing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Technical Computing WELCOME! Instructor: Dan Wolf http://web.acd.ccac.edu/~dwolf/ 11/07/2019

  2. Week #1 - Introduction Agenda : • Introductions • Course Formalities • Retirement Summary • Arduino Demo – Homemade Force Sensor Lab Assignment: Lab #1.2 – Google Account Lab #1 – Paint & Clipart

  3. 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

  4. Introductions • Introduction to the Instructor • Student Introductions a) Name b) Where do you work or what is your degree? c) Why are you taking this class?

  5. Administrative Information 1. Grading 2. Syllabus 3. Questions?

  6. 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

  7. Syllabus Decision This is a small class – do we want to go off the (syllabus) grid? Let’s discuss and decide.

  8. General Advice The internet contains a huge wealth of information about any subject. Don’t limit your learning material to what I pass out in class. If you want to do something and don’t 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”.

  9. Unit / Lab Assignments for SET-105 See the Syllabus for a list of assignments/labs

  10. Maximize Your Time Do not get behind ! You will need the entire scheduled class time each week

  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. Do you want to be a millionaire? Tonight, I will show you how.

  15. Success with Retirement Goals • Many companies match the first 3-6% of your contributions to a 401K retirement plan. • 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. • BUT, your contribution of $3000 is not taxable so you will also pay $750 less in taxes for the year (assume 25% tax bracket). • Your contribution of $3K yields you $3K + $3K + $750 = $6750 What would be a good reason to justify not contributing?

  16. Success with Retirement Goals • 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. • Someone entering the engineering profession today can expect to have $2-4M in his/her retirement account at age 60 – but only if you contribute (early and often)!

  17. Two Quick Tips • Start now by contributing whatever you are able to – do not wait. • 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.

  18. 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”

  19. File Management How familiar are you with Microsoft Explorer? File Copying File Moving Folder Creation CCAC Network Shared Drives Demo provided if necessary.

  20. Google Drive Topics Installing Google Drive (on-line file storage) Installing FreeFileSync Using FreeFileSync to backup and synchronize folders Logging Off Google Drive

  21. Paint 3D Topics How to use the class file folders Adding text Inserting and rotating pictures and clipart Using the color pens Using the Fill function Cropping and use of aspect ration Saving your file

  22. 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.

  23. The End

  24. Week #2 – Class Canceled Campus Water Main Break

  25. Week #3 – MS-Word Agenda: • Assignment#1 Review • FreeFileSync Review • MS-Word • Demo: The Hand Lab Assignment: Lab #3 – MS-Word

  26. 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.

  27. Assignment#1 – Review & Comments • Follow directions carefully & ask if you do not understand • There were 7 optionals – did you do any of them? • Clearly label each optional / assignment • Your co-workers and boss are busy and will not carefully read everything you write. • Always ask yourself “What can I do to make it easier for the reader to understand?” • I usually have trouble with some of the handwriting

  28. Utilities Installing FreeFileSync Using FreeFileSync to backup and synchronize folders What utilities do you use?

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

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

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

  32. The Review tab a b c • The Review Tab supports: • Spelling and Grammar Check • Thesaurus • Translate

  33. The Developer tab • Show the Developer tab: • Press the File button next to the Home tab and choose Options. • Select the section Customize Ribbon. • In the right pane, enable the selection field before “Developer”. • Press OK to close the open dialog. Developer | Record Macro, Stop, Run

  34. 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”

  35. 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.

  36. The End Thank You !

  37. Week #4 – Excel and Finance • Agenda: • Excel • Demo: Arduino DC Motor Control • Lab Assignment: • Lab #2 – Excel Financial Calculations

  38. Resume Assignment Comments • Resumes must be perfect and must look professional. • Spell and especially grammar must be correct. • Formatting & presentation must be good. • Small fonts with a lot of white space is a wasted opportunity. • Electronic copies must be on the S-Drive. • My review was based on “general visual impact” and I did not provide deep comments on the wording and content (this is outside the scope of the course). • Talk to me before class if want an in-depth review from me (or see the LAC for a review). • Include the “buzz” words from the job ad.

  39. Excel Topics Explained See the explanation videos located on my website. • Cells • Equations and Text entry • Worksheet creation and naming • Linking data to/from other worksheets • Average() Function • Graphing • Data Entry – rapid duplication techniques • Additional Excel topics will be covered in Week#5

  40. 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 don’t contribute, then neither does your employer!

  41. Assignment Explanation Complete the assignment titled: Assignment_2_Excel Financial Calculations_FALL_19.doc • Explanation Videos are on my website. • Create and finish Tables 1, 2, and 3 • Add at least one optional, either one of mine or you may make them up. Choose something interesting or related to yourself. • The last page of the assignment is the grading checklist. Make sure your finished work agrees with it. • The due date is Week#5, September 19 (or maybe later if necessary).

  42. The End Thank You !

  43. Week #5 - Excel Agenda: • Excel Financial Assignment Comment • Demo of filtering simulation with Excel • Google Translate • Demo: Arduino Servo Control • Oct 31 – Online Lecture (no class) Lab Assignment: Lab#5 – Excel Assignments

  44. Demo of the Night Information There will be a non-graded mini-quiz on the last night that wil 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 hand-on experiments. Your attention and questions during the demos are greatly appreciated. Week#1; Arduino and the Homemade Force Sensor Week#3: 0Arduino controlled Hand Week#4: Arduino DC Motor Speed Control Week#5: Arduino Servo Motor Control Week#6: Arduino Stepper Motor Control

  45. 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.

  46. Financial Assignment • 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”) • Format data so it prints well.

  47. 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? I assigned grades up to 90% for this assignment however, as your option, I will add 10 points to anyone who revises the assignment to include the concepts discussed in tonight’s review. Due on Week#8, Oct 10. Tonight’s comments directly relate to tonight’s Excel assignment, Assignment #5 – Enhanced Excel – Tensile Calculations

  48. Excel Topics • 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

  49. 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

  50. 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

More Related