CSE180 FAQ on MyITLab

Q1:  What is MyITLab?

A: MyITLab is an online interactive Microsoft Office training program developed by Pearson - the textbook publisher, we will use the program to train on MS Excel and MS Word 2013.

Q2:  Are there any system requirements to run MyITLab 2013 in my home PC?

A:  Yes. Each client computer [workstation] running a MyITLab must meet the minimum system requirements described at the following website:

http://www.pearsonmylabandmastering.com/northamerica/myitlab/students/support-office-2013/system-requirements/index.html

Q3:  Do I need to install any software to run MyITLab 2013?

A:  The answer is no. MyITLab 2013 is light weighted and you need not to download any software! But you do need to check the minimum system requirements and tune up your web browser.  

Q4:  Where can I find help if I have technical questions on running MyITLab 2013?

A:  Pearson provide 24/7 technical support for MyITLab 2013. Click on the following link to search MyITLab's 2013 FAQ or contact a Pearson's representative.

http://www.myitlab.com/support/support-2013/student-support.html

1. Contact Pearson’s technical support via email, phone or chat. Email is the best.
2. Make sure you have an incident number.
3. If you didn’t receive a resolution within 24 hours from the technical support team, please email your incident number, your full name, and email address to Pearson Representative – Mr. Jay Beckenstein (jay.beckenstein@pearson.com). He will follow-up and get an answer for you.
4. In case you want to call, there’s a phone line specially reserved for ASU students, the number is: 1855-875-1797

Note: for questions posted on our course website's discussion board regarding MyITLab 2013 , we will only be able to answer those which are directly related with training or course contents, sorry that we might not be able to help you solve your PC's technical problem.

Q5:  I'm stuck on one of the training questions and can't go further, what shall I do?

You can click on a button called “Learning Aids” from the lower right corner of the training screen, then pick “Watch”, it will bring up a demonstration video show exactly the steps on how to fulfill the task. You can also temperorily skip the question by pressing the next button, then later come back to solve it again.

Q6:  I got a 100% on the Skill-based Training on MyITLab.  Does that mean that I do not have to take the Skill-based Exam?

A:  Yes. For each chapter, MyITLab will record 2 grades - the highest training and exam grades. Your final grade for the chapter will be the higher of the two grades. So if you receive 100% in the training, you need not to do the exam.

Q7:  How many times can I take the the Skill-based Training & Skill-based exam?

A:  You have unlimited times to do the Skill-based trainings, but you only have 3 attempts on the Skill-based exam BEFORE the due date/time. Skill-based exam tests on exactly the same set of skills as trained in Skill-based trainings, so make sure you do the training first before you take the exam. Once the  due date/time is past, you won't be able to do the Skill-based Exam.   

Q8:  I didn't do well in the training (or exam) and I'm worried about my score, what shall I do?

For each MyITlab chapter, the system will record two scores, the highest training score and the highest exam score, your final grade for this chapter will be the higher of these two. Also, each MyITLab chapter is only worth 2% towards your final grade, so no need to worry too much if you didn't do well in one chapter. On the other hand, try your best to get 100% in each chapter's training.

Q9:  Do I let those in charge know I have completed the assignments in MyITLab or will the program record and update my grade itself?

A:  For myITLab, you do not need to inform those in charge of your completed assignments.  Just be sure to press the "Submit" button after the pre-test, and a score will be automatically recorded on the MyITLab grade book.

Q10:  Can I run MyITLab on my Mac? (Notes to Mac users)

Yes, from above website you can see that MyITLab 2013 does support Mac OS. We tested all traing questions by using a Mac in Coor 150, they all work! For few training questions (< 4), the demonstration video only shows the solution by using a PC's short cut key, in such a case, you might need to use alternative methods, such as using the Ribbon to complete the task. This is because a Mac keyboard is different from a Windows keyboard.

MyITLab simulations are programmed to accept PC methods and keyboard shortcuts. When using the Mac solution, although using a Mac computer, the simulations will still operate as though on a PC due to how they are programmed.  Therefore, Mac-specific shortcuts, such as Control+Click to open the right-click menu, will not be recognized by the simulation.  In such cases use alternative methods, such as those that use the Ribbon, to complete the activity.

Q11:  Where can I find the mapping between a Mac keyboard and a PC keyboard (for Mac users)?

The following list contains some examples of actions where standard Mac shortcuts will work in MyITLab training program.

Action/Operation (PC Keyboard)

MAC Shortcut or Alternative Solution by using MS Excel (or Word) Ribbon

CTRL + HOME

It simply means move the mouse cursor to the very beginning of the document

CTRL + END

It simply means move the mouse cursor to the very end of the document

To select non-adjacent cells, for example: select cell ranges B3:F3 and A4:A8 at the same time

Inside the training program, click in the Name box (a text box on the upper left corner of the training screen, right below the ribbon), type b3:f3,a4:a8, and then press ENTER, ranges will be selected, then you can proceed accordingly.

Double click Excel Sheet name text and use the

Select All/Cut/Copy/Paste action to change the

sheet name

Command+A/ Command+X/ Command+C/

Command+V

 

Double click a cell in Excel grid and use the Select All/Cut/Copy/Paste action to manipulate the cell contents

Command+A/ Command+X/ Command+C/

Command+V

 

Click inside a text box control in a dialog and use

the Select All/Cut/Copy/Paste action to manipulate the contents

Command+A/ Command+X/ Command+C/

Command+V

 

Double click a title text in an Access Form View and use the Select All/Cut/Copy/Paste action to change the text

Command+A/ Command+X/ Command+C/

Command+V

 

 Click HERE or HERE for a Microsoft-maintained list of keyboard mappings using a PC keyboard on a Macintosh.

Q12:  Can I install a Windows OS on my Mac and run MyITLab from there (for Mac users)?

The answer is "Yes". Mac users, please be informed that you can use Boot Camp (a software already installed on a Mac) to run Windows on your Mac, i.e. install a dual-boot system. Be cautious that the installation procedure might be complicated for a beginner, if you plan to try it, click on the following website to find more information on it. 

http://www.apple.com/support/bootcamp/

For ASU students with a valid ASURite ID they can get a free Windows 7 or Windows 8 through ASU "My Apps". Click on the following link to log into ASU “My Apps” (use your ASURite ID and password), then search for “Dreamspark”, it will bring you to a website where you can download Windows 7 or Windows 8 for free. You will need to install it on your Mac. After this, you can run MyITlab under Windows instead. If you haven't tried Window 8 before, just to let you know in advance that desktop on Windows 8 is quite different from previous versions of Windows, if you're used to the "conventional" Windows, I recommend you install Windows 7 instead.

 https://webapp3.asu.edu/myapps/login 

MyITLab Frequently Asked Question by Chapters

MyITLab Chapters

Question

Answer/Solution

General questions

Why does MyItlab training/exam run pretty slow?

When students try to run the program silmutenously, it loads the training question pretty slow. We’re aware of this and already reported this to Pearson, please be a little patient.

 

I had saved my training to continue at a later time. But when I went back to try, it does not let me, just get a message that reads "all questions have been attempted". 

This happens when your training was not submitted correctly. Please send an email to me/TA, we will re-submit it for you and by then, you will be able to redo the training.

 

I tried opening the test and it would not load. I closed everything and logged in again, when I tried accessing the test once again it stated that I only had one attempt left, why?

This happens because of your web browser’s pop-up blocker prevent the exam/training from loading. Please Google search on how to turn off your web browser’s pop-up blocker.

 

Is anyone else using a MAC and have trouble with the shortcut for spell/grammar check? I couldn't do CTRL+Home so i tried F7 (which is the shortcut for spell/grammar on a MAC) But it didn't work,

The MyITLab simulations are programmed to accept PC methods and keyboard shortcuts. When using the Mac solution, although using a Mac computer, the simulations will still operate as though on a PC due to how they are programmed.  Therefore, Mac-specific shortcuts, such as Control+Click to open the right-click menu, will not be recognized by the simulation.  In such cases use alternative methods, such as those that use the Ribbon, to complete the activity

Excel Chp.1

Q#2: 3 ) Apply the Heading 4 style to the ranges B3:F3 and A4:A8 at the same time.

Select the range B3:F3. Hold down CTRL and then select the range A4:A8. On the HOME tab, in the Styles group, click Cell Styles, and then under Titles and Headings, click Heading 4.

 

I am attempting to copy and drag a formula from one cell across two other cells.  I can't drag it just the two cells.  I can drag it out to about 5 or 6 cells, or up and down any number, but I can't get it to go to just the two cells I need it in

Unsure why this happens to some students. In case you encounter this problem, please contact TA or Sherry Feng to get your score back.

 

Q #8. The fill handle function isn't working properly.

Try using copy and paste and not the fill handle instead. Let us know if you still can’t get it to work

Excel Chp.2

Q #5. 1 ) In cell I5, enter a formula that divides the Total Enrolled for the class Advanced Music by the Total Enrolled for the quarter (in cell F20). Set F20 as an absolute cell reference in the formula

1. Click cell I5, and then type (in the cell or in the Formula Bar) =F5/$F$20

 2. Press ENTER

Excel Chp.3

Q #3  1)  In the Online Sales sheet, clear the contents from cells A1 and B1.

For above question, the  “Clear format” option is not available to me in the drop down menu as shown in the video for some reason, what shall I do?

1. Select cell A1 and B1 

2. In the "Home" tab, under "Style" group, I clicked on "Cell Styles", then I clicked "Normal"

 

Q#8: upon reaching question 8, I suddenly received an error message saying that the question cannot launch and that I could try again or skip to the next question

If you encounter this, send an email to TA/instructor, we will check and give you back the points.

Excel Chp.4

Q # 3: 3 )   Format the result in cell K8 with the Number format. Decrease the number of decimal places to show a whole number only. Copy the first Payoff Year formula in cell K8 to the range K9:K12.

1.  With cell K8 selected, click the HOME tab.

2.  In the Number group, click the Number Format arrow, and then click Number.

3.  In the Number group, click Decrease Decimal.

4.  Click Decrease Decimal again.

5.  Double-click the fill handle in cell K8.

Word Chp.1

Q #2: In the third row, in the first cell, type EXPERIENCE and press TAB. In the second cell of the third row, type Instructional Lab Assistant….

I kept receiving “Incorrect” message, why?

Check your spelling of the entering words, even a small typo can result in an “Incorrect” message showing on screen.

Word Chp.2

Q #3 2)    Select the three subheadings: The Internship Program, Requirements, and Introduction to Upcoming Internships and then change the spacing before to 12 pt. for the three selected subheadings.

 

Select the subheading The Internship Program. Scroll the document. Hold down CTRL and select the subheading Requirements. Scroll the document. Hold down CTRL and select the subheading Introduction to Upcoming Internships. On the PAGE LAYOUT tab, in the Paragraph group, under Spacing, click the Before spin box up arrow.

 On the PAGE LAYOUT tab, in the Paragraph group, under Spacing, click the Before spin box up arrow.

 

Q #5 1)    Add the File Name to the footer of the document

Click the INSERT tab.  In the Header & Footer group, click Footer, and then click Edit Footer.

On the HEADER & FOOTER TOOLS DESIGN tab, in the Insert group, click Document Info and then click File Name

Word Chp.3

Q #5 2)    With the bulleted list still selected, add a 6-inch right tab stop with a dot leader and clear the 4-inch left tab stop.

Click the PAGE LAYOUT tab, and in the Paragraph group, click the Paragraph Dialog Box Launcher (or click the HOME tab, click the Line Spacing button, and then click Line Spacing Options). Alternatively, on the HOME tab, in the Paragraph group, click the Paragraph Dialog Box Launcher. Alternatively, double-click any indent marker on the horizontal ruler.

 In the Paragraph dialog box, click the Tabs button.

 With 4 selected under Tab stop position, click the Clear (or Clear All) button.

 In the Tab stop position box, type 6 (or 6" or 6.0 or 6.0" or 6.00 or 6.00").

 Under Alignment, click Right.

 Under Leader, click 2.

 Click the Set button and then click the OK button. Alternatively, click the OK button.

Word Chp.4

Q #2 2 ) Select the first bulleted line, Aperture/F-Stop, on page 2. Format it with a solid round black bullet. Click the Bullets arrow, and then click Define New Bullet. Click Font, and change the font color to Plum, Accent 1, Darker 25%.

1. Scroll to the bottom of page 2. Select the first bulleted line, Aperture/F-Stop. On the HOME tab, in the Paragraph group, click the Bullets arrow, and then click the solid round black bullet.

 2. In the Paragraph group, click the Bullets arrow, and then click Define New Bullet.

 3. In the Define New Bullet dialog box, click Font.

 4. In the Font dialog box, click the Font color arrow, and then click Plum, Accent 1, Darker 25%.

 5. Click OK.

 6. In the Define New Bullet dialog box, click OK.

 

Q #2 3 ) Create a new paragraph style named Dobry Bullets based on the formatting of the first bulleted item. Apply the Dobry Bullets style to the remaining ten bulleted paragraphs n the accomplishments list.

1. With the insertion point in the first bulleted line, 169 received undergraduate degrees, on the HOME tab, in the Styles group, click the Styles Dialog Box Launcher.

 2. In the Styles pane, click New Style.

 3. In the Create New Style from Formatting dialog box type Dobry Bullets in the Name box.

 4. Click OK.

5. Select the ten bulleted paragraphs below 169 received undergraduate degrees. In the Styles pane, click Dobry Bullets.

 6. In the Style pane, click Close (X).

 

Q #4: 1) Change the Height of the SmartArt to 1.75 and change the Width to 6.5.

1. Click the SmartArt border. On the SMARTART TOOLS FORMAT tab, in the Size group, click Size.

2. Click in the Shape Height box, and then type 1.75. Press ENTER.

3. In the Size group, click Size. Click in the Shape Width box, type 6.5 and then press ENTER.