Description
- Read Access Chapters 1, 2, 3, and 4 in your e-text and complete the Try-It Exercises.
- Complete and submit the Projects the Microsoft Access chapters 1, 2, 3 and 4 in SIMNet
- Complete the Pre-Post exercises for Access 2016 Chapters 1,2,3 and 4 in SIMNet
- Prepare for and take the Microsoft Access Exam in SIMNet.
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
It's done. Ch...
Completion Status:
100%
Review
Review
Anonymous
Really helped me to better understand my coursework. Super recommended.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
Concord University Introduction to Computer Programming Lab Report
Assignment #9The parts below describe a single large program so you will only need to turn in one file for this assignment ...
Concord University Introduction to Computer Programming Lab Report
Assignment #9The parts below describe a single large program so you will only need to turn in one file for this assignment. I suggest that you complete each part and save each part for your own use in the event that something does not work. Also, the programs below utilize a series of external data files - click here to download these files as a ZIP archive.Part 1You just finished administering the final exam for all of the students in the "Introduction to Computer Programming" classes this semester. The exam was a 25 question multiple choice exam, and it is your job to grade the exams. You have all of the scores stored in a series of text files (click here to download these files).To begin, download the data files and store them in a folder on your computer. Then create a new Python program inside of this folder called "YourName_Assignment09.py". Make sure your source code file is inside of the same folder as the data files you just downloaded!Next, write a program that lets the user type in the name of a file. Attempt to open the supplied file for read access. If the file exists you can print out a confirmation message. If the file doesn't exist you should tell the user that the file cannot be found. Hint: use a try/except block to do this (don't just use a series of "if" statements - we want this program to be as "generic" as possible).You will not get credit for this part of the program if you write something like the following to identify valid data files:filename = input("Enter a filename: ")
if filename == "class1":
# open class1.txt
elif filename == "class2":
# open class2.txt
else:
print ("Sorry, I can't find this filename")Here's a sample running of the program:Enter a class file to grade (i.e. class1 for class1.txt): foobar
File cannot be found.
Enter a class file to grade (i.e. class1 for class1.txt): class1
Successfully opened class1.txtundefinedPart 2Next, you are going to write a program to grade the exams for a given section. The exam was a 25 question multiple choice exam. Here are the answers to the exam:answerkey = "B,A,D,D,C,B,D,A,C,C,D,B,A,B,A,C,B,D,A,C,A,A,B,D,D"Each data file contains a series of student responses in the following format:N12345678,B,A,D,D,C,B,D,A,C,C,D,B,A,B,A,C,B,D,A,C,A,A,B,D,DorN12345678,B,,D,,C,B,,A,C,C,,B,A,B,A,,,,A,C,A,A,B,D,The first number is the student’s ID number. The following 25 letters are the student responses to the exam. If there is no letter following a comma, this means the student skipped answering the question.Note that some lines of data may be corrupted! For example, this line of data does not have enough answers:N12345678,B,A,D,D,C,B... and this line of data has too many answers:N12345678,B,A,D,D,C,B,D,A,C,C,D,B,A,B,A,C,B,D,A,C,A,A,B,D,D,A,B,C,D,EIf you encounter a line of data that is un-usable you should make a note of it and not use the line in your calculations. Report to the user at the end of the program how many unusable lines of data you found.Your program should open up the file specified by the user and read in the data. It should then compute the following:The total # of students represented in the fileThe total # of invalid lines of data found in the fileThe grade for each student. This can be done by comparing the student's answers to the answer key above. Scores can be computed using the following rubric:+4 points for every right answer0 points for every skipped answer-1 points for every incorrect answerThe highest scoreThe lowest scoreThe average score (mean)Here's a sample running of your program:Enter a class file to grade (i.e. class1 for class1.txt): class1
Successfully opened class1.txt
Grade Summary:
Total students: 20
Unusable lines in the file: 0
Highest score: 91
Lowest score: 59
Mean score: 75.60Hints: Use the "split" method to split apart the data from the file. You may need to use this method a few times along with a loop or two. Hint: think about the order in which you need to split your items. For example, your file is organized so that one student's record occupies an entire line in the file. Splitting first on the line break will isolate each student's data. Then you will need to further split each item based on the separator character to pull out the responses for each student.Hint: once you've scored the students you should use a list to store indivdual student scores - you can then compute statistics after you've examined every student in the file.Solutions: you can view the expected solutions for all of the data files by clicking here. Note that this solution file also includes the "median", "mode" and "range" - you will be computing these values in the next part of the assignment.undefinedPart 3Next, have your program compute the following based on each data file:The median value (Sort the grades in ascending order. If the # of students is odd you can take the middle of all the grades (i.e. [0, 50, 100] - the median is 50). If the # of students is even you can compute the median by averaging the middle two values (i.e. [0, 50, 60, 100] - the median is 55)The mode value (the grade that occurs most frequently - i.e. [0, 50, 50, 100] - the mode is 50). Hint: you will probably want to create two new lists to do this. One new list canhold the UNIQUE test scores found and the other can hold the # of times that score has been seen. For example:
unique = [100,90,80]
seen = [1,5,3]Hint: use the "in" operator, the "append" method and the max function to help you solve this problem!The range (the difference between the largest and smallest grade in the set)Here's a sample running of your program for class1:Enter a class file to grade (i.e. class1 for class1.txt): class1
Successfully opened class1.txt
Grade Summary:
Total students: 20
Highest score: 91
Lowest score: 59
Mean score: 75.60
Median score: 73.0
Mode: 73
Range: 32undefinedPart 4Finally, have your program generate a "results" file that contains the detailed results for each student in your class. Each line of this file should contain the student’s ID number, a comma, and then their grade truncated to 2 decimal points. You should name this file based on the original filename supplied -- for example, if the user wants to analyze "class1.txt" you should store the results in a file named "class1_grades.txt"Here's a sample of what "class1_grades.txt" should look like. You can download all result files by clicking here.N00000001,59.00
N00000002,70.00
N00000003,84.00
N00000004,73.00
N00000005,83.00
N00000006,66.00
N00000007,88.00
N00000008,67.00
N00000009,86.00
N00000010,73.00
N00000011,86.00
N00000012,73.00
N00000013,73.00
N00000014,78.00
N00000015,72.00
N00000016,91.00
N00000017,66.00
N00000018,78.00
N00000019,78.00
N00000020,68.00undefinedPart 5As you can see, some students didn't do very well on their exams. Add a feature to your program that lets the user "curve" the test scores so that they are adjusted in such a way that the mean score is increased to a desired level. Only accept positive curve values. Then re-generate the "class_grades.txt" file to include this information.You can simply add the curve value to each student's score (i.e. if the user is curving the exam from a 75 to an 80 you would add +5 to each student score).Here's a sample running of your program:Enter a class file to grade (i.e. class1 for class1.txt): class1
Successfully opened class1.txt
Grade Summary:
Total students: 20
Unusable lines in the file: 0
Highest score: 91
Lowest score: 59
Mean score: 75.60
Median score: 73.0
Mode: 73
Range: 32
Would you like to curve the exam? 'y' or 'n': y
Enter a desired mean (i.e. 75.0 to raise the mean score to 75.0): -5
Invalid curve, try again.
Enter a desired mean (i.e. 75.0 to raise the mean score to 75.0): 80.0
Done! Check your grade file!And here's a copy of the grade file that should be generated for class1 with a curved score of 80.0 - note the 3rd column contains the curved score (the 1st and 2nd columns are the same):N00000001,59,64
N00000002,70,75
N00000003,84,89
N00000004,73,78
N00000005,83,88
N00000006,66,71
N00000007,88,93
N00000008,67,72
N00000009,86,91
N00000010,73,78
N00000011,86,91
N00000012,73,78
N00000013,73,78
N00000014,78,83
N00000015,72,77
N00000016,91,96
N00000017,66,71
N00000018,78,83
N00000019,78,83
N00000020,68,73
Horace Mann School Html CSS Responsive Web Design Question
HTML homework: Use text editor (notepad++, etc. ) to create 1 basic html page, do two Web Site Design Evaluations, crea ...
Horace Mann School Html CSS Responsive Web Design Question
HTML homework: Use text editor (notepad++, etc. ) to create 1 basic html page, do two Web Site Design Evaluations, create 2 basic html pages with css
when opening a file, the “wt” parameter indicated that we, Programming Essentials quiz help
Question 1 when opening a file, the “wt” parameter indicated that we:
want to append to the end ...
when opening a file, the “wt” parameter indicated that we, Programming Essentials quiz help
Question 1 when opening a file, the “wt” parameter indicated that we:
want to append to the end of the text file.want to write data to a text file.that we are opening a binrary file.that we are reading from a text file. 1 points Question 2 when opening a file, the “rt” parameter indicated that we:
want to append to the end of the text file.want to write data to a text file.that we are opening a binary file.that we are reading from a text file. 1 points Question 3 when using the ‘with’ keyword and opening a file, we must remember to close the file once we are done. True False 1 points Question 4 the import command can be used to bring into your Python program, additional code contained in other Python code files. True False 1 points Question 5 Which keyword is used in conjunction with the import command to selectively import objects from an external python code file?
fromforincludeeval 1 points Question 6 You can set an infinite loop using the command: while True: True False 1 points Question 7 Where can you learn more about pre-built python modules that can be used in your python program?
Python Reference websitePython community sitePython Library Reference websiteAll of the above 1 points Question 8 An important component to becoming an effective programmer is:
Existing knowledgeResearchReinventing the wheelHaving a good IDE 1 points Question 9 We can open and access a text file directly and do not have to create a file object. True False 1 points Question 10 Accessing a text file requires the text file to be created before we can open the file using the “wt” parameter. True False
8 pages
Java Questions
1. Design a module named getNumber, which uses a reference parameter variable to accept an Integer argument. The module sh ...
Java Questions
1. Design a module named getNumber, which uses a reference parameter variable to accept an Integer argument. The module should prompt the user to ...
Java short programs coding , programming homework help
Q1) Write a method named area that accepts a circle's radius as a parameter and returns its area. The area of a circle is ...
Java short programs coding , programming homework help
Q1) Write a method named area that accepts a circle's radius as a parameter and returns its area. The area of a circle is defined as: or You may wish to use the constant Math.PI in your solution. Call the method in main to test it and display the area to the screen. Q2) Write a method named bottlesOnWall that accepts an integer as a parameter and prints "XX Bottles on the wall" with that many verses, each time counting down from XX till it becomes 1. So for instance if the integer is 5, then the output should be: 5 Bottles on the wall 4 Bottles on the wall 3 Bottles on the wall 2 Bottles on the wall 1 Bottles on the wall Assume that the integer passed to the method is always positive. Call the method in main to test it. Q3) Write a program that asks the user to enter five test scores. The program should display a letter grade for each score and the average test score. Write the following methods in the program: calcAverage – This method should accept five test scores as arguments and return the average of the scores. determineGrade – This method should accept a test score as an argument and return a letter grade for the score, based on the following grading scale: Score: Letter Grade: 90-100 A 80-89 B 70-79 C 60-69 D Below 60 F
Similar Content
SQL for data management
This assignment requires you to take your extended design from Week 4 IP and add proper indexes, a function, and a stored ...
cop4530 data structures
everything provided in the pdf attached...
UCLA Java Question
Note: Creating multiple Scanner objects for the same input stream yields unexpected behavior. Thus, good practice is to us...
Brookhaven College Creating a Loop Display Java Program
I have attached all the instruction which is including requirement in the file. Read the requirement carefully...
University of Phoenix Information Technology Discussion Responses
1. Practices of information technology governance is Information Technology (IT), that governs the establishment of struct...
UCLA Python Worksheet
Please use the syntax as simple as possible.All of the requirements are in the pdf attached.Please do it with Spyder.I kno...
It401 Assignment 2 Questions 1
This Assignment must be submitted on Blackboard (WORD format only) via the allocated You are advised to make your work cle...
Cst333 Hw5
Here is a Datalog query that uses the relation Flights(Airline, Departure, Arrival) as an input Reach(X,Y) Flights(_,X...
Second
1. Use the mysqldump.exe command line tool to backup the data in your volunteer database. ○ To access the mysqldump.exe ...
Related Tags
Book Guides
Flowers For Algernon
by Alice Walker
The Hobbit
by J. R. R. Tolkien
Things That Matter
by Charles Krauthammer
Catch-22
by Joseph Heller
Twelve Years A Slave
by Solomon Northrup
Fools Crow
by James Welch
2001 A Space Odyssey
by Arthur Clarke
Harry Potter and the Sorcerers Stone
by J. K. Rowling
The Visible Filth
by Nathan Ballingrud
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
Concord University Introduction to Computer Programming Lab Report
Assignment #9The parts below describe a single large program so you will only need to turn in one file for this assignment ...
Concord University Introduction to Computer Programming Lab Report
Assignment #9The parts below describe a single large program so you will only need to turn in one file for this assignment. I suggest that you complete each part and save each part for your own use in the event that something does not work. Also, the programs below utilize a series of external data files - click here to download these files as a ZIP archive.Part 1You just finished administering the final exam for all of the students in the "Introduction to Computer Programming" classes this semester. The exam was a 25 question multiple choice exam, and it is your job to grade the exams. You have all of the scores stored in a series of text files (click here to download these files).To begin, download the data files and store them in a folder on your computer. Then create a new Python program inside of this folder called "YourName_Assignment09.py". Make sure your source code file is inside of the same folder as the data files you just downloaded!Next, write a program that lets the user type in the name of a file. Attempt to open the supplied file for read access. If the file exists you can print out a confirmation message. If the file doesn't exist you should tell the user that the file cannot be found. Hint: use a try/except block to do this (don't just use a series of "if" statements - we want this program to be as "generic" as possible).You will not get credit for this part of the program if you write something like the following to identify valid data files:filename = input("Enter a filename: ")
if filename == "class1":
# open class1.txt
elif filename == "class2":
# open class2.txt
else:
print ("Sorry, I can't find this filename")Here's a sample running of the program:Enter a class file to grade (i.e. class1 for class1.txt): foobar
File cannot be found.
Enter a class file to grade (i.e. class1 for class1.txt): class1
Successfully opened class1.txtundefinedPart 2Next, you are going to write a program to grade the exams for a given section. The exam was a 25 question multiple choice exam. Here are the answers to the exam:answerkey = "B,A,D,D,C,B,D,A,C,C,D,B,A,B,A,C,B,D,A,C,A,A,B,D,D"Each data file contains a series of student responses in the following format:N12345678,B,A,D,D,C,B,D,A,C,C,D,B,A,B,A,C,B,D,A,C,A,A,B,D,DorN12345678,B,,D,,C,B,,A,C,C,,B,A,B,A,,,,A,C,A,A,B,D,The first number is the student’s ID number. The following 25 letters are the student responses to the exam. If there is no letter following a comma, this means the student skipped answering the question.Note that some lines of data may be corrupted! For example, this line of data does not have enough answers:N12345678,B,A,D,D,C,B... and this line of data has too many answers:N12345678,B,A,D,D,C,B,D,A,C,C,D,B,A,B,A,C,B,D,A,C,A,A,B,D,D,A,B,C,D,EIf you encounter a line of data that is un-usable you should make a note of it and not use the line in your calculations. Report to the user at the end of the program how many unusable lines of data you found.Your program should open up the file specified by the user and read in the data. It should then compute the following:The total # of students represented in the fileThe total # of invalid lines of data found in the fileThe grade for each student. This can be done by comparing the student's answers to the answer key above. Scores can be computed using the following rubric:+4 points for every right answer0 points for every skipped answer-1 points for every incorrect answerThe highest scoreThe lowest scoreThe average score (mean)Here's a sample running of your program:Enter a class file to grade (i.e. class1 for class1.txt): class1
Successfully opened class1.txt
Grade Summary:
Total students: 20
Unusable lines in the file: 0
Highest score: 91
Lowest score: 59
Mean score: 75.60Hints: Use the "split" method to split apart the data from the file. You may need to use this method a few times along with a loop or two. Hint: think about the order in which you need to split your items. For example, your file is organized so that one student's record occupies an entire line in the file. Splitting first on the line break will isolate each student's data. Then you will need to further split each item based on the separator character to pull out the responses for each student.Hint: once you've scored the students you should use a list to store indivdual student scores - you can then compute statistics after you've examined every student in the file.Solutions: you can view the expected solutions for all of the data files by clicking here. Note that this solution file also includes the "median", "mode" and "range" - you will be computing these values in the next part of the assignment.undefinedPart 3Next, have your program compute the following based on each data file:The median value (Sort the grades in ascending order. If the # of students is odd you can take the middle of all the grades (i.e. [0, 50, 100] - the median is 50). If the # of students is even you can compute the median by averaging the middle two values (i.e. [0, 50, 60, 100] - the median is 55)The mode value (the grade that occurs most frequently - i.e. [0, 50, 50, 100] - the mode is 50). Hint: you will probably want to create two new lists to do this. One new list canhold the UNIQUE test scores found and the other can hold the # of times that score has been seen. For example:
unique = [100,90,80]
seen = [1,5,3]Hint: use the "in" operator, the "append" method and the max function to help you solve this problem!The range (the difference between the largest and smallest grade in the set)Here's a sample running of your program for class1:Enter a class file to grade (i.e. class1 for class1.txt): class1
Successfully opened class1.txt
Grade Summary:
Total students: 20
Highest score: 91
Lowest score: 59
Mean score: 75.60
Median score: 73.0
Mode: 73
Range: 32undefinedPart 4Finally, have your program generate a "results" file that contains the detailed results for each student in your class. Each line of this file should contain the student’s ID number, a comma, and then their grade truncated to 2 decimal points. You should name this file based on the original filename supplied -- for example, if the user wants to analyze "class1.txt" you should store the results in a file named "class1_grades.txt"Here's a sample of what "class1_grades.txt" should look like. You can download all result files by clicking here.N00000001,59.00
N00000002,70.00
N00000003,84.00
N00000004,73.00
N00000005,83.00
N00000006,66.00
N00000007,88.00
N00000008,67.00
N00000009,86.00
N00000010,73.00
N00000011,86.00
N00000012,73.00
N00000013,73.00
N00000014,78.00
N00000015,72.00
N00000016,91.00
N00000017,66.00
N00000018,78.00
N00000019,78.00
N00000020,68.00undefinedPart 5As you can see, some students didn't do very well on their exams. Add a feature to your program that lets the user "curve" the test scores so that they are adjusted in such a way that the mean score is increased to a desired level. Only accept positive curve values. Then re-generate the "class_grades.txt" file to include this information.You can simply add the curve value to each student's score (i.e. if the user is curving the exam from a 75 to an 80 you would add +5 to each student score).Here's a sample running of your program:Enter a class file to grade (i.e. class1 for class1.txt): class1
Successfully opened class1.txt
Grade Summary:
Total students: 20
Unusable lines in the file: 0
Highest score: 91
Lowest score: 59
Mean score: 75.60
Median score: 73.0
Mode: 73
Range: 32
Would you like to curve the exam? 'y' or 'n': y
Enter a desired mean (i.e. 75.0 to raise the mean score to 75.0): -5
Invalid curve, try again.
Enter a desired mean (i.e. 75.0 to raise the mean score to 75.0): 80.0
Done! Check your grade file!And here's a copy of the grade file that should be generated for class1 with a curved score of 80.0 - note the 3rd column contains the curved score (the 1st and 2nd columns are the same):N00000001,59,64
N00000002,70,75
N00000003,84,89
N00000004,73,78
N00000005,83,88
N00000006,66,71
N00000007,88,93
N00000008,67,72
N00000009,86,91
N00000010,73,78
N00000011,86,91
N00000012,73,78
N00000013,73,78
N00000014,78,83
N00000015,72,77
N00000016,91,96
N00000017,66,71
N00000018,78,83
N00000019,78,83
N00000020,68,73
Horace Mann School Html CSS Responsive Web Design Question
HTML homework: Use text editor (notepad++, etc. ) to create 1 basic html page, do two Web Site Design Evaluations, crea ...
Horace Mann School Html CSS Responsive Web Design Question
HTML homework: Use text editor (notepad++, etc. ) to create 1 basic html page, do two Web Site Design Evaluations, create 2 basic html pages with css
when opening a file, the “wt” parameter indicated that we, Programming Essentials quiz help
Question 1 when opening a file, the “wt” parameter indicated that we:
want to append to the end ...
when opening a file, the “wt” parameter indicated that we, Programming Essentials quiz help
Question 1 when opening a file, the “wt” parameter indicated that we:
want to append to the end of the text file.want to write data to a text file.that we are opening a binrary file.that we are reading from a text file. 1 points Question 2 when opening a file, the “rt” parameter indicated that we:
want to append to the end of the text file.want to write data to a text file.that we are opening a binary file.that we are reading from a text file. 1 points Question 3 when using the ‘with’ keyword and opening a file, we must remember to close the file once we are done. True False 1 points Question 4 the import command can be used to bring into your Python program, additional code contained in other Python code files. True False 1 points Question 5 Which keyword is used in conjunction with the import command to selectively import objects from an external python code file?
fromforincludeeval 1 points Question 6 You can set an infinite loop using the command: while True: True False 1 points Question 7 Where can you learn more about pre-built python modules that can be used in your python program?
Python Reference websitePython community sitePython Library Reference websiteAll of the above 1 points Question 8 An important component to becoming an effective programmer is:
Existing knowledgeResearchReinventing the wheelHaving a good IDE 1 points Question 9 We can open and access a text file directly and do not have to create a file object. True False 1 points Question 10 Accessing a text file requires the text file to be created before we can open the file using the “wt” parameter. True False
8 pages
Java Questions
1. Design a module named getNumber, which uses a reference parameter variable to accept an Integer argument. The module sh ...
Java Questions
1. Design a module named getNumber, which uses a reference parameter variable to accept an Integer argument. The module should prompt the user to ...
Java short programs coding , programming homework help
Q1) Write a method named area that accepts a circle's radius as a parameter and returns its area. The area of a circle is ...
Java short programs coding , programming homework help
Q1) Write a method named area that accepts a circle's radius as a parameter and returns its area. The area of a circle is defined as: or You may wish to use the constant Math.PI in your solution. Call the method in main to test it and display the area to the screen. Q2) Write a method named bottlesOnWall that accepts an integer as a parameter and prints "XX Bottles on the wall" with that many verses, each time counting down from XX till it becomes 1. So for instance if the integer is 5, then the output should be: 5 Bottles on the wall 4 Bottles on the wall 3 Bottles on the wall 2 Bottles on the wall 1 Bottles on the wall Assume that the integer passed to the method is always positive. Call the method in main to test it. Q3) Write a program that asks the user to enter five test scores. The program should display a letter grade for each score and the average test score. Write the following methods in the program: calcAverage – This method should accept five test scores as arguments and return the average of the scores. determineGrade – This method should accept a test score as an argument and return a letter grade for the score, based on the following grading scale: Score: Letter Grade: 90-100 A 80-89 B 70-79 C 60-69 D Below 60 F
Earn money selling
your Study Documents