gng1103lab2answers
pdf
keyboard_arrow_up
School
University of Ottawa *
*We aren’t endorsed by this school
Course
1103
Subject
English
Date
Apr 3, 2024
Type
Pages
7
Uploaded by gracejewan
1 Computer Essentials for Engineers GNG1103 –
Engineering Design Objective This lab's objective is to teach students how to use three critical tools. The lab is divided into three sections, A, B, and C: A.
Microsoft Excel
(A): Scientific user orientation, rather than business B.
Microsoft Word
(B): technical report basics C.
Wrike
(C): Task tracking and Gantt charts with dependency information This lab is not intended to be an exhaustive or even a complete tutorial on all
of these programs' features. Rather than that, it focuses on their most pertinent or useful characteristics. As always, "the internet is your friend," and we'll practice using it to help find a desired feature. This skill allows you to continue to be a “lifelong learner”, once you exit the classroom, and this skill is not
to be under-appreciated and is worth practicing! Someone else has probably had and has probably already solved your problem. Apparatus and Equipment Overview A PC or MAC computer is needed, with the required tools already installed, if possible. There are a limited number of lab machines available, however, as backups or for users who do not own or who forget their own computers. Do not
count on one of these being available, especially in the larger lab sections.
Pre-Lab Preparation You will also learn better, if you use your own computer than if you share the one in the lab with a group of other people. More personal “hands
-
on” time is much better for learning. While using Microsoft applications, install them and try them out to make sure that they are working before the lab period and
remember to bring your computer with you to your lab session! Also, take a look at available videos in the specific product folders in Brightspace (e.g. there is one in the ‘
Lab 1
’
folder). Watch them or take advantage of some of the many tutorial videos for these products that are available on the internet. If you don’t
already have Microsoft 365 installed on your computer, you can follow these steps and login with your uOttawa credentials: https://support.microsoft.com/en-us/office/download-
and-install-or-reinstall-microsoft-365-or-office-2021-on-a-pc-or-mac-4414eaaf-0478-48be-9c42-
23adc4716658 Note that there is supplementary high-quality video training information about these tools. You can find a large range of tutorials and information on a wide range of subjects. In all likelihood, you will be learning via the internet (or whatever replaces it) for the rest of your life.
2 Much of that information is free. However, getting access to higher-quality material generally has a cost associated with it. This will give you a good running start at the labs here and is very worthwhile, especially for the newer users in the class. However, even power users can improve. Often, such people are
power users precisely because
they have embraced the challenge of constantly learning and improving their knowledge, in whatever ways that they can!
How to “google”
Nowadays one of the most important skills to have is how to look for information. Information can be found in different forms (media, blogs, books, journal and magazine articles, web pages, etc). Search engines are used to find information around the world by just a few clicks. You will be using these skills to answer some questions during this lab.
Revision Questions (PC) What does CTRL+s
(the control key is held down simultaneously with s
) do? ______________________________________________________________________________ (MAC) What does ⌘
+s
(the command key with s held down simultaneously) do? ______________________________________________________________________________ For all of the previously-mentioned Microsoft applications (PC or MAC) how does the autosave feature work (Microsoft tools only) and how can it be customized? ______________________________________________________________________________ ______________________________________________________________________________
What are the basic elements (arranged in a grid) called in Excel? ______________________________________________________________________________ ______________________________________________________________________________ What are 3 main parts of a technical document? ______________________________________________________________________________ ______________________________________________________________________________
Why is a project planning or work planning important? ______________________________________________________________________________ ______________________________________________________________________________
3 Submission (40 pts) You will submit the answers to all your questions from each part of the laboratory in 1 single document. In total, you must submit: -
A PDF document containing the answers to all the questions from the 3 parts of the laboratory (Excel, Word, Wrike)
, a template is shown below (29 pts)
-
Your spreadsheets in .xlsx format (Excel)
, both the graph and student ones (3 pts)
-
Your version of the basic technical document
(Word) (8 pts)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
4 Lab answers Part A- Excel (15 pts)
Question 1. (PC or MAC) What is the difference between Excel files, “saved as” files with a suffix of: .tsv. What about suffixes of: .ods,.xlsx and .csv? (0.25 each for a total of 1 pts) .tsv: ________________________________________________________________________ .ods: ________________________________________________________________________ .xlsx: ________________________________________________________________________ .csv: ________________________________________________________________________ Question 2. What is the label for the cell in row 5 and column 3? (1 pts) ______________________________________________________________________________ ______________________________________________________________________________ Question 3. What is the value in cell D2 after you have typed the formula and hit enter/carriage return (or clicked with the mouse on the check mark to the left of the ‘Formula Box’)? (1 pts) ______________________________________________________________________________ ______________________________________________________________________________
Question 4. Explain the difference or the similarities between the formula in step 5 and the formula in step 6? (1 pts) ______________________________________________________________________________ ______________________________________________________________________________
Question 5. What are the dimensions of the cell grid that is specified by the cell range of A2:D6? (1 pts) ______________________________________________________________________________ ______________________________________________________________________________
Question 6. What happened? Find out by selecting the cells in the cell range D3:D6 (e.g. D3, D4, D5 or D6) and examining the formula bar and then describing what you see: (1 pts) ______________________________________________________________________________ ______________________________________________________________________________
Question 7. What does the value in cell D7 represent, in terms of the numbers that are stored in columns A, B and C? (1 pts) ______________________________________________________________________________ ______________________________________________________________________________
5 Question 8. a) How else could you calculate the exact same value as D7 if you rewrote your formula to use only the cells A2:C6 (i.e. without any intermediate summed row values in column D)? (0.5 pts) ______________________________________________________________________________
Question 8. b) In cell D9, enter your formula and compare it to the value in cell D7. Are they identical, as they should be? (0.5 pts) ______________________________________________________________________________ ______________________________________________________________________________
Question 9. What changed? Was this what you expected? (1 pts) ______________________________________________________________________________ ______________________________________________________________________________
Question 10. What happened? What formulae are in cells C4 to C6? (1 pts) ______________________________________________________________________________
Question 11. What happened this time? Was this what you expected? Verify the formulae for B4, B5, B6, C4, C5 and C6. (1 pts) ______________________________________________________________________________ ______________________________________________________________________________
Question 12. Explain, in your own words, the difference that the $
prefix makes in cell formula references, when those cells are being copied. Hint
: use words like absolute and relative or maybe ‘fixed’ or ‘changes by …’ etc.! (1 pts) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ Question 13. Using an internet search to find the appropriate Excel function (or by typing your best guess in the formula bar and investigating the autofill alternatives) determine how you would calculate the average of the numbers in the cell range A2:C6, storing the result in D8. What is this function and how did you write it in cell D8? (1 pts) ______________________________________________________________________________
Question 14. What happens when the student ID that is typed into the blue box does not exist in column B of the list below and what does this mean? (1 pts) ______________________________________________________________________________ ______________________________________________________________________________
6 Excel exercise (0.5 each for a total of 1 pts) Formula (cell C2): = ___________________________________________________________
Formula (cell D2): = ___________________________________________________________ Part B- Word (5 pts)
Question 1. How can we align our document to the right side of our page? (1 pts) ______________________________________________________________________________
Question 2. How will you number a third-level title? (1 pts) ______________________________________________________________________________ ______________________________________________________________________________
Question 3. In a document, where should the table of contents be located? (1 pts) ______________________________________________________________________________ Question 4. List all the steps you have taken to create the header and footer (1 pts) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ Part C- Wrike
Snapshot link
(6 pts) ______________________________________________________________________________
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
7 Filled-in table
(3 pts)
Scheduling Item Date or date range A
: Team formation and contract B
: Needs Identification C
: Design Criteria D
: Conceptual Design E:
Project Schedule and Cost < Reading Week > F
: Prototype I and Customer Feedback G
: Prototype II and Customer Feedback H
: Prototype III and Customer Feedback I
: Design Day J
: Final Project Presentations K
: User Manual