{"id":"https://openalex.org/W7208826862","doi":"https://doi.org/10.31326/sistek.v8i1.2671","title":"Perancangan Sistem Pendaftaran Ekstrakurikuler Berbasis Microsoft Excel Menggunakan Fitur VLOOKUP dan Pivot Table (Studi Kasus: SMPN 6 Babelan)","display_name":"Perancangan Sistem Pendaftaran Ekstrakurikuler Berbasis Microsoft Excel Menggunakan Fitur VLOOKUP dan Pivot Table (Studi Kasus: SMPN 6 Babelan)","alternate_titles":[],"publication_year":2026,"publication_date":"2026-03-03","ids":{"openalex":"https://openalex.org/W7208826862","doi":"https://doi.org/10.31326/sistek.v8i1.2671"},"language":"id","primary_location":{"id":"doi:10.31326/sistek.v8i1.2671","doi":"https://doi.org/10.31326/sistek.v8i1.2671","is_oa":true,"landing_page_url":"https://doi.org/10.31326/sistek.v8i1.2671","pdf_url":"https://ojs.trilogi.ac.id/index.php/SISTEK/article/download/2671/pdf","source":{"id":"https://openalex.org/S4210219371","display_name":"Jurnal Sistem Informasi dan Sains Teknologi","issn_l":"2684-8260","issn":["2684-8260"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I4210137653","host_organization_name":"Trilogi University","host_organization_lineage":["https://openalex.org/I4210137653"],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Jurnal Sistem Informasi dan Sains Teknologi","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W7208826862"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://ojs.trilogi.ac.id/index.php/SISTEK/article/download/2671/pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5150298270","display_name":"Atika Wigunastuti","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Atika Wigunastuti","raw_affiliation_strings":["SEKOLAH TINGGI ILMU EKONOMI GANESHA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SEKOLAH TINGGI ILMU EKONOMI GANESHA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5150211265","display_name":"Eka Az Zahrah Nurul Azizah","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Eka Az Zahrah Nurul Azizah","raw_affiliation_strings":["SEKOLAH TINGGI ILMU EKONOMI GANESHA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SEKOLAH TINGGI ILMU EKONOMI GANESHA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5106392839","display_name":"Syafran Nurrahman","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Syafran Nurrahman","raw_affiliation_strings":["SEKOLAH TINGGI ILMU EKONOMI GANESHA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SEKOLAH TINGGI ILMU EKONOMI GANESHA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5128438283","display_name":"- U'um Umayah","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Uum Umayah","raw_affiliation_strings":["SEKOLAH TINGGI ILMU EKONOMI GANESHA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SEKOLAH TINGGI ILMU EKONOMI GANESHA","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5017438428","display_name":"Yuniarti Yuniarti","orcid":"https://orcid.org/0000-0002-6689-2916","observed_orcids":["https://orcid.org/0000-0002-6689-2916","https://orcid.org/0009-0003-0131-5231"]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Yuniarti Yuniarti","raw_affiliation_strings":["SEKOLAH TINGGI ILMU EKONOMI GANESHA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SEKOLAH TINGGI ILMU EKONOMI GANESHA","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":5.7845,"has_fulltext":true,"cited_by_count":2,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.94125221,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":96},"biblio":{"volume":"8","issue":"1","first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11734","display_name":"Decision Support System Applications","score":0.5400000214576721,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11734","display_name":"Decision Support System Applications","score":0.5400000214576721,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T13681","display_name":"Engineering and Information Technology","score":0.42750000953674316,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.026100000366568565,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/microsoft-excel","display_name":"Microsoft Excel","score":0.9259999990463257},{"id":"https://openalex.org/keywords/vlookup","display_name":"VLOOKUP","score":0.996999979019165},{"id":"https://openalex.org/keywords/pivot-tables","display_name":"pivot tables","score":0.9290000200271606},{"id":"https://openalex.org/keywords/school-management","display_name":"school management","score":0.75},{"id":"https://openalex.org/keywords/junior-high-school","display_name":"junior high school","score":0.7110000252723694},{"id":"https://openalex.org/keywords/data-reconciliation","display_name":"data reconciliation","score":0.4740000069141388},{"id":"https://openalex.org/keywords/data-lookup","display_name":"data lookup","score":0.34599998593330383}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6218000054359436},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.5049999952316284},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.3765999972820282},{"id":"https://openalex.org/C15708023","wikidata":"https://www.wikidata.org/wiki/Q80083","display_name":"Humanities","level":1,"score":0.3598000109195709},{"id":"https://openalex.org/C92209122","wikidata":"https://www.wikidata.org/wiki/Q16937537","display_name":"Informatics engineering","level":2,"score":0.21469999849796295},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.1784999966621399},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.1581999957561493},{"id":"https://openalex.org/C3019730874","wikidata":"https://www.wikidata.org/wiki/Q11272","display_name":"Microsoft excel","level":2,"score":0.1509999930858612},{"id":"https://openalex.org/C121684516","wikidata":"https://www.wikidata.org/wiki/Q7600677","display_name":"Computer graphics (images)","level":1,"score":0.14079999923706055},{"id":"https://openalex.org/C512115632","wikidata":"https://www.wikidata.org/wiki/Q134067","display_name":"Microsoft Visual Studio","level":3,"score":0.12530000507831573}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.31326/sistek.v8i1.2671","doi":"https://doi.org/10.31326/sistek.v8i1.2671","is_oa":true,"landing_page_url":"https://doi.org/10.31326/sistek.v8i1.2671","pdf_url":"https://ojs.trilogi.ac.id/index.php/SISTEK/article/download/2671/pdf","source":{"id":"https://openalex.org/S4210219371","display_name":"Jurnal Sistem Informasi dan Sains Teknologi","issn_l":"2684-8260","issn":["2684-8260"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I4210137653","host_organization_name":"Trilogi University","host_organization_lineage":["https://openalex.org/I4210137653"],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Jurnal Sistem Informasi dan Sains Teknologi","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.31326/sistek.v8i1.2671","doi":"https://doi.org/10.31326/sistek.v8i1.2671","is_oa":true,"landing_page_url":"https://doi.org/10.31326/sistek.v8i1.2671","pdf_url":"https://ojs.trilogi.ac.id/index.php/SISTEK/article/download/2671/pdf","source":{"id":"https://openalex.org/S4210219371","display_name":"Jurnal Sistem Informasi dan Sains Teknologi","issn_l":"2684-8260","issn":["2684-8260"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I4210137653","host_organization_name":"Trilogi University","host_organization_lineage":["https://openalex.org/I4210137653"],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Jurnal Sistem Informasi dan Sains Teknologi","raw_type":"journal-article"},"sustainable_development_goals":[{"score":0.9235000014305115,"display_name":"Quality education","id":"https://metadata.un.org/sdg/4"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W7208826862.pdf","grobid_xml":"https://content.openalex.org/works/W7208826862.grobid-xml"},"referenced_works_count":11,"referenced_works":["https://openalex.org/W3036950956","https://openalex.org/W3135338599","https://openalex.org/W3135848218","https://openalex.org/W4312216720","https://openalex.org/W4401152693","https://openalex.org/W4401170620","https://openalex.org/W4410267513","https://openalex.org/W4411502222","https://openalex.org/W7123577694","https://openalex.org/W7220160530","https://openalex.org/W7220337580"],"related_works":["https://openalex.org/W3120878222","https://openalex.org/W7220036946","https://openalex.org/W4405055645","https://openalex.org/W7162941690","https://openalex.org/W4402375531","https://openalex.org/W3163033778","https://openalex.org/W2972451725","https://openalex.org/W3046011975","https://openalex.org/W7119901314","https://openalex.org/W2899911099"],"abstract_inverted_index":{"ABSTRAKSMPN":[0],"6":[1],"Babelan":[2],"merupakan":[3],"salah":[4],"satu":[5],"Sekolah":[6],"Menengah":[7],"Pertama":[8],"Negeri":[9],"di":[10],"Kabupaten":[11],"Bekasi":[12],"yang":[13,24,81,103,137,142,157],"setiap":[14],"tahun":[15],"menyelenggarakan":[16],"pendaftaran":[17,23,59,102,125],"kegiatan":[18,134],"ekstrakurikuler":[19,60],"bagi":[20,155,165],"siswa.":[21],"Proses":[22],"berjalan":[25],"saat":[26],"ini":[27,52,149,178],"masih":[28,158],"dilakukan":[29],"secara":[30],"manual":[31,161],"sehingga":[32],"menimbulkan":[33],"berbagai":[34],"permasalahan,":[35],"seperti":[36],"ketidakteraturan":[37],"data,":[38,122],"kesalahan":[39,120],"pencatatan,":[40],"serta":[41,130,162],"kesulitan":[42],"dalam":[43,180],"pencarian":[44,127],"dan":[45,56,72,98,126,146,185],"rekapitulasi":[46,77],"data":[47,71,94,128,141],"untuk":[48,54],"keperluan":[49],"laporan.":[50],"Penelitian":[51,148,173],"bertujuan":[53],"merancang":[55],"mengimplementasikan":[57],"sistem":[58,101,111,160,167,177],"berbasis":[61,112,170,183,192],"Microsoft":[62,113,198],"Excel":[63,114],"dengan":[64,87,187],"memanfaatkan":[65],"fitur":[66],"VLOOKUP":[67],"sebagai":[68,75],"relasi":[69],"antar":[70],"Pivot":[73,201],"Table":[74],"alat":[76],"otomatis.":[78],"Metode":[79],"penelitian":[80,84,107],"digunakan":[82],"adalah":[83],"deskriptif":[85],"kualitatif":[86],"pendekatan":[88],"studi":[89],"kasus,":[90],"melalui":[91],"teknik":[92],"pengumpulan":[93],"berupa":[95],"observasi,":[96],"wawancara,":[97],"dokumentasi":[99],"terhadap":[100],"sedang":[104],"berjalan.":[105],"Hasil":[106],"menunjukkan":[108],"bahwa":[109],"penerapan":[110],"mampu":[115],"meningkatkan":[116],"efisiensi":[117],"kerja,":[118],"mengurangi":[119],"input":[121],"mempermudah":[123],"proses":[124],"siswa,":[129],"mempercepat":[131],"pembuatan":[132],"laporan":[133],"ekstrakurikuler.":[135],"Sistem":[136],"dirancang":[138],"juga":[139],"menghasilkan":[140],"lebih":[143],"rapi,":[144],"akurat,":[145],"terstruktur.":[147],"diharapkan":[150],"dapat":[151,175],"menjadi":[152,163],"solusi":[153],"praktis":[154],"sekolah":[156,169,189],"menggunakan":[159],"referensi":[164],"pengembangan":[166],"administrasi":[168],"teknologi":[171],"sederhana.":[172],"selanjutnya":[174],"mengembangkan":[176],"ke":[179],"bentuk":[181],"aplikasi":[182],"web,":[184],"mengintegrasikannya":[186],"database":[188],"atau":[190],"layanan":[191],"cloud.":[193],"Kata":[194],"Kunci:":[195],"Pendaftaran":[196],"Ekstrakulikuler,":[197],"Excel,":[199],"VLOOKUP,":[200],"Table.":[202]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W7208826862","counts_by_year":[{"year":2026,"cited_by_count":2}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2026-09-06T00:00:00"}
