Those with a PC with MS Office with Access complete this section. MacOS users or

Those with a PC with MS Office with Access complete this section. MacOS users or PC Users without MS Access see below.
Background Resources(PC or Mac)
Database Overview PowerPoint

Instructions/Starter File (MS Access)
AccessCS-InClass.pdf
LooneyTunes-InClass.xlsx (Right click and Save As to download the starter Excel file)
Instructional/Helper Videos (MS Access)

Submit the following files (MS Access)
(1) Completed Excel file
(2) Access Database (.accdb) file. NOTE – Close Access before uploading
(3) PDF export of the report
Rubric (MS Access)
LooneyTunes-GradeSheet.xlsx
=====================================================================================
MacOS users or PC Users without MS Access complete per below
NOTE – For MacOS students, if you get a Java error, please see below guidance at the bottom of the page.
Instructions/Starter File (Libre/OpenOffice Base)
LibreBase-InClass.pdf
ActionsDownload LibreBase-InClass.pdf (Mac OS Users – There are workarounds on steps 15 and 17)
LooneyTunes-InClass.xlsxDownload LooneyTunes-InClass.xlsxDownload LooneyTunes-InClass.xlsx
LooneyTunes-GradeSheet-Libre.xlsx Download LooneyTunes-GradeSheet.xlsx Download LooneyTunes-GradeSheet-Libre.xlsx Download LooneyTunes-GradeSheet.xlsxInstructional/Helper Videos (Libre/OpenOffice Base)
Normalizing Excel for import into LibreOffice Base
Relationships and QueriesLinks to an external site.
Creating Reports and Exporting
Submit the following files (Libre/OpenOffice Base)
(1) Excel file
(2) LibreOffice or OpenOffice Base file (close LibreOfficeBase/OpenOfficeBase before uploading)
(3) PDF export of the report
Rubric (Libre/OpenOffice Base)
LooneyTunes-GradeSheet-Libre.xlsxDownload LooneyTunes-GradeSheet-Libre.xlsx
Links to an external site.
MAC OS Users Troubleshooting – Do these in the following order
Go to this siteLinks to an external site. to download Java for Mac OS and then run LibreOffice.
Launch LibreOffice. Navigate to the preferences window (“LibreOffice” menu in the top left corner of the screen, then ‘Preferences’). Select ‘Advanced’ from the list of options on the left hand side. This should display the preference options for Java. If the installation of the JDK has gone well, it should already have a tick in the option for ‘Use a Java runtime environment’. In the pane below that, a radio button should indicate that the vendor is Oracle Corporation
If there is no Java package selected, you can add it manually. Click on the ‘Add’ button on the right hand side of the preference window. A normal Mac OS file dialogue box will open. Using that, navigate to the top of your Mac’s hard disk. This should list the following folders: Applications, Library, System, Users. Select ‘Library’. In the Library folder select ‘Java’, then ‘JavaVirtualMachines’. Within that, select the most recent (probably only) version of the JRE. Then, within that ‘Contents’, then ‘Home’. Then press the ‘Open’ button on the MacOS dialogue box to select that as the location.
If this does not work, please try OpenOffice in lieu of LibreOffice. You can download hereLinks to an external site.. Since OpenOffice is not digitally signed, you will need to right click, then select Open. The instructions for the table imports have a few notes for Mac OS (steps 15 and 17), but otherwise the instructions are the same for LibreOffice and OpenOffice. NOTE – The screens are slightly different between LIbreOffice and OpenOffice.