Frequently asked questions and instructor notes
All our courses assume that each student has a personal computer to use during the class. Our hands-on approach to learning requires they do. This topic gives information on how to set up the classroom to teach this course. It includes minimum requirements for the students’ personal computers, setup information for the first time you teach the class, and setup information for each time that you teach after the first time you set up the classroom.
Student computer requirements
Each student’s personal computer should have:
· A keyboard and a mouse
· PC with a Pentium 75 MHz processor or higher
· Minimum 16 MB of RAM for Windows 98 computers
· Minimum 600 MB free hard-disk space
· CD-ROM drive
· SVGA monitor
· Printer driver required
· Internet access requirement if they will be downloading data files from www.courseilt.com
First-time setup instructions
The first time you teach this course, you will need to perform the following steps to set up each student computer.
1 Perform a typical setup of Windows 98 Second Edition according to the software manufacturer’s instructions.
2 Perform a custom setup of Office 2000.
3 In the Microsoft Office 2000: Selecting Features dialog box, click the plus box that appears to the left of Office Tools.
4 Select Run from My Computer option for the Visual Basic Help files and Microsoft Query.
5 Click the plus sign that appears to the left of the Office Assistant. Select the Genius list arrow and select Run from My Computer.
6 After installing Microsoft Office 2000, set the macro security level in Word, and Excel, to either Medium or Low. To do so, start the application whose security level you want to change. Choose Tools, Macro, Security. Select either the Medium or Low option button, then click the OK button.
7 To set up the Visual Basic environment, start either Word or Excel. Press Alt+F11 to open the Visual Basic Editor. Click Tools on the Standard menu, then click Options. Click the Editor tab on the Options dialog box, then check the following check boxes, if necessary: Auto Syntax Check, Require Variable Declaration, Auto List Members, Auto Quick Info, and Auto Data Tips. If necessary, clear Default to Full Module View. Click OK to close the Options dialog box, then press Alt+F11 to return to the application. Close the application without saving the document, workbook, or presentation.
8 Download the Student Data examples for the course. You can download the student data directly to student machines, to a central location on your own network, or to a disk. The student data examples contain text files with the codes used in the activities. If required you can ask students to copy the codes instead of entering them.
a Connect to www.courseilt.com/instructor_tools.html.
b Click the link for Microsoft Visual Basic for Applications to display a page of course listings, and then click the link for Microsoft VBA Programming.
c Click the link for downloading the data disk files, and follow the instructions that appear on your screen.
Setup instructions for every class
Every time you teach this course, you will need to perform the following steps to set up each student computer.
1 If necessary, reset any defaults that have been changed in previous classes.
2 Ensure that the macro security level in Word and Excel is set to either Medium or Low. To do so, start the application whose security level you want to change. Click Tools on the Standard menu bar, point to Macro, and then click Security. Click either the Medium or Low option button, then click the OK button.
3 To set up the Visual Basic environment, start either Word, Excel, or Access. Press Alt+F11 to open the Visual Basic Editor. Choose Tools, Options. Click the Editor tab on the Options dialog box, then select the following check boxes, if necessary: Auto Syntax Check, Require Variable Declaration, Auto List Members, Auto Quick Info, and Auto Data Tips. If necessary, deselect the Default to Full Module View check box. Click the OK button to close the Options dialog box, then press Alt+F11 to return to the application. Close the application without saving the document, workbook, presentation, or database.
4 Delete the contents of the Student Data folder, if necessary. (If this is the first time you are teaching the course, create a folder called Student Data at the root of the hard drive.)
5 Copy the data files for the course to the Student Data folder (see the instructions in the preceding section about how to download the data files).
Topic B: Frequently asked questions
There are no frequently asked questions for this course at this time
Topic C: Course notes
The original data for this course is missing a file for Unit 5. This file is used in step 1 of the Independent Practice Activity. The name of the file is T5-EX-E2.xls. If the disk in the back of you book is missing the file, you can download the data that includes this file from www.courseilt.com/instructor_tools.html by following the directions provided in the setup instructions for this course.
Topic D: Additional information
There is no additional information for this course at this time