CONCEPT HELP

MINF2201: Microcomputer Applications

Professor Schmidt's MIS/CS courses

 

Return to Course Home

 

Return to MINF2201 Home

 

***

WEBSITE LINKS

 

Course Information

 

Scholarship/Research

 

Personal Happenings

 

 

Various Links

 

***

COURSE LINKS

 

Course Policies

 

Course Resources

 

Online Resources

 

 

Contact Info & Online Support

 

 

 

AS Always, Your FIRST Resource is Professor Schmidt!
Nevertheless, the Various Hints/Resolved Issues Below May be a Great Resource!
Know of some Tips, Tricks, not listed? Email Professor Schmidt for Inclusion on this Page!
Lab Issues / Pearson Contact
Please Contact Pearson Technical Support for any Issue with the Online Lab that is Not Concept Based!

KNOWN TROUBLE SPOTS:

Hints and Tips to Tricky/Skilled Questions

  • Need to Crash your Exam? Follow these instruction exactly as provided:  If all else fails, crash the site using task manager - follow these instructions exactly....Close everything open on the computer and then press CTRL + ALT + DELETE together, click task manager, click on items in the broswer one at a time and click end now (If you forgot to shut down other programs be sure to choose the actual exam/trainer LAST), once you have shut down all open windows CLICK TO REOPEN THE SAME BROWSER, if it was an exam it should automatically enter you back into the exam (It may open the window minimized), if you were in a trainer homework you will need to log back into the lab and it should take you to the first question that you did not complete (try to save and exit Trainer HW's...crashing is not necessary).

  • As always, Email me if trouble persists.

SPECIFIC TIPS:

Module CH # Hint
Word 1 1

The document will appear blank. However, it contains formatting that is important to the project. Please begin following the instructions with the downloaded document even though it appears blank.

Word 1 2 Use CTRL + END to get to the end of the document. This is stated in the Learning Aid Video
Word 1 11
  • Be sure you chose the rounded rectangle - not the rectangle
  • Be sure vertical ruler is at 8 inches (use page down if you cannot scroll)
  • Be sure horizontal ruler is at margin (0 inches)
  • Click and Drag down and to the right (to about 9 in on veritical and 1 in on horizontal) and then let go
  • Use CTRL + END to get to the end of the document. This is stated in the Learning Aid Video
Word 1 18
  • Word programming counts a paragraph as any letter or group of words that has a hard coded enter at the end - even if it is only one word
  • When selecting non-continuous items use the scroll bar to go back and make sure all items are highlighted before performing the requested action
Word 1 24
  • When using the format painter double click for multiple use
  • Be sure to highlight the entire section of like items to copy the format. Partial selection will result nothing being changed
Word 1 28 Be sure to select the ENTIRE smart art graphic and not just a portion of it. All objects in the graphic should be selected with a box around the entire area so that the size for each object adjusts simultaneously. This is true for all questions of this type.
Word 1 29 Use the CTRL + END key strokes to reach the end of the document. Then it will allow you to enter the video. (This is teaching one of the fucntions of the end key.)
Word 2 8 CTRL + TAB Feature is difficult on Mac's. Either remap your keys or email professor after 1st submission for assistance.
Word 2 19 Type "PatientIT System" There is NOT a space between Patient and IT. It is not lT it is IT - the abbreviation for Information Technology.
 Word 2 21 If the "x" does not show up on the Thesaurus Pane: Check your browser, log out and back in, email me if trouble persists......(This question has been inactivated by Pearson)
Word 3 2 When instructed to a clip from office.com it IS alright to use Bing.com that pops up. Or the picture file included in the project document download can be used.
Word 3 5 When asked to insert a screen shot.....DO NOT use Internet Explorer if you want the screen shot to show up in the word document.
Word 3 16 Mail Merge instructions are particular and must be followed precisely. When it says to copy the first line - this is the first row of the table which should consist of 3 columns and several rows. Also be sure that the placement is exact. You must create the manual page break as requested in step 15 prior to beginning this step.
PowerPoint 1   USING EYE DROPPER TO CHANGE COLOR
Be sure to click the picture First! It should show as being selected and have white boxes in the corners and a solid line surrounding it. Then click the dropper, and Finally click the desired color.
PowerPoint 2   USING EYE DROPPER TO CHANGE COLOR
There is actually a specific spot in the upper right corner of the picture that it wants you to click. You will know this spot because when you mouse over it a small pop-up box appears that names the color. When the pop-up box appears click and then it will work,
PowerPoint     Several of the trainers/exams are having difficulty with the slide content disappering. Please see 'Things not showing up' listed above. FYI- this is usually a result of a slow internet connection. This happens on campus when a lab is full, or during peak hours of use, or sometimes in bad weather.
PowerPoint     A couple of students have experienced issues with incorrect color pallets. Please read the notes above on Color and let me know if you have more issues.
PowerPoint 2 10 Grader: Be sure to click "KEEP CHANGES" after clicking to remove the background of the picture. Otherwise, the background will remain.
Excel     ***Please Note: This module has TWO additional graders. One from chapter 2 and one from chapter 3.
Excel     Percent Total Formula: (Number/Total)*100 = Percentage of total the Number represents
**In Excel this formula is often Number/Total and then the field is changed to Percent instead of General.
Excel     **ABSOLUTE VALUE** Absolute Value in Excel is denoted with the "$". The purpose is to prevent the Column or Row value that is preceded with a "$" from changing when being copied and pasted from cell to cell. This is EXTREMELY useful in Formulas. If you copy and paste the formula "=a5" it will change to "=a6" or "=b5" depending on the direction in which you copy it. However, if you copy the formula "=$a$5" it will copy as this formula in all directions.....It is also possible to only designate the column "=$a5" or only the row "=a$5" as an absolute value. This allows the other value to change as the formula is copied. The keyboard shortcut for applying absolute values is F4.
Excel    

As you click around on a chart graphic you get different areas such as chart, data series, axis, data label, data point, etc. All of these are separate from the actual sheet/slide/page. Be sure to make formatting changes to the correct area as instructed. When the Format Pane is open the name appears at the top.

Excel     If a step call for labels (in a chart or graph) and they are not input it is likely points will be lost from subsequent steps that also have to do with the labels or the formatting thereof.
Excel 2 3 Click for Video of how to perform this step.
Excel 2 7 Correct the spelling of "Tulips" on the entire worksheet in order to receive points.
Excel 2 8 If you receive no points for the formula just copy and paste it all the way down (including the copied cell) or reperform the fill and do not worry about the formatting uniformity and then resubmit.
Excel 2 20 *PRINTING SCREEN* If your screen resolution is not so that you can see the 'scaling' option use the TAB KEY to move among options. Then use the ARROW KEYS to move among specific choices within a selection. If you cannot determine how many TAB key strokes are needed to reach the 'scailing' choice open MS Excel 2013 on your computer and open the Print screen. This will allow you to see the order of the choices so you will know how many times you need to hit the TAB key. ***Please note: The TAB key will move you around among available choices on any screen, including toolbar choices on many software options.
       
Excel 3 4 If you have trouble formatting Data Labels for this question...use the Ribbon and not the right click screens to add data and format data labels. Also, when adding the labels - add them and perform the requested formatting for the bolded step all at once - do not try to do it in steps. If you continuously have trouble with this one please email me!
       

 

 

 

MAIN TIPS:
  • Use 'Reset' as often as you like!:
    1. This akin to erasing your buffer. It wipes the slate screen without harming your current position in the Exam/HW.
    2. No points are lost from it's use and Often 'resetting' is necessary in order to 'clear the slate' so the program will count your actions as correct.
  • Things not showing up? Screen Freezing:
    1. Check your browser. Be sure you are using an updated version of a recommended browser (Do not use Explorer or Safari)
    2. Run the Browser Tuneup if you have not yet done so on the computer you are using.
    3. Minimize and then maximize the screen or use ALT + TAB to toggle back and forth to the screen
    4. Click 'reset' to see if what you need loads 
    5. Try to complete the assignment by mousing over the objects needed even though they cannot be seen.
    6. Email professor your name, assignment name, lab/computer location, and time of day along with a description or video of what you are experiencing.
    7. If all else fails and you are in an Exam - see the Crash your Exam instructions at the top of the column to the left.
  • Color or Font not showing up in PowerPoint?:
    1. Check again. It is probably there. The names are very specific and often really long. What appears to be location information is often part of the color/font name.
    2. Check and be sure that you are using a correct version of Office 2013. It must be either Professional Pro or 365. Student and Business versions do not have all of the needed color, theme, tool, and other options.
    3. Check to see if you correctly performed a Previous Step changing the Theme or Varient of the file. Each theme/varient has it's own color pallete.
    4. Save your file, close out of the software program, reopen the software and allow a full 1-2 minutes BEFORE you BEGIN TYPING (there are several of the ribbon items including color that are downloaded from the cloud).
    5. Change computers. A different computer in the same lab may have the color scheme downloaded from the cloud while another computer is having difficulty.
  • Saving for Later:
    1. Click 'Save' on the MyITLab Operation Pane. DO NOT CLICK THE SAVE ICON WITHIN WORD. THE SYSTEM WILL THINK YOU ARE TRYING TO PERFORM AN OPERATION FOR THE QUESTION AND RESPOND WITH AN INCORRECT ACTION MESSAGE.
    2. Click 'OK' on the popup screen to confirm you wish to save for later.
    3. The next time you log in and click on your assignment it will start you at the first question that you did not complete. NOTE: This may be question #1. It does not mean that your assignment did not save accurately. Click 'View All' to see if there are any completed questions for that attempt.
  • Submitting an Assignment:
    1. *If you click the 'x' in the top corner, YOU HAVE SUBMITTED YOUR ASSIGNMENT.
    2. *If you click 'leave this window' on a popup screen with two choices (leave this window, stay on this window), YOU HAVE SUBMITTED YOUR ASSIGNMENT
    3. *If you click 'Submit' on the MyITLab Operation Pane, YOU HAVE SUBMITTED YOUR ASSIGNMENT.
    4. **If you SUBMIT your assignment you MUST BEGIN FROM THE BEGINNING if you wish to try and earn a higher point score on that particular assignment.
  • Viewing Submissions:
    1. Click the 'Grades' button on the left side of the Lab Screen.
    2. Drill down, by clicking in the appropriate folders, until you find the assignment you desire to view.
    3. (You can prevent the need to drill down if you click on the Custom View link under Grades. Click on the drop down arrow to the left of the Grades Button to see the Custom View option.)
    4. Click on the drop down arrow to the right of the assignment name
    5. Click 'View Submissions'.
    6. When the View Submissions screen comes up click on the various submissions on the left side of the screen to populate the right side of the screen with correct and incorrect actions, completion tips, practice launches of each question for the assignment.
    7. More information can be found on the Review Your Submission webpage.